SAP Table VBAK

Sales Document: Header Data

VBAK (Sales Document: Header Data) 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 VBAK to other SAP tables.

VBAK table fields

Field Data element Checktable Datatype Length Decimals
MANDT Client MANDT T000 CLNT 3 0
VBELN Sales Document VBELN_VA VBUK 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 TVAK CHAR 4 0
AUGRU Order reason (reason for the business transaction) AUGRU TVAU 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 TVLS CHAR 2 0
FAKSK Billing block in SD document FAKSK TVFS CHAR 2 0
NETWR Net Value of the Sales Order in Document Currency NETWR_AK CURR 15 2
WAERK SD Document Currency WAERK TCURC CUKY 5 0
VKORG Sales Organization VKORG TVKO CHAR 4 0
VTWEG Distribution Channel VTWEG TVKOV CHAR 2 0
SPART Division SPART TVTA CHAR 2 0
VKGRP Sales Group VKGRP TVBVK CHAR 3 0
VKBUR Sales Office VKBUR TVKBZ CHAR 4 0
GSBER Business Area GSBER TGSB CHAR 4 0
GSKST Business area from cost center GSKST TGSB 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 T683 CHAR 6 0
VSBED Shipping Conditions VSBED TVSB CHAR 2 0
FKARA Proposed billing type for an order-related billing document FKARA TVFK 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 T176 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 KNA1 CHAR 10 0
KOSTL Cost Center KOSTL CHAR 10 0
STAFO Update group for statistics update STAFO CHAR 6 0
STWAE Statistics currency STWAE TCURC CUKY 5 0
AEDAT Changed On AEDAT DATS 8 0
KVGR1 Customer group 1 KVGR1 TVV1 CHAR 3 0
KVGR2 Customer group 2 KVGR2 TVV2 CHAR 3 0
KVGR3 Customer group 3 KVGR3 TVV3 CHAR 3 0
KVGR4 Customer group 4 KVGR4 TVV4 CHAR 3 0
KVGR5 Customer group 5 KVGR5 TVV5 CHAR 3 0
KNUMA Agreement (various conditions grouped together) KNUMA KONA CHAR 10 0
KOKRS Controlling Area KOKRS TKA01 CHAR 4 0
PS_PSP_PNR Work Breakdown Structure Element (WBS Element) PS_PSP_PNR PRPS NUMC 8 0
KURST Exchange Rate Type KURST TCURV CHAR 4 0
KKBER Credit control area KKBER T014 CHAR 4 0
KNKLI Customer's account number with credit limit reference KNKLI KNA1 CHAR 10 0
GRUPP Customer Credit Group GRUPP_CM CHAR 4 0
SBGRP Credit representative group for credit management SBGRP_CM T024B CHAR 3 0
CTLPC Credit management: Risk category CTLPC_CM T691A CHAR 3 0
CMWAE Currency key of credit control area WAERS_CM TCURC 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 THIT CHAR 1 0
ABRVW Usage Indicator ABRVW TVLV 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 VBUK CHAR 10 0
OBJNR Object number at header level OBJKO ONR00 CHAR 22 0
BUKRS_VF Company code to be billed BUKRS_VF T001 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_V1 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 T683 CHAR 6 0
AGRZR Accrual period for order-related billing docs.to be accrued AGRZR NUMC 2 0
AUFNR Order Number AUFNR AUFK CHAR 12 0
QMNUM Notification No QMNUM QMEL CHAR 12 0
VBELN_GRP Mster contract number VBELN_GRP CHAR 10 0
SCHEME_GRP Referencing requirement: Procedure SCHEME_GRP TVGRPS 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 FPLA 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 T005 CHAR 3 0
LANDTX Tax departure country LANDTX T005 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
HANDLE International unique key for VBAK-VBELN TSEGGUID_VBAK CHAR 22 0
PROLI Dangerous Goods Management Profile in SD Documents ADGE_PROLI TDGC5 CHAR 3 0
CONT_DG Indicator: Document contains dangerous goods ADGE_NCDG CHAR 1 0
X Yes
NULL No
CRM_GUID Character field, length 70 CHAR70 CHAR 70 0
UPD_TMSTMP UTC Time Stamp in Long Form (YYYYMMDDhhmmssmmmuuun) TIMESTAMPL DEC 21 7
MSR_ID Process Identification Number MSR_PROCESS_ID CHAR 10 0
TM_CTRL_KEY Control Key for Document Transfer to TM TM_CTRL_KEY CHAR 4 0
HANDOVERLOC Location for a physical handover of goods HANDOVER_LOC CHAR 10 0
/XLSO/SO_VALD_FM Field of type DATS DATS DATS 8 0
/XLSO/SO_VALD_TO Field of type DATS DATS DATS 8 0
/XLSO/PAYMENT_OP Payment Method /XLSO/E_PAY_METHOD CHAR 2 0
IN INvoice
PP Pre-Payment
CC Credit Card
/XLSO/TRANS_CTXT Transaction Context GUID /XLSO/E_TRANS_CTXT NUMC 8 0
/XLSO/CATALOG_ID Product catalog number WMINR CHAR 10 0
/XLSO/VARIANT_ID Product catalog variant WMVARD CHAR 3 0
PSM_BUDAT Posting Date in the Document PSM_BUDAT DATS 8 0
SWENR Business Entity Number HB_SWENR VIOB01 CHAR 8 0
SMENR Number of Sales Unit HB_SMENR VIMI01 CHAR 8 0
PHASE Sales Phase HB_SPHSE HBSSPH CHAR 11 0
MTLAUR Marker for Low Income Housing HB_MTLAUR CHBSNCM CHAR 1 0
STAGE Construction Stage HB_STAGE INT4 10 0
HB_CONT_REASON Contingency data HB_CONT HBSCREASON CHAR 2 0
HB_EXPDATE Expiration date HB_EXP DATS 8 0
HB_RESDATE Resolution date HB_RES DATS 8 0
MILL_APPL_ID Application ID Category for Configuration MILL_APPL_ID CHAR 2 0
PP Caller is a Manufacturing Order
MM Caller is Purchasing
SD Caller is Sales and Distribution
OID_EXTBOL External bill of lading OID_EXTBOL CHAR 16 0
OID_MISCDL Miscellaneous delivery number OID_MISCDL CHAR 16 0
OIDMSG_SHP Message type for contract restrictions ship-to party OIDMSG_SHP CHAR 1 0
NULL No message
W Warning
E Error
I Information
OIDSTS_SHP Status of contract restriction for ship-to party OIDSTS_SHP CHAR 1 0
NULL Not Selected
X Selected
OIPIPEVAL Validation indicator for pipeline fields (X=ON, blank=OFF) OID_PIPEV CHAR 1 0
X Yes
NULL No
OIC_LIFNR Account Number of Vendor or Creditor LIFNR LFA1 CHAR 10 0
OIC_DCITYC Destination city code OIC_DCITYC T005G CHAR 4 0
OIC_DCOUNC Destination county code OIC_DCOUNC T005E CHAR 3 0
OIC_DREGIO Destination region OIC_DREGIO T005S CHAR 3 0
OIC_DLAND1 Destination country OIC_DLAND1 T005 CHAR 3 0
OIC_OCITYC Origin city code OIC_OCITYC T005G CHAR 4 0
OIC_OCOUNC Origin county code OIC_OCOUNC T005E CHAR 3 0
OIC_OREGIO Origin region OIC_OREGIO T005S CHAR 3 0
OIC_OLAND1 Origin country OIC_OLAND1 T005 CHAR 3 0
OIC_PORGIN Tax origin OIC_PORGIN CHAR 15 0
OIC_PDESTN Tax destination OIC_PDESTN CHAR 15 0
OIC_PTRIP Pipeline trip number (external) OIC_PTRIP CHAR 16 0
OIC_PBATCH Pipeline operator�s external batch number OIC_PBATCH CHAR 16 0
OIC_MOT IS-OIL MAP external details mode of transport OIC_MOT TVTR CHAR 2 0
OIC_AORGIN Alternate origin OIC_AORGIN CHAR 15 0
OIC_ADESTN Alternate destination OIC_ADESTN CHAR 15 0
OIC_TRUCKN Truck number OIC_TRUCKN CHAR 10 0
OIA_BASELO Base location OIA_BASELO CHAR 15 0
OIINEX Code for internal or external excise duty rate determination OIH_INEX OIH16 CHAR 2 0
OIISOIL Sales order created by IS-Oil: X=Yes BLANK=No OID_ISOIL CHAR 1 0
X Yes
NULL No
OIPTRFNC Partner function OID_PTRFNC CHAR 2 0
OIPARTNR Customer name (sold-to party or ship-to party) OID_PARTNR CHAR 10 0
OILASTOR Last order number OID_LASTOR CHAR 10 0
OIDRC Differential Reference Code (DRC) OIC_DRC OICDC CHAR 5 0
OIEXGNUM Exchange agreement number OIA_EXGNUM OIA01 CHAR 10 0
OIEXGTYP Exchange type OIA_EXGTYP TOIA2 CHAR 4 0
OICHEADOFF Head office account number (in branch accounts) KNRZE CHAR 10 0
OIPBL Business location identifier (IS-Oil MRN) OIF_PBLNR OIFSPBL CHAR 10 0
OIDRESTR Contract restrictions flag OIDRESTR CHAR 1 0
NULL Not Selected
X Selected
OIDMSG_PRD Message type for product with contract restrictions OIDMSG_PRD CHAR 1 0
NULL No message
W Warning
E Error
I Information
OIDMSG_QTY Message type for contract restrictions quantity OIDMSG_QTY CHAR 1 0
NULL No message
W Warning
E Error
I Information
OIDMSG_UOM Message type for contract restrictions unit of measure OIDMSG_UOM CHAR 1 0
NULL No message
W Warning
E Error
I Information
OIDMSG_DAT Message type for contract restrictions validity period OIDMSG_DAT CHAR 1 0
NULL No message
W Warning
E Error
I Information
OIDMSG_TRM Message type for contract restrictions payment terms OIDMSG_TRM CHAR 1 0
NULL No message
W Warning
E Error
I Information
OICNTPER Contact person OID_CNTPER CHAR 35 0
OICNTNTE Contact note OID_CNTNTE CHAR 35 0
OICNTPHO Contact tel. number OID_CNTPHO CHAR 16 0
OID_SORTL Descending sort key for sales orders (converted date) OID_SORTL NUMC 10 0
OID_SORT2 Descending sort key for sales orders (converted time) OID_SORT2 NUMC 10 0
OICFKARTDI Differential invoice billing type proposal OICFKARTDI CHAR 4 0
OIAEVGTYPE Evergreen type OIA_EVTYPE CHAR 1 0
NULL None
R Regular
U Unlimited
OIU_CT_TYPE_CD Contract Type OIU_CT_TYPE_CD OIU_CM_CTTYP CHAR 2 0
OIU_CUST_VEND_CD Customer/Vendor Indicator OIU_CUST_VEND_CD CHAR 1 0
C Customer
V Vendor
P Partner
OIU_APPR_FL Approval indicator OIU_APPL_FL CHAR 1 0
X Active
NULL Inactive
OIU_APPR_DT Approval Date OIU_APPR_DT DATS 8 0
OIU_EXEC_DT Contract Execution Date OIU_EXEC_DT DATS 8 0
OIU_STD_CT_FL Standard Contract Flag OIU_STD_CT_FL CHAR 1 0
X Active
NULL Inactive
OIU_PREV_CT_NO Old / Previous Contract Number OIU_PREV_CT_NO CHAR 10 0
OIU_GPLT_COMPANY Gas Plant Company OIU_GPLT_BUKRS T001 CHAR 4 0
OIU_GPLT_VNAME Gas Plant Venture OIU_GPLT_VNAME OIU_DO_JV CHAR 6 0
OIU_GPLT_DOI_NO Gasplant DOI No OIU_GPLT_DOI_NO CHAR 5 0
OIU_MK_REP_NO Marketing Representative No OIU_MK_REP_NO CHAR 10 0
OIU_MK_REP_ISQ Marketing Representative Interest Sequence No OIU_MK_REP_ISQ_NO CHAR 2 0
OIU_DEST_SALE_CD Plant Destination Of Product Sale Codes OIU_DEST_SALE_CD CHAR 1 0
B Bypass
P Processing
S Straddle
N None
OIU_LIFE_LSE_FL Life Lease Flag OIU_LIFE_LSE_FL CHAR 1 0
X Active
NULL Inactive
OIU_INV_NO Contract Invoice Number OIU_INV_NO CHAR 6 0
OIU_INV_FL Invoice Flag OIU_INV_FL CHAR 1 0
X Active
NULL Inactive
OIU_OBLIG_DT Obligation Date OIU_OBLIG_DT DATS 8 0
OIU_DESK_CD Desk Codes OIU_DESK_CD CHAR 3 0
OIU_EIA_GINA_CD Energy Information Agency Report Code OIU_EIA_GINA_CD CHAR 2 0
OIU_CT_STATUS_CD Contract Status Code OIU_CT_STATUS_CD CHAR 2 0
AC Active
AS Assigned
CO Correction
MO Modified
RE Renewal
RO Rollover
SU Successor
TE Terminated
OIU_SPOT_TERM_CD Spot/Term OIU_SPOT_TERM_CD CHAR 1 0
S Spot
T Term
OIU_STNDEDQ_CD Varying/Equ Daily Qu OIU_STNDEDQ_CD CHAR 1 0
E Equal Daily Quantity
V Varying Daily Quantity
OIU_IOTR_FL Price includes Tax Reimbursement. OIU_IOTR_FL CHAR 1 0
X Active
NULL Inactive
OIU_INTRA_INTER Boundary (Intra/Inter) Codes OIU_INTRA_INTER_CD CHAR 1 0
A Intrastate
B Both
E Interstate
OIU_EXRES_SPLT Excess Residue Return (Before/After) Lease Plant Split Code OIU_EXRES_SPLT_CD CHAR 1 0
B Before
A After
N None
OIU_EVGN_FL Evergreen Flag OIU_EVGN_FL CHAR 1 0
X Active
NULL Inactive
OIU_EVGNPD_BAS Evergreen Period Basis OIU_EVGNPD_BAS_CD CHAR 2 0
DY Days
MO Months
OIU_EVGN_PERD_QY Evergreen Period Duration OIU_EVGN_PERD_QY NUMC 3 0
OIU_PREIM_TM_CD Primary Term Basis OIU_PREIM_TM_CD CHAR 2 0
YR Years
MO Months
OIU_PRIM_TM_QY Primary Term Length OIU_PRIM_TM_QY NUMC 3 0
OIU_SEC_TM_CD Secondary Term Basis OIU_SEC_TM_CD CHAR 2 0
YR Years
MO Months
OIU_SEC_TM_QY Secondary Term Length OIU_SEC_TM_QY NUMC 3 0
OIU_EXP_NOTIF_DT Expiration Notification Date OIU_EXP_NOTIF_DT DATS 8 0
OIU_INTIT_RDT_DT Initial Redetermination Date OIU_INTIT_RDT_DT DATS 8 0
OIU_NEXT_RDT_DT Next redetermination date OIU_NEXT_RDT_DT DATS 8 0
OIU_RTC_DT Right to cancel date OIU_RTC_DT DATS 8 0
OIU_RDT_N_PERD Re-determination Notification Period (in Days) OIU_RDT_N_PERD_QY QUAN 13 3
OIU_RDT_REFQ_CD Redetermination Frequency Code OIU_RDT_REFQ_CD CHAR 2 0
AN Annually
BM Bi-monthly
MT Monthly
QT Quarterly
SA Semi-annually
OIU_RTF_CD Ratification Date OIU_RTF_DT DATS 8 0
OIU_IMB_PRVSN_FL Imbalance Provision Flag OIU_IMB_PRVSN_FL CHAR 1 0
X Active
NULL Inactive
OIU_FFEE_RMB_FL Filing Fee Reimbursement Flag OIU_FFEE_RMB_FL CHAR 1 0
X Active
NULL Inactive
OIU_FIRM_INTRPT Firm/Interruptable Code OIU_FIRM_INTRPT_CD CHAR 1 0
F Firm
I Interruptable
OIU_BAL_BAS_CD Balancing Basis Code OIU_BAL_BAS_CD CHAR 1 0
V Volume
E Energy
A Value
OIU_PNTY_BAS_CD Penalty Basis Code OIU_PNTY_BAS_CD CHAR 1 0
V Volume
E Energy
A Value
OIU_TRANSP_BA Transportation Basis Code OIU_TRANSP_BAS_CD CHAR 1 0
V Volume
E Energy
A Value
OIU_DLY_MAX_T_QY Daily Maximum Transport Quantity OIU_DLY_MAX_T_QY QUAN 13 3
OIU_PRCS_FL Processing Flag OIU_PRCS_FL CHAR 1 0
X Active
NULL Inactive
OIU_SPR_FL Separation Flag OIU_SPR_FL CHAR 1 0
X Active
NULL Inactive
OIU_DEHYD_FL Dehydration Flag OIU_DEHYD_FL CHAR 1 0
X Active
NULL Inactive
OIU_COMPR_FL Compression Flag OIU_COMPR_FL CHAR 1 0
X Active
NULL Inactive
OIU_PYMT_METH_CD Payment Method Code OIU_PYMT_METH_CD CHAR 1 0
C Check
E Electronic File Transfers
J Joint Interest
N Non-wire Payments
W Wire
OIU_CON_MATNR Contaminant material OIU_CON_MATNR CHAR 18 0
OIU_CON_MAX_QY Contaminant Percent OIU_CON_MAX_QY NUMC 3 0
OIU_AFFIL_FL Affiliate Flag OIU_AFFIL_FL CHAR 1 0
X Active
NULL Inactive
OIU_MMS_TYPE_CD Production: MMS-2014 - Sales Type Code OIUREP_MMS_2014_SALES_TYPE_CD OIUREP_SALESTY CHAR 4 0
OIU_MMS_ETPAY_FL MMS-2014: Contracts with Estimated Payment OIUREP_MMS_2014_CT_EST_PAY_FL CHAR 1 0
X Yes
NULL No
OIUH_CT_NO Contract Number OIUH_CT_NO CHAR 6 0
TAS Treasury Account Symbol FMFG_TAS CHAR 30 0
BETC Business Event Type Code FMFG_BETC CHAR 10 0
MOD_ALLOW Modification Allowed FMFG_MOD_ALLOW CHAR 1 0
CANCEL_ALLOW Cancellation Allowed FMFG_CANCEL_ALLOW CHAR 1 0
PAY_METHOD List of the Payment Methods to be Considered DZWELS CHAR 10 0
BPN Business Partner Number FMFG_BPN T880 CHAR 6 0
REP_FREQ Reporting Frequency FMFG_REP_FREQ CHAR 3 0
LOGSYSB Logical system with which document was created LOGSYSB CHAR 10 0
KALCD Procedure for Campaign Determination KALCD CHAR 6 0
MULTI Multiple Campaigns/Trade Promotions Active Indicator CMPC_MULT_CAMPAIGN CHAR 1 0
NULL Inactive
A Compatible with CRM (Sorting According to Access Sequence)
B Compatible with CRM and CRM Mobile (Simple Sorting)
SPPAYM Payment Form for Special Payment Method SPPAYM CHAR 2 0
01 Payment Service Provider
WTYSC_CLM_HDR Claim header WTYSC_CLM_HDR CHAR 16 0

VBAK foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
VBAK ABRVW VBAK MANDT TVLV Check table for release orders: Usage ID MANDT
VBAK ABRVW VBAK ABRVW TVLV Check table for release orders: Usage ID ABRVW
VBAK AUART VBAK MANDT TVAK Sales Document Types MANDT
VBAK AUART VBAK AUART TVAK Sales Document Types AUART
VBAK AUFNR VBAK MANDT AUFK Order master data MANDT
VBAK AUFNR VBAK AUFNR AUFK Order master data AUFNR
VBAK AUGRU VBAK AUGRU TVAU Sales Documents: Order Reasons AUGRU
VBAK AUGRU VBAK MANDT TVAU Sales Documents: Order Reasons MANDT
VBAK BPN VBAK MANDT T880 Global Company Data (for KONS Ledger) MANDT
VBAK BPN VBAK BPN T880 Global Company Data (for KONS Ledger) RCOMP
VBAK BSARK VBAK MANDT T176 Sales Documents: Customer Order Types MANDT
VBAK BSARK VBAK BSARK T176 Sales Documents: Customer Order Types BSARK
VBAK BUKRS_VF VBAK MANDT T001 Company Codes MANDT
VBAK BUKRS_VF VBAK BUKRS_VF T001 Company Codes BUKRS
VBAK CMWAE VBAK CMWAE TCURC Currency Codes WAERS
VBAK CMWAE VBAK MANDT TCURC Currency Codes MANDT
VBAK CTLPC VBAK CTLPC T691A Credit management risk categories CTLPC
VBAK CTLPC VBAK KKBER T691A Credit management risk categories KKBER
VBAK CTLPC VBAK MANDT T691A Credit management risk categories MANDT
VBAK FAKSK VBAK MANDT TVFS Billing: Reasons for Blocking MANDT
VBAK FAKSK VBAK FAKSK TVFS Billing: Reasons for Blocking FAKSP
VBAK FKARA VBAK FKARA TVFK Billing: Document Types FKART
VBAK FKARA VBAK MANDT TVFK Billing: Document Types MANDT
VBAK GSBER VBAK MANDT TGSB Business Areas MANDT
VBAK GSBER VBAK GSBER TGSB Business Areas GSBER
VBAK GSKST VBAK MANDT TGSB Business Areas MANDT
VBAK GSKST VBAK GSKST TGSB Business Areas GSBER
VBAK HB_CONT_REASON * HBSCREASON Contingency reasons MANDT
VBAK HB_CONT_REASON VBAK HB_CONT_REASON HBSCREASON Contingency reasons HB_CONT
VBAK HITYP_PR VBAK MANDT THIT Customer Hierarchy Types MANDT
VBAK HITYP_PR VBAK HITYP_PR THIT Customer Hierarchy Types HITYP
VBAK KALSM VBAK MANDT T683 Pricing procedures MANDT
VBAK KALSM T681V KVEWE T683 Pricing procedures KVEWE
VBAK KALSM T681A KAPPL T683 Pricing procedures KAPPL
VBAK KALSM VBAK KALSM T683 Pricing procedures KALSM
VBAK KALSM_CH VBAK MANDT T683 Pricing procedures MANDT
VBAK KALSM_CH T681V KVEWE T683 Pricing procedures KVEWE
VBAK KALSM_CH T681A KAPPL T683 Pricing procedures KAPPL
VBAK KALSM_CH VBAK KALSM_CH T683 Pricing procedures KALSM
VBAK KKBER VBAK MANDT T014 Credit control areas MANDT
VBAK KKBER VBAK KKBER T014 Credit control areas KKBER
VBAK KNKLI VBAK MANDT KNA1 General Data in Customer Master MANDT
VBAK KNKLI VBAK KNKLI KNA1 General Data in Customer Master KUNNR
VBAK KNUMA VBAK MANDT KONA Agreements MANDT
VBAK KNUMA VBAK KNUMA KONA Agreements KNUMA
VBAK KOKRS VBAK KOKRS TKA01 Controlling Areas KOKRS
VBAK KOKRS VBAK MANDT TKA01 Controlling Areas MANDT
VBAK KUNNR VBAK MANDT KNA1 General Data in Customer Master MANDT
VBAK KUNNR VBAK KUNNR KNA1 General Data in Customer Master KUNNR
VBAK KURST VBAK KURST TCURV Exchange rate types for currency translation KURST
VBAK KURST VBAK MANDT TCURV Exchange rate types for currency translation MANDT
VBAK KVGR1 VBAK KVGR1 TVV1 Customer Group 1 KVGR1
VBAK KVGR1 VBAK MANDT TVV1 Customer Group 1 MANDT
VBAK KVGR2 VBAK MANDT TVV2 Customer Group 2 MANDT
VBAK KVGR2 VBAK KVGR2 TVV2 Customer Group 2 KVGR2
VBAK KVGR3 VBAK MANDT TVV3 Customer Group 3 MANDT
VBAK KVGR3 VBAK KVGR3 TVV3 Customer Group 3 KVGR3
VBAK KVGR4 VBAK MANDT TVV4 Customer Group 4 MANDT
VBAK KVGR4 VBAK KVGR4 TVV4 Customer Group 4 KVGR4
VBAK KVGR5 VBAK MANDT TVV5 Customer Group 5 MANDT
VBAK KVGR5 VBAK KVGR5 TVV5 Customer Group 5 KVGR5
VBAK LANDTX VBAK MANDT T005 Countries MANDT
VBAK LANDTX VBAK LANDTX T005 Countries LAND1
VBAK LIFSK VBAK MANDT TVLS Deliveries: Blocking Reasons/Criteria MANDT
VBAK LIFSK VBAK LIFSK TVLS Deliveries: Blocking Reasons/Criteria LIFSP
VBAK MANDT VBAK MANDT T000 Clients MANDT
VBAK MTLAUR * CHBSNCM Possible entries for the target income MANDT
VBAK MTLAUR VBAK MTLAUR CHBSNCM Possible entries for the target income INCOME
VBAK OBJNR VBAK MANDT ONR00 General Object Number MANDT
VBAK OBJNR VBAK OBJNR ONR00 General Object Number OBJNR
VBAK OIC_DCITYC VBAK OIC_DCITYC T005G City CITYC
VBAK OIC_DCITYC SYST MANDT T005G City MANDT
VBAK OIC_DCITYC VBAK OIC_DLAND1 T005G City LAND1
VBAK OIC_DCITYC VBAK OIC_DREGIO T005G City REGIO
VBAK OIC_DCOUNC VBAK OIC_DLAND1 T005E County LAND1
VBAK OIC_DCOUNC VBAK OIC_DREGIO T005E County REGIO
VBAK OIC_DCOUNC VBAK OIC_DCOUNC T005E County COUNC
VBAK OIC_DCOUNC SYST MANDT T005E County MANDT
VBAK OIC_DLAND1 VBAK OIC_DLAND1 T005 Countries LAND1
VBAK OIC_DLAND1 SYST MANDT T005 Countries MANDT
VBAK OIC_DREGIO VBAK OIC_DLAND1 T005S Taxes: Region (Province) Key LAND1
VBAK OIC_DREGIO VBAK OIC_DREGIO T005S Taxes: Region (Province) Key BLAND
VBAK OIC_DREGIO SYST MANDT T005S Taxes: Region (Province) Key MANDT
VBAK OIC_LIFNR SYST MANDT LFA1 Vendor Master (General Section) MANDT
VBAK OIC_LIFNR VBAK OIC_LIFNR LFA1 Vendor Master (General Section) LIFNR
VBAK OIC_MOT SYST MANDT TVTR Routes: Modes of Transport MANDT
VBAK OIC_MOT VBAK OIC_MOT TVTR Routes: Modes of Transport VKTRA
VBAK OIC_OCITYC SYST MANDT T005G City MANDT
VBAK OIC_OCITYC VBAK OIC_OLAND1 T005G City LAND1
VBAK OIC_OCITYC VBAK OIC_OREGIO T005G City REGIO
VBAK OIC_OCITYC VBAK OIC_OCITYC T005G City CITYC
VBAK OIC_OCOUNC VBAK OIC_OREGIO T005E County REGIO
VBAK OIC_OCOUNC VBAK OIC_OCOUNC T005E County COUNC
VBAK OIC_OCOUNC SYST MANDT T005E County MANDT
VBAK OIC_OCOUNC VBAK OIC_OLAND1 T005E County LAND1
VBAK OIC_OLAND1 SYST MANDT T005 Countries MANDT
VBAK OIC_OLAND1 VBAK OIC_OLAND1 T005 Countries LAND1
VBAK OIC_OREGIO SYST MANDT T005S Taxes: Region (Province) Key MANDT
VBAK OIC_OREGIO VBAK OIC_OLAND1 T005S Taxes: Region (Province) Key LAND1
VBAK OIC_OREGIO VBAK OIC_OREGIO T005S Taxes: Region (Province) Key BLAND
VBAK OIDRC VBAK MANDT OICDC Differential Reference Code MANDT
VBAK OIDRC VBAK OIDRC OICDC Differential Reference Code OIDRC
VBAK OIEXGNUM VBAK MANDT OIA01 Exchange header (IS-Oil EXG standard/core object) MANDT
VBAK OIEXGNUM VBAK OIEXGNUM OIA01 Exchange header (IS-Oil EXG standard/core object) EXGNUM
VBAK OIEXGTYP VBAK MANDT TOIA2 Exchange types MANDT
VBAK OIEXGTYP VBAK OIEXGTYP TOIA2 Exchange types EXGTYP
VBAK OIINEX VBAK OIINEX OIH16 Internal/external price conditions INEX
VBAK OIINEX VBAK MANDT OIH16 Internal/external price conditions MANDT
VBAK OIPBL VBAK MANDT OIFSPBL Physical Location - Master Data MANDT
VBAK OIPBL VBAK OIPBL OIFSPBL Physical Location - Master Data PBLNR
VBAK OIU_CT_TYPE_CD VBAK OIU_CT_TYPE_CD OIU_CM_CTTYP Contract Type (TBLCS007) CT_TYPE_CD
VBAK OIU_GPLT_COMPANY SYST MANDT T001 Company Codes MANDT
VBAK OIU_GPLT_COMPANY VBAK OIU_GPLT_COMPANY T001 Company Codes BUKRS
VBAK OIU_GPLT_VNAME VBAK OIU_GPLT_COMPANY OIU_DO_JV PRA venture extension BUKRS
VBAK OIU_GPLT_VNAME VBAK OIU_GPLT_VNAME OIU_DO_JV PRA venture extension VNAME
VBAK OIU_GPLT_VNAME SYST MANDT OIU_DO_JV PRA venture extension MANDT
VBAK OIU_MMS_TYPE_CD SYST MANDT OIUREP_SALESTY MMS-2014: Sales Type Control Table MANDT
VBAK OIU_MMS_TYPE_CD VBAK OIU_MMS_TYPE_CD OIUREP_SALESTY MMS-2014: Sales Type Control Table SALES_TYPE_CD
VBAK PHASE VBAK PHASE HBSSPH Permitted Sales Phases PHASE
VBAK PHASE * HBSSPH Permitted Sales Phases MANDT
VBAK PHASE * HBSSPH Permitted Sales Phases BUKRS
VBAK PHASE VBAK SWENR HBSSPH Permitted Sales Phases SWENR
VBAK PROLI VBAK MANDT TDGC5 DG: Dangerous Goods Management Profile for SD Documents MANDT
VBAK PROLI VBAK PROLI TDGC5 DG: Dangerous Goods Management Profile for SD Documents PROLI
VBAK PS_PSP_PNR VBAK MANDT PRPS WBS (Work Breakdown Structure) Element Master Data MANDT
VBAK PS_PSP_PNR VBAK PS_PSP_PNR PRPS WBS (Work Breakdown Structure) Element Master Data PSPNR
VBAK QMNUM VBAK MANDT QMEL Quality Notification MANDT
VBAK QMNUM VBAK QMNUM QMEL Quality Notification QMNUM
VBAK RPLNR VBAK MANDT FPLA Billing Plan MANDT
VBAK RPLNR VBAK RPLNR FPLA Billing Plan FPLNR
VBAK SBGRP VBAK MANDT T024B Credit management: Credit representative groups MANDT
VBAK SBGRP VBAK SBGRP T024B Credit management: Credit representative groups SBGRP
VBAK SBGRP VBAK KKBER T024B Credit management: Credit representative groups KKBER
VBAK SCHEME_GRP VBAK MANDT TVGRPS Group referencing requirement: Procedures MANDT
VBAK SCHEME_GRP VBAK SCHEME_GRP TVGRPS Group referencing requirement: Procedures SCHEME
VBAK SMENR VBAK SMENR VIMI01 Rental unit - Master data SMENR
VBAK SMENR * VIMI01 Rental unit - Master data MANDT
VBAK SMENR * VIMI01 Rental unit - Master data BUKRS
VBAK SMENR VBAK SWENR VIMI01 Rental unit - Master data SWENR
VBAK SPART VBAK VTWEG TVTA Organizational Unit: Sales Area(s) VTWEG
VBAK SPART VBAK SPART TVTA Organizational Unit: Sales Area(s) SPART
VBAK SPART VBAK MANDT TVTA Organizational Unit: Sales Area(s) MANDT
VBAK SPART VBAK VKORG TVTA Organizational Unit: Sales Area(s) VKORG
VBAK STCEG_L VBAK MANDT T005 Countries MANDT
VBAK STCEG_L VBAK STCEG_L T005 Countries LAND1
VBAK STWAE VBAK MANDT TCURC Currency Codes MANDT
VBAK STWAE VBAK STWAE TCURC Currency Codes WAERS
VBAK SWENR * VIOB01 Business entities MANDT
VBAK SWENR * VIOB01 Business entities BUKRS
VBAK SWENR VBAK SWENR VIOB01 Business entities SWENR
VBAK VBELN VBAK MANDT VBUK Sales Document: Header Status and Administrative Data MANDT
VBAK VBELN VBAK VBELN VBUK Sales Document: Header Status and Administrative Data VBELN
VBAK VGBEL VBAK MANDT VBUK Sales Document: Header Status and Administrative Data MANDT
VBAK VGBEL VBAK VGBEL VBUK Sales Document: Header Status and Administrative Data VBELN
VBAK VKBUR VBAK VTWEG TVKBZ Org.Unit: Sales Office: Assignment to Organizational Unit VTWEG
VBAK VKBUR VBAK SPART TVKBZ Org.Unit: Sales Office: Assignment to Organizational Unit SPART
VBAK VKBUR VBAK VKBUR TVKBZ Org.Unit: Sales Office: Assignment to Organizational Unit VKBUR
VBAK VKBUR VBAK MANDT TVKBZ Org.Unit: Sales Office: Assignment to Organizational Unit MANDT
VBAK VKBUR VBAK VKORG TVKBZ Org.Unit: Sales Office: Assignment to Organizational Unit VKORG
VBAK VKGRP VBAK MANDT TVBVK Organizational Unit: Sales Groups per Sales Office MANDT
VBAK VKGRP VBAK VKBUR TVBVK Organizational Unit: Sales Groups per Sales Office VKBUR
VBAK VKGRP VBAK VKGRP TVBVK Organizational Unit: Sales Groups per Sales Office VKGRP
VBAK VKORG VBAK MANDT TVKO Organizational Unit: Sales Organizations MANDT
VBAK VKORG VBAK VKORG TVKO Organizational Unit: Sales Organizations VKORG
VBAK VSBED VBAK MANDT TVSB Shipping Conditions MANDT
VBAK VSBED VBAK VSBED TVSB Shipping Conditions VSBED
VBAK VTWEG VBAK MANDT TVKOV Org. Unit: Distribution Channels per Sales Organization MANDT
VBAK VTWEG VBAK VKORG TVKOV Org. Unit: Distribution Channels per Sales Organization VKORG
VBAK VTWEG VBAK VTWEG TVKOV Org. Unit: Distribution Channels per Sales Organization VTWEG
VBAK WAERK VBAK MANDT TCURC Currency Codes MANDT
VBAK WAERK VBAK WAERK TCURC Currency Codes WAERS