P_USER_LOGON

DDL: P_USER_LOGON SQL: PUSERLOGON Type: view BASIC
8 Fields 1 Data Sources 1 Associations

Suche nach Logondaten

P_USER_LOGON is a Basic CDS View that provides data about "Suche nach Logondaten" in SAP S/4HANA. It reads from 1 data source (usr02) and exposes 8 fields with key field bname. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
usr02 _usr02 from

Associations (1)

CardinalityTargetAliasCondition
[0..1] usrefus _usrefus _usr02.bname = _usrefus.bname

Annotations (7)

NameValueLevelField
VDM.private true view
AbapCatalog.sqlViewName PUSERLOGON view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Suche nach Logondaten view
VDM.viewType #BASIC view

Fields (8)

KeyFieldSource TableSource FieldDescription
KEY bname usr02 bname User name
gltgv usr02 gltgv Valid from
gltgb usr02 gltgb Valid to
ustyp usr02 ustyp User Type
class usr02 class User Group
accnt usr02 accnt Number
useralias _usrefus useralias Alias
refuser _usrefus refuser Reference user

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 P_USER_LOGON.
-- 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: PUSERLOGON

CREATE VIEW P_USER_LOGON AS
SELECT
  _usr02.bname AS bname,
  _usr02.gltgv AS gltgv,
  _usr02.gltgb AS gltgb,
  _usr02.ustyp AS ustyp,
  _usr02.class AS class,
  _usr02.accnt AS accnt,
  _usrefus.useralias AS useralias,
  _usrefus.refuser AS refuser
FROM usr02 AS _usr02
LEFT OUTER JOIN usrefus AS _usrefus ON _usr02.bname = _usrefus.bname  -- association [0..1]
;

Learn More