I_DraftAdminDataUserAuth

DDL: I_DRAFTADMINDATAUSERAUTH Type: view_entity

Coll. Draft User Authority

I_DraftAdminDataUserAuth is a CDS View that provides data about "Coll. Draft User Authority" in SAP S/4HANA. It reads from 2 data sources (sdraft_user, sdraft_admin) and exposes 2 fields with key fields DraftUUID, DraftEntityType.

2 data source(s) 2 fields

Data Sources (2)

SourceAliasJoin Type
sdraft_user CollaborationUser left_outer
sdraft_admin DraftAdminData from

Annotations (2)

NameValueLevelField
AccessControl.authorizationCheck #PRIVILEGED_ONLY view
EndUserText.label Coll. Draft User Authority view

Fields (2)

KeyFieldSource TableSource FieldDescription
KEY DraftUUID sdraft_admin draft_key
KEY DraftEntityType sdraft_admin draft_entity 
@AccessControl.authorizationCheck: #PRIVILEGED_ONLY

@EndUserText.label: 'Coll. Draft User Authority'
define view entity I_DraftAdminDataUserAuth
  as select from    sdraft_admin as DraftAdminData
    left outer join sdraft_user  as CollaborationUser on  DraftAdminData.draft_entity = CollaborationUser.draft_entity
                                                      and DraftAdminData.draft_key    = CollaborationUser.draft_key
                                                      and CollaborationUser.user_name = $session.user
{
  key DraftAdminData.draft_key    as DraftUUID,
  key DraftAdminData.draft_entity as DraftEntityType
}
where
  (
            DraftAdminData.access_type   = '2'
    and     CollaborationUser.user_name  = $session.user
    or      DraftAdminData.access_type   = '3'
  )
  or(
    (
      (
            DraftAdminData.created_by    = $session.user
        and DraftAdminData.in_process_by = ''
      )
      or    DraftAdminData.in_process_by = $session.user
    )
  );
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"SDRAFT_ADMIN",
"SDRAFT_USER"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More