Freight Order Update with Execution Information

[Former Member]

Hello Experts,

We need to update the Freight Order document with the Execution information stored through a Z-Table , we need to update through the Execution tab in Freight Order , is there a standard Function module that can help in such Requirement.

[Former Member · Accepted solution]

Hi,

Z - Table contains the following fields:

Freight Order number  , Source Location , Destination Location ,  Source location coordinates (Longitude & latitude) Actual Departure , Actual Arrival , whereas a customized job run to compare the truck actual coordinates coming from a GPS tracking system from /SCMTMS/RES_POS with Coordinates of Source and destination as to calculate the Actual arrival time and Departure.

when such calculation is done we need to update the /SCMTMS/D_TOREXE with actual departure and arrival through a standard way.

Reference to the document attached , /SCMTMS/CL_TOR_A_PROC_EXEC could be used with method  /BOBF/IF_FRW_ACTION~EXECUTE. .

Just to Check is such method used to update /SCMTMS/D_TOREXE with the Execution information., if not what is the method for that.

[former_member186607 · Accepted solution]

Hi,

methods of class /SCMTMS/CL_TOR_A_PROC_EXEC (actions EXECUTIONINFORMATION->PROCESS_EXEC_INFO and EXECUTIONINFORMATION->PROPAGATE_EXEC_INFO) are used to process the standard updates triggered by new/updated execution information and to propagate it to related freight documents.

If you want to create new entries in EXECUTIONINFORMATION (and therefore in /SCMTMS/D_TOREXE) you can try tu use action EXECUTIONINFORMATION_TR->REPORT_EVENT (class /SCMTMS/CL_TOR_A_EXI_REP_EVENT). This is the action that is used in the standard, when events are reported from the execution tab.

You have to build up new entry in transient node EXECUTIONINFORMATION and then call the action for this.

Best regards, Daniel

[former_member186607]

Hi,

can you maybe explain a few more details on this?

You want to report an event (execution information -> NODE EXECUTIONINFORMATION) on the freight order execution tab. The Z-Table you mention is related to the event or to the freight order? Which data (nodes) should be updated in the freight order as reaction to the new execution information?

Best regards, Daniel

[Former Member]

Hello,

Departure time , Arrival time per freight order is saved in a Z-table with combination of locations,

We need to insert such data with reference of Freight order number into Node Execution information that insert data into /SCMTMS/D_TOREXE , we need to use a standard way in such requirement , as to perform the system actions when such step is done through the Freight order screen manually.

[former_member186607]

Hi,

what do you mean with combination of locations exactly? What exactly is the gap to the standard solution , in which you report e.g. a Departure for a specific location (stop) of a freight order?

Are you using integration with SAP Event Management for the execution data or TM only?

If you are interested in possibilities on how to trigger additional actions as reaction to update/creation of EXECUTIONINFORMATION, please refer to chapter "Updating data in TM triggered by new execution event" in this document: http://scn.sap.com/docs/DOC-33550

Best regards, Daniel