I_SeasonSalesPeriod

Season sales periods basic view | view: ISEASONSDPERIOD | Extraction: Not supported | Component: Season

Tables used: FSH_SD_PERIODS

🔑 Keys (5)
💰 Amounts
∑ Quantities
📅 Dates (12)
☰ Categorical (2)
Other (2)
🔗 Relations (12)

Column Name	Description
ConditionRecord	Condition Record Number for Seasons
ProductSeasonYear FK	Season Year
ProductSeason FK	Season
ProductCollection FK	Fashion Collection
ProductTheme FK	Fashion Theme

Column Name	Description

Column Name	Description

Column Name	Description
DeliveryStartDate	Delivery Date From
DeliveryEndDate	Delivery Date To
OrderStartDate	Order Date From
OrderEndDate	Order Date To
StoreSaleStartDate	Store Date From
StoreSaleEndDate	Store Date To
ATPCheckStartDate	Starting Date with ATP
PreferredDeliveryDate	Preferred Delivery Date
CreationDate	Date on Which the Object Was Created
CreationTime	Time at Which the Object Was Created
LastChangeDate	Date on Which the Object Was Last Changed
LastChangeTime	Time at Which the Object Was Last Changed

Column Name	Description
ProposedDeliveryDate	Type for Delivery Date Proposal	Show values
DeliveryDateIsProposed	Delivery Date Check	Show values

Column Name	Description	Domain name
CreatedByUser	User Who Created the Object	USNAM
LastChangedByUser	Last User to Change the Object	USNAM

Master Data Relations	Join Conditions
Country/Region Key Country/Region Key Client	`I_SEASONSALESPERIOD.COUNTRY == T005.LAND1` `I_SEASONSALESPERIOD.MANDT == T005.MANDT`
Customer Group Client Customer Group	`I_SEASONSALESPERIOD.MANDT == T151.MANDT` `I_SEASONSALESPERIOD.CUSTOMERGROUP == T151.KDGRP`
Distribution Channel Client Sales Organization Distribution Channel	`I_SEASONSALESPERIOD.MANDT == TVKOV.MANDT` `I_SEASONSALESPERIOD.SALESORGANIZATION == TVKOV.VKORG` `I_SEASONSALESPERIOD.DISTRIBUTIONCHANNEL == TVKOV.VTWEG`
Partner Function Client Partner Function	`I_SEASONSALESPERIOD.MANDT == TPAR.MANDT` `I_SEASONSALESPERIOD.PARTNERFUNCTION == TPAR.PARVW`
Fashion Collection Fashion Collection Season Client Season Year	`I_SEASONSALESPERIOD.PRODUCTCOLLECTION == FSH_COLLECTIONS.FSH_COLLECTION` `I_SEASONSALESPERIOD.PRODUCTSEASON == FSH_COLLECTIONS.FSH_SEASON` `I_SEASONSALESPERIOD.MANDT == FSH_COLLECTIONS.MANDT` `I_SEASONSALESPERIOD.PRODUCTSEASONYEAR == FSH_COLLECTIONS.FSH_SEASON_YEAR`
Season Season Client Season Year	`I_SEASONSALESPERIOD.PRODUCTSEASON == FSH_SEASONS.FSH_SEASON` `I_SEASONSALESPERIOD.MANDT == FSH_SEASONS.MANDT` `I_SEASONSALESPERIOD.PRODUCTSEASONYEAR == FSH_SEASONS.FSH_SEASON_YEAR`
Season Year Season Client Season Year	`I_SEASONSALESPERIOD.PRODUCTSEASON == FSH_SEASONS.FSH_SEASON` `I_SEASONSALESPERIOD.MANDT == FSH_SEASONS.MANDT` `I_SEASONSALESPERIOD.PRODUCTSEASONYEAR == FSH_SEASONS.FSH_SEASON_YEAR`
Fashion Theme Fashion Collection Season Client Fashion Theme Season Year	`I_SEASONSALESPERIOD.PRODUCTCOLLECTION == FSH_THEMES.FSH_COLLECTION` `I_SEASONSALESPERIOD.PRODUCTSEASON == FSH_THEMES.FSH_SEASON` `I_SEASONSALESPERIOD.MANDT == FSH_THEMES.MANDT` `I_SEASONSALESPERIOD.PRODUCTTHEME == FSH_THEMES.FSH_THEME` `I_SEASONSALESPERIOD.PRODUCTSEASONYEAR == FSH_THEMES.FSH_SEASON_YEAR`
Region (State, Province, County) Region (State, Province, County) Country/Region Key Client	`I_SEASONSALESPERIOD.REGION == T005S.BLAND` `I_SEASONSALESPERIOD.COUNTRY == T005S.LAND1` `I_SEASONSALESPERIOD.MANDT == T005S.MANDT`
Sales District Client Sales District	`I_SEASONSALESPERIOD.MANDT == T171.MANDT` `I_SEASONSALESPERIOD.SALESDISTRICT == T171.BZIRK`
Sales Organization Client Sales Organization	`I_SEASONSALESPERIOD.MANDT == TVKO.MANDT` `I_SEASONSALESPERIOD.SALESORGANIZATION == TVKO.VKORG`
Customer Number Customer Number Client	`I_SEASONSALESPERIOD.SOLDTOPARTY == KNA1.KUNNR` `I_SEASONSALESPERIOD.MANDT == KNA1.MANDT`