Co$ta - Flat Files loading
>> Back to the Co$ta project home page
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:
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
6. RCC determination
- Purpose: This table is used to determine the responsible cost center when the origin flow is FI or COPA.
- File & documentation: Co$ta - Responsible cost center FI or COPA
Once the file is ready follow the procedure here to load the file
9. Corrective Destination Flow
- Purpose: Upload manual corrections in Co$ta
- File & documentation: Co$ta - Destination Correction file
Upload a file
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 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 
.
