General presentation
Objective of the application
Tool Leader + IT leader of the application:
Usage information
History
Roles & Access
Roles and access
List of application role + menu role and explanation if we have several applications role with specials rules.
| Role Code | Role Description | Explanation |
|---|---|---|
| ZR_RCS_CA_M731 | CT - COSTA Transactions | Role to have access to transaction ZBW_CUST_COSTA |
Authorization objects
List of autorisation objects mandatory for the application.
| Authorization object | Explanation |
|---|---|
Dataflow overview
Reporting documentation drive folder:
https://drive.google.com/drive/folders/0B0qn89R0RGdqYkZZOFZyYXlXVkE
Exemple of dataflow overview :
Template Application name DataFlow
Functional and Technical rules on Workbench + Reporting
Flat files loading - Transaction ZBW_CUST_COSTA
Order Capex Opex
- Program: ZBW_COSTA_ORDER_CAPEX_OPEX
- Process chain: PC_CT_TR_03
- Infoprovider: APCOCT09 → CPCOCT06
- Query: BW_QRY_CPCOCT06_0001 + QV_BW_QRY_CPCOCT06_0001
- Flat file format: https://drive.google.com/file/d/17S7GBSYr4PdUoIKgFM_55WUXNZ30Mj_5/view?usp=sharing
Percentage inflation
- Program: ZBW_COSTA_INFLATION
- Process chain: PC_CT_TR_04
- Infoprovider: APCOCT11 → CPCOCT06
- Query: BW_QRY_CPCOCT06_0002 + QV_BW_QRY_CPCOCT06_0002
- Flat file format: https://drive.google.com/file/d/1ohjO7Frob67lfLQeTBI5YV1TAKlRz9MO/view?usp=sharing
Zero Based Budgeting
- Program: ZBW_COSTA_C_CTSBPKG_ZBB
- Process chain: PC_CT_TR_05
- Infoprovider: APCOCT13 → CPCOCT06
- Query: BW_QRY_CPCOCT06_0003 + QV_BW_QRY_CPCOCT06_0003
- Flat file format: https://drive.google.com/file/d/1m-KAKYcZaj0EW5-DWsYnxeovxS733nQH/view?usp=sharing
Resp. Cost Center Determination
- Program: ZBW_COSTA_RCC
- Process chain: PC_CT_RCC_01
- Infoprovider: APCOCT15
- Query:
- Flat file format: https://docs.google.com/spreadsheets/d/1vqYWqegl4sTGUZTg-lPb6o1N5XzWKx7midspUa3ZGik/edit#gid=0
Cluster GBU
Clusters and sub clusters come from PF1_050, datasource DTS_BW_REPO_BU_CLU_SCLU. This datasource uses module function ZFM_BW_REPO_BU_CLU_SCLU).
We extract data into adso APCOCT14 and then load the attributes and textes in master data CPFCTR1_2, C_CLUSTER & C_SUBCLUS (loadings done in process chain PC_CT_MD_01).
Group of function
Goal:
Add in master data C_COSTCTR two attributes: group function and GBU function extracted from hierarchy Z013ZCBS_GRP (WP1 system). The link between cost center and hierarchy is C_FUNCT_2 (attribute from cost center and level 4 in hierarchy Z013ZCBS_GRP).
Steps:
1) Extract Z013ZCBS_GRP hierarchy in master data C_FUNCT_2 where: (done in process chain PC_CT_MD_01).
- C_FUNCT_2 = level 4 in Z013ZCBS_GRP (without controlling area).
- C_FUNCT_2__C_GRPFUNC = Level 3 in Z013ZCBS_GRP.
- C_FUNCT_2__C_GBUFUNC = Level 2 in Z013ZCBS_GRP.
2) Load attributes C_GRPFUNC & C_GBUFUNC in master data C_COSTCTR (with look up on C_FUNCT_2)
Cost package derivation from:
Material Group
In adso APCOCT04 we use data from master data C_MAT_GRP to determine cost sub package (C_CTSBPKG).
This loading is done in process chain PC_CT_TR_01 (process skipped for the moment because values in master data C_MAT_GRP are not ok, so data loaded by flat file).
Segment
In adso APCOCT05 we use data from master data C_SEGT to determine cost sub package (C_CTSBPKG).
This loading is done in process chain PC_CT_TR_01.
Cost Element:
In adso APCOCT06 we use data from adso APCOCT16 (only landscape ERPSOLV and ERPRCS) to determine cost sub package (C_CTSBPKG) associated to cost element.
For the moment there is no process chain to load this dso, for the moment there is another transformation and dtp to load the adso with flat file.
Investment Reason for PM Order
Goal: in master data c_coorder add three new attributes C_GEN_REA & C_INV_REA C_ORD_TYP
C_GEN_REA & C_INV_REA come from C_WBS_EL2 and C_WBS_EL2 comes from dso ABCOCT01 & ABCOCT02.
Rules & Explanations
Dependencies with other applications
Data loadings
Info providers and objects loaded
Loading frequency
Average performance
| Key Figure | Estimation |
|---|---|
| ~ Average Process Chain Runtime | |
| ~ Average nb of rows loaded per load | |
| ~ Total nb of rows loaded (if full) | |
| ~ Average Runtime for 10k lines |
Record Keeping
Reporting
Queries End User Documentation
Unit test for program ZBW_COSTA_RCC:
https://docs.google.com/document/d/1lG0t9k2MadMawaTrYvtFDmwJ1Twzbp3jcjF1VJ-XC1g/edit?usp=sharing