SAP Table AUFG
Allocation Table Sub-Item, Store Group
AUFG (Allocation Table Sub-Item, Store Group) 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 AUFG to other SAP tables.
AUFG 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 | NUMC | 5 | 0 | |||
| FIGRI | Internal class number, plant | FCLIN | KLAH | NUMC | 10 | 0 | ||
| FIGRP | Base plant group | FIGRP | CHAR | 18 | 0 | |||
| GRMAN | Indicates that plant group does not exist as a class | GRMAN | CHAR | 1 | 0 | |||
| ANZFI | Number of Plants | ANZFI | NUMC | 5 | 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 | |||
| AUFME | Allocation Unit | AUFME | UNIT | 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 | |||
| SPERR | Blocking flag: plant group | SPBWG | T629 | CHAR | 1 | 0 | ||
| VQUOT | Quotas (Base for qty calculation) | VQUOT | NUMC | 13 | 0 | |||
| HMNGU | Maximum Quantity for Plants in Plant Group | HMNGU | QUAN | 13 | 3 | |||
AUFG foreign key relationships
| Table | Field | Foreign key table | Foreign key field | Check table | Check field | |
|---|---|---|---|---|---|---|
| AUFG | ABELN | AUFG | MANDT | AUKO | Allocation Table Document Header | MANDT |
| AUFG | ABELN | AUFG | ABELN | AUKO | Allocation Table Document Header | ABELN |
| AUFG | ABELP | AUFG | ABELP | AUPO | Allocation Table Document Item | ABELP |
| AUFG | ABELP | AUFG | MANDT | AUPO | Allocation Table Document Item | MANDT |
| AUFG | ABELP | AUFG | ABELN | AUPO | Allocation Table Document Item | ABELN |
| AUFG | FIGRI | AUFG | MANDT | KLAH | Class Header Data | MANDT |
| AUFG | FIGRI | AUFG | FIGRI | KLAH | Class Header Data | CLINT |
| AUFG | MANDT | AUFG | MANDT | T000 | Clients | MANDT |
| AUFG | SPERR | AUFG | MANDT | T629 | Allocation Table Rejection Reasons | MANDT |
| AUFG | SPERR | AUFG | SPERR | T629 | Allocation Table Rejection Reasons | SPERR |
