SAP ABAP View U_16199 (Customer quotation)

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_16199
Short Description	Customer quotation
Root table	VBAK	Sales Document: Header Data

Entity Type	DM02L
Short text	Customer quotation

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	VBUK	VBTYP		EQ	'B'			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	ANGDT	VBAK	ANGDT		☐	ANGDT_V	☐	Quotation/Inquiry is valid from
8	BNDDT	VBAK	BNDDT		☐	BNDDT	☐	Date until which bid/quotation is binding (valid-to date)
9	AUDAT	VBAK	AUDAT		☐	AUDAT	☐	Document Date (Date Received/Sent)
10	VBTYP	VBAK	VBTYP		☐	VBTYP	☐	SD document category
11	TRVOG	VBAK	TRVOG		☐	TRVOG	☐	Transaction group
12	AUART	VBAK	AUART		☐	AUART	☐	Sales Document Type
13	AUGRU	VBAK	AUGRU		☐	AUGRU	☐	Order reason (reason for the business transaction)
14	GWLDT	VBAK	GWLDT		☐	GWLDT	☐	Guarantee date
15	SUBMI	VBAK	SUBMI		☐	SUBMI_SD	☐	Collective number (SD)
16	NETWR	VBAK	NETWR		☐	NETWR_AK	☐	Net Value of the Sales Order in Document Currency
17	WAERK	VBAK	WAERK		☐	WAERK	☐	SD document currency
18	VKORG	VBAK	VKORG		☐	VKORG	☐	Sales Organization
19	VTWEG	VBAK	VTWEG		☐	VTWEG	☐	Distribution Channel
20	SPART	VBAK	SPART		☐	SPART	☐	Division
21	VKGRP	VBAK	VKGRP		☐	VKGRP	☐	Sales group
22	VKBUR	VBAK	VKBUR		☐	VKBUR	☐	Sales office
23	GSBER	VBAK	GSBER		☐	GSBER	☐	Business Area
24	GSKST	VBAK	GSKST		☐	GSKST	☐	Business area from cost center
25	KNUMV	VBAK	KNUMV		☐	KNUMV	☐	Number of the document condition
26	VDATU	VBAK	VDATU		☐	EDATU_VBAK	☐	Requested delivery date
27	VPRGR	VBAK	VPRGR		☐	PRGRS_VBAK	☐	Proposed Period for Date
28	AUTLF	VBAK	AUTLF		☐	AUTLF	☐	Complete delivery defined for each sales order?
29	VBKLA	VBAK	VBKLA		☐	VBKLA	☐	unused (sales doocument class)
30	VBKLT	VBAK	VBKLT		☐	VBKLT	☐	SD document indicator
31	KALSM	VBAK	KALSM		☐	KALSMASD	☐	Sales and Distribution: Pricing Procedure in Pricing
32	VSBED	VBAK	VSBED		☐	VSBED	☐	Shipping conditions
33	FKARA	VBAK	FKARA		☐	FKARA	☐	Proposed billing type for an order-related billing document
34	AWAHR	VBAK	AWAHR		☐	AWAHR_AK	☐	Sales Probability
35	KTEXT	VBAK	KTEXT		☐	KTEXT_V	☐	Search term for product proposal
36	BSTNK	VBAK	BSTNK		☐	BSTNK	☐	Customer purchase order number
37	BSARK	VBAK	BSARK		☐	BSARK	☐	Customer Order Type
38	BSTDK	VBAK	BSTDK		☐	BSTDK	☐	Customer purchase order date
39	BSTZD	VBAK	BSTZD		☐	BSTZD	☐	Customer purchase order number supplement
40	IHREZ	VBAK	IHREZ		☐	IHREZ	☐	Your Reference
41	BNAME	VBAK	BNAME		☐	BNAME_V	☐	Name of orderer
42	TELF1	VBAK	TELF1		☐	TELF1_VP	☐	Telephone Number
43	STAFO	VBAK	STAFO		☐	STAFO	☐	Update group for statistics update
44	STWAE	VBAK	STWAE		☐	STWAE	☐	Statistics currency
45	AEDAT	VBAK	AEDAT		☐	AEDAT	☐	Last Changed On
46	KVGR1	VBAK	KVGR1		☐	KVGR1	☐	Customer group 1
47	KVGR2	VBAK	KVGR2		☐	KVGR2	☐	Customer group 2
48	KVGR3	VBAK	KVGR3		☐	KVGR3	☐	Customer group 3
49	KVGR4	VBAK	KVGR4		☐	KVGR4	☐	Customer group 4
50	KVGR5	VBAK	KVGR5		☐	KVGR5	☐	Customer group 5
51	KKBER	VBAK	KKBER		☐	KKBER	☐	Credit control area
52	KNKLI	VBAK	KNKLI		☐	KNKLI	☐	Customer's account number with credit limit reference
53	KURST	VBAK	KURST		☐	KURST	☐	Exchange Rate Type
54	GRUPP	VBAK	GRUPP		☐	GRUPP_CM	☐	Customer credit group
55	SBGRP	VBAK	SBGRP		☐	SBGRP_CM	☐	Credit Representative Group for Credit Management
56	CTLPC	VBAK	CTLPC		☐	CTLPC_CM	☐	Credit management: Risk category
57	CMWAE	VBAK	CMWAE		☐	WAERS_CM	☐	Currency key of credit control area
58	CMFRE	VBAK	CMFRE		☐	CMFRE	☐	Release date of the document determined by credit management
59	CMNUP	VBAK	CMNUP		☐	CMNUP	☐	Date of next credit check of document
60	CMNGV	VBAK	CMNGV		☐	CMNGV	☐	Next date
61	AMTBL	VBAK	AMTBL		☐	AMTBL_CM	☐	Released credit value of the document
62	HITYP_PR	VBAK	HITYP_PR		☐	HITYP_PR	☐	Hierarchy type for pricing
63	OBJNR	VBAK	OBJNR		☐	OBJKO	☐	Object number at header level
64	BUKRS_VF	VBAK	BUKRS_VF		☐	BUKRS_VF	☐	Company code to be billed
65	TAXK1	VBAK	TAXK1		☐	TAXK1_AK	☐	Alternative tax classification
66	TAXK2	VBAK	TAXK2		☐	TAXK2	☐	Tax classification 2 for customer
67	TAXK3	VBAK	TAXK3		☐	TAXK3	☐	Tax classification 3 for customer
68	TAXK4	VBAK	TAXK4		☐	TAXK4	☐	Tax classification 4 for customer
69	TAXK5	VBAK	TAXK5		☐	TAXK5	☐	Tax classification 5 for customer
70	TAXK6	VBAK	TAXK6		☐	TAXK6	☐	Tax classification 6 for customer
71	TAXK7	VBAK	TAXK7		☐	TAXK7	☐	Tax classification 7 for customer
72	TAXK8	VBAK	TAXK8		☐	TAXK8	☐	Tax classification 8 for customer
73	TAXK9	VBAK	TAXK9		☐	TAXK9	☐	Tax classification 9 for customer
74	XBLNR	VBAK	XBLNR		☐	XBLNR_V1	☐	Reference Document Number
75	ZUONR	VBAK	ZUONR		☐	ORDNR_V	☐	Assignment Number
76	VGTYP	VBAK	VGTYP		☐	VBTYP_V	☐	Document category of preceding SD document
77	VGBEL	VBAK	VGBEL		☐	VGBEL	☐	Document number of the reference document
78	KALSM_CH	VBAK	KALSM_CH		☐	KALSMA_CH	☐	Search procedure for batch determination
79	AGRZR	VBAK	AGRZR		☐	AGRZR	☐	Accrual period for order-related billing docs.to be accrued
80	KONDA	VBKD	KONDA		☐	KONDA	☐	Price Group (Customer)
81	KDGRP	VBKD	KDGRP		☐	KDGRP	☐	Customer group
82	BZIRK	VBKD	BZIRK		☐	BZIRK	☐	Sales district
83	PLTYP	VBKD	PLTYP		☐	PLTYP	☐	Price list type
84	INCO1	VBKD	INCO1		☐	INCO1	☐	Incoterms (part 1)
85	INCO2	VBKD	INCO2		☐	INCO2	☐	Incoterms (part 2)
86	KZAZU	VBKD	KZAZU		☐	KZAZU_D	☐	Order combination indicator
87	VALTG	VBKD	VALTG		☐	VALTG	☐	Additional value days
88	VALDT	VBKD	VALDT		☐	VALDT	☐	Fixed value date
89	ZTERM	VBKD	ZTERM		☐	DZTERM	☐	Terms of payment key
90	ZLSCH	VBKD	ZLSCH		☐	SCHZW_BSEG	☐	Payment Method
91	KTGRD	VBKD	KTGRD		☐	KTGRD	☐	Account assignment group for this customer
92	KURSK	VBKD	KURSK		☐	KURSK	☐	Exchange Rate for Pricing and Statistics
93	PRSDT	VBKD	PRSDT		☐	PRSDT	☐	Date for pricing and exchange rate
94	FBUDA	VBKD	FBUDA		☐	FBUDA	☐	Date When Services Rendered
95	GJAHR	VBKD	GJAHR		☐	GJAHR	☐	Fiscal Year
96	POPER	VBKD	POPER		☐	POPER	☐	Posting period
97	STCUR	VBKD	STCUR		☐	STCUR	☐	Exchange rate for statistics
98	VLAUFZ	VEDA	VLAUFZ		☐	VLAUF_VEDA	☐	Contract Term
99	VLAUEZ	VEDA	VLAUEZ		☐	VLAUE_VEDA	☐	Unit of validity period of contract
100	VLAUFK	VEDA	VLAUFK		☐	VLAUK_VEDA	☐	Validity period category of contract
101	VINSDAT	VEDA	VINSDAT		☐	VIDAT_VEDA	☐	Installation date
102	VABNDAT	VEDA	VABNDAT		☐	VADAT_VEDA	☐	Agreement acceptance date
103	VBEGDAT	VEDA	VBEGDAT		☐	VBDAT_VEDA	☐	Contract start date
104	VUNTDAT	VEDA	VUNTDAT		☐	VUDAT_VEDA	☐	Date on which contract is signed
105	VKUESCH	VEDA	VKUESCH		☐	VKUES_VEDA	☐	Assignment cancellation procedure/cancellation rule
106	VAKTSCH	VEDA	VAKTSCH		☐	VASCH_VEDA	☐	Activity at end of contract
107	VBEGREG	VEDA	VBEGREG		☐	VBREG_VEDA	☐	Rule for calculating contract start date
108	VDEMDAT	VEDA	VDEMDAT		☐	VDDAT_VEDA	☐	Dismantling date

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