TVRO

Transparent Table Customizing Table
22 Fields 4 CDS Views

Routes

TVRO is an SAP database table in S/4HANA. Routes. It contains 22 fields. 4 CDS views read from this table.

CDS Views using this table (4)

ViewTypeJoinVDMDescription
I_ACMRoute view from BASIC ACM Route Master data
I_Route view from BASIC Route
I_TransportRoute view from BASIC Transportation Route
I_TripRouteVH view from BASIC Value Help for Routes

Fields (22)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY route ROUTE Route
trazt TRAZT Transit time
traztd TRAZTD Transit Time
tdvzt TDVZT Trans.lead time
tdvztd TDVZTD Trans.Lead Time
tdvznd TDVZND Tr.Lead Time Hr
spfbk FABKL Factory Calend.
expvz EXPVZ Mode of Trans.
tdiix TDIIX Rel.transport
spzst TSTRIDSD Working Times
fahztd FAHZTD Travel Duration
distz DISTZ Distance
medst MEDST UoM-Distance
vsart VERSART Shipping Type
vsavl VERSARTVL ShTypePrelimLeg
vsanl VERSARTNL SubseqLegShType
tdlnr TDLNR Service Agent
routid ROUTID Route Identific.
tctab ADGE_TCTAB TransCtry/RgTab
allowed_twgt ALLOWED_TWGT Allow.Tot. Wght
allowed_uom ALLOWED_UOM UoM for tot.wgt

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
-- Category TRANSPARENT · Delivery class C
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE TVRO (
    MANDT,         -- Client [MANDT]
    ROUTE,         -- Route [ROUTE]
    TRAZT,         -- Transit time [TRAZT]
    TRAZTD,        -- Transit Time [TRAZTD]
    TDVZT,         -- Trans.lead time [TDVZT]
    TDVZTD,        -- Trans.Lead Time [TDVZTD]
    TDVZND,        -- Tr.Lead Time Hr [TDVZND]
    SPFBK,         -- Factory Calend. [FABKL]
    EXPVZ,         -- Mode of Trans. [EXPVZ]
    TDIIX,         -- Rel.transport [TDIIX]
    SPZST,         -- Working Times [TSTRIDSD]
    FAHZTD,        -- Travel Duration [FAHZTD]
    DISTZ,         -- Distance [DISTZ]
    MEDST,         -- UoM-Distance [MEDST]
    VSART,         -- Shipping Type [VERSART]
    VSAVL,         -- ShTypePrelimLeg [VERSARTVL]
    VSANL,         -- SubseqLegShType [VERSARTNL]
    TDLNR,         -- Service Agent [TDLNR]
    ROUTID,        -- Route Identific. [ROUTID]
    TCTAB,         -- TransCtry/RgTab [ADGE_TCTAB]
    ALLOWED_TWGT,  -- Allow.Tot. Wght [ALLOWED_TWGT]
    ALLOWED_UOM,   -- UoM for tot.wgt [ALLOWED_UOM]
    PRIMARY KEY (MANDT, ROUTE)
);

Learn More