Dataflow overview
CPX MasterData DataFlow :
https://drive.google.com/open?id=1hZ1QQbCZHr2meJCfBF0Kj44_qkkaehF3JVZtYLUcWF8
List of main MasterData
| Info-object Name | Info-object Text | Source | Compounding |
|---|---|---|---|
| 0CHRT_ACCTS | Chart of accounts | ||
| C_COMPCDE | Company Code | Source System | |
| 0CO_AREA | Controlling Area | ||
| C_COSTCTR | Cost Center | Controlling Area | |
| C_COSTELM | Cost Element | Controlling Area | |
| C_MATNR | Material | Source System | |
| C_MATPLNT | Material Plant | Plant + Source System | |
| C_MATMBEW | Material Plant/Valuation | Chart of accounts + Valuation type + Plant + Source System | |
| C_COORDER | Order Number | Source System | |
| C_PLANT | Plant | Source System | |
| 0SOURSYSTEM | Source System | ||
| C_VALTYPE | Valuation type | Source System | |
| C_WORKCTR | Work Center/Ressource | Table CRHD | Plant + Source System |
MasterData Company Code
| Attribute Name (in WBP) | Attribute Text | Source | |
|---|---|---|---|
| 0CHRT_ACCTS | Chart of accounts | T001-KTOPL | |
0COUNTRY | Country of Company code | T001-LAND1 | |
C_COMPPRS | Company code PRS | T001-RCOMP | Reference to C_COMPCDE? D'où récupérer le libellé ? |
MasterData Material
| Attribute Name (in WBP) | Attribute Text | Source | |
|---|---|---|---|
0PROD_HIER | Product hierarchy of Material | MARA-PRDHA | |
C_MAT_GRP | Material group of Material | MARA-MATKL | Compounded by 0LOGSYS in WBP |
C_MAT_TYP | Material Type of Material | MARA-MTART | Compounded by 0LOGSYS in WBP |
C_PRDHIER | Product Hierarchy (LIP03) of Material | MARA-WKRST | Compounded by 0LOGSYS in WBP |
C_LIP00GR | LIP00 product group of Material | 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_LIP01GR | LIP01 product group of Material | 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 group of Material | 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
| Attribute Name (in WBP) | Attribute Text | Source |
|---|---|---|
0PROFIT_CTR | Profit Center of Material/Plant | MARC-PRCTR |
C_DISPO | MRP controller of Material/Plant | MARC-DISPO |
|
| 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 |
|
| 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/Valuation
| Attribute Name (in WBP) | Attribute Text | Source | |
|---|---|---|---|
| C_VALCLAS | Valuation Class | MBEW-BKLAS | Compounded by 0LOGSYS in WBP |
MasterData Plant
| Attribute Name | Attribute Text | Source | |
|---|---|---|---|
| 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 | ZZBUKRS in 0PLANT_ATTR DataSource | |
MasterData Order Number
| Attribute Name (in WBP) | Attribute Text | Source | Comments |
|---|---|---|---|
| C_CORDTYP | Order Type | AUFK-AUART | Compounded by 0LOGSYS in WBP |
| C_FEVOR | Production Scheduler | AUFK-ZZFEVOR | Does not exist as attribute of Order Number in WBP |
| C_LINHIER | Line hierarchy | AUFK-ZZMDVUP | Does not exist as attribute of Order Number in WBP |
| C_MDV01 | Production line | AUFK-ZZMDV01 | Does not exist as attribute of Order Number in WBP |
| C_PRVERPO | Production Version PO | AUFK-VERID | Does not exist as attribute of Order Number in WBP |
| C_WBOMPO | Alternate.BOM PO | AUFK-STALT | Does not exist as attribute of Order Number in WBP |
| C_WBS_ELM | WBS Element | AFPO-PROJN | Compounded by 0LOGSYS in WBP |
MasterData Work Center/Ressource (C_WORKCTR)
SAP Transaction CR03 to Display Work Center
SAP Tables CRHD / Work Center Header
DataSource 0WORKCENTER_ATTR + 0WORKCENTER_TEXT
| Attribute Name | Attribute Text | Source | |
|---|---|---|---|
| K_PARV2 | Number of Operators | CRHD-PARV2 via class Z0WORKCENTER_ATTR | |
| U_PARU2 | Number of Operators Unit | CRHD-PARU2 via class Z0WORKCENTER_ATTR |
Dataflow overview
Reporting documentation drive folder:
https://drive.google.com/open?id=1hZ1QQbCZHr2meJCfBF0Kj44_qkkaehF3JVZtYLUcWF8
Data loadings
Daily updates
Weekly updates
Monthly updates
Maintenance
Known bugs
Recurring procedure
Planned Evolution