SAIS_WBO_SUCU

DDL: SAIS_WBO_SUCU SQL: SAIS_WBOSUCU Type: view
7 Fields 3 Data Sources

Get object catalog entries for Authorization Groups

SAIS_WBO_SUCU is a CDS View that provides data about "Get object catalog entries for Authorization Groups" in SAP S/4HANA. It reads from 3 data sources (df14l, tadir, tdevc) and exposes 7 fields with key field brgru.

Data Sources (3)

SourceAliasJoin Type
df14l df14l left_outer
tadir TBRG_WBO from
tdevc tdevc left_outer

Annotations (5)

NameValueLevelField
AbapCatalog.sqlViewName SAIS_WBOSUCU view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Get object catalog entries for Authorization Groups view

Fields (7)

KeyFieldSource TableSource FieldDescription
KEY brgru Authorization Group
devclass tadir devclass Package (Obsolete)
dlvunit tdevc dlvunit Softw. Comp.
ps_posid df14l ps_posid WBS Element
srcsystem tadir srcsystem Source system
author tadir author User Name
masterlang tadir masterlang Single-Character Flag

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 SAIS_WBO_SUCU.
-- 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: SAIS_WBOSUCU

CREATE VIEW SAIS_WBO_SUCU AS
SELECT
  cast ( TBRG_WBO.obj_name as char30 ) AS brgru,
  TBRG_WBO.devclass AS devclass,
  tdevc.dlvunit AS dlvunit,
  df14l.ps_posid AS ps_posid,
  TBRG_WBO.srcsystem AS srcsystem,
  TBRG_WBO.author AS author,
  TBRG_WBO.masterlang AS masterlang
FROM tadir AS TBRG_WBO
LEFT OUTER JOIN tdevc ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN df14l ON /* join condition not captured in parsed metadata */
;

Learn More