1. Home
  2. Resources
  3. SAP Tables
  4. VTRLK_VBUK - VBUK for Including in VTRLK

SAP Table VTRLK_VBUK

VBUK for Including in VTRLK

VTRLK_VBUK (VBUK for Including in VTRLK) 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 VTRLK_VBUK to other SAP tables.

VTRLK_VBUK table fields

Field Data element Checktable Datatype Length Decimals
MANDT_TR Client MANDT T000 CLNT 3 0
VBELN_TR Sales and Distribution Document Number VBELN CHAR 10 0
RFSTK_TR Reference document header status RFSTK CHAR 1 0
NULL Not Relevant
A Not yet processed
B Partially processed
C Completely processed
RFGSK_TR Total reference status of all items RFGSK CHAR 1 0
NULL Not Relevant
A Not yet processed
B Partially processed
C Completely processed
BESTK_TR Confirmation status BESTK CHAR 1 0
NULL Not Relevant
A Not yet processed
B Partially processed
C Completely processed
LFSTK_TR Delivery status LFSTK CHAR 1 0
NULL Not Relevant
A Not yet processed
B Partially processed
C Completely processed
LFGSK_TR Overall delivery status for all items LKGSK CHAR 1 0
NULL Not Relevant
A Not yet processed
B Partially processed
C Completely processed
WBSTK_TR Total goods movement status WBSTK CHAR 1 0
NULL Not Relevant
A Not yet processed
B Partially processed
C Completely processed
FKSTK_TR Billing status FKSTK CHAR 1 0
NULL Not Relevant
A Not yet processed
B Partially processed
C Completely processed
FKSAK_TR Billing status (order-related billing document) FKSAK CHAR 1 0
NULL Not Relevant
A Not yet processed
B Partially processed
C Completely processed
BUCHK_TR Posting Status of Billing Document BUCHK CHAR 1 0
NULL Not Relevant
A Not yet processed
B Partially processed
C Completely processed
ABSTK_TR Overall rejection status of all document items ABSTK CHAR 1 0
NULL Not Relevant
A Not yet processed
B Partially processed
C Completely processed
GBSTK_TR Overall processing status of document GBSTK CHAR 1 0
NULL Not Relevant
A Not yet processed
B Partially processed
C Completely processed
KOSTK_TR Overall picking / putaway status KOSTK CHAR 1 0
NULL Not Relevant
A Not yet processed
B Partially processed
C Completely processed
LVSTK_TR Overall status of warehouse management activities LVSTK CHAR 1 0
NULL Not Relevant
A Not yet processed
B Partially processed
C Completely processed
UVALS_TR Total incompletion status of all items in general UVALL_SU CHAR 1 0
NULL Not Relevant
A Not yet processed
B Partially processed
C Completely processed
UVVLS_TR Total incompletion status of all items: Delivery UVVLS_SU CHAR 1 0
NULL Not Relevant
A Not yet processed
B Partially processed
C Completely processed
UVFAS_TR Total incompletion status of all items: Billing UVFAK_SU CHAR 1 0
NULL Not Relevant
A Not yet processed
B Partially processed
C Completely processed
UVALL_TR General incompletion status of the header UVALL_UK CHAR 1 0
NULL Not Relevant
A Not yet processed
B Partially processed
C Completely processed
UVVLK_TR Header incompletion status concerning delivery UVVLK_UK CHAR 1 0
NULL Not Relevant
A Not yet processed
B Partially processed
C Completely processed
UVFAK_TR Header incompletion status with respect to billing UVFAK_UK CHAR 1 0
NULL Not Relevant
A Not yet processed
B Partially processed
C Completely processed
UVPRS_TR Document is incomplete with respect to pricing UVPRS_UK CHAR 1 0
NULL Not Relevant
A Not yet processed
B Partially processed
C Completely processed
VBTYP_TR 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
VBOBJ_TR SD document object VBOBJ CHAR 1 0
A Order
B Purchase order
F Billing document
K Sales activities
L Delivery
T Shipment
V Shipping
X Others
W Bulk Transportation (only IS-OIL)
AEDAT_TR Changed On AEDAT DATS 8 0
FKIVK_TR Billing totals status for intercompany billing FKIVK CHAR 1 0
NULL Not Relevant
A Not yet processed
B Partially processed
C Completely processed
RELIK_TR Invoice list status of billing document RELIK CHAR 1 0
NULL Not Relevant
A Not yet processed
B Partially processed
C Completely processed
UVK01_TR Customer reserves 1: Header status UVK01 CHAR 1 0
NULL Not Relevant
A Not yet processed
B Partially processed
C Completely processed
UVK02_TR Customer reserves 2: Header status UVK02 CHAR 1 0
NULL Not Relevant
A Not yet processed
B Partially processed
C Completely processed
UVK03_TR Customer reserves 3: Header status UVK03 CHAR 1 0
NULL Not Relevant
A Not yet processed
B Partially processed
C Completely processed
UVK04_TR Custmer reserves 4: Header status UVK04 CHAR 1 0
NULL Not Relevant
A Not yet processed
B Partially processed
C Completely processed
UVK05_TR Customer reserves 5: Header status UVK05 CHAR 1 0
NULL Not Relevant
A Not yet processed
B Partially processed
C Completely processed
UVS01_TR Customer reserves 1: Sum of all items UVS01 CHAR 1 0
NULL Not Relevant
A Not yet processed
B Partially processed
C Completely processed
UVS02_TR Customer reserves 2: Sum of all items UVS02 CHAR 1 0
NULL Not Relevant
A Not yet processed
B Partially processed
C Completely processed
UVS03_TR Customer reserves 3: Sum of all items UVS03 CHAR 1 0
NULL Not Relevant
A Not yet processed
B Partially processed
C Completely processed
UVS04_TR Customer reserves 4: Sum of all items UVS04 CHAR 1 0
NULL Not Relevant
A Not yet processed
B Partially processed
C Completely processed
UVS05_TR Customer reserves 5: Sum of all items UVS05 CHAR 1 0
NULL Not Relevant
A Not yet processed
B Partially processed
C Completely processed
PKSTK_TR Overall packing status of all items PKSTK CHAR 1 0
NULL Not Relevant
A Not Processed
B Partially Processed
C Completely Processed
D There are only non-assigned shipping units
CMPSA_TR Status of static credit limit check CMPSA CHAR 1 0
NULL Credit check was not executed
A Credit check was executed, document OK
B Credit check was executed, document not OK
D Document released by credit representative
CMPSB_TR Status of dynamic credit limit check in the credit horizon CMPSB CHAR 1 0
NULL Credit check was not executed
A Credit check was executed, document OK
B Credit check was executed, document not OK
D Document released by credit representative
CMPSC_TR Status of credit check against maximum document value CMPSC CHAR 1 0
NULL Credit check was not executed
A Credit check was executed, document OK
B Credit check was executed, document not OK
D Document released by credit representative
CMPSD_TR Status of credit check against terms of payment CMPSD CHAR 1 0
NULL Credit check was not executed
A Credit check was executed, document OK
B Credit check was executed, document not OK
D Document released by credit representative
CMPSE_TR Status of credit check against customer review date CMPSE CHAR 1 0
NULL Credit check was not executed
A Credit check was executed, document OK
B Credit check was executed, document not OK
D Document released by credit representative
CMPSF_TR Status of credit check against open items due CMPSF CHAR 1 0
NULL Credit check was not executed
A Credit check was executed, document OK
B Credit check was executed, document not OK
D Document released by credit representative
CMPSG_TR Status of credit check against oldest open items CMPSG CHAR 1 0
NULL Credit check was not executed
A Credit check was executed, document OK
B Credit check was executed, document not OK
D Document released by credit representative
CMPSH_TR Status of credit check against highest dunning level CMPSH CHAR 1 0
NULL Credit check was not executed
A Credit check was executed, document OK
B Credit check was executed, document not OK
D Document released by credit representative
CMPSI_TR Status of credit check against financial document CMPSI CHAR 1 0
NULL Credit check was not executed
A Credit check was executed, document OK
B Credit check was executed, document not OK
D Document released by credit representative
CMPSJ_TR Status of credit check against export credit insurance CMPSJ CHAR 1 0
NULL Credit check was not executed
A Credit check was executed, document OK
B Credit check was executed, document not OK
D Document released by credit representative
CMPSK_TR Status of credit check against payment card authorization CMPSK CHAR 1 0
NULL Credit check was not executed
A Credit check was executed, document OK
B Credit check was executed, document not OK
D Document released by credit representative
CMPSL_TR Status of credit check of reserves 4 CMPSL CHAR 1 0
NULL Credit check was not executed
A Credit check was executed, document OK
B Credit check was executed, document not OK
D Document released by credit representative
CMPS0_TR Status of credit check for customer reserve 1 CMPS0 CHAR 1 0
NULL Credit check was not executed
A Credit check was executed, document OK
B Credit check was executed, document not OK
D Document released by credit representative
CMPS1_TR Status of credit check for customer reserve 2 CMPS1 CHAR 1 0
NULL Credit check was not executed
A Credit check was executed, document OK
B Credit check was executed, document not OK
D Document released by credit representative
CMPS2_TR Status of credit check for customer reserve 3 CMPS2 CHAR 1 0
NULL Credit check was not executed
A Credit check was executed, document OK
B Credit check was executed, document not OK
D Document released by credit representative
CMGST_TR Overall status of credit checks CMGST CHAR 1 0
NULL Credit check was not executed/Status not set
A Credit check was executed, document OK
B Credit check was executed, document not OK
C Credit check was executed, document not OK, partial release
D Document released by credit representative
TRSTA_TR Transportation planning status TRSTA CHAR 1 0
NULL Not Relevant
A Not Processed
B Partially Processed
C Completely Processed
KOQUK_TR Status of pick confirmation KOQUK CHAR 1 0
NULL Not Relevant
A Not yet processed
B Partially processed
C Completely processed
COSTA_TR Confirmation status for ALE COSTA_D CHAR 1 0
NULL Item not relevant for confirmation
A Item not yet confirmed by MM
B Item partially confirmed by MM
C All schedule lines by MM confirmed
SAPRL_TR SAP Release SAPRL CHAR 4 0
UVPAS_TR Totals incomplete status for all items: packaging UVPAK_SU CHAR 1 0
NULL Not Relevant
A Not yet processed
B Partially processed
C Completely processed
UVPIS_TR Totals incomplete status for all items: Picking UVPIK_SU CHAR 1 0
NULL Not Relevant
A Not yet processed
B Partially processed
C Completely processed
UVWAS_TR Total incomplete status of all items: post goods movement UVWAK_SU CHAR 1 0
NULL Not Relevant
A Not yet processed
B Partially processed
C Completely processed
UVPAK_TR Header incomplete status for packaging UVPAK_UK CHAR 1 0
NULL Not Relevant
A Not yet processed
B Partially processed
C Completely processed
UVPIK_TR Header incomplete status for picking/putaway UVPIK_UK CHAR 1 0
NULL Not Relevant
A Not yet processed
B Partially processed
C Completely processed
UVWAK_TR Post header incomplete status for goods movement UVWAK_UK CHAR 1 0
NULL Not Relevant
A Not yet processed
B Partially processed
C Completely processed
UVGEK_TR UNUSED UVGEK_UK CHAR 1 0
NULL Not Relevant
A Not yet processed
B Partially processed
C Completely processed
CMPSM_TR Credit check data is obsolete CMPSM CHAR 1 0
NULL Credit check was not executed
A Credit check was executed, document OK
B Credit check was executed, document not OK
D Document released by credit representative
DCSTK_TR Delay status DCSTK CHAR 1 0
NULL Not Relevant
A Not yet processed
B Partially processed
C Completely processed
VESTK_TR Handling Unit Placed in Stock VESTK CHAR 1 0
NULL No shipping unit put away in WM for delivery
X At least one shipping unit put away in WM for delivery
VLSTK_TR Distribution Status (Decentralized Warehouse Processing) VLSTK CHAR 1 0
NULL Not Relevant
A Relevant
B Distributed
C Confirmed
D Planned for Distribution
E Delivery split was performed locally
F Change Management Switched Off
RRSTA_TR Revenue determination status RR_STATUS CHAR 1 0
NULL Not Relevant
A Not yet processed
B Partially processed
C Completely processed
BLOCK_TR Indicator: Document preselected for archiving BLOCK_VB CHAR 1 0
NULL No document block
A Document has been selected for archiving
FSSTK_TR Overall billing block status FSSTK CHAR 1 0
NULL Not Relevant
A Not yet processed
B Partially processed
C Completely processed
LSSTK_TR Overall delivery block status LSSTK_G CHAR 1 0
NULL Not Relevant
A Not yet processed
B Partially processed
C Completely processed
SPSTG_TR Overall blocked status SPSTG CHAR 1 0
NULL Not Relevant
A Not yet processed
B Partially processed
C Completely processed
PDSTK_TR POD status on header level PDSTK CHAR 1 0
NULL Not Relevant
A Not yet processed
B Partially processed
C Completely processed
FMSTK_TR Status Funds Management FMSTK CHAR 1 0
NULL Not Relevant
A Not yet processed
B Partially processed
C Completely processed
MANEK_TR Manual Completion of Contract MANEK CHAR 1 0
SPE_TMPID_TR Temporary inbound delivery /SPE/TMPID CHAR 1 0
NULL Real (non temporary) delivery
1 Temp.ID is waiting for acknowledgement for changing ID
2 Temp.ID is waiting for acknowledgement for deleting ID
3 Temp.ID is waiting for acknowledgement for purging ID
4 Temp.ID is waiting for ackn. to delete caused by redirecting
HDALL_TR Inbound delivery header not yet complete (on Hold) /SPE/INB_HDALL CHAR 1 0
X Yes
NULL No
HDALS_TR At least one of ID items not yet complete (on Hold) /SPE/INB_HDALS CHAR 1 0
X Yes
NULL No
CMPS_CM_TR Status of Credit Check SAP Credit Management CMPS_CM CHAR 1 0
NULL Credit check was not executed
A Credit check was executed, document OK
B Credit check was executed, document not OK
D Document released by credit representative
CMPS_TE_TR Status of Technical Error SAP Credit Management CMPS_TE CHAR 1 0
NULL Credit check was not executed
A Credit check was executed, document OK
B Credit check was executed, document not OK
D Document released by credit representative
VBTYP_EXT_TR Extension of SD Document Category TDD_VBTYP_EXT CHAR 4 0
f001 Period-End Invoice
f002 Period-End Credit Memo
f003 Period-End Invoice (Intercompany Billing)
f004 Period-End Credit Memo (Intercompany Billing)
OIG_SSTSF_TR TD Shipment Status (Functional) OIG_SSTSF CHAR 1 0
1 Partially Scheduled
2 Scheduled
3 Partially Loaded (Plants Missing)
4 Completely Loaded
5 Partially Confirmed (Deliveries Missing)
6 Completely Confirmed
OI_SHIP_TR CHAR 10 0
OIC_NXTINV_TR Next billing date for invoice if status is provisional OIC_NXINV DATS 8 0

VTRLK_VBUK foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
VTRLK_VBUK MANDT_TR VTRLK_VBUK MANDT_TR T000 Clients MANDT