Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.


HideElements
metastrue
breadcrumbtrue
titletrue



Co$ta - Flat Files loading

>> Back to the Co$ta project home page



Info
iconfalse
Excerpt

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: 

Table of Contents

OPEX - CAPEX

This table is used to manage the split CAPEX - OPEX in the dashboard Co$ta: button OPEX/CAPEX/Leases

Image Removed

Inflation

This table is used to upload the inflation rate that is used in the dashboard Co$ta: view Financial Evolution (€)

Image Removed

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

Image Removed

how to upload flat files in Co$ta using the transaction ZBW_CUST_COSTA 

Table of Contents
maxLevel1



Open the transaction in BW 

Open the SAP Logon Image Added and double click "BW - Production - WBP"

Image Added

Enter the transaction code ZBW_CUST_COSTA in the search bar and click Image Added

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)

Image Added


Select the file to be uploaded

Click on the file you want to upload:

Table of Contents
maxLevel3
minLevel3

Image Added

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

Image Added

2. Corrective Flow 

Image Added

3. Costs Sub Pak. ZBB

  • This transaction should not be used anymore

Image Added

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 Image Added 
  • To retrieve the snapshot use the BW query: Co$ta - BW Snapshot vs Current

Image Added

5. Invest reason WBS

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

Image Added

6. RCC determination

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

Image Added

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

Image Added

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 

Image Added

Anchor
upload
upload


Upload a file


Warning

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

  1. Select the file to be uploaded. 

Image Added

  • Click Image Added to visualize the uploaded file.

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

Image Added

  • Click Image Added 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."

Image Added

  • When the file is ready to be loaded, click Image Added.

A process chain will load data in BW side (it takes few seconds).

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

Image Added



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

Image Added