Arun_Sto_Req1

STO Requirement - Initial join | view: ARUN_V_STO_REQ1 | TRAN | Extraction: Not supported | Component: Order Allocation Run
Tables used: EKKOEKPOMAKTMARAMARC
Column Name Description
ebeln FK Purchasing Document Number
ebelp Item Number of Purchasing Document
Column Name Description
Column Name Description
kwmeng null
Column Name Description
bedat Purchasing Document Date
audat Purchasing Document Date
aedat Creation Date of Purchasing Document
erdat Creation Date of Purchasing Document
Column Name Description
bstyp Purchasing Document Category Show values
stapo Item is statistical 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
attyp Material Category Show values
Column Name Description Domain name
sgt_rcat 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
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
maktg Material Description in Uppercase for Matchcodes CHAR40
fsh_grid_cond_rec Grid Condition Record Number CHAR32
Master Data Relations Join Conditions
Purchasing Document Type
  • Purchasing Document Type
  • Purchasing Document Category
  • Client
  • ARUN_STO_REQ1.BSART == T161.BSART
  • ARUN_STO_REQ1.BSTYP == T161.BSTYP
  • ARUN_STO_REQ1.MANDT == T161.MANDT
Company Code
  • Client
  • Company Code
  • ARUN_STO_REQ1.MANDT == T001.MANDT
  • ARUN_STO_REQ1.BUKRS == T001.BUKRS
Purchasing Group
  • Purchasing Group
  • Client
  • ARUN_STO_REQ1.EKGRP == T024.EKGRP
  • ARUN_STO_REQ1.MANDT == T024.MANDT
Purchasing organization
  • Purchasing organization
  • Client
  • ARUN_STO_REQ1.EKORG == T024E.EKORG
  • ARUN_STO_REQ1.MANDT == T024E.MANDT
Issuing Storage Location for Stock Transport Order
  • Client
  • Issuing Storage Location for Stock Transport Order
  • Supplying (issuing) plant in case of stock transport order
  • ARUN_STO_REQ1.MANDT == T001L.MANDT
  • ARUN_STO_REQ1.LGORT == T001L.LGORT
  • ARUN_STO_REQ1.RESWK == T001L.WERKS
Base Unit of Measure
  • Client
  • Base Unit of Measure
  • ARUN_STO_REQ1.MANDT == T006.MANDT
  • ARUN_STO_REQ1.LMEIN == T006.MSEHI
Material Group
  • Material Group
  • Client
  • ARUN_STO_REQ1.MATKL == T023.MATKL
  • ARUN_STO_REQ1.MANDT == T023.MANDT
Material Number
  • Client
  • Material Number
  • ARUN_STO_REQ1.MANDT == MARA.MANDT
  • ARUN_STO_REQ1.MATNR == MARA.MATNR
Purchase Order Unit of Measure
  • Client
  • Purchase Order Unit of Measure
  • ARUN_STO_REQ1.MANDT == T006.MANDT
  • ARUN_STO_REQ1.MEINS == T006.MSEHI
Division
  • Client
  • Division
  • ARUN_STO_REQ1.MANDT == TSPA.MANDT
  • ARUN_STO_REQ1.MSPART == TSPA.SPART
Supplying (issuing) plant in case of stock transport order
  • Client
  • Supplying (issuing) plant in case of stock transport order
  • ARUN_STO_REQ1.MANDT == T001W.MANDT
  • ARUN_STO_REQ1.RESWK == T001W.WERKS
Cross-Plant Configurable Material
  • Cross-Plant Configurable Material
  • Client
  • ARUN_STO_REQ1.SATNR == MARA.MATNR
  • ARUN_STO_REQ1.MANDT == MARA.MANDT
Segmentation Strategy
  • Client
  • ?
  • Segmentation Strategy
Plant
  • Plant
  • Client
  • ARUN_STO_REQ1.WERKS == T001W.WERKS
  • ARUN_STO_REQ1.MANDT == T001W.MANDT