Arun_I_Sto_Reqmt

ARun insight to action :Sto selection | view: ARUN_V_I_STO_REQ | TRAN | Extraction: Not supported | Component: Order Allocation Run
Tables used: EKET, EKET, EKPO, EKKO, EKPO, EKES, EKPV, LFA1, MAKT, MARA, MARC, TMVF, ARUN_BDBS, KNA1, KNVV, T161V
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
FMENGE Assigned Quantity by ARun
HMENGE Assigned Quantity by ARun
RMENGE Assigned Quantity by ARun
omenge Assigned Quantity by ARun
pomenge Assigned Quantity by ARun
dmenge null
cmenge Assigned Quantity by ARun
tbdlv_qty null
wmeng 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
batch_req 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
uecha Higher-Level Item of Batch Split Item POSNR
Master Data Relations Join Conditions
MRP Area
  • MRP Area
  • Client
  • ARUN_I_STO_REQMT.BERID == MDLV.BERID
  • ARUN_I_STO_REQMT.MANDT == MDLV.MANDT
Purchasing Document Type
  • Purchasing Document Category
  • Client
  • Purchasing Document Type
  • ARUN_I_STO_REQMT.BSTYP == T161.BSTYP
  • ARUN_I_STO_REQMT.MANDT == T161.MANDT
  • ARUN_I_STO_REQMT.BSART == T161.BSART
Company Code
  • Company Code
  • Client
  • ARUN_I_STO_REQMT.BUKRS == T001.BUKRS
  • ARUN_I_STO_REQMT.MANDT == T001.MANDT
MRP type
  • MRP Type
  • Client
  • ARUN_I_STO_REQMT.DISMM == T438A.DISMM
  • ARUN_I_STO_REQMT.MANDT == T438A.MANDT
Purchasing Group
  • Client
  • Purchasing Group
  • ARUN_I_STO_REQMT.MANDT == T024.MANDT
  • ARUN_I_STO_REQMT.EKGRP == T024.EKGRP
Purchasing organization
  • Purchasing organization
  • Client
  • ARUN_I_STO_REQMT.EKORG == T024E.EKORG
  • ARUN_I_STO_REQMT.MANDT == T024E.MANDT
Grouping Rule
  • Grouping Rule
  • Client
ARUN Grouping Strategy
  • Client
  • ARUN Grouping Strategy
Customer Group 10
  • Sales Organization
  • Customer Group 10
  • Client
Customer Group 6
  • Sales Organization
  • Customer Group 6
  • Client
  • ARUN_I_STO_REQMT.VKORG == FSH_TVV6.VKORG
  • ARUN_I_STO_REQMT.FSH_KVGR6 == FSH_TVV6.KVGR6
  • ARUN_I_STO_REQMT.MANDT == FSH_TVV6.MANDT
Customer Group 7
  • Sales Organization
  • Customer Group 7
  • Client
  • ARUN_I_STO_REQMT.VKORG == FSH_TVV7.VKORG
  • ARUN_I_STO_REQMT.FSH_KVGR7 == FSH_TVV7.KVGR7
  • ARUN_I_STO_REQMT.MANDT == FSH_TVV7.MANDT
Customer Group 8
  • Sales Organization
  • Customer Group 8
  • Client
  • ARUN_I_STO_REQMT.VKORG == FSH_TVV8.VKORG
  • ARUN_I_STO_REQMT.FSH_KVGR8 == FSH_TVV8.KVGR8
  • ARUN_I_STO_REQMT.MANDT == FSH_TVV8.MANDT
Customer Group 9
  • Sales Organization
  • Customer Group 9
  • Client
  • ARUN_I_STO_REQMT.VKORG == FSH_TVV9.VKORG
  • ARUN_I_STO_REQMT.FSH_KVGR9 == FSH_TVV9.KVGR9
  • ARUN_I_STO_REQMT.MANDT == FSH_TVV9.MANDT
Release Strategy
  • Release Strategy
  • Client
Customer Group
  • Customer Group
  • Client
  • ARUN_I_STO_REQMT.KDGRP == T151.KDGRP
  • ARUN_I_STO_REQMT.MANDT == T151.MANDT
Customer Number
  • Client
  • Customer Number
  • Customer Number
  • ARUN_I_STO_REQMT.MANDT == KNA1.MANDT
  • ARUN_I_STO_REQMT.KUNNR == KNA1.KUNNR
  • ARUN_I_STO_REQMT.KUNWE == KNA1.KUNNR
Customer Number
  • Client
  • Customer Number
  • Customer Number
  • ARUN_I_STO_REQMT.MANDT == KNA1.MANDT
  • ARUN_I_STO_REQMT.KUNNR == KNA1.KUNNR
  • ARUN_I_STO_REQMT.KUNWE == KNA1.KUNNR
Customer Group 1
  • Customer Group 1
  • Client
  • ARUN_I_STO_REQMT.KVGR1 == TVV1.KVGR1
  • ARUN_I_STO_REQMT.MANDT == TVV1.MANDT
Customer Group 2
  • Customer Group 2
  • Client
  • ARUN_I_STO_REQMT.KVGR2 == TVV2.KVGR2
  • ARUN_I_STO_REQMT.MANDT == TVV2.MANDT
Customer Group 3
  • Customer Group 3
  • Client
  • ARUN_I_STO_REQMT.KVGR3 == TVV3.KVGR3
  • ARUN_I_STO_REQMT.MANDT == TVV3.MANDT
Customer Group 4
  • Customer Group 4
  • Client
  • ARUN_I_STO_REQMT.KVGR4 == TVV4.KVGR4
  • ARUN_I_STO_REQMT.MANDT == TVV4.MANDT
Customer Group 5
  • Customer Group 5
  • Client
  • ARUN_I_STO_REQMT.KVGR5 == TVV5.KVGR5
  • ARUN_I_STO_REQMT.MANDT == TVV5.MANDT
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
  • Client
  • Issuing Storage Location for Stock Transport Order
  • Issuing Storage Location for Stock Transport Order
  • ARUN_I_STO_REQMT.RESWK == T001L.WERKS
  • ARUN_I_STO_REQMT.PLANT == T001L.WERKS
  • ARUN_I_STO_REQMT.MANDT == T001L.MANDT
  • ARUN_I_STO_REQMT.LGORT == T001L.LGORT
  • ARUN_I_STO_REQMT.SLOC_REQ == T001L.LGORT
Base Unit of Measure
  • Client
  • Base Unit of Measure
  • ARUN_I_STO_REQMT.MANDT == T006.MANDT
  • ARUN_I_STO_REQMT.LMEIN == T006.MSEHI
Delivery Priority
  • Client
  • Delivery Priority
  • ARUN_I_STO_REQMT.MANDT == TPRIO.MANDT
  • ARUN_I_STO_REQMT.LPRIO == TPRIO.LPRIO
Material Number
  • Material Number
  • Client
  • ARUN_I_STO_REQMT.MATERIAL == MARA.MATNR
  • ARUN_I_STO_REQMT.MANDT == MARA.MANDT
Material Group
  • Material Group
  • Client
  • ARUN_I_STO_REQMT.MATKL == T023.MATKL
  • ARUN_I_STO_REQMT.MANDT == T023.MANDT
Checking Group for Availability Check
  • Client
  • Checking Group for Availability Check
  • ARUN_I_STO_REQMT.MANDT == TMVF.MANDT
  • ARUN_I_STO_REQMT.MTVFP == TMVF.MTVFP
Supplying (issuing) plant in case of stock transport order
  • Supplying (issuing) plant in case of stock transport order
  • Supplying (issuing) plant in case of stock transport order
  • Client
  • ARUN_I_STO_REQMT.RESWK == T001W.WERKS
  • ARUN_I_STO_REQMT.PLANT == T001W.WERKS
  • ARUN_I_STO_REQMT.MANDT == T001W.MANDT
Supplying (issuing) plant in case of stock transport order
  • Supplying (issuing) plant in case of stock transport order
  • Supplying (issuing) plant in case of stock transport order
  • Client
  • ARUN_I_STO_REQMT.RESWK == T001W.WERKS
  • ARUN_I_STO_REQMT.PLANT == T001W.WERKS
  • ARUN_I_STO_REQMT.MANDT == T001W.MANDT
Route
  • Route
  • Client
  • ARUN_I_STO_REQMT.ROUTE == TVRO.ROUTE
  • ARUN_I_STO_REQMT.MANDT == TVRO.MANDT
Cross-Plant Configurable Material
  • Cross-Plant Configurable Material
  • Client
  • ARUN_I_STO_REQMT.SATNR == MARA.MATNR
  • ARUN_I_STO_REQMT.MANDT == MARA.MANDT
Segmentation Strategy
  • ?
  • Client
  • Segmentation Strategy
  • ARUN_I_STO_REQMT.[column in domain "WERKS_D"] == SGT_COVS_T.WERKS
  • ARUN_I_STO_REQMT.MANDT == SGT_COVS_T.MANDT
  • ARUN_I_STO_REQMT.SGT_COVS == SGT_COVS_T.SGT_COVS
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
  • Client
  • Issuing Storage Location for Stock Transport Order
  • Issuing Storage Location for Stock Transport Order
  • ARUN_I_STO_REQMT.RESWK == T001L.WERKS
  • ARUN_I_STO_REQMT.PLANT == T001L.WERKS
  • ARUN_I_STO_REQMT.MANDT == T001L.MANDT
  • ARUN_I_STO_REQMT.LGORT == T001L.LGORT
  • ARUN_I_STO_REQMT.SLOC_REQ == T001L.LGORT
Division
  • Client
  • Division
  • ARUN_I_STO_REQMT.MANDT == TSPA.MANDT
  • ARUN_I_STO_REQMT.SPART == TSPA.SPART
Sales Organization
  • Sales Organization
  • Client
  • ARUN_I_STO_REQMT.VKORG == TVKO.VKORG
  • ARUN_I_STO_REQMT.MANDT == TVKO.MANDT
Shipping Point / Receiving Point
  • Shipping Point / Receiving Point
  • Client
  • ARUN_I_STO_REQMT.VSTEL == TVST.VSTEL
  • ARUN_I_STO_REQMT.MANDT == TVST.MANDT
Distribution Channel
  • Client
  • Distribution Channel
  • ARUN_I_STO_REQMT.MANDT == TVTW.MANDT
  • ARUN_I_STO_REQMT.VTWEG == TVTW.VTWEG