1. Home
  2. Resources
  3. SAP Tables
  4. AUPO - Allocation Table Document Item

SAP Table AUPO

Allocation Table Document Item

AUPO (Allocation Table Document Item) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.

Additionally we provide an overview of foreign key relationships, if any, that link AUPO to other SAP tables.

AUPO table fields

Field Data element Checktable Datatype Length Decimals
MANDT Client MANDT T000 CLNT 3 0
ABELN Allocation Table Number ABELN AUKO CHAR 10 0
ABELP Item number of allocation table ABELP NUMC 5 0
APSTP Item category of allocation table APSTP T621 CHAR 4 0
ASTAP Activity status of allocation table item ASTAP CHAR 1 0
1 Not active
2 Partially active
3 Active
4 Done
PSTAP Maintenance status of alloc. table item PSTAP CHAR 1 0
1 New
2 Released
3 In Process
4 Incomplete
SPERR Blocking flag: item SPPOS T629 CHAR 1 0
ERDAT Date on Which Record Was Created ERDAT DATS 8 0
AEDAT Changed On AEDAT DATS 8 0
ERNAM Name of Person who Created the Object ERNAM CHAR 12 0
AENAM Name of Person Who Changed Object AENAM CHAR 12 0
RFKTN Reference outline agreement RFKTN EKKO CHAR 10 0
RFKTP Reference outline agreement item RFKTP EKPO NUMC 5 0
RSNUM Number of Reservation/Dependent Requirement RSNUM NUMC 10 0
RSPOS Item Number of Reservation/Dependent Requirement RSPOS NUMC 4 0
EBELN Purchasing Document Number EBELN EKKO CHAR 10 0
EBELP Item Number of Purchasing Document EBELP EKPO NUMC 5 0
AKTNR Promotion WAKTION WAKH CHAR 10 0
AKTPO Sub-item for units of measure W_MEPOS NUMC 2 0
MATNR Material Number MATNR MARA CHAR 18 0
MAKTX Material Description (Short Text) MAKTX CHAR 40 0
BWART Valuation Type BWTAR_D T149D CHAR 10 0
VZWRK Distribution center as plant VZWRK T001W CHAR 4 0
LIFNR Vendor Account Number ELIFN LFA1 CHAR 10 0
SBELN No. of allocation rule SBELN CHAR 10 0
FIKLI Internal class number, plant FCLIN KLAH NUMC 10 0
FILKL Plant group (technical plant class) FILKL CHAR 18 0
PMNGE Planned Quantity of Item PMNGE QUAN 13 3
IMNGE Confirmed qty of item IMNGE QUAN 13 3
MMNGE Minimum Quantity Per Plant MMNGE QUAN 13 3
AUFME Allocation Unit AUFME T006 UNIT 3 0
MEINS Base Unit of Measure MEINS T006 UNIT 3 0
UZAEH Numerator for conversion to base units of measure UZAEH DEC 5 0
UNENN Denominator for conversion to base units of measure UNENN DEC 5 0
LISTG Listing Indicator LISTG CHAR 1 0
NULL 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 MANUE CHAR 1 0
RUNDG Rounding off in allocation table RUNDG CHAR 1 0
A Round up
B Round down
C Round off
D Quantity optimizing (round off as per rounding profile)
RESTV Split remainder RESTV CHAR 1 0
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 ASTRA T627 CHAR 4 0
LIEFW Flag: delivery phase exists LIEFW CHAR 1 0
VKSDT Date of start of sales at plant VKIDT DATS 8 0
VKSTP Date type (day, week, month, interval) PRGRS CHAR 1 0
1 Day
2 Week
3 Month
4 Posting period
5 Planning calendar period
AAVIT Notification Category Allocation: Info Exchance HQ - Plant AAVIT T626 CHAR 4 0
MATKL Material Group MATKL T023 CHAR 9 0
VZENT Distribution center (as customer) VZENT KNA1 CHAR 10 0
VZLFR Vendor number of plant LIFNR_WK LFA1 CHAR 10 0
BSART Order type in allocation table (for external vendor) BSART_LIEF T161 CHAR 4 0
UMART Order type in allocation table (for warehouse/DC) BSART_LAGER T161 CHAR 4 0
BSART_GL_BUKRS Replacement order type in alloc tbl in same company code BSART_GL_BUKRS T161 CHAR 4 0
LFART Delivery type of allocation table LFART_AUFT TVLK CHAR 4 0
ABFDT Confirmation request date AFIDT DATS 8 0
ABFTP Date type (day, week, month, interval) PRGRS CHAR 1 0
1 Day
2 Week
3 Month
4 Posting period
5 Planning calendar period
SVFIX Plants fixed in AR SVFIX CHAR 1 0
SIMAM Alloc tbl qty simulation SIMAM CHAR 1 0
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 LGORT_D T001L CHAR 4 0
HMNGE Maximum Quantity Per Plant HMNGE QUAN 13 3
KETYP Key Figure Category KETYP CHAR 1 0
VBELN Delivery VBELN_VL LIKP CHAR 10 0
VBELP Delivery Item POSNR_VL LIPS NUMC 6 0
SAPOS Number of alloc tbl item of material on higher level POSNR_SA NUMC 5 0
ATTYP Material Category ATTYP CHAR 2 0
NULL Single material (industry)
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 RETPO CHAR 1 0
X Yes
NULL No
BERMIMA Include Minimum and Maximum Quantities BERMIMA CHAR 1 0
NULL 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 AUART TVAK CHAR 4 0
NREMFIN Number of Recipient Determination NREMFIN EMFIN CHAR 4 0
EXT_REF_ID External Reference Number RDM_EXT_REF_ID CHAR 25 0
ASTRA_VAR Allocation Strategy Variant ASTRA_VAR CHAR 14 0
ERVON Application creating allocation table ERVON CHAR 1 0
NULL 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
Z Allocation table was generated from individual program
F Allocation Table Generated from Demand Management System
WRF_HIER_CNT Hierarchy WRF_HIER_CNT CHAR 2 0
WRF_CDT_LEVEL Hierarchy Level WRF_CDT_LEVEL NUMC 2 0
WRF_STRUC_NODE Hierarchy Node WRF_STRUC_NODE CHAR 18 0
PLID Purchasing List Number WRF_PLID CHAR 10 0
CONS_MODE Consignment Processing in Allocation Table WRF_AT_CONS_MODE CHAR 1 0
NULL 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 Foreign key table Foreign key field Check table Check field
AUPO AAVIT AUPO MANDT T626 Allocation Table Notification Categories MANDT
AUPO AAVIT AUPO AAVIT T626 Allocation Table Notification Categories AAVIT
AUPO ABELN AUPO MANDT AUKO Allocation Table Document Header MANDT
AUPO ABELN AUPO ABELN AUKO Allocation Table Document Header ABELN
AUPO AKTNR AUPO MANDT WAKH Promotion Header Data, IS-R MANDT
AUPO AKTNR AUPO AKTNR WAKH Promotion Header Data, IS-R AKTNR
AUPO APSTP AUPO MANDT T621 Item Categories for Allocation Tables MANDT
AUPO APSTP AUPO APSTP T621 Item Categories for Allocation Tables APSTP
AUPO ASTRA AUPO MANDT T627 Allocation Strategy: Allocation Table MANDT
AUPO ASTRA AUPO ASTRA T627 Allocation Strategy: Allocation Table ASTRA
AUPO AUFME AUPO MANDT T006 Units of Measurement MANDT
AUPO AUFME AUPO AUFME T006 Units of Measurement MSEHI
AUPO BSART AUPO MANDT T161 Purchasing Document Types MANDT
AUPO BSART 'F' T161 Purchasing Document Types BSTYP
AUPO BSART AUPO BSART T161 Purchasing Document Types BSART
AUPO BSART_GL_BUKRS AUPO MANDT T161 Purchasing Document Types MANDT
AUPO BSART_GL_BUKRS 'F' T161 Purchasing Document Types BSTYP
AUPO BSART_GL_BUKRS AUPO BSART_GL_BUKRS T161 Purchasing Document Types BSART
AUPO BWART AUPO MANDT T149D Global Valuation Types MANDT
AUPO BWART AUPO BWART T149D Global Valuation Types BWTAR
AUPO EBELN AUPO EBELN EKKO Purchasing Document Header EBELN
AUPO EBELN AUPO MANDT EKKO Purchasing Document Header MANDT
AUPO EBELP AUPO EBELP EKPO Purchasing Document Item EBELP
AUPO EBELP AUPO MANDT EKPO Purchasing Document Item MANDT
AUPO EBELP AUPO EBELN EKPO Purchasing Document Item EBELN
AUPO FIKLI AUPO MANDT KLAH Class Header Data MANDT
AUPO FIKLI AUPO FIKLI KLAH Class Header Data CLINT
AUPO KAART AUPO MANDT TVAK Sales Document Types MANDT
AUPO KAART AUPO KAART TVAK Sales Document Types AUART
AUPO LFART AUPO MANDT TVLK Delivery Types MANDT
AUPO LFART AUPO LFART TVLK Delivery Types LFART
AUPO LGORT AUPO MANDT T001L Storage Locations MANDT
AUPO LGORT AUPO VZWRK T001L Storage Locations WERKS
AUPO LGORT AUPO LGORT T001L Storage Locations LGORT
AUPO LIFNR AUPO LIFNR LFA1 Vendor Master (General Section) LIFNR
AUPO LIFNR AUPO MANDT LFA1 Vendor Master (General Section) MANDT
AUPO MANDT AUPO MANDT T000 Clients MANDT
AUPO MATKL AUPO MATKL T023 Material Groups MATKL
AUPO MATKL AUPO MANDT T023 Material Groups MANDT
AUPO MATNR AUPO MANDT MARA General Material Data MANDT
AUPO MATNR AUPO MATNR MARA General Material Data MATNR
AUPO MEINS AUPO MANDT T006 Units of Measurement MANDT
AUPO MEINS AUPO MEINS T006 Units of Measurement MSEHI
AUPO NREMFIN AUPO MANDT EMFIN Recipient determin. MANDT
AUPO NREMFIN AUPO NREMFIN EMFIN Recipient determin. NREMFIN
AUPO RFKTN AUPO MANDT EKKO Purchasing Document Header MANDT
AUPO RFKTN AUPO RFKTN EKKO Purchasing Document Header EBELN
AUPO RFKTP AUPO MANDT EKPO Purchasing Document Item MANDT
AUPO RFKTP AUPO RFKTN EKPO Purchasing Document Item EBELN
AUPO RFKTP AUPO RFKTP EKPO Purchasing Document Item EBELP
AUPO SPERR AUPO MANDT T629 Allocation Table Rejection Reasons MANDT
AUPO SPERR AUPO SPERR T629 Allocation Table Rejection Reasons SPERR
AUPO UMART AUPO UMART T161 Purchasing Document Types BSART
AUPO UMART AUPO MANDT T161 Purchasing Document Types MANDT
AUPO UMART 'F' T161 Purchasing Document Types BSTYP
AUPO VBELN AUPO MANDT LIKP SD Document: Delivery Header Data MANDT
AUPO VBELN AUPO VBELN LIKP SD Document: Delivery Header Data VBELN
AUPO VBELP AUPO MANDT LIPS SD document: Delivery: Item data MANDT
AUPO VBELP AUPO VBELN LIPS SD document: Delivery: Item data VBELN
AUPO VBELP AUPO VBELP LIPS SD document: Delivery: Item data POSNR
AUPO VZENT AUPO MANDT KNA1 General Data in Customer Master MANDT
AUPO VZENT AUPO VZENT KNA1 General Data in Customer Master KUNNR
AUPO VZLFR AUPO MANDT LFA1 Vendor Master (General Section) MANDT
AUPO VZLFR AUPO VZLFR LFA1 Vendor Master (General Section) LIFNR
AUPO VZWRK AUPO MANDT T001W Plants/Branches MANDT
AUPO VZWRK AUPO VZWRK T001W Plants/Branches WERKS