P_CNSLDTNGROUPSTRUCTUREPERIOD

CDS View
10 Fields 1 CDS Views

validity

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

CDS Views using this table (1)

ViewTypeJoinVDMDescription
P_CnsldtnGroupStructurePeriod1 view from BASIC validity

Fields (10)

KeyField CDS FieldsUsed in Views
KEY ConsolidationGroupHierarchy ConsolidationGroupHierarchy 1
KEY ConsolidationStructureVersion ConsolidationStructureVersion 1
KEY ValidityEndDate ValidityEndDate 1
ConsolidationDimension ConsolidationDimension 1
ConsolidationGroup ConsolidationGroup 1
ConsolidationUnit ConsolidationUnit 1
FromFiscalYearPeriod FromFiscalYearPeriod 1
ToFiscalYear ToFiscalYear 1
toFiscalYearPeriod toFiscalYearPeriod 1
ValidityStartDate ValidityStartDate 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.

-- validity
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE P_CNSLDTNGROUPSTRUCTUREPERIOD (
    CONSOLIDATIONGROUPHIERARCHY,
    CONSOLIDATIONSTRUCTUREVERSION,
    VALIDITYENDDATE,
    CONSOLIDATIONDIMENSION,
    CONSOLIDATIONGROUP,
    CONSOLIDATIONUNIT,
    FROMFISCALYEARPERIOD,
    TOFISCALYEAR,
    TOFISCALYEARPERIOD,
    VALIDITYSTARTDATE,
    PRIMARY KEY (CONSOLIDATIONGROUPHIERARCHY, CONSOLIDATIONSTRUCTUREVERSION, VALIDITYENDDATE)
);

Learn More