AUPO is a standard SAP table in SAP ERP (or) S/4HANA which stores Allocation Table Document Item data. There are total 73 fields in AUPO table.This blog post provides key technical details of SAP table AUPO, including its availability across SAP S/4HANA versions and the list of CDS views for AUPO 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 AUPO Table Fields
The following is the list of fields that are available in SAP AUPO 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 | NUMC (5) | |
APSTP | Item category of allocation table | APSTP | APSTP | T621 | CHAR (4) |
ASTAP | Activity status of allocation table item | ASTAP | ASTAK | CHAR (1) | |
PSTAP | Maintenance status of alloc. table item | PSTAP | PSTAK | CHAR (1) | |
SPERR | Blocking flag: item | SPPOS | SPERR_A | T629 | CHAR (1) |
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) | |
RFKTN | Reference outline agreement | RFKTN | EBELN | EKKO | CHAR (10) |
RFKTP | Reference outline agreement item | RFKTP | EBELP | EKPO | NUMC (5) |
RSNUM | Number of reservation/dependent requirements | RSNUM | RSNUM | * | NUMC (10) |
RSPOS | Item Number of Reservation / Dependent Requirements | RSPOS | RSPOS | NUMC (4) | |
EBELN | Purchasing Document Number | EBELN | EBELN | EKKO | CHAR (10) |
EBELP | Item Number of Purchasing Document | EBELP | EBELP | EKPO | NUMC (5) |
AKTNR | Promotion | WAKTION | WAKTION | WAKH | CHAR (10) |
AKTPO | Sub-item for units of measure | W_MEPOS | NUMC2 | NUMC (2) | |
MATNR | Material Number | MATNR | MATNR | MARA | CHAR (40) |
MAKTX | Material Description | MAKTX | TEXT40 | CHAR (40) | |
BWART | Valuation Type | BWTAR_D | BWTAR | T149D | CHAR (10) |
VZWRK | Distribution Center | VZWRK | WERKS | T001W | CHAR (4) |
LIFNR | Vendor’s account number | ELIFN | LIFNR | LFA1 | CHAR (10) |
SBELN | No. of allocation rule | SBELN | SBELN | * | CHAR (10) |
FIKLI | Internal class number, plant | FCLIN | CLINT | KLAH | NUMC (10) |
FILKL | Plant group (technical plant class) | FILKL | KLASSE | CHAR (18) | |
PMNGE | Planned Quantity of Item | PMNGE | MENG13 | QUAN (13) | |
IMNGE | Confirmed Quantity of Item | IMNGE | MENG13 | QUAN (13) | |
MMNGE | Minimum Quantity Per Plant | MMNGE | MENG13 | QUAN (13) | |
AUFME | Allocation Unit | AUFME | MEINS | T006 | UNIT (3) |
MEINS | Base Unit of Measure | MEINS | MEINS | T006 | UNIT (3) |
UZAEH | Numerator for conversion to base units of measure | UZAEH | UMBSZ | DEC (5) | |
UNENN | Denominator for conversion to base units of measure | UNENN | UMBSN | DEC (5) | |
LISTG | Listing Indicator | LISTG | LISTG | CHAR (1) | |
MANUE | Flag: allocation table manually changed | MANUE | CHAR1 | CHAR (1) | |
RUNDG | Rounding off in allocation table | RUNDG | RUNDG | CHAR (1) | |
RESTV | Split remainder | RESTV | RESTV | CHAR (1) | |
ASTRA | Allocation Strategy | ASTRA | ASTRA | T627 | CHAR (4) |
LIEFW | Flag: delivery phase exists | LIEFW | CHAR1 | CHAR (1) | |
VKSDT | Date of start of sales at plant | VKIDT | DATUM | DATS (8) | |
VKSTP | Date type (day, week, month, interval) | PRGRS | PRGRS | CHAR (1) | |
AAVIT | Notification Category Allocation: Info Exchance HQ – Plant | AAVIT | AAVIT | T626 | CHAR (4) |
MATKL | Material Group | MATKL | MATKL | T023 | CHAR (9) |
VZENT | Distribution center (as customer) | VZENT | KUNNR | KNA1 | CHAR (10) |
VZLFR | Supplier Number of Plant | LIFNR_WK | LIFNR | LFA1 | CHAR (10) |
BSART | Order Type in Allocation Table (for External Supplier) | BSART_LIEF | BSART | T161 | CHAR (4) |
UMART | Order type in allocation table (for warehouse/DC) | BSART_LAGER | BSART | T161 | CHAR (4) |
BSART_GL_BUKRS | Replacement order type in alloc tbl in same company code | BSART_GL_BUKRS | BSART | T161 | CHAR (4) |
LFART | Delivery type of allocation table | LFART_AUFT | LFART | TVLK | CHAR (4) |
ABFDT | Confirmation request date | AFIDT | DATUM | DATS (8) | |
ABFTP | Date type (day, week, month, interval) | PRGRS | PRGRS | CHAR (1) | |
SVFIX | Plants fixed in AR | SVFIX | SVFIX | CHAR (1) | |
SIMAM | Alloc tbl qty simulation | SIMAM | SIMAM | CHAR (1) | |
LGORT | Storage location | LGORT_D | LGORT | T001L | CHAR (4) |
HMNGE | Maximum Quantity Per Plant | HMNGE | MENG13 | QUAN (13) | |
KETYP | Key Figure Category | KETYP | KETYP | * | CHAR (1) |
VBELN | Delivery | VBELN_VL | VBELN | LIKP | CHAR (10) |
VBELP | Delivery Item | POSNR_VL | POSNR | LIPS | NUMC (6) |
SAPOS | Allocation table item of material on higher level | POSNR_SA | ABELP | * | NUMC (5) |
ATTYP | Material Category | ATTYP | ATTYP | CHAR (2) | |
RETPO | Returns Item | RETPO | XFELD | CHAR (1) | |
BERMIMA | Include Minimum and Maximum Quantities | BERMIMA | BERMIMA | CHAR (1) | |
KAART | Sales Document Type | AUART | AUART | TVAK | CHAR (4) |
NREMFIN | Number of Recipient Determination | NREMFIN | NREMFIN | EMFIN | CHAR (4) |
EXT_REF_ID | External Reference Number | RDM_EXT_REF_ID | RDM_EXT_REF_ID | CHAR (25) | |
ASTRA_VAR | Allocation Strategy Variant | ASTRA_VAR | VARIANT | * | CHAR (14) |
ERVON | Application creating allocation table | ERVON | ERVON | CHAR (1) | |
WRF_HIER_CNT | Hierarchy | WRF_HIER_CNT | WRF_HIERCNT | CHAR (2) | |
WRF_CDT_LEVEL | Hierarchy Level | WRF_CDT_LEVEL | NUMC2 | NUMC (2) | |
WRF_STRUC_NODE | Hierarchy Node | WRF_STRUC_NODE | WRF_NODES | CHAR (18) | |
PLID | Purchasing List Number | WRF_PLID | WRF_PLID | * | CHAR (10) |
CONS_MODE | Consignment Processing in Allocation Table | WRF_AT_CONS_MODE | WRF_AT_CONS_MODE | CHAR (1) |
Availability
The SAP table AUPO 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 AUPO table
The following is the list of AUPO CDS views, which can also be used instead of AUPO table based on your business requirements.
CDS View | CDS View Type | Description |
---|---|---|
I_ALLOCATIONTABLEITEM | BASIC | Allocation Table Item |
I_ALLOCATIONTABLEBYPRODUCT | COMPOSITE | Allocation Table by Product |
I_ALLOCATIONTABLEBYPROMOTION | COMPOSITE | Allocation Table by Promotion |
I_NROFPRODUCTSOFALLOCTBLBYSITE | COMPOSITE | Number Of Products Of Allocation Table by Site |
C_ALLOCATIONTABLEITEMOBJPG | CONSUMPTION | Allocation Table Item Object Page |
C_ALLOCATIONTABLEOBJPGITEM | CONSUMPTION | Allocation Table Object Page – Items |
C_ALLOCTABLESTOREOBJPGPRODUCT | CONSUMPTION | Allocation Table Store Object Page – Products |
C_ALLOCTBLITEMOBJPGVARIANT | CONSUMPTION | Allocation Table Item Object Page – Variants |
C_ALLOCTBLOBJPGRECEIVINGSTORE | CONSUMPTION | Allocation Table Object Page – Receiving Stores |
C_PRODUCTOBJPGALLOCATIONTABLE | CONSUMPTION | Product Object Page – Allocation Table |
C_RTLPROMNITMOBJPGALLOCTBLITM | CONSUMPTION | Retail Promotion Item Object Page – Allocation Table Item |
C_RTLPROMNOBJPGALLOCATIONTABLE | CONSUMPTION | Retail Promotion Object Page – Allocation Tables |
C_SITEOBJPGALLOCATIONTABLE | CONSUMPTION | Site Object Page – Allocation Table |