aruni_po_sel

ARun ITA : PO Select | view: ARUNI_V_PO_SEL | TRAN | Extraction: Not supported | Component: Order Allocation Run
Tables used: EKETEKKOEKPOLFA1MARAMARCARUN_BDBS
Column Name Description
Column Name Description
Column Name Description
po_open_qty null
StockQty null
pfmenge null
📏 Purchase Order Unit of Measure (materialbaseunit):
phmenge null
prmenge null
fmenge null
hmenge null
rmenge null
omenge null
pomenge null
alloc_qty null
Column Name Description
delv_date Item delivery date
po_arrival_date null
PurchDocDate Purchasing Document Date
Column Name Description
attyp Material Category Show values
Column Name Description Domain name
purchord_num Purchasing Document Number EBELN
purchord_item Item Number of Purchasing Document EBELP
purchord_sch Delivery Schedule Line Counter EETEN
sgt_scat Stock Segment SGT_SRCA
StockSegment Stock Segment SGT_SRCA
SeasonYear Season Year FSH_CJAHR
Season Season RFM_SAISO
SCollection Fashion Collection FSH_COLLECTION
theme Fashion Theme FSH_THEME
webaz Goods receipt processing time in days DEC3
stock_source null
color Characteristic Value for Colors of Variants WRF_ATWRT
size1 Characteristic Value for Main Sizes of Variants WRF_ATWRT
size2 Characteristic Value for Second Size for Variants WRF_ATWRT
color_atinn Internal Charactieristic Number for Color Characteristics ATINN
size1_atinn Internal Char. Number for Characteristics for Main Sizes ATINN
size2_atinn Internal Char. Number for Characteristics for Second Sizes ATINN
stknam null
Master Data Relations Join Conditions
Company Code
  • Client
  • Company Code
  • ARUNI_PO_SEL.MANDT == T001.MANDT
  • ARUNI_PO_SEL.COMPANY_CODE == T001.BUKRS
Material Number
  • Client
  • Material Number
  • ARUNI_PO_SEL.MANDT == MARA.MANDT
  • ARUNI_PO_SEL.MATERIAL == MARA.MATNR
Purchase Order Unit of Measure
  • Client
  • Purchase Order Unit of Measure
  • ARUNI_PO_SEL.MANDT == T006.MANDT
  • ARUNI_PO_SEL.MATERIALBASEUNIT == T006.MSEHI
Material Group
  • Client
  • Material Group
  • ARUNI_PO_SEL.MANDT == T023.MANDT
  • ARUNI_PO_SEL.MATKL == T023.MATKL
Plant
  • Client
  • Plant
  • ARUNI_PO_SEL.MANDT == T001W.MANDT
  • ARUNI_PO_SEL.PLANT == T001W.WERKS
Purchasing Document Type
  • Purchasing Document Type
  • Client
  • ?
  • ARUNI_PO_SEL.PURCHDOCTYPE == T161.BSART
  • ARUNI_PO_SEL.MANDT == T161.MANDT
  • ARUNI_PO_SEL.[column in domain "BSTYP"] == T161.BSTYP
Issuing Storage Location for Stock Transport Order
  • Client
  • Supplying (issuing) plant in case of stock transport order
  • Issuing Storage Location for Stock Transport Order
  • ARUNI_PO_SEL.MANDT == T001L.MANDT
  • ARUNI_PO_SEL.RESWK == T001L.WERKS
  • ARUNI_PO_SEL.RESLO == T001L.LGORT
Supplying (issuing) plant in case of stock transport order
  • Client
  • Supplying (issuing) plant in case of stock transport order
  • ARUNI_PO_SEL.MANDT == T001W.MANDT
  • ARUNI_PO_SEL.RESWK == T001W.WERKS
Cross-Plant Configurable Material
  • Client
  • Cross-Plant Configurable Material
  • ARUNI_PO_SEL.MANDT == MARA.MANDT
  • ARUNI_PO_SEL.SATNR == MARA.MATNR
Storage location
  • Storage location
  • Client
  • Plant
  • ARUNI_PO_SEL.STORAGELOCATION == T001L.LGORT
  • ARUNI_PO_SEL.MANDT == T001L.MANDT
  • ARUNI_PO_SEL.PLANT == T001L.WERKS
Vendor's account number
  • Client
  • Vendor's account number
  • ARUNI_PO_SEL.MANDT == LFA1.MANDT
  • ARUNI_PO_SEL.SUPPLIER == LFA1.LIFNR