Accessible_Views_Comp

DDL: ACCESSIBLE_VIEWS_COMP SQL: ACCESSVIEWSCOMP Type: view Package: S_DICT_VB

Accessible Views - S_RS_COMP validation

Accessible_Views_Comp is a CDS View that provides data about "Accessible Views - S_RS_COMP validation" in SAP S/4HANA. It reads from 3 data sources (CDS_VIEW_FIRST_REFERENCE, ust12, ust12) and exposes 2 fields. Part of development package S_DICT_VB.

Data Sources (3)

SourceAliasJoin Type
CDS_VIEW_FIRST_REFERENCE allViews inner
ust12 compID inner
ust12 infoCube inner

Parameters (1)

NameTypeDefault
P_User syuname

Annotations (5)

NameValueLevelField
AbapCatalog.sqlViewName ACCESSVIEWSCOMP view
EndUserText.label Accessible Views - S_RS_COMP validation view
ObjectModel.usageType.serviceQuality #P view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.authorizationCheck #NOT_REQUIRED view

Fields (2)

KeyFieldSource TableSource FieldDescription
CSQLViewName CDS_VIEW_FIRST_REFERENCE CSQLViewName
SqlViewName CDS_VIEW_FIRST_REFERENCE SqlViewName View Name

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 Accessible_Views_Comp.
-- 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: ACCESSVIEWSCOMP
-- Parameters: P_User : syuname

CREATE VIEW Accessible_Views_Comp AS
SELECT
  allViews.CSQLViewName AS CSQLViewName,
  allViews.SqlViewName AS SqlViewName
INNER JOIN ust12 AS compID ON /* join condition not captured in parsed metadata */
INNER JOIN ust12 AS infoCube ON /* join condition not captured in parsed metadata */
INNER JOIN CDS_VIEW_FIRST_REFERENCE AS allViews ON /* join condition not captured in parsed metadata */
;