ARUN_I_STO_REQMT_PREV

ARun ITA: STO selection in Preview mode | view: ARUN_V_STO_REQ_P | TRAN | Extraction: Not supported | Component: Order Allocation Run
Tables used: EKETEKETEKPOEKKOEKPOEKESEKPVLFA1MAKTMARAMARCTMVFARUN_PREVIEWKNA1KNVVT161V
Column Name Description
ebeln FK Purchasing Document Number
ebelp Item Number of Purchasing Document
Column Name Description
netpr Net Price in Purchasing Document (in Document Currency)
netwr Net Order Value in PO Currency
Column Name Description
req_conf_qty null
wamng null
kwmeng null
alloc_qty Assigned Quantity by ARun
PFMENGE Assigned Quantity by ARun
PHMENGE Assigned Quantity by ARun
PRMENGE Assigned Quantity by ARun
pomenge Assigned Quantity by ARun
tbdlv_qty null
dmenge null
klmeng Committed Quantity
Column Name Description
bedat Purchasing Document Date
audat Purchasing Document Date
aedat Creation Date of Purchasing Document
erdat Creation Date of Purchasing Document
req_dlvdate null
material_avail_date Committed date
cnf_dlvdate null
delivery_date_po Confirmed Delivery Date for Future Receipts
mat_avail_date_mrp Material Staging/Availability Date
requested_date null
Column Name Description
bstyp Purchasing Document Category Show values
stapo Item is statistical Show values
fsh_mg_arun_req Supply Assignment (ARun) Show values
fsh_vas_rel VAS Relevant Show values
xchpf Batch Management Requirement Indicator for Plant Show values
sgt_stk_prt Stock Protection Indicator [Obsolete] Show values
arun_status ARun Status Show values
stock_source ARun Stock Source Show values
arun_mode Allocation Run Mode Show values
attyp Material Category Show values
fixmg Delivery Date and Quantity Fixed Show values
sgt_scope Segmentation Strategy Scope Show values
arun_fix_batch Assign Batches in Supply Assignment (ARun) Show values
Column Name Description Domain name
posnr Item Number of Purchasing Document EBELP
bdart null
storage_location Issuing Storage Location for Stock Transport Order LGORT
purchdoc_num Purchasing Document Number EBELN
purchdoc_item Item Number of Purchasing Document EBELP
req_ind null
REQ_SEGMENT Requirement Segment SGT_SRCA
fsh_season Season RFM_SAISO
fsh_season_year Season Year FSH_CJAHR
fsh_collection Fashion Collection FSH_COLLECTION
fsh_theme Fashion Theme FSH_THEME
abelp Allocation Table Item ABELP
fsh_vas_prnt_id Item Number of Purchasing Document EBELP
fsh_transaction Transaction Number FSH_TRANSACTION
fsh_item_group Item Group FSH_ITEM_GROUP
fsh_item Item Number FSH_ITEM
maktg Material Description in Uppercase for Matchcodes CHAR40
rfm_psst_group PSST Group RFM_PSST_GROUP_ID
umrez Numerator for Conversion of Order Unit to Base Unit UMBSZ
umren Denominator for Conversion of Order Unit to Base Unit UMBSN
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
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
fsh_grid_cond_rec Grid Condition Record Number CHAR32
arunid ARun GUID SYSUUID
salesdoc_num Sales Document VBELN
reserv_num Number of reservation/dependent requirements RSNUM
salesdoc_item Item number of the SD document POSNR
reserv_item Item number of Reservation RSPOS
batch Batch Number CHARG
purchord_num Purchase Order number (Stock) EBELN
prodord_num Production number (Stock) AUFNR
purchord_item Item number of Purchase Order EBELP
prodord_item Item number of Production Order CO_POSNR
purchord_sch Schedule Line number of Purchase Order ETENR
confirmation_no Sequential Number of Supplier Confirmation for ARun NUM04
consignment_num Special stock consignment number CHAR10
stk_segment Stock Segment SGT_SRCA
creation_time UTC Time Stamp in Short Form (YYYYMMDDhhmmss) TZNTSTMPS
changed_by Name of Person Who Changed Object USNAM
prreg null
rereg null
ibd_num Delivery VBELN
ibd_itm Delivery Item POSNR
Master Data Relations Join Conditions
MRP Area
  • Client
  • MRP Area
  • ARUN_I_STO_REQMT_PREV.MANDT == MDLV.MANDT
  • ARUN_I_STO_REQMT_PREV.BERID == MDLV.BERID
Purchasing Document Type
  • Purchasing Document Category
  • Purchasing Document Type
  • Client
  • ARUN_I_STO_REQMT_PREV.BSTYP == T161.BSTYP
  • ARUN_I_STO_REQMT_PREV.BSART == T161.BSART
  • ARUN_I_STO_REQMT_PREV.MANDT == T161.MANDT
Company Code
  • Company Code
  • Client
  • ARUN_I_STO_REQMT_PREV.BUKRS == T001.BUKRS
  • ARUN_I_STO_REQMT_PREV.MANDT == T001.MANDT
MRP type
  • Client
  • MRP Type
  • ARUN_I_STO_REQMT_PREV.MANDT == T438A.MANDT
  • ARUN_I_STO_REQMT_PREV.DISMM == T438A.DISMM
Purchasing Group
  • Purchasing Group
  • Client
  • ARUN_I_STO_REQMT_PREV.EKGRP == T024.EKGRP
  • ARUN_I_STO_REQMT_PREV.MANDT == T024.MANDT
Purchasing organization
  • Purchasing organization
  • Client
  • ARUN_I_STO_REQMT_PREV.EKORG == T024E.EKORG
  • ARUN_I_STO_REQMT_PREV.MANDT == T024E.MANDT
Grouping Rule
  • Grouping Rule
  • Client
  • ARUN_I_STO_REQMT_PREV.FSH_GRREG == FSH_GRRG_W.GRREG
  • ARUN_I_STO_REQMT_PREV.MANDT == FSH_GRRG_W.MANDT
ARUN Grouping Strategy
  • ARUN Grouping Strategy
  • Client
  • ARUN_I_STO_REQMT_PREV.FSH_GRSGY == FSH_GRSG_W.FSH_GRSGY
  • ARUN_I_STO_REQMT_PREV.MANDT == FSH_GRSG_W.MANDT
Customer Group 10
  • Sales Organization
  • Client
  • Customer Group 10
  • ARUN_I_STO_REQMT_PREV.VKORG == FSH_TVV10.VKORG
  • ARUN_I_STO_REQMT_PREV.MANDT == FSH_TVV10.MANDT
  • ARUN_I_STO_REQMT_PREV.FSH_KVGR10 == FSH_TVV10.KVGR10
Customer Group 6
  • Sales Organization
  • Customer Group 6
  • Client
  • ARUN_I_STO_REQMT_PREV.VKORG == FSH_TVV6.VKORG
  • ARUN_I_STO_REQMT_PREV.FSH_KVGR6 == FSH_TVV6.KVGR6
  • ARUN_I_STO_REQMT_PREV.MANDT == FSH_TVV6.MANDT
Customer Group 7
  • Sales Organization
  • Customer Group 7
  • Client
  • ARUN_I_STO_REQMT_PREV.VKORG == FSH_TVV7.VKORG
  • ARUN_I_STO_REQMT_PREV.FSH_KVGR7 == FSH_TVV7.KVGR7
  • ARUN_I_STO_REQMT_PREV.MANDT == FSH_TVV7.MANDT
Customer Group 8
  • Sales Organization
  • Client
  • Customer Group 8
  • ARUN_I_STO_REQMT_PREV.VKORG == FSH_TVV8.VKORG
  • ARUN_I_STO_REQMT_PREV.MANDT == FSH_TVV8.MANDT
  • ARUN_I_STO_REQMT_PREV.FSH_KVGR8 == FSH_TVV8.KVGR8
Customer Group 9
  • Sales Organization
  • Customer Group 9
  • Client
  • ARUN_I_STO_REQMT_PREV.VKORG == FSH_TVV9.VKORG
  • ARUN_I_STO_REQMT_PREV.FSH_KVGR9 == FSH_TVV9.KVGR9
  • ARUN_I_STO_REQMT_PREV.MANDT == FSH_TVV9.MANDT
Release Strategy
  • Release Strategy
  • Client
  • ARUN_I_STO_REQMT_PREV.FSH_RESGY == FSH_RESG_W.FSH_RESGY
  • ARUN_I_STO_REQMT_PREV.MANDT == FSH_RESG_W.MANDT
Customer Group
  • Customer Group
  • Client
  • ARUN_I_STO_REQMT_PREV.KDGRP == T151.KDGRP
  • ARUN_I_STO_REQMT_PREV.MANDT == T151.MANDT
Customer Number
  • Customer Number
  • Customer Number
  • Client
  • ARUN_I_STO_REQMT_PREV.KUNNR == KNA1.KUNNR
  • ARUN_I_STO_REQMT_PREV.KUNWE == KNA1.KUNNR
  • ARUN_I_STO_REQMT_PREV.MANDT == KNA1.MANDT
Customer Number
  • Customer Number
  • Customer Number
  • Client
  • ARUN_I_STO_REQMT_PREV.KUNNR == KNA1.KUNNR
  • ARUN_I_STO_REQMT_PREV.KUNWE == KNA1.KUNNR
  • ARUN_I_STO_REQMT_PREV.MANDT == KNA1.MANDT
Customer Group 1
  • Customer Group 1
  • Client
  • ARUN_I_STO_REQMT_PREV.KVGR1 == TVV1.KVGR1
  • ARUN_I_STO_REQMT_PREV.MANDT == TVV1.MANDT
Customer Group 2
  • Customer Group 2
  • Client
  • ARUN_I_STO_REQMT_PREV.KVGR2 == TVV2.KVGR2
  • ARUN_I_STO_REQMT_PREV.MANDT == TVV2.MANDT
Customer Group 3
  • Customer Group 3
  • Client
  • ARUN_I_STO_REQMT_PREV.KVGR3 == TVV3.KVGR3
  • ARUN_I_STO_REQMT_PREV.MANDT == TVV3.MANDT
Customer Group 4
  • Customer Group 4
  • Client
  • ARUN_I_STO_REQMT_PREV.KVGR4 == TVV4.KVGR4
  • ARUN_I_STO_REQMT_PREV.MANDT == TVV4.MANDT
Customer Group 5
  • Customer Group 5
  • Client
  • ARUN_I_STO_REQMT_PREV.KVGR5 == TVV5.KVGR5
  • ARUN_I_STO_REQMT_PREV.MANDT == TVV5.MANDT
Issuing Storage Location for Stock Transport Order
  • Client
  • Issuing Storage Location for Stock Transport Order
  • Issuing Storage Location for Stock Transport Order
  • Supplying (issuing) plant in case of stock transport order
  • Supplying (issuing) plant in case of stock transport order
  • ARUN_I_STO_REQMT_PREV.MANDT == T001L.MANDT
  • ARUN_I_STO_REQMT_PREV.LGORT == T001L.LGORT
  • ARUN_I_STO_REQMT_PREV.SLOC_REQ == T001L.LGORT
  • ARUN_I_STO_REQMT_PREV.PLANT == T001L.WERKS
  • ARUN_I_STO_REQMT_PREV.RESWK == T001L.WERKS
Base Unit of Measure
  • Client
  • Base Unit of Measure
  • ARUN_I_STO_REQMT_PREV.MANDT == T006.MANDT
  • ARUN_I_STO_REQMT_PREV.LMEIN == T006.MSEHI
Delivery Priority
  • Delivery Priority
  • Client
  • ARUN_I_STO_REQMT_PREV.LPRIO == TPRIO.LPRIO
  • ARUN_I_STO_REQMT_PREV.MANDT == TPRIO.MANDT
Material Number
  • Client
  • Material Number
  • ARUN_I_STO_REQMT_PREV.MANDT == MARA.MANDT
  • ARUN_I_STO_REQMT_PREV.MATERIAL == MARA.MATNR
Material Group
  • Client
  • Material Group
  • ARUN_I_STO_REQMT_PREV.MANDT == T023.MANDT
  • ARUN_I_STO_REQMT_PREV.MATKL == T023.MATKL
Checking Group for Availability Check
  • Checking Group for Availability Check
  • Client
  • ARUN_I_STO_REQMT_PREV.MTVFP == TMVF.MTVFP
  • ARUN_I_STO_REQMT_PREV.MANDT == TMVF.MANDT
Supplying (issuing) plant in case of stock transport order
  • Client
  • Supplying (issuing) plant in case of stock transport order
  • Supplying (issuing) plant in case of stock transport order
  • ARUN_I_STO_REQMT_PREV.MANDT == T001W.MANDT
  • ARUN_I_STO_REQMT_PREV.PLANT == T001W.WERKS
  • ARUN_I_STO_REQMT_PREV.RESWK == T001W.WERKS
Supplying (issuing) plant in case of stock transport order
  • Client
  • Supplying (issuing) plant in case of stock transport order
  • Supplying (issuing) plant in case of stock transport order
  • ARUN_I_STO_REQMT_PREV.MANDT == T001W.MANDT
  • ARUN_I_STO_REQMT_PREV.PLANT == T001W.WERKS
  • ARUN_I_STO_REQMT_PREV.RESWK == T001W.WERKS
Route
  • Client
  • Route
  • ARUN_I_STO_REQMT_PREV.MANDT == TVRO.MANDT
  • ARUN_I_STO_REQMT_PREV.ROUTE == TVRO.ROUTE
Cross-Plant Configurable Material
  • Client
  • Cross-Plant Configurable Material
  • ARUN_I_STO_REQMT_PREV.MANDT == MARA.MANDT
  • ARUN_I_STO_REQMT_PREV.SATNR == MARA.MATNR
Segmentation Strategy
  • ?
  • Segmentation Strategy
  • Client
  • ARUN_I_STO_REQMT_PREV.[column in domain "WERKS_D"] == SGT_COVS_T.WERKS
  • ARUN_I_STO_REQMT_PREV.SGT_COVS == SGT_COVS_T.SGT_COVS
  • ARUN_I_STO_REQMT_PREV.MANDT == SGT_COVS_T.MANDT
Issuing Storage Location for Stock Transport Order
  • Client
  • Issuing Storage Location for Stock Transport Order
  • Issuing Storage Location for Stock Transport Order
  • Supplying (issuing) plant in case of stock transport order
  • Supplying (issuing) plant in case of stock transport order
  • ARUN_I_STO_REQMT_PREV.MANDT == T001L.MANDT
  • ARUN_I_STO_REQMT_PREV.LGORT == T001L.LGORT
  • ARUN_I_STO_REQMT_PREV.SLOC_REQ == T001L.LGORT
  • ARUN_I_STO_REQMT_PREV.PLANT == T001L.WERKS
  • ARUN_I_STO_REQMT_PREV.RESWK == T001L.WERKS
Division
  • Client
  • Division
  • ARUN_I_STO_REQMT_PREV.MANDT == TSPA.MANDT
  • ARUN_I_STO_REQMT_PREV.SPART == TSPA.SPART
Sales Organization
  • Sales Organization
  • Client
  • ARUN_I_STO_REQMT_PREV.VKORG == TVKO.VKORG
  • ARUN_I_STO_REQMT_PREV.MANDT == TVKO.MANDT
Shipping Point / Receiving Point
  • Shipping Point / Receiving Point
  • Client
  • ARUN_I_STO_REQMT_PREV.VSTEL == TVST.VSTEL
  • ARUN_I_STO_REQMT_PREV.MANDT == TVST.MANDT
Distribution Channel
  • Client
  • Distribution Channel
  • ARUN_I_STO_REQMT_PREV.MANDT == TVTW.MANDT
  • ARUN_I_STO_REQMT_PREV.VTWEG == TVTW.VTWEG