C_ProductSeasons

Consumption - Product Seasons | view: CPRODSEASONS | Extraction: Not supported | Component: Material Master

Tables used: FSH_SEASONS_MAT, FSH_SEASONS_MAT, MARA, RFM_SEASONS

🔑 Keys (6)
💰 Amounts
∑ Quantities
📅 Dates (2)
☰ Categorical (3)
Other (1)
🔗 Relations (11)

Column Name	Description
Product	Material Number
ProductCollection FK	Fashion Collection
ProductSeason FK	Season
ProductTheme FK	Fashion Theme
ProductSeasonYear FK	Season Year
RequirementSegment	Requirement Segment

Column Name	Description

Column Name	Description

Column Name	Description
ProductSeasonValidFrom	Valid From Date
ProductSeasonValidTo	Valid To Date

Column Name	Description
IsProductSeasonType1	Season Type 1	Show values
IsProductSeasonType2	Season Type 2	Show values
IsProductSeasonType3	Season Type 3	Show values

Column Name	Description	Domain name
ProductSeasonName	Description of Season Assigned to Article	FSH_ARTICLE_SEASON_DESC

Master Data Relations	Join Conditions
Fashion Collection Season Season Season Client Fashion Collection Fashion Collection Fashion Collection Season Year Season Year	`C_PRODUCTSEASONS.PRODUCTSEASON == FSH_COLLECTIONS.FSH_SEASON` `C_PRODUCTSEASONS.PRODUCTSEASONFOREDIT == FSH_COLLECTIONS.FSH_SEASON` `C_PRODUCTSEASONS.PRODUCTSEASONFORCREATE == FSH_COLLECTIONS.FSH_SEASON` `C_PRODUCTSEASONS.MANDT == FSH_COLLECTIONS.MANDT` `C_PRODUCTSEASONS.PRODUCTCOLLECTION == FSH_COLLECTIONS.FSH_COLLECTION` `C_PRODUCTSEASONS.PRODUCTCOLLECTIONFORCREATE == FSH_COLLECTIONS.FSH_COLLECTION` `C_PRODUCTSEASONS.PRODUCTCOLLECTIONFOREDIT == FSH_COLLECTIONS.FSH_COLLECTION` `C_PRODUCTSEASONS.PRODUCTSEASONYEARFOREDIT == FSH_COLLECTIONS.FSH_SEASON_YEAR` `C_PRODUCTSEASONS.PRODUCTSEASONYEAR == FSH_COLLECTIONS.FSH_SEASON_YEAR`
Fashion Collection Season Season Season Client Fashion Collection Fashion Collection Fashion Collection Season Year Season Year	`C_PRODUCTSEASONS.PRODUCTSEASON == FSH_COLLECTIONS.FSH_SEASON` `C_PRODUCTSEASONS.PRODUCTSEASONFOREDIT == FSH_COLLECTIONS.FSH_SEASON` `C_PRODUCTSEASONS.PRODUCTSEASONFORCREATE == FSH_COLLECTIONS.FSH_SEASON` `C_PRODUCTSEASONS.MANDT == FSH_COLLECTIONS.MANDT` `C_PRODUCTSEASONS.PRODUCTCOLLECTION == FSH_COLLECTIONS.FSH_COLLECTION` `C_PRODUCTSEASONS.PRODUCTCOLLECTIONFORCREATE == FSH_COLLECTIONS.FSH_COLLECTION` `C_PRODUCTSEASONS.PRODUCTCOLLECTIONFOREDIT == FSH_COLLECTIONS.FSH_COLLECTION` `C_PRODUCTSEASONS.PRODUCTSEASONYEARFOREDIT == FSH_COLLECTIONS.FSH_SEASON_YEAR` `C_PRODUCTSEASONS.PRODUCTSEASONYEAR == FSH_COLLECTIONS.FSH_SEASON_YEAR`
Fashion Collection Season Season Season Client Fashion Collection Fashion Collection Fashion Collection Season Year Season Year	`C_PRODUCTSEASONS.PRODUCTSEASON == FSH_COLLECTIONS.FSH_SEASON` `C_PRODUCTSEASONS.PRODUCTSEASONFOREDIT == FSH_COLLECTIONS.FSH_SEASON` `C_PRODUCTSEASONS.PRODUCTSEASONFORCREATE == FSH_COLLECTIONS.FSH_SEASON` `C_PRODUCTSEASONS.MANDT == FSH_COLLECTIONS.MANDT` `C_PRODUCTSEASONS.PRODUCTCOLLECTION == FSH_COLLECTIONS.FSH_COLLECTION` `C_PRODUCTSEASONS.PRODUCTCOLLECTIONFORCREATE == FSH_COLLECTIONS.FSH_COLLECTION` `C_PRODUCTSEASONS.PRODUCTCOLLECTIONFOREDIT == FSH_COLLECTIONS.FSH_COLLECTION` `C_PRODUCTSEASONS.PRODUCTSEASONYEARFOREDIT == FSH_COLLECTIONS.FSH_SEASON_YEAR` `C_PRODUCTSEASONS.PRODUCTSEASONYEAR == FSH_COLLECTIONS.FSH_SEASON_YEAR`
Season Season Season Season Client Season Year Season Year	`C_PRODUCTSEASONS.PRODUCTSEASON == FSH_SEASONS.FSH_SEASON` `C_PRODUCTSEASONS.PRODUCTSEASONFOREDIT == FSH_SEASONS.FSH_SEASON` `C_PRODUCTSEASONS.PRODUCTSEASONFORCREATE == FSH_SEASONS.FSH_SEASON` `C_PRODUCTSEASONS.MANDT == FSH_SEASONS.MANDT` `C_PRODUCTSEASONS.PRODUCTSEASONYEARFOREDIT == FSH_SEASONS.FSH_SEASON_YEAR` `C_PRODUCTSEASONS.PRODUCTSEASONYEAR == FSH_SEASONS.FSH_SEASON_YEAR`
Season Season Season Season Client Season Year Season Year	`C_PRODUCTSEASONS.PRODUCTSEASON == FSH_SEASONS.FSH_SEASON` `C_PRODUCTSEASONS.PRODUCTSEASONFOREDIT == FSH_SEASONS.FSH_SEASON` `C_PRODUCTSEASONS.PRODUCTSEASONFORCREATE == FSH_SEASONS.FSH_SEASON` `C_PRODUCTSEASONS.MANDT == FSH_SEASONS.MANDT` `C_PRODUCTSEASONS.PRODUCTSEASONYEARFOREDIT == FSH_SEASONS.FSH_SEASON_YEAR` `C_PRODUCTSEASONS.PRODUCTSEASONYEAR == FSH_SEASONS.FSH_SEASON_YEAR`
Season Season Season Season Client Season Year Season Year	`C_PRODUCTSEASONS.PRODUCTSEASON == FSH_SEASONS.FSH_SEASON` `C_PRODUCTSEASONS.PRODUCTSEASONFOREDIT == FSH_SEASONS.FSH_SEASON` `C_PRODUCTSEASONS.PRODUCTSEASONFORCREATE == FSH_SEASONS.FSH_SEASON` `C_PRODUCTSEASONS.MANDT == FSH_SEASONS.MANDT` `C_PRODUCTSEASONS.PRODUCTSEASONYEARFOREDIT == FSH_SEASONS.FSH_SEASON_YEAR` `C_PRODUCTSEASONS.PRODUCTSEASONYEAR == FSH_SEASONS.FSH_SEASON_YEAR`
Season Year Season Season Season Client Season Year Season Year	`C_PRODUCTSEASONS.PRODUCTSEASON == FSH_SEASONS.FSH_SEASON` `C_PRODUCTSEASONS.PRODUCTSEASONFOREDIT == FSH_SEASONS.FSH_SEASON` `C_PRODUCTSEASONS.PRODUCTSEASONFORCREATE == FSH_SEASONS.FSH_SEASON` `C_PRODUCTSEASONS.MANDT == FSH_SEASONS.MANDT` `C_PRODUCTSEASONS.PRODUCTSEASONYEARFOREDIT == FSH_SEASONS.FSH_SEASON_YEAR` `C_PRODUCTSEASONS.PRODUCTSEASONYEAR == FSH_SEASONS.FSH_SEASON_YEAR`
Season Year Season Season Season Client Season Year Season Year	`C_PRODUCTSEASONS.PRODUCTSEASON == FSH_SEASONS.FSH_SEASON` `C_PRODUCTSEASONS.PRODUCTSEASONFOREDIT == FSH_SEASONS.FSH_SEASON` `C_PRODUCTSEASONS.PRODUCTSEASONFORCREATE == FSH_SEASONS.FSH_SEASON` `C_PRODUCTSEASONS.MANDT == FSH_SEASONS.MANDT` `C_PRODUCTSEASONS.PRODUCTSEASONYEARFOREDIT == FSH_SEASONS.FSH_SEASON_YEAR` `C_PRODUCTSEASONS.PRODUCTSEASONYEAR == FSH_SEASONS.FSH_SEASON_YEAR`
Fashion Theme Season Season Season Fashion Theme Fashion Theme Fashion Theme Client Fashion Collection Fashion Collection Fashion Collection Season Year Season Year	`C_PRODUCTSEASONS.PRODUCTSEASON == FSH_THEMES.FSH_SEASON` `C_PRODUCTSEASONS.PRODUCTSEASONFOREDIT == FSH_THEMES.FSH_SEASON` `C_PRODUCTSEASONS.PRODUCTSEASONFORCREATE == FSH_THEMES.FSH_SEASON` `C_PRODUCTSEASONS.PRODUCTTHEMEFOREDIT == FSH_THEMES.FSH_THEME` `C_PRODUCTSEASONS.PRODUCTTHEME == FSH_THEMES.FSH_THEME` `C_PRODUCTSEASONS.PRODUCTTHEMEFORCREATE == FSH_THEMES.FSH_THEME` `C_PRODUCTSEASONS.MANDT == FSH_THEMES.MANDT` `C_PRODUCTSEASONS.PRODUCTCOLLECTION == FSH_THEMES.FSH_COLLECTION` `C_PRODUCTSEASONS.PRODUCTCOLLECTIONFORCREATE == FSH_THEMES.FSH_COLLECTION` `C_PRODUCTSEASONS.PRODUCTCOLLECTIONFOREDIT == FSH_THEMES.FSH_COLLECTION` `C_PRODUCTSEASONS.PRODUCTSEASONYEARFOREDIT == FSH_THEMES.FSH_SEASON_YEAR` `C_PRODUCTSEASONS.PRODUCTSEASONYEAR == FSH_THEMES.FSH_SEASON_YEAR`
Fashion Theme Season Season Season Fashion Theme Fashion Theme Fashion Theme Client Fashion Collection Fashion Collection Fashion Collection Season Year Season Year	`C_PRODUCTSEASONS.PRODUCTSEASON == FSH_THEMES.FSH_SEASON` `C_PRODUCTSEASONS.PRODUCTSEASONFOREDIT == FSH_THEMES.FSH_SEASON` `C_PRODUCTSEASONS.PRODUCTSEASONFORCREATE == FSH_THEMES.FSH_SEASON` `C_PRODUCTSEASONS.PRODUCTTHEMEFOREDIT == FSH_THEMES.FSH_THEME` `C_PRODUCTSEASONS.PRODUCTTHEME == FSH_THEMES.FSH_THEME` `C_PRODUCTSEASONS.PRODUCTTHEMEFORCREATE == FSH_THEMES.FSH_THEME` `C_PRODUCTSEASONS.MANDT == FSH_THEMES.MANDT` `C_PRODUCTSEASONS.PRODUCTCOLLECTION == FSH_THEMES.FSH_COLLECTION` `C_PRODUCTSEASONS.PRODUCTCOLLECTIONFORCREATE == FSH_THEMES.FSH_COLLECTION` `C_PRODUCTSEASONS.PRODUCTCOLLECTIONFOREDIT == FSH_THEMES.FSH_COLLECTION` `C_PRODUCTSEASONS.PRODUCTSEASONYEARFOREDIT == FSH_THEMES.FSH_SEASON_YEAR` `C_PRODUCTSEASONS.PRODUCTSEASONYEAR == FSH_THEMES.FSH_SEASON_YEAR`
Fashion Theme Season Season Season Fashion Theme Fashion Theme Fashion Theme Client Fashion Collection Fashion Collection Fashion Collection Season Year Season Year	`C_PRODUCTSEASONS.PRODUCTSEASON == FSH_THEMES.FSH_SEASON` `C_PRODUCTSEASONS.PRODUCTSEASONFOREDIT == FSH_THEMES.FSH_SEASON` `C_PRODUCTSEASONS.PRODUCTSEASONFORCREATE == FSH_THEMES.FSH_SEASON` `C_PRODUCTSEASONS.PRODUCTTHEMEFOREDIT == FSH_THEMES.FSH_THEME` `C_PRODUCTSEASONS.PRODUCTTHEME == FSH_THEMES.FSH_THEME` `C_PRODUCTSEASONS.PRODUCTTHEMEFORCREATE == FSH_THEMES.FSH_THEME` `C_PRODUCTSEASONS.MANDT == FSH_THEMES.MANDT` `C_PRODUCTSEASONS.PRODUCTCOLLECTION == FSH_THEMES.FSH_COLLECTION` `C_PRODUCTSEASONS.PRODUCTCOLLECTIONFORCREATE == FSH_THEMES.FSH_COLLECTION` `C_PRODUCTSEASONS.PRODUCTCOLLECTIONFOREDIT == FSH_THEMES.FSH_COLLECTION` `C_PRODUCTSEASONS.PRODUCTSEASONYEARFOREDIT == FSH_THEMES.FSH_SEASON_YEAR` `C_PRODUCTSEASONS.PRODUCTSEASONYEAR == FSH_THEMES.FSH_SEASON_YEAR`