SAP Table BC490_VBAK_VBUK

BC490: Structure for tables VBAK and VBUK

BC490_VBAK_VBUK (BC490: Structure for tables VBAK and VBUK) 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 BC490_VBAK_VBUK to other SAP tables.

BC490_VBAK_VBUK table fields

Field Data element Checktable Datatype Length Decimals
MANDT Client MANDT CLNT 3 0
VBELN Sales Document VBELN_VA CHAR 10 0
ERDAT Date on Which Record Was Created ERDAT DATS 8 0
ERZET Entry time ERZET TIMS 6 0
ERNAM Name of Person who Created the Object ERNAM CHAR 12 0
ANGDT Quotation/Inquiry is valid from ANGDT_V DATS 8 0
BNDDT Date until which bid/quotation is binding (valid-to date) BNDDT DATS 8 0
AUDAT Document Date (Date Received/Sent) AUDAT DATS 8 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
TRVOG Transaction group TRVOG CHAR 1 0
0 Sales order
1 Inquiry
2 Quotation
3 Scheduling agreement
4 Contract
5 Item proposal
6 Delivery
7 Billing documents
8 Proforma invoices
9 Sales activities
A Sales promotions
B Customer independent requirements
D Shipping notification
G Rough Goods Receipt
O Cost accounting: Variance calculation
AUART Sales Document Type AUART CHAR 4 0
AUGRU Order reason (reason for the business transaction) AUGRU CHAR 3 0
GWLDT Warranty Date GWLDT DATS 8 0
SUBMI Collective number (SD) SUBMI_SD CHAR 10 0
LIFSK Delivery block (document header) LIFSK CHAR 2 0
FAKSK Billing block in SD document FAKSK CHAR 2 0
NETWR Net Value of the Sales Order in Document Currency NETWR_AK CURR 15 2
WAERK SD Document Currency WAERK CUKY 5 0
VKORG Sales Organization VKORG CHAR 4 0
VTWEG Distribution Channel VTWEG CHAR 2 0
SPART Division SPART CHAR 2 0
VKGRP Sales Group VKGRP CHAR 3 0
VKBUR Sales Office VKBUR CHAR 4 0
GSBER Business Area GSBER CHAR 4 0
GSKST Business area from cost center GSKST CHAR 4 0
GUEBG Valid-from date (outline agreements, product proposals) GUEBG DATS 8 0
GUEEN Valid-to date (outline agreements, product proposals) GUEEN DATS 8 0
KNUMV Number of the document condition KNUMV CHAR 10 0
VDATU Requested delivery date EDATU_VBAK DATS 8 0
VPRGR Proposed date type PRGRS_VBAK CHAR 1 0
1 Day
2 Week
3 Month
4 Posting period
5 Planning calendar period
AUTLF Complete delivery defined for each sales order? AUTLF CHAR 1 0
X Yes
NULL No
VBKLA Original system with release and transaction control VBKLA CHAR 9 0
VBKLT SD document indicator VBKLT CHAR 1 0
NULL No classification
A Billing request (line item billing)
B Delivery order
C Scheduling agreement with delivery order
D Invoice correction request
E Delivery order correction
F Repair processing: Leading serviceable material
G Repair processing: Leading service product
H Scheduling agreement with external service agent processing
I Consignment issue by external service agent
K Correct consignment issue by external service agent
R Order for Billing Between Company Codes (RRICB)
KALSM Sales and Distribution: Pricing Procedure in Pricing KALSMASD CHAR 6 0
VSBED Shipping Conditions VSBED CHAR 2 0
FKARA Proposed billing type for an order-related billing document FKARA CHAR 4 0
AWAHR Sales probability AWAHR_AK NUMC 3 0
000 Sales order probability
KTEXT Search term for product proposal KTEXT_V CHAR 40 0
BSTNK Customer purchase order number BSTNK CHAR 20 0
BSARK Customer purchase order type BSARK CHAR 4 0
BSTDK Customer purchase order date BSTDK DATS 8 0
BSTZD Purchase order number supplement BSTZD CHAR 4 0
IHREZ Your Reference IHREZ CHAR 12 0
BNAME Name of orderer BNAME_V CHAR 35 0
TELF1 Telephone Number TELF1_VP CHAR 16 0
MAHZA Number of contacts from the customer MAHZA DEC 3 0
MAHDT Last customer contact date MAHDT DATS 8 0
KUNNR Sold-to party KUNAG CHAR 10 0
KOSTL Cost Center KOSTL CHAR 10 0
STAFO Update group for statistics update STAFO CHAR 6 0
STWAE Statistics currency STWAE CUKY 5 0
AEDAT Changed On AEDAT DATS 8 0
KVGR1 Customer group 1 KVGR1 CHAR 3 0
KVGR2 Customer group 2 KVGR2 CHAR 3 0
KVGR3 Customer group 3 KVGR3 CHAR 3 0
KVGR4 Customer group 4 KVGR4 CHAR 3 0
KVGR5 Customer group 5 KVGR5 CHAR 3 0
KNUMA Agreement (various conditions grouped together) KNUMA CHAR 10 0
KOKRS Controlling Area KOKRS CHAR 4 0
PS_PSP_PNR Work Breakdown Structure Element (WBS Element) PS_PSP_PNR NUMC 8 0
KURST Exchange Rate Type KURST CHAR 4 0
KKBER Credit control area KKBER CHAR 4 0
KNKLI Customer's account number with credit limit reference KNKLI CHAR 10 0
GRUPP Customer Credit Group GRUPP_CM CHAR 4 0
SBGRP Credit representative group for credit management SBGRP_CM CHAR 3 0
CTLPC Credit management: Risk category CTLPC_CM CHAR 3 0
CMWAE Currency key of credit control area WAERS_CM CUKY 5 0
CMFRE Release date of the document determined by credit management CMFRE DATS 8 0
CMNUP Date of next credit check of document CMNUP DATS 8 0
CMNGV Next date CMNGV DATS 8 0
AMTBL Released credit value of the document AMTBL_CM CURR 15 2
HITYP_PR Hierarchy type for pricing HITYP_PR CHAR 1 0
ABRVW Usage Indicator ABRVW CHAR 3 0
ABDIS MRP for delivery schedule types ABDIS CHAR 1 0
NULL Delivery schedules are not used
A Requiremnts acc. to fore.dlv.sched/Delivery acc. to validity
B Requirements and deliveries according to validity
C Requirements acc. to fore.dlv.sched/Deliveries acc. to JIT
D Requirements acc. to validity/Deliveries acc. to JIT
E JIT delivery schedules are not used
VGBEL Document number of the reference document VGBEL CHAR 10 0
OBJNR Object number at header level OBJKO CHAR 22 0
BUKRS_VF Company code to be billed BUKRS_VF CHAR 4 0
TAXK1 Alternative tax classification TAXK1_AK CHAR 1 0
TAXK2 Tax classification 2 for customer TAXK2 CHAR 1 0
TAXK3 Tax classification 3 for customer TAXK3 CHAR 1 0
TAXK4 Tax Classification 4 Customer TAXK4 CHAR 1 0
TAXK5 Tax classification 5 for customer TAXK5 CHAR 1 0
TAXK6 Tax classification 6 for customer TAXK6 CHAR 1 0
TAXK7 Tax classification 7 for customer TAXK7 CHAR 1 0
TAXK8 Tax classification 8 for customer TAXK8 CHAR 1 0
TAXK9 Tax classification 9 for customer TAXK9 CHAR 1 0
XBLNR Reference Document Number XBLNR_V CHAR 16 0
ZUONR Assignment number ORDNR_V CHAR 18 0
VGTYP Document category of preceding SD document VBTYP_V 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
KALSM_CH Search procedure for batch determination KALSMA_CH CHAR 6 0
AGRZR Accrual period for order-related billing docs.to be accrued AGRZR NUMC 2 0
AUFNR Order Number AUFNR CHAR 12 0
QMNUM Notification No QMNUM CHAR 12 0
VBELN_GRP Mster contract number VBELN_GRP CHAR 10 0
SCHEME_GRP Referencing requirement: Procedure SCHEME_GRP CHAR 4 0
ABRUF_PART Check partner authorizations ABRUF_PART CHAR 1 0
NULL No check
A Check partner authorized to release in contract
B Check Customer List Partner
ABHOD Pick up date ABHOD DATS 8 0
ABHOV Pick up time ABHOZ TIMS 6 0
ABHOB Pick up time ABHOZ TIMS 6 0
RPLNR Number of payment card plan type RPLNR CHAR 10 0
VZEIT Proposed schedule line time (local with ref. to sales org.) EZEIT_VBAK TIMS 6 0
STCEG_L Tax Destination Country LAND1TX CHAR 3 0
LANDTX Tax departure country LANDTX CHAR 3 0
XEGDR Indicator: Triangular deal within the EU ? XEGDR CHAR 1 0
X Yes
NULL No
ENQUEUE_GRP Block master contr. until all lower level contracts updated ENQUEUE_GRP CHAR 1 0
NULL No document block
A Block because of open work items for master contract
DAT_FZAU Cml delivery order qty date DAT_FZAU DATS 8 0
FMBDAT Material Staging/Availability Date MBDAT DATS 8 0
VSNMR_V Sales document version number VSNMR_V CHAR 12 0
RFSTK Reference document header status RFSTK CHAR 1 0
NULL Not Relevant
A Not yet processed
B Partially processed
C Completely processed
RFGSK Total reference status of all items RFGSK CHAR 1 0
NULL Not Relevant
A Not yet processed
B Partially processed
C Completely processed
BESTK Confirmation status BESTK CHAR 1 0
NULL Not Relevant
A Not yet processed
B Partially processed
C Completely processed
LFSTK Delivery status LFSTK CHAR 1 0
NULL Not Relevant
A Not yet processed
B Partially processed
C Completely processed
LFGSK Overall delivery status for all items LKGSK CHAR 1 0
NULL Not Relevant
A Not yet processed
B Partially processed
C Completely processed
WBSTK Total goods movement status WBSTK CHAR 1 0
NULL Not Relevant
A Not yet processed
B Partially processed
C Completely processed
FKSTK Billing status FKSTK CHAR 1 0
NULL Not Relevant
A Not yet processed
B Partially processed
C Completely processed
FKSAK Billing status (order-related billing document) FKSAK CHAR 1 0
NULL Not Relevant
A Not yet processed
B Partially processed
C Completely processed
BUCHK Posting Status of Billing Document BUCHK CHAR 1 0
NULL Not Relevant
A Not yet processed
B Partially processed
C Completely processed
ABSTK 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 Overall processing status of document GBSTK CHAR 1 0
NULL Not Relevant
A Not yet processed
B Partially processed
C Completely processed
KOSTK Overall picking / putaway status KOSTK CHAR 1 0
NULL Not Relevant
A Not yet processed
B Partially processed
C Completely processed
LVSTK Overall status of warehouse management activities LVSTK CHAR 1 0
NULL Not Relevant
A Not yet processed
B Partially processed
C Completely processed
UVALS 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 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 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 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 Header incompletion status concerning delivery UVVLK_UK CHAR 1 0
NULL Not Relevant
A Not yet processed
B Partially processed
C Completely processed
UVFAK 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 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
VBOBJ 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)
FKIVK Billing totals status for intercompany billing FKIVK CHAR 1 0
NULL Not Relevant
A Not yet processed
B Partially processed
C Completely processed
RELIK Invoice list status of billing document RELIK CHAR 1 0
NULL Not Relevant
A Not yet processed
B Partially processed
C Completely processed
UVK01 Customer reserves 1: Header status UVK01 CHAR 1 0
NULL Not Relevant
A Not yet processed
B Partially processed
C Completely processed
UVK02 Customer reserves 2: Header status UVK02 CHAR 1 0
NULL Not Relevant
A Not yet processed
B Partially processed
C Completely processed
UVK03 Customer reserves 3: Header status UVK03 CHAR 1 0
NULL Not Relevant
A Not yet processed
B Partially processed
C Completely processed
UVK04 Custmer reserves 4: Header status UVK04 CHAR 1 0
NULL Not Relevant
A Not yet processed
B Partially processed
C Completely processed
UVK05 Customer reserves 5: Header status UVK05 CHAR 1 0
NULL Not Relevant
A Not yet processed
B Partially processed
C Completely processed
UVS01 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 Transportation planning status TRSTA CHAR 1 0
NULL Not Relevant
A Not Processed
B Partially Processed
C Completely Processed
KOQUK Status of pick confirmation KOQUK CHAR 1 0
NULL Not Relevant
A Not yet processed
B Partially processed
C Completely processed
COSTA 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 SAP Release SAPRL CHAR 4 0
UVPAS 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 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 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 Header incomplete status for packaging UVPAK_UK CHAR 1 0
NULL Not Relevant
A Not yet processed
B Partially processed
C Completely processed
UVPIK 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 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 UNUSED UVGEK_UK CHAR 1 0
NULL Not Relevant
A Not yet processed
B Partially processed
C Completely processed
CMPSM 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 Delay status DCSTK CHAR 1 0
NULL Not Relevant
A Not yet processed
B Partially processed
C Completely processed
VESTK 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 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 Revenue determination status RR_STATUS CHAR 1 0
NULL Not Relevant
A Not yet processed
B Partially processed
C Completely processed
BLOCK Indicator: Document preselected for archiving BLOCK_VB CHAR 1 0
NULL No document block
A Document has been selected for archiving