SAP ABAP View U_16810 (Material allocation table sub-item - plant)

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_16810
Short Description	Material allocation table sub-item - plant
Root table	AUFI	Allocation Table, Document Sub-item, Stores

Entity Type	DM02L
Short text	Material allocation table sub-item - plant

Table

#	Table Name	Foreign Table	Foreign Field	Foreign DIR
1	AUFI	AUFI
2	AUPO
3	AUVT

Join Conditions

#	Table Name	Field Name	Negation	Operator	Constants	Cont. line	AND/OR	Offset	F Length	Mco Field
1	AUPO	MANDT	JL	EQ				0	0
2	AUFI	MANDT	JR	EQ			AND	0	0
3	AUPO	ABELN	JL	EQ				0	0
4	AUFI	ABELN	JR	EQ			AND	0	0
5	AUPO	ABELP	JL	EQ				0	0
6	AUFI	ABELP	JR	EQ			AND	0	0
7	AUPO	MANDT	JL	EQ				0	0
8	AUVT	MANDT	JR	EQ			AND	0	0
9	AUPO	ABELN	JL	EQ				0	0
10	AUVT	ABELN	JR	EQ			AND	0	0
11	AUPO	ABELP	JL	EQ				0	0
12	AUVT	ABELP	JR	EQ				0	0

View Fields

#	View field	Table	Field	Maintenance Flag	Key	Data element	Mod	Short Description
1	MANDT	AUFI	MANDT		☐	MANDT	☐	Client
2	ABELN	AUFI	ABELN		☐	ABELN	☐	Allocation Table Number
3	ABELP	AUFI	ABELP		☐	ABELP	☐	Item number of allocation table
4	ABELG	AUFI	ABELG		☐	ABELG	☐	Sub-item no. of plant group (alloc tbl)
5	ABELF	AUFI	ABELF		☐	ABELF	☐	Sub.item no. of plant (alloc. tbl)
6	FILNR	AUFI	FILNR		☐	KUNNR	☐	Customer Number
7	FIWRK	AUFI	FIWRK		☐	FIWRK	☐	Store as plant
8	EKORG	AUFI	EKORG		☐	EKORG	☐	Purchasing organization
9	EKGRP	AUFI	EKGRP		☐	EKGRP	☐	Purchasing group
10	ERDAT	AUFI	ERDAT		☐	ERDAT	☐	Date on which the record was created
11	AEDAT	AUFI	AEDAT		☐	AEDAT	☐	Last Changed On
12	ERNAM	AUFI	ERNAM		☐	ERNAM	☐	Name of Person who Created the Object
13	AENAM	AUFI	AENAM		☐	AENAM	☐	Name of Person Who Changed Object
14	LFNRU	AUFI	LFNRU		☐	LFNRU	☐	Account no. of vendor / creditor of sub-item
15	PMNGU	AUFI	PMNGU		☐	PMNGU	☐	Planned qty of sub-item
16	IMNGU	AUFI	IMNGU		☐	IMNGU	☐	Confirmed qty of plant
17	MMNGU	AUFI	MMNGU		☐	MMNGU	☐	Minimum Quantity of Plant in Plant Group
18	WMNGE	AUFI	WMNGE		☐	WMNGE	☐	Quantity requested by store
19	AUFME	AUFI	AUFME		☐	AUFME	☐	Allocation Unit
20	LIEFW	AUFI	LIEFW		☐	LIEFW	☐	Flag: delivery phase exists
21	EBLNU	AUFI	EBLNU		☐	EBLNU	☐	Purchase Order Generated for Vendor
22	EBLPU	AUFI	EBLPU		☐	EBLPU	☐	Generated purchase order item
23	UBSTN	AUFI	UBSTN		☐	UBSTN	☐	Generated warehouse order
24	UBSTP	AUFI	UBSTP		☐	UBSTP	☐	Generated stock transport order item
25	VBLNU	AUFI	VBLNU		☐	VBLNU	☐	Generated delivery number
26	VBLPU	AUFI	VBLPU		☐	VBLPU	☐	Generated delivery note item
27	BEDAT	AUFI	BEDAT		☐	BEDAT	☐	Purchase Order Date
28	BEDTP	AUFI	BEDTP		☐	PRGRS	☐	Date type (day, week, month, interval)
29	VKDAT	AUFI	VKDAT		☐	VKIDT	☐	Date of start of sales at plant
30	VKTYP	AUFI	VKTYP		☐	PRGRS	☐	Date type (day, week, month, interval)
31	LEWED	AUFI	LEWED		☐	LEWED	☐	Latest Possible Goods Receipt
32	VZENT	AUFI	VZENT		☐	VZENT	☐	Distribution center (as customer)
33	VZWRK	AUFI	VZWRK		☐	VZWRK	☐	Distribution center as plant
34	VZLFR	AUFI	VZLFR		☐	LIFNR_WK	☐	Vendor number of plant
35	AAVIT	AUFI	AAVIT		☐	AAVIT	☐	Notification Category Allocation: Info Exchance HQ - Plant
36	PLIFZ	AUFI	PLIFZ		☐	PLIFZ	☐	Planned delivery time in days
37	WEBAZ	AUFI	WEBAZ		☐	WEBAZ	☐	Goods receipt processing time in days
38	ABFDT	AUFI	ABFDT		☐	AFIDT	☐	Confirmation request date
39	ABFTP	AUFI	ABFTP		☐	PRGRS	☐	Date type (day, week, month, interval)
40	PSTAB	AUFI	PSTAB		☐	PSTAB	☐	Maint. status of plant
41	VKORG	AUFI	VKORG		☐	VKORG	☐	Sales Organization
42	VTWEG	AUFI	VTWEG		☐	VTWEG	☐	Distribution Channel
43	SPART	AUFI	SPART		☐	SPART	☐	Division
44	BSTMG	AUFI	BSTMG		☐	BSTMG	☐	Purchase Order Quantity
45	BSTME	AUFI	BSTME		☐	BSTME	☐	Order unit
46	UMLMG	AUFI	UMLMG		☐	BSTMG	☐	Purchase Order Quantity
47	UMLME	AUFI	UMLME		☐	BSTME	☐	Order unit
48	LFMNG	AUFI	LFMNG		☐	EFMNG	☐	GR qty assigned after alloc tbl adjustment made
49	VRKME	AUFI	VRKME		☐	VRKME	☐	Sales unit
50	SPERR	AUFI	SPERR		☐	SPBTR	☐	Blocking flag, plant
51	VQUOT	AUFI	VQUOT		☐	VQUOT	☐	Quotas (Base for qty calculation)
52	WMERF	AUFI	WMERF		☐	CHAR1	☐	Single-Character Flag
53	BMERF	AUFI	BMERF		☐	CHAR1	☐	Single-Character Flag
54	VSTEL	AUVT	VSTEL		☐	VSTEL	☐	Shipping Point/Receiving Point
55	LPRIO	AUVT	LPRIO		☐	LPRIO	☐	Delivery priority
56	ROUTE	AUVT	ROUTE		☐	ROUTE	☐	Route
57	FILWE	AUVT	FILWE		☐	FILNR	☐	Customer no. of plant
58	FILAG	AUVT	FILAG		☐	KUNAG	☐	Sold-to party
59	SPDNR	AUVT	SPDNR		☐	SPDNR	☐	Carrier
60	WERKS	AUVT	WERKS		☐	WERKS_D	☐	Plant
61	LGORT	AUVT	LGORT		☐	LGORT_D	☐	Storage location

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	20130529
SAP Release Created in