P_CnsldtnFSItemByTimeVersion

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view P_CnsldtnFSItemByTimeVersion.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.

CREATE VIEW P_CnsldtnFSItemByTimeVersion AS
SELECT
  cast( _Assignment.itclg as fincs_conschartofaccounts preserving type ) AS ConsolidationChartOfAccounts,
  cast ( _Assignment.item as fincs_md_finstatementitem preserving type ) AS CnsldtnFinancialStatementItem,
  cast( _CnsldtnVersionJ.ConsolidationVersion as fincs_consolidationversion preserving type ) AS ConsolidationVersion,
  cast( _Assignment.fromyearper as fincs_fromfiscalyearperiod ) AS FromFiscalYearPeriod,
  cast( _Assignment.toyearper as fincs_tofiscalyearperiod ) AS ToFiscalYearPeriod,
  cast(_Assignment.iatvs as fincs_fsitemattributeversion preserving type ) AS CnsldtnFSItemAttributeVersion,
  cast ( _Assignment.sa_role as fincs_fsitemrole preserving type ) AS CnsldtnFSItemRole,
  cast ( _Assignment.sa_data_collection as fincs_fsitemdatacollection preserving type ) AS CnsldtnFSItemDataCollection,
  cast ( _Assignment.sa_currency_translation as fincs_fsitemcrcytranslation preserving type ) AS CnsldtnFSItemCrcyTranslation,
  cast ( _Assignment.sa_elimination as fincs_fsitemelimination preserving type ) AS CnsldtnFSItemElimination,
  cast ( _Assignment.sa_cash_flow as fincs_fsitemcashflow preserving type ) AS CnsldtnFSItemCashFlow,
  cast ( _Assignment.sa_scope as fincs_fsitemscope preserving type ) AS CnsldtnFSItemScope,
  cast ( _Assignment.sa_customer_specific as fincs_fsitemcustomerspecific preserving type ) AS CnsldtnFSItemCustomerSpecific,
  cast ( _Assignment.ta_elimination as fincs_eliminationtargetfsitem preserving type ) AS CnsldtnEliminationTargetFSItem,
  cast ( _Assignment.ta_nci as fincs_ncitargetfsitem preserving type ) AS CnsldtnNCITargetFSItem,
  cast ( _Assignment.ta_planning as fincs_planningtargetfsitem preserving type ) AS CnsldtnPlanningTargetFSItem,
  cast ( _Assignment.ta_offsetting as fincs_offsettingtargetfsitem preserving type ) AS CnsldtnOffsettingTargetFSItem
FROM fincs_fsiassgmt AS _Assignment
LEFT OUTER JOIN I_CnsldtnChartOfAccounts AS _CnsldtnChartOfAccounts ON ConsolidationChartOfAccounts = _CnsldtnChartOfAccounts.ConsolidationChartOfAccounts  -- association [1..1]
LEFT OUTER JOIN I_CnsldtnVersion AS _CnsldtnVersion ON ConsolidationVersion = _CnsldtnVersion.ConsolidationVersion  -- association [1..1]
LEFT OUTER JOIN I_CnsldtnFSItemRole AS _CnsldtnFSItemRole ON CnsldtnFSItemRole = _CnsldtnFSItemRole.CnsldtnFSItemRole  -- association [0..1]
LEFT OUTER JOIN I_CnsldtnFSItemDataColl AS _CnsldtnFSItemDataColl ON CnsldtnFSItemDataCollection = _CnsldtnFSItemDataColl.CnsldtnFSItemDataCollection  -- association [0..1]
LEFT OUTER JOIN I_CnsldtnFSItemCrcyTrnsltn AS _CnsldtnFSItemCrcyTrnsltn ON CnsldtnFSItemCrcyTranslation = _CnsldtnFSItemCrcyTrnsltn.CnsldtnFSItemCrcyTranslation  -- association [0..1]
LEFT OUTER JOIN I_CnsldtnFSItemElimination AS _CnsldtnFSItemElimination ON CnsldtnFSItemElimination = _CnsldtnFSItemElimination.CnsldtnFSItemElimination  -- association [0..1]
LEFT OUTER JOIN I_CnsldtnFSItemCashFlow AS _CnsldtnFSItemCashFlow ON CnsldtnFSItemCashFlow = _CnsldtnFSItemCashFlow.CnsldtnFSItemCashFlow  -- association [0..1]
LEFT OUTER JOIN I_CnsldtnFSItemScope AS _CnsldtnFSItemScope ON CnsldtnFSItemScope = _CnsldtnFSItemScope.CnsldtnFSItemScope  -- association [0..1]
LEFT OUTER JOIN I_CnsldtnFSItemCustSpcfc AS _CnsldtnFSItemCustSpcfc ON CnsldtnFSItemCustomerSpecific = _CnsldtnFSItemCustSpcfc.CnsldtnFSItemCustomerSpecific  -- association [0..1]
;