You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 29 Next »

Dataflow overview

CPX MasterData DataFlow : 

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

List of main MasterData

 

Info-object NameEquivalent in WBPInfo-object TextSource

Compounding

0CHRT_ACCTS0CHRT_ACCTSChart of accounts

C_COMPCDEC_COMPCDECompany Code
Source System
0CO_AREA0CO_AREAControlling Area

C_COSTCTRC_COSTCTRCost Center
Controlling Area
C_COSTELM0COSTELMNTCost Element
Source System + Controlling Area
C_MATNRC_MATNR2Material
Source System
C_MATPLNTC_MATPNT2Material Plant
Plant + Source System
C_MATMBEWC_MATPNT3Material Plant/Valuation
Chart of accounts + Valuation type + Plant + Source System
C_COORDERC_COORDEROrder Number
Source System
C_PLANTC_PLANTPlant
Source System
C_PROFITC0PROFIT_CTRProfit Center
Source System + Controlling Area
0SOURSYSTEM0SOURSYSTEMSource System

C_VALTYPEC_VALTYPEValuation type
Source System
C_WORKCTRC_WORKCTRWork Center/RessourceTable CRHDPlant + Source System
C_VENDIDC_VENDIDVendor number
Source System

MasterData Company Code

Attribute Name (in WBP)Attribute Text

Source


0CHRT_ACCTSChart of accountsT001-KTOPL

0COUNTRY

Country of Company code

T001-LAND1

C_COMPPRS

Company code PRS

T001-RCOMPReference to C_COMPCDE? D'où récupérer le libellé ?

MasterData Material (C_MATNR)

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




MasterData Material Plant (C_MATPLNT)

Attribute Name (in WBP)Attribute TextExample

Source


0PROFIT_CTR

Profit Center of Material/Plant


MARC-PRCTR

C_DISPO

MRP controller of Material/Plant


MARC-DISPO

C_LIP00GR

(C_LIP0GR)

LIP00 product group


Datasource 0MAT_PLANT_ATTR field ZZLIP00GR


C_LIP0GRWLIP00 product group plant
Datasource 0MAT_PLANT_ATTR field ZZLIP00GRW

C_LIP01GR

(C_LIP1GR)

LIP01 product group


Datasource 0MAT_PLANT_ATTR field ZZLIP01GR


C_LIP1GRWLIP01 product group plant
Datasource 0MAT_PLANT_ATTR field ZZLIP01GRW

C_PRODGR

Product group


Datasource 0MAT_PLANT_ATTR field ZZPRODGR


C_PRODGRWProduct group plant
Datasource 0MAT_PLANT_ATTR field ZZPRODGRW
K_LOSGRCosting Lot Size (EOQ)1000MARC-LOSGR (unit 0BASE_UOM)

Costing View

Not filled yet

0BASE_UOMBase Unit of MesurePCMARA-MEINSNot filled yet
C_BESKZMRP Procurement TypeEMARC-BESKZ

MRP2 View

Text from DTS_BESKZ (Domain BESKZ)

C_ITMGRPItem Group008 / FILLER-RM

material Characteristic => Material Class => Subcategory

Not filled yet => class does not exist in WDX yet

MasterData Material Plant/Valuation

Attribute Name (in WBP)Attribute Text

Source


C_VALCLASValuation ClassMBEW-BKLASCompounded by 0LOGSYS in WBP

MasterData Plant

Attribute NameAttribute Text

Source


C_ZONEPlant Region

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_COMPCDECompany CodeZZBUKRS in 0PLANT_ATTR DataSource

MasterData Profit Center

Attribute Name (in WBP)Attribute Text

Source

C_GBU

(CPFCTR1_2)

BFC GBU of Material/Plant

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

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 Order Number

Attribute Name (in WBP)Attribute Text

Source

Comments
C_CORDTYPOrder Type

AUFK-AUART

Compounded by 0LOGSYS in WBP
C_FEVORProduction Scheduler

AUFK-ZZFEVOR

Does not exist as attribute of Order Number in WBP
C_LINHIERLine hierarchy

AUFK-ZZMDVUP

Does not exist as attribute of Order Number in WBP
C_MDV01Production line

AUFK-ZZMDV01

Does not exist as attribute of Order Number in WBP
C_PRVERPOProduction Version PO

AUFK-ZZVERID

Does not exist as attribute of Order Number in WBP
C_WBOMPOAlternate.BOM PO

AFKO-STLAL

Does not exist as attribute of Order Number in WBP

C_WBS_ELM

(C_WBS_EL2)

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 NameAttribute Text

Source


K_PARV2Number of Operators

CRHD-PARV2

via class Z0WORKCENTER_ATTR


U_PARU2Number of Operators Unit

CRHD-PARU2

via class Z0WORKCENTER_ATTR

IO in reference to 0UNIT


MasterData Material (C_MATNR)

DataSource 0MATERIAL_ATTR + 0MATERIAL_TEXT


Attribute NameAttribute Text

Source


0PROD_HIERProduct Hierarchy

Datasource 0MATERIAL_ATTR field PRDHA



C_MAT_GRPMaterial Group

Datasource 0MATERIAL_ATTR field MATKL



C_MAT_TYPMaterial TypeDatasource 0MATERIAL_ATTR field MTART
C_PRDHIERProduct Hierarchy (LIP03)Concatenation of 'P' and field WRKST
0BASE_UOMBase Unit of MeasureDatasource 0MATERIAL_ATTR field MEINS



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

 

  • No labels