TVTK SAP (Shipment Types) Table details
Dictionary Type: Table
Description: Shipment Types
Description: Shipment Types
Table field list including key, data, relationships and ABAP select examples
TVTK is a standard SAP Table which is used to store Shipment Types data and is available within R/3 SAP systems depending on the version and release level.
The TVTK table consists of various fields, each holding specific information or linking keys about Shipment Types data available in SAP. These include SHTYP (Shipment type), VBTYP (SD document category), NUMKI (Number range in the case of internal number assignment), NUMKE (Number range in the case of external number assignment).. 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: G - Customising table which is protected against SAP UpdateDisplay/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type)
Text table = TVTKT
SAP TVTK 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 | |||
SHTYP | Shipment type | SHTYP | CHAR | 4 | SHTYP | TSH | |||
VBTYP | SD document category | VBTYP | CHAR | 1 | VBTYP | ||||
NUMKI | Number range in the case of internal number assignment | NUMKI | CHAR | 2 | NUMKR | ||||
NUMKE | Number range in the case of external number assignment | NUMKE | CHAR | 2 | NUMKR | ||||
KOPGR | Screen sequence group in doc. header | KOPGR | CHAR | 4 | KOPGR | ||||
STERM | Leg determination | STERM | CHAR | 1 | STERM | ||||
ABFER | Shipment completion type | ABFER | CHAR | 1 | ABFER | ||||
ABWST | Processing control | ABWST | CHAR | 1 | ABWST | ||||
BFART | Service Level | BFART | CHAR | 1 | BFART | ||||
VSART | Shipping type | VERSART | CHAR | 2 | T173 | VERSART | |||
VSAVL | Shipping type of preliminary leg | VSAVL | CHAR | 2 | T173 | VERSART | |||
VSANL | Shipping type of subsequent leg | VSANL | CHAR | 2 | T173 | VERSART | |||
LAUFK | Leg Indicator | LAUFK | CHAR | 1 | LAUFK | ||||
KALSM | Output determination procedure | KALSMB | CHAR | 6 | T683 | KALSM | |||
KAPPL | Application for output conditions | NA_KAPPL | CHAR | 2 | T681A | KAPPL | NA_KAPPL | ||
TXTGR | Text determination procedure | TXTGR | CHAR | 2 | TTXG | TXTGR | |||
PARGR | Partner Determination Procedure | PARGR | CHAR | 4 | TVPG | PARGR | |||
SVTRA | Selection variant for transportation planning | SVTRA | CHAR | 14 | RALDB_VARI | TSV | |||
PROFIDNETZ | Network profile | PROFIDNZPL | CHAR | 7 | TCN41 | PROFILID | PNW | ||
DTMEG | Unit of Weight for Transportation Planning | DTMEG | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
DTMEV | Volume Unit for Transportation Planning | DTMEV | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
KSCHL | Output Type | NA_KSCHL | CHAR | 4 | Assigned to domain | KSCHL | NAC | CSH_NA_KSCHL | |
ROUTE_VLF | Indicator: Proposed route from delivery | ROUTE_VLF | CHAR | 1 | XFELD | ||||
SPEDI_VLF | Indicator: Proposed forwarding agent from delivery | SPEDI_VLF | CHAR | 1 | XFELD | ||||
ABF_ACTPRF | Actions to be carried out for completing a shipment | ABF_ACTPRF | CHAR | 14 | RALDB_VARI | ||||
FKART | Shipment cost type | FKART_T | CHAR | 4 | TVTF | FKART_T | FRK | ||
STGTA | Shipment: statistics group, shipment type | STGTA | CHAR | 2 | VTSGT | STGTA | |||
FRKRL | Proposal freight costs relevance, Shipment header | FRKRL_KOP | CHAR | 1 | FRKRL | ||||
FRKRL_STR | Proposal freight costs relevance, shipment leg | FRKRL_STR | CHAR | 1 | FRKRL | ||||
FRKRL_UMP | Proposal for shipment costs relevance - Load transfer point | FRKRL_UMP | CHAR | 1 | FRKRL | ||||
FRKRL_GRP | Proposal for freight costs relevance, Border cross.pt | FRKRL_GRP | CHAR | 1 | FRKRL | ||||
ROUTE_STAG | Adopt stages from route into shipment | ROUTE_STAG | CHAR | 1 | ROUTE_STAG | ||||
CHGDOC_SHTYP | Indicator: Change document shipment for shipment type | CHGDOC_SHTYP | CHAR | 1 | XFELD | ||||
DIS_ACTPRF | Activities to be performed for planning a shipment | DIS_ACTPRF | CHAR | 14 | RALDB_VARI | ||||
REG_ACTPRF | Activites to be carried out at shipment check-in | REG_ACTPRF | CHAR | 14 | RALDB_VARI | ||||
LBG_ACTPRF | Activities to be performed at start of shipment loading | LBG_ACTPRF | CHAR | 14 | RALDB_VARI | ||||
LEN_ACTPRF | Activities to be performed at loading finish of shipment | LEN_ACTPRF | CHAR | 14 | RALDB_VARI | ||||
TBG_ACTPRF | Activites to be carried out at the beginning of a shipment | TBG_ACTPRF | CHAR | 14 | RALDB_VARI | ||||
TEN_ACTPRF | Activities to be carried out at the end of a shipment | TEN_ACTPRF | CHAR | 14 | RALDB_VARI | ||||
PLANNING_PROFILE | Planning profile for transportation planning | PLANNING_PROFILE | CHAR | 14 | RALDB_VARI | TSV | |||
TSEGTP | Time segment event group shipment header | TSEGTPLVTT | CHAR | 10 | TTSEGTPLH | TMPLA | TSEGTEMPLA | ||
KOPRF | Control Indicator for Pick Check in Shipment | KOPRF | CHAR | 1 | KOPRF | ||||
TERMIN_VLF | Indicator: Proposal for deadlines from deliveries | TERMIN_VLF | CHAR | 1 | XFELD | ||||
TRINF_UEB | Data transfer | TRINF_UEB | NUMC | 3 | Assigned to domain | GRPNO | |||
PMODE_VD | Delivery Split Profile Before Transportation Planning | LEDSPD_PMODE_TRA1 | CHAR | 4 | TVDSS | LEDSPD_PMODE | |||
PMODE_ND | Delivery Split Profile after Transportation Planning | LEDSPD_PMODE_TRA2 | CHAR | 4 | TVDSS | LEDSPD_PMODE | |||
KZHULFR | Indicator: HUs Relevant for Delivery Item Generation | KZHULFR | CHAR | 1 | KZHULFR | ||||
VTDWM | Distribution Control: Decentralized WMS | VTDWM | CHAR | 1 | VTDWM | ||||
BORGR_PROCTYP | GR-Relevance Indicator | BORGR_PROCTYP | CHAR | 2 | BORGR_PROCTYP | ||||
BORGR_AUTO_REG | Automatic Registration for the Status of the Inb. Deliveries | BORGR_AUTO_REG | CHAR | 1 | CHAR1 | ||||
BORGR_AUTO_LEN | Aut. 'Loading end' From the Status of the Inb. Deliveries | BORGR_AUTO_LEN | CHAR | 1 | CHAR1 | ||||
BORGR_EXTI1_UNQ | Uniqueness of the External ID | BORGR_EXID_UNIQUE | CHAR | 1 | BORGR_EXID_UNIQUE | ||||
BORGR_EXTI1_MUST | Required Entry | BORGR_EXID_MUST | CHAR | 1 | BORGR_EXID_MUST | ||||
BORGR_EXTI1_EEDI | Ty.of Error Message when ID Transferred by EDI is not Unique | BORGR_EXID_ERREDI | CHAR | 1 | BORGR_EXID_ERRTYP | ||||
BORGR_EXTI1_EDIA | Type of Error Message when Online ID is not Unique | BORGR_EXID_ERRDIA | CHAR | 1 | BORGR_EXID_ERRTYP | ||||
BORGR_EXTI2_UNQ | Uniqueness of the External ID | BORGR_EXID_UNIQUE | CHAR | 1 | BORGR_EXID_UNIQUE | ||||
BORGR_EXTI2_MUST | Required Entry | BORGR_EXID_MUST | CHAR | 1 | BORGR_EXID_MUST | ||||
BORGR_EXTI2_EEDI | Ty.of Error Message when ID Transferred by EDI is not Unique | BORGR_EXID_ERREDI | CHAR | 1 | BORGR_EXID_ERRTYP | ||||
BORGR_EXTI2_EDIA | Type of Error Message when Online ID is not Unique | BORGR_EXID_ERRDIA | CHAR | 1 | BORGR_EXID_ERRTYP | ||||
BORGR_SIGNI_UNQ | Uniqueness of the External ID | BORGR_EXID_UNIQUE | CHAR | 1 | BORGR_EXID_UNIQUE | ||||
BORGR_SIGNI_MUST | Required Entry | BORGR_EXID_MUST | CHAR | 1 | BORGR_EXID_MUST | ||||
BORGR_SIGNI_EEDI | Ty.of Error Message when ID Transferred by EDI is not Unique | BORGR_EXID_ERREDI | CHAR | 1 | BORGR_EXID_ERRTYP | ||||
BORGR_SIGNI_EDIA | Type of Error Message when Online ID is not Unique | BORGR_EXID_ERRDIA | CHAR | 1 | BORGR_EXID_ERRTYP | ||||
BORGR_TPBEZ_UNQ | Uniqueness of the External ID | BORGR_EXID_UNIQUE | CHAR | 1 | BORGR_EXID_UNIQUE | ||||
BORGR_TPBEZ_MUST | Required Entry | BORGR_EXID_MUST | CHAR | 1 | BORGR_EXID_MUST | ||||
BORGR_TPBEZ_EEDI | Ty.of Error Message when ID Transferred by EDI is not Unique | BORGR_EXID_ERREDI | CHAR | 1 | BORGR_EXID_ERRTYP | ||||
BORGR_TPBEZ_EDIA | Type of Error Message when Online ID is not Unique | BORGR_EXID_ERRDIA | CHAR | 1 | BORGR_EXID_ERRTYP | ||||
BORGR_ASN_NOT_EX | Shipments for Non-Existing Inbound Deliveries Allowed | BORGR_ASN_NOT_EXIST | CHAR | 1 | XFELD |
Key field | Non-key field |
How do I retrieve data from SAP table TVTK using ABAP code
The following ABAP code Example will allow you to do a basic selection on TVTK to SELECT all data from the tableDATA: WA_TVTK TYPE TVTK.
SELECT SINGLE *
FROM TVTK
INTO CORRESPONDING FIELDS OF WA_TVTK
WHERE...
How to access SAP table TVTK
Within an ECC or HANA version of SAP you can also view further information about TVTK 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