SAP Table

AUPO Allocation Table Document Item

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

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

/ Fields

AUPO columns.

Field Description Data Type Length Decimals Checktable Data Element
KeyMANDT Client CLNT 3 0 T000 MANDT
KeyABELN Allocation Table CHAR 10 0 AUKO ABELN
KeyABELP 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
MANUE Flag: allocation table manually changed CHAR 1 0 MANUE
RUNDG Rounding off in allocation table CHAR 1 0 RUNDG
RESTV Split remainder CHAR 1 0 RESTV
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
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
SVFIX Plants fixed in AR CHAR 1 0 SVFIX
SIMAM Alloc tbl qty simulation CHAR 1 0 SIMAM
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
RETPO Returns Item CHAR 1 0 RETPO
BERMIMA Include Minimum and Maximum Quantities CHAR 1 0 BERMIMA
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
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
/ Relationships

AUPO foreign keys.

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