Co$ta - Flat Files loading
>> Back to the Co$ta project home page
OPEX - CAPEX
By default only OPEX are displayed in the dashboard but it is possible to display all costs including CAPEX ( Capital Expenditure) & Capital Leases
Definition of CAPEX-Invest
All costs posted in a WBS element or a PM order (*) with the type IM - CAPEX (Invest.)
(*) The value IM is determined in BW and assigned to the Order, if the cost in the Order is fully or partially settled to a WBS element type IM - CAPEX (Invest.).
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 :
| YEAR | Country code | Inflation (%) labour | 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 :
| Cost Sub-Package | ZBB |
|---|---|
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
This table is used to determine the responsible cost center when the origin flow is FI or COPA.
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):
| GBU | Cost macro-package | Cost package | BFC Activity 1 | Company code | Plant | Controlling area | Responsible cost center |
|---|---|---|---|---|---|---|---|
Enter the BFC GBU code ex: PE | Enter a macro-package ex: P00003 | Enter a package ex: P10012 | Enter an Activity 1 ex: CSNR | 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 |
| ... | ... |
2. Once the file is ready, follow the procedure here to upload it in BW.
Investment reason for WBS
Upload a file 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 
Click on the file you want to upload:
- CAPEX / OPEX
- Perc. Inflation
- Costs Sub Pak. ZBB
- Resp. Cost Center
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.
- Click
to check the consistency of the file. If there is no error, there is a 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).
