N_SBLE_CLG_BADI_W_CACHE

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_CLG_BADI_W_CACHE.
-- 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_CLG_BADI_W_CACHE AS
SELECT
  badi.badi_name AS ID,
  'BLEB' AS Type,
  badiCache.badi_description AS Description,
  badiCache.badi_documentation AS Documentation,
  badiCache.enhancement_spot_description AS ContainerDescription,
  badiCache.upper_badi_description AS UpperDescription,
  badiCache.upper_badi_documentation AS UpperDocumentation,
  badiCache.upper_enhancement_spot_descrip AS UpperContainerDescription,
  badi.availability AS Availability,
  badi.release_status AS ReleaseStatus,
  case when badi.availability = 'MULTITENAN' and badiFilters.numberOf > 1 then 'X' when badi.availability <> 'MULTITENAN' and badiFilters.numberOf > 0 then 'X' else '' end as HasAttributes AS numberOf0thenXelseendasHasAttributes
FROM cfd_w_badi AS badi
LEFT OUTER JOIN N_SBLE_CLG_BADI_N_OF_FILTERS AS badiFilters ON /* join condition not captured in parsed metadata */
;