aps_iam_user_timestamp

DDL: APS_IAM_USER_TIMESTAMP SQL: APS_IAM_USR_TS Type: view Package: SR_APS_IAM_UTILS_ODATA

Business User Last Changed User

aps_iam_user_timestamp is a CDS View that provides data about "Business User Last Changed User" in SAP S/4HANA. It reads from 2 data sources (aps_user_ddl, usrstamp) and exposes 5 fields with key field UserID. Part of development package SR_APS_IAM_UTILS_ODATA.

2 data source(s) 5 fields

Data Sources (2)

SourceAliasJoin Type
aps_user_ddl aps_user_ddl left_outer
usrstamp usrstamp from

Annotations (4)

NameValueLevelField
AbapCatalog.sqlViewName APS_IAM_USR_TS view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Business User Last Changed User view

Fields (5)

KeyFieldSource TableSource FieldDescription
KEY UserID username
LastChangedDate moddate
LastChangedTime modtime
LastChangedUser modifier
LastChangedUserName UserDescription 
@AbapCatalog.sqlViewName: 'APS_IAM_USR_TS'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Business User Last Changed User'
define view aps_iam_user_timestamp
  as select from    usrstamp
    left outer join aps_user_ddl on usrstamp.modifier = aps_user_ddl.UserID
{
  key username                     as UserID,    
      moddate                      as LastChangedDate,
      modtime                      as LastChangedTime,
      cast( dats_tims_to_tstmp(moddate,
                           modtime,
                           abap_system_timezone( $session.client,'NULL' ),
                           $session.client,
                           'NULL') as timestamp) as LastChangedTimestamp, 
      modifier                     as LastChangedUser,
      UserDescription              as LastChangedUserName      
}

Learn More