The objective of this documentation is not to allow to recreate from scratch the object but to explain everything that is not obvious by looking directly at the query/workbook or emphases on things that are important for the report to work.

Remove the sections that are not relevant.

Description

Ex : BW - Working Capital for GBU (Core Workbook)

Technical NameEx : BW_QRY_MPR_FC001_0022

Application

Ex : FIWC - Working Capital

Info-provider

Ex : MPR_WC02

Usage type

Direct execution in Analyzer / Broadcast / Qlikview Source / ...

Expected users

Ex: GBU zone and WW controllers

Workbook/Query General Description

Enter some description to explain what is the purpose of this query/workbook and who/how it will be used.

General parameters

Global properties

TabScreenshotComment
DisplayInsert screenshot
Rows/ColumnsInsert screenshot
Value DisplayInsert screenshot
PlanningInsert screenshot
ExtendedInsert screenshot

Variables

Definitions

Variable Name

Info-object

Selection Type

Required

Description/Explanation

Ex : Calendar Day

0CALDAY

Single/Multiple/SelectOption/SAPexit/ClientExit

Yes/No

Explanation for the use of this variable

Variable Sequence

Add screenshot

Filters

ObjectFilter ValueExplanation
Ex : Status of the trading partner Ex : <> 1 Ex : Exclude intercompanies

Add screenshot if relevant

Key figures

Key Figure 1

Description

Text/name of the variable and explanation

Calculation rule detail

Quantity x Price

Text Replacement Variable

If relevant, add the text replacement rule used for the key figure

Currency Conversion

Exchange Rate Type : Ex ZRH0

Currency : Variable, or fixed currency used

Time Reference : Current date / Based on infoobject X / Variable

Unit Conversion

Unit : Variable or fixed unit

Characteristics


Info-object NameInfo-object TextExplanation (if needed)

Budget

Review

Forecast

Accuracy

QV

DR

QV

FA

0CALMONTHCalendar Year/MonthTextRowColumnFreeColumn
0LOGSYSSource SystemNo display to avoid the display of the prefix for compound characteristics.RowRowRowFree
C_MATNR2Material

Key + Text

RowRowRowFree
C_SHIPTIDSAP Ship-to

Key + Text

Previously, the Ship-to was C_SHIPTO, but description were not daily loaded.

Previous 30/10/2017, the description was 'Ship-to'

02.2019 Added in Segmentation

RowRowRowRow
0DISTR_CHANDistribution Channel

Key + Text

Available for RCS only. For SOLVAY it corresponds to the 2 first characters of the BU.

Also available for Logility flow, coming from Exclusion table since 01.2018

RowRow
Free
C_DYN_024DYN Ship-to (incl.Prosp)

Available for DynaSys since 30/10/2017

02.2019 Added on FA

FreeFreeFree
CPFCTR1_2BFC Global Business Unit

Key + Text

From DSO DBDYN02 to get the BU (C_DYN_010), then MasterData C_DYN_010 to get the GBU

FreeFreeFreeFree
C_MATNR2__0PROD_HIERProd. HierarchyKey + TextFreeFreeFreeFree
C_MATNR2__C_PRODCommercial Product / Material Group

Key + Text

Commercial Product for RCS WP1 (Basic Material in Material Master MARA-WRKST)

Example 90001465 / RHODOLINE® 581B

Material Group for SOLVAY PF1.

Example Z10-11695 / SD TGT<0,15

Exception rule : for material RCS dupplicated on Solvay PF1, having Basic Material filled with Commercial Product,

value is stored in C_PROD axis instead of Material Group  (rule cancelled 24/11/2022 WO0000000039416)

02.2019 Added on Segmentation

WP1 => DS DTS_SD_PROD_AXIS => PCH ZPC_MD_ATTR_RCS

Row

FreeFreeFree
C_SHTCTRYShip-to Country

Text for Ship-to and Prospects (C_DYN_024)

02.2019 Added on Segmentation

RowFreeFreeFree
C_SOLDIDSold-to

Key + Text

Previously, the Sold-to was C_SOLDTO, but description were not daily loaded.

FreeFreeFreeFree
C_SOLDID__C_GRCUSTIndustrial Group

Text

V1 = C_CUSTOMR__C_GRCUST

For V2 it has been changed for C_CUSTID. The field KONZS is taken from PRS Customer. PRS seems not contains all customers (only payer?). If Customer Group (C_GRCUST) are missing, the masterdata will have to be upgraded to get missing ones.

FreeFreeFreeFree
C_DYN_017__C_SAL_GRPSales Group (SAP)

Sales Group = Sales Rep for RCS WP1 Only

Source :

  • M3 order for Solvay PF1
  • Masterdata Ship-to/Sold-to Sales view if Sales Order
  • DynaSys table EXP_SHIPTO_DC_SR_MANUAL => DynaSys source to be removed
FreeFreeFreeFree
C_SHTCTRY__C_GZONEGeo Zone

Key & Texts

Geo Zone is defined at Country level

Last update was done in 29/01/2016 from WP1 table ZWFAT114 (MAGNITUDE - COUNTRIES) field Administrative zone (MGN_ZADM)

Transco 'EUR' => 'EU'; 'AMSU' => 'LA';   'ASIA' => 'AP';   'AMNC' => 'NA'  

FreeFreeFreeFree
C_DYN_005__C_TACTIC2Tactical MaterialDescription are available since 08/12/2016FreeFreeFreeFree







C_CUSTOMR__0REGIONShip-to Region FreeFreeFreeFree
C_CUSTOMR__0CITYShip-to City

Since 30/10/2017, for DynaSys info it comes from C_DYN_024 to get city for both SAP Ship-to and Sales Force Prospects

??? assignement not done with C_DYN_024__0CITY ???

FreeFreeFreeFree
C_DYN_018__C_MPPLANTMain Shipping Plant FreeFreeFreeFree
C_MATNR2__C_MAT_GRPMaterial Group FreeFreeFreeFree
C_MATNR2__C_MATGR2Packaging Type

Previous name : Material Group 2 (Release March 2017)

For Solvay PF1 only

FreeFreeFreeFree
C_MATNR2__C_DIVISNDivision FreeFreeFreeFree
C_DYN_010BU FreeFreeFreeFree
C_DYN_018__C_MSHCONDMain Shipping Cond.

Available since 07/02/2017

Shipping Condition of the last M3 sales order not rejected

(No reason for Rejection , Item Category M3N, most recent change on date)

FreeFreeFreeFree
C_MATNR2__C_MAGRVPackaging Materials

Only for RCS

Available since 14/03/2017

FreeFreeFreeFree

C_DYN_019__C_DYN_020

C_DYN_021__C_DYN_020

Planning Zone

Managed in DynaSys at DFU level

Changed to C_DYN_021 27/11/2018

FreeFreeFree
C_GBR14__C_GBR1GBR End-Use (Application)

Previous to 30/10/2017, field was C_GBR5__C_GBR1

Important C_GBR34 end-uses for all GBUs  has been created to replace

  • C_GBR14 end-uses for GBUs except Novecare 
  • C_GBR24 end-uses for GBU Novecare

To avoid havy modification in QV queries / QV application, only mapping in MVDYN11 has been changed C_GBR14__C_GBR1 is now assigned to C_GBR34__C_GBR1

Modification done 2021/01/18


Important BFC Activity 1 (C_MAGNIT2) has to be filled only for GBU = CS (Novecare), for others, as Soda in the below example, have to remain blank


FreeFreeFreeFree
C_GBR14__C_GBR2GBR End-Use (Market)

Previous to 30/10/2017, field was C_GBR5__C_GBR2

See important points written for C_GBR14__C_GBR1

FreeFreeFreeFree
C_GBR14__C_GBR3GBR End-Use (Segment)

Previous to 30/10/2017, field was C_GBR5__C_GBR3

See important points written for C_GBR14__C_GBR1

FreeFreeFreeFree
C_GBR14__C_GBR4

GBR GBU End-Use


Previous to 30/10/2017, field was C_GBR5__C_GBR4

See important points written for C_GBR14__C_GBR1

also called GBR Corporate End-Use

FreeFreeFreeFree
C_DYN_021__C_DYN_022ABC Class (auto)

Managed in DynaSys

Is based on Estimated ICM (possibility for S&OP managers to force change)

0 = Opportunité SFDC

1 = class for which Sales Team forecast is needed

2 + 3 = mainly forecast generated by stat processus



FreeFreeFreeFree
C_DYN_021__C_DYN_023ABC Class (manual)

Managed in DynaSys

Not used by Novecare and not linked to l'ABC Class (Auto)

A Large accounts to be reviewed
B Large accounts (medium impact)
C Small accounts
D Specific processes
N Potential prospects + new

FreeFreeFreeFree
C_GBUZONE__C_ZONEH1GBU Zone (Hier. 1)

Key and Text

Defined at GBU / Country level.

to be updated in case of GBU change

Ship-to's GBU Zone (Hier. 1). Updated by flat file.

It is defined GBU by GBU, so an update is requested in case of GBU change.

Use ZBW_GBR to update GBU Zone (Hier. 1) => WIKI

RowFreeFreeFree
C_GBUZONE__C_ZONEH2GBU Zone (Hier. 2)

Key and Text. Defined at GBU / Country level.

to be updated in case of GBU change

same as GBU Zone (Hier. 1)

RowFreeFreeFree
0G_CWWE01IECRAAPO + DYN WP1FreeFreeFreeFree
C_GBR18__C_GBR19GBR GBU Mat Group

Key and Text



The notion of GBU material group exists only for WP1.
Available since since 30/10/2017

02.2019 Added on Segmentation

to be updated in case of GBU change

RowFreeFreeFree
C_GBR13__C_GBR9GBR: Customer Sub Group

Key and Text

Available since since 30/10/2017

02.2019 Added on Segmentation

to be updated in case of GBU change

RowFree
Free
C_GBR13__C_GBR6GBR GBU group (Ship-to)

Key + Text

Available since since 30/10/2017, for Dyn/Log , it replaces 'Enterprise Customer Group'

02.2019 Added on Segmentation

to be updated in case of GBU change

RowFreeFreeFree
C_GBR15__C_SHIPKAGBR Ship-to KA

Key and Text

Available since since 30/10/2017

FreeFreeFreeFree
C_SHTCTRY__C_ZONEShip-to BFC Geographie/Zone

Key and Text. Zone is defined at Country Level

Available since since 30/10/2017

One shot upload done by flat file (Last upload 11/07/2014). 

FreeFreeFreeFree
C_DYN_024__C_PROSPFlag Prospect

Key and Text

Available since since 30/10/2017

 

'X' Prospect

 

' ' Ship-to

02.2019 Added on FA

FreeFreeFree
0INFOPROVInfoProvider

Key and Text

Available since 30/10/2017

FreeFree

C_GBR18__C_GBR20GBU Material Sub-grp

Key and Text

Available since 28/11/2017

02.2019 Added on Segmentation

to be updated in case of GBU change

RowFreeFree
C_DYN_018__PRDFACT

Main Prod Plant

Available since 31/05/2018

Attribut maintained only in DynaSys for RCS Material/Shipto

02.2019 Added on Segmentation

06.2019 => description changed to "Main Production Plant" (Ex : Default Factory Plant)

FreeFreeFree
C_MATNR2__C_LPRODProduct Line 00

Source SAP - function module Z_WBW_DTS_SD_PROD_AXIS

ex WP1 Material 101655

FreeFreeFree
C_MATNR2__C_LIP04Product Line 04
FreeFreeFree
C_MATNR2__C_LIP05Product Line 05

Key and Text

Available since 28/11/2017

02.2019 Added on Segmentation

RowFree

C_MATNR2__C_FMPRDProduct Family Code

FreeFreeFree
C_SOTCTRYSold-to Country
FreeFreeFree
C_SOTCTRY__C_ZONESold-to BFC Geographie/Zone

See rule for Ship-to one

FreeFreeFree
C_DYN_005__C_GRPPGMIProduct Group (PGMI)

Available only for TS (filter on PGMI IC*)

FreeFreeFreeFree
C_DYN_018__C_INCOTRMIncoterms (Solvay)

Key. From most recent Sales Orders, type M3 (without reason for rejection)
Available since 18/10/2018

FreeFreeFreeFree
C_DYN_018__C_INCOTM2Incoterms 2 (Solvay)

Key. From most recent Sales Orders, type M3 (without reason for rejection)
Available since 18/10/2018

FreeFreeFree
C_DYN_017__C_INCOTRMIncoterms (RCS)Key. From DBDYN33 (Ship-to/DC)
Available since 18/10/2018		FreeFreeFree
C_DYN_017__C_INCOTM2Incoterms 2 (RCS)Key. From DBDYN33 (Ship-to/DC)
Available since 18/10/2018		FreeFreeFree
 C_GBR23__SGINFO4 GBR Segment Info 4

Available 13/12/2018

RCS only (depending on IECRA)

02.2019 Added on FA/Segmentation

to be updated in case of IECRA / ERP BU creation/change

C_GBR23 is not filled for Novecare. Replace by C_GBR21

To avoid havy modification in QV queries / QV application, only mapping in MVDYN11 has been changed C_GBR23__SGINFO4 is now assigned to C_GBR21__SGINFO4. Modification to be done with EV00054


FreeFree

 C_GBR23__SGINFO5 GBR Segment Info 5 Available 13/12/2018

RCS only (depending on IECRA)

02.2019 Added on FA/Segmentation

to be updated in case of IECRA / ERP BU creation/change

To avoid havy modification in QV queries / QV application, only mapping in MVDYN11 has been changed C_GBR23__SGINFO5 is now assigned to C_GBR21__SGINFO5. Modification to be done with EV00054

FreeFree

C_DYN_017__C_FLGDISTDistributor Flag

Texts

02.2019 Added on DR/BR/FA/Segmentation

but empty (flow will be implemented later)

FreeFree

C_MATNR2__C_LIP02Product Line 02

Texts

02.2019 Added on DR/BR/FA/Segmentation

FreeFreeFree
C_GBR15_C_SHIPK2GBR Ship-to KA Adjusted      

Key

02.2019 Added on DR/BR/FA/Segmentation

For Novecare. If Commercial Product = "GRCL000098" (DECISION VARIOUS), Ship-to is taken

FreeFree

0CALQUARTERCal. Year/Quarter

Key

02.2019 Added on DR/FA

FreeFree

0CALMONTH2Calendar Month

Key

02.2019 Added on DR/FA

FreeFree

0CALYEARCalendar Year

Key

02.2019 Added on DR/FA

FreeFree

0CALQUART1Quarter

Key

02.2019 Added on DR/FA

FreeFree

0LOC_CURRCYLocal Currency

Key

02.2019 Added on DR

Freen/aFree
0CURRENCYCurrency

Key

02.2019 Added on DR

Freen/aRow
0UNITUnit of Measure

Key

02.2019 Added on DR/FA

FreeFree

C_PRODPLAManufacturing PlantAvailable since 15/02/2018 for FA
Free

C_SAL_OFFSales OfficeAvailable since 15/05/2018 for FA
Free

C_SHIPTOCustomer number




C_MATNR2__C_AMTS001Reason for material production




C_MATNR2__C_MSTAVX-DChain status




C_GBUZONEGBU zone




C_PLANTPlant




C_CUSTOMR__0COUNTRYCust: Country


Free
C_DYN_018__C_COMPCDECompany code


FreeFree
C_DOCTYP2Order document type

DYN for Source DynaSys

APO for Source APO



Free
C_MATNR2__C_LIP03Product line 03
FreeFreeFreeFree
C_DYN_018__C_DYN_016

Key Account

(Ship-to KA) (APO)

RCS notion

Text in MD C_GRCUST

Available since 14/03/2017

Since 30/10/2017, For DynaSys/Logility, use Ship-to KA (GBR) (C_GBR15__C_SHIPKA)

=> to be removed quickly in last QV query (QV is not using it anymore)




Free
C_TGBRC2__C_ENTSEG3GBR Enterprise Segment

Available since 25/06/2019

To avoid havy modification in QV queries / QV application, only mapping in MVDYN11 has been changed C_TGBRC2__C_ENTSEG3 is now assigned to C_TGBRC2__C_ENTSEG. Modification to be done with EV00054

FreeFree

CPFCTR2_2BFC Group of activities

BFC BU

Available since 07/2019

From IECRA for WP1 (via C_CDSA); from Material Plant for PF1 (value determined in C_DYN_018 using the main shipping plant received from DynaSys)

Technical object is C_DYN_018__CPFCTR2_2 but taken from CPFCTR2_2 stored in cube

FreeFreeFreeFree
C_MAGNITUBFC Activity 1

Available since 07/2019

From IECRA for WP1; from Material Plant for PF1 (C_DYN_018)

Technical object is 0G_CWWE01__C_MAGNITU but taken from C_MAGNITU stored in cube

FreeFreeFreeFree
C_MATNR2_C_BISMTOld Material NumberAvailable since 04/2020Free FreeFreeFree
C_DYN_053Base Material PRCOMAvailable since 04/2020FreeFreeFreeFree
C_DYN_061Commercial Product

Available since 04/2020

Commercial product For WP1 (C_MATNR2_C_PROD)

Basic Material for PF1 (C_MATNR2_BASIC_MATL)

FreeFreeFreeFree
C_DYN_018__C_VEPART

Account Manager (M3)

PF1 notion from M3 Sales Orders

Release April 2017

FreeFreeFreeFree
C_DYN_018__C_VWPARTCCS Rep (M3)

PF1 notion from M3 Sales Orders

Release April 2017

FreeFreeFreeFree
C_DYN_017__C_SALEMPSales Employee (SAP)

Key + Texts

02.2019 Added on DR/FA/Segmentation

For RCS : Mix DYN (view EXP_SHIPTO_DC_SR_MANUAL) / SAP => DynaSys source to be removed

RowFree

C_DYN_017__C_ZIPARTZI Partner (SAP)

Customer Service Officer (CSO)

or CSR Contact

Only filled for RCS, from SAP

Old name CSO. Changed to ZI Partner (SAP) 05.11.2020

FreeFreeFreeFree
C_DYN_021__C_DYN_065Sales Employee DYN

09.2020 From DynaSys view EXP_DFU_DR_BW

FreeFreeFreeFree
C_DYN_021__C_DYN_066Sales Assistant DYN

09.2020 From DynaSys view EXP_DFU_DR_BW

FreeFreeFreeFree
C_DYN_018__C_DYN_062S&OP Planner

09.2020 New

Used by Novecare + Special Chem

From DynaSys view EXP_MATSHIPTO_BW

FreeFreeFreeFree
C_DYN_021___C_DYN_063New Product Type

09.2020 New

Used by PEROX

From DynaSys view EXP_DFU_DR_BW

FreeFreeFreeFree
C_DYN_024__C_DYN_064CRM ProspectCRM Prospect before transcodification to fit max length 11 charactersFreeFreeFreeFree
C_DYN_021__C_DYN_034Active DFU

Key + Text  ( Yes/No )

Managed in DynaSys

FreeFree
Free
C_DYN_021__C_DYN_035Replaced DFU

Key + Text  ( Yes/No )

Managed in DynaSys

FreeFree
Free
C_DYN_018__C_DYN_049Stock Holding Strategy

MARC-ZZST_HOLD

Added 2020-01-18

FreeFreeFreeFree
C_DYN_018__C_DYN_050Catalog LT

MARC-ZZCATALOG_LT

Not in place on SAP side yet (WP1 January 18th 2021 / PFI Feb 2021)

Added 2020-01-18

FreeFreeFreeFree
C_DYN_017__0CUST_GRP2

GBU Segment


Customer Segmentation from the SAP SOLD-TO (caution if SOLD-TO has been forced in DynaSys, customer segmentation can not be re-determined)

Added 2020-01-18

Old name Customer Group 2 (changed 24/07/2023 with WO%285066)

FreeFreeFreeFree

C_DYN_018__0REPLENTIME

C_DYN_018__C_WZEIT

Total Replenishment Lead time

on progress

Info from C_MATPNT2, 2 axis, one as a keyfigure (like original one), on as a characteristic

SAP Material Master => MRP 3 view (MARC-WZEIT)


0REPLENTIME = 40

0STGE_PD_UN = TAG

C_WZEIT = 40 DAYS

to be addedto be addedto be addedto be added
C_SHIPTID__C_NAMECOC/O (Ship-to)

Key

FreeFreeFreeFree
C_SOLDID__C_NAMECOC/O (Sold-to)KeyFreeFreeFreeFree
C_DYN_085__C_TEAMCLTeam Cluster

Key

Team Cluster is linked to Sold-to master.

Market Cluster is managed in SAP customer master, sales view,  ‘extra sales area data’, tab ‘Additional Data’

=> table KNVV-ZZTEAMC

Used by GBU Specialty Polymer

FreeFreeFreeFree
C_GBR4__C_MAKTCLMarket Cluster

Key and Text

Market Cluster is linked to Corporate End-Use (C_GBR4 managed in GBR)

Market Cluster is managed in PF1 (and soon in WP1) table ZSD_T_ENDU_MARKC

Used by GBU Specialty Polymer

FreeFreeFreeFree
C_DYN_021__C_DYN_086ABC variability

Key and Text

Used by SA&D, and managed in DynaSys

3 Values : X Regular / Y Normal / Z Chaotic

FreeFreeFreeFree
C_DYN_021_C_DYN_UAUnder allocation

X = under allocation => will be implemented mid-July 2023 (WO%285066)

Managed in DynaSys






Old axis

C_CUSTGP2Enterprise Customer Group (APO)

Key + Text

Since 30/11/2017, only for APO (new axis for Dyn). Old description 'Enterprise Customer Group'


C_DYN_018__C_INCOTRM Incoterms

Available since 07/02/2017

Incoterms of the last M3 sales order not rejected

(No reason for Rejection , Item Category M3N, most recent change on date)


C_MATNR2__C_LPROD LIP00 Since Solstice
C_MATNR2__C_LIP04 LIP04 Since Solstice
C_MATNR2__C_FMPRD Product Group (family) Since Solstice
C_PGMI__C_GRPPGMI Item Class Since Solstice