I_CNSLDTNGROUPSTRUCTURE_2

CDS View
11 Fields 7 CDS Views

Consolidation Group Structure

I_CNSLDTNGROUPSTRUCTURE_2 is a CDS View in S/4HANA. Consolidation Group Structure. It contains 11 fields. 7 CDS views read from this table.

CDS Views using this table (7)

ViewTypeJoinVDMDescription
C_UnassgdCnsldtnGroupByUnitVH view left_outer CONSUMPTION Consolidation Groups w/o Unit Assignment
P_CnsldtnGroupStructureEnhcd view from COMPOSITE
P_Matrix_CP_GroupChecked view inner COMPOSITE
P_Matrix_CP_GroupDerived view inner COMPOSITE
P_MJEL_ElimData view inner COMPOSITE
P_MJEL_ElimDataWGroupDerived view inner COMPOSITE
P_MJEL_SFDWGroupDerived view inner COMPOSITE

Fields (11)

KeyField CDS FieldsUsed in Views
KEY ConsolidationGroup ConsolidationGroup,rcongr 4
KEY ConsolidationUnit ConsolidationUnit 1
KEY ConsolidationVersion ConsolidationVersion 1
DivestitureIsAtBeginOfPeriod DivestitureIsAtBeginOfPeriod 1
DivestitureIsDueToMerger DivestitureIsDueToMerger 1
ETag ETag 1
FirstCnsldtnIsAtEndOfPeriod FirstCnsldtnIsAtEndOfPeriod 1
PeriodOfDivestiture PeriodOfDivestiture 1
PeriodOfFirstConsolidation PeriodOfFirstConsolidation 1
YearOfDivestiture YearOfDivestiture 1
YearOfFirstConsolidation YearOfFirstConsolidation 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.

-- Consolidation Group Structure
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_CNSLDTNGROUPSTRUCTURE_2 (
    CONSOLIDATIONGROUP,
    CONSOLIDATIONUNIT,
    CONSOLIDATIONVERSION,
    DIVESTITUREISATBEGINOFPERIOD,
    DIVESTITUREISDUETOMERGER,
    ETAG,
    FIRSTCNSLDTNISATENDOFPERIOD,
    PERIODOFDIVESTITURE,
    PERIODOFFIRSTCONSOLIDATION,
    YEAROFDIVESTITURE,
    YEAROFFIRSTCONSOLIDATION,
    PRIMARY KEY (CONSOLIDATIONGROUP, CONSOLIDATIONUNIT, CONSOLIDATIONVERSION)
);

Learn More