SE11 ABAP Dictionary SE11 VBKD

Popular:

VBAK VBAP MARA MAKT BKPF BSEG BVOR EKKO EKPO KNA1 LFA1 LIKP VBRK

VBKD

Sales Document: Business Data

SAP SD Transparent Table 91 Fields

Primary Key:

MANDT VBELN POSNR

#	Field Name	Key	Field Label	Type	Length	Dec	Check Table	Short Description
1	MANDT	KEY	Client	CLNT	3	-	T000	Client
2	VBELN	KEY	SD Doc.	CHAR	10	-	VBAK	Sales and Distribution Document Number
3	POSNR	KEY	Item	NUMC	6	-	-	Item number of the SD document
4	KONDA	-	Price grp	CHAR	2	-	-	Price group (customer)
5	KDGRP	-	Cust.group	CHAR	2	-	-	Customer group
6	BZIRK	-	District	CHAR	6	-	-	Sales district
7	PLTYP	-	Price list	CHAR	2	-	-	Price list type
8	INCO1	-	Incoterms	CHAR	3	-	-	Incoterms (Part 1)
9	INCO2	-	Inco. 2	CHAR	28	-	-	Incoterms (Part 2)
10	KZAZU	-	OrderComb.	CHAR	1	-	-	Order Combination Indicator
11	PERFK	-	Invoic.Dat	CHAR	2	-	-	Invoice dates (calendar identification)
12	PERRL	-	InvListSch	CHAR	2	-	-	Invoice list schedule (calendar identification)
13	MRNKZ	-	Inv.maint.	CHAR	1	-	-	Manual invoice maintenance
14	KURRF	-	ExchRt.Act	DEC	9	5	-	Exchange rate for FI postings
15	VALTG	-	AddValDays	NUMC	2	-	-	Additional value days
16	VALDT	-	FixValDate	DATS	8	-	-	Fixed value date
17	ZTERM	-	Payt Terms	CHAR	4	-	-	Terms of Payment Key
18	ZLSCH	-	Pmt Method	CHAR	1	-	-	Payment Method
19	KTGRD	-	AcctAssgGr	CHAR	2	-	-	Account assignment group for this customer
20	KURSK	-	Exch. Rate	DEC	9	5	-	Exchange Rate for Price Determination
21	PRSDT	-	Pricing dt	DATS	8	-	-	Date for pricing and exchange rate
22	FKDAT	-	Bill. Date	DATS	8	-	-	Billing date for billing index and printout
23	FBUDA	-	Serv.rend.	DATS	8	-	-	Date on which services rendered
24	GJAHR	-	Fiscal Yr	NUMC	4	-	-	Fiscal Year
25	POPER	-	Period	NUMC	3	-	-	Posting period
26	STCUR	-	ExRateStat	DEC	9	5	-	Exchange rate for statistics
27	MSCHL	-	Dunn.key	CHAR	1	-	-	Dunning key
28	MANSP	-	Dunn.block	CHAR	1	-	-	Dunning block
29	FPLNR	-	Bill.plan	CHAR	10	-	-	Billing plan number / invoicing plan number
30	WAKTION	-	Promotion	CHAR	10	-	-	Promotion
31	ABSSC	-	PayGuaProc	CHAR	6	-	-	Payment guarantee procedure
32	LCNUM	-	FD No.	CHAR	10	-	-	Financial doc. processing: Internal financial doc. number
33	J_1AFITP	-	Tax type	CHAR	2	-	-	Tax type
34	J_1ARFZ	-	Reason	CHAR	1	-	-	Reason for zero VAT
35	J_1AREGIO	-	Region	CHAR	3	-	-	Region (State, Province, County)
36	J_1AGICD	-	Activity	CHAR	2	-	-	Activity Code for Gross Income Tax
37	J_1ADTYP	-	Distribut.	CHAR	2	-	-	Distribution Type for Employment Tax
38	J_1ATXREL	-	Tax rel.	CHAR	10	-	-	Tax relevant classification
39	ABTNR	-	Department	CHAR	4	-	-	Department number
40	EMPST	-	Rec. pnt	CHAR	25	-	-	Receiving point
41	BSTKD	-	Pur. order	CHAR	35	-	-	Customer purchase order number
42	BSTDK	-	PO date	DATS	8	-	-	Customer purchase order date
43	BSARK	-	PO type	CHAR	4	-	-	Customer purchase order type
44	IHREZ	-	Ref. 1	CHAR	12	-	-	Your Reference
45	BSTKD_E	-	Pur. Order	CHAR	35	-	-	Ship-to Party's Purchase Order Number
46	BSTDK_E	-	PO date	DATS	8	-	-	Ship-to party's PO date
47	BSARK_E	-	Order type	CHAR	4	-	-	Ship-to party purchase order type
48	IHREZ_E	-	Characters	CHAR	12	-	-	Ship-to party character
49	POSEX_E	-	PO item	CHAR	6	-	-	Item Number of the Underlying Purchase Order
50	KURSK_DAT	-	TranslDate	DATS	8	-	-	Translation Date
51	KURRF_DAT	-	TranslDate	DATS	8	-	-	Translation Date
52	KDKG1	-	CondGrp 1	CHAR	2	-	-	Customer condition group 1
53	KDKG2	-	CondGrp 2	CHAR	2	-	-	Customer condition group 2
54	KDKG3	-	CondGrp 3	CHAR	2	-	-	Customer condition group 3
55	KDKG4	-	CondGrp 4	CHAR	2	-	-	Customer condition group 4
56	KDKG5	-	CondGrp 5	CHAR	2	-	-	Customer condition group 5
57	WKWAE	-	Currency	CUKY	5	-	-	Value contract currency
58	WKKUR	-	Exch. rate	DEC	9	5	-	Exchange rate in value contract currency
59	AKWAE	-	LeOCreCrcy	CUKY	5	-	-	Currency key for letter-of-credit procg in foreign trade
60	AKKUR	-	LetterRate	DEC	9	5	-	Exchange rate for letter-of-credit procg in foreign trade
61	AKPRZ	-	Deprec.	DEC	5	2	-	Depreciation percentage for financial document processing
62	J_1AINDXP	-	Inf. index	CHAR	5	-	-	Inflation Index
63	J_1AIDATEP	-	Date Index	DATS	8	-	-	Indexing base date
64	BSTKD_M	-	Pur. Order	CHAR	35	-	-	Customer PO number as matchcode field
65	DELCO	-	Del. time	CHAR	3	-	-	Agreed delivery time
66	FFPRF	-	Profile	CHAR	8	-	-	Dynamic Item Processor Profile
67	BEMOT	-	AcctIndic	CHAR	2	-	-	Accounting Indicator
68	FAKTF	-	BillForm	CHAR	2	-	-	Billing form
69	RRREL	-	Rev. recog	CHAR	1	-	-	Revenue recognition category
70	ACDATV	-	Acc. start	CHAR	1	-	-	Proposed start date for accrual period
71	VSART	-	Ship.type	CHAR	2	-	-	Shipping type
72	TRATY	-	MnsTransTy	CHAR	4	-	-	Means-of-Transport Type
73	TRMTYP	-	Mns of tr.	CHAR	18	-	-	Means of Transport
74	SDABW	-	SpecProcId	CHAR	4	-	-	Special processing indicator
75	WMINR	-	Catalog	CHAR	10	-	-	Product catalog number
76	FKBER	-	Func. Area	CHAR	16	-	-	Functional Area
77	PODKZ	-	POD-rel.	CHAR	1	-	-	Relevant for POD processing
78	CAMPAIGN	-	CGPL_GUID	RAW	16	-	-	Generic project planning: GUID from external R/3 system
79	VKONT	-	Cont. Acct	CHAR	12	-	-	Contract Account Number
80	DPBP_REF_FPLNR	-	Bill.plan	CHAR	10	-	-	Billing plan number / invoicing plan number
81	DPBP_REF_FPLTR	-	Item	NUMC	6	-	-	Item for billing plan/invoice plan/payment cards
82	REVSP	-	Rev. Dist.	CHAR	1	-	-	Revenue Distribution Type
83	REVEVTYP	-	Rev.Event	CHAR	1	-	-	Revenue Event Type (Customizing)
84	VTREF	-	Contract	CHAR	20	-	-	Reference Specifications from Contract
85	PEROP_BEG	-	Start Date	DATS	8	-	-	Period of Performance Start Date
86	PEROP_END	-	End Date	DATS	8	-	-	Period of Performance End Date
87	STCODE	-	ST Code	CHAR	3	-	-	LST CST applicability code
88	FORMC1	-	Form Type	CHAR	3	-	-	Form Type
89	FORMC2	-	Form Type	CHAR	3	-	-	Form Type
90	STEUC	-	Ctrl code	CHAR	16	-	-	Control code for consumption taxes in foreign trade
91	COMPREAS	-	Abb.	CHAR	4	-	-	Abbreviation for Complaints Reason

Related References & SQL

Diagram ERD, T-Code standar, tabel terkait, dan contoh query untuk VBKD.

Interactive ERD Diagrams

SAP SD - Sales Tables Relation → SAP SD Table Mapping & Document Flow →

Standard T-Codes

VA03 VA02

Related Tables

VBAK VBAP VBEP VBEH STXH STXL VBPA VAPMA

ANSI SQL Query

SELECT a.VBELN,
       a.POSNR,
       a.KONDA,
       a.KDGRP,
       a.BZIRK,
       a.PLTYP,
       a.INCO1
FROM VBKD AS a
WHERE a.VBELN = '0000004987'
  AND a.POSNR = '0001';

ABAP OpenSQL (7.40+)

SELECT a~vbeln,
       a~posnr,
       a~konda,
       a~kdgrp,
       a~bzirk,
       a~pltyp,
       a~inco1
  FROM vbkd AS a
  WHERE a~vbeln = '0000004987'
  and a~posnr = '0001'
  INTO TABLE @DATA(lt_vbkd)
  UP TO 100 ROWS.

SE11 ABAP Dictionary SE11 VBKD

VBKD

Dictionary Fields Fields

Related References & SQL