I_CNSLDTNFSITEMHIERARCHY_2

CDS View
6 Fields 2 CDS Views

Consolidation FS Item Hierarchy

I_CNSLDTNFSITEMHIERARCHY_2 is a CDS View in S/4HANA. Consolidation FS Item Hierarchy. It contains 6 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
A_CnsldtnFSItemHierarchy_3 view_entity from BASIC Consolidation FS Item Hierarchy
P_CnsldtnFSItemHierAnlytsVH view_entity from COMPOSITE FS Item value help (time dependent)

Fields (6)

KeyField CDS FieldsUsed in Views
KEY CnsldtnFSItemHierarchy CnsldtnFSItemHierarchy 1
KEY ConsolidationChartOfAccounts ConsolidationChartOfAccounts 1
KEY ValidityEndDate ValidityEndDate 1
LastChangeDateTime LastChangeDateTime 1
LastChangedByUser LastChangedByUser 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.

-- Consolidation FS Item Hierarchy
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_CNSLDTNFSITEMHIERARCHY_2 (
    CNSLDTNFSITEMHIERARCHY,
    CONSOLIDATIONCHARTOFACCOUNTS,
    VALIDITYENDDATE,
    LASTCHANGEDATETIME,
    LASTCHANGEDBYUSER,
    VALIDITYSTARTDATE,
    PRIMARY KEY (CNSLDTNFSITEMHIERARCHY, CONSOLIDATIONCHARTOFACCOUNTS, VALIDITYENDDATE)
);

Learn More