P_CNSLDTNFSITEMBYTIMEVERSION

CDS View
25 Fields 2 CDS Views

Consolidation FS Item by Time Version

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

CDS Views using this table (2)

ViewTypeJoinVDMDescription
I_CnsldtnFinStmntItemAssgmtTP view_entity from TRANSACTIONAL Financial Statement Item Assignment
I_CnsldtnFSItemByTimeVersion view from BASIC Consolidation FS Item by Time Version

Fields (25)

KeyField CDS FieldsUsed in Views
KEY CnsldtnFinancialStatementItem CnsldtnFinancialStatementItem 1
KEY ConsolidationChartOfAccounts ConsolidationChartOfAccounts 2
KEY ConsolidationVersion ConsolidationVersion 2
KEY FromFiscalYearPeriod FromFiscalYearPeriod 2
_CnsldtnChartOfAccounts _CnsldtnChartOfAccounts 2
_CnsldtnFSItemCashFlow _CnsldtnFSItemCashFlow 1
_CnsldtnFSItemCrcyTrnsltn _CnsldtnFSItemCrcyTrnsltn 1
_CnsldtnFSItemCustSpcfc _CnsldtnFSItemCustSpcfc 1
_CnsldtnFSItemDataColl _CnsldtnFSItemDataColl 1
_CnsldtnFSItemElimination _CnsldtnFSItemElimination 1
_CnsldtnFSItemRole _CnsldtnFSItemRole 1
_CnsldtnFSItemScope _CnsldtnFSItemScope 1
_CnsldtnVersion _CnsldtnVersion 2
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 2

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 P_CNSLDTNFSITEMBYTIMEVERSION (
    CNSLDTNFINANCIALSTATEMENTITEM,
    CONSOLIDATIONCHARTOFACCOUNTS,
    CONSOLIDATIONVERSION,
    FROMFISCALYEARPERIOD,
    _CNSLDTNCHARTOFACCOUNTS,
    _CNSLDTNFSITEMCASHFLOW,
    _CNSLDTNFSITEMCRCYTRNSLTN,
    _CNSLDTNFSITEMCUSTSPCFC,
    _CNSLDTNFSITEMDATACOLL,
    _CNSLDTNFSITEMELIMINATION,
    _CNSLDTNFSITEMROLE,
    _CNSLDTNFSITEMSCOPE,
    _CNSLDTNVERSION,
    CNSLDTNELIMINATIONTARGETFSITEM,
    CNSLDTNFSITEMCASHFLOW,
    CNSLDTNFSITEMCRCYTRANSLATION,
    CNSLDTNFSITEMCUSTOMERSPECIFIC,
    CNSLDTNFSITEMDATACOLLECTION,
    CNSLDTNFSITEMELIMINATION,
    CNSLDTNFSITEMROLE,
    CNSLDTNFSITEMSCOPE,
    CNSLDTNNCITARGETFSITEM,
    CNSLDTNOFFSETTINGTARGETFSITEM,
    CNSLDTNPLANNINGTARGETFSITEM,
    TOFISCALYEARPERIOD,
    PRIMARY KEY (CNSLDTNFINANCIALSTATEMENTITEM, CONSOLIDATIONCHARTOFACCOUNTS, CONSOLIDATIONVERSION, FROMFISCALYEARPERIOD)
);

Learn More