I_FISCCALENDARDATEFORCOMPCODE

CDS View

Fiscal Calendar Date For Company Code

I_FISCCALENDARDATEFORCOMPCODE is a CDS View in S/4HANA. Fiscal Calendar Date For Company Code. It contains 5 fields. 7 CDS views read from this table.

CDS Views using this table (7)

ViewTypeJoinVDMDescription
P_FiscalPeriodStart view from COMPOSITE Start of Fiscal Period
P_GR_CADocJournalLogItm view_entity inner CONSUMPTION Greece Document Journal Item Logs
P_GR_DocJournalBPItem view_entity inner CONSUMPTION GR Doc Journal BP items
P_GR_DocJournalGLItem view_entity inner CONSUMPTION GR Doc Journal
P_IntApportnmntBasic view inner COMPOSITE PSM Interest Apportionment Query Basic
P_PeriodTypeByFiscalYearPeriod view left_outer COMPOSITE Period Type
P_RblsItmForKeyDteRepPeriod view from COMPOSITE reporting period

Fields (5)

KeyField CDS FieldsUsed in Views
KEY CalendarDate CalendarDate 1
KEY CompanyCode CompanyCode 1
KEY FiscalPeriod FiscalPeriod 2
KEY FiscalYear FiscalYear 3
KEY FiscalYearVariant FiscalYearVariant 2

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.

-- Fiscal Calendar Date For Company Code
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_FISCCALENDARDATEFORCOMPCODE (
    CALENDARDATE,
    COMPANYCODE,
    FISCALPERIOD,
    FISCALYEAR,
    FISCALYEARVARIANT,
    PRIMARY KEY (CALENDARDATE, COMPANYCODE, FISCALPERIOD, FISCALYEAR, FISCALYEARVARIANT)
);