I_FSItemMappingAssignment

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_FSItemMappingAssignment.
-- 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: IFSITEMMAPASSG

CREATE VIEW I_FSItemMappingAssignment AS
SELECT
  impvs AS FSItemMappingVersion,
  itclg AS ConsolidationChartOfAccounts,
  ktopl AS ChartOfAccounts,
  cast (fromyearper as fincs_fyearperiod_fr) AS ValidityStartFiscalYearPeriod,
  cast ( toyearper as fincs_fyearperiod_to) AS ValidityEndFiscalYearPeriod,
  mapping AS FSItemMappingID,
  revision AS FSItemMappingRevision
FROM fincs_fsimapa
LEFT OUTER JOIN I_CnsldtnChartOfAccounts AS _ConsChartOfAccounts ON ConsolidationChartOfAccounts = _ConsChartOfAccounts.ConsolidationChartOfAccounts  -- association [1..1]
LEFT OUTER JOIN I_ChartOfAccounts AS _GLChartOfAccounts ON ChartOfAccounts = _GLChartOfAccounts.ChartOfAccounts  -- association [1..1]
LEFT OUTER JOIN I_FSItemMapping AS _Mapping ON FSItemMappingID = _Mapping.FSItemMappingID  -- association [1..1]
LEFT OUTER JOIN I_FSItemMappingRevision AS _MappingRevision ON ConsolidationChartOfAccounts = _MappingRevision.ConsolidationChartOfAccounts AND FSItemMappingID = _MappingRevision.FSItemMappingID AND ChartOfAccounts = _MappingRevision.ChartOfAccounts AND FSItemMappingRevision = _MappingRevision.FSItemMappingRevision  -- association [1..1]
LEFT OUTER JOIN I_FSItemMappingItem AS _MappingItem ON ConsolidationChartOfAccounts = _MappingItem.ConsolidationChartOfAccounts AND FSItemMappingID = _MappingItem.FSItemMappingID AND ChartOfAccounts = _MappingItem.ChartOfAccounts AND FSItemMappingRevision = _MappingItem.FSItemMappingRevision  -- association [1..*]
;