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 | Possible values |
|---|---|---|---|---|---|---|
|
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 | MANDT |
AUPO
Allocation Table Document Item
|
MANDT |
| AUFG | ABELP | AUFG | ABELN |
AUPO
Allocation Table Document Item
|
ABELN |
| AUFG | ABELP | AUFG | ABELP |
AUPO
Allocation Table Document Item
|
ABELP |
| AUFG | FIGRI | AUFG | FIGRI |
KLAH
Class Header Data
|
CLINT |
| AUFG | FIGRI | AUFG | MANDT |
KLAH
Class Header Data
|
MANDT |
| 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 |