VB_CDSVIEW_APPS

DDL: VB_CDSVIEW_APPS SQL: CDSAPPS Type: view Package: S_DICT_VB
8 Fields 2 Data Sources 1 Associations

view for apps entity set

VB_CDSVIEW_APPS is a CDS View that provides data about "view for apps entity set" in SAP S/4HANA. It reads from 2 data sources (report_chips, VB_CDSVIEWS_LANGUAGE) and exposes 8 fields with key field app_id. It has 1 association to related views. Part of development package S_DICT_VB.

Data Sources (2)

SourceAliasJoin Type
report_chips report_chips from
VB_CDSVIEWS_LANGUAGE VB_CDSVIEWS_LANGUAGE left_outer

Associations (1)

CardinalityTargetAliasCondition
[0..*] VB_GET_LANG_DETAILS _Text report_chips.app_id = _Text.app_id

Annotations (5)

NameValueLevelField
AbapCatalog.sqlViewName CDSAPPS view
EndUserText.label view for apps entity set view
ObjectModel.usageType.serviceQuality #P view
AccessControl.authorizationCheck #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view

Fields (8)

KeyFieldSource TableSource FieldDescription
KEY app_id app_id Identifier
language report_chips language Report Text Language
LanguageISOCode LanguageISOCode Language ISO Code
title title View Title
subtitle subtitle Subtitle
app_type app_type Application Type
logsys logsys Source system
_Text _Text

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 VB_CDSVIEW_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: CDSAPPS

CREATE VIEW VB_CDSVIEW_APPS AS
SELECT
  app_id,
  report_chips.language AS language,
  LanguageISOCode,
  title,
  subtitle,
  app_type,
  logsys
FROM report_chips
LEFT OUTER JOIN VB_CDSVIEWS_LANGUAGE ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN VB_GET_LANG_DETAILS AS _Text ON report_chips.app_id = _Text.app_id  -- association [0..*]
;

Learn More