Tables associated with Transportation Charge Management for determining Charge Elements and Items

[jobyjohn]

TM is based on BOPF and its not always easy to retrieve the records from the tables. Sometime for any validation and for retrieving the records for multiple documents (Freight Units/Freight Orders/Freight Booking etc.) from BOBT using association becomes bit difficult, so we will be required to use Standard tables and relate with multiple associated tables to get the desired records.

In this blog, I am going to cover the tables which are required from the Charge Calculation perspective for the TOR objects and to navigate from the Freight Orders to multiple charge types and vice versa.

 Case-1) Navigating from the Freight Orders to different Charge types: -

Flowchart

In this section, I am going to cover the steps and the key values which needs to be passed to display the charge types from the below Freight Orders (#6100000783 and #6100000784).

Details from the Freight Orders

(**Screenshots from Demo System only for explanation purpose) 

Steps to be followed:-

• Pass the Freight Order(s) number in the table /SCMTMS/D_TORROT (Table for TOR Root Node)

• Get the DB_KEY for the Freight Order(s) from the table /SCMTMS/D_TORROT

• Pass the DB_KEY of the Freight Order obtained from previous steps to table /SCMTMS/D_TCHRGR as HOST_KEY

• Get the DB_KEY from the /SCMTMS/D_TCHRGR (Table for Transportation Charges Root)

• Pass the DB_KEY obtained from the previous step as PARENT_KET in table /SCMTMS/D_TCHRGI (Table for Charge Items)

• Get the DB_KEY from the table /SCMTMS/D_TCHRGI

• Pass the DB_KEY obtained from the previous step as PARENT_KEY in the table /SCMTMS/D_TCHRGE (Table for Item Charge Element)

• This will display all the charge types with all the details for the Freight Order(s)

Case-2) Navigating from the Charge types to relevant Freight Orders/Freight Booking/Freight Settlement Documents: -

Flowchart-

Steps to be followed: -

• Pass the Charge type(s) for which we want to determine the corresponding Freight Order/Freight Booking/Freight Settlement Documents in the table /SCMTMS/D_TCHRGE (Table for Item Charge Element)

• Get the PARENT_KEY from the table /SCMTMS/D_TCHRGE

• Pass the PARENT_KEY obtained from the previous step as DB_KEY in the table /SCMTMS/D_TCHRGI (Table for Charge Items)

• Get the HOST_KEY from the table /SCMTMS/D_TCHRGI

• HOST_KEY refers to the Freight Order/Freight Booking and the corresponding Freight Settlement Documents

• Pass the HOST_KEY for the entries which is having REF_KEY as null to /SCMTMS/D_TORROT as DB_KEY to get TOR_ID which refers to Freight Order(s)/Freight Booking(s)

• Pass the HOST_KEY for the entries which is having REF_KEY as not equal to null (pointing to corresponding TOR objects) to /SCMTMS/D_SF_ROT to get SFIR_ID which refers to Freight Settlement Document(s)

Some of the additional useful Tables from the Transportation Charge Management perspective

Table Name	Short Text
/SCMTMS/D_SCAH1	Transportation Scales Header
/SCMTMS/D_SCAIT2	Transportation Scales Item
/SCMTMS/D_TCSCTX	Scale Texts
/SCMTMS/D_TCRATE	Transportation Charges Rates
/SCMTMS/D_RATCTR	Rate contractors
/SCMTMS/D_TCRTTX	Rate Table Texts
/SCMTMS/D_TCRTSR	Rate Scale Reference
/SCMTMS/D_TCRTUC	Rate Scale Calc Method
/SCMTMS/D_TCRTVP	Validity Period For Rate
/SCMTMS/D_TCCSRT	Calculation Sheet Root
/SCMTMS/D_TCCSIT	Calculation Sheet Item
/SCMTMS/D_TCRULE	Calculation Rule
/SCMTMS/D_TCFRT	Freight Term for Calculation Sheet
/SCMTMS/D_TCINCT	Incoterm
/SCMTMS/D_TCCSTX	TCCS Texts
/SCMTMS/D_FAGROT	Freight Agreement Root Node
/SCMTMS/D_FAGITM	Freight Agreement Item
/SCMTMS/D_FAGPTY	Freight Agreement Party
/SCMTMS/D_TCHRA	Amount Rate Assignment
/SCMTMS/D_CHXRAT	Charge Element Exchange Rates
/SCMTMS/D_SF_ITM	SFIR Item Details
/SCMTMS/D_SF_APP	SFIR App log reference
/SCMTMS/D_SF_PTY	SFIR Party Details
/SCMTMS/D_SF_WFL	SFIR Workflow Items
/SCMTMS/D_SFIDOC	Document Reference for Item