SAP ABAP Table AUFI (Allocation Table, Document Sub-item, Stores)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM (Application Component) Customer Relationship Management
     ⤷ CRM_APPLICATION (Package) All CRM Components Without Special Structure Packages
       ⤷ WAUF (Package) Application development R/3 Purchasing, Allocation table

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	AUFI	Table Relationship Diagram
Short Description	Allocation Table, Document Sub-item, Stores

Delivery and Maintenance

Pool/cluster
Delivery Class	A	Application Table (Master- and Transaction Data)
Data Browser/Table View Maintenance		Display/Maintenance Allowed with Restrictions

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	MANDT	☑	MANDT	MANDT	CLNT	3	0	Client	T000
2	ABELN	☑	ABELN	ABELN	CHAR	10	0	Allocation Table Number	AUKO
3	ABELP	☑	ABELP	ABELP	NUMC	5	0	Item number of allocation table	AUPO
4	ABELG	☑	ABELG	ABELG	NUMC	5	0	Sub-item no. of plant group (alloc tbl)	AUFG
5	ABELF	☑	ABELF	ABELF	NUMC	5	0	Sub.item no. of plant (alloc. tbl)
6	FILNR	☐	KUNNR	KUNNR	CHAR	10	0	Customer Number	KNA1
7	FIWRK	☐	FIWRK	WERKS	CHAR	4	0	Store as plant	T001W
8	EKORG	☐	EKORG	EKORG	CHAR	4	0	Purchasing organization	T024E
9	EKGRP	☐	EKGRP	EKGRP	CHAR	3	0	Purchasing group	T024
10	ERDAT	☐	ERDAT	DATUM	DATS	8	0	Date on which the record was created
11	AEDAT	☐	AEDAT	DATUM	DATS	8	0	Last Changed On
12	ERNAM	☐	ERNAM	USNAM	CHAR	12	0	Name of Person who Created the Object
13	AENAM	☐	AENAM	USNAM	CHAR	12	0	Name of Person Who Changed Object
14	LFNRU	☐	LFNRU	LIFNR	CHAR	10	0	Account no. of vendor / creditor of sub-item	LFA1
15	PMNGU	☐	PMNGU	MENG13	QUAN	13	3	Planned qty of sub-item
16	IMNGU	☐	IMNGU	MENG13	QUAN	13	3	Confirmed qty of plant
17	MMNGU	☐	MMNGU	MENG13	QUAN	13	3	Minimum Quantity of Plant in Plant Group
18	WMNGE	☐	WMNGE	MENG13	QUAN	13	3	Quantity requested by store
19	AUFME	☐	AUFME	MEINS	UNIT	3	0	Allocation Unit	T006
20	LIEFW	☐	LIEFW	CHAR1	CHAR	1	0	Flag: delivery phase exists
21	EBLNU	☐	EBLNU	EBELN	CHAR	10	0	Purchase Order Generated for Vendor	*
22	EBLPU	☐	EBLPU	EBELP	NUMC	5	0	Generated purchase order item	*
23	UBSTN	☐	UBSTN	EBELN	CHAR	10	0	Generated warehouse order	*
24	UBSTP	☐	UBSTP	EBELP	NUMC	5	0	Generated stock transport order item	*
25	VBLNU	☐	VBLNU	VBELN	CHAR	10	0	Generated delivery number	*
26	VBLPU	☐	VBLPU	POSNR	NUMC	6	0	Generated delivery note item	*
27	BEDAT	☐	BEDAT	DATUM	DATS	8	0	Purchase Order Date
28	BEDTP	☐	PRGRS	PRGRS	CHAR	1	0	Date type (day, week, month, interval)
29	VKDAT	☐	VKIDT	DATUM	DATS	8	0	Date of start of sales at plant
30	VKTYP	☐	PRGRS	PRGRS	CHAR	1	0	Date type (day, week, month, interval)
31	LEWED	☐	LEWED	DATUM	DATS	8	0	Latest Possible Goods Receipt
32	VZENT	☐	VZENT	KUNNR	CHAR	10	0	Distribution center (as customer)	KNA1
33	VZWRK	☐	VZWRK	WERKS	CHAR	4	0	Distribution center as plant	T001W
34	VZLFR	☐	LIFNR_WK	LIFNR	CHAR	10	0	Vendor number of plant	LFA1
35	AAVIT	☐	AAVIT	AAVIT	CHAR	4	0	Notification Category Allocation: Info Exchance HQ - Plant	T626
36	PLIFZ	☐	PLIFZ	DEC3	DEC	3	0	Planned delivery time in days
37	WEBAZ	☐	WEBAZ	DEC3	DEC	3	0	Goods receipt processing time in days
38	ABFDT	☐	AFIDT	DATUM	DATS	8	0	Confirmation request date
39	ABFTP	☐	PRGRS	PRGRS	CHAR	1	0	Date type (day, week, month, interval)
40	PSTAB	☐	PSTAB	PSTAK	CHAR	1	0	Maint. status of plant
41	VKORG	☐	VKORG	VKORG	CHAR	4	0	Sales Organization	*
42	VTWEG	☐	VTWEG	VTWEG	CHAR	2	0	Distribution Channel	*
43	SPART	☐	SPART	SPART	CHAR	2	0	Division	*
44	BSTMG	☐	BSTMG	MENG13	QUAN	13	3	Purchase Order Quantity
45	BSTME	☐	BSTME	MEINS	UNIT	3	0	Order unit	T006
46	UMLMG	☐	BSTMG	MENG13	QUAN	13	3	Purchase Order Quantity
47	UMLME	☐	BSTME	MEINS	UNIT	3	0	Order unit	T006
48	LFMNG	☐	EFMNG	MENG13	QUAN	13	3	GR qty assigned after alloc tbl adjustment made
49	VRKME	☐	VRKME	MEINS	UNIT	3	0	Sales unit	T006
50	SPERR	☐	SPBTR	SPERR_A	CHAR	1	0	Blocking flag, plant	T629
51	VQUOT	☐	VQUOT	VQUOT	NUMC	13	0	Quotas (Base for qty calculation)
52	WMERF	☐	CHAR1	CHAR1	CHAR	1	0	Single-Character Flag
53	BMERF	☐	CHAR1	CHAR1	CHAR	1	0	Single-Character Flag
54	BEWZA	☐	UPOBZ	UPOBZ	NUMC	13	0	Evaluation figure of plant
55	LABST	☐	LABST	MENG13V	QUAN	13	3	Valuated Unrestricted-Use Stock
56	HMNGU	☐	HMNGU	MENG13	QUAN	13	3	Maximum Quantity for Plants in Plant Group
57	BUKRS	☐	BUKRS	BUKRS	CHAR	4	0	Company Code	T001
58	LAND1	☐	LAND1	LAND1	CHAR	3	0	Country Key	T005
59	ELIKZ	☐	ELIKZ	XFELD	CHAR	1	0	"Delivery Completed" Indicator
60	LGORT	☐	LGORT_D	LGORT	CHAR	4	0	Storage location	T001L
61	ABFST	☐	ABFST	ASTAB	CHAR	1	0	Status plant notification
62	ABAST	☐	ABAST	ABAST	CHAR	1	0	Details status, plant notification
63	BLGTP	☐	BLGTP	BLGTP	CHAR	1	0	Doc.Cat. for Follow-On Doc. to be Generated in Alloc. Tble
64	EXPECTED_SALES	☐	UPOBZ	UPOBZ	NUMC	13	0	Evaluation figure of plant
65	OPEN_ORDERS	☐	BSTMG	MENG13	QUAN	13	3	Purchase Order Quantity
66	TREND_FACTOR	☐	TREND_ALL	NUMC04	NUMC	4	0	Trend Factor

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	AUFI	AAVIT	T626	AAVIT
2	AUFI	ABELG	AUFG	ABELG	KEY	1	CN
3	AUFI	ABELN	AUKO	ABELN	KEY	1	N
4	AUFI	ABELP	AUPO	ABELP	KEY	1	CN
5	AUFI	AUFME	T006	MSEHI	REF	1	N
6	AUFI	BSTME	T006	MSEHI	REF	1	CN
7	AUFI	BUKRS	T001	BUKRS
8	AUFI	EKGRP	T024	EKGRP
9	AUFI	EKORG	T024E	EKORG
10	AUFI	FILNR	KNA1	KUNNR	REF	1	N
11	AUFI	FIWRK	T001W	WERKS	KEY	1	CN
12	AUFI	LAND1	T005	LAND1
13	AUFI	LFNRU	LFA1	LIFNR	REF	C	N
14	AUFI	LGORT	T001L	LGORT
15	AUFI	MANDT	T000	MANDT	KEY	1	N
16	AUFI	SPERR	T629	SPERR	REF	1	CN
17	AUFI	UMLME	T006	MSEHI	REF	1	CN
18	AUFI	VRKME	T006	MSEHI	REF	1	CN
19	AUFI	VZENT	KNA1	KUNNR
20	AUFI	VZLFR	LFA1	LIFNR	REF	1	CN
21	AUFI	VZWRK	T001W	WERKS

History

Last changed by/on	SAP	20130529
SAP Release Created in