I_DraftAdminDataUserAuth

DDL: I_DRAFTADMINDATAUSERAUTH Type: view_entity Package: SBOI_RAP_SERVICES_DSP_ADMIN

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. Part of development package SBOI_RAP_SERVICES_DSP_ADMIN.

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
    )
  );

Learn More