P_USERATTRIBUTES
User Attribute Assignments
P_USERATTRIBUTES is a CDS View that provides data about "User Attribute Assignments" in SAP S/4HANA. It reads from 2 data sources (usr_attr_id, P_USR02) and exposes 4 fields with key fields bname, attr_id. Part of development package SUSR.
Data Sources (2)
| Source | Alias | Join Type |
|---|---|---|
| usr_attr_id | UserAttributes | left_outer |
| P_USR02 | UserExistence | from |
Annotations (7)
| Name | Value | Level | Field |
|---|---|---|---|
| AbapCatalog.extensibility.extensible | false | view | |
| AccessControl.authorizationCheck | #CHECK | view | |
| EndUserText.label | User Attribute Assignments | view | |
| ObjectModel.usageType.serviceQuality | #X | view | |
| ObjectModel.usageType.sizeCategory | #M | view | |
| ObjectModel.usageType.dataClass | #MIXED | view | |
| Metadata.allowExtensions | false | view |
Fields (4)
| Key | Field | Source Table | Source Field | Description |
|---|---|---|---|---|
| KEY | bname | P_USR02 | bname | |
| KEY | attr_id | usr_attr_id | attr_id | |
| attr_type | usr_attr_id | attr_type | ||
| class | P_USR02 | class |
@AbapCatalog: {
viewEnhancementCategory: [ #NONE ]
, extensibility: { extensible: false }
}
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'User Attribute Assignments'
@ObjectModel.usageType:{
serviceQuality: #X,
sizeCategory: #M,
dataClass: #MIXED
}
@Metadata: { allowExtensions: false }
// built for function module 'SUSR_USER_GET_DETAIL_MASS' (mass enabled 'BAPI_USER_GET_DETAIL')
// Parameter ET_USERATTRIBUTES with BAPIUSATTRIBUTE structure + username
define view entity P_USERATTRIBUTES
as select from P_USR02 as UserExistence
left outer join usr_attr_id as UserAttributes on UserExistence.bname = UserAttributes.bname
{
key UserExistence.bname,
key UserAttributes.attr_id,
UserAttributes.attr_type,
@Consumption.hidden: true
UserExistence.class
}
Learn More
- What Is a CDS View in SAP S/4HANA?
- Types of CDS Views: Basic, Composite, Consumption, and Transactional
- SAP Tables vs CDS Views — Key Differences
- Understanding Data Lineage in SAP S/4HANA
- VDM (Virtual Data Model) in SAP S/4HANA Explained
- CDS View Annotations — A Complete Guide
- CDS View Field Mapping and Associations
- Understanding the SAP S/4HANA Data Model
- CDS View Extensions and Custom Fields in SAP S/4HANA
- Released APIs and Stability Contracts in SAP S/4HANA