Syensqo IS - Customer Support

Page tree

Versions Compared

Old Version 1

changes.mady.by.user ROLLIER, Charlotte

Saved on

compared with

New Version Current

changes.mady.by.user ROLLIER, Charlotte

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.


Info
titleInfo
Excerpt

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


Definition

Average freight & duties can be determined: 

  1. With a table manually maintained and uploaded in BW
  2. Using a calculation done in BW based on data coming from the application TIERS


Image Added

Image Added



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

Image Added


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  Image Added

Click on the button A - Manual update of IM Transport Costs & Duties at plant level

Image Added

  1. Select the file to be uploaded.

Image Added


Image Added

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

“Preview” show the file uploaded:

Image Added



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

Image Added

  • If there was an error in the file, the list of errors are displayed with the description of the problem to be solved. 
Note
  • 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.


Image Added

  • When the file is ready to be loaded, click Image Added. 

  • When the loading is finished a message appears

Image Added



Display the report in BW

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

Image Added

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

Image Added

There are 2 sheets in the file: Image Added