View Source

Table to be used when no transport cost can be calculated by Tiers

Definition

Average freight & duties can be determined:

Syensqo IS - Customer Support > A - Manual update of IM Transport Costs & Duties at plant level > image2023-3-8_14-44-39.png

Syensqo IS - Customer Support > A - Manual update of IM Transport Costs & Duties at plant level > image2023-3-8_14-45-24.png

Prepare the data to be uploaded in WBP using the dedicated template:

Syensqo IS - Customer Support > A - Manual update of IM Transport Costs & Duties at plant level > image2023-3-8_15-13-47.png

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

Syensqo IS - Customer Support > A - Manual update of IM Transport Costs & Duties at plant level > image2023-3-8_14-59-58.png

Syensqo IS - Customer Support > A - Manual update of IM Transport Costs & Duties at plant level > image2023-3-8_15-1-9.png

When the excel file was chosen, the button preview and check file are available.

“Preview” show the file uploaded:

Syensqo IS - Customer Support > A - Manual update of IM Transport Costs & Duties at plant level > image2023-3-8_15-1-59.png

Click . If the file was well prepared, the message "Your file is OK and ready to be loaded in BW." is displayed.

Syensqo IS - Customer Support > A - Manual update of IM Transport Costs & Duties at plant level > image2023-3-8_15-6-19.png

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.

Syensqo IS - Customer Support > A - Manual update of IM Transport Costs & Duties at plant level > image2023-3-8_15-7-13.png

Syensqo IS - Customer Support > A - Manual update of IM Transport Costs & Duties at plant level > image2023-3-8_15-16-50.png

Open the workbook BW_WBK_PL_0006 P&L Integrated Margin – Freight & Duties Costs Tab

Syensqo IS - Customer Support > A - Manual update of IM Transport Costs & Duties at plant level > image2023-3-8_15-20-22.png

Fill the prompt (at least the GBU and the period)

Syensqo IS - Customer Support > A - Manual update of IM Transport Costs & Duties at plant level > image2023-3-8_15-20-49.png

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)