C_DrctActivityAllocationUserVH
Created By
C_DrctActivityAllocationUserVH is a Consumption CDS View that provides data about "Created By" in SAP S/4HANA. It reads from 1 data source (I_User) and exposes 4 fields with key field UserID. It has 1 association to related views.
Data Sources (1)
| Source | Alias | Join Type |
|---|---|---|
| I_User | _User | from |
Associations (1)
| Cardinality | Target | Alias | Condition |
|---|---|---|---|
| [0..*] | R_DirectActivityAllocation | _DirectActivityAllocation | _User.UserID = _DirectActivityAllocation.AccountingDocCreatedByUser |
Annotations (11)
| Name | Value | Level | Field |
|---|---|---|---|
| EndUserText.label | Created By | view | |
| AccessControl.authorizationCheck | #MANDATORY | view | |
| AccessControl.personalData.blocking | #BLOCKED_DATA_EXCLUDED | view | |
| VDM.viewType | #CONSUMPTION | view | |
| ObjectModel.dataCategory | #VALUE_HELP | view | |
| ObjectModel.representativeKey | UserID | view | |
| ObjectModel.usageType.serviceQuality | #C | view | |
| ObjectModel.usageType.sizeCategory | #L | view | |
| ObjectModel.usageType.dataClass | #MIXED | view | |
| Search.searchable | true | view | |
| Consumption.ranked | true | view |
@AbapCatalog.viewEnhancementCategory: [#NONE]
@EndUserText.label: 'Created By'
@AccessControl: { authorizationCheck: #MANDATORY,
personalData.blocking: #BLOCKED_DATA_EXCLUDED }
@VDM.viewType: #CONSUMPTION
@ObjectModel.dataCategory: #VALUE_HELP
@ObjectModel.representativeKey: 'UserID'
@ObjectModel.usageType: { serviceQuality: #C,
sizeCategory: #L,
dataClass: #MIXED }
@Search.searchable: true
@Consumption.ranked: true
define view entity C_DrctActivityAllocationUserVH
as select from I_User as _User
association [0..*] to R_DirectActivityAllocation as _DirectActivityAllocation on _User.UserID = _DirectActivityAllocation.AccountingDocCreatedByUser
{
@UI.textArrangement: #TEXT_LAST
@ObjectModel.text.element: ['UserDescription']
@Search: { defaultSearchElement: true,
ranking: #HIGH,
fuzzinessThreshold: 0.8 }
key _User.UserID,
@Search: { defaultSearchElement: true,
ranking: #LOW,
fuzzinessThreshold: 0.8 }
_User.UserDescription,
cast (IsTechnicalUser as fco_io_is_technical_user preserving type ) as IsTechnicalUser,
// For Access control
@Consumption.hidden: true
_DirectActivityAllocation
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_USER"
],
"ASSOCIATED":
[
"R_DIRECTACTIVITYALLOCATION"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/
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