Dataflow overview

CPX MasterData DataFlow : 

https://drive.google.com/file/d/1KC1YRemekkmGSJl5tarY9vticCpLcWAMoR7Iy3eGDgc/view

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
C_GLBFILTC_GLBFILTMaster data global filterFlat File

MasterData Company Code (C_COMPCDE)

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)

DataSource 0MATERIAL_ATTR + 0MATERIAL_TEXT

Attribute Name (in WBP)Attribute Text

Source


0PROD_HIER

Product hierarchy of Material

MARA-PRDHA

Datasource 0MATERIAL_ATTR field PRDHA

C_MAT_GRP

Material group of Material

MARA-MATKL

Compounded by 0LOGSYS in WBP

Datasource 0MATERIAL_ATTR field MATKL

C_MAT_TYP

Material Type of Material

MARA-MTART

Compounded by 0LOGSYS in WBP

Datasource 0MATERIAL_ATTR field MTART

C_PRDHIER

Product Hierarchy (LIP03) of Material

MARA-WKRST

Compounded by 0LOGSYS in WBP

Concatenation of 'P' and field WRKST

0BASE_UOMBase Unit of Measure
Datasource 0MATERIAL_ATTR field MEINS


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)1000

MARC- LOSGR (unit 0BASE_UOM)

Class Z0MAT_PLANT_ATTR - field ZZLOSGR

MM03 → Costing View

0BASE_UOMBase Unit of MesurePC

MARA-MEINS

Class Z0MAT_PLANT_ATTR - field ZZMEINS


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

U_COMPUNIComponent Unit
MARC-FRTMEProduction Unit (WPX) = Component Unit (CPX), if Production Unit does not exist for this material Base Unit of Measure (WPX )= Component Unit (CPX).

MasterData Material Plant/Valuation (C_MATMBEW)

Attribute Name (in WBP)Attribute Text

Source


C_VALCLASValuation Class MBEW-BKLAS Compounded by 0LOGSYS in WBP

MasterData Plant (C_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 (filled with class Z0PLANT_ATTR)
C_SORT2Search Term 2ZZSORT2 in 0PLANT_ATTR DataSource - From table ADRC (filled with class Z0PLANT_ATTR).

MasterData Profit Center (C_PROFITC)

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 (C_COORDER)

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


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/file/d/1KC1YRemekkmGSJl5tarY9vticCpLcWAMoR7Iy3eGDgc/view

Data loadings

Daily updates


Technical Name Process ChainLabel Process chainDescriptionScheduled
AttributsPC_GLOBAL_ATTR_01Global: META - MD - D - Master Data Attributes (Vault)

Main Chain : RSP_DAILY_GLOBAL

Schedule : at 19:01 (before 19:30), daily, calendar 14, 'not on Sunday or public holidays'

TextesPC_GLOBAL_TEXT_01Global: META - TXT - D - Master Data Texts (Vault)

Same as attributs

Generated conversion ADSO (automatic conversion)

PC_GLOBAL_ATTR_03Global: MD - D - Unit Conversions UOMC_MAT for C_MATNRfor C_MATNR + C_MATPLNT

Same as attributs


ADSO woth conversion (not generated)PC_GLOBAL_ATTR_04Global: MD - D - Material unit of quantity (DSO)

Load ODS ABMARM01

Needed for PC_CO_PC_MM_04 (monthly)

Same as attributs

Dynasys AttributesPC_DPS_DYNASYS_01DPS Dynasys : MD - D - Master Data AttributesDynasys Master dataSame as attributs
Dynasys
Texts		PC_DPS_DYNASYS_02DPS Dynasys : MD - D - Master Data TextsDynasys Master dataSame as attributs


Extract of  RSP_DAILY_GLOBAL - META - D - Daily Process Chains (Attr, Texts, Unit conv)

Weekly updates (none)

Monthly updates (none)

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