SAP ABAP View U_16002 (Sales order)

Hierarchy

☛ SAP_APPL (Software Component) Logistics and Accounting
   ⤷ CA (Application Component) Cross-Application Components
     ⤷ UUDM (Package) EDM: Data Modeler (General)

Basic Data

View Type	D	Database View
Database View	U_16002
Short Description	Sales order
Root table	VBAK	Sales Document: Header Data

Entity Type	DM02L
Short text	Sales order

Table

#	Table Name	Foreign Table	Foreign Field	Foreign DIR
1	VBAK	VBAK
2	VBUK
3	VBKD
4	VEDA

Join Conditions

#	Table Name	Field Name	Negation	Operator	Constants	Cont. line	AND/OR	Offset	F Length	Mco Field
1	VBUK	MANDT	JL	EQ				0	0
2	VBAK	MANDT	JR	EQ			AND	0	0
3	VBUK	VBELN	JL	EQ				0	0
4	VBAK	VBELN	JR	EQ			AND	0	0
5	VBUK	MANDT	JL	EQ				0	0
6	VBKD	MANDT	JR	EQ			AND	0	0
7	VBUK	VBELN	JL	EQ				0	0
8	VBKD	VBELN	JR	EQ			AND	0	0
9	VBUK	MANDT	JL	EQ				0	0
10	VEDA	MANDT	JR	EQ			AND	0	0
11	VBUK	VBELN	JL	EQ				0	0
12	VEDA	VBELN	JR	EQ			AND	0	0
13	VBAK	VBTYP		EQ	'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	KUNNR	VBAK	KUNNR		☐	KUNAG	☐	Sold-to party
4	ERDAT	VBAK	ERDAT		☐	ERDAT	☐	Date on which the record was created
5	ERZET	VBAK	ERZET		☐	ERZET	☐	Entry time
6	ERNAM	VBAK	ERNAM		☐	ERNAM	☐	Name of Person who Created the Object
7	AUDAT	VBAK	AUDAT		☐	AUDAT	☐	Document Date (Date Received/Sent)
8	VBTYP	VBAK	VBTYP		☐	VBTYP	☐	SD document category
9	TRVOG	VBAK	TRVOG		☐	TRVOG	☐	Transaction group
10	AUART	VBAK	AUART		☐	AUART	☐	Sales Document Type
11	AUGRU	VBAK	AUGRU		☐	AUGRU	☐	Order reason (reason for the business transaction)
12	GWLDT	VBAK	GWLDT		☐	GWLDT	☐	Guarantee date
13	LIFSK	VBAK	LIFSK		☐	LIFSK	☐	Delivery block (document header)
14	FAKSK	VBAK	FAKSK		☐	FAKSK	☐	Billing block in SD document
15	NETWR	VBAK	NETWR		☐	NETWR_AK	☐	Net Value of the Sales Order in Document Currency
16	WAERK	VBAK	WAERK		☐	WAERK	☐	SD document currency
17	VKORG	VBAK	VKORG		☐	VKORG	☐	Sales Organization
18	VTWEG	VBAK	VTWEG		☐	VTWEG	☐	Distribution Channel
19	SPART	VBAK	SPART		☐	SPART	☐	Division
20	VKGRP	VBAK	VKGRP		☐	VKGRP	☐	Sales group
21	VKBUR	VBAK	VKBUR		☐	VKBUR	☐	Sales office
22	GSBER	VBAK	GSBER		☐	GSBER	☐	Business Area
23	GSKST	VBAK	GSKST		☐	GSKST	☐	Business area from cost center
24	KNUMV	VBAK	KNUMV		☐	KNUMV	☐	Number of the document condition
25	VDATU	VBAK	VDATU		☐	EDATU_VBAK	☐	Requested delivery date
26	VPRGR	VBAK	VPRGR		☐	PRGRS_VBAK	☐	Proposed Period for Date
27	AUTLF	VBAK	AUTLF		☐	AUTLF	☐	Complete delivery defined for each sales order?
28	VBKLA	VBAK	VBKLA		☐	VBKLA	☐	unused (sales doocument class)
29	VBKLT	VBAK	VBKLT		☐	VBKLT	☐	SD document indicator
30	KALSM	VBAK	KALSM		☐	KALSMASD	☐	Sales and Distribution: Pricing Procedure in Pricing
31	VSBED	VBAK	VSBED		☐	VSBED	☐	Shipping conditions
32	FKARA	VBAK	FKARA		☐	FKARA	☐	Proposed billing type for an order-related billing document
33	BSTNK	VBAK	BSTNK		☐	BSTNK	☐	Customer purchase order number
34	BSARK	VBAK	BSARK		☐	BSARK	☐	Customer Order Type
35	BSTDK	VBAK	BSTDK		☐	BSTDK	☐	Customer purchase order date
36	BSTZD	VBAK	BSTZD		☐	BSTZD	☐	Customer purchase order number supplement
37	IHREZ	VBAK	IHREZ		☐	IHREZ	☐	Your Reference
38	BNAME	VBAK	BNAME		☐	BNAME_V	☐	Name of orderer
39	TELF1	VBAK	TELF1		☐	TELF1_VP	☐	Telephone Number
40	MAHZA	VBAK	MAHZA		☐	MAHZA	☐	Number of reminder notices, reminders for delivery purchase
41	MAHDT	VBAK	MAHDT		☐	MAHDT	☐	Last Delivery Reminder Notice
42	STAFO	VBAK	STAFO		☐	STAFO	☐	Update group for statistics update
43	STWAE	VBAK	STWAE		☐	STWAE	☐	Statistics currency
44	AEDAT	VBAK	AEDAT		☐	AEDAT	☐	Last Changed On
45	KVGR1	VBAK	KVGR1		☐	KVGR1	☐	Customer group 1
46	KVGR2	VBAK	KVGR2		☐	KVGR2	☐	Customer group 2
47	KVGR3	VBAK	KVGR3		☐	KVGR3	☐	Customer group 3
48	KVGR4	VBAK	KVGR4		☐	KVGR4	☐	Customer group 4
49	KVGR5	VBAK	KVGR5		☐	KVGR5	☐	Customer group 5
50	KKBER	VBAK	KKBER		☐	KKBER	☐	Credit control area
51	KNKLI	VBAK	KNKLI		☐	KNKLI	☐	Customer's account number with credit limit reference
52	KURST	VBAK	KURST		☐	KURST	☐	Exchange Rate Type
53	GRUPP	VBAK	GRUPP		☐	GRUPP_CM	☐	Customer credit group
54	SBGRP	VBAK	SBGRP		☐	SBGRP_CM	☐	Credit Representative Group for Credit Management
55	CTLPC	VBAK	CTLPC		☐	CTLPC_CM	☐	Credit management: Risk category
56	CMWAE	VBAK	CMWAE		☐	WAERS_CM	☐	Currency key of credit control area
57	CMFRE	VBAK	CMFRE		☐	CMFRE	☐	Release date of the document determined by credit management
58	CMNUP	VBAK	CMNUP		☐	CMNUP	☐	Date of next credit check of document
59	CMNGV	VBAK	CMNGV		☐	CMNGV	☐	Next date
60	AMTBL	VBAK	AMTBL		☐	AMTBL_CM	☐	Released credit value of the document
61	HITYP_PR	VBAK	HITYP_PR		☐	HITYP_PR	☐	Hierarchy type for pricing
62	OBJNR	VBAK	OBJNR		☐	OBJKO	☐	Object number at header level
63	BUKRS_VF	VBAK	BUKRS_VF		☐	BUKRS_VF	☐	Company code to be billed
64	TAXK1	VBAK	TAXK1		☐	TAXK1_AK	☐	Alternative tax classification
65	TAXK2	VBAK	TAXK2		☐	TAXK2	☐	Tax classification 2 for customer
66	TAXK3	VBAK	TAXK3		☐	TAXK3	☐	Tax classification 3 for customer
67	TAXK4	VBAK	TAXK4		☐	TAXK4	☐	Tax classification 4 for customer
68	TAXK5	VBAK	TAXK5		☐	TAXK5	☐	Tax classification 5 for customer
69	TAXK6	VBAK	TAXK6		☐	TAXK6	☐	Tax classification 6 for customer
70	TAXK7	VBAK	TAXK7		☐	TAXK7	☐	Tax classification 7 for customer
71	TAXK8	VBAK	TAXK8		☐	TAXK8	☐	Tax classification 8 for customer
72	TAXK9	VBAK	TAXK9		☐	TAXK9	☐	Tax classification 9 for customer
73	XBLNR	VBAK	XBLNR		☐	XBLNR_V1	☐	Reference Document Number
74	ZUONR	VBAK	ZUONR		☐	ORDNR_V	☐	Assignment Number
75	VGTYP	VBAK	VGTYP		☐	VBTYP_V	☐	Document category of preceding SD document
76	VGBEL	VBAK	VGBEL		☐	VGBEL	☐	Document number of the reference document
77	KALSM_CH	VBAK	KALSM_CH		☐	KALSMA_CH	☐	Search procedure for batch determination
78	AGRZR	VBAK	AGRZR		☐	AGRZR	☐	Accrual period for order-related billing docs.to be accrued
79	KONDA	VBKD	KONDA		☐	KONDA	☐	Price Group (Customer)
80	KDGRP	VBKD	KDGRP		☐	KDGRP	☐	Customer group
81	BZIRK	VBKD	BZIRK		☐	BZIRK	☐	Sales district
82	PLTYP	VBKD	PLTYP		☐	PLTYP	☐	Price list type
83	INCO1	VBKD	INCO1		☐	INCO1	☐	Incoterms (part 1)
84	INCO2	VBKD	INCO2		☐	INCO2	☐	Incoterms (part 2)
85	KZAZU	VBKD	KZAZU		☐	KZAZU_D	☐	Order combination indicator
86	PERFK	VBKD	PERFK		☐	PERFK	☐	Invoice dates (calendar identification)
87	PERRL	VBKD	PERRL		☐	PERRL	☐	Invoice list schedule (calendar identification)
88	MRNKZ	VBKD	MRNKZ		☐	MRNKZ	☐	Manual invoice maintenance
89	KURRF	VBKD	KURRF		☐	KURRF	☐	Exchange rate for FI postings
90	VALTG	VBKD	VALTG		☐	VALTG	☐	Additional value days
91	VALDT	VBKD	VALDT		☐	VALDT	☐	Fixed value date
92	ZTERM	VBKD	ZTERM		☐	DZTERM	☐	Terms of payment key
93	ZLSCH	VBKD	ZLSCH		☐	SCHZW_BSEG	☐	Payment Method
94	KTGRD	VBKD	KTGRD		☐	KTGRD	☐	Account assignment group for this customer
95	KURSK	VBKD	KURSK		☐	KURSK	☐	Exchange Rate for Pricing and Statistics
96	PRSDT	VBKD	PRSDT		☐	PRSDT	☐	Date for pricing and exchange rate
97	FKDAT	VBKD	FKDAT		☐	FKDAT	☐	Billing date for billing index and printout
98	FBUDA	VBKD	FBUDA		☐	FBUDA	☐	Date When Services Rendered
99	GJAHR	VBKD	GJAHR		☐	GJAHR	☐	Fiscal Year
100	POPER	VBKD	POPER		☐	POPER	☐	Posting period
101	STCUR	VBKD	STCUR		☐	STCUR	☐	Exchange rate for statistics
102	MSCHL	VBKD	MSCHL		☐	MSCHL	☐	Dunning key
103	MANSP	VBKD	MANSP		☐	MANSP	☐	Dunning block
104	VLAUFZ	VEDA	VLAUFZ		☐	VLAUF_VEDA	☐	Contract Term
105	VINSDAT	VEDA	VINSDAT		☐	VIDAT_VEDA	☐	Installation date
106	VABNDAT	VEDA	VABNDAT		☐	VADAT_VEDA	☐	Agreement acceptance date
107	VBEGDAT	VEDA	VBEGDAT		☐	VBDAT_VEDA	☐	Contract start date
108	VUNTDAT	VEDA	VUNTDAT		☐	VUDAT_VEDA	☐	Date on which contract is signed
109	VAKTSCH	VEDA	VAKTSCH		☐	VASCH_VEDA	☐	Activity at end of contract
110	VKUESCH	VEDA	VKUESCH		☐	VKUES_VEDA	☐	Assignment cancellation procedure/cancellation rule
111	VEINDAT	VEDA	VEINDAT		☐	VEDAT_VEDA	☐	Date on which cancellation request was received
112	VWUNDAT	VEDA	VWUNDAT		☐	VWDAT_VEDA	☐	Requested cancellation date
113	VKUEGRU	VEDA	VKUEGRU		☐	VKGRU_VEDA	☐	Reason for cancellation of contract
114	VENDDAT	VEDA	VENDDAT		☐	VNDAT_VEDA	☐	Contract End Date
115	VBELKUE	VEDA	VBELKUE		☐	VBELK_VEDA	☐	Cancellation document number of contract partner
116	VBEDKUE	VEDA	VBEDKUE		☐	VBEDK_VEDA	☐	Date of cancellation document from contract partner
117	VBEGREG	VEDA	VBEGREG		☐	VBREG_VEDA	☐	Rule for calculating contract start date
118	VDEMDAT	VEDA	VDEMDAT		☐	VDDAT_VEDA	☐	Dismantling date
119	VASDA	VEDA	VASDA		☐	VASDA	☐	Date of Activity
120	WIMID	VEDA	WIMID		☐	WIMID	☐	Work item ID
121	VASDR	VEDA	VASDR		☐	VASDR	☐	Date Rule for Activity
122	VKUEPAR	VEDA	VKUEPAR		☐	VKPAR_VEDA	☐	Cancelling Party

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