SAP ABAP View V_OLR3_VBAX (Sales Order, VBAK + VBUK: Consistency Check)

Hierarchy

☛ SAP_APPL (Software Component) Logistics and Accounting
   ⤷ PS-ST (Application Component) Structures
     ⤷ R3_OBJECTLINK_R3 (Package) Object Link cProjects and R/3

Basic Data

View Type	D	Database View
Database View	V_OLR3_VBAX
Short Description	Sales Order, VBAK + VBUK: Consistency Check
Root table	VBAK	Sales Document: Header Data

Table

#	Table Name	Foreign Table	Foreign Field	Foreign DIR
1	VBAK	VBAK
2	VBUK

Join Conditions

#	Table Name	Field Name	Negation	Operator	Constants	Cont. line	AND/OR	Offset	F Length	Mco Field
1	VBAK	MANDT	JL	EQ				0	0
2	VBUK	MANDT	JR	EQ			AND	0	0
3	VBAK	VBELN	JL	EQ				0	0
4	VBUK	VBELN	JR	EQ			AND	0	0
5	VBAK	VBTYP		EQ	'C'		AND	0	0
6	VBUK	ABSTK		NE	'C'			0	0

View Fields

#	View field	Table	Field	Maintenance Flag	Key	Data element	Mod	Short Description
1	MANDT	VBAK	MANDT		☐	MANDT	☐	Client
2	VBELN	VBAK	VBELN		☐	VBELN_VA	☐	Sales Document
3	ERDAT	VBAK	ERDAT		☐	ERDAT	☐	Date on which the record was created
4	ERZET	VBAK	ERZET		☐	ERZET	☐	Entry time
5	ERNAM	VBAK	ERNAM		☐	ERNAM	☐	Name of Person who Created the Object
6	ANGDT	VBAK	ANGDT		☐	ANGDT_V	☐	Quotation/Inquiry is valid from
7	BNDDT	VBAK	BNDDT		☐	BNDDT	☐	Date until which bid/quotation is binding (valid-to date)
8	AUDAT	VBAK	AUDAT		☐	AUDAT	☐	Document Date (Date Received/Sent)
9	VBTYP	VBAK	VBTYP		☐	VBTYP	☐	SD document category
10	TRVOG	VBAK	TRVOG		☐	TRVOG	☐	Transaction group
11	AUART	VBAK	AUART		☐	AUART	☐	Sales Document Type
12	AUGRU	VBAK	AUGRU		☐	AUGRU	☐	Order reason (reason for the business transaction)
13	GWLDT	VBAK	GWLDT		☐	GWLDT	☐	Guarantee date
14	SUBMI	VBAK	SUBMI		☐	SUBMI_SD	☐	Collective number (SD)
15	LIFSK	VBAK	LIFSK		☐	LIFSK	☐	Delivery block (document header)
16	FAKSK	VBAK	FAKSK		☐	FAKSK	☐	Billing block in SD document
17	NETWR	VBAK	NETWR		☐	NETWR_AK	☐	Net Value of the Sales Order in Document Currency
18	WAERK	VBAK	WAERK		☐	WAERK	☐	SD document currency
19	VKORG	VBAK	VKORG		☐	VKORG	☐	Sales Organization
20	VTWEG	VBAK	VTWEG		☐	VTWEG	☐	Distribution Channel
21	SPART	VBAK	SPART		☐	SPART	☐	Division
22	VKGRP	VBAK	VKGRP		☐	VKGRP	☐	Sales group
23	VKBUR	VBAK	VKBUR		☐	VKBUR	☐	Sales office
24	GSBER	VBAK	GSBER		☐	GSBER	☐	Business Area
25	GSKST	VBAK	GSKST		☐	GSKST	☐	Business area from cost center
26	GUEBG	VBAK	GUEBG		☐	GUEBG	☐	Valid-from date (outline agreements, product proposals)
27	GUEEN	VBAK	GUEEN		☐	GUEEN	☐	Valid-to date (outline agreements, product proposals)
28	KNUMV	VBAK	KNUMV		☐	KNUMV	☐	Number of the document condition
29	VDATU	VBAK	VDATU		☐	EDATU_VBAK	☐	Requested delivery date
30	VPRGR	VBAK	VPRGR		☐	PRGRS_VBAK	☐	Proposed Period for Date
31	AUTLF	VBAK	AUTLF		☐	AUTLF	☐	Complete delivery defined for each sales order?
32	VBKLA	VBAK	VBKLA		☐	VBKLA	☐	unused (sales doocument class)
33	VBKLT	VBAK	VBKLT		☐	VBKLT	☐	SD document indicator
34	KALSM	VBAK	KALSM		☐	KALSMASD	☐	Sales and Distribution: Pricing Procedure in Pricing
35	VSBED	VBAK	VSBED		☐	VSBED	☐	Shipping conditions
36	FKARA	VBAK	FKARA		☐	FKARA	☐	Proposed billing type for an order-related billing document
37	AWAHR	VBAK	AWAHR		☐	AWAHR_AK	☐	Sales Probability
38	KTEXT	VBAK	KTEXT		☐	KTEXT_V	☐	Search term for product proposal
39	BSTNK	VBAK	BSTNK		☐	BSTNK	☐	Customer purchase order number
40	BSARK	VBAK	BSARK		☐	BSARK	☐	Customer Order Type
41	BSTDK	VBAK	BSTDK		☐	BSTDK	☐	Customer purchase order date
42	BSTZD	VBAK	BSTZD		☐	BSTZD	☐	Customer purchase order number supplement
43	IHREZ	VBAK	IHREZ		☐	IHREZ	☐	Your Reference
44	BNAME	VBAK	BNAME		☐	BNAME_V	☐	Name of orderer
45	TELF1	VBAK	TELF1		☐	TELF1_VP	☐	Telephone Number
46	MAHZA	VBAK	MAHZA		☐	MAHZA	☐	Number of reminder notices, reminders for delivery purchase
47	MAHDT	VBAK	MAHDT		☐	MAHDT	☐	Last Delivery Reminder Notice
48	KUNNR	VBAK	KUNNR		☐	KUNAG	☐	Sold-to party
49	KOSTL	VBAK	KOSTL		☐	KOSTL	☐	Cost Center
50	STAFO	VBAK	STAFO		☐	STAFO	☐	Update group for statistics update
51	STWAE	VBAK	STWAE		☐	STWAE	☐	Statistics currency
52	AEDAT	VBAK	AEDAT		☐	AEDAT	☐	Last Changed On
53	KVGR1	VBAK	KVGR1		☐	KVGR1	☐	Customer group 1
54	KVGR2	VBAK	KVGR2		☐	KVGR2	☐	Customer group 2
55	KVGR3	VBAK	KVGR3		☐	KVGR3	☐	Customer group 3
56	KVGR4	VBAK	KVGR4		☐	KVGR4	☐	Customer group 4
57	KVGR5	VBAK	KVGR5		☐	KVGR5	☐	Customer group 5
58	KNUMA	VBAK	KNUMA		☐	KNUMA	☐	Agreement (various conditions grouped together)
59	KOKRS	VBAK	KOKRS		☐	KOKRS	☐	Controlling Area
60	PS_PSP_PNR	VBAK	PS_PSP_PNR		☐	PS_PSP_PNR	☐	Work Breakdown Structure Element (WBS Element)
61	KURST	VBAK	KURST		☐	KURST	☐	Exchange Rate Type
62	KKBER	VBAK	KKBER		☐	KKBER	☐	Credit control area
63	KNKLI	VBAK	KNKLI		☐	KNKLI	☐	Customer's account number with credit limit reference
64	GRUPP	VBAK	GRUPP		☐	GRUPP_CM	☐	Customer credit group
65	SBGRP	VBAK	SBGRP		☐	SBGRP_CM	☐	Credit Representative Group for Credit Management
66	CTLPC	VBAK	CTLPC		☐	CTLPC_CM	☐	Credit management: Risk category
67	CMWAE	VBAK	CMWAE		☐	WAERS_CM	☐	Currency key of credit control area
68	CMFRE	VBAK	CMFRE		☐	CMFRE	☐	Release date of the document determined by credit management
69	CMNUP	VBAK	CMNUP		☐	CMNUP	☐	Date of next credit check of document
70	CMNGV	VBAK	CMNGV		☐	CMNGV	☐	Next date
71	AMTBL	VBAK	AMTBL		☐	AMTBL_CM	☐	Released credit value of the document
72	HITYP_PR	VBAK	HITYP_PR		☐	HITYP_PR	☐	Hierarchy type for pricing
73	ABRVW	VBAK	ABRVW		☐	ABRVW	☐	Usage Indicator
74	ABDIS	VBAK	ABDIS		☐	ABDIS	☐	MRP for Release Types
75	VGBEL	VBAK	VGBEL		☐	VGBEL	☐	Document number of the reference document
76	OBJNR	VBAK	OBJNR		☐	OBJKO	☐	Object number at header level
77	BUKRS_VF	VBAK	BUKRS_VF		☐	BUKRS_VF	☐	Company code to be billed
78	TAXK1	VBAK	TAXK1		☐	TAXK1_AK	☐	Alternative tax classification
79	TAXK2	VBAK	TAXK2		☐	TAXK2	☐	Tax classification 2 for customer
80	TAXK3	VBAK	TAXK3		☐	TAXK3	☐	Tax classification 3 for customer
81	TAXK4	VBAK	TAXK4		☐	TAXK4	☐	Tax classification 4 for customer
82	TAXK5	VBAK	TAXK5		☐	TAXK5	☐	Tax classification 5 for customer
83	TAXK6	VBAK	TAXK6		☐	TAXK6	☐	Tax classification 6 for customer
84	TAXK7	VBAK	TAXK7		☐	TAXK7	☐	Tax classification 7 for customer
85	TAXK8	VBAK	TAXK8		☐	TAXK8	☐	Tax classification 8 for customer
86	TAXK9	VBAK	TAXK9		☐	TAXK9	☐	Tax classification 9 for customer
87	XBLNR	VBAK	XBLNR		☐	XBLNR_V1	☐	Reference Document Number
88	ZUONR	VBAK	ZUONR		☐	ORDNR_V	☐	Assignment Number
89	VGTYP	VBAK	VGTYP		☐	VBTYP_V	☐	Document category of preceding SD document
90	KALSM_CH	VBAK	KALSM_CH		☐	KALSMA_CH	☐	Search procedure for batch determination
91	AGRZR	VBAK	AGRZR		☐	AGRZR	☐	Accrual period for order-related billing docs.to be accrued
92	AUFNR	VBAK	AUFNR		☐	AUFNR	☐	Order Number
93	QMNUM	VBAK	QMNUM		☐	QMNUM	☐	Message Number
94	VBELN_GRP	VBAK	VBELN_GRP		☐	VBELN_GRP	☐	Group Master Contract
95	SCHEME_GRP	VBAK	SCHEME_GRP		☐	SCHEME_GRP	☐	Referencing requirement: Procedure
96	ABRUF_PART	VBAK	ABRUF_PART		☐	ABRUF_PART	☐	Check partner authorizations
97	ABHOD	VBAK	ABHOD		☐	ABHOD	☐	Pick up date
98	ABHOV	VBAK	ABHOV		☐	ABHOZ	☐	Pick up time
99	ABHOB	VBAK	ABHOB		☐	ABHOZ	☐	Pick up time
100	RPLNR	VBAK	RPLNR		☐	RPLNR	☐	Installment Plan Number
101	VZEIT	VBAK	VZEIT		☐	EZEIT_VBAK	☐	Proposed schedule line time (local with ref. to sales org.)
102	STCEG_L	VBAK	STCEG_L		☐	LAND1TX	☐	Tax Destination Country
103	LANDTX	VBAK	LANDTX		☐	LANDTX	☐	Tax Departure Country
104	XEGDR	VBAK	XEGDR		☐	XEGDR	☐	Indicator: Triangular deal within the EU ?
105	ENQUEUE_GRP	VBAK	ENQUEUE_GRP		☐	ENQUEUE_GRP	☐	Block master contr. until all lower level contracts updated
106	DAT_FZAU	VBAK	DAT_FZAU		☐	DAT_FZAU	☐	Cml delivery order qty date
107	FMBDAT	VBAK	FMBDAT		☐	MBDAT	☐	Material Staging/Availability Date
108	VSNMR_V	VBAK	VSNMR_V		☐	VSNMR_V	☐	Sales document version number
109	HANDLE	VBAK	HANDLE		☐	TSEGGUID_VBAK	☐	International unique key for VBAK-VBELN
110	PROLI	VBAK	PROLI		☐	ADGE_PROLI	☐	Dangerous Goods Management Profile in SD Documents
111	CONT_DG	VBAK	CONT_DG		☐	ADGE_NCDG	☐	Indicator: Document contains dangerous goods
112	LOGSYSB	VBAK	LOGSYSB		☐	LOGSYSB	☐	Logical system with which document was created
113	KALCD	VBAK	KALCD		☐	KALCD	☐	Procedure for Campaign Determination
114	RFSTK	VBUK	RFSTK		☐	RFSTK	☐	Reference document header status
115	RFGSK	VBUK	RFGSK		☐	RFGSK	☐	Total reference status of all items
116	BESTK	VBUK	BESTK		☐	BESTK	☐	Confirmation status
117	LFSTK	VBUK	LFSTK		☐	LFSTK	☐	Delivery status
118	LFGSK	VBUK	LFGSK		☐	LKGSK	☐	Overall delivery status for all items
119	WBSTK	VBUK	WBSTK		☐	WBSTK	☐	Total goods movement status
120	FKSTK	VBUK	FKSTK		☐	FKSTK	☐	Billing status
121	FKSAK	VBUK	FKSAK		☐	FKSAK	☐	Billing status (order-related billing document)
122	BUCHK	VBUK	BUCHK		☐	BUCHK	☐	Posting Status of Billing Document
123	ABSTK	VBUK	ABSTK		☐	ABSTK	☐	Overall rejection status of all sales document items
124	GBSTK	VBUK	GBSTK		☐	GBSTK	☐	Overall processing status of document
125	KOSTK	VBUK	KOSTK		☐	KOSTK	☐	Overall picking / putaway status
126	LVSTK	VBUK	LVSTK		☐	LVSTK	☐	Overall status of warehouse management activities
127	UVALS	VBUK	UVALS		☐	UVALL_SU	☐	Total incompletion status of all items in general
128	UVVLS	VBUK	UVVLS		☐	UVVLS_SU	☐	Total incompletion status of all items: Delivery
129	UVFAS	VBUK	UVFAS		☐	UVFAK_SU	☐	Total incompletion status of all items: Billing
130	UVALL	VBUK	UVALL		☐	UVALL_UK	☐	General incompletion status of the header
131	UVVLK	VBUK	UVVLK		☐	UVVLK_UK	☐	Header incompletion status concerning delivery
132	UVFAK	VBUK	UVFAK		☐	UVFAK_UK	☐	Header incompletion status with respect to billing
133	UVPRS	VBUK	UVPRS		☐	UVPRS_UK	☐	Document is incomplete with respect to pricing
134	VBOBJ	VBUK	VBOBJ		☐	VBOBJ	☐	SD document object
135	FKIVK	VBUK	FKIVK		☐	FKIVK	☐	Billing totals status for intercompany billing
136	RELIK	VBUK	RELIK		☐	RELIK	☐	Invoice list status of billing document
137	UVK01	VBUK	UVK01		☐	UVK01	☐	Customer reserves 1: Header status
138	UVK02	VBUK	UVK02		☐	UVK02	☐	Customer reserves 2: Header status
139	UVK03	VBUK	UVK03		☐	UVK03	☐	Customer reserves 3: Header status
140	UVK04	VBUK	UVK04		☐	UVK04	☐	Custmer reserves 4: Header status
141	UVK05	VBUK	UVK05		☐	UVK05	☐	Customer reserves 5: Header status
142	UVS01	VBUK	UVS01		☐	UVS01	☐	Customer reserves 1: Sum of all items
143	UVS02	VBUK	UVS02		☐	UVS02	☐	Customer reserves 2: Sum of all items
144	UVS03	VBUK	UVS03		☐	UVS03	☐	Customer reserves 3: Sum of all items
145	UVS04	VBUK	UVS04		☐	UVS04	☐	Customer reserves 4: Sum of all items
146	UVS05	VBUK	UVS05		☐	UVS05	☐	Customer reserves 5: Sum of all items
147	PKSTK	VBUK	PKSTK		☐	PKSTK	☐	Overall packing status of all items
148	CMPSA	VBUK	CMPSA		☐	CMPSA	☐	Status of static credit limit check
149	CMPSB	VBUK	CMPSB		☐	CMPSB	☐	Status of dynamic credit limit check in the credit horizon
150	CMPSC	VBUK	CMPSC		☐	CMPSC	☐	Status of credit check against maximum document value
151	CMPSD	VBUK	CMPSD		☐	CMPSD	☐	Status of credit check against terms of payment
152	CMPSE	VBUK	CMPSE		☐	CMPSE	☐	Status of credit check against customer review date
153	CMPSF	VBUK	CMPSF		☐	CMPSF	☐	Status of credit check against open items due
154	CMPSG	VBUK	CMPSG		☐	CMPSG	☐	Status of credit check against oldest open items
155	CMPSH	VBUK	CMPSH		☐	CMPSH	☐	Status of credit check against highest dunning level
156	CMPSI	VBUK	CMPSI		☐	CMPSI	☐	Status of credit check against financial document
157	CMPSJ	VBUK	CMPSJ		☐	CMPSJ	☐	Status of credit check against export credit insurance
158	CMPSK	VBUK	CMPSK		☐	CMPSK	☐	Status of credit check against payment card authorization
159	CMPSL	VBUK	CMPSL		☐	CMPSL	☐	Status of credit check of reserves 4
160	CMPS0	VBUK	CMPS0		☐	CMPS0	☐	Status of credit check for customer reserve 1
161	CMPS1	VBUK	CMPS1		☐	CMPS1	☐	Status of credit check for customer reserve 2
162	CMPS2	VBUK	CMPS2		☐	CMPS2	☐	Status of credit check for customer reserve 3
163	CMGST	VBUK	CMGST		☐	CMGST	☐	Overall status of credit checks
164	TRSTA	VBUK	TRSTA		☐	TRSTA	☐	Transportation planning status
165	KOQUK	VBUK	KOQUK		☐	KOQUK	☐	Status of pick confirmation
166	COSTA	VBUK	COSTA		☐	COSTA_D	☐	Confirmation status for ALE
167	SAPRL	VBUK	SAPRL		☐	SAPRL	☐	SAP Release
168	UVPAS	VBUK	UVPAS		☐	UVPAK_SU	☐	Totals incomplete status for all items: packaging
169	UVPIS	VBUK	UVPIS		☐	UVPIK_SU	☐	Totals incomplete status for all items: Picking
170	UVWAS	VBUK	UVWAS		☐	UVWAK_SU	☐	Total incomplete status of all items: post goods movement
171	UVPAK	VBUK	UVPAK		☐	UVPAK_UK	☐	Header incomplete status for packaging
172	UVPIK	VBUK	UVPIK		☐	UVPIK_UK	☐	Header incomplete status for picking/putaway
173	UVWAK	VBUK	UVWAK		☐	UVWAK_UK	☐	Post header incomplete status for goods movement
174	UVGEK	VBUK	UVGEK		☐	UVGEK_UK	☐	UNUSED
175	CMPSM	VBUK	CMPSM		☐	CMPSM	☐	Credit check data is obsolete
176	DCSTK	VBUK	DCSTK		☐	DCSTK	☐	Delay status
177	VESTK	VBUK	VESTK		☐	VESTK	☐	Handling Unit Placed in Stock
178	VLSTK	VBUK	VLSTK		☐	VLSTK	☐	Distribution Status (Decentralized Warehouse Processing)
179	RRSTA	VBUK	RRSTA		☐	RR_STATUS	☐	Revenue determination status
180	BLOCK	VBUK	BLOCK		☐	BLOCK_VB	☐	Indicator: Document preselected for archiving
181	FSSTK	VBUK	FSSTK		☐	FSSTK	☐	Overall billing block status
182	LSSTK	VBUK	LSSTK		☐	LSSTK_G	☐	Overall delivery block status
183	SPSTG	VBUK	SPSTG		☐	SPSTG	☐	Overall blocked status
184	PDSTK	VBUK	PDSTK		☐	PDSTK	☐	POD status on header level
185	FMSTK	VBUK	FMSTK		☐	FMSTK	☐	Status Funds Management

Maintenance Status

Access

☑   read only

☐   read and change

☐   Time-dependent views: like U, validity data like ' '

☐   read, change, delete and insert

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

History

Last changed by/on	SAP	20131127
SAP Release Created in