RFM_SEASONS

Transparent Table Application Table

Season Master

RFM_SEASONS is an SAP database table in S/4HANA. Season Master. It contains 22 fields. 18 CDS views read from this table.

CDS Views using this table (18)

ViewTypeJoinVDMDescription
I_SeasonBasic view from BASIC Season basic view
RFM_E_COL view from FSH_COLLECTIONS Compatibility view
RFM_E_COL_T view from FSH_COLLECTIONS_TCompatibility view
RFM_E_SEA view from FSH_SEASONS Compatibility view
RFM_E_SEA_T view from FSH_SEASONS_TCompatibility view
RFM_E_THEME view from FSH_THEMES Compatibility view
RFM_E_theme_T view from FSH_COLLECTIONS_TCompatibility view
RFM_MM_PERIODS_V view inner FSH_MM_PERIODS enh. with RFM_PRIORITY
RFM_PP_PERIODS_V view inner FSH_PP_PERIODS enh. with RFM_PRIORITY
rfm_scc_sd_season_assign view inner RFM Manage Season Completeness SD Assign
RFM_SCC_SEASNID_KEYITM_ART_V view inner CDS view for key item assigned to season
rfm_scc_season_concat_V view from View for season concatenation
rfm_scc_season_data view from get season data and season Text
rfm_Scc_season_text view from Season Text
RFM_SCC_SEASONID_ARTICLE_V view inner CDS view for article assigned to season
rfm_scc_sto_sea_assign view inner RFM Season Complete Check STO Assignment
RFM_SD_PERIODS_V view inner FSH_SD_PERIODS enh. with RFM_PRIORITY
SHSM_FSH_VA_SEA_F4 view inner CDS replacing replacing FSH_VA_SEA_F4

Fields (22)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY rfm_suid RFM_SUID Sea Int. Identifier
fsh_season_year FSH_SAISJ Season Year
fsh_season FSH_SAISO Season
fsh_collection FSH_COLLECTION Collection
fsh_theme FSH_THEME Theme
fsh_validity_frm FSH_SEA_VALID_FROM Validity From
fsh_validity_to FSH_SEA_VALID_TO Validity To
rfm_priority RFM_PRIORITY Priority
rfm_sea_completness RFM_SEASON_COMPLETNESS Season Comp.Group
rfm_season_category RFM_SEASON_CATEGORY Season Category
fsh_createuser FSH_CREATEUSER Created by
fsh_createdate FSH_CREATEDATE Created On
fsh_createtime FSH_CREATETIME Created at
fsh_changeuser FSH_CHANGEUSER Changed by
fsh_changedate FSH_CHANGEDATE Changed on
fsh_changetime FSH_CHANGETIME Changed at
rfm_seasonlevel RFM_SEASONLEVEL Season Level
rfm_seasonyearparent RFM_SEASONYEARPARENT Season Year Par
rfm_seasonparent RFM_SEASONPARENT Season Parent
rfm_collectionparent RFM_COLLECTIONPARENT Collection Par
rfm_themeparent RFM_THEMEPARENT Theme Parent

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.

-- Season Master
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE RFM_SEASONS (
    MANDT,                 -- Client [MANDT]
    RFM_SUID,              -- Sea Int. Identifier [RFM_SUID]
    FSH_SEASON_YEAR,       -- Season Year [FSH_SAISJ]
    FSH_SEASON,            -- Season [FSH_SAISO]
    FSH_COLLECTION,        -- Collection [FSH_COLLECTION]
    FSH_THEME,             -- Theme [FSH_THEME]
    FSH_VALIDITY_FRM,      -- Validity From [FSH_SEA_VALID_FROM]
    FSH_VALIDITY_TO,       -- Validity To [FSH_SEA_VALID_TO]
    RFM_PRIORITY,          -- Priority [RFM_PRIORITY]
    RFM_SEA_COMPLETNESS,   -- Season Comp.Group [RFM_SEASON_COMPLETNESS]
    RFM_SEASON_CATEGORY,   -- Season Category [RFM_SEASON_CATEGORY]
    FSH_CREATEUSER,        -- Created by [FSH_CREATEUSER]
    FSH_CREATEDATE,        -- Created On [FSH_CREATEDATE]
    FSH_CREATETIME,        -- Created at [FSH_CREATETIME]
    FSH_CHANGEUSER,        -- Changed by [FSH_CHANGEUSER]
    FSH_CHANGEDATE,        -- Changed on [FSH_CHANGEDATE]
    FSH_CHANGETIME,        -- Changed at [FSH_CHANGETIME]
    RFM_SEASONLEVEL,       -- Season Level [RFM_SEASONLEVEL]
    RFM_SEASONYEARPARENT,  -- Season Year Par [RFM_SEASONYEARPARENT]
    RFM_SEASONPARENT,      -- Season Parent [RFM_SEASONPARENT]
    RFM_COLLECTIONPARENT,  -- Collection Par [RFM_COLLECTIONPARENT]
    RFM_THEMEPARENT,       -- Theme Parent [RFM_THEMEPARENT]
    PRIMARY KEY (MANDT, RFM_SUID)
);