FSH_SD_PERIODS

Transparent Table Application Table
28 Fields 4 CDS Views

Condition Records For Season Determination in SD

FSH_SD_PERIODS is an SAP database table in S/4HANA. Condition Records For Season Determination in SD. It contains 28 fields. 4 CDS views read from this table.

CDS Views using this table (4)

ViewTypeJoinVDMDescription
I_SeasonSalesPeriod view from BASIC Season sales periods basic view
I_SeasonSalesPeriod_2 view_entity from BASIC Season Sales Period
I_SeasonStockTransferPeriod view_entity from BASIC Season Stock Transfer Period
RFM_SD_PERIODS_V view from FSH_SD_PERIODS enh. with RFM_PRIORITY

Fields (28)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY fsh_crsd fsh_crsd Cond.Record No.
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
vkorg vkorg Sales Org.
vtweg vtweg Distr. Channel
land1 land1 Country/Reg.
regio regio Region
kdgrp kdgrp Customer Group
kunnr kunnr Customer
sd_dldt_from fsh_adldv Deliv.Date From
sd_dldt_to fsh_adldb Deliv. Date To
sd_ordt_from fsh_audtv Order Date From
sd_ordt_to fsh_audtb Order Date To
sd_store_from fsh_store_dt_frm Sales Store Frm
sd_store_to fsh_store_dt_to Sales Store To
fsh_dt_proposal fsh_dprgdate Date Proposal
fsh_dl_dt_check fsh_dprgdifdate Del. Date Check
fsh_atp_date fsh_dprgpdate Start Date ATP
bzirk bzirk Sales District
parvw parvw Partner Functn
rfm_prfrd_deliv_date rfm_prfrd_deliv_date Prfrd Deliv Date
supplying_plant werks_d Plant
season_guid rfm_suid Sea Int. Identifier
sales_guid rfm_season_sales_guid
season_period_type rfm_season_period_type

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.

-- Condition Records For Season Determination in SD
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE FSH_SD_PERIODS (
    MANDT,                 -- Client [mandt]
    FSH_CRSD,              -- Cond.Record No. [fsh_crsd]
    FSH_SEASON_YEAR,       -- Season Year [fsh_saisj]
    FSH_SEASON,            -- Season [fsh_saiso]
    FSH_COLLECTION,        -- Collection [fsh_collection]
    FSH_THEME,             -- Theme [fsh_theme]
    VKORG,                 -- Sales Org. [vkorg]
    VTWEG,                 -- Distr. Channel [vtweg]
    LAND1,                 -- Country/Reg. [land1]
    REGIO,                 -- Region [regio]
    KDGRP,                 -- Customer Group [kdgrp]
    KUNNR,                 -- Customer [kunnr]
    SD_DLDT_FROM,          -- Deliv.Date From [fsh_adldv]
    SD_DLDT_TO,            -- Deliv. Date To [fsh_adldb]
    SD_ORDT_FROM,          -- Order Date From [fsh_audtv]
    SD_ORDT_TO,            -- Order Date To [fsh_audtb]
    SD_STORE_FROM,         -- Sales Store Frm [fsh_store_dt_frm]
    SD_STORE_TO,           -- Sales Store To [fsh_store_dt_to]
    FSH_DT_PROPOSAL,       -- Date Proposal [fsh_dprgdate]
    FSH_DL_DT_CHECK,       -- Del. Date Check [fsh_dprgdifdate]
    FSH_ATP_DATE,          -- Start Date ATP [fsh_dprgpdate]
    BZIRK,                 -- Sales District [bzirk]
    PARVW,                 -- Partner Functn [parvw]
    RFM_PRFRD_DELIV_DATE,  -- Prfrd Deliv Date [rfm_prfrd_deliv_date]
    SUPPLYING_PLANT,       -- Plant [werks_d]
    SEASON_GUID,           -- Sea Int. Identifier [rfm_suid]
    SALES_GUID,            -- rfm_season_sales_guid
    SEASON_PERIOD_TYPE,    -- rfm_season_period_type
    PRIMARY KEY (MANDT, FSH_CRSD, FSH_SEASON_YEAR, FSH_SEASON, FSH_COLLECTION, FSH_THEME)
);

Learn More