TVRAB SAP (Route Stages) Table details
Dictionary Type: Table
Description: Route Stages
Description: Route Stages
Table field list including key, data, relationships and ABAP select examples
TVRAB is a standard SAP Table which is used to store Route Stages data and is available within R/3 SAP systems depending on the version and release level.
The TVRAB table consists of various fields, each holding specific information or linking keys about Route Stages data available in SAP. These include ROUTE (Route), ABNUM (Stage Number), ANFRF (Itinerary for regular route), ABCAT (Route stage category).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .
Delivery Class: C - Customising table, maintenance only by custDisplay/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)
SAP TVRAB table fields - Full list of fields found in SAP data dictionary
Field | Description | Data Element | Data Type | length (Dec) | Check table | Conversion Routine | Domain Name | MemoryID | SHLP |
MANDT | Client | MANDT | CLNT | 3 | T000 | MANDT | |||
ROUTE | Route | ROUTE | CHAR | 6 | TVRO | ROUTE | |||
ABNUM | Stage Number | RABNUM | NUMC | 4 | NUM4 | ||||
ANFRF | Itinerary for regular route | ANFRF | NUMC | 3 | ANFRF | ||||
ABCAT | Route stage category | ABCAT | NUMC | 1 | ABCAT | ||||
KNANF | Departure Point | KNOTA | CHAR | 10 | TVKN | KNOTN | |||
KNEND | Destination point | KNOTZ | CHAR | 10 | TVKN | KNOTN | |||
KNUZL | Destination of a load transfer point | KNOTU | CHAR | 10 | TVKN | KNOTN | |||
GESZTD | Total duration in calendar days | GESZTD | DEC | 11 | TSTRG | TSTRDURAG | |||
FAHZTD | Travel duration as actual time (hours/minutes) | FAHZTD | DEC | 11 | TSTRN | TSTRDURAN | |||
DISTZ | Distance | DISTZ | QUAN | 13(3) | MENG13 | ||||
MEDST | Unit of measure for distance | MEDST | UNIT | 3 | T006 | CUNIT | MEINS | ||
TDLNR | Number of forwarding agent | TDLNR | CHAR | 10 | LFA1 | ALPHA | LIFNR | LIF | F4_CARRIERS |
LAUFK | Leg Indicator | LAUFK | CHAR | 1 | LAUFK | ||||
SDABW | Special processing indicator | SDABW | CHAR | 4 | TVSAK | SDABW | |||
TSTYP | Stage category | TSTYP | CHAR | 1 | TSTYP | ||||
SPFBK | Factory calendar key | FABKL | CHAR | 2 | TFACD | WFCID | |||
SPZST | Working time from sales view | TSTRIDSD | CHAR | 10 | TTSTRSD | TSTRID | |||
VSART | Shipping type | VERSART | CHAR | 2 | T173 | VERSART | |||
FRKRL | Shipment costs relevance | FRKRL | CHAR | 1 | FRKRL | ||||
SKALSM | Pricing procedure in stage of shipment | KALSM_TRAB | CHAR | 6 | T683 | KALSM | |||
OIJ_TSYST | Transport system | OIJ_TSYST | CHAR | 10 | OIJTS | OIJ_TSYST | OIW |
Key field | Non-key field |
How do I retrieve data from SAP table TVRAB using ABAP code
The following ABAP code Example will allow you to do a basic selection on TVRAB to SELECT all data from the tableDATA: WA_TVRAB TYPE TVRAB.
SELECT SINGLE *
FROM TVRAB
INTO CORRESPONDING FIELDS OF WA_TVRAB
WHERE...
How to access SAP table TVRAB
Within an ECC or HANA version of SAP you can also view further information about TVRAB and the data within it using relevant transactions such asSE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).
Search for further information about these or an SAP related objects