SAP table TVTK (Shipment Types)

SAP table TVTK has 2 primary key fields being MANDT,SHTYP.

If you're only analyzing data from a single SAP instance you may omit field MANT in your relationships as it will we the same across the entire dataset. On the other hand, if you're combining data from multiple SAP instances you need to take MANDT into account.

Field Description Data Type Length Decimals Checktable Data Element
MANDT Client CLNT 3 0 T000 MANDT
SHTYP Shipment type CHAR 4 0 SHTYP
VBTYP SD Document Category CHAR 4 0 VBTYPL
# Revenue Recognition (Temporary)
$ (AFS)
& Warehouse Document
* Pick Order
+ Journal Entry (Temporary)
, Shipment Document
- Journal Entry (Temporary)
. Service Notification
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
: Service Order
A Inquiry
a Shipment Costs
b CRM Opportunity
B Quotation
BOS Service Entry Sheet
C Order
c Unverified Delivery
CEM ETM Shipping Document
CMMA Customer Management Master Agreement
CSCO Customer Management Service Confirmation
CSCT Customer Management Service Contract
CSVO Customer Management Service Order
D Item Proposal
d Trading Contract
e Allocation Table
E Scheduling Agreement
EBDR Billing Document Request
F Scheduling Agreement with External Service Agent
f001 Period-End Invoice
f002 Period-End Credit Memo
f003 Period-End Invoice (Intercompany Billing)
f004 Period-End Credit Memo (Intercompany Billing)
G Contract
g Rough Goods Receipt (only IS-Retail)
GBRQ Grants Management Billing Request
h Cancel Goods Issue
H Returns
i Goods Receipt
I Order Without Charge
J Delivery
j JIT Call
K Credit Memo Request
k Settlement Management Document
L Debit Memo Request
M Invoice
N Invoice Cancellation
n Reserved
O Credit Memo
o Reserved
P Debit Memo
p Goods Movement (Documentation)
PBD Preliminary Billing Document
PBDR Billing Document Request for Prof. Serv.
PBRQ Project Billing Request
q Reserved
Q WMS Transfer Order
R Goods Movement
r TD Transport (Only IS-Oil)
S Credit Memo Cancellation
s Load Confirmation, Reposting (Only IS-Oil)
SBRQ Subscription Billing Request
SOLO Solution Order
t Gain / Loss (Only IS-Oil)
T Returns Delivery for Order
TMFO Freight Order
TMFU Freight Unit
U Pro Forma Invoice
u Reentry into Storage (Only IS-Oil)
v Data Collation (Only IS-Oil)
V Purchase Order
W Independent Reqts Plan
w Reservation (Only IS-Oil)
X Handling Unit
x Load Confirmation, Goods Receipt (Only IS-Oil)
Y Rebate Agreement
^ Reserved
| Reserved
~ Revenue Cancellation (Temporary)
ยง Revenue Recognition/New View (Temporary)
NUMKI Number Range of Internal Number Assignment CHAR 2 0 NUMKI
NUMKE Number Range of External Number Assignment CHAR 2 0 NUMKE
KOPGR Screen sequence group in doc. header CHAR 4 0 KOPGR
STERM Leg determination CHAR 1 0 STERM
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 CHAR 1 0 ABFER
1 Loaded outbound shipment
2 Loaded inbound shipment
3 Empty outbound shipment
4 Empty inbound shipment
ABWST Processing control CHAR 1 0 ABWST
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 CHAR 1 0 BFART
1 Load
2 General cargo
3 Groupage
4 Express
VSART Shipping Type CHAR 2 0 T173 VERSART
VSAVL Shipping type of preliminary leg CHAR 2 0 T173 VSAVL
VSANL Shipping type of subsequent leg CHAR 2 0 T173 VSANL
LAUFK Leg Indicator CHAR 1 0 LAUFK
1 Preliminary leg
2 Main leg
3 Subsequent leg
4 Direct leg
5 Return leg
KALSM Output determination procedure CHAR 6 0 T683 KALSMB
KAPPL Application for output conditions CHAR 2 0 T681A NA_KAPPL
TXTGR Text Determination Procedure CHAR 2 0 TTXG TXTGR
PARGR Partner Determination Procedure CHAR 4 0 TVPG PARGR
SVTRA Selection variant for transportation planning CHAR 14 0 SVTRA
PROFIDNETZ Network Profile CHAR 7 0 TCN41 PROFIDNZPL
DTMEG Unit of Weight for Transportation Planning UNIT 3 0 * DTMEG
DTMEV Volume Unit for Transportation Planning UNIT 3 0 * DTMEV
KSCHL Output Type CHAR 4 0 * NA_KSCHL
ROUTE_VLF Indicator: Proposed route from delivery CHAR 1 0 ROUTE_VLF
SPEDI_VLF Indicator: Proposed forwarding agent from delivery CHAR 1 0 SPEDI_VLF
ABF_ACTPRF Actions to be carried out for completing a shipment CHAR 14 0 ABF_ACTPRF
FKART Shipment cost type CHAR 4 0 TVTF FKART_T
STGTA Shipment: statistics group, shipment type CHAR 2 0 VTSGT STGTA
FRKRL Proposal freight costs relevance, Shipment header CHAR 1 0 FRKRL_KOP
FRKRL_STR Proposal freight costs relevance, shipment leg CHAR 1 0 FRKRL_STR
FRKRL_UMP Proposal for shipment costs relevance - Load transfer point CHAR 1 0 FRKRL_UMP
FRKRL_GRP Proposal for freight costs relevance, Border cross.pt CHAR 1 0 FRKRL_GRP
ROUTE_STAG Adopt stages from route into shipment CHAR 1 0 ROUTE_STAG
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 CHAR 1 0 CHGDOC_SHTYP
DIS_ACTPRF Activities to be performed for planning a shipment CHAR 14 0 DIS_ACTPRF
REG_ACTPRF Activites to be carried out at shipment check-in CHAR 14 0 REG_ACTPRF
LBG_ACTPRF Activities to be performed at start of shipment loading CHAR 14 0 LBG_ACTPRF
LEN_ACTPRF Activities to be performed at loading finish of shipment CHAR 14 0 LEN_ACTPRF
TBG_ACTPRF Activites to be carried out at the beginning of a shipment CHAR 14 0 TBG_ACTPRF
TEN_ACTPRF Activities to be carried out at the end of a shipment CHAR 14 0 TEN_ACTPRF
PLANNING_PROFILE Planning profile for transportation planning CHAR 14 0 PLANNING_PROFILE
TSEGTP Time segment event group shipment header CHAR 10 0 TTSEGTPLH TSEGTPLVTT
KOPRF Control Indicator for Pick Check in Shipment CHAR 1 0 KOPRF
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 CHAR 1 0 TERMIN_VLF
TRINF_UEB Data transfer NUMC 3 0 * TRINF_UEB
PMODE_VD Delivery Split Profile Before Transportation Planning CHAR 4 0 TVDSS LEDSPD_PMODE_TRA1
PMODE_ND Delivery Split Profile after Transportation Planning CHAR 4 0 TVDSS LEDSPD_PMODE_TRA2
KZHULFR Indicator: HUs Relevant for Delivery Item Generation CHAR 1 0 KZHULFR
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 CHAR 1 0 VTDWM
Do Not Distribute to Decentralized WMS
1 Distribute to Decentralized WMS
2 Distribute to Central WMS
BORGR_PROCTYP GR-Relevance Indicator CHAR 2 0 BORGR_PROCTYP
Normal
WE Shipment Relevant to GR
BORGR_AUTO_REG Automatic Registration for the Status of the Inb. Deliveries CHAR 1 0 BORGR_AUTO_REG
BORGR_AUTO_LEN Aut. "Loading end" From the Status of the Inb. Deliveries CHAR 1 0 BORGR_AUTO_LEN
BORGR_EXTI1_UNQ Uniqueness of the External ID CHAR 1 0 BORGR_EXID_UNIQUE
Do not check
X Check
BORGR_EXTI1_MUST Required Entry CHAR 1 0 BORGR_EXID_MUST
Not a required entry
X Required entry
BORGR_EXTI1_EEDI Ty.of Error Message when ID Transferred by EDI is not Unique CHAR 1 0 BORGR_EXID_ERREDI
BORGR_EXTI1_EDIA Type of Error Message when Online ID is not Unique CHAR 1 0 BORGR_EXID_ERRDIA
BORGR_EXTI2_UNQ Uniqueness of the External ID CHAR 1 0 BORGR_EXID_UNIQUE
Do not check
X Check
BORGR_EXTI2_MUST Required Entry CHAR 1 0 BORGR_EXID_MUST
Not a required entry
X Required entry
BORGR_EXTI2_EEDI Ty.of Error Message when ID Transferred by EDI is not Unique CHAR 1 0 BORGR_EXID_ERREDI
BORGR_EXTI2_EDIA Type of Error Message when Online ID is not Unique CHAR 1 0 BORGR_EXID_ERRDIA
BORGR_SIGNI_UNQ Uniqueness of the External ID CHAR 1 0 BORGR_EXID_UNIQUE
Do not check
X Check
BORGR_SIGNI_MUST Required Entry CHAR 1 0 BORGR_EXID_MUST
Not a required entry
X Required entry
BORGR_SIGNI_EEDI Ty.of Error Message when ID Transferred by EDI is not Unique CHAR 1 0 BORGR_EXID_ERREDI
BORGR_SIGNI_EDIA Type of Error Message when Online ID is not Unique CHAR 1 0 BORGR_EXID_ERRDIA
BORGR_TPBEZ_UNQ Uniqueness of the External ID CHAR 1 0 BORGR_EXID_UNIQUE
Do not check
X Check
BORGR_TPBEZ_MUST Required Entry CHAR 1 0 BORGR_EXID_MUST
Not a required entry
X Required entry
BORGR_TPBEZ_EEDI Ty.of Error Message when ID Transferred by EDI is not Unique CHAR 1 0 BORGR_EXID_ERREDI
BORGR_TPBEZ_EDIA Type of Error Message when Online ID is not Unique CHAR 1 0 BORGR_EXID_ERRDIA
BORGR_ASN_NOT_EX Shipments for Non-Existing Inbound Deliveries Allowed CHAR 1 0 BORGR_ASN_NOT_EXIST

TVTK foreign key relationships

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