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

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM-BTX-BF-IF (Application Component) R/3 Interface for Business Transactions
     ⤷ VZ (Package) Application development R/3 RV central functions

Basic Data

Table Category	INTTAB	Structure
Structure	VBDKA	Table Relationship Diagram
Short Description	Document Header View for Inquiry,Quotation,Order

Delivery and Maintenance

Pool/cluster
Delivery Class
Data Browser/Table View Maintenance	Display/Maintenance Allowed with Restrictions

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	ANRED	☐	ANRED	TEXT15	CHAR	15	0	Title
2	ADRNR	☐	AD_ADDRNUM	AD_ADDRNUM	CHAR	10	0	Address number	*
3	ADRNP	☐	AD_PERSNUM	AD_PERSNUM	CHAR	10	0	Person number	*
4	ADDRESS_TYPE	☐	AD_ADRTYPE	AD_ADRTYPE	CHAR	1	0	Address type (1=Organization, 2=Person, 3=Contact person)
5	NAME1	☐	NAME1_GP	NAME	CHAR	35	0	Name 1
6	NAME2	☐	NAME2_GP	NAME	CHAR	35	0	Name 2
7	NAME3	☐	NAME3_GP	NAME	CHAR	35	0	Name 3
8	NAME4	☐	NAME4_GP	NAME	CHAR	35	0	Name 4
9	STRAS	☐	STRAS_GP	TEXT35	CHAR	35	0	House number and street
10	PFACH	☐	PFACH	PFACH	CHAR	10	0	PO Box
11	PFORT	☐	PFORT_GP	TEXT35	CHAR	35	0	PO Box city
12	PSTL2	☐	PSTL2	PSTLZ	CHAR	10	0	P.O. Box Postal Code
13	LAND1	☐	LAND1	LAND1	CHAR	3	0	Country Key	T005
14	SPRAS	☐	SPRAS	SPRAS	LANG	1	0	Language Key	T002
15	PSTLZ	☐	PSTLZ	PSTLZ	CHAR	10	0	Postal Code
16	ORT01	☐	ORT01_GP	TEXT35	CHAR	35	0	City
17	ORT02	☐	ORT02_GP	TEXT35	CHAR	35	0	District
18	REGIO	☐	REGIO	REGIO	CHAR	3	0	Region (State, Province, County)	T005S
19	KUNNR	☐	KUNNR	KUNNR	CHAR	10	0	Customer Number	*
20	VKORG	☐	VKORG	VKORG	CHAR	4	0	Sales Organization	TVKO
21	VTWEG	☐	VTWEG	VTWEG	CHAR	2	0	Distribution Channel	TVKOV
22	SPART	☐	SPART	SPART	CHAR	2	0	Division	TVTA
23	SPRAS_VKO	☐	SPRAS	SPRAS	LANG	1	0	Language Key	T002
24	VKBUR	☐	VKBUR	VKBUR	CHAR	4	0	Sales office	TVBUR
25	SPRAS_VBUR	☐	SPRAS	SPRAS	LANG	1	0	Language Key	T002
26	VBELN	☐	VBELN	VBELN	CHAR	10	0	Sales and Distribution Document Number	VBUK
27	AUDAT	☐	AUDAT	DATUM	DATS	8	0	Document Date (Date Received/Sent)
28	BSTNK	☐	BSTNK	BSTNK	CHAR	20	0	Customer purchase order number
29	BSTDK	☐	BSTDK	DATUM	DATS	8	0	Customer purchase order date
30	BSARK	☐	BSARK	BSARK	CHAR	4	0	Customer Order Type	*
31	BSARK_BEZ	☐	BSARK_BEZ	TEXT20	CHAR	20	0	Description of purchase order type
32	BSTZD	☐	BSTZD	BSTZD	CHAR	4	0	Customer purchase order number supplement
33	IHREZ	☐	IHREZ	TEXT12	CHAR	12	0	Your Reference
34	BNAME	☐	BNAME_V	NAME	CHAR	35	0	Name of orderer
35	TELF1	☐	TELF1_VP	TELF1	CHAR	16	0	Telephone Number
36	VBELN_VANG	☐	VBELN_VON	VBELN	CHAR	10	0	Preceding sales and distribution document	VBUK
37	VBTYP_VANG	☐	VBTYP_V	VBTYP	CHAR	1	0	Document category of preceding SD document
38	AUDAT_VANG	☐	AUDAT_VANG	DATUM	DATS	8	0	Quotation Date
39	HERKL	☐	CHAR03	CHAR3	CHAR	3	0	Three-digit character field for IDocs
40	LLAND	☐	LLAND	LAND1	CHAR	3	0	Destination Country	T005
41	ALAND	☐	ALAND	LAND1	CHAR	3	0	Departure country (country from which the goods are sent)	T005
42	SLAND	☐	SLAND	LAND1	CHAR	3	0	Sending country for processing address	T005
43	ANRED_WE	☐	ANRED	TEXT15	CHAR	15	0	Title
44	ADRNR_WE	☐	AD_ADDRNUM	AD_ADDRNUM	CHAR	10	0	Address number	*
45	ADRNP_WE	☐	AD_PERSNUM	AD_PERSNUM	CHAR	10	0	Person number	*
46	ADDRESS_TYPE_WE	☐	AD_ADRTYPE	AD_ADRTYPE	CHAR	1	0	Address type (1=Organization, 2=Person, 3=Contact person)
47	NAME1_WE	☐	NAME1_GP	NAME	CHAR	35	0	Name 1
48	NAME2_WE	☐	NAME2_GP	NAME	CHAR	35	0	Name 2
49	NAME3_WE	☐	NAME3_GP	NAME	CHAR	35	0	Name 3
50	NAME4_WE	☐	NAME4_GP	NAME	CHAR	35	0	Name 4
51	STRAS_WE	☐	STRAS_GP	TEXT35	CHAR	35	0	House number and street
52	PFACH_WE	☐	PFACH	PFACH	CHAR	10	0	PO Box
53	PFORT_WE	☐	PFORT_GP	TEXT35	CHAR	35	0	PO Box city
54	PSTL2_WE	☐	PSTL2	PSTLZ	CHAR	10	0	P.O. Box Postal Code
55	LAND1_WE	☐	LAND1	LAND1	CHAR	3	0	Country Key	T005
56	SPRAS_WE	☐	SPRAS	SPRAS	LANG	1	0	Language Key	T002
57	PSTLZ_WE	☐	PSTLZ	PSTLZ	CHAR	10	0	Postal Code
58	ORT01_WE	☐	ORT01_GP	TEXT35	CHAR	35	0	City
59	ORT02_WE	☐	ORT02_GP	TEXT35	CHAR	35	0	District
60	REGIO_WE	☐	REGIO	REGIO	CHAR	3	0	Region (State, Province, County)	T005S
61	VSBED	☐	VSBED	VSBED	CHAR	2	0	Shipping conditions	TVSB
62	VSBED_BEZ	☐	VSBED_BEZ	TEXT20	CHAR	20	0	Description of the shipping conditions
63	BUKRS_VF	☐	BUKRS_VF	BUKRS	CHAR	4	0	Company code to be billed	T001
64	INCO1	☐	INCO1	INCO1	CHAR	3	0	Incoterms (part 1)	TINC
65	INCO2	☐	INCO2	INCO2	CHAR	28	0	Incoterms (part 2)
66	INCO1_BEZ	☐	INCO1_BEZ	TEXT30	CHAR	30	0	Incoterm description
67	ZTERM	☐	DZTERM	ZTERM	CHAR	4	0	Terms of payment key
68	ZTERM_BEZ	☐	DZTERM_BEZ	TEXT30	CHAR	30	0	Description of terms of payment
69	ZTERM_TX1	☐	TEXT80	TEXT80UEB	CHAR	80	0	Text (80 Characters)
70	ZTERM_TX2	☐	TEXT80	TEXT80UEB	CHAR	80	0	Text (80 Characters)
71	ZTERM_TX3	☐	TEXT80	TEXT80UEB	CHAR	80	0	Text (80 Characters)
72	ZTERM_TX4	☐	TEXT80	TEXT80UEB	CHAR	80	0	Text (80 Characters)
73	LFDAT	☐	LFDAT_EXT	CHAR10	CHAR	10	0	Delivery date
74	DATBEZ	☐	DATBEZ	TEXT8	CHAR	8	0	Description of the date format (day, week, month)
75	BRGEW	☐	BRGEW_15	MENG15	QUAN	15	3	Gross weight
76	NTGEW	☐	NTGEW_15	MENG15	QUAN	15	3	Net weight
77	GEWEI	☐	GEWEI	MEINS	UNIT	3	0	Weight Unit	T006
78	VOLUM	☐	VOLUM_15	MENG15	QUAN	15	3	Volume
79	VOLEH	☐	VOLEH	MEINS	UNIT	3	0	Volume unit	T006
80	WAERS	☐	WAERS	WAERS	CUKY	5	0	Currency Key	*
81	WAERK	☐	WAERK	WAERS	CUKY	5	0	SD document currency	TCURC
82	KURST	☐	KURST	KURST	CHAR	4	0	Exchange Rate Type	TCURV
83	KURRF	☐	KURRF	KURRF	DEC	9	5	Exchange rate for FI postings
84	KURRF_DAT	☐	WWERT_D	DATUM	DATS	8	0	Translation date
85	NETWR	☐	NETWR_AK	WERTV8	CURR	15	2	Net Value of the Sales Order in Document Currency
86	TDNAME	☐	TDOBNAME	TDOBNAME	CHAR	70	0	Name
87	KALSM	☐	KALSM_D	KALSM	CHAR	6	0	Procedure (Pricing, Output Control, Acct. Det., Costing,...)	T683
88	KNUMV	☐	KNUMV	KNUMV	CHAR	10	0	Number of the document condition
89	KNUMA	☐	KNUMA	KNUMA	CHAR	10	0	Agreement (various conditions grouped together)	KONA
90	VBTYP	☐	VBTYP	VBTYP	CHAR	1	0	SD document category
91	ANGDT	☐	ANGDT	DATUM	DATS	8	0	Quotation Validity Date
92	BNDDT	☐	BNDDT	DATUM	DATS	8	0	Date until which bid/quotation is binding (valid-to date)
93	GUEBG	☐	GUEBG	DATUM	DATS	8	0	Valid-from date (outline agreements, product proposals)
94	GUEEN	☐	GUEEN	DATUM	DATS	8	0	Valid-to date (outline agreements, product proposals)
95	KDGRP	☐	KDGRP	KDGRP	CHAR	2	0	Customer group	*
96	KDGRP_BEZ	☐	KDGRP_BEZ	TEXT20	CHAR	20	0	Description of customer group
97	BZIRK	☐	BZIRK	BZIRK	CHAR	6	0	Sales district	*
98	BZIRK_BEZ	☐	BZTXT	TEXT20	CHAR	20	0	Name of the district
99	VALTG	☐	VALTG	TAGE2	NUMC	2	0	Additional value days
100	VALDT	☐	VALDT	DATUM	DATS	8	0	Fixed value date
101	ERDAT	☐	ERDAT	DATUM	DATS	8	0	Date on which the record was created
102	ERZET	☐	ERZET	UZEIT	TIMS	6	0	Entry time
103	ERNAM	☐	ERNAM	USNAM	CHAR	12	0	Name of Person who Created the Object
104	AUART	☐	AUART	AUART	CHAR	4	0	Sales Document Type	*
105	AUART_BEZ	☐	AUART_BEZ	TEXT20	CHAR	20	0	Description of sales order type
106	AUGRU	☐	AUGRU	AUGRU	CHAR	3	0	Order reason (reason for the business transaction)	*
107	AUGRU_BEZ	☐	AUGRU_BEZ	TEXT40	CHAR	40	0	Description of sales order reason
108	GWLDT	☐	GWLDT	DATUM	DATS	8	0	Guarantee date
109	SUBMI	☐	SUBMI	CHAR10	CHAR	10	0	Collective Number
110	LIFSK	☐	LIFSK	LIFSP	CHAR	2	0	Delivery block (document header)	*
111	FAKSK	☐	FAKSK	FAKSP	CHAR	2	0	Billing block in SD document	*
112	VKGRP	☐	VKGRP	VKGRP	CHAR	3	0	Sales group	*
113	VKGRP_BEZ	☐	VKGRP_BEZ	TEXT20	CHAR	20	0	Description of Sales Group
114	KOSTL	☐	KOSTL	KOSTL	CHAR	10	0	Cost Center	*
115	GSBER	☐	GSBER	GSBER	CHAR	4	0	Business Area	*
116	GSKST	☐	GSKST	GSBER	CHAR	4	0	Business area from cost center	*
117	AUTLF	☐	AUTLF	XFELD	CHAR	1	0	Complete delivery defined for each sales order?
118	P_SPLIT	☐	P_SPLIT	CHAR1	CHAR	1	0	Split terms of payment
119	TEXT	☐	CHAR80	CHAR80	CHAR	80	0	Char 80
120	VBKLT	☐	VBKLT	VBKLT	CHAR	1	0	SD document indicator
121	DELCO	☐	DELCO	DELCO	CHAR	3	0	Agreed delivery time
122	DELCO_BEZ	☐	BEZEI20	TEXT20	CHAR	20	0	Description
123	BSTKD	☐	BSTKD	BSTKD	CHAR	35	0	Customer purchase order number
124	BSTKD_E	☐	BSTKD_E	BSTKD	CHAR	35	0	Ship-to Party's Purchase Order Number
125	BSTDK_E	☐	BSTDK_E	DATUM	DATS	8	0	Ship-to party's PO date
126	BSARK_E	☐	BSARK_E	BSARK	CHAR	4	0	Ship-to party purchase order type	*
127	BSARK_BEZE	☐	BSARK_BEZ	TEXT20	CHAR	20	0	Description of purchase order type
128	IHREZ_E	☐	IHREZ_E	TEXT12	CHAR	12	0	Ship-to party character
129	MSR_ID	☐	MSR_PROCESS_ID	MSR_PROCESS_ID	CHAR	10	0	Process Identification Number
130	.INCLUDE	☐				0	0	Doc.Header View Inquiry, Quotation, Sales Order: Cust.Mod.
131	DUMMY	☐	DUMMY	DUMMY	CHAR	1	0	Dummy function in length 1

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	VBDKA	ALAND	T005	LAND1
2	VBDKA	BUKRS_VF	T001	BUKRS
3	VBDKA	GEWEI	T006	MSEHI
4	VBDKA	INCO1	TINC	INCO1
5	VBDKA	KALSM	T683	KALSM
6	VBDKA	KNUMA	KONA	KNUMA
7	VBDKA	KURST	TCURV	KURST
8	VBDKA	LAND1	T005	LAND1
9	VBDKA	LAND1_WE	T005	LAND1
10	VBDKA	LLAND	T005	LAND1
11	VBDKA	REGIO	T005S	BLAND
12	VBDKA	REGIO_WE	T005S	BLAND
13	VBDKA	SLAND	T005	LAND1
14	VBDKA	SPART	TVTA	SPART
15	VBDKA	SPRAS	T002	SPRAS
16	VBDKA	SPRAS_VBUR	T002	SPRAS
17	VBDKA	SPRAS_VKO	T002	SPRAS
18	VBDKA	SPRAS_WE	T002	SPRAS
19	VBDKA	VBELN	VBUK	VBELN
20	VBDKA	VBELN_VANG	VBUK	VBELN
21	VBDKA	VKBUR	TVBUR	VKBUR
22	VBDKA	VKORG	TVKO	VKORG
23	VBDKA	VOLEH	T006	MSEHI
24	VBDKA	VSBED	TVSB	VSBED
25	VBDKA	VTWEG	TVKOV	VTWEG
26	VBDKA	WAERK	TCURC	WAERS

History

Last changed by/on	SAP	20130529
SAP Release Created in