I_DraftUserRole
Draft User Role
I_DraftUserRole is a CDS View that provides data about "Draft User Role" in SAP S/4HANA. It reads from 1 data source (dd07l) and exposes 3 fields with key field DraftUserRole. It has 1 association to related views.
Data Sources (1)
| Source | Alias | Join Type |
|---|---|---|
| dd07l | value | from |
Associations (1)
| Cardinality | Target | Alias | Condition |
|---|---|---|---|
| [0..*] | I_DraftUserRoleText | _Text | _Text.DraftUserRole = $projection.DraftUserRole |
Annotations (4)
| Name | Value | Level | Field |
|---|---|---|---|
| AccessControl.authorizationCheck | #NOT_REQUIRED | view | |
| EndUserText.label | Draft User Role | view | |
| Search.searchable | true | view | |
| ObjectModel.resultSet.sizeCategory | #XS | view |
Fields (3)
| Key | Field | Source Table | Source Field | Description |
|---|---|---|---|---|
| KEY | DraftUserRole | |||
| domvalue_h | domvalue_h | |||
| _Text | _Text |
@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'Draft User Role'
@Search.searchable: true
@ObjectModel : { resultSet.sizeCategory: #XS }
/*+[hideWarning] { "IDS" : [ "KEY_CHECK" ] }*/
define view entity I_DraftUserRole
as select from dd07l as value
association [0..*] to I_DraftUserRoleText as _Text on _Text.DraftUserRole = $projection.DraftUserRole
{
@Search.defaultSearchElement: true
@ObjectModel.text.association: '_Text'
key cast( substring( value.domvalue_l, 1, 1 ) as sdraft_user_role preserving type ) as DraftUserRole,
@Consumption.hidden:true
domvalue_h,
//@Consumption.hidden:true
_Text
}
where
value.domname = 'SDRAFT_USER_ROLE'
and value.domvalue_l is not initial
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"DD07L"
],
"ASSOCIATED":
[
"I_DRAFTUSERROLETEXT"
],
"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