SAP table V_TVTK (Generated Table for View)

SAP table V_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
BEZEI Description CHAR 20 0 BEZEI20
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
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
PROFIDNETZ Network Profile CHAR 7 0 TCN41 PROFIDNZPL
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
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
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
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

V_TVTK foreign key relationships

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