SAP Table V_TVLK

Generated Table for View

V_TVLK (Generated Table for View) 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 V_TVLK to other SAP tables.

Source: V_TVLK (Generated Table for View)

V_TVLK table fields

Field Data element Checktable Datatype Length Decimals
MANDT Client MANDT T000 CLNT 3 0
LFART Delivery Type LFART CHAR 4 0
KOPGR Screen sequence group for document header & item BIFGR TVHB CHAR 4 0
UEVOR F-code default for overview screen UEVOR_VL CHAR 4 0
NULL Remain on initial screen until a function is selected
UER1 Go to quantity overview by pressing ENTER
UER2 Go to weight overview by pressing ENTER
UEKO Go to the picking overview screen after pressing ENTER
UELG Go to the overview screen for extent delivered after ENTER
UELA Overview for inbound delivery
UEGW Overview for rough goods receipt
TXN08 Number of the standard text TXN08 CHAR 8 0
UMFNG Display Range UMFNG CHAR 20 0
UALL All items
UHAU Main items
UMAR Selected items
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
INCPO Increment of item number in the SD document INCPO NUMC 6 0
AUFER A sales order is required as basis for delivery AUFER CHAR 1 0
NULL No preceding documents required
X Sales order required
B Purchase order required
L Delivery for subcontracting
P Project required
U Stock transfer w/o previous activity
R Return delivery to vendor
O Goods movement through inb.deliv. / post.chge /outb. deliv.
W Delivery from PP interface (work order)
H Posting change with delivery
DAART Default order type for deliveries without reference to order DAART TVAK CHAR 4 0
POBED Requirement for item that does not refer to a sales order POBED NUMC 3 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
PARGR Partner Determination Procedure PARGR TVPG CHAR 4 0
REGLG Rule for determining the storage location for picking REGLG CHAR 4 0
MALA Shipping point / plant / storage condition
RETA Plant / situation (SITUA) / storage condition
MARE MALA, then RETA (backup procedure)
YY User exit in MV50AFZZ
MSRE Advanced Returns Inbound (Considers Follow-Up Activity)
ROUTF New route determination: with or without a check? ROUTF CHAR 1 0
NULL No new route determination
A New route determination without check
B New route determination with check
TXTGR Text determination procedure TXTGR TTXG CHAR 2 0
KAPPL Application for output conditions NA_KAPPL T681A CHAR 2 0
KALSM Output determination procedure KALSMB T683 CHAR 6 0
KSCHL Output Type NA_KSCHL T685 CHAR 4 0
STGAK Statistics group for sales document type STGAK TVSF CHAR 2 0
VTEXT Description BEZEI20 CHAR 20 0
TRSPG Shipment Blocking Reason TRSPG TTSG CHAR 2 0
TDIIX Transportation relevant indicator for delivery TDIIX_LIEF CHAR 1 0
X Yes
NULL No
EXCOK Carry out legal control for sales document type EXCOK CHAR 1 0
NULL Legal control: No check
C Legal control: Check in dispatch and export area
NEUTE Reschedule deliveries NEUTE CHAR 1 0
NULL No rescheduling
X Reschedule if deadlines are in the past
Y Like X or route changed or route schedule changed
A Reschedule after relevant changes
FEHGR Incompletion procedure for sales document FEHGR TVUV CHAR 2 0
LNSPL Perform Delivery Split According to Warehouse Number LNSPL CHAR 1 0
X Yes
NULL No
AVERP Automatic packing using packing proposal AVERP CHAR 1 0
X Yes
NULL No
PM_ITEM_GEN Generation of Delivery Items for HU Packaging Materials LESHP_ITEM_GEN CHAR 1 0
NULL No item generation for packaging material
X Generation of packaging material items possible
DBTCH Distribution Mode for the Delivery DBTCH CHAR 1 0
NULL Distribution Control By Warehouse Number
1 Stop Distribution
2 Distribution at Delivery Creation
DSFAD Delivery Split for Additional Partners TVLK_DSFAD CHAR 1 0
X Yes
NULL No
OIDELDCM Active flag f. Document Change Management (DCM) f.deliveries OIC_SDP_DDCM CHAR 1 0
X Yes
NULL No

V_TVLK foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
V_TVLK DAART V_TVLK DAART TVAK Sales Document Types AUART
V_TVLK DAART V_TVLK MANDT TVAK Sales Document Types MANDT
V_TVLK FEHGR V_TVLK FEHGR TVUV Incompletion Control: Procedures FEHGR
V_TVLK FEHGR V_TVLK MANDT TVUV Incompletion Control: Procedures MANDT
V_TVLK KALSM V_TVLK KALSM T683 Pricing procedures KALSM
V_TVLK KALSM V_TVLK KAPPL T683 Pricing procedures KAPPL
V_TVLK KALSM 'B' T683 Pricing procedures KVEWE
V_TVLK KALSM V_TVLK MANDT T683 Pricing procedures MANDT
V_TVLK KAPPL V_TVLK KAPPL T681A Conditions: Applications KAPPL
V_TVLK KOPGR V_TVLK KOPGR TVHB Sales Document: Screen Sequence Group BIFGR
V_TVLK KOPGR V_TVLK MANDT TVHB Sales Document: Screen Sequence Group MANDT
V_TVLK KOPGR TTAB OBJEKT_BCF TVHB Sales Document: Screen Sequence Group OBJEKT
V_TVLK KSCHL 'B' T685 Conditions: Types KVEWE
V_TVLK KSCHL V_TVLK KSCHL T685 Conditions: Types KSCHL
V_TVLK KSCHL V_TVLK KAPPL T685 Conditions: Types KAPPL
V_TVLK KSCHL V_TVLK MANDT T685 Conditions: Types MANDT
V_TVLK MANDT V_TVLK MANDT T000 Clients MANDT
V_TVLK PARGR V_TVLK PARGR TVPG Partner Function Groups PARGR
V_TVLK PARGR V_TVLK MANDT TVPG Partner Function Groups MANDT
V_TVLK STGAK V_TVLK STGAK TVSF SD: Statistics Groups for Document Types and Item Categories STGVB
V_TVLK STGAK V_TVLK MANDT TVSF SD: Statistics Groups for Document Types and Item Categories MANDT
V_TVLK TRSPG V_TVLK MANDT TTSG Shipment Blocking Reason MANDT
V_TVLK TRSPG V_TVLK TRSPG TTSG Shipment Blocking Reason TRSPG
V_TVLK TXTGR V_TVLK TXTGR TTXG Text Processing: Text ID Groups TXTGR
V_TVLK TXTGR 'VBBK' TTXG Text Processing: Text ID Groups TDOBJECT
V_TVLK TXTGR V_TVLK MANDT TTXG Text Processing: Text ID Groups MANDT