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 | Possible values | ||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
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 | ||||||||||||||||||||||||||
|
||||||||||||||||||||||||||||||
|
PSTAP
Maintenance status of alloc. table item
|
PSTAP |
CHAR
|
1 | 0 | ||||||||||||||||||||||||||
|
||||||||||||||||||||||||||||||
|
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 | ||||||||||||||||||||||||||
|
||||||||||||||||||||||||||||||
|
MANUE
Flag: allocation table manually changed
|
MANUE |
CHAR
|
1 | 0 | ||||||||||||||||||||||||||
|
RUNDG
Rounding off in allocation table
|
RUNDG |
CHAR
|
1 | 0 | ||||||||||||||||||||||||||
|
||||||||||||||||||||||||||||||
|
RESTV
Split remainder
|
RESTV |
CHAR
|
1 | 0 | ||||||||||||||||||||||||||
|
||||||||||||||||||||||||||||||
|
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 | ||||||||||||||||||||||||||
|
||||||||||||||||||||||||||||||
|
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 | ||||||||||||||||||||||||||
|
||||||||||||||||||||||||||||||
|
SVFIX
Plants fixed in AR
|
SVFIX |
CHAR
|
1 | 0 | ||||||||||||||||||||||||||
|
SIMAM
Alloc tbl qty simulation
|
SIMAM |
CHAR
|
1 | 0 | ||||||||||||||||||||||||||
|
||||||||||||||||||||||||||||||
|
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 | ||||||||||||||||||||||||||
|
||||||||||||||||||||||||||||||
|
RETPO
Returns Item
|
RETPO |
CHAR
|
1 | 0 | ||||||||||||||||||||||||||
|
||||||||||||||||||||||||||||||
|
BERMIMA
Include Minimum and Maximum Quantities
|
BERMIMA |
CHAR
|
1 | 0 | ||||||||||||||||||||||||||
|
||||||||||||||||||||||||||||||
|
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 | ||||||||||||||||||||||||||
|
||||||||||||||||||||||||||||||
|
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 | ||||||||||||||||||||||||||
|
||||||||||||||||||||||||||||||
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 | BSART_GL_BUKRS |
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 | BWART | AUPO | MANDT |
T149D
Global Valuation Types
|
MANDT |
| AUPO | BWART | AUPO | BWART |
T149D
Global Valuation Types
|
BWTAR |
| AUPO | EBELN | AUPO | MANDT |
EKKO
Purchasing Document Header
|
MANDT |
| AUPO | EBELN | AUPO | EBELN |
EKKO
Purchasing Document Header
|
EBELN |
| AUPO | EBELP | AUPO | MANDT |
EKPO
Purchasing Document Item
|
MANDT |
| AUPO | EBELP | AUPO | EBELN |
EKPO
Purchasing Document Item
|
EBELN |
| AUPO | EBELP | AUPO | EBELP |
EKPO
Purchasing Document Item
|
EBELP |
| 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 | LGORT |
T001L
Storage Locations
|
LGORT |
| AUPO | LGORT | AUPO | MANDT |
T001L
Storage Locations
|
MANDT |
| AUPO | LGORT | AUPO | VZWRK |
T001L
Storage Locations
|
WERKS |
| AUPO | LIFNR | AUPO | MANDT |
LFA1
Vendor Master (General Section)
|
MANDT |
| AUPO | LIFNR | AUPO | LIFNR |
LFA1
Vendor Master (General Section)
|
LIFNR |
| AUPO | MANDT | AUPO | MANDT |
T000
Clients
|
MANDT |
| AUPO | MATKL | AUPO | MANDT |
T023
Material Groups
|
MANDT |
| AUPO | MATKL | AUPO | MATKL |
T023
Material Groups
|
MATKL |
| AUPO | MATNR | AUPO | MANDT |
MARA
General Material Data
|
MANDT |
| AUPO | MATNR | AUPO | MATNR |
MARA
General Material Data
|
MATNR |
| AUPO | MEINS | AUPO | MEINS |
T006
Units of Measurement
|
MSEHI |
| AUPO | MEINS | AUPO | MANDT |
T006
Units of Measurement
|
MANDT |
| 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 | RFKTP |
EKPO
Purchasing Document Item
|
EBELP |
| AUPO | RFKTP | AUPO | MANDT |
EKPO
Purchasing Document Item
|
MANDT |
| AUPO | RFKTP | AUPO | RFKTN |
EKPO
Purchasing Document Item
|
EBELN |
| AUPO | SPERR | AUPO | SPERR |
T629
Allocation Table Rejection Reasons
|
SPERR |
| AUPO | SPERR | AUPO | MANDT |
T629
Allocation Table Rejection Reasons
|
MANDT |
| AUPO | UMART | AUPO | MANDT |
T161
Purchasing Document Types
|
MANDT |
| AUPO | UMART | 'F' |
T161
Purchasing Document Types
|
BSTYP | |
| AUPO | UMART | AUPO | UMART |
T161
Purchasing Document Types
|
BSART |
| 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 |