(warning)     (warning)     (warning)     (warning)

The new wiki link for this data flow is here:

BW - DP - List of axis in DP queries 

Please update the new doc there and no longer here.

(warning)    (warning)       (warning)       (warning) 





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

Technical Name

Application

Info-provider

Usage type

Expected users

Workbook/Query General Description

General parameters

Global properties

TabScreenshotComment
Display
Rows/Columns
Value Display
Planning
Extended

Variables

Definitions

Variable Name

Info-object

Selection Type

Required

Description/Explanation

Variable Sequence

Filters

ObjectFilter ValueExplanation

Key figures

Key Figure 1

Description

Calculation rule detail

Text Replacement Variable

Currency Conversion

Exchange Rate Type : 

Currency : 

Time Reference : 

Unit Conversion

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
  • No labels