I_DraftAdminDataUserAuth_cc

DDL: I_DRAFTADMINDATAUSERAUTH_CC Type: view_entity

Coll. Draft User Authority x-client

I_DraftAdminDataUserAuth_cc is a CDS View that provides data about "Coll. Draft User Authority x-client" in SAP S/4HANA. It reads from 2 data sources (sdraft_user_cc, sdraft_admin_cc) and exposes 2 fields with key fields DraftUUID, DraftEntityType.

2 data source(s) 2 fields

Data Sources (2)

SourceAliasJoin Type
sdraft_user_cc CollaborationUser left_outer
sdraft_admin_cc DraftAdminData from

Annotations (2)

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

Fields (2)

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

@EndUserText.label: 'Coll. Draft User Authority x-client'
define view entity I_DraftAdminDataUserAuth_cc
  as select from    sdraft_admin_cc as DraftAdminData
    left outer join sdraft_user_cc  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.created_by    = $session.user
        and DraftAdminData.in_process_by = ''
      )
      or    DraftAdminData.in_process_by = $session.user
    )
  );
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"SDRAFT_ADMIN_CC",
"SDRAFT_USER_CC"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More