I_ProductSeasonsTP

Product BO Seasons (Draft) | view: IPRODSEASONSTP | TRAN | Extraction: Not supported | Component: Material Master

Tables used: FSH_SEASONS_MAT, FSH_SEASONS_MAT, MARA, RFM_SEASONS

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

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

Column Name	Description

Column Name	Description

Column Name	Description

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
Cross-Plant Configurable Material Client Cross-Plant Configurable Material	`I_PRODUCTSEASONSTP.MANDT == MARA.MANDT` `I_PRODUCTSEASONSTP.CROSSPLANTCONFIGURABLEPRODUCT == MARA.MATNR`
Fashion Collection Client Season Year Season Year Fashion Collection Fashion Collection Fashion Collection Season Season Season	`I_PRODUCTSEASONSTP.MANDT == FSH_COLLECTIONS.MANDT` `I_PRODUCTSEASONSTP.PRODUCTSEASONYEARFOREDIT == FSH_COLLECTIONS.FSH_SEASON_YEAR` `I_PRODUCTSEASONSTP.PRODUCTSEASONYEAR == FSH_COLLECTIONS.FSH_SEASON_YEAR` `I_PRODUCTSEASONSTP.PRODUCTCOLLECTIONFORCREATE == FSH_COLLECTIONS.FSH_COLLECTION` `I_PRODUCTSEASONSTP.PRODUCTCOLLECTION == FSH_COLLECTIONS.FSH_COLLECTION` `I_PRODUCTSEASONSTP.PRODUCTCOLLECTIONFOREDIT == FSH_COLLECTIONS.FSH_COLLECTION` `I_PRODUCTSEASONSTP.PRODUCTSEASON == FSH_COLLECTIONS.FSH_SEASON` `I_PRODUCTSEASONSTP.PRODUCTSEASONFORCREATE == FSH_COLLECTIONS.FSH_SEASON` `I_PRODUCTSEASONSTP.PRODUCTSEASONFOREDIT == FSH_COLLECTIONS.FSH_SEASON`
Fashion Collection Client Season Year Season Year Fashion Collection Fashion Collection Fashion Collection Season Season Season	`I_PRODUCTSEASONSTP.MANDT == FSH_COLLECTIONS.MANDT` `I_PRODUCTSEASONSTP.PRODUCTSEASONYEARFOREDIT == FSH_COLLECTIONS.FSH_SEASON_YEAR` `I_PRODUCTSEASONSTP.PRODUCTSEASONYEAR == FSH_COLLECTIONS.FSH_SEASON_YEAR` `I_PRODUCTSEASONSTP.PRODUCTCOLLECTIONFORCREATE == FSH_COLLECTIONS.FSH_COLLECTION` `I_PRODUCTSEASONSTP.PRODUCTCOLLECTION == FSH_COLLECTIONS.FSH_COLLECTION` `I_PRODUCTSEASONSTP.PRODUCTCOLLECTIONFOREDIT == FSH_COLLECTIONS.FSH_COLLECTION` `I_PRODUCTSEASONSTP.PRODUCTSEASON == FSH_COLLECTIONS.FSH_SEASON` `I_PRODUCTSEASONSTP.PRODUCTSEASONFORCREATE == FSH_COLLECTIONS.FSH_SEASON` `I_PRODUCTSEASONSTP.PRODUCTSEASONFOREDIT == FSH_COLLECTIONS.FSH_SEASON`
Fashion Collection Client Season Year Season Year Fashion Collection Fashion Collection Fashion Collection Season Season Season	`I_PRODUCTSEASONSTP.MANDT == FSH_COLLECTIONS.MANDT` `I_PRODUCTSEASONSTP.PRODUCTSEASONYEARFOREDIT == FSH_COLLECTIONS.FSH_SEASON_YEAR` `I_PRODUCTSEASONSTP.PRODUCTSEASONYEAR == FSH_COLLECTIONS.FSH_SEASON_YEAR` `I_PRODUCTSEASONSTP.PRODUCTCOLLECTIONFORCREATE == FSH_COLLECTIONS.FSH_COLLECTION` `I_PRODUCTSEASONSTP.PRODUCTCOLLECTION == FSH_COLLECTIONS.FSH_COLLECTION` `I_PRODUCTSEASONSTP.PRODUCTCOLLECTIONFOREDIT == FSH_COLLECTIONS.FSH_COLLECTION` `I_PRODUCTSEASONSTP.PRODUCTSEASON == FSH_COLLECTIONS.FSH_SEASON` `I_PRODUCTSEASONSTP.PRODUCTSEASONFORCREATE == FSH_COLLECTIONS.FSH_SEASON` `I_PRODUCTSEASONSTP.PRODUCTSEASONFOREDIT == FSH_COLLECTIONS.FSH_SEASON`
Season Client Season Year Season Year Season Season Season	`I_PRODUCTSEASONSTP.MANDT == FSH_SEASONS.MANDT` `I_PRODUCTSEASONSTP.PRODUCTSEASONYEARFOREDIT == FSH_SEASONS.FSH_SEASON_YEAR` `I_PRODUCTSEASONSTP.PRODUCTSEASONYEAR == FSH_SEASONS.FSH_SEASON_YEAR` `I_PRODUCTSEASONSTP.PRODUCTSEASON == FSH_SEASONS.FSH_SEASON` `I_PRODUCTSEASONSTP.PRODUCTSEASONFORCREATE == FSH_SEASONS.FSH_SEASON` `I_PRODUCTSEASONSTP.PRODUCTSEASONFOREDIT == FSH_SEASONS.FSH_SEASON`
Season Client Season Year Season Year Season Season Season	`I_PRODUCTSEASONSTP.MANDT == FSH_SEASONS.MANDT` `I_PRODUCTSEASONSTP.PRODUCTSEASONYEARFOREDIT == FSH_SEASONS.FSH_SEASON_YEAR` `I_PRODUCTSEASONSTP.PRODUCTSEASONYEAR == FSH_SEASONS.FSH_SEASON_YEAR` `I_PRODUCTSEASONSTP.PRODUCTSEASON == FSH_SEASONS.FSH_SEASON` `I_PRODUCTSEASONSTP.PRODUCTSEASONFORCREATE == FSH_SEASONS.FSH_SEASON` `I_PRODUCTSEASONSTP.PRODUCTSEASONFOREDIT == FSH_SEASONS.FSH_SEASON`
Season Client Season Year Season Year Season Season Season	`I_PRODUCTSEASONSTP.MANDT == FSH_SEASONS.MANDT` `I_PRODUCTSEASONSTP.PRODUCTSEASONYEARFOREDIT == FSH_SEASONS.FSH_SEASON_YEAR` `I_PRODUCTSEASONSTP.PRODUCTSEASONYEAR == FSH_SEASONS.FSH_SEASON_YEAR` `I_PRODUCTSEASONSTP.PRODUCTSEASON == FSH_SEASONS.FSH_SEASON` `I_PRODUCTSEASONSTP.PRODUCTSEASONFORCREATE == FSH_SEASONS.FSH_SEASON` `I_PRODUCTSEASONSTP.PRODUCTSEASONFOREDIT == FSH_SEASONS.FSH_SEASON`
Season Year Client Season Year Season Year Season Season Season	`I_PRODUCTSEASONSTP.MANDT == FSH_SEASONS.MANDT` `I_PRODUCTSEASONSTP.PRODUCTSEASONYEARFOREDIT == FSH_SEASONS.FSH_SEASON_YEAR` `I_PRODUCTSEASONSTP.PRODUCTSEASONYEAR == FSH_SEASONS.FSH_SEASON_YEAR` `I_PRODUCTSEASONSTP.PRODUCTSEASON == FSH_SEASONS.FSH_SEASON` `I_PRODUCTSEASONSTP.PRODUCTSEASONFORCREATE == FSH_SEASONS.FSH_SEASON` `I_PRODUCTSEASONSTP.PRODUCTSEASONFOREDIT == FSH_SEASONS.FSH_SEASON`
Season Year Client Season Year Season Year Season Season Season	`I_PRODUCTSEASONSTP.MANDT == FSH_SEASONS.MANDT` `I_PRODUCTSEASONSTP.PRODUCTSEASONYEARFOREDIT == FSH_SEASONS.FSH_SEASON_YEAR` `I_PRODUCTSEASONSTP.PRODUCTSEASONYEAR == FSH_SEASONS.FSH_SEASON_YEAR` `I_PRODUCTSEASONSTP.PRODUCTSEASON == FSH_SEASONS.FSH_SEASON` `I_PRODUCTSEASONSTP.PRODUCTSEASONFORCREATE == FSH_SEASONS.FSH_SEASON` `I_PRODUCTSEASONSTP.PRODUCTSEASONFOREDIT == FSH_SEASONS.FSH_SEASON`
Fashion Theme Fashion Theme Fashion Theme Fashion Theme Client Season Year Season Year Fashion Collection Fashion Collection Fashion Collection Season Season Season	`I_PRODUCTSEASONSTP.PRODUCTTHEMEFOREDIT == FSH_THEMES.FSH_THEME` `I_PRODUCTSEASONSTP.PRODUCTTHEME == FSH_THEMES.FSH_THEME` `I_PRODUCTSEASONSTP.PRODUCTTHEMEFORCREATE == FSH_THEMES.FSH_THEME` `I_PRODUCTSEASONSTP.MANDT == FSH_THEMES.MANDT` `I_PRODUCTSEASONSTP.PRODUCTSEASONYEARFOREDIT == FSH_THEMES.FSH_SEASON_YEAR` `I_PRODUCTSEASONSTP.PRODUCTSEASONYEAR == FSH_THEMES.FSH_SEASON_YEAR` `I_PRODUCTSEASONSTP.PRODUCTCOLLECTIONFORCREATE == FSH_THEMES.FSH_COLLECTION` `I_PRODUCTSEASONSTP.PRODUCTCOLLECTION == FSH_THEMES.FSH_COLLECTION` `I_PRODUCTSEASONSTP.PRODUCTCOLLECTIONFOREDIT == FSH_THEMES.FSH_COLLECTION` `I_PRODUCTSEASONSTP.PRODUCTSEASON == FSH_THEMES.FSH_SEASON` `I_PRODUCTSEASONSTP.PRODUCTSEASONFORCREATE == FSH_THEMES.FSH_SEASON` `I_PRODUCTSEASONSTP.PRODUCTSEASONFOREDIT == FSH_THEMES.FSH_SEASON`
Fashion Theme Fashion Theme Fashion Theme Fashion Theme Client Season Year Season Year Fashion Collection Fashion Collection Fashion Collection Season Season Season	`I_PRODUCTSEASONSTP.PRODUCTTHEMEFOREDIT == FSH_THEMES.FSH_THEME` `I_PRODUCTSEASONSTP.PRODUCTTHEME == FSH_THEMES.FSH_THEME` `I_PRODUCTSEASONSTP.PRODUCTTHEMEFORCREATE == FSH_THEMES.FSH_THEME` `I_PRODUCTSEASONSTP.MANDT == FSH_THEMES.MANDT` `I_PRODUCTSEASONSTP.PRODUCTSEASONYEARFOREDIT == FSH_THEMES.FSH_SEASON_YEAR` `I_PRODUCTSEASONSTP.PRODUCTSEASONYEAR == FSH_THEMES.FSH_SEASON_YEAR` `I_PRODUCTSEASONSTP.PRODUCTCOLLECTIONFORCREATE == FSH_THEMES.FSH_COLLECTION` `I_PRODUCTSEASONSTP.PRODUCTCOLLECTION == FSH_THEMES.FSH_COLLECTION` `I_PRODUCTSEASONSTP.PRODUCTCOLLECTIONFOREDIT == FSH_THEMES.FSH_COLLECTION` `I_PRODUCTSEASONSTP.PRODUCTSEASON == FSH_THEMES.FSH_SEASON` `I_PRODUCTSEASONSTP.PRODUCTSEASONFORCREATE == FSH_THEMES.FSH_SEASON` `I_PRODUCTSEASONSTP.PRODUCTSEASONFOREDIT == FSH_THEMES.FSH_SEASON`
Fashion Theme Fashion Theme Fashion Theme Fashion Theme Client Season Year Season Year Fashion Collection Fashion Collection Fashion Collection Season Season Season	`I_PRODUCTSEASONSTP.PRODUCTTHEMEFOREDIT == FSH_THEMES.FSH_THEME` `I_PRODUCTSEASONSTP.PRODUCTTHEME == FSH_THEMES.FSH_THEME` `I_PRODUCTSEASONSTP.PRODUCTTHEMEFORCREATE == FSH_THEMES.FSH_THEME` `I_PRODUCTSEASONSTP.MANDT == FSH_THEMES.MANDT` `I_PRODUCTSEASONSTP.PRODUCTSEASONYEARFOREDIT == FSH_THEMES.FSH_SEASON_YEAR` `I_PRODUCTSEASONSTP.PRODUCTSEASONYEAR == FSH_THEMES.FSH_SEASON_YEAR` `I_PRODUCTSEASONSTP.PRODUCTCOLLECTIONFORCREATE == FSH_THEMES.FSH_COLLECTION` `I_PRODUCTSEASONSTP.PRODUCTCOLLECTION == FSH_THEMES.FSH_COLLECTION` `I_PRODUCTSEASONSTP.PRODUCTCOLLECTIONFOREDIT == FSH_THEMES.FSH_COLLECTION` `I_PRODUCTSEASONSTP.PRODUCTSEASON == FSH_THEMES.FSH_SEASON` `I_PRODUCTSEASONSTP.PRODUCTSEASONFORCREATE == FSH_THEMES.FSH_SEASON` `I_PRODUCTSEASONSTP.PRODUCTSEASONFOREDIT == FSH_THEMES.FSH_SEASON`