I_CNSLDTNUNITBYTIMEVERSION

CDS View
25 Fields 13 CDS Views

Consolidation Unit by Time and Version

I_CNSLDTNUNITBYTIMEVERSION is a CDS View in S/4HANA. Consolidation Unit by Time and Version. It contains 25 fields. 13 CDS views read from this table.

CDS Views using this table (13)

ViewTypeJoinVDMDescription
P_CnsldtnGLAvgDailyBal_01 view inner COMPOSITE
P_CNSLDTNINTEGRPTDFINDATA_01 view inner 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_GVoAAccountLineItemEnhcd view_entity inner COMPOSITE
P_GVoAAccountLineItemPRS view_entity inner COMPOSITE
P_GVoAGrpJEItm view_entity inner COMPOSITE
P_PLANDATA_NRL_01 view inner COMPOSITE
P_REALTIMERPTDFINDATANRL_01 view inner COMPOSITE
P_RepFinData_RT_AggrNRL_02 view inner COMPOSITE
P_REPFINDATA_RT_AGGRSNRL_02 view inner COMPOSITE
R_CnsldtnUnitByTimeVersionTP view_entity from TRANSACTIONAL Consolidation Unit by Time/Version - TP

Fields (25)

KeyField CDS FieldsUsed in Views
KEY ConsolidationUnit ConsolidationUnit 1
KEY FromFiscalYearPeriod FromFiscalYearPeriod 1
_CnsldtnCrcyTrnsltnMethod _CnsldtnCrcyTrnsltnMethod 1
_CnsldtnRptdFinDataUpldMeth _CnsldtnRptdFinDataUpldMeth 1
_CnsldtnUnitDataColl _CnsldtnUnitDataColl 1
_CnsldtnUnitPartner _CnsldtnUnitPartner 1
_CnsldtnUnitPostingRule _CnsldtnUnitPostingRule 1
_CnsldtnUnitValidation _CnsldtnUnitValidation 1
_DataTransferMethod _DataTransferMethod 1
_FiscalYearVariant _FiscalYearVariant 1
CnsldtnCrcyTranslationMethod CnsldtnCrcyTranslationMethod 1
CnsldtnDataTransferMethod CnsldtnDataTransferMethod 1
CnsldtnUnitDataCollection CnsldtnUnitDataCollection 1
CnsldtnUnitGroupCrcySource CnsldtnUnitGroupCrcySource 6
CnsldtnUnitLocalCrcySource CnsldtnUnitLocalCrcySource 6
CnsldtnUploadMethod CnsldtnUploadMethod 1
ConsolidationDimension ConsolidationDimension 3
ConsolidationUnitIsPartnerOnly ConsolidationUnitIsPartnerOnly 1
ConsolidationUnitPartner ConsolidationUnitPartner 1
ConsolidationUnitPostingRule ConsolidationUnitPostingRule 1
ConsolidationUnitValidation ConsolidationUnitValidation 1
DocumentEntryIsInGroupCurrency DocumentEntryIsInGroupCurrency 10
FiscalYearVariant FiscalYearVariant 1
TaxRate TaxRate 1
ToFiscalYearPeriod ToFiscalYearPeriod 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 by Time and Version
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_CNSLDTNUNITBYTIMEVERSION (
    CONSOLIDATIONUNIT,
    FROMFISCALYEARPERIOD,
    _CNSLDTNCRCYTRNSLTNMETHOD,
    _CNSLDTNRPTDFINDATAUPLDMETH,
    _CNSLDTNUNITDATACOLL,
    _CNSLDTNUNITPARTNER,
    _CNSLDTNUNITPOSTINGRULE,
    _CNSLDTNUNITVALIDATION,
    _DATATRANSFERMETHOD,
    _FISCALYEARVARIANT,
    CNSLDTNCRCYTRANSLATIONMETHOD,
    CNSLDTNDATATRANSFERMETHOD,
    CNSLDTNUNITDATACOLLECTION,
    CNSLDTNUNITGROUPCRCYSOURCE,
    CNSLDTNUNITLOCALCRCYSOURCE,
    CNSLDTNUPLOADMETHOD,
    CONSOLIDATIONDIMENSION,
    CONSOLIDATIONUNITISPARTNERONLY,
    CONSOLIDATIONUNITPARTNER,
    CONSOLIDATIONUNITPOSTINGRULE,
    CONSOLIDATIONUNITVALIDATION,
    DOCUMENTENTRYISINGROUPCURRENCY,
    FISCALYEARVARIANT,
    TAXRATE,
    TOFISCALYEARPERIOD,
    PRIMARY KEY (CONSOLIDATIONUNIT, FROMFISCALYEARPERIOD)
);

Learn More