SAP ABAP View U_16270 (Customer rental contract)

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_16270
Short Description	Customer rental contract
Root table	VBAK	Sales Document: Header Data

Entity Type	DM02L
Short text	Customer rental contract

Table

#	Table Name	Foreign Table	Foreign Field	Foreign DIR
1	VBAK	VBAK
2	VBUK
3	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	VEDA	MANDT	JR	EQ			AND	0	0
7	VBUK	VBELN	JL	EQ				0	0
8	VEDA	VBELN	JR	EQ			AND	0	0
9	VBAK	AUART		EQ	'MV'			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	RFSTK	VBUK	RFSTK		☐	RFSTK	☐	Reference document header status
95	RFGSK	VBUK	RFGSK		☐	RFGSK	☐	Total reference status of all items
96	BESTK	VBUK	BESTK		☐	BESTK	☐	Confirmation status
97	LFSTK	VBUK	LFSTK		☐	LFSTK	☐	Delivery status
98	LFGSK	VBUK	LFGSK		☐	LKGSK	☐	Overall delivery status for all items
99	WBSTK	VBUK	WBSTK		☐	WBSTK	☐	Total goods movement status
100	FKSTK	VBUK	FKSTK		☐	FKSTK	☐	Billing status
101	FKSAK	VBUK	FKSAK		☐	FKSAK	☐	Billing status (order-related billing document)
102	BUCHK	VBUK	BUCHK		☐	BUCHK	☐	Posting Status of Billing Document
103	ABSTK	VBUK	ABSTK		☐	ABSTK	☐	Overall rejection status of all sales document items
104	GBSTK	VBUK	GBSTK		☐	GBSTK	☐	Overall processing status of document
105	KOSTK	VBUK	KOSTK		☐	KOSTK	☐	Overall picking / putaway status
106	LVSTK	VBUK	LVSTK		☐	LVSTK	☐	Overall status of warehouse management activities
107	UVALS	VBUK	UVALS		☐	UVALL_SU	☐	Total incompletion status of all items in general
108	UVVLS	VBUK	UVVLS		☐	UVVLS_SU	☐	Total incompletion status of all items: Delivery
109	UVFAS	VBUK	UVFAS		☐	UVFAK_SU	☐	Total incompletion status of all items: Billing
110	UVALL	VBUK	UVALL		☐	UVALL_UK	☐	General incompletion status of the header
111	UVVLK	VBUK	UVVLK		☐	UVVLK_UK	☐	Header incompletion status concerning delivery
112	UVFAK	VBUK	UVFAK		☐	UVFAK_UK	☐	Header incompletion status with respect to billing
113	UVPRS	VBUK	UVPRS		☐	UVPRS_UK	☐	Document is incomplete with respect to pricing
114	VBOBJ	VBUK	VBOBJ		☐	VBOBJ	☐	SD document object
115	AEDAT2	VBUK	AEDAT		☐	AEDAT	☐	Last Changed On
116	FKIVK	VBUK	FKIVK		☐	FKIVK	☐	Billing totals status for intercompany billing
117	RELIK	VBUK	RELIK		☐	RELIK	☐	Invoice list status of billing document
118	UVK01	VBUK	UVK01		☐	UVK01	☐	Customer reserves 1: Header status
119	UVK02	VBUK	UVK02		☐	UVK02	☐	Customer reserves 2: Header status
120	UVK03	VBUK	UVK03		☐	UVK03	☐	Customer reserves 3: Header status
121	UVK04	VBUK	UVK04		☐	UVK04	☐	Custmer reserves 4: Header status
122	UVK05	VBUK	UVK05		☐	UVK05	☐	Customer reserves 5: Header status
123	UVS01	VBUK	UVS01		☐	UVS01	☐	Customer reserves 1: Sum of all items
124	UVS02	VBUK	UVS02		☐	UVS02	☐	Customer reserves 2: Sum of all items
125	UVS03	VBUK	UVS03		☐	UVS03	☐	Customer reserves 3: Sum of all items
126	UVS04	VBUK	UVS04		☐	UVS04	☐	Customer reserves 4: Sum of all items
127	UVS05	VBUK	UVS05		☐	UVS05	☐	Customer reserves 5: Sum of all items
128	PKSTK	VBUK	PKSTK		☐	PKSTK	☐	Overall packing status of all items
129	CMPSA	VBUK	CMPSA		☐	CMPSA	☐	Status of static credit limit check
130	CMPSB	VBUK	CMPSB		☐	CMPSB	☐	Status of dynamic credit limit check in the credit horizon
131	CMPSC	VBUK	CMPSC		☐	CMPSC	☐	Status of credit check against maximum document value
132	CMPSD	VBUK	CMPSD		☐	CMPSD	☐	Status of credit check against terms of payment
133	CMPSE	VBUK	CMPSE		☐	CMPSE	☐	Status of credit check against customer review date
134	CMPSF	VBUK	CMPSF		☐	CMPSF	☐	Status of credit check against open items due
135	CMPSG	VBUK	CMPSG		☐	CMPSG	☐	Status of credit check against oldest open items
136	CMPSH	VBUK	CMPSH		☐	CMPSH	☐	Status of credit check against highest dunning level
137	CMPSI	VBUK	CMPSI		☐	CMPSI	☐	Status of credit check against financial document
138	CMPSJ	VBUK	CMPSJ		☐	CMPSJ	☐	Status of credit check against export credit insurance
139	CMPSK	VBUK	CMPSK		☐	CMPSK	☐	Status of credit check against payment card authorization
140	CMPSL	VBUK	CMPSL		☐	CMPSL	☐	Status of credit check of reserves 4
141	CMPS0	VBUK	CMPS0		☐	CMPS0	☐	Status of credit check for customer reserve 1
142	CMPS1	VBUK	CMPS1		☐	CMPS1	☐	Status of credit check for customer reserve 2
143	CMPS2	VBUK	CMPS2		☐	CMPS2	☐	Status of credit check for customer reserve 3
144	CMGST	VBUK	CMGST		☐	CMGST	☐	Overall status of credit checks
145	TRSTA	VBUK	TRSTA		☐	TRSTA	☐	Transportation planning status
146	KOQUK	VBUK	KOQUK		☐	KOQUK	☐	Status of pick confirmation
147	COSTA	VBUK	COSTA		☐	COSTA_D	☐	Confirmation status for ALE
148	VLAUFZ	VEDA	VLAUFZ		☐	VLAUF_VEDA	☐	Contract Term
149	VLAUEZ	VEDA	VLAUEZ		☐	VLAUE_VEDA	☐	Unit of validity period of contract
150	VLAUFK	VEDA	VLAUFK		☐	VLAUK_VEDA	☐	Validity period category of contract
151	VINSDAT	VEDA	VINSDAT		☐	VIDAT_VEDA	☐	Installation date
152	VABNDAT	VEDA	VABNDAT		☐	VADAT_VEDA	☐	Agreement acceptance date
153	VBEGDAT	VEDA	VBEGDAT		☐	VBDAT_VEDA	☐	Contract start date
154	VUNTDAT	VEDA	VUNTDAT		☐	VUDAT_VEDA	☐	Date on which contract is signed
155	VKUESCH	VEDA	VKUESCH		☐	VKUES_VEDA	☐	Assignment cancellation procedure/cancellation rule
156	VAKTSCH	VEDA	VAKTSCH		☐	VASCH_VEDA	☐	Activity at end of contract
157	VEINDAT	VEDA	VEINDAT		☐	VEDAT_VEDA	☐	Date on which cancellation request was received
158	VWUNDAT	VEDA	VWUNDAT		☐	VWDAT_VEDA	☐	Requested cancellation date
159	VKUEPAR	VEDA	VKUEPAR		☐	VKPAR_VEDA	☐	Cancelling Party
160	VKUEGRU	VEDA	VKUEGRU		☐	VKGRU_VEDA	☐	Reason for cancellation of contract
161	VENDDAT	VEDA	VENDDAT		☐	VNDAT_VEDA	☐	Contract End Date
162	VBELKUE	VEDA	VBELKUE		☐	VBELK_VEDA	☐	Cancellation document number of contract partner
163	VBEDKUE	VEDA	VBEDKUE		☐	VBEDK_VEDA	☐	Date of cancellation document from contract partner
164	VBEGREG	VEDA	VBEGREG		☐	VBREG_VEDA	☐	Rule for calculating contract start date
165	VVORZEIT	VEDA	VVORZEIT		☐	VZEIT_VEDA	☐	Lead time for cancellation prevention activities
166	VVOREIN	VEDA	VVOREIN		☐	VZEIE_VEDA	☐	Time unit of lead time
167	VDEMDAT	VEDA	VDEMDAT		☐	VDDAT_VEDA	☐	Dismantling date
168	VASDA	VEDA	VASDA		☐	VASDA	☐	Date of Activity
169	WIMID	VEDA	WIMID		☐	WIMID	☐	Work item ID
170	VASDR	VEDA	VASDR		☐	VASDR	☐	Date Rule for Activity
171	VENDREG	VEDA	VENDREG		☐	RGVTE	☐	Rule for contract end 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