SE11 ABAP Dictionary SE11 VBRK

Popular:

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

VBRK

Billing Document: Header Data

SAP SD Transparent Table 99 Fields

Primary Key:

MANDT VBELN

#	Field Name	Key	Field Label	Type	Length	Dec	Check Table	Short Description
1	MANDT	KEY	Client	CLNT	3	-	T000	Client
2	VBELN	KEY	Bill.Doc.	CHAR	10	-	VBAK	Billing Document
3	FKART	-	Bill. Type	CHAR	4	-	-	Billing Type
4	FKTYP	-	BillCateg.	CHAR	1	-	-	Billing category
5	VBTYP	-	Doc.cat.	CHAR	1	-	-	SD document category
6	WAERK	-	Currency	CUKY	5	-	TCURC	SD Document Currency
7	VKORG	-	Sales org.	CHAR	4	-	-	Sales Organization
8	VTWEG	-	Distr. Chl	CHAR	2	-	-	Distribution Channel
9	KALSM	-	Pric.proc.	CHAR	6	-	-	Sales and Distribution: Pricing Procedure in Pricing
10	KNUMV	-	Doc.cond.	CHAR	10	-	-	Number of the document condition
11	VSBED	-	Shpg Cond.	CHAR	2	-	-	Shipping Conditions
12	FKDAT	-	Bill. Date	DATS	8	-	-	Billing date for billing index and printout
13	BELNR	-	DocumentNo	CHAR	10	-	-	Accounting Document Number
14	GJAHR	-	Fiscal Yr	NUMC	4	-	-	Fiscal Year
15	POPER	-	Period	NUMC	3	-	-	Posting period
16	KONDA	-	Price grp	CHAR	2	-	-	Price group (customer)
17	KDGRP	-	Cust.group	CHAR	2	-	-	Customer group
18	BZIRK	-	District	CHAR	6	-	-	Sales district
19	PLTYP	-	Price list	CHAR	2	-	-	Price list type
20	INCO1	-	Incoterms	CHAR	3	-	-	Incoterms (Part 1)
21	INCO2	-	Inco. 2	CHAR	28	-	-	Incoterms (Part 2)
22	EXPKZ	-	Export	CHAR	1	-	-	Export indicator
23	RFBSK	-	Poststatus	CHAR	1	-	-	Status for transfer to accounting
24	MRNKZ	-	Inv.maint.	CHAR	1	-	-	Manual invoice maintenance
25	KURRF	-	ExchRt.Act	DEC	9	5	-	Exchange rate for FI postings
26	CPKUR	-	Set rate	CHAR	1	-	-	ID:Exchange rate setting (no new rate determ.in bill.doc.)
27	VALTG	-	AddValDays	NUMC	2	-	-	Additional value days
28	VALDT	-	FixValDate	DATS	8	-	-	Fixed value date
29	ZTERM	-	Payt Terms	CHAR	4	-	-	Terms of Payment Key
30	ZLSCH	-	Pmt Method	CHAR	1	-	-	Payment Method
31	KTGRD	-	AcctAssgGr	CHAR	2	-	-	Account assignment group for this customer
32	LAND1	-	Dest. Ctry	CHAR	3	-	T005	Country of Destination
33	REGIO	-	Region	CHAR	3	-	-	Region (State, Province, County)
34	COUNC	-	County cde	CHAR	3	-	-	County Code
35	CITYC	-	City code	CHAR	4	-	-	City Code
36	BUKRS	-	CoCode	CHAR	4	-	T001	Company Code
37	TAXK1	-	TaxCl1Cust	CHAR	1	-	-	Tax classification 1 for customer
38	TAXK2	-	TaxCl2Cust	CHAR	1	-	-	Tax classification 2 for customer
39	TAXK3	-	TaxCl3Cust	CHAR	1	-	-	Tax classification 3 for customer
40	TAXK4	-	TaxCl4Cust	CHAR	1	-	-	Tax Classification 4 Customer
41	TAXK5	-	TaxCl5Cust	CHAR	1	-	-	Tax classification 5 for customer
42	TAXK6	-	TaxCl6Cust	CHAR	1	-	-	Tax classification 6 for customer
43	TAXK7	-	TaxCl7Cust	CHAR	1	-	-	Tax classification 7 for customer
44	TAXK8	-	TaxCl8Cust	CHAR	1	-	-	Tax classification 8 for customer
45	TAXK9	-	TaxCl9Cust	CHAR	1	-	-	Tax classification 9 for customer
46	NETWR	-	Net	CURR	15	2	-	Net Value in Document Currency
47	ZUKRI	-	Comb.crit.	CHAR	40	-	-	Combination criteria in the billing document
48	ERNAM	-	Created	CHAR	12	-	-	Name of Person who Created the Object
49	ERZET	-	Time	TIMS	6	-	-	Entry time
50	ERDAT	-	On	DATS	8	-	-	Date on Which Record Was Created
51	STAFO	-	Update grp	CHAR	6	-	-	Update group for statistics update
52	KUNRG	-	Payer	CHAR	10	-	-	Payer
53	KUNAG	-	Sold-to pt	CHAR	10	-	-	Sold-to party
54	MABER	-	Dunn.area	CHAR	2	-	-	Dunning Area
55	STWAE	-	Currency	CUKY	5	-	-	Statistics currency
56	EXNUM	-	FT no.	CHAR	10	-	-	Number of foreign trade data in MM and SD documents
57	STCEG	-	VAT Reg.No	CHAR	20	-	-	VAT Registration Number
58	AEDAT	-	Chngd	DATS	8	-	-	Changed On
59	SFAKN	-	CancBillDc	CHAR	10	-	-	Cancelled billing document number
60	KNUMA	-	Agreement	CHAR	10	-	-	Agreement (various conditions grouped together)
61	FKART_RL	-	InvListTyp	CHAR	4	-	-	Invoice list type
62	FKDAT_RL	-	Bill.date	DATS	8	-	-	Billing date for the invoice list
63	KURST	-	ExRateType	CHAR	4	-	-	Exchange Rate Type
64	MSCHL	-	Dunn.key	CHAR	1	-	-	Dunning key
65	MANSP	-	Dunn.block	CHAR	1	-	-	Dunning block
66	SPART	-	Division	CHAR	2	-	-	Division
67	KKBER	-	CreditArea	CHAR	4	-	-	Credit control area
68	KNKLI	-	Cred. acct	CHAR	10	-	-	Customer's account number with credit limit reference
69	CMWAE	-	Currency	CUKY	5	-	-	Currency key of credit control area
70	CMKUF	-	Exch.rate	DEC	9	5	-	Credit data exchange rate at billing document rate
71	HITYP_PR	-	HierTypPri	CHAR	1	-	-	Hierarchy type for pricing
72	BSTNK_VF	-	Pur. order	CHAR	35	-	-	Customer purchase order number
73	VBUND	-	Tradg Part	CHAR	6	-	-	Company ID of trading partner
74	FKART_AB	-	AccBillTyp	CHAR	4	-	-	Accrual billing type
75	KAPPL	-	Applicat.	CHAR	2	-	-	Application
76	LANDTX	-	TaxDepCty	CHAR	3	-	-	Tax departure country
77	STCEG_H	-	OrgSlsTxNo	CHAR	1	-	-	Origin of sales tax ID number
78	STCEG_L	-	CtrySlsTxN	CHAR	3	-	-	Country of Sales Tax ID Number
79	XBLNR	-	Reference	CHAR	16	-	-	Reference Document Number
80	ZUONR	-	Assignment	CHAR	18	-	-	Assignment number
81	MWSBK	-	Tax	CURR	13	2	-	Tax amount in document currency
82	LOGSYS	-	LogSystem	CHAR	10	-	-	Logical system
83	FKSTO	-	Cancelled	CHAR	1	-	-	Billing document is cancelled
84	XEGDR	-	Tri.deal	CHAR	1	-	-	Indicator: Triangular deal within the EU ?
85	RPLNR	-	Paym.plan	CHAR	10	-	-	Number of payment card plan type
86	LCNUM	-	FD No.	CHAR	10	-	-	Financial doc. processing: Internal financial doc. number
87	J_1AFITP	-	Tax type	CHAR	2	-	-	Tax type
88	KURRF_DAT	-	TranslDate	DATS	8	-	-	Translation Date
89	AKWAE	-	LeOCreCrcy	CUKY	5	-	-	Currency key for letter-of-credit procg in foreign trade
90	AKKUR	-	LetterRate	DEC	9	5	-	Exchange rate for letter-of-credit procg in foreign trade
91	KIDNO	-	Paymt ref.	CHAR	30	-	-	Payment Reference
92	BVTYP	-	Part. Bank	CHAR	4	-	-	Partner Bank Type
93	NUMPG	-	Pages	NUMC	3	-	-	Number of pages of invoice
94	BUPLA	-	Bus. Pl.	CHAR	4	-	-	Business Place
95	VKONT	-	Cont. Acct	CHAR	12	-	-	Contract Account Number
96	FKK_DOCSTAT	-	Add.FIStat	CHAR	1	-	-	Additional Status Transfer to Fin. Accounting (Res. RFBSK)
97	NRZAS	-	Character Field of Length 12	CHAR	12	-	-	Character Field of Length 12
98	SPE_BILLING_IND	-	BillingInd	CHAR	1	-	-	EWM Billing Indicator
99	VTREF	-	Contract	CHAR	20	-	-	Reference Specifications from Contract

Related References & SQL

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

Interactive ERD Diagrams

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

Standard T-Codes

VF03 VF01 VF02 VF05 VFX3

Related Tables

VBAK TCURC T005 T001 VBRP VRKPA VRPMA VKDFS

ANSI SQL Query

SELECT a.VBELN,
       a.FKART,
       a.FKTYP,
       a.VBTYP,
       a.WAERK,
       a.VKORG
FROM VBRK AS a
WHERE a.VBELN = '0000004987';

ABAP OpenSQL (7.40+)

SELECT a~vbeln,
       a~fkart,
       a~fktyp,
       a~vbtyp,
       a~waerk,
       a~vkorg
  FROM vbrk AS a
  WHERE a~vbeln = '0000004987'
  INTO TABLE @DATA(lt_vbrk)
  UP TO 100 ROWS.

SE11 ABAP Dictionary SE11 VBRK

VBRK

Dictionary Fields Fields

Related References & SQL