Co$ta - Non ERP - upload data
>> Back to the Co$ta project home page
Info
Procedure to upload manually data from systems not interfaced with WBP.
Prepare the file to be uploaded
Prepare the data to be uploaded in WBP using the dedicated template:
For Cost centers master data: TEMPLATE Cost Center Master Data
For Cost elements master data: TEMPLATE Cost Element Master Data
For Costs: TEMPLATE ZCBS_BW
Currency
The data currency comes from the PRS company code of the file.
Amounts are integer keyfigure
All amounts must be integer. No decimal (loading will be rejected)
Summation and overwriting
All amounts with the same key will be:
- added if they are in the same file
- overwritten if they are in a different file
Transaction ZBW_CBS
Open the SAP Logon 
and double click "BW - Production - WBP"
Enter the transaction code ZBW_CBS in the search bar and click 
A new window will open with the following fields
- Source = Source system. Enter ZCYT for Cytec.
- Click
to display the list of cost centers with the master data that were already loaded in BW or click 
to display the list of cost centers with the master data that were already loaded in BW. - Click
to export in excel the list of cost centers and 
to export in excel the list of cost elements. - Select the type of data to be loaded (costs or master data)
- 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
- Select the file to be uploaded. For instance "Cost Center Master data"
- Choose the excel file "Cost Center Master data" that was prepared
- Click . If the file was well prepared, the message "Congratulations ! Your file is OK and ready to be loaded in BW." is displayed.
- If there was an error in the file. the message " X errors in your file. Please correct it." is displayed. The list of errors are displayed with the description of the problem to be solved.
- When the file is ready to be loaded, click
. Once it is done a message is displayed to inform that the file was sent to BW and will be available in the reporting at the next data loading.
