Co$ta - Flat Files loading

>> Back to the Co$ta project home page



The aim of this page is to describe how to upload flat files in Co$ta using the transaction ZBW_CUST_COSTA 


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 

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:

1. Adjust. Perimeter

  • Purpose: Upload perimeter changes in Co$ta to automate the calculation of restatements & enable efficient comparison of figures between 2 periods)
  • File & documentation is available here

Once the file is ready follow the procedure here to load the file

2. Corrective Flow 

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

Once the file is ready follow the procedure here to load the file

6. RCC determination

Once the file is ready follow the procedure here to load the file

7. Bridge Perimeter

  • Purpose: Restatements for destination Bridge
  • File & documentation is available here

Once the file is ready follow the procedure here to load the file

8. Excl Anaplan/F2G 

This transaction can only be used by DT team for the maintenance of Co$ta - Anaplan & F2G Scope


9. Corrective Destination Flow 

Upload a file


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 visualize the uploaded file.

    The transaction will then display the lines that have been retrieved from the file.

  • Click  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.

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

  • As soon as the file upload is completed, the data will be available in Co$ta - BW queries.
  • The data will not be available in Co$ta - Dashboard until a data refresh takes place.
  • If 2 users load a file at the exact same time (day/hour/min/sec) it is possible that both files appear as correctly loaded in the ‘History’ (see above) but that only one of them has actually been loaded. 



The history of the files loaded can be accessed by clicking on .