/SSB/CHIP_APP_VARIANTS

DDL: /SSB/CHIP_APP_VARIANTS SQL: /SSB/APPVARIANTS Type: view
14 Fields 8 Data Sources

App variants for all tiles

/SSB/CHIP_APP_VARIANTS is a CDS View that provides data about "App variants for all tiles" in SAP S/4HANA. It reads from 8 data sources and exposes 14 fields with key field ObjectId.

Data Sources (8)

SourceAliasJoin Type
/ssb/ce_chips /ssb/ce_chips union_all
/ssb/chip /ssb/chip union_all
/ssb/chips_s /ssb/chips_s union_all
/ssb/sacda_tile /ssb/sacda_tile union_all
/ssb/sactile_s /ssb/sactile_s from
/SSB/SAPCLIENT SC inner
/SSB/SAPCLIENT SC inner
/SSB/SAPCLIENT SC inner

Annotations (5)

NameValueLevelField
AbapCatalog.sqlViewName /SSB/APPVARIANTS view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label App variants for all tiles view
Metadata.ignorePropagatedAnnotations true view

Fields (14)

KeyFieldSource TableSource FieldDescription
KEY ObjectId /ssb/sactile_s id WorklistID
VariantId /ssb/sactile_s variant_id Variant Id
ObjectType
evaluation_idasObjectId
VariantId /ssb/chips_s variant_id Variant Id
ObjectType
VariantId variant_id Variant Id
ObjectType
VariantId variant_id Variant Id
ObjectType
idasObjectId
VariantId /ssb/sacda_tile variant_id Variant Id
ObjectType
created_on /ssb/sacda_tile created_on Variant created on

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/CHIP_APP_VARIANTS.
-- 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/APPVARIANTS

CREATE VIEW /SSB/CHIP_APP_VARIANTS AS
SELECT
  /ssb/sactile_s.id AS ObjectId,
  /ssb/sactile_s.variant_id AS VariantId,
  'SAC' AS ObjectType,
  /ssb/sactile_s.created_on AS evaluation_idasObjectId,
  created_on AS idasObjectId,
  /ssb/sacda_tile.created_on AS created_on
FROM /ssb/sactile_s
INNER JOIN /SSB/SAPCLIENT AS SC ON /* join condition not captured in parsed metadata */
-- UNION ALL with additional select branch(es): /ssb/chips_s, /ssb/chip, /ssb/ce_chips, /ssb/sacda_tile
;

Learn More