Dataflow overview

CPX MasterData DataFlow :

https://drive.google.com/open?id=1hZ1QQbCZHr2meJCfBF0Kj44_qkkaehF3JVZtYLUcWF8

List of main MasterData

Info-object Name	Info-object Text	Compounding
	Company Code	Source System
0CO_AREA	Controlling Area
(C_COSTCTR)	Cost Center	Controlling Area	Depending on Nav. Attr. needed, we could use 0COSTCENTER (none needed for IMEP)
0COSTELMNT	Cost Element	Controlling Area
(C_MATNR2)	Material	Source System
(C_MATPNT2)	Material Plant	Plant + Source System
(C_MATPNT3)	Material Plant	Chart of accounts + Valuation type + Plant + Source System
	Plant	Source System
	Source System
	Work Center	Plant + Source System

MasterData Company Code

Attribute Name (in WBP)	Attribute Text	Type	Source
0CHRT_ACCTS	Chart of accounts	ATTR	T001-KTOPL
0COUNTRY	Country of Company code	ATTR	T001-LAND1
C_COMPPRS	PRS Company code	ATTR	T001-RCOMP

MasterData Material

Attribute Name (in WBP)	Attribute Text	Type	Source
0PROD_HIER	Product hierarchy of Material	ATTR	MARA-PRDHA
C_MAT_GRP	Material group of Material	ATTR	MARA-MATKL
C_MAT_TYP	Material Type of Material	ATTR	MARA-MTART
C_PRDHIER	Product Hierarchy (LIP03) of Material	ATTR	MARA-WKRST
C_LIP0GR	LIP00 product group of Material	ATTR	KLAH-CLASS In KSSK, look at Internal class for Object = Basic material MARA-WRKST of Material LIP00 Internal Class (and Class type 001 and Ind. Object/Class = O); then look up in KLAH with found Internal class Ex. Material 106150 => Basic material 90052119 => KSSK/KLAH Internal class 21902 => KLAH Class LIP0022406
C_LIP1GR	LIP01 product group of Material	ATTR	KLAH-CLASS In KSSK, look at Internal class for Object = LIP00 Internal Class (and Class type 001 and Ind. Object/Class = K); then look up in KLAH with found Internal class Ex. KSSK Object 21902 => KSSK/KLAH Internal class 21901 => KLAH Class LIP0104114
C_PRODGR	Product Hierarchy (LIP03) of Material	ATTR	KLAH-CLASS In KSSK, look at Internal class for Object = LIP01 Internal Class (and Class type 001 and Ind. Object/Class = K); then look up in KLAH with found Internal class Ex. KSSK Object 21901 => KSSK/KLAH Internal class 17487 => KLAH Class LIP0202114

MasterData Material Plant (C_MATPNT2)

Attribute Name (in WBP)	Attribute Text	Type	Source
0PROFIT_CTR	Profit Center of Material/Plant	ATTR	MARC-PRCTR
C_DISPO	MRP controller of Material/Plant	ATTR	MARC-DISPO
~~CPFCTR1_2~~	~~BFC GBU of Material/Plant~~	~~ATTR~~	Same as the one of Material/Plant Profit center Profit Center BGC GBU assignment is maintained in SAP table ZWFAT186 (Cf. FC GBU ZWFAT186-DESCRIPT2), which is a flat view of standard PC hierarchy NB: WPX PC hierarchy is a copy of WP1, but it’s not yet planned to manage ZWFAT186
~~C_MAGNITU~~	~~BFC Activity 1~~	~~ATTR~~	Same as the one of Material/Plant Profit center Profit Center BFC Activity 1 assignment is maintained in SAP table ZWFAT186 (Cf. FC Market ZWFAT186-WWE40), which is a flat view of standard PC hierarchy NB: WPX PC hierarchy is a copy of WP1, but it’s not yet planned to manage ZWFAT186

MasterData Material Plant (C_MATPNT3)

Attribute Name (in WBP)	Attribute Text	Type	Source
C_VALCLAS	Valuation Class	ATTR	MBEW-BKLAS

MasterData Plant

Attribute Name

Attribute Text

Type

Source

~~C_ZONE~~

~~Plant Region~~

~~ATTR~~

~~MD Country 0COUNTRY~~

~~Magnitude Geographie/Zone C_ZONE from WP1 table ZWFAT114 field MGN_ZADM Administrative Zone with following transcodification :~~

~~MGN_ZADM = 'EUR' => C_ZONE = 'EU'~~

~~MGN_ZADM = 'AMSU' => C_ZONE = 'LA'~~

~~MGN_ZADM = 'ASIA' => C_ZONE = 'AP'~~

~~MGN_ZADM = 'AMNC' => C_ZONE = 'NA'~~

Question : 21.02.2019 : ZWFAT114 should be integrated and managd on WPX or need to link WP1 to CDX to have the content of data on CDX system

NPC 25/02 finaly No need for 'BW-DP-Labor Planning Tool Interface'

C_COMPCDE

Company Code

ATTR

ZZBUKRS in 0PLANT_ATTR DataSource

MasterData Work Center

SAP Transaction CR03 to Display Work Center

SAP Tables CRHD / Work Center Header

DataSource 0WORKCENTER_ATTR + 0WORKCENTER_TEXT

Dataflow overview

Use the google presentation below as a template. This google presentation must be saved in the Reporting GDrive folder under the corresponding application. Then post the link to the document here.

Reporting documentation drive folder:

https://drive.google.com/open?id=1hZ1QQbCZHr2meJCfBF0Kj44_qkkaehF3JVZtYLUcWF8

Data loadings

Daily updates

Weekly updates

Monthly updates

Maintenance

Known bugs

Give the list and explanation on the known, not-solved, bugs.

Recurring procedure

List recurring procedures

Planned Evolution

Detail planned major evolution if already known. Example: complete decommissioning of application is planned in 2017 / Extension to solvay perimeter planned in 2nd semester of 2016