I_CNSLDTNUNIT_3

CDS View

Consolidation Unit

I_CNSLDTNUNIT_3 is a CDS View in S/4HANA. Consolidation Unit. It contains 5 fields. 9 CDS views read from this table.

CDS Views using this table (9)

ViewTypeJoinVDMDescription
C_CnsldtnUnitValueHelp_3 view from CONSUMPTION Consolidation Unit Value Help
FAC_PARTNERCONSOLIDATIONUNITVH view from Value help for partner consldtn unit
P_CnsldtnUnit_UnionByKey view union COMPOSITE Consolidation Unit
P_CnsldtnUnitOverview view from COMPOSITE Consolidation Unit Overview
P_GLE_ADB_GR_01 view inner COMPOSITE Aggregated select from ACDOCA
P_PLANDATA_NRL_01 view inner COMPOSITE Select from ACDOCP; Consolidation Unit; Period and Year
P_REALTIMERPTDFINDATANRL_01 view inner COMPOSITE Select from ACDOCA; Cons Unit; Period and Year (NRL)
P_RepFinData_RT_AggrNRL_02 view inner COMPOSITE Consolidation Unit; Period and Year
P_REPFINDATA_RT_AGGRSNRL_02 view inner COMPOSITE Consolidation Unit; Period and Year

Fields (5)

KeyField CDS FieldsUsed in Views
KEY ConsolidationDimension ConsolidationDimension 5
KEY ConsolidationUnit ConsolidationUnit 5
ConsolidationUnitLink ConsolidationUnitLink 1
ConsolidationUnitLinkLabel ConsolidationUnitLinkLabel 1
Country Country 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 Unit
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_CNSLDTNUNIT_3 (
    CONSOLIDATIONDIMENSION,
    CONSOLIDATIONUNIT,
    CONSOLIDATIONUNITLINK,
    CONSOLIDATIONUNITLINKLABEL,
    COUNTRY,
    PRIMARY KEY (CONSOLIDATIONDIMENSION, CONSOLIDATIONUNIT)
);