I_QltyNotificationLongText
Quality Notification Longtext
I_QltyNotificationLongText is a Basic CDS View that provides data about "Quality Notification Longtext" in SAP S/4HANA. It reads from 1 data source (qmelltext) and exposes 12 fields with key fields QualityNotification, ItemCounter, Language. It has 2 associations to related views. Part of development package VDM_QM_NOTIFICATION.
Data Sources (1)
| Source | Alias | Join Type |
|---|---|---|
| qmelltext | qmelltext | from |
Associations (2)
| Cardinality | Target | Alias | Condition |
|---|---|---|---|
| [1..1] | I_QltyNotification | _QltyNotification | $projection.QualityNotification = _QltyNotification.QualityNotification |
| [1..1] | I_Language | _Language | $projection.Language = _Language.Language |
Annotations (10)
| Name | Value | Level | Field |
|---|---|---|---|
| AccessControl.authorizationCheck | #CHECK | view | |
| VDM.viewType | #BASIC | view | |
| ObjectModel.usageType.dataClass | #TRANSACTIONAL | view | |
| ObjectModel.usageType.sizeCategory | #L | view | |
| ObjectModel.usageType.serviceQuality | #C | view | |
| ObjectModel.representativeKey | ItemCounter | view | |
| ObjectModel.dataCategory | #TEXT | view | |
| Analytics.technicalName | IQNOTIFLT | view | |
| EndUserText.label | Quality Notification Longtext | view | |
| Metadata.ignorePropagatedAnnotations | true | view |
Fields (12)
| Key | Field | Source Table | Source Field | Description |
|---|---|---|---|---|
| KEY | QualityNotification | qmnum | ||
| KEY | ItemCounter | counter | ||
| KEY | Language | langu | ||
| LongTextID | textid | |||
| QltyNotificationLongText | content | |||
| LongTextCreatedByUser | created_by | |||
| LongTextCreatedAt | created_at | |||
| LongTextLastChangedByUser | changed_by | |||
| LongTextLastChangedAt | changed_at | |||
| MimeType | mimetype | |||
| _QltyNotification | _QltyNotification | |||
| _Language | _Language |
@AccessControl.authorizationCheck: #CHECK
@VDM.viewType: #BASIC
@ObjectModel:
{ usageType: {
dataClass: #TRANSACTIONAL,
sizeCategory: #L,
serviceQuality: #C
},
representativeKey: 'ItemCounter',
supportedCapabilities: [ #SQL_DATA_SOURCE, #CDS_MODELING_DATA_SOURCE ],
dataCategory: #TEXT
}
@Analytics.technicalName: 'IQNOTIFLT'
@EndUserText.label: 'Quality Notification Longtext'
@Metadata.ignorePropagatedAnnotations:true
define view entity I_QltyNotificationLongText
as select from qmelltext
association [1..1] to I_QltyNotification as _QltyNotification on $projection.QualityNotification = _QltyNotification.QualityNotification
association [1..1] to I_Language as _Language on $projection.Language = _Language.Language
{
@ObjectModel.foreignKey.association: '_QltyNotification'
key qmnum as QualityNotification,
key counter as ItemCounter,
@ObjectModel.foreignKey.association: '_Language'
@Semantics.language: true
key langu as Language,
textid as LongTextID,
@EndUserText:{ label: 'Detailed Description',
quickInfo: 'Detailed Description of Quality Notification'
}/* normally you should build a vdm_q* data element and cast the field to it to get the label, but casting of STRING is not allowed */
@Semantics.text: true
content as QltyNotificationLongText,
created_by as LongTextCreatedByUser,
created_at as LongTextCreatedAt,
changed_by as LongTextLastChangedByUser,
changed_at as LongTextLastChangedAt,
mimetype as MimeType,
// //field necessary for authorization check
// @Consumption.hidden: true
// _QltyNotification.NotificationType,
// @Consumption.hidden: true
// _QltyNotification.Plant,
// @Consumption.hidden: true
// _QltyNotification.IsBusinessPurposeCompleted,
_QltyNotification,
_Language
}
where textid = 'LTQM'
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