Screen shot mentioned in the above thread is misinterpreted......it is not possible to create multiple freight agreement using excel. that functionality is meant to download/upload rates for rates tables belonging to different agreement items.
You have to write your own upload programs to achieve this.
1) /SCMTMS?FREIGHTAGREEMENT: For forwarding and freight agreements and connecting TCCS which are referred under agreement items.
2) /SCMTMS/TCCS: For modelling calculation sheets and different charge types represented as TCCS line.
3) /SCMTMS/TC_RATES: For modelling rate tables including the rate values
4) /SCMTMS/TC_SCALE: For modelling scales, used to create a dimension of the rate tables which mainly represents the logistical values of different dimensions.
All the BOs have their own logic to perform different activities modelled in BOPF actions. So, to create a contract which is a combination of all the above BOs you have to write a report calling different actions available on each BO. You can use 'BOBF' t-code to check more details about these BOs.
You can follow top down (Agmnt-->TCCS-->Rates) or bottom up (Rate Table-->TCCS-->Agmnt) approach to model the contract programmatically. Generally speaking, it is quite a effort to create upload programs for contracts, unfortunately, there is no BAPI or FM available to perform all the above activities.
You need a BOPF resource who is aware of TM objects as well to perform this upload.
For uploading/updating the rates we have standard functionality 'excel integration' available under agreement and rate table directly.
Although, it depends upon your business requirement but I would suggest you to use other options to model the agreement and TCCS structure and later use standard rate table upload functionality.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.