SAIS_DDIC_WUSL

DDL: SAIS_DDIC_WUSL Type: view_entity Package: SAIS_TOOLS
11 Fields 2 Data Sources

Get User Authorization Change Documents

SAIS_DDIC_WUSL is a CDS View that provides data about "Get User Authorization Change Documents" in SAP S/4HANA. It reads from 2 data sources (dd02l, dd03l) and exposes 11 fields. Part of development package SAIS_TOOLS.

Data Sources (2)

SourceAliasJoin Type
dd02l d02 from
dd03l d03 inner

Annotations (6)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label Get User Authorization Change Documents view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #MIXED view

Fields (11)

KeyFieldSource TableSource FieldDescription
tabname dd02l tabname Table/Constant Value
fieldname dd03l fieldname UI Group FieldName
pos dd03l position Test Position
keyflag dd03l keyflag Key field
rollname dd03l rollname Repr. Data Elem
domname dd03l domname Domain
datatype dd03l datatype Field Type
leng dd03l leng No. of Characters
cnt_all
cnt_val
ddtext

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_DDIC_WUSL.
-- 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.

CREATE VIEW SAIS_DDIC_WUSL AS
SELECT
  d02.tabname AS tabname,
  d03.fieldname AS fieldname,
  d03.position AS pos,
  d03.keyflag AS keyflag,
  d03.rollname AS rollname,
  d03.domname AS domname,
  d03.datatype AS datatype,
  d03.leng AS leng,
  cast( 0 as sytabix ) AS cnt_all,
  cast( 0 as sytabix ) AS cnt_val,
  coalesce( t02_s.ddtext, t02_e.ddtext ) AS ddtext
FROM dd02l AS d02
INNER JOIN dd03l AS d03 ON /* join condition not captured in parsed metadata */
;

Learn More