AUPO SAP (Allocation Table Document Item) Table details
Dictionary Type: Table
Description: Allocation Table Document Item
Description: Allocation Table Document Item
Table field list including key, data, relationships and ABAP select examples
AUPO is a standard SAP Table which is used to store Allocation Table Document Item data and is available within R/3 SAP systems depending on the version and release level.
The AUPO table consists of various fields, each holding specific information or linking keys about Allocation Table Document Item data available in SAP. These include ABELN (Allocation Table Number), ABELP (Item number of allocation table), APSTP (Item category of allocation table), ASTAP (Activity status of allocation table item).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .
Delivery Class: A - Application table (master and transaction data)Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)
SAP AUPO table fields - Full list of fields found in SAP data dictionary
Field | Description | Data Element | Data Type | length (Dec) | Check table | Conversion Routine | Domain Name | MemoryID | SHLP |
MANDT | Client | MANDT | CLNT | 3 | T000 | MANDT | |||
ABELN | Allocation Table Number | ABELN | CHAR | 10 | AUKO | ALPHA | ABELN | ABE | |
ABELP | Item number of allocation table | ABELP | NUMC | 5 | ABELP | ||||
APSTP | Item category of allocation table | APSTP | CHAR | 4 | T621 | APSTP | |||
ASTAP | Activity status of allocation table item | ASTAP | CHAR | 1 | ASTAK | ||||
PSTAP | Maintenance status of alloc. table item | PSTAP | CHAR | 1 | PSTAK | ||||
SPERR | Blocking flag: item | SPPOS | CHAR | 1 | T629 | SPERR_A | |||
ERDAT | Date on Which Record Was Created | ERDAT | DATS | 8 | DATUM | ||||
AEDAT | Changed On | AEDAT | DATS | 8 | DATUM | ||||
ERNAM | Name of Person who Created the Object | ERNAM | CHAR | 12 | USNAM | ||||
AENAM | Name of Person Who Changed Object | AENAM | CHAR | 12 | USNAM | ||||
RFKTN | Reference outline agreement | RFKTN | CHAR | 10 | EKKO | ALPHA | EBELN | ||
RFKTP | Reference outline agreement item | RFKTP | NUMC | 5 | EKPO | EBELP | |||
RSNUM | Number of Reservation/Dependent Requirement | RSNUM | NUMC | 10 | Assigned to domain | RSNUM | RES | ||
RSPOS | Item Number of Reservation/Dependent Requirement | RSPOS | NUMC | 4 | RSPOS | RPO | |||
EBELN | Purchasing Document Number | EBELN | CHAR | 10 | EKKO | ALPHA | EBELN | BES | MEKK_C |
EBELP | Item Number of Purchasing Document | EBELP | NUMC | 5 | EKPO | EBELP | BSP | ||
AKTNR | COUPON | WAKTION | CHAR | 10 | WAKH | ALPHA | WAKTION | WAK | |
AKTPO | Sub-item for units of measure | W_MEPOS | NUMC | 2 | NUMC2 | ||||
MATNR | Material Number | MATNR | CHAR | 18 | MARA | MATN1 | MATNR | MAT | S_MAT1 |
MAKTX | Material Description (Short Text) | MAKTX | CHAR | 40 | TEXT40 | ||||
BWART | Valuation Type | BWTAR_D | CHAR | 10 | T149D | BWTAR | BWT | ||
VZWRK | Distribution center as plant | VZWRK | CHAR | 4 | T001W | WERKS | VZW | ||
LIFNR | Vendor Account Number | ELIFN | CHAR | 10 | LFA1 | ALPHA | LIFNR | LIF | KRED_C |
SBELN | No. of allocation rule | SBELN | CHAR | 10 | Assigned to domain | ALPHA | SBELN | BLN | |
FIKLI | Internal class number, plant | FCLIN | NUMC | 10 | KLAH | CLINT | |||
FILKL | Plant group (technical plant class) | FILKL | CHAR | 18 | KLASSE | ||||
PMNGE | Planned Quantity of Item | PMNGE | QUAN | 13(3) | MENG13 | ||||
IMNGE | Confirmed qty of item | IMNGE | QUAN | 13(3) | MENG13 | ||||
MMNGE | Minimum Quantity Per Plant | MMNGE | QUAN | 13(3) | MENG13 | ||||
AUFME | Allocation Unit | AUFME | UNIT | 3 | T006 | CUNIT | MEINS | ||
MEINS | Base Unit of Measure | MEINS | UNIT | 3 | T006 | CUNIT | MEINS | ||
UZAEH | Numerator for conversion to base units of measure | UZAEH | DEC | 5 | UMBSZ | ||||
UNENN | Denominator for conversion to base units of measure | UNENN | DEC | 5 | UMBSN | ||||
LISTG | Listing Indicator | LISTG | CHAR | 1 | LISTG | ||||
MANUE | Flag: allocation table manually changed | MANUE | CHAR | 1 | CHAR1 | ||||
RUNDG | Rounding off in allocation table | RUNDG | CHAR | 1 | RUNDG | ||||
RESTV | Split remainder | RESTV | CHAR | 1 | RESTV | ||||
ASTRA | Allocation Strategy | ASTRA | CHAR | 4 | T627 | ASTRA | |||
LIEFW | Flag: delivery phase exists | LIEFW | CHAR | 1 | CHAR1 | ||||
VKSDT | Date of start of sales at plant | VKIDT | DATS | 8 | DATUM | ||||
VKSTP | Date type (day, week, month, interval) | PRGRS | CHAR | 1 | PRGRS | ||||
AAVIT | Notification Category Allocation: Info Exchance HQ - Plant | AAVIT | CHAR | 4 | T626 | AAVIT | |||
MATKL | Material Group | MATKL | CHAR | 9 | T023 | MATKL | MKL | S_WBWG | |
VZENT | Distribution center (as customer) | VZENT | CHAR | 10 | KNA1 | ALPHA | KUNNR | ||
VZLFR | Vendor number of plant | LIFNR_WK | CHAR | 10 | LFA1 | ALPHA | LIFNR | ||
BSART | Order type in allocation table (for external vendor) | BSART_LIEF | CHAR | 4 | T161 | BSART | BSA | WAUF_T161 | |
UMART | Order type in allocation table (for warehouse/DC) | BSART_LAGER | CHAR | 4 | T161 | BSART | BSA | WAUF_T161 | |
BSART_GL_BUKRS | Replacement order type in alloc tbl in same company code | BSART_GL_BUKRS | CHAR | 4 | T161 | BSART | BSA | WAUF_T161 | |
LFART | Delivery type of allocation table | LFART_AUFT | CHAR | 4 | TVLK | LFART | ALT | LFART_FOR_ALLOCATION | |
ABFDT | Confirmation request date | AFIDT | DATS | 8 | DATUM | ||||
ABFTP | Date type (day, week, month, interval) | PRGRS | CHAR | 1 | PRGRS | ||||
SVFIX | Plants fixed in AR | SVFIX | CHAR | 1 | SVFIX | ||||
SIMAM | Alloc tbl qty simulation | SIMAM | CHAR | 1 | SIMAM | ||||
LGORT | Storage Location | LGORT_D | CHAR | 4 | T001L | LGORT | LAG | ||
HMNGE | Maximum Quantity Per Plant | HMNGE | QUAN | 13(3) | MENG13 | ||||
KETYP | Key Figure Category | KETYP | CHAR | 1 | Assigned to domain | KETYP | |||
VBELN | Delivery | VBELN_VL | CHAR | 10 | LIKP | ALPHA | VBELN | VL | |
VBELP | Delivery Item | POSNR_VL | NUMC | 6 | LIPS | POSNR | |||
SAPOS | Number of alloc tbl item of material on higher level | POSNR_SA | NUMC | 5 | Assigned to domain | ABELP | |||
ATTYP | Material Category | ATTYP | CHAR | 2 | ATTYP | MTY | |||
RETPO | Returns Item | RETPO | CHAR | 1 | XFELD | ||||
BERMIMA | Include Minimum and Maximum Quantities | BERMIMA | CHAR | 1 | BERMIMA | ||||
KAART | Sales Document Type | AUART | CHAR | 4 | TVAK | AUART | AUART | AAT | |
NREMFIN | Number of Recipient Determination | NREMFIN | CHAR | 4 | EMFIN | NREMFIN | |||
.INCLU--AP | 0 | ||||||||
EXT_REF_ID | External Reference Number | RDM_EXT_REF_ID | CHAR | 25 | RDM_EXT_REF_ID | ||||
.INCLU--AP | 0 | ||||||||
ASTRA_VAR | Allocation Strategy Variant | ASTRA_VAR | CHAR | 14 | Assigned to domain | VARIANT | |||
ERVON | Application creating allocation table | ERVON | CHAR | 1 | ERVON | ||||
.INCLU--AP | 0 | ||||||||
WRF_HIER_CNT | Hierarchy | WRF_HIER_CNT | CHAR | 2 | WRF_HIERCNT | RTHIER | WRF_HIERID_STATUS | ||
WRF_CDT_LEVEL | Hierarchy Level | WRF_CDT_LEVEL | NUMC | 2 | NUMC2 | RTLEVEL | WRF_TREE_LEVEL | ||
WRF_STRUC_NODE | Hierarchy Node | WRF_STRUC_NODE | CHAR | 18 | WRF_NODES | RTNODE | WRF_MATGRP_CSHLP | ||
PLID | Purchasing List Number | WRF_PLID | CHAR | 10 | Assigned to domain | PLID1 | WRF_PLID | PLID | |
CONS_MODE | Consignment Processing in Allocation Table | WRF_AT_CONS_MODE | CHAR | 1 | WRF_AT_CONS_MODE |
Key field | Non-key field |
How do I retrieve data from SAP table AUPO using ABAP code
The following ABAP code Example will allow you to do a basic selection on AUPO to SELECT all data from the tableDATA: WA_AUPO TYPE AUPO.
SELECT SINGLE *
FROM AUPO
INTO CORRESPONDING FIELDS OF WA_AUPO
WHERE...
How to access SAP table AUPO
Within an ECC or HANA version of SAP you can also view further information about AUPO and the data within it using relevant transactions such asSE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).
Search for further information about these or an SAP related objects