N_SBLE_CLG_BADI_W_BC

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_BC.
-- 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_BC AS
SELECT
  badi.badi_name AS ID,
  badiContext.business_context AS BusinessContext,
  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_ctxt AS badiContext
LEFT OUTER JOIN N_SBLE_CLG_BADI_N_OF_FILTERS AS badiFilters ON /* join condition not captured in parsed metadata */
;