Arun_Purchord_Sel

A-run purchase order selection(w/o confirmations) | view: ARUN_V_PUROR_SEL | TRAN | Extraction: Not supported | Component: Order Allocation Run
Tables used: EKETEKKOEKPOMARAMARCARUN_BDBS
Column Name Description
Column Name Description
Column Name Description
po_open_qty null
Column Name Description
delv_date Item delivery date
termn null
PurchDocDate Purchasing Document Date
Column Name Description
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
stock_source null
Master Data Relations Join Conditions
Material Number
  • Client
  • Material Number
  • ARUN_PURCHORD_SEL.MANDT == MARA.MANDT
  • ARUN_PURCHORD_SEL.MATERIAL == MARA.MATNR
Purchase Order Unit of Measure
  • Client
  • Purchase Order Unit of Measure
  • ARUN_PURCHORD_SEL.MANDT == T006.MANDT
  • ARUN_PURCHORD_SEL.MATERIALBASEUNIT == T006.MSEHI
Plant
  • Client
  • Plant
  • ARUN_PURCHORD_SEL.MANDT == T001W.MANDT
  • ARUN_PURCHORD_SEL.PLANT == T001W.WERKS
Purchasing Document Type
  • Client
  • Purchasing Document Type
  • ?
  • ARUN_PURCHORD_SEL.MANDT == T161.MANDT
  • ARUN_PURCHORD_SEL.PURCHDOCTYPE == T161.BSART
  • ARUN_PURCHORD_SEL.[column in domain "BSTYP"] == T161.BSTYP
Storage location
  • Storage location
  • Client
  • Plant
  • ARUN_PURCHORD_SEL.STORAGELOCATION == T001L.LGORT
  • ARUN_PURCHORD_SEL.MANDT == T001L.MANDT
  • ARUN_PURCHORD_SEL.PLANT == T001L.WERKS
Vendor's account number
  • Client
  • Vendor's account number
  • ARUN_PURCHORD_SEL.MANDT == LFA1.MANDT
  • ARUN_PURCHORD_SEL.SUPPLIER == LFA1.LIFNR