SAP ERPTMS_S_IV_REFERENCE E/A Fields for TM Document Reference Table data and field list

ERPTMS_S_IV_REFERENCE is a standard SAP Structure so does not store data like a database table does. It can be used to define the fields of other actual tables or to process "E/A Fields for TM Document Reference" Information within sap ABAP programs.

This is done by declaring abap internal tables, work areas or database tables based on this Structure. These can then be used to store and process the required data appropriately.

i.e. DATA: wa_ERPTMS_S_IV_REFERENCE TYPE ERPTMS_S_IV_REFERENCE.

The ERPTMS_S_IV_REFERENCE table consists of various fields, each holding specific information or linking keys about E/A Fields for TM Document Reference data available in SAP. These include TOR_ID (Freight Order), SFIR_ID (Freight Settlement Document), TSP_ID (Business Partner), BOL_ID (Bill of Lading)... See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .

ERPTMS_S_IV_REFERENCE structure Technical Details:

Delivery Class:
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)


SAP ERPTMS_S_IV_REFERENCE structure fields - Full list of fields found in SAP data dictionary

Looking for S/4HANA specific information? Click here to explore the details, fields and extensibility available for this table in the SAP S/4HANA version of the ERPTMS_S_IV_REFERENCE table. Also check whether the table still exists or has been transformed into a CDS view as part of the HANA simplifications.
Field Description Data Element Data Type length (Dec) Check table Conversion Routine Domain Name MemoryID SHLP
TM_REFERENCE_DOCUMENTReference Document Category (Transportation Mgmt) ERPTMS_TM_REFERENCETYPECHAR1ERPTMS_TM_REFERENCETYPE
TOR_IDFreight Order ERPTMS_TOR_IDCHAR20ALPHAERPTMS_DO_20
SFIR_IDFreight Settlement Document ERPTMS_SFIR_IDCHAR20ALPHAERPTMS_DO_20
TSP_IDBusiness Partner ERPTMS_PARTY_IDCHAR10ALPHAERPTMS_DO_10
BOL_IDBill of Lading ERPTMS_BOL_IDCHAR35ALPHAERPTMS_DO_35
AWB_IDAir Waybill ERPTMS_AWB_IDCHAR35ALPHAERPTMS_DO_35
FLIGHT_IDFlight Number ERPTMS_FLIGHT_IDCHAR7ALPHAERPTMS_DO_07
VOYAGE_IDVoyage Number ERPTMS_VOYAGE_IDCHAR10ALPHAERPTMS_DO_10
TM_SERVICE_PROVIDERReference Document Category of Transportation Management MRM_TM_REFERENCE_DOCUMENTCHAR51MRM_TM_REFERENCE_DOCUMENT
TM_ITEM_LIST_VERSIONLayout for Invoicing (Transportation Mgmt) ERPTMS_TM_ITEM_LIST_VERSIONCHAR30ERPTMS_TM_ITEM_LIST_VERSION
DOC_NUMBERDocument ID for TM Reference ERPTMS_TM_REFDOC_IDCHAR35ALPHAERPTMS_DO_35

Key field Non-key field



How do I retrieve data from SAP structure ERPTMS_S_IV_REFERENCE using ABAP code?

As ERPTMS_S_IV_REFERENCE is a database structure and not a table it does not store any data in the SAP data dictionary. The ABAP SELECT statement is therefore not appropriate and can not be performed on ERPTMS_S_IV_REFERENCE as there is no data to select.

How to access SAP table ERPTMS_S_IV_REFERENCE

Within an ECC or HANA version of SAP you can also view further information about ERPTMS_S_IV_REFERENCE and the data within it using relevant transactions such as

SE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).