APS_IAM_REP_ACTIVE_USR

DDL: APS_IAM_REP_ACTIVE_USR SQL: APS_IAM_REP_AC Type: view Package: SR_APS_IAM_REP_ODATA
10 Fields 1 Data Sources

IAM Key Figures App Active user

APS_IAM_REP_ACTIVE_USR is a CDS View that provides data about "IAM Key Figures App Active user" in SAP S/4HANA. It reads from 1 data source (aps_iam_busr_core) and exposes 10 fields with key field UserID. Part of development package SR_APS_IAM_REP_ODATA.

Data Sources (1)

SourceAliasJoin Type
aps_iam_busr_core aps_iam_busr_core from

Annotations (5)

NameValueLevelField
AbapCatalog.sqlViewName APS_IAM_REP_AC view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label IAM Key Figures App Active user view

Fields (10)

KeyFieldSource TableSource FieldDescription
KEY UserID UserID User Name
UserName UserName User who owns item
LockStatus LockStatus User Lock
FirstName FirstName First Name
LastName LastName Last Name
FullName FullName Name
CreationUser CreationUser Creation User
CreationDate CreationDate Time Stamp
LastLogonDate LastLogonDate Transfer Date
LastLoginDays

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view APS_IAM_REP_ACTIVE_USR.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.
-- SQL view name: APS_IAM_REP_AC

CREATE VIEW APS_IAM_REP_ACTIVE_USR AS
SELECT
  UserID,
  UserName,
  LockStatus,
  FirstName,
  LastName,
  FullName,
  CreationUser,
  CreationDate,
  LastLogonDate,
  DATS_DAYS_BETWEEN( LastLogonDate, cast($session.system_date as dats) ) AS LastLoginDays
FROM aps_iam_busr_core
;

Learn More