P_DISTINCT_POSTINGDATE

CDS View
10 Fields 1 CDS Views

P_DISTINCT_POSTINGDATE is a CDS View in S/4HANA. It contains 10 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_Distinct_Postingdate view from BASIC Distinct Posting Date

Fields (10)

KeyField CDS FieldsUsed in Views
KEY calendar_date CalendarDate 1
KEY fiscal_period FiscalPeriod 1
KEY fiscal_year FiscalYear 1
KEY fiscal_year_variant FiscalYearVariant 1
fiscal_period_end_date FiscalPeriodEndDate 1
fiscal_year_end_date FiscalYearEndDate 1
fiscal_year_period FiscalYearPeriod 1
fiscal_year_start_date FiscalYearStartDate 1
FiscalPeriodDate FiscalPeriodDate 1
is_special_period IsSpecialPeriod 1

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.

-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE P_DISTINCT_POSTINGDATE (
    CALENDAR_DATE,
    FISCAL_PERIOD,
    FISCAL_YEAR,
    FISCAL_YEAR_VARIANT,
    FISCAL_PERIOD_END_DATE,
    FISCAL_YEAR_END_DATE,
    FISCAL_YEAR_PERIOD,
    FISCAL_YEAR_START_DATE,
    FISCALPERIODDATE,
    IS_SPECIAL_PERIOD,
    PRIMARY KEY (CALENDAR_DATE, FISCAL_PERIOD, FISCAL_YEAR, FISCAL_YEAR_VARIANT)
);

Learn More