| Table of Contents | ||
|---|---|---|
|
Access Management
| Panel | |||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| |||||||||||||
|
| Panel | ||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| ||||||||||||||||
Link to the BW Catalog of role https://drive.google.com/open?id=10GEfKYqrT1eeTO_uHYAheL1GX7L5y_pvH0KQU64qh5I
|
...
Solstice Google Drive document
MVCOPA01
P&L
WP1
Updated dataflow after Solstice update (Rules are unchanged except for the Solstice split)
...
Last change : PO2 Project 08/2023
Non ERP
PQ1
PQ1 flows are kept only for historical data, they are replaced by PF1 flows since 01.2018.
PF1:
CPCOPA03
More details here.
...
P&L was done in 2015 and IM in 2016. Solstice split was done in 2019.
Technical Rules
...
on Workbench
Functional rules
COPA flows
COPA module is the ancestor of BW
COPA is divided in “tight” perimeters (in customizing, in VV list, for certain characteristics, for BW data sources) : Operating concern
The lines of the ERP data (COPA value fields from WP1 system) must be translated in BFC account. This translation should be dynamic.
...
Value Fields are the lowest key figures in COPA module (For BCS sourcing)
Value Fields are the central elements of the BFC account determination. Since CROCO project, the determination of the BFC account depends of the value field and also the OECD activity for PF1 COPA flow.
- P&L analysis is based on BFC Account with a detail by Value Field. For now, it is not useful to have an analysis directly by value field
Rhodia legacy
Historic data have been recalcuted with the new allocation Value Field / BFC Account
Historic views are avaible in BFC (not restated)
...
- CASE A : COPA line items with Material and Distribution Channel valid
- CASE B : COPA line items with Material empty and/or Distribution Channel empty
Solvay legacy data (PQ1 based solution)
Existing application in PQ1 with a lot of intelligence
Easier to load from PQ1 than redoing what has already been done - it was a temporary solution and it is replaced with SPS project (P&L with COPA in PF1, go live was on January 2018)
BFC Data
Loaded by flat files
3 levels:
Version 1: Total P&L
Version 2: Interco Sales
Version 3 : Third Party
...
<--- 08/2023 : PO2 Project
CICC
Loaded by BFC flat files
Only for CICC companies (companies in c_compprs MD with landscape = "CICC") or Adjustment companies maintained in c_glbfilt (PL_BFC_ADJ/COMPANY)
Below Gross Margin
Loaded by BFC flat files, only for companies loaded in Non ERP for the concerned month (companies can move from Non ERP to ERP) when Below Gross Margin is not uploaded by flat file (= only Non ERP system for which a non full flat file is loaded).
Non ERP companies
Some companies are in Solvay group but don’t use RCS or Solvay ERP : companies belonging to NOVECARE or SODA GBU
Systems involved
Rhodia ERP WP1
Solvay BW PQ1 (PQ1 is the view of the P&L for PF1 data)
BFC (flat files)
- Flat files for Non ERP
Organisation
BFC GBU
BFC Group of Activities
BFC Activity
Technical rules
P&L WP1
We have 2 steps in the business layer.
...
BFC heading determination: the BFC heading is determined in master data C_FIELDN using DSO dpcopaa10 (data from WP1 table ZWFAT110).
Solstice (WP1)
An additional split is done from ABCOPA03 to 2 ADSO: ABCOPA01 and ABCOPA04. ABCOPA01 contains Solstice data and ABCOPA04 contains non-Solstice data. Split is done on a list of Company Code in the DTPs.
...
- Delta from ABDPDY01: If Program, Market or Program Percentage have been modified/created.
- Delta from ABDPDY02 & from ADPSDAE01: Both ADSOs are used to feed Master Data C_ITM_SD, if Main Specification or Specification List are created/changed.
P&L PF1
We have 2 steps in the business layer.
...
-c_tecpct2 (reference c_tecpctr) - Technical Profit Center:
This object is used to determine dynamically the organisational structure (activity1, GBU...).
It follows the business rules in COPA, these rules have changed after SPS project and the old model technical MD, c_techba, is now used for historical data only (before 2018).
cf. part "8.7 Organisation structure" of the specification document: https://drive.google.com/open?id=1lBBAR1mIJpdyw-RHrglgSSGm14uY1J1Whx9-j0k5jZ8/file/d/19tbW1LlskpgOQHslJAH1Aby85wZYjmRsKc6BBtE5SVM/view
The entries in this MD are generated only by the SID generation in transactional flows then transformation from the MD to itself determines the attributes.
-c_techpac - Technical Part Activity:
This object is used to determine dynamically the partner organisational structure.
It follows the business rules in COPA, these rules have changed after SPS project and the old model technical MD, c_techpba, is now used for historical data only (before 2018).
cf. part "8.8 Partner Organisation structure" of the specification document: https://drive.google.com/open?id=1lBBAR1mIJpdyw-RHrglgSSGm14uY1J1Whx9-j0k5jZ8/file/d/19tbW1LlskpgOQHslJAH1Aby85wZYjmRsKc6BBtE5SVM/view
The entries in this MD are generated only by the SID generation in transactional flows then transformation from the MD to itself determines the attributes.
...
-c_tgbr5:
This object is used to determine dynamically the GBR axis.
cf. specifications: https://drive.google.com/open?id=18IyjGuveYkJ0hnnCT2YfpjjL3lf0BvpkCxlSL3NLzSc/file/d/1AL5UzU3oIFqyzMAwU9Dv6Ko6SNWQcF6Z992nB5WxhAU/view
The entries in this MD are generated only by the SID generation in transactional flows then transformation from the MD to itself determines the attributes.
BFC
08/2023 : PO2 Project changes
...
- customer_master_data.csv
- material_master_data.csv
- non-erp_data.csv
Example of user manual to upload non-ERP file
Dataflow :
https://docs.google.com/presentation/d/1fmDajNiJ7SF12m8K_ytJgScvxoaMmcEnUCVP7-S1d8w/edit
...
| Global Filter Stream (Application) | "Global Filter Rule" | "Global Filter" | Global Filter Active | Global Filter Description | Global Filter Hight Value | Global Filter Low Value | Global Filter Option | Global Filter Sign |
| CO_NONERP | COMPCDE | 1 | Y | Company Code | 07735 | EQ | E |
PQ1
PQ1 flows are kept only for historical data, they are replaced by PF1 flows since 01.2018!
...
The file loaded in WBP was stored the following directory: https://drive.google.com/drive/folders/1CxIL3OR68e3DGFi6a3SFxY3eOfGm0nbK1sPk5Jh8nJBNVeYIV2dX2yOB23XDQGjyU
GBU: the GBU in the reporting is the attribute of c_techba. The GBU stored in the DSO from the Business transformation layer is also the attribute of c_techba (replaced between propagation and business layer) and not the GBU from PQ1 which is linked to the business area in ZZCONACT.
...
2: Company is not LER and Plant is Trading Plant
3: Company is not LER
The list of companies is managed in Global filter master data C_GLBFILT manually or by flat file:
...
To have more details about Z_LER_RULES, there is a dedicated document about it:
https://drive.google.com/open?id=1-54NzGz63dagA-UyyIIoNgK8fwmzo-e-YAnASxInwjo/file/d/1AXQaMXmP4AdN9FeP8eByaRVQqDgs59BJBPL3NxSAhfc/view
1) determine where the program is sued to be able to select the data from corresponding dso:
...
If c_fieldn = QUANTITY (standard case): we pick data from ODS_PCP4
If necessary, we convert quantitites and amounts with module functions: 'Z_CONVERT_CURRENCY' with type of rate CAR3 + 'Z_MD_CONVERT_MATERIAL_UNIT_F'
And we calculate new value fields:
If no records are found in ODS_PCP4, we determine value fields from source DSO
...
Counter 002 by company code
Coutner 003 by GBU
Data Loading
Info providers and objects loaded
List on info providers inside the technical cockpit.
Main process chains are:
PC_COPA_PL_GLOBAL : Load WP1 & PF1 COPA, BFC and WP1 IM daily
PC_COPA_PL_22 : Load WP1 & PF1 COPA Extra load during closing period. This chain included too chain PC_COPA_PL_12, which load BFC File in WBP.
PC_COPA_PL_36 : Load PF1 IM and allocation of transportation costs PF1
PC_COPA_PL_09 : Load Non ERP Master data and Transactional data
Other chains:
...
CRCOPA29
CRCOPA31
CRCOPA02
CRCOPA01
...
CRCOPA03
CRCOPA04
CRCOPA05
CRCOPA06
CRCOPA07
CRCOPA08
...
CRCOPA18
CRCOPA14
CRCOPA17
CRCOPA13
CRCOPA15
CRCOPA16
CRCOPA20
CRCOPA32
...
CRCOPA09
CRCOPA20
...
Reporting
Queries End User Documentation
All the reporting is available throught workbooks in the role "PL - P&L Reporting" ZR_RCS_CA_M12
Query documentation:
https://drive.google.com/drive/folders/1pFQ_tfTUYK1xEz4-cz0JFel7arKyY7Nn?usp=drive_link
Reporting documentation drive folder:
https://drive.google.com/drive/folders/19pPWUmAkTcW1aYlzlqyHOxvL6JfDdaKe
https://drive.google.com/drive/folders/1zF0862L7nRnu39MXdtVORT-HkmHavs-R
https://drive.google.com/drive/folders/1xY6QOu8gmrvmyncdpSu5trUA5SQIliRX
https://drive.google.com/drive/folders/1rzUHdVecCOROXOkZBpp7uhbHNJqIc63Y
Main queries
There are several queries but the main ones are:
BW_QRY_MVCOPA01_0001 BW P&L Query
BW_QRY_MVCOPA01_0002 BW P&L - Monthly Query
BW_QRY_MVCOPA01_0003 BW P&L Reconciliation Query
BW_QRY_MVCOPA01_0005 BW Integrated Contribution Margin Query
All queries use structures for key figures. There are many key figures, using calculated and restricted key figures inside.
Main functionnalities: Jump query available
Dependencies with other applications
List of APD:
| APD | Description |
|---|---|
| APD_PL_0007 | ADP P&L Contrib (current month - Conso) |
| APD_PL_0006 | ADP P&L Contrib (current month - Detailed) |
| APD_PL_0005 | ADP P&L Sales Contrib (current and last month) |
| APD_PL_0004 | ADP P&L VC+QTY current month |
| APD_PL_0001 | ADP P&L VC+QTY last month |
| APD_PL_0003 | ADP P&L VSE+QTY current month |
| APD_PL_0002 | ADP P&L VSE+QTY last 2 months |
| APD_PL_0008 | APD MM - SMOG Evolution |
| APD_PL_0009 | APD P&L - Contrib for Global Sales M (Solvay) |
| APD_PL_0012 | APD P&L - Contrib for Global Sales M-1 (Rhodia) |
APD_PL_0013 | APD P&L - Contrib for Global Sales M-1 (Solvay) |
APD_PL_0023 | APD P&L Smartfloat |
APD_PL_0022 | APD P&L: ICM Current month (Rhodia) |
Data Loading
Info providers and objects loaded
List on info providers inside the technical cockpit.
Main process chains are:
PC_COPA_PL_GLOBAL : Load WP1 & PF1 COPA, BFC and WP1 IM daily
PC_COPA_PL_22 : Load WP1 & PF1 COPA Extra load during closing period. This chain included too chain PC_COPA_PL_12, which load BFC File in WBP.
PC_COPA_PL_36 : Load PF1 IM and allocation of transportation costs PF1
PC_COPA_PL_09 : Load Non ERP Master data and Transactional data
Other chains:
| Process chain | Providers Loaded | Frequency | Time Start | Duration |
|---|---|---|---|---|
| PC_COPA_PL_03 | CRCOPA29 CRCOPA31 CRCOPA02 CRCOPA01 | Daily | Arround 1:20am | Arround 5 mins |
| PC_COPA_PL_12 | CRCOPA03 CRCOPA04 CRCOPA05 CRCOPA06 CRCOPA07 CRCOPA08 | Daily | Arround 2am | Arround 8 mins |
| PC_COPA_PL_20 | CRCOPA21 | Daily | Every hour | Arround 2 mins |
| PC_COPA_PL_21 | CRCOPA18 CRCOPA14 CRCOPA17 CRCOPA13 CRCOPA15 CRCOPA16 CRCOPA20 CRCOPA32 | Daily | Arround 2:15am | Arround 6 mins |
| PC_COPA_PL_32 | CRCOPA22 | Daily | Arround 1:10am | Arround 3 mins |
| PC_COPA_PL_33 | CRCOPA23 | Third and Fourth working day | Several execution between 2am and 4pm | Arround 5 mins |
| PC_COPA_PL_42 | CRCOPA26 | Third and Fourth working day | Several execution between 2am and 4pm | Arround 5 mins |
| PC_COPA_PL_45 | CRCOPA30 | Third and Fourth working day | Several execution between 2am and 4pm | Arround 8 mins |
| PC_GBR_14 | CRCOPA09 CRCOPA20 | Daily | Arround 3:40am | Arround 20 mins |
Reporting
Queries End User Documentation
All the reporting is available throught workbooks in the role "PL - P&L Reporting" ZR_RCS_CA_M12
Query documentation:
Reporting documentation drive folder:
https://drive.google.com/open?id=0B_p_Afe8sjVlN1J3YzYzdE8taDg
https://drive.google.com/open?id=0B_p_Afe8sjVlTEVnc3NjdDV5U0U
https://drive.google.com/drive/folders/1fZQwSGmRV3IuB1DlBf92ASEYatiSYNF6
Main queries
There are several queries but the main ones are:
BW_QRY_MVCOPA01_0001 BW P&L Query
BW_QRY_MVCOPA01_0002 BW P&L - Monthly Query
BW_QRY_MVCOPA01_0003 BW P&L Reconciliation Query
BW_QRY_MVCOPA01_0005 BW Integrated Contribution Margin Query
All queries use structures for key figures. There are many key figures, using calculated and restricted key figures inside.
Main functionnalities: Jump query available
Dependencies with other applications
List of APD:
APD_PL_0013
APD_PL_0023
APD_PL_0022
Loading frequency
WP1 and PF1(except for PF1 IM) are loaded daily at 1h30 am (french time) and also 4 other times between working day 2 and 4 (8am, 1pm, 3pm and 8pm, managed in c_glbfilt PL_ELEMENT/CHECK_LOAD).
...
PQ1 loading: on demand from PQ1 system => PQ1 is now decommissioned, no more loading
...
Flag intra gbu decision variant:
Inside the PC PC_COPA_PL_03 (WP1 P&L), the loadings of DBCOPA02 → DBCOPA02 and ABCOPA03 → ABCOPA03 to redetermine the flag intra GBU are only once a week, determined by enhanced decision variants that read the last week of redetermination using MD c_glbfilt ( stream = "PL_ELEMENT", rule = "INTGBU")
...
As part of the change # 4287353 , In the meta chain PC_COPA_PL_36,added the PC_COPA_PL_45 process chain after the execution of PC_COPA_PL_42.
Average performance
WP1: 1h40 for P&L and IM
PF1: 20min for COPA and 20min for IM
...
PQ1: 10min for GM and 1h for PCA
Record Keeping
We keep all records.
Dependencies with other applications
Broadcast
No broadcast
Open Hub
| Domain | OH | Name | Query | Target |
|---|---|---|---|---|
| Finance | OH_IMEP1 | IMEP-WP1/PF1dataforPCFOH | BW_QRY_MVCOPP01_0021 | Z_BW_PCF_IMEP |
| Finance | OH_SOL002 | Solstice:CPCOPA01 | BW_QRY_MVCOPA02_0002 | Z_SOLSTICE_OHSOL002_FILE |
APD
| DOMAIN | PROCESS | NAME | QUERY | TARGET | PC |
| Finance | APD_PL_0003 | ADP P&L VSE+QTY current month | APD_QRY_MVCOPA01_0001 | DPSDSO70 | PC_GL_SALES_APD0003 |
| Finance | APD_PL_0002 | ADP P&L VSE+QTY last 2 months | APD_QRY_MVCOPA01_0002 | DPSDSO69 | - |
| Finance | APD_PL_0001 | ADP P&L VC+QTY last month | APD_QRY_MVCOPA01_0003 | DPSDSO72 | - |
| Finance | APD_PL_0004 | ADP P&L VC+QTY current month | APD_QRY_MVCOPA01_0004 | DPSDSO73 | PC_GL_SALES_APD001 |
| Finance | APD_PL_0005 | ADP P&L Sales Contrib (current and last month) | APD_QRY_MVCOPA01_0005 | DPSDSO74 | PC_GL_SALES_APD_CONTRIB |
| Finance | APD_PL_0006 | ADP P&L Contrib (current month - Detailed) | APD_QRY_MVCOPA01_0007 | DPSDSO75 | PC_GL_SALES_APD_CONTRIB |
| Finance | APD_PL_0007 | ADP P&L Contrib (current month - Conso) | APD_QRY_MVCOPA01_0007 | DPSDSO95 | PC_GL_SALES_APD_CONTRIB |
| Finance | APD_PL_0009 | APD P&L - Contrib for Global Sales M (Solvay) | APD_QRY_MVCOPA01_0009 | DPSDSO81 | - |
| Finance | APD_PL_0010 | SPM - APD P&L (Rhodia) - curr + prev month | APD_QRY_MVCOPA01_0010 | DPSDSP10 | PC_SPM_TRANS_01 |
| Finance | APD_PL_0011 | SPM - APD P&L (Solvay) - curr + prev month | APD_QRY_MVCOPA01_0011 | DPSDSP11 | PC_SPM_TRANS_02 |
| Finance | APD_PL_0012 | APD P&L - Contrib for Global Sales M-1 (Rhodia) | APD_QRY_MVCOPA01_0013 | DPSDSO88 | - |
| Finance | APD_PL_0013 | APD P&L - Contrib for Global Sales M-1 (Solvay) | APD_QRY_MVCOPA01_0014 | DPSDSO89 | - |
| Finance | APD_PL_0022 | APD P&L: ICM Current month (Rhodia) | APD_QRY_MVCOPA01_0015 | DPSDSO95 | - |
| Finance | APD_PL_0020 | SPM - APD P&L (Rhodia) - any period | APD_QRY_MVCOPA01_0020 | DPSDSP10 | PC_SPM_RELOAD_01 |
| Finance | APD_PL_0021 | SPM - APD P&L (Solvay) - any period | APD_QRY_MVCOPA01_0021 | DPSDSP11 | - |
| Finance | APD_PL_0023 | APD P&L Smartfloat | APD_QRY_MVCOPA01_0023 | Z_BW_SMARTFLOAT_EXTRACT | PC_PL_APD0001 |
| Finance | APD_PL_GS_0030 | Netback Sales P&L | APD_QRY_MVCOPA01_NBACK_0001 | DPSDSO7A | PC_GL_SALES_APD030 |
| Finance | APD_PL_GS_0031 | Netback Sales P&L (w/o interval) | APD_QRY_MVCOPA01_NBACK_0002 | DPSDSO7A | - |
| Finance | ADP_DSO_DPCOPA08 | APD for DSO DPCOPA08 | BW_QRY_MVCOPA01_0011 | DPCOPA08 | PC_COPA_PL_23 PC_COPA_PL_42 PC_COPA_PL_25 |
| Dynasys | APD_DPS_DYNASYS_0023 | Dynasys - ICM COPA | BW_QRY_MVCOPA01_0027 | Z_BW_DYNASYS_ICM_COPA | PC_DPS_DYNASYS_09 |
| Dynasys | APD_DPS_DYNASYS_0046 | Dynasys - Contribution Margin SKU | BW_QRY_MVCOPA01_0029 | Z_BW_DYNASYS_CM_SKU | PC_DPS_DYNASYS_09 |
| EHS | APD_EHS_SVHC_001 | EHS - SVHC - Previous Month Sales | BW_QRY_MVCOPA01_EHS_001A | DPEHS024 | - |
| EHS | APD_EHS_SVHC_002 | EHS - SVHC - Quarterly Sales | BW_QRY_MVCOPA01_EHS_001B | DPEHS024 | - |
| EHS | APD_EHS_SHVC_003 | EHS - SVHC - Last 12 months Sales excluding current month | BW_QRY_MVCOPA01_EHS_001C | DPEHS024 | PC_EHS_SVHC_006 |
| Dynasys | APD_DPS_DYNASYS_0068 | Dynasys - Netback COPA | BW_QRY_MVCOPA01_NETBACK_0002 | Z_BW_DYNASYS_NETBACK | PC_DPS_DYNASYS_09 |
Maintenance
Known bugs
No known bug
...
| _BW_DYNASYS_NETBACK | PC_DPS_DYNASYS_09 |
Data Quality Control
Data come from SAP system. To compare data between BW and sources systems, check propagation layers.
Table KE30 can valid with P&L on non-console view.
Table CE1+ Operating concern in the source should be the same value as Propagation layer of COPA data.
Operational Documentation
Procedures
P&L : Non ERP transaction
https://drive.google.com/open?id=1gF426ok7VvnF1-idij_FCsMt7HMYQuY4LiN34CseSZs/file/d/1Mqb9wnFqnp2tl6j4AFKbWjm6BnDGSxPTQJHyOYvwspQ/view
P&L : Time reference for CICC and GM flat filesand GM flat files
https://drive.google.com/file/d/1EoZAjLveLXL2wASs1m-l1D8LO8l28y5A_Jze6sO-bS4/view
IM: Delta + full load of current and previous months.
Program for LER determination
https://drive.google.com/open?id=1cqPl_gkWdFubpTRyxbSaJtsa4iv8m4uH-bRT8dGOyoY/file/d/1VnOB0-jeV85c6kJYram-fuIh70U3gWU7LHiTHtB8e0I/view
https://drive.google.com/file/d/12hYsIOncEYpMI6aeOtjZtIHS3o2-GCLnnCZiKzJOUiU/viewIM: Delta + full load of current and previous months.
Program for LER determinationinfo providers
https://drive.google.com/open?id=1pEJTKs37dEloE7HGiY9lVsPf0crLoxxbzVN9oN33cr8
https://docs.google.com/spreadsheets/d/1jVkZGYuzpfkIfGY1Ob1AOMNQrhtNnO11xrquBBzAI3w/edit?usp=sharing
Program for LER info providers
https://drive.google.com/open?id=1-54NzGz63dagA-UyyIIoNgK8fwmzo-e-YAnASxInwjo
...
file/d/1AXQaMXmP4AdN9FeP8eByaRVQqDgs59BJBPL3NxSAhfc/view
Scheduling
<Describe the scheduling in place for the application (eg. existing jobs, trigger time/event based, dependencies)>
Monitoring
<Describe the monitoring checks to confirm the application is performing well (eg. check the overall status, check performance metrics like runtime/data volume/memory/disk/CPU, maintain and react to alerts/notifications)>
Error Handling
<Describe how to handle errors (eg. error codes, description and respective resolution, alert users)>
Known Bugs
<List the existing bugs, its criticity, workarounds and resolution plan.>
Roadmap
Todo list: https://drive.google.com/open?id=1GVVKIEbmSyeZx2lke4kmLg5MWHhjgsjka_7ewLcNGsYfile/d/1cvHfPpBByAQnYIZUZpvMkwFQmgmGESkSdrQrBhcTz9s/view