APS_USER_DDL

CDS View

User

APS_USER_DDL is a CDS View in S/4HANA. User. It contains 2 fields. 22 CDS views read from this table.

Used by 22 CDS view(s) 2 fields

CDS Views using this table (22)

ViewTypeJoinVDMDescription
APS_COM_COMM_IBS view left_outer COM: Inbound Scenarios
APS_COM_COMM_IBS_CUST_AUX view left_outer Auxiliary Custom IBS view w/ all services
APS_COM_COMM_OBS view left_outer COM: Outbound Services
aps_com_cs_csmpt view left_outer Custom Communication Scenarios
aps_com_ibs_pub_ddl view left_outer Inbound Service
aps_iam_app_ddl view left_outer Applications
APS_IAM_BROLE_ACC_CAT_CHG view_entity left_outer Business Role Access Category changes
APS_IAM_BROLE_ACC_RSTR_RT_CHG view_entity left_outer Access restriction type changes
APS_IAM_BROLE_APP_CHG view_entity left_outer Business Role app changes
APS_IAM_BROLE_CAT_CHG view_entity left_outer Business Role catalog changes
APS_IAM_BROLE_GEN_CHG view_entity left_outer General Business role changes
APS_IAM_BROLE_RSTR_CHG view_entity left_outer Business Role Restriction changes
APS_IAM_BROLE_RSTR_VAL_CHG view_entity left_outer Business Role Restriction Value changes
APS_IAM_BROLE_RVAL_HIGH_CHG view_entity left_outer Restriction high value changes
APS_IAM_BROLE_RVAL_LOW_CHG view_entity left_outer Restriction low value changes
APS_IAM_BROLE_RVAL_NAMES view_entity left_outer Field names of restriction values changed
APS_IAM_BROLE_SPACE_CHG view_entity left_outer Business Role Space changes
APS_IAM_BROLE_USR_CHG view_entity left_outer Business Role User changes
aps_iam_user_timestamp view left_outer Business User Last Changed User
I_APS_COM_CS_CSMPT_D view_entity left_outer Custom Communication Scenarios
I_APS_COM_IBS view_entity left_outer COM: Inbound Services Consumption view
I_APS_COM_OBS view_entity left_outer Outbound Services interface view

Fields (2)

KeyField CDS FieldsUsed in Views
UserDescription change_user_id,ChangedByUser,CreatedByUser 12
UserID UserID 12 
@ClientDependent: true
@AbapCatalog.sqlViewName: 'APS_USER'
@EndUserText.label: 'User'

// SAP_BASIS representation of the VDM CDS view "I_User".

// Users represent either persons or technical entities.

// Users created for persons, communication and printing are owned by the customer.

// All other users are owned by SAP.

// Because any kind of user can create or change data in the system, 

// fields like "CreatedByUser" or "LastChangedByUser" must refer to this entity via a "[0..1]" association

// to obtain a descriptive text of the user. It must not be assumed, that the target of the association exists.

// It must not be assumed that such a user always corresponds to a business partner of type person.

// This views must not be exposed to end users directly because it exposes person relevant information.

// It must only be used in the definition context specific consumption views as target for the "CreatedByUser"

// and "LastChangedByUser" associations.

define view aps_user_ddl as select from usr21

association [0..1]  to aps_bp                            as _BusinessPartner
                    on $projection.BusinessPartnerUUID  =  _BusinessPartner.businesspartneruuid
 {
    key cast( usr21.bname as APS_USERID )             as UserID
    ,   cast( usr21.techdesc as APS_USERDESCRIPTION ) as UserDescription
    ,   case usr21.idadtype
           when '02' then ' '
           when '04' then ' '
           else 'X'             
        end                                           as IsTechnicalUser

    // The BusinessPartnerUUID is only used for the association and shall not be used directly.

    ,  @Consumption.hidden:true
       bpperson                                       as BusinessPartnerUUID
    
    // Public associations

    , _BusinessPartner
}

Learn More