FSH_SD_PERIODS

Transparent Table Application Table
30 Fields 2 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 30 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
I_SeasonSalesPeriod view from BASIC Season sales periods basic view
RFM_SD_PERIODS_V view from FSH_SD_PERIODS enh. with RFM_PRIORITY

Fields (30)

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
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
bzirk BZIRK Sales District
parvw PARVW Partner Functn
rfm_prfrd_deliv_date RFM_PRFRD_DELIV_DATE Prfrd Deliv Date

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]
    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]
    BZIRK,                 -- Sales District [BZIRK]
    PARVW,                 -- Partner Functn [PARVW]
    RFM_PRFRD_DELIV_DATE,  -- Prfrd Deliv Date [RFM_PRFRD_DELIV_DATE]
    PRIMARY KEY (MANDT, FSH_CRSD, FSH_SEASON_YEAR, FSH_SEASON, FSH_COLLECTION, FSH_THEME)
);

Learn More