Info
Table to be used when no transport cost can be calculated by Tiers
Definition
Average freight & duties can be determined:
- With a table manually maintained and uploaded in BW
- Using a calculation done in BW based on data coming from the application TIERS
How to upload the the manual table in BW
Prepare the file to be uploaded
Prepare the data to be uploaded in WBP using the dedicated template:
A - Manual update of IM Transport Costs & Duties at plant level.xlsx
Upload the file
Once everthing is ready, open WBP and enter the transaction ZBW_INT_MARGIN - Integrated margin process in the search bar and enter 
Click on the button A - Manual update of IM Transport Costs & Duties at plant level
- Select the file to be uploaded.
When the excel file was chosen, the button preview and check file are available.
“Preview” show the file uploaded:
- Click
. If the file was well prepared, the message "Your file is OK and ready to be loaded in BW." is displayed.
- If there was an error in the file, the list of errors are displayed with the description of the problem to be solved.
- Date format should be YYYYMMDD.
- Destination Plant is used an authorisation scope derived with respect to GBU’s assigned to User.
- GBU’s assigned to User are derived using Function Module RSSB_AUTHORIZATIONS_OF_USER, input is SAP user id and output is multiple single GBU’s or ‘*’ (access to all GBU’s).
- Master data checks with respect to fields destination plant, Departure plant, Unit and Currency are validated from BW master tables.
- GBU’s destination plant error: “'User has no authorization for the Destination plant’”, This error is due to destination plant authorization not available with respect to GBU’s assigned to User.
- If any of the above fields are not available with respect to file data, error message ‘fieldname’ information does not exist.
- All Mandatory fields are validated to address special characters.
'ABCDEFGHIJKLMNÑOPQRSTUVWXYZ!"#$%&/()=?¡¨][ :;^` |° %$#@(){}[]<>,.?/’.
- Check file can identify erroneous records caused to be highted in red. Until the records are corrected with respect to above all conditions. They will be highlighted in RED colour.
- When the file is ready to be loaded, click
. When the loading is finished a message appears
Display the report in BW
Open the workbook BW_WBK_PL_0006 P&L Integrated Margin – Freight & Duties Costs Tab
Fill the prompt (at least the GBU and the period)
There are 2 sheets in the file: 
- Default Freight Cost - Table uploaded with transaction A - Manual update of IM Transport Costs & Duties at plant level
- Freight (TIERS) & Duties - Calculation done by BW based on TIERS (only when activated)
The best way to get IT support is to use the new
Service One Platform.