|
Prepare the file to be uploaded
Prepare the data to be uploaded in WBP using the dedicated template: zbw_cor_costa.xlsx (click the button 
to download the file)
The total of the column Q (=Actual) should be zero |
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
- Tick "By CostElmnt" if the cost element should be used for the determination of the subpackage or "By MatGroup" if the material should be used for the determination of the subpackage.
- 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
you can not use both methods with the same files. You need to create 2 files.
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_costa 01.2020"
- Choose the excel file "zbw_cor_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 - 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_FLOW |
- 1st control: Total of origin flow is zero
- 2nd control: Filter the list of origin objects you entered in your file (cost center/WBS or order). In the example the cost center is 2295-1020. You can also add the cost element, cost subpackage, vendor to confirm what is in the system.
In the example, the costs of the vendor 76467 in the cost center 2295-1020 was transferred from the cost element 98300330 to the cost element 98150940 and then from the cost package "Miscel Bk Charges" to "Out of Scope".
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 |