ARUN_I_PR

Select PR Allocation data | view: ARUN_V_PR | TRAN | Extraction: Not supported | Component: Order Allocation Run
Tables used: EBANMARAMARCARUN_PREVIEWARUN_PREVIEW
Column Name Description
Column Name Description
Column Name Description
total_stock null
sopen_pre null
pfmenge null
alloc_qty null
📏 Purchase requisition unit of measure (materialbaseunit):
phmenge null
prmenge null
pomenge null
Column Name Description
delv_date Item delivery date
Column Name Description
attyp Material Category Show values
Column Name Description Domain name
purchreq_num Purchase Requisition Number BANFN
purchreq_item Item number of purchase requisition BNFPO
purchreq_sch null
stock_source null
stocksegment Stock Segment SGT_SRCA
SeasonYear null
Season null
sCollection null
theme 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
company_code Company Code of External System BUKRS
satnr Cross-Plant Configurable Material MATNR
webaz Goods receipt processing time in days DEC3
Master Data Relations Join Conditions
Material Number
  • Client
  • Material Number
  • ARUN_I_PR.MANDT == MARA.MANDT
  • ARUN_I_PR.MATERIAL == MARA.MATNR
Purchase requisition unit of measure
  • Client
  • Purchase requisition unit of measure
  • ARUN_I_PR.MANDT == T006.MANDT
  • ARUN_I_PR.MATERIALBASEUNIT == T006.MSEHI
Material Group
  • Client
  • Material Group
  • ARUN_I_PR.MANDT == T023.MANDT
  • ARUN_I_PR.MATKL == T023.MATKL
Plant
  • Client
  • Plant
  • ARUN_I_PR.MANDT == T001W.MANDT
  • ARUN_I_PR.PLANT == T001W.WERKS
Purchase Requisition Document Type
  • Client
  • Purchase Requisition Document Type
  • ?
  • ARUN_I_PR.MANDT == T161.MANDT
  • ARUN_I_PR.PR_DOC_TYP == T161.BSART
  • ARUN_I_PR.[column in domain "BSTYP"] == T161.BSTYP
Storage location
  • Client
  • Storage location
  • Plant
  • ARUN_I_PR.MANDT == T001L.MANDT
  • ARUN_I_PR.STORAGELOCATION == T001L.LGORT
  • ARUN_I_PR.PLANT == T001L.WERKS
Desired Vendor
  • Client
  • Desired Vendor
  • ARUN_I_PR.MANDT == LFA1.MANDT
  • ARUN_I_PR.SUPPLIER == LFA1.LIFNR