I_CNSLDTNVERSION

CDS View
18 Fields 62 CDS Views

Consolidation Version

I_CNSLDTNVERSION is a CDS View in S/4HANA. Consolidation Version. It contains 18 fields. 62 CDS views read from this table.

CDS Views using this table (62)

ViewTypeJoinVDMDescription
A_CnsldtnVersion view from COMPOSITE Consolidation Version
C_CnsldtnTskMntrMnlVersionVH view_entity from CONSUMPTION Consolidation Version
C_CnsldtnUnitGrpCrcySrceCntxt view cross CONSUMPTION Source for Group Currency with Context
C_CnsldtnUnitLoclCrcySrceCntxt view cross CONSUMPTION Source for Local Currency with Context
C_CnsldtnVersionUIParameter view from CONSUMPTION
C_CnsldtnVersionVH view from CONSUMPTION Consolidation Version Value Help
C_CnsldtnVersReltdToAttribVers view from CONSUMPTION Related Version for FSI Attributes
C_CnsldtnVersReltdToAttribVers view cross CONSUMPTION Related Version for FSI Attributes
C_CnsldtnVersReltdToAttribVers view union CONSUMPTION Related Version for FSI Attributes
I_CnsldtnGLAcctItemAttribute view_entity inner COMPOSITE GL Account Line Item with GR attributes
I_CnsldtnTaskRunLastLog_2 view_entity inner BASIC Consolidation Task Run Last Log
I_CnsldtnUnitByGroup view inner COMPOSITE Consolidation Units by Group
I_CnsldtnUnitOverview view_entity inner COMPOSITE Consolidation Unit Overview
I_CnsldtnVersionVH view from COMPOSITE Consolidation Version
P_CnsldtnExtnVersAcctgInteg view from COMPOSITE
P_CnsldtnFSItemAcrossVersions view cross COMPOSITE Financial Statement Item by Version
P_CnsldtnGLAvgDailyBal_01 view inner COMPOSITE
P_CnsldtnGroupStrucMethAssgmt view inner BASIC Cnsldtn Group Structure Method Assgmt
P_CnsldtnGroupStructure view inner BASIC Consolidation Group Structure
P_CnsldtnGrpJrnlEntrItmConVers view inner COMPOSITE
P_CNSLDTNINTEGRPTDFINDATA_01 view inner COMPOSITE
P_CNSLDTNRPTGRULEIDINDEX1 view inner COMPOSITE
P_CnsldtnTaskMonitorOverview01 view_entity cross COMPOSITE
P_CnsldtnTaskMonitorOverview02 view_entity inner COMPOSITE
P_CnsldtnTskDocTypeDtaColl view inner BASIC
P_CnsldtnTskMntrGrpPerdSts01 view_entity inner COMPOSITE
P_CnsldtnUndrlgVersConfign view inner COMPOSITE
P_CnsldtnUnitOverview view cross COMPOSITE
P_FinSGLCnsldtnADB_01 view_entity inner COMPOSITE Consolidation Average Daily Balance
P_GLE_ADB_GR_01 view inner COMPOSITE
P_GLE_ADB_GR_FT_01 view_entity inner COMPOSITE Consolidation Average Daily Balance
P_GLE_ADB_PERIOD_LAST view inner COMPOSITE
P_GVoAAccountLineItemEnhcd view_entity inner COMPOSITE
P_GVoAAccountLineItemPRS view_entity inner COMPOSITE
P_GVoAGrpJEItm view_entity inner COMPOSITE
P_Matrix_CnsldtdDataWthoutElim view inner COMPOSITE
P_Matrix_CnsldtnFoundation_2 view inner COMPOSITE
P_Matrix_CnsldtnFoundationPER view inner COMPOSITE
P_Matrix_CnsldtnFoundationYTD view inner COMPOSITE
P_Matrix_CP_GroupDerived_2 view inner COMPOSITE
P_Matrix_CP_GroupFilled_2 view inner COMPOSITE
P_Matrix_ElimData view inner COMPOSITE
P_Matrix_ElimDataWGroupDerived view inner BASIC
P_Matrix_PreparedElimCGDeriv view inner BASIC
P_Matrix_PreparedSFDForCGDeriv view inner COMPOSITE
P_Matrix_SFDWGroupDerived view inner COMPOSITE
P_Matrix_VecElim view inner COMPOSITE
P_Matrix_VecPCC view inner COMPOSITE
P_Matrix_VecSFD view inner COMPOSITE
P_MatrixCnsldtn01Fndn view inner COMPOSITE
P_MatrixCnsldtnFoundation view inner COMPOSITE
P_MJEL_PreparedElimCGDeriv view inner COMPOSITE
P_PLANDATA_NRL_01 view inner COMPOSITE
P_RealTimeRptdFinData_01 view inner COMPOSITE
P_REALTIMERPTDFINDATANRL_01 view inner COMPOSITE
P_RepFinData_RT_Aggr_02 view inner COMPOSITE
P_RepFinData_RT_AggrNRL_02 view inner COMPOSITE
P_REPFINDATA_RT_AGGRSNRL_02 view inner COMPOSITE
P_RFD_RT_AGGR_simple_02 view inner COMPOSITE
P_StandardizedDataEnhC view inner COMPOSITE
R_CnsldtnFSItemByTimeVersionTP view_entity inner TRANSACTIONAL Cnsldtn FS Item by Time and Version - TP
R_CnsldtnUnitByTimeVersionTP view_entity inner TRANSACTIONAL Consolidation Unit by Time/Version - TP

Fields (18)

KeyField CDS FieldsUsed in Views
KEY ConsolidationVersion ConsolidationVersion 30
CnsldtnAccountingSourceLedger CnsldtnAccountingSourceLedger 1
CnsldtnFSItemAttributeVersion CnsldtnFSItemAttributeVersion 1
CnsldtnIsPlanVersion CnsldtnIsPlanVersion 2
CnsldtnReferenceVersion CnsldtnReferenceVersion 1
CnsldtnSourceLedger CnsldtnSourceLedger 1
CnsldtnUnitAttributeVersion CnsldtnUnitAttributeVersion 1
CnsldtnVersionGroupCrcySource CnsldtnVersionGroupCrcySource 5
CnsldtnVersionHasAllKeyFigures CnsldtnVersionHasAllKeyFigures 2
CnsldtnVersionLocalCrcySource CnsldtnVersionLocalCrcySource 1
CnsldtnVersionRunMode CnsldtnVersionRunMode 3
CnsldtnVersionType CnsldtnVersionType 2
ConsolidationLedger ConsolidationLedger 10
ConsolidationReportingRuleVers ConsolidationReportingRuleVers 1
ConsolidationStructureVersion strvs 3
FiscalYearVariant FiscalYearVariant 1
FSItemMappingVersion FSItemMappingVersion 12
GroupCurrency GroupCurrency 13

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 Version
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_CNSLDTNVERSION (
    CONSOLIDATIONVERSION,
    CNSLDTNACCOUNTINGSOURCELEDGER,
    CNSLDTNFSITEMATTRIBUTEVERSION,
    CNSLDTNISPLANVERSION,
    CNSLDTNREFERENCEVERSION,
    CNSLDTNSOURCELEDGER,
    CNSLDTNUNITATTRIBUTEVERSION,
    CNSLDTNVERSIONGROUPCRCYSOURCE,
    CNSLDTNVERSIONHASALLKEYFIGURES,
    CNSLDTNVERSIONLOCALCRCYSOURCE,
    CNSLDTNVERSIONRUNMODE,
    CNSLDTNVERSIONTYPE,
    CONSOLIDATIONLEDGER,
    CONSOLIDATIONREPORTINGRULEVERS,
    CONSOLIDATIONSTRUCTUREVERSION,
    FISCALYEARVARIANT,
    FSITEMMAPPINGVERSION,
    GROUPCURRENCY,
    PRIMARY KEY (CONSOLIDATIONVERSION)
);

Learn More