TVRAB
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)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| I_TransportRouteStage | view | from | BASIC | Transportation Route Stage |
Fields (22)
| Key | Field | Data Element | Description | Domain | Type | Length |
|---|---|---|---|---|---|---|
| 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
- Understanding Data Lineage in SAP S/4HANA
- SAP Tables vs CDS Views — Key Differences
- Understanding the SAP S/4HANA Data Model
- BSEG to ACDOCA: The Universal Journal Migration
- Business Partner Migration: KNA1/LFA1 to BUT000
- Material Document Migration: MSEG/MKPF to MATDOC
- How to Find the Right CDS View for an SAP Table
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA