SAP Table VBDKA

Document Header View for Inquiry,Quotation,Order

VBDKA (Document Header View for Inquiry,Quotation,Order) 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 VBDKA to other SAP tables.

VBDKA table fields

Field Data element Checktable Datatype Length Decimals
ANRED Title ANRED CHAR 15 0
ADRNR Address number AD_ADDRNUM CHAR 10 0
ADRNP Person number AD_PERSNUM CHAR 10 0
ADDRESS_TYPE Address type (1=Organization, 2=Person, 3=Contact person) AD_ADRTYPE CHAR 1 0
1 Organization, Company
2 Private address
3 Contact person (in company)
NAME1 Name 1 NAME1_GP CHAR 35 0
NAME2 Name 2 NAME2_GP CHAR 35 0
NAME3 Name 3 NAME3_GP CHAR 35 0
NAME4 Name 4 NAME4_GP CHAR 35 0
STRAS House number and street STRAS_GP CHAR 35 0
PFACH PO Box PFACH CHAR 10 0
PFORT PO Box city PFORT_GP CHAR 35 0
PSTL2 P.O. Box Postal Code PSTL2 CHAR 10 0
LAND1 Country Key LAND1 T005 CHAR 3 0
SPRAS Language Key SPRAS T002 LANG 1 0
PSTLZ Postal Code PSTLZ CHAR 10 0
ORT01 City ORT01_GP CHAR 35 0
ORT02 District ORT02_GP CHAR 35 0
REGIO Region (State, Province, County) REGIO T005S CHAR 3 0
KUNNR Customer Number KUNNR CHAR 10 0
VKORG Sales Organization VKORG TVKO CHAR 4 0
VTWEG Distribution Channel VTWEG TVKOV CHAR 2 0
SPART Division SPART TVTA CHAR 2 0
SPRAS_VKO Language Key SPRAS T002 LANG 1 0
VKBUR Sales Office VKBUR TVBUR CHAR 4 0
SPRAS_VBUR Language Key SPRAS T002 LANG 1 0
VBELN Sales and Distribution Document Number VBELN VBUK CHAR 10 0
AUDAT Document Date (Date Received/Sent) AUDAT DATS 8 0
BSTNK Customer purchase order number BSTNK CHAR 20 0
BSTDK Customer purchase order date BSTDK DATS 8 0
BSARK Customer purchase order type BSARK CHAR 4 0
BSARK_BEZ Description of purchase order type BSARK_BEZ CHAR 20 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
VBELN_VANG Preceding sales and distribution document VBELN_VON VBUK CHAR 10 0
VBTYP_VANG 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
AUDAT_VANG Quotation Date AUDAT_VANG DATS 8 0
HERKL Three-digit character field for IDocs CHAR03 CHAR 3 0
LLAND Country of Destination LLAND T005 CHAR 3 0
ALAND Departure country (country from which the goods are sent) ALAND T005 CHAR 3 0
SLAND Sending country for processing address SLAND T005 CHAR 3 0
ANRED_WE Title ANRED CHAR 15 0
ADRNR_WE Address number AD_ADDRNUM CHAR 10 0
ADRNP_WE Person number AD_PERSNUM CHAR 10 0
ADDRESS_TYPE_WE Address type (1=Organization, 2=Person, 3=Contact person) AD_ADRTYPE CHAR 1 0
1 Organization, Company
2 Private address
3 Contact person (in company)
NAME1_WE Name 1 NAME1_GP CHAR 35 0
NAME2_WE Name 2 NAME2_GP CHAR 35 0
NAME3_WE Name 3 NAME3_GP CHAR 35 0
NAME4_WE Name 4 NAME4_GP CHAR 35 0
STRAS_WE House number and street STRAS_GP CHAR 35 0
PFACH_WE PO Box PFACH CHAR 10 0
PFORT_WE PO Box city PFORT_GP CHAR 35 0
PSTL2_WE P.O. Box Postal Code PSTL2 CHAR 10 0
LAND1_WE Country Key LAND1 T005 CHAR 3 0
SPRAS_WE Language Key SPRAS T002 LANG 1 0
PSTLZ_WE Postal Code PSTLZ CHAR 10 0
ORT01_WE City ORT01_GP CHAR 35 0
ORT02_WE District ORT02_GP CHAR 35 0
REGIO_WE Region (State, Province, County) REGIO T005S CHAR 3 0
VSBED Shipping Conditions VSBED TVSB CHAR 2 0
VSBED_BEZ Description of the shipping conditions VSBED_BEZ CHAR 20 0
BUKRS_VF Company code to be billed BUKRS_VF T001 CHAR 4 0
INCO1 Incoterms (Part 1) INCO1 TINC CHAR 3 0
INCO2 Incoterms (Part 2) INCO2 CHAR 28 0
INCO1_BEZ Incoterm description INCO1_BEZ CHAR 30 0
ZTERM Terms of Payment Key DZTERM CHAR 4 0
ZTERM_BEZ Description of terms of payment DZTERM_BEZ CHAR 30 0
ZTERM_TX1 Text (80 Characters) TEXT80 CHAR 80 0
ZTERM_TX2 Text (80 Characters) TEXT80 CHAR 80 0
ZTERM_TX3 Text (80 Characters) TEXT80 CHAR 80 0
ZTERM_TX4 Text (80 Characters) TEXT80 CHAR 80 0
LFDAT Delivery date LFDAT_EXT CHAR 10 0
DATBEZ Description of the date format (day, week, month) DATBEZ CHAR 8 0
BRGEW Gross weight BRGEW_15 QUAN 15 3
NTGEW Net weight NTGEW_15 QUAN 15 3
GEWEI Weight Unit GEWEI T006 UNIT 3 0
VOLUM Volume VOLUM_15 QUAN 15 3
VOLEH Volume unit VOLEH T006 UNIT 3 0
WAERS Currency Key WAERS CUKY 5 0
WAERK SD Document Currency WAERK TCURC CUKY 5 0
KURST Exchange Rate Type KURST TCURV CHAR 4 0
KURRF Exchange rate for FI postings KURRF DEC 9 5
KURRF_DAT Translation Date WWERT_D DATS 8 0
NETWR Net Value of the Sales Order in Document Currency NETWR_AK CURR 15 2
TDNAME Name TDOBNAME CHAR 70 0
KALSM Procedure (Pricing, Output Control, Acct. Det., Costing,...) KALSM_D T683 CHAR 6 0
KNUMV Number of the document condition KNUMV CHAR 10 0
KNUMA Agreement (various conditions grouped together) KNUMA KONA CHAR 10 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
ANGDT Quotation Validity Date ANGDT DATS 8 0
BNDDT Date until which bid/quotation is binding (valid-to date) BNDDT DATS 8 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
KDGRP Customer group KDGRP CHAR 2 0
KDGRP_BEZ Description of customer group KDGRP_BEZ CHAR 20 0
BZIRK Sales district BZIRK CHAR 6 0
BZIRK_BEZ Name of the district BZTXT CHAR 20 0
VALTG Additional value days VALTG NUMC 2 0
VALDT Fixed value date VALDT DATS 8 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
AUART Sales Document Type AUART CHAR 4 0
AUART_BEZ Description of sales order type AUART_BEZ CHAR 20 0
AUGRU Order reason (reason for the business transaction) AUGRU CHAR 3 0
AUGRU_BEZ Description of sales order reason AUGRU_BEZ CHAR 40 0
GWLDT Warranty Date GWLDT DATS 8 0
SUBMI Collective Number SUBMI CHAR 10 0
LIFSK Delivery block (document header) LIFSK CHAR 2 0
FAKSK Billing block in SD document FAKSK CHAR 2 0
VKGRP Sales Group VKGRP CHAR 3 0
VKGRP_BEZ Description of Sales Group VKGRP_BEZ CHAR 20 0
KOSTL Cost Center KOSTL CHAR 10 0
GSBER Business Area GSBER CHAR 4 0
GSKST Business area from cost center GSKST CHAR 4 0
AUTLF Complete delivery defined for each sales order? AUTLF CHAR 1 0
X Yes
NULL No
P_SPLIT Split terms of payment P_SPLIT CHAR 1 0
TEXT Char 80 CHAR80 CHAR 80 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)
DELCO Agreed delivery time DELCO CHAR 3 0
DELCO_BEZ Description BEZEI20 CHAR 20 0
BSTKD Customer purchase order number BSTKD CHAR 35 0
BSTKD_E Ship-to Party's Purchase Order Number BSTKD_E CHAR 35 0
BSTDK_E Ship-to party's PO date BSTDK_E DATS 8 0
BSARK_E Ship-to party purchase order type BSARK_E CHAR 4 0
BSARK_BEZE Description of purchase order type BSARK_BEZ CHAR 20 0
IHREZ_E Ship-to party character IHREZ_E CHAR 12 0
MSR_ID Process Identification Number MSR_PROCESS_ID CHAR 10 0
DUMMY Dummy function in length 1 DUMMY CHAR 1 0

VBDKA foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
VBDKA ALAND SYST MANDT T005 Countries MANDT
VBDKA ALAND VBDKA ALAND T005 Countries LAND1
VBDKA BUKRS_VF SYST MANDT T001 Company Codes MANDT
VBDKA BUKRS_VF VBDKA BUKRS_VF T001 Company Codes BUKRS
VBDKA GEWEI SYST MANDT T006 Units of Measurement MANDT
VBDKA GEWEI VBDKA GEWEI T006 Units of Measurement MSEHI
VBDKA INCO1 SYST MANDT TINC Customers: Incoterms MANDT
VBDKA INCO1 VBDKA INCO1 TINC Customers: Incoterms INCO1
VBDKA KALSM VBDKA KALSM T683 Pricing procedures KALSM
VBDKA KALSM SYST MANDT T683 Pricing procedures MANDT
VBDKA KALSM T681V KVEWE T683 Pricing procedures KVEWE
VBDKA KALSM T681A KAPPL T683 Pricing procedures KAPPL
VBDKA KNUMA SYST MANDT KONA Agreements MANDT
VBDKA KNUMA VBDKA KNUMA KONA Agreements KNUMA
VBDKA KURST SYST MANDT TCURV Exchange rate types for currency translation MANDT
VBDKA KURST VBDKA KURST TCURV Exchange rate types for currency translation KURST
VBDKA LAND1 SYST MANDT T005 Countries MANDT
VBDKA LAND1 VBDKA LAND1 T005 Countries LAND1
VBDKA LAND1_WE SYST MANDT T005 Countries MANDT
VBDKA LAND1_WE VBDKA LAND1_WE T005 Countries LAND1
VBDKA LLAND VBDKA LLAND T005 Countries LAND1
VBDKA LLAND SYST MANDT T005 Countries MANDT
VBDKA REGIO VBDKA REGIO T005S Taxes: Region (Province) Key BLAND
VBDKA REGIO SYST MANDT T005S Taxes: Region (Province) Key MANDT
VBDKA REGIO VBDKA LAND1 T005S Taxes: Region (Province) Key LAND1
VBDKA REGIO_WE SYST MANDT T005S Taxes: Region (Province) Key MANDT
VBDKA REGIO_WE VBDKA LAND1_WE T005S Taxes: Region (Province) Key LAND1
VBDKA REGIO_WE VBDKA REGIO_WE T005S Taxes: Region (Province) Key BLAND
VBDKA SLAND SYST MANDT T005 Countries MANDT
VBDKA SLAND VBDKA SLAND T005 Countries LAND1
VBDKA SPART SYST MANDT TVTA Organizational Unit: Sales Area(s) MANDT
VBDKA SPART VBDKA VKORG TVTA Organizational Unit: Sales Area(s) VKORG
VBDKA SPART VBDKA VTWEG TVTA Organizational Unit: Sales Area(s) VTWEG
VBDKA SPART VBDKA SPART TVTA Organizational Unit: Sales Area(s) SPART
VBDKA SPRAS VBDKA SPRAS T002 Language Keys (Component BC-I18) SPRAS
VBDKA SPRAS_VBUR VBDKA SPRAS_VBUR T002 Language Keys (Component BC-I18) SPRAS
VBDKA SPRAS_VKO VBDKA SPRAS_VKO T002 Language Keys (Component BC-I18) SPRAS
VBDKA SPRAS_WE VBDKA SPRAS_WE T002 Language Keys (Component BC-I18) SPRAS
VBDKA VBELN VBDKA VBELN VBUK Sales Document: Header Status and Administrative Data VBELN
VBDKA VBELN SYST MANDT VBUK Sales Document: Header Status and Administrative Data MANDT
VBDKA VBELN_VANG SYST MANDT VBUK Sales Document: Header Status and Administrative Data MANDT
VBDKA VBELN_VANG VBDKA VBELN_VANG VBUK Sales Document: Header Status and Administrative Data VBELN
VBDKA VKBUR SYST MANDT TVBUR Organizational Unit: Sales Offices MANDT
VBDKA VKBUR VBDKA VKBUR TVBUR Organizational Unit: Sales Offices VKBUR
VBDKA VKORG SYST MANDT TVKO Organizational Unit: Sales Organizations MANDT
VBDKA VKORG VBDKA VKORG TVKO Organizational Unit: Sales Organizations VKORG
VBDKA VOLEH SYST MANDT T006 Units of Measurement MANDT
VBDKA VOLEH VBDKA VOLEH T006 Units of Measurement MSEHI
VBDKA VSBED SYST MANDT TVSB Shipping Conditions MANDT
VBDKA VSBED VBDKA VSBED TVSB Shipping Conditions VSBED
VBDKA VTWEG SYST MANDT TVKOV Org. Unit: Distribution Channels per Sales Organization MANDT
VBDKA VTWEG VBDKA VKORG TVKOV Org. Unit: Distribution Channels per Sales Organization VKORG
VBDKA VTWEG VBDKA VTWEG TVKOV Org. Unit: Distribution Channels per Sales Organization VTWEG
VBDKA WAERK SYST MANDT TCURC Currency Codes MANDT
VBDKA WAERK VBDKA WAERK TCURC Currency Codes WAERS