C_FSItemMappingHeader

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_FSItemMappingHeader.
-- 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 C_FSItemMappingHeader AS
SELECT
  FSItemMappingUUID,
  ConsolidationChartOfAccounts,
  ChartOfAccounts,
  FSItemMappingID,
  FSItemMappingRevision,
  _ConsChartOfAccounts._Text[1:Language = $session.system_language].ConsolidationChartOfAcctsText AS ConsolidationChartOfAcctsText,
  _GLChartOfAccounts._Text[1:Language = $session.system_language].ChartOfAccountsName AS ChartOfAccountsName,
  _Mapping._Text[1:Language = $session.system_language].FSItemMappingName AS FSItemMappingName,
  _Revision._Text[1:Language = $session.system_language].FSItemMappingRevisionText AS FSItemMappingRevisionText,
  TotalNmbrOfMappedGLAccounts,
  TotalNmbrOfNotMappedGLAccounts,
  TotalNmbrOfFinStmntItems,
  IsActiveEntity,
  HasActiveEntity,
  HasDraftEntity,
  cast('' as abap_boolean) AS FSItemMappingIsAssigned,
  cast(case when QueueTimeInSeconds < 10 then 'X' else '' end as abap_boolean) AS FSItemMappingIsNew,
  CreationDateTime,
  cast ( case when _LastChangeByUser.FullName is not initial then _LastChangeByUser.FullName else LastChangeByUser end as vdm_userdescription ) AS UserDescription,
  LastChangeDateTime
FROM I_FSItemMappingHeaderDef
LEFT OUTER JOIN C_CnsldtnChartOfAccountsVH AS _ConsChartOfAccountsVH ON ConsolidationChartOfAccounts = _ConsChartOfAccountsVH.ConsolidationChartOfAccounts  -- association [0..1]
LEFT OUTER JOIN C_CnsldtnGLChartOfAccountsVH AS _GLChartOfAccountsVH ON ChartOfAccounts = _GLChartOfAccountsVH.ChartOfAccounts  -- association [0..1]
LEFT OUTER JOIN C_FSItemMappingVH AS _MappingVH ON FSItemMappingID = _MappingVH.FSItemMappingID  -- association [0..1]
LEFT OUTER JOIN C_FSItemMappingHeaderDef AS _HeaderTP ON FSItemMappingUUID = _HeaderTP.FSItemMappingUUID  -- association [1..1]
LEFT OUTER JOIN C_FSItemMappingRevision AS _MappingRevisionVH ON ConsolidationChartOfAccounts = _MappingRevisionVH.ConsolidationChartOfAccounts AND ChartOfAccounts = _MappingRevisionVH.ChartOfAccounts AND FSItemMappingID = _MappingRevisionVH.FSItemMappingID AND FSItemMappingRevision = _MappingRevisionVH.FSItemMappingRevision  -- association [0..1]
-- UNION ALL with additional select branch(es): I_FSItemMappingHeaderDef
;