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

SAP table AUFI has 5 primary key fields being MANDT,ABELN,ABELP,ABELG,ABELF.

If you're only analyzing data from a single SAP instance you may omit field MANT in your relationships as it will we the same across the entire dataset. On the other hand, if you're combining data from multiple SAP instances you need to take MANDT into account.

Field Description Data Type Length Decimals Checktable Data Element
MANDT Client CLNT 3 0 T000 MANDT
ABELN Allocation Table CHAR 10 0 AUKO ABELN
ABELP Allocation Table Item NUMC 5 0 AUPO ABELP
ABELG Store Group of an Allocation Table NUMC 5 0 AUFG ABELG
ABELF Identifier of a Recipient of an Item of an Allocation Table NUMC 5 0 ABELF
FILNR Customer Number CHAR 10 0 KNA1 KUNNR
FIWRK Store CHAR 4 0 T001W FIWRK
EKORG Purchasing organization CHAR 4 0 T024E EKORG
EKGRP Purchasing Group CHAR 3 0 T024 EKGRP
ERDAT Date on which the record was created DATS 8 0 ERDAT
AEDAT Last Changed On DATS 8 0 AEDAT
ERNAM Name of Person Responsible for Creating the Object CHAR 12 0 ERNAM
AENAM Name of Person Who Changed Object CHAR 12 0 AENAM
LFNRU Account No. of Supplier/Creditor of Sub-Item CHAR 10 0 LFA1 LFNRU
PMNGU Planned Quantity of Sub-Item QUAN 13 3 PMNGU
IMNGU Confirmed Quantity of Plant QUAN 13 3 IMNGU
MMNGU Minimum Quantity of Plant in Plant Group QUAN 13 3 MMNGU
WMNGE Quantity requested by store QUAN 13 3 WMNGE
AUFME Allocation Unit UNIT 3 0 T006 AUFME
LIEFW Flag: delivery phase exists CHAR 1 0 LIEFW
EBLNU Purchase Order Generated for Supplier CHAR 10 0 * EBLNU
EBLPU Generated purchase order item NUMC 5 0 * EBLPU
UBSTN Generated warehouse order CHAR 10 0 * UBSTN
UBSTP Generated stock transport order item NUMC 5 0 * UBSTP
VBLNU Generated delivery number CHAR 10 0 * VBLNU
VBLPU Generated delivery note item NUMC 6 0 * VBLPU
BEDAT Purchase Order Date DATS 8 0 BEDAT
BEDTP Date type (day, week, month, interval) CHAR 1 0 PRGRS
1 Day
2 Week
3 Month
4 Posting period
5 Planning calendar period
VKDAT Date of start of sales at plant DATS 8 0 VKIDT
VKTYP Date type (day, week, month, interval) CHAR 1 0 PRGRS
1 Day
2 Week
3 Month
4 Posting period
5 Planning calendar period
LEWED Latest Possible Goods Receipt DATS 8 0 LEWED
VZENT Distribution center (as customer) CHAR 10 0 KNA1 VZENT
VZWRK Distribution Center CHAR 4 0 T001W VZWRK
VZLFR Supplier Number of Plant CHAR 10 0 LFA1 LIFNR_WK
AAVIT Notification Category Allocation: Info Exchance HQ - Plant CHAR 4 0 T626 AAVIT
PLIFZ Planned Delivery Time in Days DEC 3 0 PLIFZ
WEBAZ Goods receipt processing time in days DEC 3 0 WEBAZ
ABFDT Confirmation request date DATS 8 0 AFIDT
ABFTP Date type (day, week, month, interval) CHAR 1 0 PRGRS
1 Day
2 Week
3 Month
4 Posting period
5 Planning calendar period
PSTAB Maint. status of plant CHAR 1 0 PSTAB
VKORG Sales Organization CHAR 4 0 * VKORG
VTWEG Distribution Channel CHAR 2 0 * VTWEG
SPART Division CHAR 2 0 * SPART
BSTMG Purchase Order Quantity QUAN 13 3 BSTMG
BSTME Purchase Order Unit of Measure UNIT 3 0 T006 BSTME
UMLMG Purchase Order Quantity QUAN 13 3 BSTMG
UMLME Purchase Order Unit of Measure UNIT 3 0 T006 BSTME
LFMNG GR qty assigned after alloc tbl adjustment made QUAN 13 3 EFMNG
VRKME Sales unit UNIT 3 0 T006 VRKME
SPERR Blocking flag, plant CHAR 1 0 T629 SPBTR
VQUOT Quotas (Base for qty calculation) NUMC 13 0 VQUOT
WMERF Single-Character Flag CHAR 1 0 CHAR1
BMERF Single-Character Flag CHAR 1 0 CHAR1
BEWZA Evaluation Figure of Plant NUMC 13 0 UPOBZ
LABST Valuated Unrestricted-Use Stock QUAN 13 3 LABST
HMNGU Maximum Quantity for Plants in Plant Group QUAN 13 3 HMNGU
BUKRS Company Code CHAR 4 0 T001 BUKRS
LAND1 Country/Region Key CHAR 3 0 T005 LAND1
ELIKZ "Delivery Completed" Indicator CHAR 1 0 ELIKZ
LGORT Storage location CHAR 4 0 T001L LGORT_D
ABFST Status plant notification CHAR 1 0 ABFST
ABAST Details status, plant notification CHAR 1 0 ABAST
Not Relevant
1 Not created
2 Request created, reply open, no reminder necessary
3 Request created, reply open, reminder necessary
4 Request created, reminder created, reply open
5 Request created, reply received, confirmation open
6 Request created, reply received, confirmed qty missing
9 Completely created
BLGTP Doc.Cat. for Follow-On Doc. to be Generated in Alloc. Tble CHAR 1 0 BLGTP
Purchase Order
1 Sales Order
EXPECTED_SALES Evaluation Figure of Plant NUMC 13 0 UPOBZ
OPEN_ORDERS Purchase Order Quantity QUAN 13 3 BSTMG
TREND_FACTOR Trend Factor NUMC 4 0 TREND_ALL

AUFI foreign key relationships

Table Field Check Table Check Field
0 AUFI AAVIT T626 Allocation Table Notification Categories MANDT
0 AUFI AAVIT T626 Allocation Table Notification Categories AAVIT
1 AUFI ABELG AUFG Allocation Table Sub-Item, Store Group MANDT
1 AUFI ABELG AUFG Allocation Table Sub-Item, Store Group ABELN
1 AUFI ABELG AUFG Allocation Table Sub-Item, Store Group ABELP
0 AUFI ABELN AUKO Allocation Table Document Header ABELN
1 AUFI ABELP AUPO Allocation Table Document Item ABELN
1 AUFI ABELP AUPO Allocation Table Document Item ABELP
0 AUFI AUFME T006 Units of Measurement MANDT
0 AUFI AUFME T006 Units of Measurement MSEHI
1 AUFI BSTME T006 Units of Measurement MANDT
0 AUFI BUKRS T001 Company Codes BUKRS
1 AUFI EKGRP T024 Purchasing Groups EKGRP
0 AUFI EKORG T024E Purchasing Organizations EKORG
1 AUFI FILNR KNA1 General Data in Customer Master MANDT
1 AUFI FILNR KNA1 General Data in Customer Master KUNNR
0 AUFI FIWRK T001W Plants/Branches MANDT
0 AUFI FIWRK T001W Plants/Branches WERKS
1 AUFI LAND1 T005 Countries MANDT
1 AUFI LAND1 T005 Countries LAND1
0 AUFI LFNRU LFA1 Supplier Master (General Section) MANDT
0 AUFI LFNRU LFA1 Supplier Master (General Section) LIFNR
1 AUFI LGORT T001L Storage Locations MANDT
1 AUFI LGORT T001L Storage Locations WERKS
0 AUFI MANDT T000 Clients MANDT
1 AUFI SPERR T629 Allocation Table Rejection Reasons MANDT
1 AUFI SPERR T629 Allocation Table Rejection Reasons SPERR
0 AUFI UMLME T006 Units of Measurement MANDT
0 AUFI UMLME T006 Units of Measurement MSEHI
1 AUFI VRKME T006 Units of Measurement MANDT
1 AUFI VRKME T006 Units of Measurement MSEHI
0 AUFI VZENT KNA1 General Data in Customer Master MANDT
0 AUFI VZENT KNA1 General Data in Customer Master KUNNR
1 AUFI VZLFR LFA1 Supplier Master (General Section) MANDT
1 AUFI VZLFR LFA1 Supplier Master (General Section) LIFNR
0 AUFI VZWRK T001W Plants/Branches MANDT
0 AUFI VZWRK T001W Plants/Branches WERKS