Co$ta - Destination Correction file
>> Back to the Co$ta project home page
Prepare the file to be uploaded
Prepare the data to be uploaded in WBP using the dedicated template: zbw_cor_dest_costa (click the button 
to download the file)
Enter the transaction code ZBW_CUST_COSTA in the search bar and click 
Click the button 
A new window will open with the following fields
- Select the file to be loaded
- Click
to preview the file that was loaded - Click
to check if there are errors in the file - Click
to load the file once all errors are solved - Click
to see last files uploaded - Click
to leave the transaction
Upload the file
Before starting, it is recommended to close and save your excel files to avoid interferences with excel
- Select the file to be uploaded. For instance "zbw_cor_dest_costa 01.2020"
- Choose the excel file "zbw_cor_dest_costa 01.2020" that was prepared
- 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
.
The correction will be populated in the costa query within a couple of minutes after the file is loaded.
Check that the correction you made corresponds to what you wanted to do
How to check the correction
- Run the Co$ta - Destination BW queries with the scope of your correction (legal entity, period etc.)
- Remove all dimensions and add the Co$ta - Origin flow & filters & Actual Origin - Legal view (Local)
Corrections are made with the origin flow = CORR_DEST
Once you load the file in BW, it is immediatly populated in the query BW and the day after in the Co$ta - Dashboard. Make sure you have enough time to check the query BW before it is populated in the dashboard. Do not load the file in the evening and then check the result the day after !
What shall you do if there was a mistake in your file ?
You need to reload the same file with the new values. For instance if you load a file with the following posting:
| Cost element | Value |
|---|---|
| 98xxxxxxx | 100 |
| 98xxxxxxx | -100 |
But you realize that the posting is wrong you wanted to do the opposite then you should correct your file with the right posting and reload as below:
| Cost element | Value |
|---|---|
| 98xxxxxxx | -100 |
| 98xxxxxxx | 100 |
If you want to cancel the posting, then enter the following file
| Cost element | Value |
|---|---|
| 98xxxxxxx | 0 |
| 98xxxxxxx | 0 |