SAP AUFI Allocation Table, Document Sub-item, Stores Table
Overview
AUFI is a standard SAP S/4HANA table that stores Allocation Table, Document Sub-item, Stores data. There are total 66 fields in the AUFI table. The following is a list of the fields that make up this table. Key fields are marked in blue.
The table AUFI belongs to Allocation (LO-RFM-PUR-AL) module and is located in the package Application development R/3 Purchasing, Allocation table (WAUF).
In addition, following links provide an overview of foreign key relationships, if any, that link AUFI to other SAP tables and standard CDS views available based on AUFI table in S/4HANA 2020.
Techincal Settings of AUFI
Below are technical details of the table AUFI
- Buffering not allowed
- No buffering
- Storage type is Column Store
List of AUFI Fields
The following table gives you an overview of the fields available in AUFI
| Field | Description | Data Element | Check Table | Data Type | Length |
|---|---|---|---|---|---|
| MANDT | Client | MANDT | T000 | CLNT | 3 |
| ABELN | Allocation Table | ABELN | AUKO | CHAR | 10 |
| ABELP | Allocation Table Item | ABELP | AUPO | NUMC | 5 |
| ABELG | Store Group of an Allocation Table | ABELG | AUFG | NUMC | 5 |
| ABELF | Identifier of a Recipient of an Item of an Allocation Table | ABELF | NUMC | 5 | |
| FILNR | Customer Number | KUNNR | KNA1 | CHAR | 10 |
| FIWRK | Store | FIWRK | T001W | CHAR | 4 |
| EKORG | Purchasing organization | EKORG | T024E | CHAR | 4 |
| EKGRP | Purchasing Group | EKGRP | T024 | CHAR | 3 |
| ERDAT | Date on which the record was created | ERDAT | DATS | 8 | |
| AEDAT | Date of Last Change | AEDAT | DATS | 8 | |
| ERNAM | Name of Person who Created the Object | ERNAM | CHAR | 12 | |
| AENAM | Name of person who changed object | AENAM | CHAR | 12 | |
| LFNRU | Account No. of Supplier/Creditor of Sub-Item | LFNRU | LFA1 | CHAR | 10 |
| PMNGU | Planned Quantity of Sub-Item | PMNGU | QUAN | 13 | |
| IMNGU | Confirmed Quantity of Plant | IMNGU | QUAN | 13 | |
| MMNGU | Minimum Quantity of Plant in Plant Group | MMNGU | QUAN | 13 | |
| WMNGE | Quantity requested by store | WMNGE | QUAN | 13 | |
| AUFME | Allocation Unit | AUFME | T006 | UNIT | 3 |
| LIEFW | Flag: delivery phase exists | LIEFW | CHAR | 1 | |
| EBLNU | Purchase Order Generated for Supplier | EBLNU | * | CHAR | 10 |
| EBLPU | Generated purchase order item | EBLPU | * | NUMC | 5 |
| UBSTN | Generated warehouse order | UBSTN | * | CHAR | 10 |
| UBSTP | Generated stock transport order item | UBSTP | * | NUMC | 5 |
| VBLNU | Generated delivery number | VBLNU | * | CHAR | 10 |
| VBLPU | Generated delivery note item | VBLPU | * | NUMC | 6 |
| BEDAT | Purchase Order Date | BEDAT | DATS | 8 | |
| BEDTP | Date type (day, week, month, interval) | PRGRS | CHAR | 1 | |
| VKDAT | Date of start of sales at plant | VKIDT | DATS | 8 | |
| VKTYP | Date type (day, week, month, interval) | PRGRS | CHAR | 1 | |
| LEWED | Latest Possible Goods Receipt | LEWED | DATS | 8 | |
| VZENT | Distribution center (as customer) | VZENT | KNA1 | CHAR | 10 |
| VZWRK | Distribution Center | VZWRK | T001W | CHAR | 4 |
| VZLFR | Supplier Number of Plant | LIFNR_WK | LFA1 | CHAR | 10 |
| AAVIT | Notification Category Allocation: Info Exchance HQ - Plant | AAVIT | T626 | CHAR | 4 |
| PLIFZ | Planned Delivery Time in Days | PLIFZ | DEC | 3 | |
| WEBAZ | Goods receipt processing time in days | WEBAZ | DEC | 3 | |
| ABFDT | Confirmation request date | AFIDT | DATS | 8 | |
| ABFTP | Date type (day, week, month, interval) | PRGRS | CHAR | 1 | |
| PSTAB | Maint. status of plant | PSTAB | CHAR | 1 | |
| VKORG | Sales Organization | VKORG | * | CHAR | 4 |
| VTWEG | Distribution Channel | VTWEG | * | CHAR | 2 |
| SPART | Division | SPART | * | CHAR | 2 |
| BSTMG | Purchase Order Quantity | BSTMG | QUAN | 13 | |
| BSTME | Purchase Order Unit of Measure | BSTME | T006 | UNIT | 3 |
| UMLMG | Purchase Order Quantity | BSTMG | QUAN | 13 | |
| UMLME | Purchase Order Unit of Measure | BSTME | T006 | UNIT | 3 |
| LFMNG | GR qty assigned after alloc tbl adjustment made | EFMNG | QUAN | 13 | |
| VRKME | Sales unit | VRKME | T006 | UNIT | 3 |
| SPERR | Blocking flag, plant | SPBTR | T629 | CHAR | 1 |
| VQUOT | Quotas (Base for qty calculation) | VQUOT | NUMC | 13 | |
| WMERF | Single-Character Flag | CHAR1 | CHAR | 1 | |
| BMERF | Single-Character Flag | CHAR1 | CHAR | 1 | |
| BEWZA | Evaluation Figure of Plant | UPOBZ | NUMC | 13 | |
| LABST | Valuated Unrestricted-Use Stock | LABST | QUAN | 13 | |
| HMNGU | Maximum Quantity for Plants in Plant Group | HMNGU | QUAN | 13 | |
| BUKRS | Company Code | BUKRS | T001 | CHAR | 4 |
| LAND1 | Country/Region Key | LAND1 | T005 | CHAR | 3 |
| ELIKZ | Delivery Completed Indicator | ELIKZ | CHAR | 1 | |
| LGORT | Storage location | LGORT_D | T001L | CHAR | 4 |
| ABFST | Status plant notification | ABFST | CHAR | 1 | |
| ABAST | Details status, plant notification | ABAST | CHAR | 1 | |
| BLGTP | Doc.Cat. for Follow-On Doc. to be Generated in Alloc. Tble | BLGTP | CHAR | 1 | |
| EXPECTED_SALES | Evaluation Figure of Plant | UPOBZ | NUMC | 13 | |
| OPEN_ORDERS | Purchase Order Quantity | BSTMG | QUAN | 13 | |
| TREND_FACTOR | Trend Factor | TREND_ALL | NUMC | 4 |
Foreign Key Relationships
A foreign key field is a table field that is allocated to a check table and becomes part of the table's foreign key. The following table gives you an overview of the foreign keys for AUFI
| Table Name | Field | Cardinality | Check Table |
|---|---|---|---|
| AUFI | AAVIT | : | T626 |
| AUFI | ABELG | 1: CN | AUFG |
| AUFI | ABELN | 1: N | AUKO |
| AUFI | ABELP | 1: CN | AUPO |
| AUFI | AUFME | 1: N | T006 |
| AUFI | BSTME | 1: CN | T006 |
| AUFI | BUKRS | : | T001 |
| AUFI | EKGRP | : | T024 |
| AUFI | EKORG | : | T024E |
| AUFI | FILNR | 1: N | KNA1 |
| AUFI | FIWRK | 1: CN | T001W |
| AUFI | LAND1 | : | T005 |
| AUFI | LFNRU | C: N | LFA1 |
| AUFI | LGORT | : | T001L |
| AUFI | MANDT | 1: N | T000 |
| AUFI | SPERR | 1: CN | T629 |
| AUFI | UMLME | 1: CN | T006 |
| AUFI | VRKME | 1: CN | T006 |
| AUFI | VZENT | : | KNA1 |
| AUFI | VZLFR | 1: CN | LFA1 |
| AUFI | VZWRK | : | T001W |