P_UserFullName
User Full Name
P_UserFullName is a Composite CDS View that provides data about "User Full Name" in SAP S/4HANA. It reads from 1 data source (I_User) and exposes 3 fields with key field UserID. It has 1 association to related views. Part of development package ODATA_MPE_MFGORDER.
Data Sources (1)
| Source | Alias | Join Type |
|---|---|---|
| I_User | I_User | from |
Associations (1)
| Cardinality | Target | Alias | Condition |
|---|---|---|---|
| [0..1] | I_AddressPersonName | _PersonName | _PersonName.AddressPersonID = $projection.AddressPersonID and _PersonName.AddressRepresentationCode = '' |
Annotations (7)
| Name | Value | Level | Field |
|---|---|---|---|
| Metadata.ignorePropagatedAnnotations | true | view | |
| ObjectModel.usageType.serviceQuality | #C | view | |
| ObjectModel.usageType.sizeCategory | #L | view | |
| ObjectModel.usageType.dataClass | #MIXED | view | |
| AccessControl.authorizationCheck | #PRIVILEGED_ONLY | view | |
| VDM.viewType | #COMPOSITE | view | |
| VDM.private | true | view |
Fields (3)
| Key | Field | Source Table | Source Field | Description |
|---|---|---|---|---|
| KEY | UserID | UserID | ||
| AddressPersonID | AddressPersonID | |||
| PersonFullName | _PersonName | PersonFullName |
@Metadata.ignorePropagatedAnnotations: true
@ObjectModel.usageType:{
serviceQuality: #C,
sizeCategory: #L,
dataClass: #MIXED
}
@AccessControl.authorizationCheck: #PRIVILEGED_ONLY // never expose directly
@VDM.viewType: #COMPOSITE
@VDM.private: true
define view entity P_UserFullName as select from I_User
association [0..1] to I_AddressPersonName as _PersonName on _PersonName.AddressPersonID = $projection.AddressPersonID
and _PersonName.AddressRepresentationCode = ''
{
key UserID,
AddressPersonID,
_PersonName.PersonFullName
}
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