/SSB/CLOUD_CHIPS

DDL: /SSB/CLOUD_CHIPS SQL: /SSB/CCHIPS Type: view
16 Fields 1 Data Sources 2 Associations

SSB: Core CE Chips

/SSB/CLOUD_CHIPS is a CDS View that provides data about "SSB: Core CE Chips" in SAP S/4HANA. It reads from 1 data source (/SSB/UNION_CE_CHIPS_DET) and exposes 16 fields with key field id. It has 2 associations to related views.

Data Sources (1)

SourceAliasJoin Type
/SSB/UNION_CE_CHIPS_DET /SSB/UNION_CE_CHIPS_DET from

Associations (2)

CardinalityTargetAliasCondition
[0..*] /SSB/CORE_DEFAULT_PARAMS _DEF_PARAMS _DEF_PARAMS.chip_id = /SSB/UNION_CE_CHIPS_DET.id
[0..*] /SSB/UNION_SAC_NAV_INTENTS _NAV_INTENT _NAV_INTENT.chip_id = /SSB/UNION_CE_CHIPS_DET.id

Annotations (9)

NameValueLevelField
AbapCatalog.preserveKey true view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.sqlViewName /SSB/CCHIPS view
ObjectModel.usageType.dataClass #META view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #M view
AccessControl.authorizationCheck #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label SSB: Core CE Chips view

Fields (16)

KeyFieldSource TableSource FieldDescription
KEY id /SSB/UNION_CE_CHIPS_DET id WorklistID
namespace /SSB/UNION_CE_CHIPS_DET namespace Parameter Namespace
type /SSB/UNION_CE_CHIPS_DET type Worklist Type
chip_config /SSB/UNION_CE_CHIPS_DET chip_config Chip Config
catalog_id /SSB/UNION_CE_CHIPS_DET catalog_id UUID
variant_id /SSB/UNION_CE_CHIPS_DET variant_id Variant Id
fiori_id /SSB/UNION_CE_CHIPS_DET fiori_id SAP Fiori ID
chip_mode /SSB/UNION_CE_CHIPS_DET chip_mode Chip Mode
parent_id /SSB/UNION_CE_CHIPS_DET parent_id UUID
parent_name /SSB/UNION_CE_CHIPS_DET parent_name Parent Name
TenantAlias /SSB/UNION_CE_CHIPS_DET TenantAlias System Alias
TenantType /SSB/UNION_CE_CHIPS_DET TenantType Tenant Type
title /SSB/UNION_CE_CHIP_TEXTS title View Title
subtitle /SSB/UNION_CE_CHIP_TEXTS subtitle Subtitle
_DEF_PARAMS _DEF_PARAMS
_NAV_INTENT _NAV_INTENT

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/CLOUD_CHIPS.
-- 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/CCHIPS

CREATE VIEW /SSB/CLOUD_CHIPS AS
SELECT
  /SSB/UNION_CE_CHIPS_DET.id AS id,
  /SSB/UNION_CE_CHIPS_DET.namespace AS namespace,
  /SSB/UNION_CE_CHIPS_DET.type AS type,
  /SSB/UNION_CE_CHIPS_DET.chip_config AS chip_config,
  /SSB/UNION_CE_CHIPS_DET.catalog_id AS catalog_id,
  /SSB/UNION_CE_CHIPS_DET.variant_id AS variant_id,
  /SSB/UNION_CE_CHIPS_DET.fiori_id AS fiori_id,
  /SSB/UNION_CE_CHIPS_DET.chip_mode AS chip_mode,
  /SSB/UNION_CE_CHIPS_DET.parent_id AS parent_id,
  /SSB/UNION_CE_CHIPS_DET.parent_name AS parent_name,
  /SSB/UNION_CE_CHIPS_DET.TenantAlias AS TenantAlias,
  /SSB/UNION_CE_CHIPS_DET.TenantType AS TenantType,
  /SSB/UNION_CE_CHIP_TEXTS.title AS title,
  /SSB/UNION_CE_CHIP_TEXTS.subtitle AS subtitle
FROM /SSB/UNION_CE_CHIPS_DET
LEFT OUTER JOIN /SSB/CORE_DEFAULT_PARAMS AS _DEF_PARAMS ON _DEF_PARAMS.chip_id = /SSB/UNION_CE_CHIPS_DET.id  -- association [0..*]
LEFT OUTER JOIN /SSB/UNION_SAC_NAV_INTENTS AS _NAV_INTENT ON _NAV_INTENT.chip_id = /SSB/UNION_CE_CHIPS_DET.id  -- association [0..*]
;

Learn More