rfm_scc_salesorder_data

Get sales order data | view: RFMSCCSALESORDV | Extraction: Not supported | Component: Season

Tables used: VBAK, VBAP, VBEP, VBPA, KNA1, T002, MAKT, T023T, T134T, WRF_CHARVALT, MARA, T001W, TSPAT, TVAKT, TVKOT, TVTWT, RFM_SEASONS, RFM_SEASONS_T, RFM_SEASONS, RFM_SEA_CATGRY_T

🔑 Keys (47)
💰 Amounts
∑ Quantities (1)
📅 Dates (2)
☰ Categorical (2)
Other
🔗 Relations (18)

Column Name	Description
vbeln FK	Sales Document
posnr	Sales Document Item
kunnr FK	Sold-to Party
auart FK	Sales Document Type
vkorg FK	Sales Organization
vtweg FK	Distribution Channel
fsh_candate	Cancellation Date
vkorg_vtxtk	Name
vtweg_vtxtk	Name
fsh_season_year FK	Season Year
fsh_season FK	Season
fsh_collection FK	Fashion Collection
fsh_theme FK	Fashion Theme
matnr FK	Material Number
kwmeng	Cumulative order quantity in sales units
vrkme FK	Sales unit
werks	Plant (Own or External)
spart FK	Division
spart_vtxtk	Name
werks_name1	Name
kunnr_name1	Name of Customer
shiptoparty	Customer Number
shiptoparty_name1	Name of Customer
edatu	null
rfm_season_text	Name of Season, Collection, or Theme
size1	Characteristic Value for Main Sizes of Variants
size2	Characteristic Value for Second Size for Variants
color	Characteristic Value for Colors of Variants
mtart FK	Material type
matkl FK	Material Group
maktx	Product Description
color_desc FK	Characteristic Value (Seasonal Procurement)
size1_desc FK	Characteristic Value (Seasonal Procurement)
size2_desc FK	Characteristic Value (Seasonal Procurement)
mtart_mtbez	Description of product type
matkl_wgbez	Product Group Description
attyp	Material Category	Show values
attyp_text	Product Category Text
auart_bezei	Sales Document Type Description
rfm_collection_text	Name of Season, Collection, or Theme
rfm_theme_text	Name of Season, Collection, or Theme
sgt_rcat	Requirement Segment
seasoncategory FK	Season Category
seasoncategory_text	Season Category Text
season_priority	Priority
seasoncompletenessindicator	Season Completeness Indicator	Show values
seasoncompletenessindicatortxt	Short Text for Fixed Values

Column Name	Description

Column Name	Description
📏 Sales unit (vrkme):
kwmeng	Cumulative order quantity in sales units

Column Name	Description
fsh_candate	Cancellation Date
edatu	null

Column Name	Description
attyp	Material Category	Show values
seasoncompletenessindicator	Season Completeness Indicator	Show values

Column Name	Description	Domain name

Master Data Relations	Join Conditions
Order type in order header Client Sales Document Type	`RFM_SCC_SALESORDER_DATA.MANDT == TVAK.MANDT` `RFM_SCC_SALESORDER_DATA.AUART == TVAK.AUART`
Characteristic Value (Seasonal Procurement) ? Characteristic Value (Seasonal Procurement) Characteristic Value (Seasonal Procurement) Characteristic Value (Seasonal Procurement) Client	`RFM_SCC_SALESORDER_DATA.[column in domain "ATINN"] == WRF_CHARVAL.ATINN` `RFM_SCC_SALESORDER_DATA.COLOR_DESC == WRF_CHARVAL.ATWRT` `RFM_SCC_SALESORDER_DATA.SIZE1_DESC == WRF_CHARVAL.ATWRT` `RFM_SCC_SALESORDER_DATA.SIZE2_DESC == WRF_CHARVAL.ATWRT` `RFM_SCC_SALESORDER_DATA.MANDT == WRF_CHARVAL.MANDT`
Fashion Collection Fashion Collection Season Client Season Year	`RFM_SCC_SALESORDER_DATA.FSH_COLLECTION == FSH_COLLECTIONS.FSH_COLLECTION` `RFM_SCC_SALESORDER_DATA.FSH_SEASON == FSH_COLLECTIONS.FSH_SEASON` `RFM_SCC_SALESORDER_DATA.MANDT == FSH_COLLECTIONS.MANDT` `RFM_SCC_SALESORDER_DATA.FSH_SEASON_YEAR == FSH_COLLECTIONS.FSH_SEASON_YEAR`
Season Season Client Season Year	`RFM_SCC_SALESORDER_DATA.FSH_SEASON == FSH_SEASONS.FSH_SEASON` `RFM_SCC_SALESORDER_DATA.MANDT == FSH_SEASONS.MANDT` `RFM_SCC_SALESORDER_DATA.FSH_SEASON_YEAR == FSH_SEASONS.FSH_SEASON_YEAR`
Season Year Season Client Season Year	`RFM_SCC_SALESORDER_DATA.FSH_SEASON == FSH_SEASONS.FSH_SEASON` `RFM_SCC_SALESORDER_DATA.MANDT == FSH_SEASONS.MANDT` `RFM_SCC_SALESORDER_DATA.FSH_SEASON_YEAR == FSH_SEASONS.FSH_SEASON_YEAR`
Fashion Theme Fashion Collection Season Fashion Theme Client Season Year	`RFM_SCC_SALESORDER_DATA.FSH_COLLECTION == FSH_THEMES.FSH_COLLECTION` `RFM_SCC_SALESORDER_DATA.FSH_SEASON == FSH_THEMES.FSH_SEASON` `RFM_SCC_SALESORDER_DATA.FSH_THEME == FSH_THEMES.FSH_THEME` `RFM_SCC_SALESORDER_DATA.MANDT == FSH_THEMES.MANDT` `RFM_SCC_SALESORDER_DATA.FSH_SEASON_YEAR == FSH_THEMES.FSH_SEASON_YEAR`
Sold-to Party Client Sold-to Party	`RFM_SCC_SALESORDER_DATA.MANDT == KNA1.MANDT` `RFM_SCC_SALESORDER_DATA.KUNNR == KNA1.KUNNR`
Material Group Client Material Group	`RFM_SCC_SALESORDER_DATA.MANDT == T023.MANDT` `RFM_SCC_SALESORDER_DATA.MATKL == T023.MATKL`
Material: order item Client Material Number	`RFM_SCC_SALESORDER_DATA.MANDT == MARA.MANDT` `RFM_SCC_SALESORDER_DATA.MATNR == MARA.MATNR`
Material type Material type Client	`RFM_SCC_SALESORDER_DATA.MTART == T134.MTART` `RFM_SCC_SALESORDER_DATA.MANDT == T134.MANDT`
Season Category Client Season Category	`RFM_SCC_SALESORDER_DATA.MANDT == RFM_SEA_CATGRY.MANDT` `RFM_SCC_SALESORDER_DATA.SEASONCATEGORY == RFM_SEA_CATGRY.RFM_SEASON_CATEGORY`
Characteristic Value (Seasonal Procurement) ? Characteristic Value (Seasonal Procurement) Characteristic Value (Seasonal Procurement) Characteristic Value (Seasonal Procurement) Client	`RFM_SCC_SALESORDER_DATA.[column in domain "ATINN"] == WRF_CHARVAL.ATINN` `RFM_SCC_SALESORDER_DATA.COLOR_DESC == WRF_CHARVAL.ATWRT` `RFM_SCC_SALESORDER_DATA.SIZE1_DESC == WRF_CHARVAL.ATWRT` `RFM_SCC_SALESORDER_DATA.SIZE2_DESC == WRF_CHARVAL.ATWRT` `RFM_SCC_SALESORDER_DATA.MANDT == WRF_CHARVAL.MANDT`
Characteristic Value (Seasonal Procurement) ? Characteristic Value (Seasonal Procurement) Characteristic Value (Seasonal Procurement) Characteristic Value (Seasonal Procurement) Client	`RFM_SCC_SALESORDER_DATA.[column in domain "ATINN"] == WRF_CHARVAL.ATINN` `RFM_SCC_SALESORDER_DATA.COLOR_DESC == WRF_CHARVAL.ATWRT` `RFM_SCC_SALESORDER_DATA.SIZE1_DESC == WRF_CHARVAL.ATWRT` `RFM_SCC_SALESORDER_DATA.SIZE2_DESC == WRF_CHARVAL.ATWRT` `RFM_SCC_SALESORDER_DATA.MANDT == WRF_CHARVAL.MANDT`
Division Client Division	`RFM_SCC_SALESORDER_DATA.MANDT == TSPA.MANDT` `RFM_SCC_SALESORDER_DATA.SPART == TSPA.SPART`
Sales organization in order header Client Sales Organization	`RFM_SCC_SALESORDER_DATA.MANDT == TVKO.MANDT` `RFM_SCC_SALESORDER_DATA.VKORG == TVKO.VKORG`
Sales unit Client Sales unit	`RFM_SCC_SALESORDER_DATA.MANDT == T006.MANDT` `RFM_SCC_SALESORDER_DATA.VRKME == T006.MSEHI`
Distribution channel in order header Client Sales Organization Distribution Channel	`RFM_SCC_SALESORDER_DATA.MANDT == TVKOV.MANDT` `RFM_SCC_SALESORDER_DATA.VKORG == TVKOV.VKORG` `RFM_SCC_SALESORDER_DATA.VTWEG == TVKOV.VTWEG`