1. Home
  2. Resources
  3. SAP Tables
  4. AUFI - Allocation Table, Document Sub-item, Stores

SAP Table AUFI

Allocation Table, Document Sub-item, Stores

AUFI (Allocation Table, Document Sub-item, Stores) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.

Additionally we provide an overview of foreign key relationships, if any, that link AUFI to other SAP tables.

AUFI table fields

Field Data element Checktable Datatype Length Decimals
MANDT Client MANDT T000 CLNT 3 0
ABELN Allocation Table Number ABELN AUKO CHAR 10 0
ABELP Item number of allocation table ABELP AUPO NUMC 5 0
ABELG Sub-item no. of plant group (alloc tbl) ABELG AUFG NUMC 5 0
ABELF Sub.item no. of plant (alloc. tbl) ABELF NUMC 5 0
FILNR Customer Number KUNNR KNA1 CHAR 10 0
FIWRK Store as plant FIWRK T001W CHAR 4 0
EKORG Purchasing Organization EKORG T024E CHAR 4 0
EKGRP Purchasing Group EKGRP T024 CHAR 3 0
ERDAT Date on Which Record Was Created ERDAT DATS 8 0
AEDAT Changed On AEDAT DATS 8 0
ERNAM Name of Person who Created the Object ERNAM CHAR 12 0
AENAM Name of Person Who Changed Object AENAM CHAR 12 0
LFNRU Account no. of vendor / creditor of sub-item LFNRU LFA1 CHAR 10 0
PMNGU Planned qty of sub-item PMNGU QUAN 13 3
IMNGU Confirmed qty of plant IMNGU QUAN 13 3
MMNGU Minimum Quantity of Plant in Plant Group MMNGU QUAN 13 3
WMNGE Quantity requested by store WMNGE QUAN 13 3
AUFME Allocation Unit AUFME T006 UNIT 3 0
LIEFW Flag: delivery phase exists LIEFW CHAR 1 0
EBLNU Purchase Order Generated for Vendor EBLNU CHAR 10 0
EBLPU Generated purchase order item EBLPU NUMC 5 0
UBSTN Generated warehouse order UBSTN CHAR 10 0
UBSTP Generated stock transport order item UBSTP NUMC 5 0
VBLNU Generated delivery number VBLNU CHAR 10 0
VBLPU Generated delivery note item VBLPU NUMC 6 0
BEDAT Purchase Order Date BEDAT DATS 8 0
BEDTP Date type (day, week, month, interval) PRGRS CHAR 1 0
1 Day
2 Week
3 Month
4 Posting period
5 Planning calendar period
VKDAT Date of start of sales at plant VKIDT DATS 8 0
VKTYP Date type (day, week, month, interval) PRGRS CHAR 1 0
1 Day
2 Week
3 Month
4 Posting period
5 Planning calendar period
LEWED Latest Possible Goods Receipt LEWED DATS 8 0
VZENT Distribution center (as customer) VZENT KNA1 CHAR 10 0
VZWRK Distribution center as plant VZWRK T001W CHAR 4 0
VZLFR Vendor number of plant LIFNR_WK LFA1 CHAR 10 0
AAVIT Notification Category Allocation: Info Exchance HQ - Plant AAVIT T626 CHAR 4 0
PLIFZ Planned Delivery Time in Days PLIFZ DEC 3 0
WEBAZ Goods Receipt Processing Time in Days WEBAZ DEC 3 0
ABFDT Confirmation request date AFIDT DATS 8 0
ABFTP Date type (day, week, month, interval) PRGRS CHAR 1 0
1 Day
2 Week
3 Month
4 Posting period
5 Planning calendar period
PSTAB Maint. status of plant PSTAB CHAR 1 0
1 New
2 Released
3 In Process
4 Incomplete
VKORG Sales Organization VKORG CHAR 4 0
VTWEG Distribution Channel VTWEG CHAR 2 0
SPART Division SPART CHAR 2 0
BSTMG Purchase Order Quantity BSTMG QUAN 13 3
BSTME Purchase Order Unit of Measure BSTME T006 UNIT 3 0
UMLMG Purchase Order Quantity BSTMG QUAN 13 3
UMLME Purchase Order Unit of Measure BSTME T006 UNIT 3 0
LFMNG GR qty assigned after alloc tbl adjustment made EFMNG QUAN 13 3
VRKME Sales unit VRKME T006 UNIT 3 0
SPERR Blocking flag, plant SPBTR T629 CHAR 1 0
VQUOT Quotas (Base for qty calculation) VQUOT NUMC 13 0
WMERF Single-Character Indicator CHAR1 CHAR 1 0
BMERF Single-Character Indicator CHAR1 CHAR 1 0
BEWZA Evaluation figure of plant UPOBZ NUMC 13 0
LABST Valuated Unrestricted-Use Stock LABST QUAN 13 3
HMNGU Maximum Quantity for Plants in Plant Group HMNGU QUAN 13 3
BUKRS Company Code BUKRS T001 CHAR 4 0
LAND1 Country Key LAND1 T005 CHAR 3 0
ELIKZ "Delivery Completed" Indicator ELIKZ CHAR 1 0
X Yes
NULL No
LGORT Storage Location LGORT_D T001L CHAR 4 0
ABFST Status plant notification ABFST CHAR 1 0
NULL Not Relevant
1 Not created
2 Created
ABAST Details status, plant notification ABAST CHAR 1 0
NULL 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 BLGTP CHAR 1 0
NULL Purchase Order
1 Sales Order
EXPECTED_SALES Evaluation figure of plant UPOBZ NUMC 13 0
OPEN_ORDERS Purchase Order Quantity BSTMG QUAN 13 3
TREND_FACTOR Trend Factor TREND_ALL NUMC 4 0

AUFI foreign key relationships

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