/SSB/UNION_CE_CHIPS_DET

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 /SSB/UNION_CE_CHIPS_DET.
-- 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: /SSB/U_CECHIP

CREATE VIEW /SSB/UNION_CE_CHIPS_DET AS
SELECT
  /ssb/chips_s.id AS id,
  namespace,
  type,
  chip_config,
  catalog_id,
  cast(variant_id as /ssb/variant_id) AS variant_id,
  fiori_id,
  cast(1 as boc_chip_mode) AS chip_mode,
  /SSB/CORE_REPORT_CONFG.id AS parent_id,
  /SSB/CORE_REPORT_CONFG.ReportName AS parent_name,
  cast('' as /ssb/sac_tenant_alias) AS TenantAlias,
  '' as TenantType AS chip_idasid,
  sac_integ_c.sac_tenant_type AS TenantType
FROM /ssb/chips_s
INNER JOIN /SSB/SAPCLIENT AS SC ON /* join condition not captured in parsed metadata */
INNER JOIN /SSB/CORE_DATA_ANALYZER AS SACDataAnalyzer ON /* join condition not captured in parsed metadata */
INNER JOIN /SSB/CORE_SAC_STORIES AS SACStory ON /* join condition not captured in parsed metadata */
INNER JOIN sac_integ_c ON /* join condition not captured in parsed metadata */
-- UNION ALL with additional select branch(es): /ssb/ce_chips, /ssb/sacda_tile, /ssb/sactile_s, boc_story_chips
;