View Source

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)

Finance Data & Reporting > Co$ta - Destination Correction file > Capture corrective destination file.PNG

Transaction ZBW_CUST_COSTA

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

Enter the transaction code ZBW_CUST_COSTA in the search bar and click

Click the button

Finance Data & Reporting > Co$ta - Destination Correction file > image2020-11-13_17-59-28.png

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

Finance Data & Reporting > Co$ta - Destination Correction file > Transaction dest correctice details.png

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

Finance Data & Reporting > Co$ta - Destination Correction file > image2020-11-13_18-13-55.png

Click to display the file.

Finance Data & Reporting > Co$ta - Destination Correction file > preview error.PNG

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."

Finance Data & Reporting > Co$ta - Destination Correction file > image2020-11-13_18-47-59.png

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

Finance Data & Reporting > Co$ta - Destination Correction file > Capture file in transaction .PNG

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

Finance Data & Reporting > Co$ta - Destination Correction file > Capture REPORT ORIGINE CORR DEST2.PNG

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