I_WorkViewStatusText
Work Perspective Basic Status - Text
I_WorkViewStatusText is a Basic CDS View that provides data about "Work Perspective Basic Status - Text" in SAP S/4HANA. It reads from 1 data source (dd07t) and exposes 5 fields with key fields Language, WorkViewStatus. It has 2 associations to related views.
Data Sources (1)
| Source | Alias | Join Type |
|---|---|---|
| dd07t | Status | from |
Associations (2)
| Cardinality | Target | Alias | Condition |
|---|---|---|---|
| [0..*] | I_WorkView | _WorkView | $projection.WorkViewStatus = _WorkView.WorkViewStatus |
| [0..1] | I_Language | _language | $projection.Language = _language.Language |
Annotations (9)
| Name | Value | Level | Field |
|---|---|---|---|
| AccessControl.authorizationCheck | #CHECK | view | |
| EndUserText.label | Work Perspective Basic Status - Text | view | |
| Metadata.ignorePropagatedAnnotations | true | view | |
| ObjectModel.usageType.serviceQuality | #A | view | |
| ObjectModel.usageType.sizeCategory | #L | view | |
| ObjectModel.usageType.dataClass | #MASTER | view | |
| ObjectModel.dataCategory | #TEXT | view | |
| ObjectModel.resultSet.sizeCategory | #XS | view | |
| VDM.viewType | #BASIC | view |
Fields (5)
| Key | Field | Source Table | Source Field | Description |
|---|---|---|---|---|
| KEY | Language | |||
| KEY | WorkViewStatus | |||
| WorkViewStatusText | ||||
| _language | _language | |||
| _WorkView | _WorkView |
@AbapCatalog.viewEnhancementCategory: [#NONE]
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Work Perspective Basic Status - Text'
@Metadata.ignorePropagatedAnnotations: true
@ObjectModel: {
usageType: {
serviceQuality: #A,
sizeCategory: #L,
dataClass: #MASTER } }
@ObjectModel.dataCategory: #TEXT
@ObjectModel.resultSet.sizeCategory: #XS
@VDM.viewType: #BASIC
/*+[hideWarning] { "IDS" : [ "KEY_CHECK", "CALCULATED_FIELD_CHECK" ] } */
define view entity I_WorkViewStatusText
as select from dd07t as Status
association [0..*] to I_WorkView as _WorkView on $projection.WorkViewStatus = _WorkView.WorkViewStatus
association [0..1] to I_Language as _language on $projection.Language = _language.Language
{
@Semantics.language: true
@Consumption.filter.hidden: true
key cast(ddlanguage as spras preserving type ) as Language,
@UI.textArrangement: #TEXT_ONLY
@ObjectModel.text.element: ['WorkViewStatusText']
@Consumption.filter.hidden: true
key cast( (substring(domvalue_l, 1, 1)) as ehfnd_wv_status preserving type ) as WorkViewStatus,
@Semantics.text: true
@Consumption.filter.hidden: true
cast( (substring(ddtext, 1, 60)) as ehfnd_cmplnc_prps_sts_name preserving type ) as WorkViewStatusText,
/* Associations */
_language,
_WorkView
}
where
domname = 'EHFND_WV_STATUS'
and ddlanguage = $session.system_language
and as4local = 'A'
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"DD07T"
],
"ASSOCIATED":
[
"I_LANGUAGE",
"I_WORKVIEW"
],
"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