Arun_So_Req1

Sales Order Requirement - Initial join | view: ARUN_V_SO_REQ1 | TRAN | Extraction: Not supported | Component: Order Allocation Run
Tables used: VBAPMARAMARC
Column Name Description
vbeln FK Sales Document
posnr Sales Document Item
Column Name Description
Column Name Description
kwmeng null
Column Name Description
fsh_candate Cancellation Date
hfsh_candate Cancellation Date
stdat Key date of the bill of material
Column Name Description
shkzg Returns Item Show values
kowrr Statistical Values Show values
fixmg Delivery Date and Quantity Fixed Show values
fsh_vas_rel VAS Relevant Show values
lfsta Delivery Status (Item) Show values
xchpf Batch Management Requirement Indicator for Plant Show values
sgt_stk_prt Stock Protection Indicator [Obsolete] Show values
Column Name Description Domain name
werks Plant (Own or External) WERKS
sgt_rcat Requirement Segment SGT_SRCA
grkor Delivery Group (Items are delivered together) GRKOR
uepos Higher-Level Item in Bill of Material Structures POSNR
stlnr Bill of Material STNUM
sposn BOM Item Number SPOSN
fsh_vas_prnt_id Item number of the SD document POSNR
fsh_transaction Transaction Number FSH_TRANSACTION
fsh_item_group Item Group FSH_ITEM_GROUP
fsh_item Item Number FSH_ITEM
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
VBFA null
BDBS null
fsh_grid_cond_rec Grid Condition Record Number CHAR32
Master Data Relations Join Conditions
Requirements type
  • Client
  • Requirements type
  • ARUN_SO_REQ1.MANDT == T459A.MANDT
  • ARUN_SO_REQ1.BEDAE == T459A.BEDAE
Batch Number
  • Batch Number
  • Material Number
  • Client
  • Plant (Own or External)
  • ARUN_SO_REQ1.CHARG == MCHA.CHARG
  • ARUN_SO_REQ1.MATNR == MCHA.MATNR
  • ARUN_SO_REQ1.MANDT == MCHA.MANDT
  • ARUN_SO_REQ1.WERKS == MCHA.WERKS
MRP type
  • MRP Type
  • Client
  • ARUN_SO_REQ1.DISMM == T438A.DISMM
  • ARUN_SO_REQ1.MANDT == T438A.MANDT
Fashion Collection
  • Season Year
  • Client
  • Fashion Collection
  • Season
Season
  • Season Year
  • Client
  • Season
Season Year
  • Season Year
  • Client
  • Season
Fashion Theme
  • Fashion Theme
  • Season Year
  • Client
  • Fashion Collection
  • Season
  • ARUN_SO_REQ1.FSH_THEME == FSH_THEMES.FSH_THEME
  • ARUN_SO_REQ1.FSH_SEASON_YEAR == FSH_THEMES.FSH_SEASON_YEAR
  • ARUN_SO_REQ1.MANDT == FSH_THEMES.MANDT
  • ARUN_SO_REQ1.FSH_COLLECTION == FSH_THEMES.FSH_COLLECTION
  • ARUN_SO_REQ1.FSH_SEASON == FSH_THEMES.FSH_SEASON
Storage location
  • Client
  • Plant (Own or External)
  • Storage location
  • ARUN_SO_REQ1.MANDT == T001L.MANDT
  • ARUN_SO_REQ1.WERKS == T001L.WERKS
  • ARUN_SO_REQ1.LGORT == T001L.LGORT
Delivery Priority
  • Delivery Priority
  • Client
  • ARUN_SO_REQ1.LPRIO == TPRIO.LPRIO
  • ARUN_SO_REQ1.MANDT == TPRIO.MANDT
Material Group
  • Client
  • Material Group
  • ARUN_SO_REQ1.MANDT == T023.MANDT
  • ARUN_SO_REQ1.MATKL == T023.MATKL
Material: order item
  • Material Number
  • Client
  • ARUN_SO_REQ1.MATNR == MARA.MATNR
  • ARUN_SO_REQ1.MANDT == MARA.MANDT
Base Unit of Measure
  • Client
  • Base Unit of Measure
  • ARUN_SO_REQ1.MANDT == T006.MANDT
  • ARUN_SO_REQ1.MEINS == T006.MSEHI
Division
  • Client
  • Division
  • ARUN_SO_REQ1.MANDT == TSPA.MANDT
  • ARUN_SO_REQ1.MSPART == TSPA.SPART
Material Group 1
  • Client
  • Material Group 1
  • ARUN_SO_REQ1.MANDT == TVM1.MANDT
  • ARUN_SO_REQ1.MVGR1 == TVM1.MVGR1
Sales document item category
  • Client
  • Sales document item category
  • ARUN_SO_REQ1.MANDT == TVPT.MANDT
  • ARUN_SO_REQ1.PSTYV == TVPT.PSTYV
Cross-Plant Configurable Material
  • Client
  • Cross-Plant Configurable Material
  • ARUN_SO_REQ1.MANDT == MARA.MANDT
  • ARUN_SO_REQ1.SATNR == MARA.MATNR
Segmentation Strategy
  • ?
  • Client
  • Segmentation Strategy
Special Stock Indicator
  • Client
  • Special Stock Indicator
  • ARUN_SO_REQ1.MANDT == T148.MANDT
  • ARUN_SO_REQ1.SOBKZ == T148.SOBKZ
Shipping Point / Receiving Point
  • Shipping Point / Receiving Point
  • Client
  • ARUN_SO_REQ1.VSTEL == TVST.VSTEL
  • ARUN_SO_REQ1.MANDT == TVST.MANDT