TVRAB

Transparent Table Customizing Table
22 Fields 1 CDS Views

Route Stages

TVRAB is an SAP database table in S/4HANA. Route Stages. It contains 22 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_TransportRouteStage view from BASIC Transportation Route Stage

Fields (22)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY route ROUTE Route
KEY abnum RABNUM Stage number
anfrf ANFRF Itinerary
abcat ABCAT Route stage category
knanf KNOTA Departure point
knend KNOTZ Dest.point
knuzl KNOTU LoadTransfDest.
gesztd GESZTD Total duration
fahztd FAHZTD Travel Duration
distz DISTZ Distance
medst MEDST UoM-Distance
tdlnr TDLNR Service Agent
laufk LAUFK Leg indicator
sdabw SDABW Spec.Processing
tstyp TSTYP Stage category
spfbk FABKL Factory Calend.
spzst TSTRIDSD Working Times
vsart VERSART Shipping Type
frkrl FRKRL ShpmntCostsRel.
skalsm KALSM_TRAB Procedure
oij_tsyst OIJ_TSYST Trans system

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.

-- Route Stages
-- Category TRANSPARENT · Delivery class C
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE TVRAB (
    MANDT,      -- Client [MANDT]
    ROUTE,      -- Route [ROUTE]
    ABNUM,      -- Stage number [RABNUM]
    ANFRF,      -- Itinerary [ANFRF]
    ABCAT,      -- Route stage category [ABCAT]
    KNANF,      -- Departure point [KNOTA]
    KNEND,      -- Dest.point [KNOTZ]
    KNUZL,      -- LoadTransfDest. [KNOTU]
    GESZTD,     -- Total duration [GESZTD]
    FAHZTD,     -- Travel Duration [FAHZTD]
    DISTZ,      -- Distance [DISTZ]
    MEDST,      -- UoM-Distance [MEDST]
    TDLNR,      -- Service Agent [TDLNR]
    LAUFK,      -- Leg indicator [LAUFK]
    SDABW,      -- Spec.Processing [SDABW]
    TSTYP,      -- Stage category [TSTYP]
    SPFBK,      -- Factory Calend. [FABKL]
    SPZST,      -- Working Times [TSTRIDSD]
    VSART,      -- Shipping Type [VERSART]
    FRKRL,      -- ShpmntCostsRel. [FRKRL]
    SKALSM,     -- Procedure [KALSM_TRAB]
    OIJ_TSYST,  -- Trans system [OIJ_TSYST]
    PRIMARY KEY (MANDT, ROUTE, ABNUM)
);

Learn More