SAP table AUPO (Allocation Table Document Item)

SAP table AUPO has 3 primary key fields being MANDT,ABELN,ABELP.

If you're only analyzing data from a single SAP instance you may omit field MANT in your relationships as it will we the same across the entire dataset. On the other hand, if you're combining data from multiple SAP instances you need to take MANDT into account.

Field Description Data Type Length Decimals Checktable Data Element
MANDT Client CLNT 3 0 T000 MANDT
ABELN Allocation Table CHAR 10 0 AUKO ABELN
ABELP Allocation Table Item NUMC 5 0 ABELP
APSTP Item category of allocation table CHAR 4 0 T621 APSTP
ASTAP Activity status of allocation table item CHAR 1 0 ASTAP
PSTAP Maintenance status of alloc. table item CHAR 1 0 PSTAP
SPERR Blocking flag: item CHAR 1 0 T629 SPPOS
ERDAT Date on which the record was created DATS 8 0 ERDAT
AEDAT Last Changed On DATS 8 0 AEDAT
ERNAM Name of Person Responsible for Creating the Object CHAR 12 0 ERNAM
AENAM Name of Person Who Changed Object CHAR 12 0 AENAM
RFKTN Reference outline agreement CHAR 10 0 EKKO RFKTN
RFKTP Reference outline agreement item NUMC 5 0 EKPO RFKTP
RSNUM Number of reservation/dependent requirements NUMC 10 0 * RSNUM
RSPOS Item Number of Reservation / Dependent Requirements NUMC 4 0 RSPOS
EBELN Purchasing Document Number CHAR 10 0 EKKO EBELN
EBELP Item Number of Purchasing Document NUMC 5 0 EKPO EBELP
AKTNR Promotion CHAR 10 0 WAKH WAKTION
AKTPO Sub-item for units of measure NUMC 2 0 W_MEPOS
MATNR Material Number CHAR 40 0 MARA MATNR
MAKTX Material Description CHAR 40 0 MAKTX
BWART Valuation Type CHAR 10 0 T149D BWTAR_D
VZWRK Distribution Center CHAR 4 0 T001W VZWRK
LIFNR Vendor's account number CHAR 10 0 LFA1 ELIFN
SBELN No. of allocation rule CHAR 10 0 * SBELN
FIKLI Internal class number, plant NUMC 10 0 KLAH FCLIN
FILKL Plant group (technical plant class) CHAR 18 0 FILKL
PMNGE Planned Quantity of Item QUAN 13 3 PMNGE
IMNGE Confirmed Quantity of Item QUAN 13 3 IMNGE
MMNGE Minimum Quantity Per Plant QUAN 13 3 MMNGE
AUFME Allocation Unit UNIT 3 0 T006 AUFME
MEINS Base Unit of Measure UNIT 3 0 T006 MEINS
UZAEH Numerator for conversion to base units of measure DEC 5 0 UZAEH
UNENN Denominator for conversion to base units of measure DEC 5 0 UNENN
LISTG Listing Indicator CHAR 1 0 LISTG
No listing check
A Listing check
B Listing check and subseq. listing if nec.
C Adopt only listed plants
MANUE Flag: allocation table manually changed CHAR 1 0 MANUE
RUNDG Rounding off in allocation table CHAR 1 0 RUNDG
A Round up
B Round down
C Round off
D Quantity optimizing (round off as per rounding profile)
RESTV Split remainder CHAR 1 0 RESTV
A Accept remainder - adjust total quantity
B Remainder to plant with largest quantity
C Remainder to plant with smallest quantity
D Remainder to plants with largest quantities
E Remainder to plants with smallest quantities
ASTRA Allocation Strategy CHAR 4 0 T627 ASTRA
LIEFW Flag: delivery phase exists CHAR 1 0 LIEFW
VKSDT Date of start of sales at plant DATS 8 0 VKIDT
VKSTP Date type (day, week, month, interval) CHAR 1 0 PRGRS
1 Day
2 Week
3 Month
4 Posting period
5 Planning calendar period
AAVIT Notification Category Allocation: Info Exchance HQ - Plant CHAR 4 0 T626 AAVIT
MATKL Material Group CHAR 9 0 T023 MATKL
VZENT Distribution center (as customer) CHAR 10 0 KNA1 VZENT
VZLFR Supplier Number of Plant CHAR 10 0 LFA1 LIFNR_WK
BSART Order Type in Allocation Table (for External Supplier) CHAR 4 0 T161 BSART_LIEF
UMART Order type in allocation table (for warehouse/DC) CHAR 4 0 T161 BSART_LAGER
BSART_GL_BUKRS Replacement order type in alloc tbl in same company code CHAR 4 0 T161 BSART_GL_BUKRS
LFART Delivery type of allocation table CHAR 4 0 TVLK LFART_AUFT
ABFDT Confirmation request date DATS 8 0 AFIDT
ABFTP Date type (day, week, month, interval) CHAR 1 0 PRGRS
1 Day
2 Week
3 Month
4 Posting period
5 Planning calendar period
SVFIX Plants fixed in AR CHAR 1 0 SVFIX
SIMAM Alloc tbl qty simulation CHAR 1 0 SIMAM
1 Item qty with plant shares
2 Item qty with plant group shares
3 Item qty proportional to previous plant quantities
4 Plant group qty proportional to previous plant quantities
5 Manual entry of plant quantities
LGORT Storage location CHAR 4 0 T001L LGORT_D
HMNGE Maximum Quantity Per Plant QUAN 13 3 HMNGE
KETYP Key Figure Category CHAR 1 0 * KETYP
VBELN Delivery CHAR 10 0 LIKP VBELN_VL
VBELP Delivery Item NUMC 6 0 LIPS POSNR_VL
SAPOS Allocation table item of material on higher level NUMC 5 0 * POSNR_SA
ATTYP Material Category CHAR 2 0 ATTYP
Product
00 Single material
01 Generic material
02 Variant
10 Sales set
11 Prepack
12 Display
20 Material group material
21 Hierarchy material
22 Group material
30 Material group reference material
RETPO Returns Item CHAR 1 0 RETPO
BERMIMA Include Minimum and Maximum Quantities CHAR 1 0 BERMIMA
No automatic conversion, warning issued
A No automatic conversion, error message issued
B Automatic conversion when plant quantities calculated
C Automatic conversion even if quantities entered manually
KAART Sales Document Type CHAR 4 0 TVAK AUART
NREMFIN Number of Recipient Determination CHAR 4 0 EMFIN NREMFIN
EXT_REF_ID External Reference Number CHAR 25 0 RDM_EXT_REF_ID
ASTRA_VAR Allocation Strategy Variant CHAR 14 0 * ASTRA_VAR
ERVON Application creating allocation table CHAR 1 0 ERVON
Allocation table was created online
A Allocation table was generated in a promotion
B Allocation table was generated in perishables planning
C Allocation table was generated in MAP
D Alloc. Table was Generated From Prepack Planning Tool
E Alloc.Tble Generated from Oper.Assortmt Planning and Control
F Allocation Table Generated from Demand Management System
G Allocation Table was Generated from CAR
Z Allocation table was generated from individual program
WRF_HIER_CNT Hierarchy CHAR 2 0 WRF_HIER_CNT
WRF_CDT_LEVEL Hierarchy Level NUMC 2 0 WRF_CDT_LEVEL
WRF_STRUC_NODE Hierarchy Node CHAR 18 0 WRF_STRUC_NODE
PLID Purchasing List Number CHAR 10 0 * WRF_PLID
CONS_MODE Consignment Processing in Allocation Table CHAR 1 0 WRF_AT_CONS_MODE
DC: Own Goods/Store: Own Goods
1 DC: Value of Master Data/Store: Value of Master Data
2 DC: Value of Master Data/Store: Own Goods
3 DC: Consignment Goods/Store: Value from Master Data
4 DC: Consignment Goods/Store: Consignment Goods
5 DC. Consignment Goods/Store: Own Goods

AUPO foreign key relationships

Table Field Check Table Check Field
0 AUPO AAVIT T626 Allocation Table Notification Categories MANDT
0 AUPO AAVIT T626 Allocation Table Notification Categories AAVIT
1 AUPO ABELN AUKO Allocation Table Document Header ABELN
0 AUPO AKTNR WAKH Promotion Header Data, IS-R MANDT
0 AUPO AKTNR WAKH Promotion Header Data, IS-R AKTNR
1 AUPO AUFME T006 Units of Measurement MANDT
1 AUPO AUFME T006 Units of Measurement MSEHI
0 AUPO BSART T161 Purchasing Document Types MANDT
1 AUPO BSART_GL_BUKRS T161 Purchasing Document Types MANDT
0 AUPO BWART T149D Global Valuation Types MANDT
0 AUPO BWART T149D Global Valuation Types BWTAR
1 AUPO EBELN EKKO Purchasing Document Header EBELN
0 AUPO EBELP EKPO Purchasing Document Item MANDT
0 AUPO EBELP EKPO Purchasing Document Item EBELN
1 AUPO FIKLI KLAH Class Header Data MANDT
1 AUPO FIKLI KLAH Class Header Data CLINT
0 AUPO KAART TVAK Sales Document Types MANDT
0 AUPO KAART TVAK Sales Document Types AUART
1 AUPO LFART TVLK Delivery Types MANDT
1 AUPO LFART TVLK Delivery Types LFART
0 AUPO LGORT T001L Storage Locations MANDT
0 AUPO LGORT T001L Storage Locations WERKS
1 AUPO LIFNR LFA1 Supplier Master (General Section) MANDT
1 AUPO LIFNR LFA1 Supplier Master (General Section) LIFNR
0 AUPO MANDT T000 Clients MANDT
1 AUPO MATKL T023 Material Groups MATKL
0 AUPO MATNR MARA General Material Data MANDT
0 AUPO MATNR MARA General Material Data MATNR
1 AUPO MEINS T006 Units of Measurement MANDT
1 AUPO MEINS T006 Units of Measurement MSEHI
0 AUPO NREMFIN EMFIN Recipient determin. MANDT
0 AUPO NREMFIN EMFIN Recipient determin. NREMFIN
1 AUPO RFKTN EKKO Purchasing Document Header MANDT
1 AUPO RFKTN EKKO Purchasing Document Header EBELN
0 AUPO RFKTP EKPO Purchasing Document Item MANDT
0 AUPO RFKTP EKPO Purchasing Document Item EBELN
1 AUPO SPERR T629 Allocation Table Rejection Reasons MANDT
1 AUPO SPERR T629 Allocation Table Rejection Reasons SPERR
0 AUPO UMART T161 Purchasing Document Types MANDT
1 AUPO VBELN LIKP SD Document: Delivery Header Data MANDT
1 AUPO VBELN LIKP SD Document: Delivery Header Data VBELN
0 AUPO VBELP LIPS SD document: Delivery: Item data MANDT
0 AUPO VBELP LIPS SD document: Delivery: Item data VBELN
0 AUPO VBELP LIPS SD document: Delivery: Item data POSNR
1 AUPO VZENT KNA1 General Data in Customer Master MANDT
1 AUPO VZENT KNA1 General Data in Customer Master KUNNR
0 AUPO VZLFR LFA1 Supplier Master (General Section) MANDT
0 AUPO VZLFR LFA1 Supplier Master (General Section) LIFNR
1 AUPO VZWRK T001W Plants/Branches MANDT
1 AUPO VZWRK T001W Plants/Branches WERKS