I_DraftAdministrativeUser

DDL: I_DRAFTADMINISTRATIVEUSER Type: view_entity

Draft Administrative Data Draft User

I_DraftAdministrativeUser is a CDS View that provides data about "Draft Administrative Data Draft User" in SAP S/4HANA. It reads from 2 data sources (sdraft_user, sdraft_user_cc) and exposes 11 fields with key fields DraftUUID, DraftEntityType, UserID, DraftEntityType, UserID. It is exposed through 2 OData services (UI_MANUALSPREADING, UI_PRICEALLOCATION).

2 data source(s) Exposed by 2 service(s) 11 fields

Data Sources (2)

SourceAliasJoin Type
sdraft_user DraftUser from
sdraft_user_cc DraftUser union_all

Annotations (5)

NameValueLevelField
AccessControl.authorizationCheck #PRIVILEGED_ONLY view
EndUserText.label Draft Administrative Data Draft User view
Search.searchable true view
Metadata.allowExtensions true view
Metadata.ignorePropagatedAnnotations true view

OData Services (2)

ServiceBindingVersionContractRelease
UI_MANUALSPREADING UI_MANUALSPREADING V4 C1 NOT_RELEASED
UI_PRICEALLOCATION UI_PRICEALLOCATION V4 C1 NOT_RELEASED

Fields (11)

KeyFieldSource TableSource FieldDescription
KEY DraftUUID sdraft_user_cc draft_key
KEY DraftEntityType sdraft_user_cc draft_entity
KEY UserID sdraft_user_cc user_name
UserAccessRole sdraft_user_cc user_role
UserEditingState sdraft_user_cc editing_state
draft_keyasDraftUUID
KEY DraftEntityType sdraft_user_cc draft_entity
KEY UserID sdraft_user_cc user_name
UserAccessRole sdraft_user_cc user_role
UserEditingState sdraft_user_cc editing_state
UserLastChangeDateTime sdraft_user_cc last_change_ts 
@AccessControl.authorizationCheck: #PRIVILEGED_ONLY
@EndUserText.label: 'Draft Administrative Data Draft User'

@Search.searchable: true
@Metadata.allowExtensions: true
@Metadata.ignorePropagatedAnnotations: true

@ObjectModel.semanticKey: ['UserID']

define view entity I_DraftAdministrativeUser
  as select from           sdraft_user as DraftUser
    left outer to one join usr21       as DraftUserDesc on DraftUserDesc.bname = DraftUser.user_name
{
      @UI.hidden
  key DraftUser.draft_key      as DraftUUID,

      @UI.hidden
  key DraftUser.draft_entity   as DraftEntityType,
      @ObjectModel.text.element: [ 'UserDescription'  ]
      @Search: { defaultSearchElement: true, fuzzinessThreshold: 0.8, ranking: #HIGH }
  key DraftUser.user_name      as UserID,

      @UI.hidden
      @Search: { defaultSearchElement: true, fuzzinessThreshold: 0.8, ranking: #HIGH }
      cast ( DraftUserDesc.techdesc
                as sdraft_user_description preserving type
           )                   as UserDescription,

      DraftUser.user_role      as UserAccessRole,
      DraftUser.editing_state  as UserEditingState,
      DraftUser.last_change_ts as UserLastChangeDateTime

}
union all

select from              sdraft_user_cc as DraftUser
  left outer to one join usr21          as DraftUserDesc on DraftUserDesc.bname = DraftUser.user_name
{

  key DraftUser.draft_key      as DraftUUID,
  key DraftUser.draft_entity   as DraftEntityType,
  key DraftUser.user_name      as UserID,
      cast ( DraftUserDesc.techdesc
                as sdraft_user_description preserving type
           )                   as UserDescription,
      DraftUser.user_role      as UserAccessRole,
      DraftUser.editing_state  as UserEditingState,
      DraftUser.last_change_ts as UserLastChangeDateTime

}

Learn More