SAP AUPO Allocation Table Document Item Table
Overview
AUPO is a standard SAP S/4HANA table that stores Allocation Table Document Item data. There are total 73 fields in the AUPO table. The following is a list of the fields that make up this table. Key fields are marked in blue.
The table AUPO 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 AUPO to other SAP tables and standard CDS views available based on AUPO table in S/4HANA 2020.
Techincal Settings of AUPO
Below are technical details of the table AUPO
- Buffering not allowed
- No buffering
- Storage type is Column Store
List of AUPO Fields
The following table gives you an overview of the fields available in AUPO
| 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 | NUMC | 5 | |
| APSTP | Item category of allocation table | APSTP | T621 | CHAR | 4 |
| ASTAP | Activity status of allocation table item | ASTAP | CHAR | 1 | |
| PSTAP | Maintenance status of alloc. table item | PSTAP | CHAR | 1 | |
| SPERR | Blocking flag: item | SPPOS | T629 | CHAR | 1 |
| 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 | |
| RFKTN | Reference outline agreement | RFKTN | EKKO | CHAR | 10 |
| RFKTP | Reference outline agreement item | RFKTP | EKPO | NUMC | 5 |
| RSNUM | Number of reservation/dependent requirements | RSNUM | * | NUMC | 10 |
| RSPOS | Item Number of Reservation / Dependent Requirements | RSPOS | NUMC | 4 | |
| EBELN | Purchasing Document Number | EBELN | EKKO | CHAR | 10 |
| EBELP | Item Number of Purchasing Document | EBELP | EKPO | NUMC | 5 |
| AKTNR | Promotion | WAKTION | WAKH | CHAR | 10 |
| AKTPO | Sub-item for units of measure | W_MEPOS | NUMC | 2 | |
| MATNR | Material Number | MATNR | MARA | CHAR | 40 |
| MAKTX | Material Description | MAKTX | CHAR | 40 | |
| BWART | Valuation Type | BWTAR_D | T149D | CHAR | 10 |
| VZWRK | Distribution Center | VZWRK | T001W | CHAR | 4 |
| LIFNR | Vendor's account number | ELIFN | LFA1 | CHAR | 10 |
| SBELN | No. of allocation rule | SBELN | * | CHAR | 10 |
| FIKLI | Internal class number, plant | FCLIN | KLAH | NUMC | 10 |
| FILKL | Plant group (technical plant class) | FILKL | CHAR | 18 | |
| PMNGE | Planned Quantity of Item | PMNGE | QUAN | 13 | |
| IMNGE | Confirmed Quantity of Item | IMNGE | QUAN | 13 | |
| MMNGE | Minimum Quantity Per Plant | MMNGE | QUAN | 13 | |
| AUFME | Allocation Unit | AUFME | T006 | UNIT | 3 |
| MEINS | Base Unit of Measure | MEINS | T006 | UNIT | 3 |
| UZAEH | Numerator for conversion to base units of measure | UZAEH | DEC | 5 | |
| UNENN | Denominator for conversion to base units of measure | UNENN | DEC | 5 | |
| LISTG | Listing Indicator | LISTG | CHAR | 1 | |
| MANUE | Flag: allocation table manually changed | MANUE | CHAR | 1 | |
| RUNDG | Rounding off in allocation table | RUNDG | CHAR | 1 | |
| RESTV | Split remainder | RESTV | CHAR | 1 | |
| ASTRA | Allocation Strategy | ASTRA | T627 | CHAR | 4 |
| LIEFW | Flag: delivery phase exists | LIEFW | CHAR | 1 | |
| VKSDT | Date of start of sales at plant | VKIDT | DATS | 8 | |
| VKSTP | Date type (day, week, month, interval) | PRGRS | CHAR | 1 | |
| AAVIT | Notification Category Allocation: Info Exchance HQ - Plant | AAVIT | T626 | CHAR | 4 |
| MATKL | Material Group | MATKL | T023 | CHAR | 9 |
| VZENT | Distribution center (as customer) | VZENT | KNA1 | CHAR | 10 |
| VZLFR | Supplier Number of Plant | LIFNR_WK | LFA1 | CHAR | 10 |
| BSART | Order Type in Allocation Table (for External Supplier) | BSART_LIEF | T161 | CHAR | 4 |
| UMART | Order type in allocation table (for warehouse/DC) | BSART_LAGER | T161 | CHAR | 4 |
| BSART_GL_BUKRS | Replacement order type in alloc tbl in same company code | BSART_GL_BUKRS | T161 | CHAR | 4 |
| LFART | Delivery type of allocation table | LFART_AUFT | TVLK | CHAR | 4 |
| ABFDT | Confirmation request date | AFIDT | DATS | 8 | |
| ABFTP | Date type (day, week, month, interval) | PRGRS | CHAR | 1 | |
| SVFIX | Plants fixed in AR | SVFIX | CHAR | 1 | |
| SIMAM | Alloc tbl qty simulation | SIMAM | CHAR | 1 | |
| LGORT | Storage location | LGORT_D | T001L | CHAR | 4 |
| HMNGE | Maximum Quantity Per Plant | HMNGE | QUAN | 13 | |
| KETYP | Key Figure Category | KETYP | * | CHAR | 1 |
| VBELN | Delivery | VBELN_VL | LIKP | CHAR | 10 |
| VBELP | Delivery Item | POSNR_VL | LIPS | NUMC | 6 |
| SAPOS | Allocation table item of material on higher level | POSNR_SA | * | NUMC | 5 |
| ATTYP | Material Category | ATTYP | CHAR | 2 | |
| RETPO | Returns Item | RETPO | CHAR | 1 | |
| BERMIMA | Include Minimum and Maximum Quantities | BERMIMA | CHAR | 1 | |
| KAART | Sales Document Type | AUART | TVAK | CHAR | 4 |
| NREMFIN | Number of Recipient Determination | NREMFIN | EMFIN | CHAR | 4 |
| EXT_REF_ID | External Reference Number | RDM_EXT_REF_ID | CHAR | 25 | |
| ASTRA_VAR | Allocation Strategy Variant | ASTRA_VAR | * | CHAR | 14 |
| ERVON | Application creating allocation table | ERVON | CHAR | 1 | |
| WRF_HIER_CNT | Hierarchy | WRF_HIER_CNT | CHAR | 2 | |
| WRF_CDT_LEVEL | Hierarchy Level | WRF_CDT_LEVEL | NUMC | 2 | |
| WRF_STRUC_NODE | Hierarchy Node | WRF_STRUC_NODE | CHAR | 18 | |
| PLID | Purchasing List Number | WRF_PLID | * | CHAR | 10 |
| CONS_MODE | Consignment Processing in Allocation Table | WRF_AT_CONS_MODE | CHAR | 1 |
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 AUPO
| Table Name | Field | Cardinality | Check Table |
|---|---|---|---|
| AUPO | AAVIT | : | T626 |
| AUPO | ABELN | 1: N | AUKO |
| AUPO | AKTNR | : | WAKH |
| AUPO | APSTP | : | T621 |
| AUPO | ASTRA | : | T627 |
| AUPO | AUFME | 1: N | T006 |
| AUPO | BSART | 1: CN | T161 |
| AUPO | BSART_GL_BUKRS | : | T161 |
| AUPO | BWART | : | T149D |
| AUPO | EBELN | 1: CN | EKKO |
| AUPO | EBELP | 1: CN | EKPO |
| AUPO | FIKLI | : | KLAH |
| AUPO | KAART | : | TVAK |
| AUPO | LFART | 1: CN | TVLK |
| AUPO | LGORT | 1: CN | T001L |
| AUPO | LIFNR | C: CN | LFA1 |
| AUPO | MANDT | 1: N | T000 |
| AUPO | MATKL | 1: CN | T023 |
| AUPO | MATNR | 1: N | MARA |
| AUPO | MEINS | 1: N | T006 |
| AUPO | NREMFIN | : | EMFIN |
| AUPO | RFKTN | 1: N | EKKO |
| AUPO | RFKTP | 1: N | EKPO |
| AUPO | SPERR | 1: CN | T629 |
| AUPO | UMART | 1: CN | T161 |
| AUPO | VBELN | : | LIKP |
| AUPO | VBELP | : | LIPS |
| AUPO | VZENT | 1: CN | KNA1 |
| AUPO | VZLFR | 1: CN | LFA1 |
| AUPO | VZWRK | 1: CN | T001W |