rfm_scc_salesorder_data_basic

Get Sales Order Data | view: RFMSCCSOBASICV | 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 (2)
💰 Amounts
∑ Quantities (1)
📅 Dates (2)
☰ Categorical (2)
Other (26)
🔗 Relations (18)

Column Name	Description
vbeln FK	Sales Document
posnr	Sales Document Item

Column Name	Description

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

Column Name	Description
fsh_candate	Cancellation Date
edatu	Schedule line date

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

Column Name	Description	Domain name
season_priority	Priority	RFM_PRIORITY
seasoncategory_text	Season Category Text	RFM_SEASON_CATEGORY_TEXT
seasoncompletenessindicatortxt	Short Text for Fixed Values	DDTEXT
werks	Plant (Own or External)	WERKS
size1	Characteristic Value for Main Sizes of Variants	WRF_ATWRT
size2	Characteristic Value for Second Size for Variants	WRF_ATWRT
color	Characteristic Value for Colors of Variants	WRF_ATWRT
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
shiptoparty	Customer Number	KUNNR
sgt_rcat	Requirement Segment	SGT_SRCA
attyp_text	Product Category Text	DDTEXT
maktx	Product Description	TEXT40
matkl_wgbez	Product Group Description	TEXT20
mtart_mtbez	Description of product type	TEXT25
vkorg_vtxtk	Name	TEXT20
vtweg_vtxtk	Name	TEXT20
spart_vtxtk	Name	TEXT20
werks_name1	Name	TEXT30
kunnr_name1	Name of Customer	TEXT80
shiptoparty_name1	Name of Customer	TEXT80
rfm_season_text	Name of Season, Collection, or Theme	FSH_DPRG_TEXT
rfm_collection_text	Name of Season, Collection, or Theme	FSH_DPRG_TEXT
rfm_theme_text	Name of Season, Collection, or Theme	FSH_DPRG_TEXT
auart_bezei	Sales Document Type Description	TEXT20

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