SAP table V_TVLK (Generated Table for View)

SAP table V_TVLK has 2 primary key fields being MANDT,LFART.

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
LFART Delivery Type CHAR 4 0 LFART
KOPGR Screen sequence group for document header & item CHAR 4 0 TVHB BIFGR
UEVOR F-code default for overview screen CHAR 4 0 UEVOR_VL
Remain on initial screen until a function is selected
UEGW Overview for rough goods receipt
UEKO Go to the picking overview screen after pressing ENTER
UELA Overview for inbound delivery
UELG Go to the overview screen for extent delivered after ENTER
UER1 Go to quantity overview by pressing ENTER
UER2 Go to weight overview by pressing ENTER
TXN08 Number of the Standard Text CHAR 8 0 TXN08
UMFNG Display Range CHAR 20 0 UMFNG
UALL All items
UHAU Main items
UMAR Selected items
NUMKI Number Range of Internal Number Assignment CHAR 2 0 NUMKI
NUMKE Number Range of External Number Assignment CHAR 2 0 NUMKE
INCPO Item Number Increment of SD Documents NUMC 6 0 INCPO
AUFER A sales order is required as basis for delivery CHAR 1 0 AUFER
DAART Default Order Type for Deliveries Without Order Reference CHAR 4 0 TVAK DAART
POBED Requirement for item that does not refer to a sales order NUMC 3 0 POBED
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)
PARGR Partner Determination Procedure CHAR 4 0 TVPG PARGR
REGLG Rule for determining the storage location for picking CHAR 4 0 REGLG
MALA Shipping point / plant / storage condition
MARE MALA, then RETA (backup procedure)
MSRE Advanced Returns Inbound (Considers Follow-Up Activity)
RETA Plant / situation (SITUA) / storage condition
YY Custom Rules
ROUTF New route determination: with or without a check? CHAR 1 0 ROUTF
No new route determination
A New route determination without check
B New route determination with check
C New route determination for inbound deliveries
TXTGR Text Determination Procedure CHAR 2 0 TTXG TXTGR
KAPPL Application for output conditions CHAR 2 0 T681A NA_KAPPL
KALSM Output determination procedure CHAR 6 0 T683 KALSMB
KSCHL Output Type CHAR 4 0 T685 NA_KSCHL
STGAK Statistics group for sales document type CHAR 2 0 TVSF STGAK
VTEXT Description CHAR 20 0 BEZEI20
TRSPG Shipment Blocking Reason CHAR 2 0 TTSG TRSPG
TDIIX Transportation relevant indicator for delivery CHAR 1 0 TDIIX_LIEF
EXCOK Carry out legal control for sales document type CHAR 1 0 EXCOK
Legal control: No check
C Legal control: Check in dispatch and export area
NEUTE Reschedule Deliveries CHAR 1 0 NEUTE
No rescheduling
A Reschedule after relevant changes
X Reschedule if deadlines are in the past
Y Like X or route changed or route schedule changed
FEHGR Incompleteness Procedure for Sales Document CHAR 2 0 TVUV FEHGR
LNSPL Perform Delivery Split According to Warehouse Number CHAR 1 0 LNSPL
AVERP Automatic packing using packing proposal CHAR 1 0 AVERP
PM_ITEM_GEN Generation of Delivery Items for HU Packaging Materials CHAR 1 0 LESHP_ITEM_GEN
DBTCH Distribution Mode for the Delivery CHAR 1 0 DBTCH
Distribution Control By Warehouse Number
1 Stop Distribution
2 Distribution at Delivery Creation
DSFAD Delivery Split for Additional Partners CHAR 1 0 TVLK_DSFAD
OIDELDCM Active flag f. Document Change Management (DCM) f.deliveries CHAR 1 0 OIC_SDP_DDCM
RESTORE_ALLOC Restore Assignments in Delivery Documents CHAR 1 0 ARUN_RESTORE_ALLOC
SGT_IGNORE_SEG Ignore Segmentation Rules in Delivery Document CHAR 1 0 SGT_IGNORE_SEG
INT_TOCD_OFFSET Offset for Internal Transfer of Control Dates DEC 3 0 INT_TOCD_OFFSET
INT_TOCD_OFFSET_UNIT Offset Unit for Internal Transfer of Control Dates UNIT 3 0 T006 INT_TOCD_OFFSET_UNIT
EXT_TOCD_OFFSET Offset for External Transfer of Control Dates DEC 3 0 EXT_TOCD_OFFSET
EXT_TOCD_OFFSET_UNIT Offset Unit for External Transfer of Control Dates UNIT 3 0 T006 EXT_TOCD_OFFSET_UNIT
SGT_IGNORE_BATCH_SPLIT Ignore Batch Split in Delivery Document CHAR 1 0 SGT_IGNORE_BATCH_SPLIT

V_TVLK foreign key relationships

Table Field Check Table Check Field
0 V_TVLK DAART TVAK Sales Document Types MANDT
0 V_TVLK DAART TVAK Sales Document Types AUART
1 V_TVLK EXT_TOCD_OFFSET_UNIT T006 Units of Measurement MANDT
0 V_TVLK FEHGR TVUV Incompletion Control: Procedures MANDT
0 V_TVLK FEHGR TVUV Incompletion Control: Procedures FEHGR
1 V_TVLK INT_TOCD_OFFSET_UNIT T006 Units of Measurement MANDT
0 V_TVLK KALSM T683 Pricing procedures KAPPL
0 V_TVLK KALSM T683 Pricing procedures KALSM
1 V_TVLK KAPPL T681A Conditions: Applications KAPPL
0 V_TVLK KOPGR TVHB Sales Document: Screen Sequence Group MANDT
0 V_TVLK KOPGR TVHB Sales Document: Screen Sequence Group OBJEKT
0 V_TVLK KOPGR TVHB Sales Document: Screen Sequence Group BIFGR
1 V_TVLK KSCHL T685 Conditions: Types KAPPL
1 V_TVLK KSCHL T685 Conditions: Types KSCHL
0 V_TVLK MANDT T000 Clients MANDT
1 V_TVLK PARGR TVPG Partner Function Groups PARGR
0 V_TVLK STGAK TVSF SD: Statistics Groups for Document Types and Item Categories MANDT
1 V_TVLK TRSPG TTSG Shipment Blocking Reason MANDT
0 V_TVLK TXTGR TTXG Text Processing: Text ID Groups MANDT