FSH_SEASONS_MAT

Transparent Table Application Table
16 Fields 10 CDS Views

Table for Seasons In Material

FSH_SEASONS_MAT is an SAP database table in S/4HANA. Table for Seasons In Material. It contains 16 fields. 10 CDS views read from this table.

CDS Views using this table (10)

ViewTypeJoinVDMDescription
Fsh_Seasons_Mig_View view from View for migration of retail season
I_ProductSeasonsUnion view from BASIC Product Seasons Union
I_ProductSeasonsUnion view inner BASIC Product Seasons Union
I_ProductSeasonsUnion view union BASIC Product Seasons Union
I_SeasonProduct view from BASIC Season product basic view
RFM_MD_ARTICLE_SEA_ASSIGN view from RFM Article Season Assign View
RFM_MD_ARTICLE_SEA_BASIC_VIEW view left_outer RFM Article Season Basic View
RFM_SCC_SEASNID_KEYITM_ART_V view from CDS view for key item assigned to season
RFM_SCC_SEASONID_ARTICLE_V view from CDS view for article assigned to season
SHSM_FSH_VA_SEA_F4 view inner CDS replacing replacing FSH_VA_SEA_F4

Fields (16)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY matnr MATNR Material
KEY fsh_sgt SGT_RCAT Req. Segment
KEY fsh_season_year FSH_SAISJ Season Year
KEY fsh_season FSH_SAISO Season
KEY fsh_collection FSH_COLLECTION Collection
KEY fsh_theme FSH_THEME Theme
season1 FSH_SEA_TYP1 Season Type 1
season2 FSH_SEA_TYP2 Season Type 2
season3 FSH_SEA_TYP3 Season Type 3
destext FSH_ARTICLE_SEASON_DESC Description
sea_indicator FSH_SEA_INDICATOR Season Indicator
satnr SATNR Cross-plant CM
rfm_keyitem RFM_KEYITEM Key Item
sdm_version RFM_SDM_VERSION SDM Version
rfm_suid RFM_SUID Sea Int. Identifier

Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.

-- Table for Seasons In Material
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE FSH_SEASONS_MAT (
    MANDT,            -- Client [MANDT]
    MATNR,            -- Material [MATNR]
    FSH_SGT,          -- Req. Segment [SGT_RCAT]
    FSH_SEASON_YEAR,  -- Season Year [FSH_SAISJ]
    FSH_SEASON,       -- Season [FSH_SAISO]
    FSH_COLLECTION,   -- Collection [FSH_COLLECTION]
    FSH_THEME,        -- Theme [FSH_THEME]
    SEASON1,          -- Season Type 1 [FSH_SEA_TYP1]
    SEASON2,          -- Season Type 2 [FSH_SEA_TYP2]
    SEASON3,          -- Season Type 3 [FSH_SEA_TYP3]
    DESTEXT,          -- Description [FSH_ARTICLE_SEASON_DESC]
    SEA_INDICATOR,    -- Season Indicator [FSH_SEA_INDICATOR]
    SATNR,            -- Cross-plant CM [SATNR]
    RFM_KEYITEM,      -- Key Item [RFM_KEYITEM]
    SDM_VERSION,      -- SDM Version [RFM_SDM_VERSION]
    RFM_SUID,         -- Sea Int. Identifier [RFM_SUID]
    PRIMARY KEY (MANDT, MATNR, FSH_SGT, FSH_SEASON_YEAR, FSH_SEASON, FSH_COLLECTION, FSH_THEME)
);

Learn More