You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 5 Next »



Co$ta - Flat Files loading

>> Back to the Co$ta project home page



The aim of this page is to describe the transaction ZBW_CUST_COSTA that is used to upload the following flat files in Co$ta: 


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 :

Object TypeDimension codeLog SysWBS Element typeCO Order - Type - CodeCapex/Opex
CO Order - TypeC_COORDER__C_CORDTYP

WP1_400 

or 

PF1_020


Enter a CO Order type

ex: ZQUI

CAPEX-Invest
WBS Element - WBS Element typeC_WBS_EL2__C_WBSE_TP

Enter a WBS Element type

ex: IM


CAPEX-Invest

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 :

YEARCountry codeInflation (%) 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-PackageZBB

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):

GBUCost macro-packageCost packageCost subpackageCompany codePlantControlling areaResponsible cost center

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

...





...

2. Once the file is ready, follow the procedure here to upload it in BW.


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:

  1. CAPEX / OPEX
  2. Perc. Inflation
  3. Costs Sub Pak. ZBB
  4. Resp. Cost Center

Before starting, it is recommended to close and save your excel files to avoid interferences with excel

  1. 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).



  • No labels