The new wiki link for this data flow is here:
BW RTR - Costa - BW Level 5 integration in Anaplan
Please update the doc there and no longer here.
| Table of Contents |
|---|
General presentation
...
New BW L5 hierarchy definition and a
nd integration to Anaplan.
Tool Leader: Charlotte Rollier
...
Levels of ZCB_GRP (target hierarchy) | Attributes of Cost Center C_COSTCTR sources and business rules | Rules for the descriptions (texts) of the levels |
Level 1 ZCBS_GRP | IF GBU/Function (C_GBUFUCT) = GRP_GBU then Level 1 = CPFCTR1_2 (BFC GBU code) Else GBU/Function (C_GBUFUCT) (values = GRP_FUNCT or GRP_SBS) | For C_GBUFUCT = GRP_GBU => name of the GBU else the description linked to C_GBUFUCT |
Level 2 ZCBS_GRP | IF GBU/Function (C_GBUFUCT) = GRP_GBU then concatenation of Group Function (C_GRPFUCT) & CPFCTR1_2 (BFC GBU code) with ”_” as separator Else Group Function (C_GRPFUCT) | No GBU in the description only the description linked to Group Function (C_GRPFUCT) |
Level 3 ZCBS_GRP | %case 1 : Function and SBS If C_GBUFUCT= GRP_FUNCT or GRP_SBS Then Level 3 = value of 3 sub function (C_FUNCT_3) %case 2 : C_FUNCT_2 Else IF C_FUNCT_2 = in the list EPRD ; ELOCO ; EMISC; ESTLO (Added in Global Filter) (global filter) THEN level 3 = concatenation of C_FUNCT_2 & Log Sys & Responsible Plant code of the CC and & CPFCTR1_2 (BFC GBU code) with ”_” as separator %case 3 :others cases ELSE concatenation value of 3 sub function (C_FUNCT_3) & CPFCTR1_2 (BFC GBU code) with ”_” as separator | %case 1 : Function and SBS Description linked to 3 sub function (C_FUNCT_3) %case 2 : C_FUNCT_2 First the G_ZONE code from company code C_COMPCDE and code of the plant and description of the plant as space as separator %case 3 :others cases Description linked to 3 sub function (C_FUNCT_3) no need GBU description |
Level 4 ZCBS_GRP | %case 1 : Function and SBS If C_GBUFUCT = GRP_FUNCT or GRP_SBS then Level 4 = 4 function (C_FUNCT_4) %case 2 : C_FUNCT_2 Else IF C_FUNCT_2 = in the list EPRD ; ELOCO ; EMISC; ESTLO (Added in Global Filter) (global filter) THEN level 4 = concatenate 3 sub function (C_FUNCT_3) & log sys & responsible Plant code of the CC & CPFCTR1_2 (BFC GBU code) with ”_” as separator %case 3 : others cases ELSE Level 4 = concatenation value of 4 function (C_FUNCT_4) & CPFCTR1_2 (BFC GBU code) of the CC with ”_” as separator | %case 1 : Function and SBS 4 function (C_FUNCT_4) %case 2 : C_FUNCT_2 3 sub function (C_FUNCT_3) & '_' & Medium description of the plant (C_PLANT) %case 3 : others cases 4 function (C_FUNCT_4) |
Level 5 ZCBS_GRP | %case 1 : Function If C_GBUFUCT = GRP_FUNCT then Level 4 = 4 function (C_FUNCT_4) & 4 function (C_FUNCT_4) with ”_” as separator %case 2 : SBS Else IF GBU/Function = GRP_SBS* THEN concatenate 4 function (C_FUNCT_4) & Code country of the company %case 3 : C_FUNCT_2 Else IF C_FUNCT_2 = in the list EPRD ; ELOCO ; EMISC; ESTLO (Added in Global Filter) (global filter) THEN level 4 = concatenate 3 sub function (C_FUNCT_3) & 3 sub function (C_FUNCT_3) & Log Sys & Responsible Plant code of the CC & CPFCTR1_2 (BFC GBU code) with ”_” as separator %case 4 : Others cases ELSE Level 4 = concatenation value of 4 function (C_FUNCT_4) & 4 function (C_FUNCT_4)& CPFCTR1_2 (BFC GBU code) of the CC with ”_” as separator | %case 1 : Function 4 function (C_FUNCT_4) %case 2 : SBS code country code + 4 function (C_FUNCT_4) space as separator %case 3 : C_FUNCT_2 3 sub function (C_FUNCT_3) (if EPRD etc) & '_' & Medium description of the plant (C_PLANT) %case 4 : Others cases 4 function (C_FUNCT_4) |
...
Process Chain: PC_CT_LEVEL5_HIER2 - COSTA - Hierarchy Level 5 from ECC
Loading frequency
Daily.
Note: Not running for now. Waiting for PO2 Scope data available in BW.
To allow the filling of the cost center master data BW attributes linked to L5 NASA Hierarchy, some pre-requisites are mandatory :
A) loads of the attributes of the cost center from ERP's (WP1, PF1 and PI1) and transaction code ZBW_CBS
B) Load of the ZCB hierarchies
C) Load of L5 fields
A-1) The load of the cost center master data from PF1 :
Process chain : RPC_COOM_MD_PF1
Daily schedule at around 02:00am (CET Time)
+ linked to the frozen period, during the yearly frozen period
Frozen period :
(period from end of December until around 20th of January which is not allow to reflect the update done in master data to not impact the end yearly closing period which should be done with th scope of the current year and not the future year)
load during the frozen period :
Load after frozen period :
The data from PF1 are loaded only once time per day during the night loading at around 02:00am (CET Time)
A-2) The load of the cost center master data from PI1 :
Process chain : RPC_COOM_MD_PI1
Daily schedule at around 02:00am (CET Time)
+ linked to the frozen period, during the yearly frozen period
During the frozen period :
Out of frozen period :
3) From WP1
ZPC_MD_ATTR_RCS
During frozen period :
After frozen period
+ loads done with process chain : FREQUENTLY_LOAD_MD
During frozen period :
From PC_FC_CYTEC_001
B-1) Load of the hierarchy every days at 07:00pm (CET time) CO_DAILY_MASTER_DATA (Daily Hierarchies CO 1/2)
For WP1 data :
Master process chain : DAILY_PC_HIER_TXT
B-2) Load of the hierarchy every days at 07:00pm (CET time) CO_DAILY_MASTER_DATA_HY (Daily Hierarchies CO 2/2)
For PF1 and PI1 data
Master process chain : DAILY_PC_HIER_TXT
C-1) Load of L5 fields on Cost center (C_COSTCTR) BW master data :
L5 update with PC_CT_LEVEL5_HIER_02 every days at 10:00pm cet time BUT following the BE Factory calendar, so the process chain is not running during Belgium public holidays.
For example for 2024 :
Ad-hoc run using the current Solvay Scope could be performed.
Open Hubs for Anaplan
BW folder for the files: /exploit/BW/Anaplan_outbound
...