P_FSITEMWITHMAPPING

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_FSITEMWITHMAPPING.
-- 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: PFSITEMWMAPPING

CREATE VIEW P_FSITEMWITHMAPPING AS
SELECT
  cast( _MappingHeader.FinancialStatementItem as char32) AS DraftUUID,
  FSItemMappingID,
  _MappingHeader.ConsolidationChartOfAccounts AS ConsolidationChartOfAccounts,
  ChartOfAccounts,
  FSItemMappingRevision,
  _MappingHeader.FinancialStatementItem AS FinancialStatementItem,
  cast('X' as abap_boolean) AS IsActiveEntity,
  cast ( _FSItem.IsConsolidationItem as fincs_fsitemisforcnsldtnonly preserving type ) AS IsConsolidationItem,
  cast ( _FSItem.FinancialStatementItemIsBlkd as fincs_fsitempostingisblocked preserving type ) AS FinancialStatementItemIsBlkd,
  cast( _FSItem.FinancialStatementItemType as fincs_fsitemtype preserving type ) AS FinancialStatementItemType,
  _FSItem.BreakdownCategory AS BreakdownCategory,
  _FSItem._Text[1: Language = $session.system_language].FinancialStatementItemText AS FinancialStatementItemText,
  _FSItem._Text[1: Language = $session.system_language].FinancialStatementItemMdmText AS FinancialStatementItemMdmText,
  FSItemMappingUUID,
  cast('' as char1024 ) AS AssigneeGLAccounts
FROM P_FSItemMappingFSItemAll AS _MappingHeader
LEFT OUTER JOIN I_CnsldtnFinStmntItem AS _FSItem ON /* join condition not captured in parsed metadata */
-- UNION ALL with additional select branch(es): P_FSItemMappingFSItemAllD
;