n_sble_extension_point

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 n_sble_extension_point.
-- 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 n_sble_extension_point AS
SELECT
  cast( ExtensionPoint.badi_name as sclg_extension_point_id preserving type ) AS ID,
  cast( 'BLEB' as sclg_extension_point_type preserving type ) AS Type,
  cast( BusinessContext.business_context as cfd_business_context preserving type ) AS BusinessContext,
  cast( ' ' as nont_name ) AS SAPObjectNodeType,
  TypeDescription.TypeDescription AS TypeDescription,
  Cache.badi_description AS Description,
  Cache.badi_documentation AS Documentation,
  Cache.upper_badi_description AS UpperDescription,
  Cache.upper_badi_documentation AS UpperDocumentation,
  case when ExtensionPoint.availability = 'MULTITENAN' and NumberOfFilters.numberOf > 1 then 'X' when ExtensionPoint.availability <> 'MULTITENAN' and NumberOfFilters.numberOf > 0 then 'X' else ' ' end as HasAttributes AS numberOf0thenXelseendasHasAttributes,
  ExtensionPoint.availability AS Availability,
  ExtensionPoint.release_status AS ReleaseStatus
FROM cfd_w_badi AS ExtensionPoint
LEFT OUTER JOIN cfd_w_badi_ctxt AS BusinessContext ON /* join condition not captured in parsed metadata */
INNER JOIN N_SCLG_EP_TYPE_DESCRIPTION AS TypeDescription ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN sble_clg_badi_c AS Cache ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN N_SBLE_CLG_BADI_N_OF_FILTERS AS NumberOfFilters ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN N_SBLE_CLG_BADI_N_OF_IMPLEMENT AS NumberOfImplementations ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN N_SBLE_EP_IMPLEMENTATION AS _Implementation ON ExtensionPoint.badi_name = _Implementation.ExtensionPointID  -- association [0..1]
;