SAP table VBDKA (Document Header View for Inquiry,Quotation,Order)

Field Description Data Type Length Decimals Checktable Data Element
ANRED Title CHAR 15 0 ANRED
ADRNR Address Number CHAR 10 0 AD_ADDRNUM
ADRNP Person Number CHAR 10 0 AD_PERSNUM
ADDRESS_TYPE Address type (1=Organization, 2=Person, 3=Contact person) CHAR 1 0 AD_ADRTYPE
1 Organization, Company
2 Private address
3 Contact person (in company)
NAME1 Name 1 CHAR 35 0 NAME1_GP
NAME2 Name 2 CHAR 35 0 NAME2_GP
NAME3 Name 3 CHAR 35 0 NAME3_GP
NAME4 Name 4 CHAR 35 0 NAME4_GP
STRAS Street and House Number CHAR 35 0 STRAS_GP
PFACH PO Box CHAR 10 0 PFACH
PFORT PO Box city CHAR 35 0 PFORT_GP
PSTL2 P.O. Box Postal Code CHAR 10 0 PSTL2
LAND1 Country/Region Key CHAR 3 0 T005 LAND1
SPRAS Language Key LANG 1 0 T002 SPRAS
PSTLZ Postal Code CHAR 10 0 PSTLZ
ORT01 City CHAR 35 0 ORT01_GP
ORT02 District CHAR 35 0 ORT02_GP
REGIO Region (State, Province, County) CHAR 3 0 T005S REGIO
KUNNR Customer Number CHAR 10 0 KUNNR
VKORG Sales Organization CHAR 4 0 TVKO VKORG
VTWEG Distribution Channel CHAR 2 0 TVKOV VTWEG
SPART Division CHAR 2 0 TVTA SPART
SPRAS_VKO Language Key LANG 1 0 T002 SPRAS
VKBUR Sales office CHAR 4 0 TVBUR VKBUR
SPRAS_VBUR Language Key LANG 1 0 T002 SPRAS
VBELN Sales and Distribution Document Number CHAR 10 0 VBELN
AUDAT Document Date (Date Received/Sent) DATS 8 0 AUDAT
BSTNK Customer Reference CHAR 20 0 BSTNK
BSTDK Customer Reference Date DATS 8 0 BSTDK
BSARK Customer Purchase Order Type CHAR 4 0 BSARK
BSARK_BEZ Description of purchase order type CHAR 20 0 BSARK_BEZ
BSTZD Purchase order number supplement CHAR 4 0 BSTZD
IHREZ Your Reference CHAR 12 0 IHREZ
BNAME Name of orderer CHAR 35 0 BNAME_V
TELF1 Telephone Number CHAR 16 0 TELF1_VP
VBELN_VANG Preceding sales and distribution document CHAR 10 0 VBELN_VON
VBTYP_VANG SD Document Category CHAR 4 0 VBTYPL
# Revenue Recognition (Temporary)
$ (AFS)
& Warehouse Document
* Pick Order
+ Journal Entry (Temporary)
, Shipment Document
- Journal Entry (Temporary)
. Service Notification
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
: Service Order
A Inquiry
a Shipment Costs
b CRM Opportunity
B Quotation
BOS Service Entry Sheet
C Order
c Unverified Delivery
CEM ETM Shipping Document
CMMA Customer Management Master Agreement
CSCO Customer Management Service Confirmation
CSCT Customer Management Service Contract
CSVO Customer Management Service Order
D Item Proposal
d Trading Contract
e Allocation Table
E Scheduling Agreement
EBDR Billing Document Request
F Scheduling Agreement with External Service Agent
f001 Period-End Invoice
f002 Period-End Credit Memo
f003 Period-End Invoice (Intercompany Billing)
f004 Period-End Credit Memo (Intercompany Billing)
G Contract
g Rough Goods Receipt (only IS-Retail)
GBRQ Grants Management Billing Request
h Cancel Goods Issue
H Returns
i Goods Receipt
I Order Without Charge
J Delivery
j JIT Call
K Credit Memo Request
k Settlement Management Document
L Debit Memo Request
M Invoice
N Invoice Cancellation
n Reserved
O Credit Memo
o Reserved
P Debit Memo
p Goods Movement (Documentation)
PBD Preliminary Billing Document
PBDR Billing Document Request for Prof. Serv.
PBRQ Project Billing Request
q Reserved
Q WMS Transfer Order
R Goods Movement
r TD Transport (Only IS-Oil)
S Credit Memo Cancellation
s Load Confirmation, Reposting (Only IS-Oil)
SBRQ Subscription Billing Request
SOLO Solution Order
t Gain / Loss (Only IS-Oil)
T Returns Delivery for Order
TMFO Freight Order
TMFU Freight Unit
U Pro Forma Invoice
u Reentry into Storage (Only IS-Oil)
v Data Collation (Only IS-Oil)
V Purchase Order
W Independent Reqts Plan
w Reservation (Only IS-Oil)
X Handling Unit
x Load Confirmation, Goods Receipt (Only IS-Oil)
Y Rebate Agreement
^ Reserved
| Reserved
~ Revenue Cancellation (Temporary)
ยง Revenue Recognition/New View (Temporary)
AUDAT_VANG Quotation Date DATS 8 0 AUDAT_VANG
HERKL Three-digit character field for IDocs CHAR 3 0 CHAR03
LLAND Destination Country/Region CHAR 3 0 T005 LLAND
ALAND Departure Country/Region (from which the goods are sent) CHAR 3 0 T005 ALAND
SLAND Sending country/region for processing address CHAR 3 0 T005 SLAND
ANRED_WE Title CHAR 15 0 ANRED
ADRNR_WE Address Number CHAR 10 0 AD_ADDRNUM
ADRNP_WE Person Number CHAR 10 0 AD_PERSNUM
ADDRESS_TYPE_WE Address type (1=Organization, 2=Person, 3=Contact person) CHAR 1 0 AD_ADRTYPE
1 Organization, Company
2 Private address
3 Contact person (in company)
NAME1_WE Name 1 CHAR 35 0 NAME1_GP
NAME2_WE Name 2 CHAR 35 0 NAME2_GP
NAME3_WE Name 3 CHAR 35 0 NAME3_GP
NAME4_WE Name 4 CHAR 35 0 NAME4_GP
STRAS_WE Street and House Number CHAR 35 0 STRAS_GP
PFACH_WE PO Box CHAR 10 0 PFACH
PFORT_WE PO Box city CHAR 35 0 PFORT_GP
PSTL2_WE P.O. Box Postal Code CHAR 10 0 PSTL2
LAND1_WE Country/Region Key CHAR 3 0 T005 LAND1
SPRAS_WE Language Key LANG 1 0 T002 SPRAS
PSTLZ_WE Postal Code CHAR 10 0 PSTLZ
ORT01_WE City CHAR 35 0 ORT01_GP
ORT02_WE District CHAR 35 0 ORT02_GP
REGIO_WE Region (State, Province, County) CHAR 3 0 T005S REGIO
VSBED Shipping Conditions CHAR 2 0 TVSB VSBED
VSBED_BEZ Shipping Conditions Description CHAR 20 0 VSBED_BEZ
BUKRS_VF Company Code to Be Billed CHAR 4 0 T001 BUKRS_VF
INCO1 Incoterms (Part 1) CHAR 3 0 TINC INCO1
INCO2 Incoterms (Part 2) CHAR 28 0 INCO2
INCO1_BEZ Incoterm description CHAR 30 0 INCO1_BEZ
ZTERM Terms of payment key CHAR 4 0 DZTERM
ZTERM_BEZ Description of terms of payment CHAR 30 0 DZTERM_BEZ
ZTERM_TX1 Text (80 Characters) CHAR 80 0 TEXT80
ZTERM_TX2 Text (80 Characters) CHAR 80 0 TEXT80
ZTERM_TX3 Text (80 Characters) CHAR 80 0 TEXT80
ZTERM_TX4 Text (80 Characters) CHAR 80 0 TEXT80
LFDAT Delivery date CHAR 10 0 LFDAT_EXT
DATBEZ Description of the date format (day, week, month) CHAR 8 0 DATBEZ
BRGEW Gross weight QUAN 15 3 BRGEW_15
NTGEW Net weight QUAN 15 3 NTGEW_15
GEWEI Weight Unit UNIT 3 0 T006 GEWEI
VOLUM Volume QUAN 15 3 VOLUM_15
VOLEH Volume unit UNIT 3 0 T006 VOLEH
WAERS Currency Key CUKY 5 0 WAERS
WAERK SD Document Currency CUKY 5 0 TCURC WAERK
KURST Exchange Rate Type CHAR 4 0 TCURV KURST
KURRF Exchange Rate for Postings to Financial Accounting DEC 9 5 KURRF
KURRF_DAT Translation date DATS 8 0 WWERT_D
NETWR Net Value of the Sales Order in Document Currency CURR 15 2 NETWR_AK
TDNAME Name CHAR 70 0 TDOBNAME
KALSM Procedure (Pricing, Output Control, Acct. Det., Costing,...) CHAR 6 0 T683 KALSM_D
KNUMV Number of the Document Condition CHAR 10 0 KNUMV
KNUMA Agreement (various conditions grouped together) CHAR 10 0 KONA KNUMA
VBTYP SD Document Category CHAR 4 0 VBTYPL
# Revenue Recognition (Temporary)
$ (AFS)
& Warehouse Document
* Pick Order
+ Journal Entry (Temporary)
, Shipment Document
- Journal Entry (Temporary)
. Service Notification
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
: Service Order
A Inquiry
a Shipment Costs
b CRM Opportunity
B Quotation
BOS Service Entry Sheet
C Order
c Unverified Delivery
CEM ETM Shipping Document
CMMA Customer Management Master Agreement
CSCO Customer Management Service Confirmation
CSCT Customer Management Service Contract
CSVO Customer Management Service Order
D Item Proposal
d Trading Contract
e Allocation Table
E Scheduling Agreement
EBDR Billing Document Request
F Scheduling Agreement with External Service Agent
f001 Period-End Invoice
f002 Period-End Credit Memo
f003 Period-End Invoice (Intercompany Billing)
f004 Period-End Credit Memo (Intercompany Billing)
G Contract
g Rough Goods Receipt (only IS-Retail)
GBRQ Grants Management Billing Request
h Cancel Goods Issue
H Returns
i Goods Receipt
I Order Without Charge
J Delivery
j JIT Call
K Credit Memo Request
k Settlement Management Document
L Debit Memo Request
M Invoice
N Invoice Cancellation
n Reserved
O Credit Memo
o Reserved
P Debit Memo
p Goods Movement (Documentation)
PBD Preliminary Billing Document
PBDR Billing Document Request for Prof. Serv.
PBRQ Project Billing Request
q Reserved
Q WMS Transfer Order
R Goods Movement
r TD Transport (Only IS-Oil)
S Credit Memo Cancellation
s Load Confirmation, Reposting (Only IS-Oil)
SBRQ Subscription Billing Request
SOLO Solution Order
t Gain / Loss (Only IS-Oil)
T Returns Delivery for Order
TMFO Freight Order
TMFU Freight Unit
U Pro Forma Invoice
u Reentry into Storage (Only IS-Oil)
v Data Collation (Only IS-Oil)
V Purchase Order
W Independent Reqts Plan
w Reservation (Only IS-Oil)
X Handling Unit
x Load Confirmation, Goods Receipt (Only IS-Oil)
Y Rebate Agreement
^ Reserved
| Reserved
~ Revenue Cancellation (Temporary)
ยง Revenue Recognition/New View (Temporary)
ANGDT Quotation Validity Date DATS 8 0 ANGDT
BNDDT Date Until Which Bid/Quotation is Binding (Valid-To Date) DATS 8 0 BNDDT
GUEBG Valid-From Date (Outline Agreements, Product Proposals) DATS 8 0 GUEBG
GUEEN Valid-To Date (Outline Agreements, Product Proposals) DATS 8 0 GUEEN
KDGRP Customer Group CHAR 2 0 KDGRP
KDGRP_BEZ Description of customer group CHAR 20 0 KDGRP_BEZ
BZIRK Sales District CHAR 6 0 BZIRK
BZIRK_BEZ Name of the district CHAR 20 0 BZTXT
VALTG Additional Value Days NUMC 2 0 VALTG
VALDT Fixed Value Date DATS 8 0 VALDT
ERDAT Date on which the record was created DATS 8 0 ERDAT
ERZET Entry time TIMS 6 0 ERZET
ERNAM Name of Person Responsible for Creating the Object CHAR 12 0 ERNAM
AUART Sales Document Type CHAR 4 0 AUART
AUART_BEZ Description of sales order type CHAR 20 0 AUART_BEZ
AUGRU Order Reason (Reason for the Business Transaction) CHAR 3 0 AUGRU
AUGRU_BEZ Description of sales order reason CHAR 40 0 AUGRU_BEZ
GWLDT Guarantee date DATS 8 0 GWLDT
SUBMI Collective Number CHAR 10 0 SUBMI
LIFSK Delivery Block (Document Header) CHAR 2 0 LIFSK
FAKSK Billing Block in SD Document CHAR 2 0 FAKSK
VKGRP Sales group CHAR 3 0 VKGRP
VKGRP_BEZ Description of Sales Group CHAR 20 0 VKGRP_BEZ
KOSTL Cost Center CHAR 10 0 KOSTL
GSBER Business Area CHAR 4 0 GSBER
GSKST Business Area from Cost Center CHAR 4 0 GSKST
AUTLF Complete Delivery Defined for Each Sales Order? CHAR 1 0 AUTLF
P_SPLIT Split terms of payment CHAR 1 0 P_SPLIT
TEXT Char 80 CHAR 80 0 CHAR80
VBKLT SD document indicator CHAR 1 0 VBKLT
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
J JIT Scheduling Agt
K Correct consignment issue by external service agent
P Project-Based Services (PBS)
R Order for Billing Between Company Codes (RRICB)
S Solution Order
DELCO Agreed Delivery Time CHAR 3 0 DELCO
DELCO_BEZ Description CHAR 20 0 BEZEI20
BSTKD Customer Reference CHAR 35 0 BSTKD
BSTKD_E Ship-to Party's Customer Reference CHAR 35 0 BSTKD_E
BSTDK_E Ship-to Party's Customer Reference Date DATS 8 0 BSTDK_E
BSARK_E Ship-to Party Purchase Order Type CHAR 4 0 BSARK_E
BSARK_BEZE Description of purchase order type CHAR 20 0 BSARK_BEZ
IHREZ_E Ship-to Party Character CHAR 12 0 IHREZ_E
MSR_ID Process Identification Number CHAR 10 0 MSR_PROCESS_ID
DUMMY Dummy function in length 1 CHAR 1 0 DUMMY
SUPOS Net Value of the Sales Order in Document Currency CURR 15 2 NETWR_AK
INCOV Incoterms Version CHAR 4 0 TINCV INCOV
INCO2_L Incoterms Location 1 CHAR 70 0 INCO2_L
INCO3_L Incoterms Location 2 CHAR 70 0 INCO3_L
INCO2_L_LBL Incoterms Location 1 Label CHAR 25 0 INCO2_L_LBL
INCO3_L_LBL Incoterms Location 2 Label CHAR 25 0 INCO3_L_LBL
BSTOB Location2 is mandatory CHAR 1 0 BSTOB
Disabled
O Optional
R Required

VBDKA foreign key relationships

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