TVTR

Transparent Table Customizing Table
8 Fields 6 CDS Views

Routes: Modes of Transport

TVTR is an SAP database table in S/4HANA. Routes: Modes of Transport. It contains 8 fields. 6 CDS views read from this table.

CDS Views using this table (6)

ViewTypeJoinVDMDescription
/SCMTMS/CV_RsceEquiTransRoot view left_outer Obsolete: Use CDS View /SCMTMS/VE_ReTRt
/SCMTMS/VE_RETRT view_entity left_outer BOPF: TRansaction Resource Root
I_ModeOfTransportVH view from BASIC I_MODEOFTRANSPORTVH
I_OIL_ModesOfTransportVH view_entity from BASIC Routes Modes of Transport
I_TransportationMode view_entity from BASIC Transportation Mode
P_ACMModeOfTransport view from BASIC

Fields (8)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY vktra VKTRA Mode of Transp.
vktrt THME_MOT DG MoT Cat.
trmodcat /SAPAPO/TRMODCAT TMode Category
main_carriage /SAPAPO/TRMOD_MAIN_CARRIAGE Main Carriage
dist_emission_factor /SCMB/DE_DIST_EMISSION_FACTOR Sustain. Category
default_mtr /SAPAPO/TR_TRATY Means of Trans.
oijmti OIJ_TSWMTI TSW mode/transp

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.

-- Routes: Modes of Transport
-- Category TRANSPARENT · Delivery class C
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE TVTR (
    MANDT,                 -- Client [MANDT]
    VKTRA,                 -- Mode of Transp. [VKTRA]
    VKTRT,                 -- DG MoT Cat. [THME_MOT]
    TRMODCAT,              -- TMode Category [/SAPAPO/TRMODCAT]
    MAIN_CARRIAGE,         -- Main Carriage [/SAPAPO/TRMOD_MAIN_CARRIAGE]
    DIST_EMISSION_FACTOR,  -- Sustain. Category [/SCMB/DE_DIST_EMISSION_FACTOR]
    DEFAULT_MTR,           -- Means of Trans. [/SAPAPO/TR_TRATY]
    OIJMTI,                -- TSW mode/transp [OIJ_TSWMTI]
    PRIMARY KEY (MANDT, VKTRA)
);

Learn More