SUIM_US_DOCU

DDL: SUIM_US_DOCU Type: view_entity
10 Fields 4 Data Sources

SUIM | Get User Documentation List

SUIM_US_DOCU is a CDS View that provides data about "SUIM | Get User Documentation List" in SAP S/4HANA. It reads from 4 data sources (usdocu, usgrp_user, usr02, usr21) and exposes 10 fields with key field bname.

Data Sources (4)

SourceAliasJoin Type
usdocu usdocu inner
usgrp_user usgrp_user left_outer
usr02 usr02 from
usr21 usr21 left_outer

Annotations (6)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label SUIM | Get User Documentation List view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #MIXED view

Fields (10)

KeyFieldSource TableSource FieldDescription
KEY bname usdocu bname User name
modda usdocu modda Modification date
modti usdocu modti Modification time
modbe usdocu modbe Changed By
techdesc usr21 techdesc Description
responsible usr21 responsible User Name
docu usdocu docu Schema Documentation
gltgb usr02 gltgb Valid to
class usr02 class User Group
usergroup usgrp_user usergroup User Group

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 SUIM_US_DOCU.
-- 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 SUIM_US_DOCU AS
SELECT
  usdocu.bname AS bname,
  usdocu.modda AS modda,
  usdocu.modti AS modti,
  usdocu.modbe AS modbe,
  usr21.techdesc AS techdesc,
  usr21.responsible AS responsible,
  usdocu.docu AS docu,
  usr02.gltgb AS gltgb,
  usr02.class AS class,
  usgrp_user.usergroup AS usergroup
FROM usr02
INNER JOIN usdocu ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN usr21 ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN usgrp_user ON /* join condition not captured in parsed metadata */
;

Learn More