C_FSItemMappedHeader

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 C_FSItemMappedHeader.
-- 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: CFSMMAPPEDHDR

CREATE VIEW C_FSItemMappedHeader AS
SELECT
  cast(concat(concat(concat(FSItemMappingID,FSItemMappingRevision),ChartOfAccounts),ConsolidationChartOfAccounts) as fincs_md_record_id) AS AdditionalMasterDataCode,
  ConsolidationChartOfAccounts,
  _ChartOfAccountsVH.ConsolidationChartOfAcctsText AS ConsolidationChartOfAcctsText,
  ChartOfAccounts,
  _GLChartOfAccountsVH.ChartOfAccountsName AS ChartOfAccountsName,
  FSItemMappingID,
  _MappingVH.FSItemMappingName AS FSItemMappingName,
  FSItemMappingRevision,
  _MappingRevisionVH.FSItemMappingRevisionText AS FSItemMappingRevisionText
FROM I_FSItemMappingRevision
LEFT OUTER JOIN C_FSItemMappedCnsldtnChtAccts AS _ChartOfAccountsVH ON ConsolidationChartOfAccounts = _ChartOfAccountsVH.ConsolidationChartOfAccounts  -- association [1..1]
LEFT OUTER JOIN C_FSItemMappedGLChtAccts AS _GLChartOfAccountsVH ON ConsolidationChartOfAccounts = _GLChartOfAccountsVH.ConsolidationChartOfAccounts AND ChartOfAccounts = _GLChartOfAccountsVH.ChartOfAccounts  -- association [1..1]
LEFT OUTER JOIN C_FSItemMappedMappingID AS _MappingVH ON ConsolidationChartOfAccounts = _MappingVH.ConsolidationChartOfAccounts AND ChartOfAccounts = _MappingVH.ChartOfAccounts AND FSItemMappingID = _MappingVH.FSItemMappingID  -- association [1..1]
LEFT OUTER JOIN C_FSItemMappingRevision AS _MappingRevisionVH ON ConsolidationChartOfAccounts = _MappingRevisionVH.ConsolidationChartOfAccounts AND FSItemMappingID = _MappingRevisionVH.FSItemMappingID AND ChartOfAccounts = _MappingRevisionVH.ChartOfAccounts AND FSItemMappingRevision = _MappingRevisionVH.FSItemMappingRevision  -- association [1..1]
;