I_CnsldtnFinStmntItemAssgmt

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 I_CnsldtnFinStmntItemAssgmt.
-- 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.
-- SQL view name: ICSFSIASSGMT

CREATE VIEW I_CnsldtnFinStmntItemAssgmt AS
SELECT
  _Assignment.itclg AS ConsolidationChartOfAccounts,
  cast ( _Assignment.item as fincs_fsi_item ) AS FinancialStatementItem,
  _Assignment.iatvs AS CnsldtnFSItemAttributeVersion,
  cast ( _Assignment.fromyearper as fincs_fsi_fiscalyearper_from ) AS FromFiscalYearPeriod,
  cast ( _Assignment.toyearper as fincs_fsi_fiscalyearper_to ) AS ToFiscalYearPeriod,
  _Assignment.sa_role AS FinancialStatementItemRole,
  _Assignment.sa_data_collection AS FSItemDataCollection,
  _Assignment.sa_currency_translation AS FSItemCurrencyTranslation,
  _Assignment.sa_elimination AS FSItemElimination,
  _Assignment.sa_cash_flow AS FSItemCashFlow,
  _Assignment.sa_scope AS FSItemScope,
  _Assignment.sa_customer_specific AS FSItemCustomerSpecific,
  cast ( _Assignment.ta_elimination as fincs_fsi_elimination_ta_item ) AS EliminationTargetFSItem,
  cast ( _Assignment.ta_nci as fincs_fsi_nci_ta_item ) AS NCITargetFSItem,
  cast ( _Assignment.ta_planning as fincs_fsi_planning_ta_item ) AS PlanningTargetFSItem,
  cast ( _Assignment.ta_offsetting as fincs_offsettingtargetfsitem ) AS CnsldtnOffsettingTargetFSItem
FROM fincs_fsiassgmt AS _Assignment
;