I_NOTIFICATIONITEMLONGTEXT
Notification Item Long Text
I_NOTIFICATIONITEMLONGTEXT is a CDS View in S/4HANA. Notification Item Long Text. It contains 13 fields. 2 CDS views read from this table.
CDS Views using this table (2)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| I_DefectLongText | view_entity | from | COMPOSITE | Defect Long Text |
| I_QltyNotifItemLongText | view_entity | from | COMPOSITE | Quality Notification Item Long Text |
Fields (13)
| Key | Field | CDS Fields | Used in Views |
|---|---|---|---|
| KEY | Language | Language | 1 |
| KEY | LongTextInternalNumber | LongTextInternalNumber | 1 |
| KEY | Notification | QualityNotification | 1 |
| KEY | NotificationItem | NotificationItem | 1 |
| _Language | _Language | 1 | |
| _Notification | _Notification | 1 | |
| _NotificationItem | _NotificationItem | 1 | |
| LongTextCreatedAt | LongTextCreatedAt | 1 | |
| LongTextCreatedByUser | LongTextCreatedByUser | 1 | |
| LongTextID | LongTextID | 1 | |
| LongTextLastChangedAt | LongTextLastChangedAt | 1 | |
| LongTextLastChangedByUser | LongTextLastChangedByUser | 1 | |
| NotificationItemLongText | NotificationItemLongText | 1 |
@VDM.viewType: #BASIC
@AccessControl.authorizationCheck: #PRIVILEGED_ONLY
@ObjectModel: {
dataCategory: #TEXT,
usageType: {
dataClass: #TRANSACTIONAL,
sizeCategory: #L,
serviceQuality: #A
},
representativeKey: 'LongTextInternalNumber'
}
@Analytics.technicalName: 'INOTIFITMLT'
@EndUserText.label: 'Notification Item Long Text'
@Metadata.ignorePropagatedAnnotations: true
define view entity I_NotificationItemLongText as select from qdefltext
association [1..1] to I_Notification as _Notification on $projection.Notification = _Notification.Notification
association [1..1] to I_NotificationItem as _NotificationItem on $projection.Notification = _NotificationItem.Notification
and $projection.NotificationItem = _NotificationItem.NotificationItem
association [1..1] to I_Language as _Language on $projection.Language = _Language.Language
{
@ObjectModel.foreignKey.association: '_Notification'
key qmnum as Notification,
@ObjectModel.foreignKey.association: '_NotificationItem'
key fenum as NotificationItem,
@ObjectModel.foreignKey.association: '_Language'
@Semantics.language: true
key langu as Language,
key counter as LongTextInternalNumber,
textid as LongTextID,
@Semantics.text
content as NotificationItemLongText,
created_by as LongTextCreatedByUser,
cast( created_at as qlt_longtext_created_at preserving type ) as LongTextCreatedAt,
changed_by as LongTextLastChangedByUser,
cast( changed_at as qlt_longtext_changed_at preserving type ) as LongTextLastChangedAt,
cast( mimetype as w3conttype ) as MimeType,
/* Association */
_Notification,
_NotificationItem,
_Language
}