BOC_STORY_APPS

DDL: BOC_STORY_APPS SQL: BOCSTORYAPPS Type: view Package: S_ANA_BEX_LAS
4 Fields 1 Data Sources 2 Associations

BOC Story : Apps created for BOC Stories

BOC_STORY_APPS is a CDS View that provides data about "BOC Story : Apps created for BOC Stories" in SAP S/4HANA. It reads from 1 data source (boc_story_chips) and exposes 4 fields with key fields app_id, story_id. It has 2 associations to related views. Part of development package S_ANA_BEX_LAS.

Data Sources (1)

SourceAliasJoin Type
boc_story_chips Apps from

Associations (2)

CardinalityTargetAliasCondition
[*] BOC_STORY_APP_TEXTS _Text Apps.app_id = _Text.app_id and Apps.story_id = _Text.story_id
[0..1] BOC_STORY_QUERIES _Query Apps.app_id = _Query.app_id and Apps.story_id = _Query.story_id

Annotations (5)

NameValueLevelField
AbapCatalog.sqlViewName BOCSTORYAPPS view
EndUserText.label BOC Story : Apps created for BOC Stories view
ObjectModel.usageType.serviceQuality #P view
AccessControl.authorizationCheck #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view

Fields (4)

KeyFieldSource TableSource FieldDescription
KEY app_id app_id Identifier
KEY story_id story_id Identifier
_Text _Text
_Query _Query

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 BOC_STORY_APPS.
-- 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: BOCSTORYAPPS

CREATE VIEW BOC_STORY_APPS AS
SELECT
  app_id,
  story_id
FROM boc_story_chips AS Apps
LEFT OUTER JOIN BOC_STORY_APP_TEXTS AS _Text ON Apps.app_id = _Text.app_id AND Apps.story_id = _Text.story_id  -- association [*]
LEFT OUTER JOIN BOC_STORY_QUERIES AS _Query ON Apps.app_id = _Query.app_id AND Apps.story_id = _Query.story_id  -- association [0..1]
;

Learn More