SE11 ABAP Dictionary SE11 VBAK

Popular:

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

VBAK

Sales Document: Header Data

SAP SD Transparent Table 127 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	Sales Doc.	CHAR	10	-	VBAK	Sales Document
3	ERDAT	-	On	DATS	8	-	-	Date on Which Record Was Created
4	ERZET	-	Time	TIMS	6	-	-	Entry time
5	ERNAM	-	Created	CHAR	12	-	-	Name of Person who Created the Object
6	ANGDT	-	Valid from	DATS	8	-	-	Quotation/Inquiry is valid from
7	BNDDT	-	Valid to	DATS	8	-	-	Date until which bid/quotation is binding (valid-to date)
8	AUDAT	-	Doc. Date	DATS	8	-	-	Document Date (Date Received/Sent)
9	VBTYP	-	Doc.cat.	CHAR	1	-	-	SD document category
10	TRVOG	-	Trans.Grp	CHAR	1	-	-	Transaction group
11	AUART	-	SalesDocTy	CHAR	4	-	-	Sales Document Type
12	AUGRU	-	Ord.reason	CHAR	3	-	-	Order reason (reason for the business transaction)
13	GWLDT	-	Beg.guaran	DATS	8	-	-	Guarantee date
14	SUBMI	-	Coll. no.	CHAR	10	-	-	Collective number (SD)
15	LIFSK	-	DelivBlock	CHAR	2	-	-	Delivery block (document header)
16	FAKSK	-	Bill.block	CHAR	2	-	-	Billing block in SD document
17	NETWR	-	Net value	CURR	15	2	-	Net Value of the Sales Order in Document Currency
18	WAERK	-	Currency	CUKY	5	-	TCURC	SD Document Currency
19	VKORG	-	Sales org.	CHAR	4	-	-	Sales Organization
20	VTWEG	-	Distr. Chl	CHAR	2	-	-	Distribution Channel
21	SPART	-	Division	CHAR	2	-	-	Division
22	VKGRP	-	Sales Grp	CHAR	3	-	-	Sales Group
23	VKBUR	-	Sales Off.	CHAR	4	-	-	Sales Office
24	GSBER	-	Bus. Area	CHAR	4	-	-	Business Area
25	GSKST	-	Bus.area	CHAR	4	-	-	Business area from cost center
26	GUEBG	-	Valid from	DATS	8	-	-	Valid-from date (outline agreements, product proposals)
27	GUEEN	-	Valid to	DATS	8	-	-	Valid-to date (outline agreements, product proposals)
28	KNUMV	-	Doc.cond.	CHAR	10	-	-	Number of the document condition
29	VDATU	-	Req.dlv.dt	DATS	8	-	-	Requested delivery date
30	VPRGR	-	Next date	CHAR	1	-	-	Proposed date type
31	AUTLF	-	Compl.dlv.	CHAR	1	-	-	Complete delivery defined for each sales order?
32	VBKLA	-	Origin	CHAR	9	-	-	Original system with release and transaction control
33	VBKLT	-	Indicator	CHAR	1	-	-	SD document indicator
34	KALSM	-	Pric.proc.	CHAR	6	-	-	Sales and Distribution: Pricing Procedure in Pricing
35	VSBED	-	Shpg Cond.	CHAR	2	-	-	Shipping Conditions
36	FKARA	-	OrdBillTyp	CHAR	4	-	-	Proposed billing type for an order-related billing document
37	AWAHR	-	Probab.	NUMC	3	-	-	Sales probability
38	KTEXT	-	Descriptn	CHAR	40	-	-	Search term for product proposal
39	BSTNK	-	Pur. Order	CHAR	20	-	-	Customer purchase order number
40	BSARK	-	PO type	CHAR	4	-	-	Customer purchase order type
41	BSTDK	-	PO date	DATS	8	-	-	Customer purchase order date
42	BSTZD	-	Supplement	CHAR	4	-	-	Purchase order number supplement
43	IHREZ	-	Ref. 1	CHAR	12	-	-	Your Reference
44	BNAME	-	Name	CHAR	35	-	-	Name of orderer
45	TELF1	-	Telephone	CHAR	16	-	-	Telephone Number
46	MAHZA	-	No.of cont	DEC	3	-	-	Number of contacts from the customer
47	MAHDT	-	Last cont.	DATS	8	-	-	Last customer contact date
48	KUNNR	-	Sold-to pt	CHAR	10	-	KNA1	Sold-to party
49	KOSTL	-	Cost Ctr	CHAR	10	-	-	Cost Center
50	STAFO	-	Update grp	CHAR	6	-	-	Update group for statistics update
51	STWAE	-	Currency	CUKY	5	-	-	Statistics currency
52	AEDAT	-	Chngd	DATS	8	-	-	Changed On
53	KVGR1	-	Cust.grp 1	CHAR	3	-	-	Customer group 1
54	KVGR2	-	Cust.grp.2	CHAR	3	-	-	Customer group 2
55	KVGR3	-	Cust.grp.3	CHAR	3	-	-	Customer group 3
56	KVGR4	-	Cust.grp.4	CHAR	3	-	-	Customer group 4
57	KVGR5	-	Cust.grp.5	CHAR	3	-	-	Customer group 5
58	KNUMA	-	Agreement	CHAR	10	-	-	Agreement (various conditions grouped together)
59	KOKRS	-	CO Area	CHAR	4	-	-	Controlling Area
60	PS_PSP_PNR	-	WBS Elem.	NUMC	8	-	-	Work Breakdown Structure Element (WBS Element)
61	KURST	-	ExRateType	CHAR	4	-	-	Exchange Rate Type
62	KKBER	-	CreditArea	CHAR	4	-	-	Credit control area
63	KNKLI	-	Cred. acct	CHAR	10	-	-	Customer's account number with credit limit reference
64	GRUPP	-	Cred.grp	CHAR	4	-	-	Customer Credit Group
65	SBGRP	-	Cred.rep.	CHAR	3	-	-	Credit representative group for credit management
66	CTLPC	-	Risk cat.	CHAR	3	-	-	Credit management: Risk category
67	CMWAE	-	Currency	CUKY	5	-	-	Currency key of credit control area
68	CMFRE	-	Release	DATS	8	-	-	Release date of the document determined by credit management
69	CMNUP	-	Next check	DATS	8	-	-	Date of next credit check of document
70	CMNGV	-	Next date	DATS	8	-	-	Next date
71	AMTBL	-	Cred.value	CURR	15	2	-	Released credit value of the document
72	HITYP_PR	-	HierTypPri	CHAR	1	-	-	Hierarchy type for pricing
73	ABRVW	-	Usage	CHAR	3	-	-	Usage Indicator
74	ABDIS	-	MRP	CHAR	1	-	-	MRP for delivery schedule types
75	VGBEL	-	Ref.doc.	CHAR	10	-	-	Document number of the reference document
76	OBJNR	-	ObjNo hdr	CHAR	22	-	-	Object number at header level
77	BUKRS_VF	-	CCodeBill	CHAR	4	-	-	Company code to be billed
78	TAXK1	-	AltTaxClss	CHAR	1	-	-	Alternative tax classification
79	TAXK2	-	TaxCl2Cust	CHAR	1	-	-	Tax classification 2 for customer
80	TAXK3	-	TaxCl3Cust	CHAR	1	-	-	Tax classification 3 for customer
81	TAXK4	-	TaxCl4Cust	CHAR	1	-	-	Tax Classification 4 Customer
82	TAXK5	-	TaxCl5Cust	CHAR	1	-	-	Tax classification 5 for customer
83	TAXK6	-	TaxCl6Cust	CHAR	1	-	-	Tax classification 6 for customer
84	TAXK7	-	TaxCl7Cust	CHAR	1	-	-	Tax classification 7 for customer
85	TAXK8	-	TaxCl8Cust	CHAR	1	-	-	Tax classification 8 for customer
86	TAXK9	-	TaxCl9Cust	CHAR	1	-	-	Tax classification 9 for customer
87	XBLNR	-	Reference	CHAR	16	-	-	Reference Document Number
88	ZUONR	-	Assignment	CHAR	18	-	-	Assignment number
89	VGTYP	-	Doc.cat.	CHAR	1	-	-	Document category of preceding SD document
90	KALSM_CH	-	SearchProc	CHAR	6	-	-	Search procedure for batch determination
91	AGRZR	-	AccrPeriod	NUMC	2	-	-	Accrual period for order-related billing docs.to be accrued
92	AUFNR	-	Order	CHAR	12	-	-	Order Number
93	QMNUM	-	Notifctn	CHAR	12	-	-	Notification No
94	VBELN_GRP	-	MastContr.	CHAR	10	-	-	Mster contract number
95	SCHEME_GRP	-	Ref.proc.	CHAR	4	-	-	Referencing requirement: Procedure
96	ABRUF_PART	-	CheckPart.	CHAR	1	-	-	Check partner authorizations
97	ABHOD	-	Pick up dt	DATS	8	-	-	Pick up date
98	ABHOV	-	Pick up tm	TIMS	6	-	-	Pick up time
99	ABHOB	-	Pick up tm	TIMS	6	-	-	Pick up time
100	RPLNR	-	Paym.plan	CHAR	10	-	-	Number of payment card plan type
101	VZEIT	-	ReqDelTime	TIMS	6	-	-	Proposed schedule line time (local with ref. to sales org.)
102	STCEG_L	-	TaxDestCty	CHAR	3	-	-	Tax destination country
103	LANDTX	-	TaxDepCty	CHAR	3	-	-	Tax departure country
104	XEGDR	-	Tri.deal	CHAR	1	-	-	Indicator: Triangular deal within the EU ?
105	ENQUEUE_GRP	-	Block master contr. until all lower level contracts updated	CHAR	1	-	-	Block master contr. until all lower level contracts updated
106	DAT_FZAU	-	CmlQtyDate	DATS	8	-	-	Cml delivery order qty date
107	FMBDAT	-	Mat.Av.Dt.	DATS	8	-	-	Material Staging/Availability Date
108	VSNMR_V	-	Version	CHAR	12	-	-	Sales document version number
109	HANDLE	-	Int.ID	CHAR	22	-	-	International unique key for VBAK-VBELN
110	PROLI	-	DGMgmtProf	CHAR	3	-	-	Dangerous Goods Management Profile in SD Documents
111	CONT_DG	-	ContainsDG	CHAR	1	-	-	Indicator: Document contains dangerous goods
112	CRM_GUID	-	Char 70	CHAR	70	-	-	Character field, length 70
113	UPD_TMSTMP	-	Time Stamp	DEC	21	7	-	UTC Time Stamp in Long Form (YYYYMMDDhhmmssmmmuuun)
114	MSR_ID	-	Process ID	CHAR	10	-	-	Process Identification Number
115	SWENR	-	Bus.ent.	CHAR	8	-	-	Business Entity Number
116	SMENR	-	Unit	CHAR	8	-	-	Number of Sales Unit
117	PHASE	-	Sls.Phs.	CHAR	11	-	-	Sales Phase
118	MTLAUR	-	Trg. Incm.	CHAR	1	-	-	Marker for Low Income Housing
119	STAGE	-	Stage	INT4	10	-	-	Construction Stage
120	HB_CONT_REASON	-	Contingent	CHAR	2	-	-	Contingency data
121	HB_EXPDATE	-	Exp date	DATS	8	-	-	Expiration date
122	HB_RESDATE	-	Res date	DATS	8	-	-	Resolution date
123	MILL_APPL_ID	-	APPL_ID	CHAR	2	-	-	Application ID Category for Configuration
124	LOGSYSB	-	LogSystem	CHAR	10	-	-	Logical system with which document was created
125	KALCD	-	Procedure	CHAR	6	-	-	Procedure for Campaign Determination
126	MULTI	-	Mult. Pr.	CHAR	1	-	-	Multiple Campaigns/Trade Promotions Active Indicator
127	WTYSC_CLM_HDR	-	Clm Header	CHAR	16	-	-	Claim header

Foreign Keys & Joins

VBAP → 1 : N

              VBAK-VBELN = VBAP-VBELN            

KNA1 → N : 1

              VBAK-KUNNR = KNA1-KUNNR            

LIKP → 1 : N

              Via Document Flow (VBFA)            

Related References & SQL

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

Interactive ERD Diagrams

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

Standard T-Codes

VA03 VA01 VA02 VA05

Related Tables

VBAP KNA1 LIKP TCURC VBEP VBEH VBKD STXH

ANSI SQL Query

SELECT a.VBELN,
       a.ERDAT,
       a.ERZET,
       a.ERNAM,
       a.ANGDT,
       a.BNDDT
FROM VBAK AS a
LEFT JOIN VBAP AS b
  ON b.MANDT = a.MANDT
 AND b.VBELN = a.VBELN
WHERE a.VBELN = '0000004987';

ABAP OpenSQL (7.40+)

SELECT a~vbeln,
       a~erdat,
       a~erzet,
       a~ernam,
       a~angdt,
       a~bnddt
  FROM vbak AS a
  LEFT OUTER JOIN vbap AS b
    ON b~VBELN = a~VBELN
  WHERE a~vbeln = '0000004987'
  INTO TABLE @DATA(lt_vbak)
  UP TO 100 ROWS.

SE11 ABAP Dictionary SE11 VBAK

VBAK

Dictionary Fields Fields

Foreign Keys & Joins

Related References & SQL