ERPTM_IV_DATA

Transparent Table Application Table
53 Fields 1 CDS Views

TM 8.0 TCM-ERP Invoice Integration Data Table

ERPTM_IV_DATA is an SAP database table in S/4HANA. TM 8.0 TCM-ERP Invoice Integration Data Table. It contains 53 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_TranspInvcPreparationData view from BASIC TM and PO Data for Invoice Preperation

Fields (53)

KeyField Data ElementDescription DomainTypeLength
KEY client MANDT Client
KEY po_id EBELN Purchasing Doc.
KEY po_item EBELP Item
tor_id ERPTMS_TOR_ID Freight Order
tor_item ERPTMS_TOR_ITEM Fr.Order Item
tsp_id ERPTMS_PARTY_ID Business Partner
bol_id ERPTMS_BOL_ID Bill of Lading
awb_id ERPTMS_AWB_ID Air Waybill
flight_id ERPTMS_FLIGHT_ID Flight Number
voyage_id ERPTMS_VOYAGE_ID Voyage Number
sfir_id ERPTMS_SFIR_ID Freight Sett. Doc.
sfir_item ERPTMS_SFIR_ITEM Item
ivp_id ERPTMS_PARTY_ID Business Partner
logsys LOGSYS Logical system
srce_loc ERPTMS_SRCE_LOC Source Location
dest_loc ERPTMS_DEST_LOC Destination Location
del_d ERPTMS_DELV_D Arrival Date
pickup_d ERPTMS_PICKUP_D Departure Date
cpudt ERPTMS_DATE Entry Date
cputm ERPTMS_TIME Entry Time
freightagrmt_id ERPTMS_FRAGR_ID Freight Agrmt
loading_meter ERPTMS_LOAD_METER Loading Meter
distance ERPTMS_DISTANCE Distance
dist_uom ERPTMS_DISTANCE_UOM Distance UOM
shipper ERPTMS_SHIPPER Shipper
consignee ERPTMS_CONSIGNEE Consignee
vehicle_id ERPTMS_VEHICLE_ID Vehicle
equipment_type ERPTMS_EQUI_TYPE Equipment Type
pricing_ind ERPTMS_PRICING_IND Pric. Indicator
chrg_due_code ERPTMS_CHRG_DUE_CODE Charges Due Code
srce_ctry ALAND Dep. Ctry/Reg.
dest_ctry LLAND Dest. Ctry/Reg
tor_src_ctry ALAND Dep. Ctry/Reg.
tor_dest_ctry LLAND Dest. Ctry/Reg
product_id ERPTMS_PRD_ID Product
package_id ERPTMS_PACK_ID Package ID
shipping_type ERPTMS_SHIPPING_TC Shipping TC
platenumber ERPTMS_RESPLATENR Registration Number
tor_src_loc ERPTMS_SRCE_LOC Source Location
tor_dest_loc ERPTMS_DEST_LOC Destination Location
accr_proc_var TCM_ACCRUAL_PROC_VAR Accrual process var
tor_del_d ERPTMS_DELV_D Arrival Date
tor_pickup_d ERPTMS_PICKUP_D Departure Date
total_distance ERPTMS_DISTANCE Distance
total_distance_uom ERPTMS_DISTANCE_UOM Distance UOM
trmodcat ERPTMS_TRMODCAT TrM Category
charge_type ERPTMS_TRCHARG_ELMNT_TYPECD Charge Type
tor_stpsucc_id ERPTMS_SUCC_ID Stage ID
container_id ERPTMS_CONTAINER_ID Conatiner ID
resource_type ERPTMS_RESOURCE_TYPE Equip.Type
resource_id ERPTMS_RESOURCE_ID Equip.Type
inactive ERPTMS_INACTIVE Inactive Prep.
dummy XFELD Checkbox

Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.

-- TM 8.0 TCM-ERP Invoice Integration Data Table
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE ERPTM_IV_DATA (
    CLIENT,              -- Client [MANDT]
    PO_ID,               -- Purchasing Doc. [EBELN]
    PO_ITEM,             -- Item [EBELP]
    TOR_ID,              -- Freight Order [ERPTMS_TOR_ID]
    TOR_ITEM,            -- Fr.Order Item [ERPTMS_TOR_ITEM]
    TSP_ID,              -- Business Partner [ERPTMS_PARTY_ID]
    BOL_ID,              -- Bill of Lading [ERPTMS_BOL_ID]
    AWB_ID,              -- Air Waybill [ERPTMS_AWB_ID]
    FLIGHT_ID,           -- Flight Number [ERPTMS_FLIGHT_ID]
    VOYAGE_ID,           -- Voyage Number [ERPTMS_VOYAGE_ID]
    SFIR_ID,             -- Freight Sett. Doc. [ERPTMS_SFIR_ID]
    SFIR_ITEM,           -- Item [ERPTMS_SFIR_ITEM]
    IVP_ID,              -- Business Partner [ERPTMS_PARTY_ID]
    LOGSYS,              -- Logical system [LOGSYS]
    SRCE_LOC,            -- Source Location [ERPTMS_SRCE_LOC]
    DEST_LOC,            -- Destination Location [ERPTMS_DEST_LOC]
    DEL_D,               -- Arrival Date [ERPTMS_DELV_D]
    PICKUP_D,            -- Departure Date [ERPTMS_PICKUP_D]
    CPUDT,               -- Entry Date [ERPTMS_DATE]
    CPUTM,               -- Entry Time [ERPTMS_TIME]
    FREIGHTAGRMT_ID,     -- Freight Agrmt [ERPTMS_FRAGR_ID]
    LOADING_METER,       -- Loading Meter [ERPTMS_LOAD_METER]
    DISTANCE,            -- Distance [ERPTMS_DISTANCE]
    DIST_UOM,            -- Distance UOM [ERPTMS_DISTANCE_UOM]
    SHIPPER,             -- Shipper [ERPTMS_SHIPPER]
    CONSIGNEE,           -- Consignee [ERPTMS_CONSIGNEE]
    VEHICLE_ID,          -- Vehicle [ERPTMS_VEHICLE_ID]
    EQUIPMENT_TYPE,      -- Equipment Type [ERPTMS_EQUI_TYPE]
    PRICING_IND,         -- Pric. Indicator [ERPTMS_PRICING_IND]
    CHRG_DUE_CODE,       -- Charges Due Code [ERPTMS_CHRG_DUE_CODE]
    SRCE_CTRY,           -- Dep. Ctry/Reg. [ALAND]
    DEST_CTRY,           -- Dest. Ctry/Reg [LLAND]
    TOR_SRC_CTRY,        -- Dep. Ctry/Reg. [ALAND]
    TOR_DEST_CTRY,       -- Dest. Ctry/Reg [LLAND]
    PRODUCT_ID,          -- Product [ERPTMS_PRD_ID]
    PACKAGE_ID,          -- Package ID [ERPTMS_PACK_ID]
    SHIPPING_TYPE,       -- Shipping TC [ERPTMS_SHIPPING_TC]
    PLATENUMBER,         -- Registration Number [ERPTMS_RESPLATENR]
    TOR_SRC_LOC,         -- Source Location [ERPTMS_SRCE_LOC]
    TOR_DEST_LOC,        -- Destination Location [ERPTMS_DEST_LOC]
    ACCR_PROC_VAR,       -- Accrual process var [TCM_ACCRUAL_PROC_VAR]
    TOR_DEL_D,           -- Arrival Date [ERPTMS_DELV_D]
    TOR_PICKUP_D,        -- Departure Date [ERPTMS_PICKUP_D]
    TOTAL_DISTANCE,      -- Distance [ERPTMS_DISTANCE]
    TOTAL_DISTANCE_UOM,  -- Distance UOM [ERPTMS_DISTANCE_UOM]
    TRMODCAT,            -- TrM Category [ERPTMS_TRMODCAT]
    CHARGE_TYPE,         -- Charge Type [ERPTMS_TRCHARG_ELMNT_TYPECD]
    TOR_STPSUCC_ID,      -- Stage ID [ERPTMS_SUCC_ID]
    CONTAINER_ID,        -- Conatiner ID [ERPTMS_CONTAINER_ID]
    RESOURCE_TYPE,       -- Equip.Type [ERPTMS_RESOURCE_TYPE]
    RESOURCE_ID,         -- Equip.Type [ERPTMS_RESOURCE_ID]
    INACTIVE,            -- Inactive Prep. [ERPTMS_INACTIVE]
    DUMMY,               -- Checkbox [XFELD]
    PRIMARY KEY (CLIENT, PO_ID, PO_ITEM)
);

Learn More