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