I_Acmusr02

DDL: I_ACMUSR02 SQL: IACMUSR02 Type: view BASIC
16 Fields 1 Data Sources

View of user-table: USR02, used by ACM

I_Acmusr02 is a Basic CDS View that provides data about "View of user-table: USR02, used by ACM" in SAP S/4HANA. It reads from 1 data source (usr02) and exposes 16 fields with key field bname.

Data Sources (1)

SourceAliasJoin Type
usr02 usr02 from

Annotations (5)

NameValueLevelField
AbapCatalog.sqlViewName IACMUSR02 view
AbapCatalog.compiler.compareFilter true view
VDM.viewType #BASIC view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label View of user-table: USR02, used by ACM view

Fields (16)

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
uflag usr02 uflag User Lock
accnt usr02 accnt Number
aname usr02 aname Creator
erdat usr02 erdat Entered On
trdat usr02 trdat Transfer Date
ltime usr02 ltime Time received
versn usr02 versn Version
codvn usr02 codvn Code Version
tzone usr02 tzone Time Zone Difference
zbvmaster usr02 zbvmaster CUA User
reserved usr02 reserved Reserved

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 I_Acmusr02.
-- 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: IACMUSR02

CREATE VIEW I_Acmusr02 AS
SELECT
  usr02.bname AS bname,
  usr02.gltgv AS gltgv,
  usr02.gltgb AS gltgb,
  usr02.ustyp AS ustyp,
  usr02.class AS class,
  usr02.uflag AS uflag,
  usr02.accnt AS accnt,
  usr02.aname AS aname,
  usr02.erdat AS erdat,
  usr02.trdat AS trdat,
  usr02.ltime AS ltime,
  usr02.versn AS versn,
  usr02.codvn AS codvn,
  usr02.tzone AS tzone,
  usr02.zbvmaster AS zbvmaster,
  usr02.reserved AS reserved
FROM usr02
;

Learn More