SUIM_US_DOCU

DDL: SUIM_US_DOCU Type: view_entity

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
modda usdocu modda
modti usdocu modti
modbe usdocu modbe
techdesc usr21 techdesc
responsible usr21 responsible
docu usdocu docu
gltgb usr02 gltgb
class usr02 class
usergroup usgrp_user usergroup
@AbapCatalog.viewEnhancementCategory: [#NONE]
@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'SUIM | Get User Documentation List'
@Metadata.ignorePropagatedAnnotations: true
@ObjectModel.usageType:{
    serviceQuality: #X,
    sizeCategory: #S,
    dataClass: #MIXED
}
//--------------------------------------------------------------

// respect report SUIM_SHOW_USDOCU and class CL_SUIM_US_DOCU

// in case of an changes

//--------------------------------------------------------------

define view entity SUIM_US_DOCU as select from usr02
  inner join usdocu on usr02.bname = usdocu.bname
  left outer join usr21 on usr02.bname = usr21.bname
  left outer join usgrp_user on usgrp_user.bname = usr02.bname
{
    key 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,
    usr02.security_policy as security_policy,
    usgrp_user.usergroup as usergroup
}

/*+[internal] {
"BASEINFO":
{
"FROM":
[
"USDOCU",
"USGRP_USER",
"USR02",
"USR21"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/