AUPO SAP (Allocation Table Document Item) Table details

Dictionary Type: Table
Description: Allocation Table Document Item




ABAP Code to SELECT data from AUPO
Related tables to AUPO
Access table AUPO




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
MANDTClient MANDTCLNT3T000MANDT
ABELNAllocation Table Number ABELNCHAR10AUKOALPHAABELNABE
ABELPItem number of allocation table ABELPNUMC5ABELP
APSTPItem category of allocation table APSTPCHAR4T621APSTP
ASTAPActivity status of allocation table item ASTAPCHAR1ASTAK
PSTAPMaintenance status of alloc. table item PSTAPCHAR1PSTAK
SPERRBlocking flag: item SPPOSCHAR1T629SPERR_A
ERDATDate on Which Record Was Created ERDATDATS8DATUM
AEDATChanged On AEDATDATS8DATUM
ERNAMName of Person who Created the Object ERNAMCHAR12USNAM
AENAMName of Person Who Changed Object AENAMCHAR12USNAM
RFKTNReference outline agreement RFKTNCHAR10EKKOALPHAEBELN
RFKTPReference outline agreement item RFKTPNUMC5EKPOEBELP
RSNUMNumber of Reservation/Dependent Requirement RSNUMNUMC10Assigned to domainRSNUMRES
RSPOSItem Number of Reservation/Dependent Requirement RSPOSNUMC4RSPOSRPO
EBELNPurchasing Document Number EBELNCHAR10EKKOALPHAEBELNBESMEKK_C
EBELPItem Number of Purchasing Document EBELPNUMC5EKPOEBELPBSP
AKTNRCOUPON WAKTIONCHAR10WAKHALPHAWAKTIONWAK
AKTPOSub-item for units of measure W_MEPOSNUMC2NUMC2
MATNRMaterial Number MATNRCHAR18MARAMATN1MATNRMATS_MAT1
MAKTXMaterial Description (Short Text) MAKTXCHAR40TEXT40
BWARTValuation Type BWTAR_DCHAR10T149DBWTARBWT
VZWRKDistribution center as plant VZWRKCHAR4T001WWERKSVZW
LIFNRVendor Account Number ELIFNCHAR10LFA1ALPHALIFNRLIFKRED_C
SBELNNo. of allocation rule SBELNCHAR10Assigned to domainALPHASBELNBLN
FIKLIInternal class number, plant FCLINNUMC10KLAHCLINT
FILKLPlant group (technical plant class) FILKLCHAR18KLASSE
PMNGEPlanned Quantity of Item PMNGEQUAN13(3) MENG13
IMNGEConfirmed qty of item IMNGEQUAN13(3) MENG13
MMNGEMinimum Quantity Per Plant MMNGEQUAN13(3) MENG13
AUFMEAllocation Unit AUFMEUNIT3T006CUNITMEINS
MEINSBase Unit of Measure MEINSUNIT3T006CUNITMEINS
UZAEHNumerator for conversion to base units of measure UZAEHDEC5UMBSZ
UNENNDenominator for conversion to base units of measure UNENNDEC5UMBSN
LISTGListing Indicator LISTGCHAR1LISTG
MANUEFlag: allocation table manually changed MANUECHAR1CHAR1
RUNDGRounding off in allocation table RUNDGCHAR1RUNDG
RESTVSplit remainder RESTVCHAR1RESTV
ASTRAAllocation Strategy ASTRACHAR4T627ASTRA
LIEFWFlag: delivery phase exists LIEFWCHAR1CHAR1
VKSDTDate of start of sales at plant VKIDTDATS8DATUM
VKSTPDate type (day, week, month, interval) PRGRSCHAR1PRGRS
AAVITNotification Category Allocation: Info Exchance HQ - Plant AAVITCHAR4T626AAVIT
MATKLMaterial Group MATKLCHAR9T023MATKLMKLS_WBWG
VZENTDistribution center (as customer) VZENTCHAR10KNA1ALPHAKUNNR
VZLFRVendor number of plant LIFNR_WKCHAR10LFA1ALPHALIFNR
BSARTOrder type in allocation table (for external vendor) BSART_LIEFCHAR4T161BSARTBSAWAUF_T161
UMARTOrder type in allocation table (for warehouse/DC) BSART_LAGERCHAR4T161BSARTBSAWAUF_T161
BSART_GL_BUKRSReplacement order type in alloc tbl in same company code BSART_GL_BUKRSCHAR4T161BSARTBSAWAUF_T161
LFARTDelivery type of allocation table LFART_AUFTCHAR4TVLKLFARTALTLFART_FOR_ALLOCATION
ABFDTConfirmation request date AFIDTDATS8DATUM
ABFTPDate type (day, week, month, interval) PRGRSCHAR1PRGRS
SVFIXPlants fixed in AR SVFIXCHAR1SVFIX
SIMAMAlloc tbl qty simulation SIMAMCHAR1SIMAM
LGORTStorage Location LGORT_DCHAR4T001LLGORTLAG
HMNGEMaximum Quantity Per Plant HMNGEQUAN13(3) MENG13
KETYPKey Figure Category KETYPCHAR1Assigned to domainKETYP
VBELNDelivery VBELN_VLCHAR10LIKPALPHAVBELNVL
VBELPDelivery Item POSNR_VLNUMC6LIPSPOSNR
SAPOSNumber of alloc tbl item of material on higher level POSNR_SANUMC5Assigned to domainABELP
ATTYPMaterial Category ATTYPCHAR2ATTYPMTY
RETPOReturns Item RETPOCHAR1XFELD
BERMIMAInclude Minimum and Maximum Quantities BERMIMACHAR1BERMIMA
KAARTSales Document Type AUARTCHAR4TVAKAUARTAUARTAAT
NREMFINNumber of Recipient Determination NREMFINCHAR4EMFINNREMFIN
.INCLU--AP 0
EXT_REF_IDExternal Reference Number RDM_EXT_REF_IDCHAR25RDM_EXT_REF_ID
.INCLU--AP 0
ASTRA_VARAllocation Strategy Variant ASTRA_VARCHAR14Assigned to domainVARIANT
ERVONApplication creating allocation table ERVONCHAR1ERVON
.INCLU--AP 0
WRF_HIER_CNTHierarchy WRF_HIER_CNTCHAR2WRF_HIERCNTRTHIERWRF_HIERID_STATUS
WRF_CDT_LEVELHierarchy Level WRF_CDT_LEVELNUMC2NUMC2RTLEVELWRF_TREE_LEVEL
WRF_STRUC_NODEHierarchy Node WRF_STRUC_NODECHAR18WRF_NODESRTNODEWRF_MATGRP_CSHLP
PLIDPurchasing List Number WRF_PLIDCHAR10Assigned to domainPLID1WRF_PLIDPLID
CONS_MODEConsignment Processing in Allocation Table WRF_AT_CONS_MODECHAR1WRF_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 table
DATA: 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 as

SE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).


Search for further information about these or an SAP related objects



Comments on this SAP object

What made you want to lookup this SAP object? Please tell us what you were looking for and anything you would like to be included on this page!