I_CNSLDTNFSITEMBYTIMEVERSION

CDS View
28 Fields 1 CDS Views

Consolidation FS Item by Time Version

I_CNSLDTNFSITEMBYTIMEVERSION is a CDS View in S/4HANA. Consolidation FS Item by Time Version. It contains 28 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
R_CnsldtnFSItemByTimeVersionTP view_entity from TRANSACTIONAL Cnsldtn FS Item by Time and Version - TP

Fields (28)

KeyField CDS FieldsUsed in Views
KEY CnsldtnFinancialStatementItem CnsldtnFinancialStatementItem 1
KEY ConsolidationChartOfAccounts ConsolidationChartOfAccounts 1
KEY ConsolidationVersion ConsolidationVersion 1
KEY FromFiscalYearPeriod FromFiscalYearPeriod 1
_CnsldtnElimTargetFSItem _CnsldtnElimTargetFSItem 1
_CnsldtnFSItemCashFlow _CnsldtnFSItemCashFlow 1
_CnsldtnFSItemCrcyTrnsltn _CnsldtnFSItemCrcyTrnsltn 1
_CnsldtnFSItemCustSpcfc _CnsldtnFSItemCustSpcfc 1
_CnsldtnFSItemDataColl _CnsldtnFSItemDataColl 1
_CnsldtnFSItemElimination _CnsldtnFSItemElimination 1
_CnsldtnFSItemRole _CnsldtnFSItemRole 1
_CnsldtnFSItemScope _CnsldtnFSItemScope 1
_CnsldtnNCITargetFSItem _CnsldtnNCITargetFSItem 1
_CnsldtnOffsettingTargetFSItem _CnsldtnOffsettingTargetFSItem 1
_CnsldtnPlanningTargetFSItem _CnsldtnPlanningTargetFSItem 1
_CnsldtnVersion _CnsldtnVersion 1
CnsldtnEliminationTargetFSItem CnsldtnEliminationTargetFSItem 1
CnsldtnFSItemCashFlow CnsldtnFSItemCashFlow 1
CnsldtnFSItemCrcyTranslation CnsldtnFSItemCrcyTranslation 1
CnsldtnFSItemCustomerSpecific CnsldtnFSItemCustomerSpecific 1
CnsldtnFSItemDataCollection CnsldtnFSItemDataCollection 1
CnsldtnFSItemElimination CnsldtnFSItemElimination 1
CnsldtnFSItemRole CnsldtnFSItemRole 1
CnsldtnFSItemScope CnsldtnFSItemScope 1
CnsldtnNCITargetFSItem CnsldtnNCITargetFSItem 1
CnsldtnOffsettingTargetFSItem CnsldtnOffsettingTargetFSItem 1
CnsldtnPlanningTargetFSItem CnsldtnPlanningTargetFSItem 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 FS Item by Time Version
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_CNSLDTNFSITEMBYTIMEVERSION (
    CNSLDTNFINANCIALSTATEMENTITEM,
    CONSOLIDATIONCHARTOFACCOUNTS,
    CONSOLIDATIONVERSION,
    FROMFISCALYEARPERIOD,
    _CNSLDTNELIMTARGETFSITEM,
    _CNSLDTNFSITEMCASHFLOW,
    _CNSLDTNFSITEMCRCYTRNSLTN,
    _CNSLDTNFSITEMCUSTSPCFC,
    _CNSLDTNFSITEMDATACOLL,
    _CNSLDTNFSITEMELIMINATION,
    _CNSLDTNFSITEMROLE,
    _CNSLDTNFSITEMSCOPE,
    _CNSLDTNNCITARGETFSITEM,
    _CNSLDTNOFFSETTINGTARGETFSITEM,
    _CNSLDTNPLANNINGTARGETFSITEM,
    _CNSLDTNVERSION,
    CNSLDTNELIMINATIONTARGETFSITEM,
    CNSLDTNFSITEMCASHFLOW,
    CNSLDTNFSITEMCRCYTRANSLATION,
    CNSLDTNFSITEMCUSTOMERSPECIFIC,
    CNSLDTNFSITEMDATACOLLECTION,
    CNSLDTNFSITEMELIMINATION,
    CNSLDTNFSITEMROLE,
    CNSLDTNFSITEMSCOPE,
    CNSLDTNNCITARGETFSITEM,
    CNSLDTNOFFSETTINGTARGETFSITEM,
    CNSLDTNPLANNINGTARGETFSITEM,
    TOFISCALYEARPERIOD,
    PRIMARY KEY (CNSLDTNFINANCIALSTATEMENTITEM, CONSOLIDATIONCHARTOFACCOUNTS, CONSOLIDATIONVERSION, FROMFISCALYEARPERIOD)
);

Learn More