C_ChFiExBusinessContextTP

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_ChFiExBusinessContextTP.
-- 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: CCHFIEXBUSCON

CREATE VIEW C_ChFiExBusinessContextTP AS
SELECT
  ExtensibilityScenarioID,
  ExtensibilityBusinessContext,
  ObjectType,
  ClassType,
  ExtensibilityStatus,
  SecdryPerStatus,
  _ChFiExCharcStatusText.Criticality AS Criticality,
  _ChFiExSecdryPerStatusText.SecdryPerCriticality AS SecdryPerCriticality,
  SecdryPerEnabled,
  DraftEnabled,
  ChFiExContextIsObsolete,
  _ChFiExAtoSettings.ExtensibilityDevSystem AS ExtensibilityDevSystem
FROM I_ChFiExBusinessContextTP
LEFT OUTER JOIN C_ChFiExCharcAllocTP AS _ChFiExCharcAllocTP ON ExtensibilityScenarioID = _ChFiExCharcAllocTP.ExtensibilityScenarioID  -- association [1..*]
LEFT OUTER JOIN C_ChFiExBusinessContextText AS _ChFiExBusinessContextText ON ExtensibilityBusinessContext = _ChFiExBusinessContextText.BusinessContext AND _ChFiExBusinessContextText.Language = $session.system_language  -- association [1..1]
LEFT OUTER JOIN C_ChFiExClassTypeText AS _ChFiExClassTypeText ON _ChFiExClassTypeText.ClassType = ClassType AND _ChFiExClassTypeText.Language = $session.system_language  -- association [1..1]
LEFT OUTER JOIN C_ChFiExCharcStatusText AS _ChFiExCharcStatusText ON ExtensibilityStatus = _ChFiExCharcStatusText.Status  -- association [1..1]
LEFT OUTER JOIN C_ChFiExSecdryPerStatusText AS _ChFiExSecdryPerStatusText ON SecdryPerStatus = _ChFiExSecdryPerStatusText.Status  -- association [1..1]
LEFT OUTER JOIN C_ChFiExAtoSettings AS _ChFiExAtoSettings ON _ChFiExAtoSettings.ExtensibilitySAPClient = $session.client  -- association [1..1]
;