SAP AUFG Allocation Table Sub-Item, Store Group Table
Overview
AUFG is a standard SAP S/4HANA table that stores Allocation Table Sub-Item, Store Group data. There are total 19 fields in the AUFG table. The following is a list of the fields that make up this table. Key fields are marked in blue.
The table AUFG 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 AUFG to other SAP tables and standard CDS views available based on AUFG table in S/4HANA 2020.
Techincal Settings of AUFG
Below are technical details of the table AUFG
- Buffering not allowed
- No buffering
- Storage type is Column Store
List of AUFG Fields
The following table gives you an overview of the fields available in AUFG
| 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 | NUMC | 5 | |
| FIGRI | Internal class number, plant | FCLIN | KLAH | NUMC | 10 |
| FIGRP | Base plant group | FIGRP | CHAR | 18 | |
| GRMAN | Indicates that plant group does not exist as a class | GRMAN | CHAR | 1 | |
| ANZFI | Number of Plants | ANZFI | NUMC | 5 | |
| 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 | |
| AUFME | Allocation Unit | AUFME | * | UNIT | 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 | |
| SPERR | Blocking flag: plant group | SPBWG | T629 | CHAR | 1 |
| VQUOT | Quotas (Base for qty calculation) | VQUOT | NUMC | 13 | |
| HMNGU | Maximum Quantity for Plants in Plant Group | HMNGU | QUAN | 13 |
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 AUFG
| Table Name | Field | Cardinality | Check Table |
|---|---|---|---|
| AUFG | ABELN | 1: CN | AUKO |
| AUFG | ABELP | : | AUPO |
| AUFG | FIGRI | : | KLAH |
| AUFG | MANDT | : | T000 |
| AUFG | SPERR | 1: CN | T629 |