1. Home
  2. Resources
  3. SAP Tables
  4. TVTK - Shipment Types

SAP Table TVTK

Shipment Types

TVTK (Shipment Types) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.

Additionally we provide an overview of foreign key relationships, if any, that link TVTK to other SAP tables.

Source: TVTK (Shipment Types)

TVTK table fields

Field Data element Checktable Datatype Length Decimals
MANDT Client MANDT T000 CLNT 3 0
SHTYP Shipment type SHTYP CHAR 4 0
VBTYP SD document category VBTYP CHAR 1 0
A Inquiry
B Quotation
C Order
D Item proposal
E Scheduling agreement
F Scheduling agreement with external service agent
G Contract
H Returns
I Order w/o charge
J Delivery
K Credit memo request
L Debit memo request
M Invoice
N Invoice cancellation
O Credit memo
P Debit memo
Q WMS transfer order
R Goods movement
S Credit memo cancellation
T Returns delivery for order
U Pro forma invoice
V Purchase Order
W Independent reqts plan
X Handling unit
0 Master contract
1 Sales activities (CAS)
2 External transaction
3 Invoice list
4 Credit memo list
5 Intercompany invoice
6 Intercompany credit memo
7 Delivery/shipping notification
8 Shipment
a Shipment costs
b CRM Opportunity
c Unverified delivery
d Trading Contract
e Allocation table
f Additional Billing Documents
g Rough Goods Receipt (only IS-Retail)
h Cancel Goods Issue
i Goods receipt
j JIT call
n Reserved
o Reserved
p Goods Movement (Documentation)
q Reserved
r TD Transport (only IS-Oil)
s Load Confirmation, Reposting (Only IS-Oil)
t Gain / Loss (Only IS-Oil)
u Reentry into Storage (Only IS-Oil)
v Data Collation (only IS-Oil)
w Reservation (Only IS-Oil)
x Load Confirmation, Goods Receipt (Only IS-Oil)
$ (AFS)
+ Accounting Document (Temporary)
- Accounting Document (Temporary)
# Revenue Recognition (Temporary)
~ Revenue Cancellation (Temporary)
ยง Revenue Recognition/New View (Temporary)
NULL Revenue Cancellation/New View (Temporary)
: Service Order
. Service Notification
& Warehouse Document
* Pick Order
, Shipment Document
^ Reserved
| Reserved
k Agency Document
NUMKI Number range in the case of internal number assignment NUMKI CHAR 2 0
NUMKE Number range in the case of external number assignment NUMKE CHAR 2 0
KOPGR Screen sequence group in doc. header KOPGR CHAR 4 0
STERM Leg determination STERM CHAR 1 0
NULL Blank: No legs to be determined
0 0: Only determine assignment of deliveries to stages
1 1: Legs determined according to departure point & itinerary
2 2: Prelim.leg per loading point, subsqnt leg per ship-to pty
3 3: Determine preliminary and subsequent leg by delivery note
4 4: As 1, but ship. type for prel. and subs. legs changeable
ABFER Shipment completion type ABFER CHAR 1 0
1 Loaded outbound shipment
2 Loaded inbound shipment
3 Empty outbound shipment
4 Empty inbound shipment
ABWST Processing control ABWST CHAR 1 0
1 Individual shipment using one mode of transport
2 Individual shipment using several modes of transport
3 Collective shipment using one mode of transport
4 Collective shipment using several modes of transport
BFART Service Level BFART CHAR 1 0
1 Load
2 General cargo
3 Groupage
4 Express
VSART Shipping type VERSART T173 CHAR 2 0
VSAVL Shipping type of preliminary leg VSAVL T173 CHAR 2 0
VSANL Shipping type of subsequent leg VSANL T173 CHAR 2 0
LAUFK Leg Indicator LAUFK CHAR 1 0
1 Preliminary leg
2 Main leg
3 Subsequent leg
4 Direct leg
5 Return leg
KALSM Output determination procedure KALSMB T683 CHAR 6 0
KAPPL Application for output conditions NA_KAPPL T681A CHAR 2 0
TXTGR Text determination procedure TXTGR TTXG CHAR 2 0
PARGR Partner Determination Procedure PARGR TVPG CHAR 4 0
SVTRA Selection variant for transportation planning SVTRA CHAR 14 0
PROFIDNETZ Network profile PROFIDNZPL TCN41 CHAR 7 0
DTMEG Unit of Weight for Transportation Planning DTMEG UNIT 3 0
DTMEV Volume Unit for Transportation Planning DTMEV UNIT 3 0
KSCHL Output Type NA_KSCHL CHAR 4 0
ROUTE_VLF Indicator: Proposed route from delivery ROUTE_VLF CHAR 1 0
X Yes
NULL No
SPEDI_VLF Indicator: Proposed forwarding agent from delivery SPEDI_VLF CHAR 1 0
X Yes
NULL No
ABF_ACTPRF Actions to be carried out for completing a shipment ABF_ACTPRF CHAR 14 0
FKART Shipment cost type FKART_T TVTF CHAR 4 0
STGTA Shipment: statistics group, shipment type STGTA VTSGT CHAR 2 0
FRKRL Proposal freight costs relevance, Shipment header FRKRL_KOP CHAR 1 0
X Relevant for freight costs
NULL Not relevant for freight costs
FRKRL_STR Proposal freight costs relevance, shipment leg FRKRL_STR CHAR 1 0
X Relevant for freight costs
NULL Not relevant for freight costs
FRKRL_UMP Proposal for shipment costs relevance - Load transfer point FRKRL_UMP CHAR 1 0
X Relevant for freight costs
NULL Not relevant for freight costs
FRKRL_GRP Proposal for freight costs relevance, Border cross.pt FRKRL_GRP CHAR 1 0
X Relevant for freight costs
NULL Not relevant for freight costs
ROUTE_STAG Adopt stages from route into shipment ROUTE_STAG CHAR 1 0
NULL Adopt all stages
1 Only stages with leg indicator of shipment header
2 Do not adopt stages
CHGDOC_SHTYP Indicator: Change document shipment for shipment type CHGDOC_SHTYP CHAR 1 0
X Yes
NULL No
DIS_ACTPRF Activities to be performed for planning a shipment DIS_ACTPRF CHAR 14 0
REG_ACTPRF Activites to be carried out at shipment check-in REG_ACTPRF CHAR 14 0
LBG_ACTPRF Activities to be performed at start of shipment loading LBG_ACTPRF CHAR 14 0
LEN_ACTPRF Activities to be performed at loading finish of shipment LEN_ACTPRF CHAR 14 0
TBG_ACTPRF Activites to be carried out at the beginning of a shipment TBG_ACTPRF CHAR 14 0
TEN_ACTPRF Activities to be carried out at the end of a shipment TEN_ACTPRF CHAR 14 0
PLANNING_PROFILE Planning profile for transportation planning PLANNING_PROFILE CHAR 14 0
TSEGTP Time segment event group shipment header TSEGTPLVTT TTSEGTPLH CHAR 10 0
KOPRF Control Indicator for Pick Check in Shipment KOPRF CHAR 1 0
NULL Shipment completion only for full picking
A Warning regarding shipment completion with incompl. picking
B No check regarding full picking
TERMIN_VLF Indicator: Proposal for deadlines from deliveries TERMIN_VLF CHAR 1 0
X Yes
NULL No
TRINF_UEB Data transfer TRINF_UEB NUMC 3 0
PMODE_VD Delivery Split Profile Before Transportation Planning LEDSPD_PMODE_TRA1 TVDSS CHAR 4 0
PMODE_ND Delivery Split Profile after Transportation Planning LEDSPD_PMODE_TRA2 TVDSS CHAR 4 0
KZHULFR Indicator: HUs Relevant for Delivery Item Generation KZHULFR CHAR 1 0
NULL HU not relevant for delivery item generation
X HUs are relevant, but no delivery items have been generated
Y HUs relevant. Del.items have been generated at least once
VTDWM Distribution Control: Decentralized WMS VTDWM CHAR 1 0
NULL Do Not Distribute to Decentralized WMS
1 Distribute to Decentralized WMS
2 Distribute to Central WMS
BORGR_PROCTYP GR-Relevance Indicator BORGR_PROCTYP CHAR 2 0
NULL Normal
WE Shipment Relevant to GR
BORGR_AUTO_REG Automatic Registration for the Status of the Inb. Deliveries BORGR_AUTO_REG CHAR 1 0
BORGR_AUTO_LEN Aut. "Loading end" From the Status of the Inb. Deliveries BORGR_AUTO_LEN CHAR 1 0
BORGR_EXTI1_UNQ Uniqueness of the External ID BORGR_EXID_UNIQUE CHAR 1 0
NULL Do not check
X Check
BORGR_EXTI1_MUST Required Entry BORGR_EXID_MUST CHAR 1 0
NULL Not a required entry
X Required entry
BORGR_EXTI1_EEDI Ty.of Error Message when ID Transferred by EDI is not Unique BORGR_EXID_ERREDI CHAR 1 0
W Warning
E Error
I Information
NULL Undefined
BORGR_EXTI1_EDIA Type of Error Message when Online ID is not Unique BORGR_EXID_ERRDIA CHAR 1 0
W Warning
E Error
I Information
NULL Undefined
BORGR_EXTI2_UNQ Uniqueness of the External ID BORGR_EXID_UNIQUE CHAR 1 0
NULL Do not check
X Check
BORGR_EXTI2_MUST Required Entry BORGR_EXID_MUST CHAR 1 0
NULL Not a required entry
X Required entry
BORGR_EXTI2_EEDI Ty.of Error Message when ID Transferred by EDI is not Unique BORGR_EXID_ERREDI CHAR 1 0
W Warning
E Error
I Information
NULL Undefined
BORGR_EXTI2_EDIA Type of Error Message when Online ID is not Unique BORGR_EXID_ERRDIA CHAR 1 0
W Warning
E Error
I Information
NULL Undefined
BORGR_SIGNI_UNQ Uniqueness of the External ID BORGR_EXID_UNIQUE CHAR 1 0
NULL Do not check
X Check
BORGR_SIGNI_MUST Required Entry BORGR_EXID_MUST CHAR 1 0
NULL Not a required entry
X Required entry
BORGR_SIGNI_EEDI Ty.of Error Message when ID Transferred by EDI is not Unique BORGR_EXID_ERREDI CHAR 1 0
W Warning
E Error
I Information
NULL Undefined
BORGR_SIGNI_EDIA Type of Error Message when Online ID is not Unique BORGR_EXID_ERRDIA CHAR 1 0
W Warning
E Error
I Information
NULL Undefined
BORGR_TPBEZ_UNQ Uniqueness of the External ID BORGR_EXID_UNIQUE CHAR 1 0
NULL Do not check
X Check
BORGR_TPBEZ_MUST Required Entry BORGR_EXID_MUST CHAR 1 0
NULL Not a required entry
X Required entry
BORGR_TPBEZ_EEDI Ty.of Error Message when ID Transferred by EDI is not Unique BORGR_EXID_ERREDI CHAR 1 0
W Warning
E Error
I Information
NULL Undefined
BORGR_TPBEZ_EDIA Type of Error Message when Online ID is not Unique BORGR_EXID_ERRDIA CHAR 1 0
W Warning
E Error
I Information
NULL Undefined
BORGR_ASN_NOT_EX Shipments for Non-Existing Inbound Deliveries Allowed BORGR_ASN_NOT_EXIST CHAR 1 0
X Yes
NULL No

TVTK foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
TVTK FKART TVTK FKART TVTF Shipment Cost Types FKART
TVTK FKART TVTK MANDT TVTF Shipment Cost Types MANDT
TVTK KALSM TVTK KALSM T683 Pricing procedures KALSM
TVTK KALSM TVTK KAPPL T683 Pricing procedures KAPPL
TVTK KALSM 'B' T683 Pricing procedures KVEWE
TVTK KALSM TVTK MANDT T683 Pricing procedures MANDT
TVTK KAPPL TVTK KAPPL T681A Conditions: Applications KAPPL
TVTK MANDT TVTK MANDT T000 Clients MANDT
TVTK PARGR TVTK MANDT TVPG Partner Function Groups MANDT
TVTK PARGR TVTK PARGR TVPG Partner Function Groups PARGR
TVTK PMODE_ND TVTK MANDT TVDSS Profiles for Subsequent Outbound Delivery Split MANDT
TVTK PMODE_ND TVTK PMODE_ND TVDSS Profiles for Subsequent Outbound Delivery Split PMODE
TVTK PMODE_VD TVTK MANDT TVDSS Profiles for Subsequent Outbound Delivery Split MANDT
TVTK PMODE_VD TVTK PMODE_VD TVDSS Profiles for Subsequent Outbound Delivery Split PMODE
TVTK PROFIDNETZ TVTK PROFIDNETZ TCN41 Network Defaults PROFIDNETZ
TVTK PROFIDNETZ 'S' TCN41 Network Defaults PLNAW
TVTK PROFIDNETZ TVTK MANDT TCN41 Network Defaults MANDT
TVTK STGTA TVTK STGTA VTSGT Shipment: Statistic Groups, Shipment Types STGTA
TVTK STGTA TVTK MANDT VTSGT Shipment: Statistic Groups, Shipment Types MANDT
TVTK TSEGTP TVTK TSEGTP TTSEGTPLH Time Segment Template Header TEPL
TVTK TSEGTP TVTK MANDT TTSEGTPLH Time Segment Template Header CLIENT
TVTK TXTGR TVTK TXTGR TTXG Text Processing: Text ID Groups TXTGR
TVTK TXTGR TVTK MANDT TTXG Text Processing: Text ID Groups MANDT
TVTK TXTGR 'VTTK' TTXG Text Processing: Text ID Groups TDOBJECT
TVTK VSANL TVTK VSANL T173 Routes: Mode of Transport for Each Shipping Type VSART
TVTK VSANL TVTK MANDT T173 Routes: Mode of Transport for Each Shipping Type MANDT
TVTK VSART TVTK MANDT T173 Routes: Mode of Transport for Each Shipping Type MANDT
TVTK VSART TVTK VSART T173 Routes: Mode of Transport for Each Shipping Type VSART
TVTK VSAVL TVTK MANDT T173 Routes: Mode of Transport for Each Shipping Type MANDT
TVTK VSAVL TVTK VSAVL T173 Routes: Mode of Transport for Each Shipping Type VSART