APS_COM_CU_A4C_QUERY

DDL: APS_COM_CU_A4C_QUERY Type: view_entity Package: SR_APS_COM_PUB_A4C
12 Fields 1 Data Sources 2 Associations

Query Comm. User

APS_COM_CU_A4C_QUERY is a CDS View that provides data about "Query Comm. User" in SAP S/4HANA. It reads from 1 data source (usr02) and exposes 12 fields with key field UserID. It has 2 associations to related views. Part of development package SR_APS_COM_PUB_A4C.

Data Sources (1)

SourceAliasJoin Type
usr02 usr02 from

Associations (2)

CardinalityTargetAliasCondition
[0..1] APS_IAM_CUSR_CHANGED_BY _LastChangedInfo _LastChangedInfo.UserID = $projection.UserID
[0..1] usr_extuid _usrEXTUID _usrEXTUID.bname = $projection.UserID and _usrEXTUID.extuid_type = 'PA'

Annotations (6)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Query Comm. User view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #MIXED view

Fields (12)

KeyFieldSource TableSource FieldDescription
KEY UserID usr21 bname User name
UserName usrefus useralias Alias
Description usr21 techdesc Description
LockStatus usr02 uflag User Lock
UserGroup usr02 class User Group
CreationUser usr02 aname Creator
CreationDate usr02 erdat Entered On
LastLogonDate usr02 trdat Transfer Date
LastLogonTime usr02 ltime Time received
LastChangedUser _LastChangedInfo LastChangedUser
LastChangedTimestamp _LastChangedInfo LastChangedTimestamp
ExternalUserID _usrEXTUID extuid External UID

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_COM_CU_A4C_QUERY.
-- 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.

CREATE VIEW APS_COM_CU_A4C_QUERY AS
SELECT
  usr21.bname AS UserID,
  usrefus.useralias AS UserName,
  usr21.techdesc AS Description,
  usr02.uflag AS LockStatus,
  usr02.class AS UserGroup,
  usr02.aname AS CreationUser,
  usr02.erdat AS CreationDate,
  usr02.trdat AS LastLogonDate,
  usr02.ltime AS LastLogonTime,
  _LastChangedInfo.LastChangedUser AS LastChangedUser,
  _LastChangedInfo.LastChangedTimestamp AS LastChangedTimestamp,
  _usrEXTUID.extuid AS ExternalUserID
FROM usr02
LEFT OUTER JOIN APS_IAM_CUSR_CHANGED_BY AS _LastChangedInfo ON _LastChangedInfo.UserID = UserID  -- association [0..1]
LEFT OUTER JOIN usr_extuid AS _usrEXTUID ON _usrEXTUID.bname = UserID AND _usrEXTUID.extuid_type = 'PA'  -- association [0..1]
;

Learn More