P_Cfd_Business_Context

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_Cfd_Business_Context.
-- 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: P_CFD_BUS_CTX

CREATE VIEW P_Cfd_Business_Context AS
SELECT
  Context.business_context AS BusinessContext,
  Context.persistence_context_suffix AS BusinessContextSuffix,
  Context.release_status AS ReleaseStatus,
  Context.availability AS Availability,
  Context.structural_enhancement AS SupportsStructuralEnhancements,
  Context.logic_enhancement AS SupportsLogicEnhancements,
  Context.characteristics_relevant AS CharacteristicsRelevant,
  Context.uppercase_only_code_lists AS UppercaseOnlyCodeLists,
  coalesce( coalesce( _textsessionlanguage.Description, _textfallbacklanguage.Description ), Context.business_context ) AS Description,
  _textsessionlanguage.RegistryText AS DescriptionRegCurrentLanguage,
  _textsessionlanguage.DdlText AS DescriptionDdlCurrentLanguage,
  _textfallbacklanguage.RegistryText AS DescriptionRegFallbackLanguage,
  _textfallbacklanguage.DdlText AS DescriptionDdlFallbackLanguage
FROM cfd_w_bus_ctxt AS Context
LEFT OUTER JOIN P_Cfd_Business_Context_Text AS _Text ON BusinessContext = _Text.BusinessContext  -- association [1..*]
LEFT OUTER JOIN P_Cfd_Business_Context_Text AS _textsessionlanguage ON BusinessContext = _textsessionlanguage.BusinessContext AND _textsessionlanguage.Description is not null AND not _textsessionlanguage.Description = '' AND _textsessionlanguage.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN P_Cfd_Business_Context_Text AS _textfallbacklanguage ON BusinessContext = _textfallbacklanguage.BusinessContext AND _textfallbacklanguage.Description is not null AND not _textfallbacklanguage.Description = '' AND _textfallbacklanguage.Language = 'E'  -- association [0..1]
LEFT OUTER JOIN I_CFD_Release_Status AS _ReleaseStatus ON ReleaseStatus = _ReleaseStatus.Code  -- association [1]
;