s_sclt_customeruser_ddl

DDL: S_SCLT_CUSTOMERUSER_DDL SQL: S_SCLT_CUSTUSER Type: view Package: S_APS_ODATA_EXT_CLT
7 Fields 1 Data Sources

Customer User

s_sclt_customeruser_ddl is a CDS View that provides data about "Customer User" in SAP S/4HANA. It reads from 1 data source (usr02) and exposes 7 fields with key field UserID. Part of development package S_APS_ODATA_EXT_CLT.

Data Sources (1)

SourceAliasJoin Type
usr02 usr02 from

Annotations (2)

NameValueLevelField
AbapCatalog.sqlViewName S_SCLT_CUSTUSER view
EndUserText.label Customer User view

Fields (7)

KeyFieldSource TableSource FieldDescription
KEY UserID
UserName
Description
LockStatus usr02 uflag User Lock
CreationUser usr02 aname Creator
CreationDate usr02 erdat Entered On
UserGroupName usr02 class User Group

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 s_sclt_customeruser_ddl.
-- 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: S_SCLT_CUSTUSER

CREATE VIEW s_sclt_customeruser_ddl AS
SELECT
  cast( usr21.bname as sclt_user_name ) AS UserID,
  cast( usrefus.useralias as sclt_user_alias ) AS UserName,
  cast( usr21.techdesc as sclt_user_description ) AS Description,
  usr02.uflag AS LockStatus,
  usr02.aname AS CreationUser,
  usr02.erdat AS CreationDate,
  usr02.class AS UserGroupName
FROM usr02
;

Learn More