I_ACMRoleAssignmentForUser

DDL: I_ACMROLEASSIGNMENTFORUSER SQL: IACMUSRROLASGNT Type: view BASIC
4 Fields 1 Data Sources

Interface layer for role assigned to the user

I_ACMRoleAssignmentForUser is a Basic CDS View that provides data about "Interface layer for role assigned to the user" in SAP S/4HANA. It reads from 1 data source (agr_users) and exposes 4 fields with key fields LogAccMActyGrpProfileRoleName, SessionUser.

Data Sources (1)

SourceAliasJoin Type
agr_users agr_users from

Annotations (12)

NameValueLevelField
AbapCatalog.sqlViewName IACMUSRROLASGNT view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ClientHandling.type #INHERITED view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #BASIC view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
Metadata.ignorePropagatedAnnotations true view
EndUserText.label Interface layer for role assigned to the user view

Fields (4)

KeyFieldSource TableSource FieldDescription
KEY LogAccMActyGrpProfileRoleName agr_name Role
KEY SessionUser uname User Name
CharcFromDate from_dat Start date
CharcToDate to_dat End date

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_ACMRoleAssignmentForUser.
-- 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: IACMUSRROLASGNT

CREATE VIEW I_ACMRoleAssignmentForUser AS
SELECT
  agr_name AS LogAccMActyGrpProfileRoleName,
  uname AS SessionUser,
  from_dat AS CharcFromDate,
  to_dat AS CharcToDate
FROM agr_users
;

Learn More