| HideElements | ||||||
|---|---|---|---|---|---|---|
|
| Info | ||||||
|---|---|---|---|---|---|---|
| ||||||
| 2 | |||||
| minLevel | 2 |
OPEX - CAPEX
This table is used to manage the split CAPEX - OPEX in the dashboard Co$ta: button OPEX/CAPEX/Leases
→ Update the table in BW
1. Download the file here and update it with the list of CO Order type & WBS element type to be considered as CAPEX :
WP1_400
or
PF1_020
Enter a CO Order type
ex: ZQUI
Enter a WBS Element type
ex: IM
2. Once the file is ready, follow the procedure here to upload it in BW.
Inflation
This table is used to upload the inflation rate that is used in the dashboard Co$ta: view Financial Evolution (€)
→ Update the table in BW
1. Download the file here and update it with the inflation rate by country :
Inflation (%) Other
Enter a year
ex: 2020
Enter the country code or WW (WW is used by default when the country code doesn't exist)
ex: FR
Enter the inflation rate
ex: 2,5
Enter the inflation rate
ex: 2,5
...
2. Once the file is ready, follow the procedure here to upload it in BW.
Scope ZBB
This table is used to filter costs that are part of the scope ZBB (F2G - Fuel for Growth) in the dashboard Co$ta
→ Update the table in BW
1. Download the file here and update it with the list of subpackages in or out of the ZBB scope :
Enter the subpackage code
ex: P20001
Enter Yes or No
ex: No
2. Once the file is ready, follow the procedure here to upload it in BW.
Responsible cost center
|
Open the transaction in BW
Open the SAP Logon 
and double click "BW - Production - WBP"
Enter the transaction code ZBW_CUST_COSTA in the search bar and click 
| Warning |
|---|
If you can not access the transaction, you must create a ticket and ask for the role ZR_RCS_CA_M731 - CT - COSTA Transactions. (It is not a standard role, it is not in the list proposed in the form so you should request it in the field: SAP WBP - BW Business Warehouse : Comment) |
Select the file to be uploaded
Click on the file you want to upload:
| Table of Contents | ||||
|---|---|---|---|---|
|
2. Corrective Flow
- Purpose:Upload manual corrections in Co$ta
- File & documentation: Co$ta - Correction file
3. Costs Sub Pak. ZBB
- This transaction should not be used anymore
4. Snapshot
- Purpose:BW is doing a snapshot of Co$ta to facilitate the analysis of changes from period to another. There can be a need to do additional snapshots (e.g. before and after a loading in Qlik)
- To do a manual snapshot click the button
- To retrieve the snapshot use the BW query: Co$ta - BW Snapshot vs Current
5. Invest reason WBS
- Purpose: This table is a setting table to maintain the mapping of General reason for investment for WBS
- File & documentation: Co$ta - Investment reason for WBS
Once the file is ready follow the procedure here to load the file
1. Download the file here and update it with the list of combinations to be used for the determination of responsible cost centers (you can leave some fields blank):
- File & documentation: Co$ta - Responsible cost center FI or COPA
Once the file is ready follow the procedure here to load the file
Enter the BFC GBU code
ex: PE
Enter a macro-package
ex: P00003
Enter a package
ex: P10012
Enter a subpackage
ex: P20031
Enter a company code
ex: 0237
Enter a plant
ex: CJEI
Enter the controlling area corresponding to the company code
ex: CHEF
Enter the responsible cost center
ex: X481200000
load the file
9. Corrective Destination Flow
- Purpose:Upload manual corrections in Co$ta
- File & documentation: Co$ta - Destination Correction file
Open the SAP Logon and double click "BW - Production - WBP"
Enter the transaction code ZBW_CUST_COSTA in the search bar and click
Click on the file you want to upload:
- CAPEX / OPEX
- Perc. Inflation
- Costs Sub Pak. ZBB
- Resp. Cost Center
| Warning |
|---|
Before starting, it is recommended to close and save your excel files to avoid interferences with excel |
- Select the file to be uploaded.
- Click
to display the file. to visualize the uploaded file.The transaction will then display the lines that have been retrieved from the file.
- Click
to to check if the contents of the file are ok for upload and display possible errors. Errors will be displayed on a red background with a message explaining the issue.
If there are errors, they need to be fixed in the file, and the file needs to be reloaded before proceeding.
- consistency of the file. If there is no error, there is a message
If there are no errors, you will receive this message:
"Congratulations ! Your file is OK and ready to be loaded in BW."
- When the file is ready to be loaded, click
.
A process chain will load data in BW side (it takes few seconds).
| Warning |
|---|
|
The history of the files loaded can be accessed by clicking on 
.
