AUFG is a standard SAP table in SAP ERP (or) S/4HANA which stores Allocation Table Sub-Item, Store Group data. There are total 19 fields in AUFG table.This blog post provides key technical details of SAP table AUFG, including its availability across SAP S/4HANA versions and the list of CDS views for AUFG table in SAP.
| SAP HANA Table Type | Column Store |
|---|---|
| Buffering Permission | Buffering not allowed |
| Buffering Type | No buffering |
| Package | Application development R/3 Purchasing, Allocation table (WAUF) |
| Technical Component | Allocation (LO-RFM-PUR-AL) |
SAP AUFG Table Fields
The following is the list of fields that are available in SAP AUFG table. The key fields of the table are highlighted in color.
| Field | Description | Data Element | Domain | Check Table | Data Type |
|---|---|---|---|---|---|
| MANDT | Client | MANDT | MANDT | T000 | CLNT (3) |
| ABELN | Allocation Table | ABELN | ABELN | AUKO | CHAR (10) |
| ABELP | Allocation Table Item | ABELP | ABELP | AUPO | NUMC (5) |
| ABELG | Store Group of an Allocation Table | ABELG | ABELG | NUMC (5) | |
| FIGRI | Internal class number, plant | FCLIN | CLINT | KLAH | NUMC (10) |
| FIGRP | Base plant group | FIGRP | KLASSE | CHAR (18) | |
| GRMAN | Indicates that plant group does not exist as a class | GRMAN | CHAR1 | CHAR (1) | |
| ANZFI | Number of Plants | ANZFI | ANZFI | NUMC (5) | |
| PMNGU | Planned Quantity of Sub-Item | PMNGU | MENG13 | QUAN (13) | |
| IMNGU | Confirmed Quantity of Plant | IMNGU | MENG13 | QUAN (13) | |
| MMNGU | Minimum Quantity of Plant in Plant Group | MMNGU | MENG13 | QUAN (13) | |
| AUFME | Allocation Unit | AUFME | MEINS | * | UNIT (3) |
| ERDAT | Date on which the record was created | ERDAT | DATUM | DATS (8) | |
| AEDAT | Date of Last Change | AEDAT | DATUM | DATS (8) | |
| ERNAM | Name of Person who Created the Object | ERNAM | USNAM | CHAR (12) | |
| AENAM | Name of person who changed object | AENAM | USNAM | CHAR (12) | |
| SPERR | Blocking flag: plant group | SPBWG | SPERR_A | T629 | CHAR (1) |
| VQUOT | Quotas (Base for qty calculation) | VQUOT | VQUOT | NUMC (13) | |
| HMNGU | Maximum Quantity for Plants in Plant Group | HMNGU | MENG13 | QUAN (13) |
Availability
The SAP table AUFG is available within SAP S/4HANA On-premise and SAP S/4HANA Cloud systems depending on the version and release level.
| SAP S/4HANA Version | Available? |
|---|---|
| 1909 | Yes |
| 2020 | Yes |
| 2021 | Yes |
| 2022 | Yes |
| 2023 | Yes |
CDS Views for AUFG table
The following is the list of AUFG CDS views, which can also be used instead of AUFG table based on your business requirements.
| CDS View | CDS View Type | Description |
|---|---|---|
| I_ALLOCATIONTABLEITEMRCPNTGRP | BASIC | Allocation Table Item Recipient Group |
| I_ALLOCATIONTABLERECIPIENT | COMPOSITE | Allocation Table Recipient |
| C_ALLOCTBLITEMOBJPGRCVGSTORE | CONSUMPTION | Allocation Table Item Object Page – Receiving Stores |
| C_ALLOCTBLITMOBJPGRCVGDISTRCTR | CONSUMPTION | Allocation Table Item Object Page – Receiving Distr Centers |
| C_ALLOCTBLOBJPGRECEIVINGSTORE | CONSUMPTION | Allocation Table Object Page – Receiving Stores |
| C_SITEOBJPGALLOCATIONTABLE | CONSUMPTION | Site Object Page – Allocation Table |
