R_QualityNotificationItemTP
Quality Notification Item
R_QualityNotificationItemTP is a Transactional CDS View that provides data about "Quality Notification Item" in SAP S/4HANA. It reads from 1 data source (I_QualityNotificationItem) and exposes 39 fields with key fields QualityNotification, NotificationItem. It has 3 associations to related views.
Data Sources (1)
| Source | Alias | Join Type |
|---|---|---|
| I_QualityNotificationItem | I_QualityNotificationItem | from |
Associations (3)
| Cardinality | Target | Alias | Condition |
|---|---|---|---|
| [1..1] | E_NotificationItem | _Extension | $projection.QualityNotification = _Extension.Notification and $projection.NotificationItem = _Extension.NotificationItem |
| [0..*] | R_QltyNotifItemLongTextTP | _QltyNotifItemLongText | |
| [0..*] | R_QltyNotificationItemCauseTP | _QltyNotificationItemCause | |
Annotations (9)
| Name | Value | Level | Field |
|---|---|---|---|
| AccessControl.authorizationCheck | #MANDATORY | view | |
| EndUserText.label | Quality Notification Item | view | |
| VDM.viewType | #TRANSACTIONAL | view | |
| VDM.lifecycle.contract.type | #SAP_INTERNAL_API | view | |
| ObjectModel.usageType.serviceQuality | #C | view | |
| ObjectModel.usageType.sizeCategory | #L | view | |
| ObjectModel.usageType.dataClass | #TRANSACTIONAL | view | |
| ObjectModel.representativeKey | NotificationItem | view | |
| Metadata.ignorePropagatedAnnotations | true | view |
Fields (39)
| Key | Field | Source Table | Source Field | Description |
|---|---|---|---|---|
| KEY | QualityNotification | I_QualityNotificationItem | QualityNotification | |
| KEY | NotificationItem | I_QualityNotificationItem | NotificationItem | |
| NotificationItemExternalID | I_QualityNotificationItem | NotificationItemExternalID | ||
| NotificationItemText | I_QualityNotificationItem | NotificationItemText | ||
| MasterLanguage | ||||
| Assembly | I_QualityNotificationItem | Assembly | ||
| DefectClass | I_QualityNotificationItem | DefectClass | ||
| NumberOfDefects | I_QualityNotificationItem | NumberOfDefects | ||
| InspPlanOperationInternalID | I_QualityNotificationItem | InspPlanOperationInternalID | ||
| InspectionCharacteristic | I_QualityNotificationItem | InspectionCharacteristic | ||
| InspectionSubsetInternalID | I_QualityNotificationItem | InspectionSubsetInternalID | ||
| MaterialSample | I_QualityNotificationItem | MaterialSample | ||
| DefectiveSingleUnit | I_QualityNotificationItem | DefectiveSingleUnit | ||
| WorkCenterTypeCode | I_QualityNotificationItem | WorkCenterTypeCode | ||
| MainWorkCenterInternalID | I_QualityNotificationItem | MainWorkCenterInternalID | ||
| MainWorkCenter | I_QualityNotificationItem | MainWorkCenter | ||
| MainWorkCenterPlant | I_QualityNotificationItem | MainWorkCenterPlant | ||
| DefectOrigin | I_QualityNotificationItem | DefectOrigin | ||
| ReferencedDefect | I_QualityNotificationItem | ReferencedDefect | ||
| IsDeleted | I_QualityNotificationItem | IsDeleted | ||
| DefectCodeCatalog | I_QualityNotificationItem | DefectCodeCatalog | ||
| DefectCodeGroup | I_QualityNotificationItem | DefectCodeGroup | ||
| DefectCode | I_QualityNotificationItem | DefectCode | ||
| NotifItmObjectPartCodeCtlg | I_QualityNotificationItem | NotifItmObjectPartCodeCtlg | ||
| NotifItmObjectPartCodeGroup | I_QualityNotificationItem | NotifItmObjectPartCodeGroup | ||
| NotifItmObjectPartCode | I_QualityNotificationItem | NotifItmObjectPartCode | ||
| ExternalDefectiveQuantity | I_QualityNotificationItem | ExternalDefectiveQuantity | ||
| InternalDefectiveQuantity | I_QualityNotificationItem | InternalDefectiveQuantity | ||
| DefectiveQuantityUnit | I_QualityNotificationItem | DefectiveQuantityUnit | ||
| CreatedByUser | I_QualityNotificationItem | CreatedByUser | ||
| CreationDate | I_QualityNotificationItem | CreationDate | ||
| CreationTime | I_QualityNotificationItem | CreationTime | ||
| LastChangedByUser | I_QualityNotificationItem | LastChangedByUser | ||
| LastChangeDate | I_QualityNotificationItem | LastChangeDate | ||
| LastChangeTime | I_QualityNotificationItem | LastChangeTime | ||
| _QltyNotification | _QltyNotification | |||
| _QltyNotifItemLongText | _QltyNotifItemLongText | |||
| _QltyNotificationItemCause | _QltyNotificationItemCause | |||
| _Notification | I_QualityNotificationItem | _Notification |
@AbapCatalog.viewEnhancementCategory: [#PROJECTION_LIST]
@AccessControl.authorizationCheck: #MANDATORY
@EndUserText.label: 'Quality Notification Item'
@VDM: {
viewType: #TRANSACTIONAL,
lifecycle.contract.type: #SAP_INTERNAL_API
}
@ObjectModel: {
usageType: {
serviceQuality: #C,
sizeCategory: #L,
dataClass: #TRANSACTIONAL
},
representativeKey: 'NotificationItem'
}
@Metadata.ignorePropagatedAnnotations: true
define view entity R_QualityNotificationItemTP
as select from I_QualityNotificationItem
association to parent R_QltyNotificationTP as _QltyNotification on $projection.QualityNotification = _QltyNotification.QualityNotification
// Compositions to child nodes
composition [0..*] of R_QltyNotifItemLongTextTP as _QltyNotifItemLongText
composition [0..*] of R_QltyNotificationItemCauseTP as _QltyNotificationItemCause
// Extension
association [1..1] to E_NotificationItem as _Extension on $projection.QualityNotification = _Extension.Notification
and $projection.NotificationItem = _Extension.NotificationItem
{
@ObjectModel.foreignKey.association: '_QltyNotification'
key I_QualityNotificationItem.QualityNotification,
key I_QualityNotificationItem.NotificationItem,
I_QualityNotificationItem.NotificationItemExternalID,
@Semantics.text: true
I_QualityNotificationItem.NotificationItemText,
cast( I_QualityNotificationItem.MasterLanguage as vdm_j_masterlanguage ) as MasterLanguage,
// I_QualityNotificationItem.MasterLanguage,
I_QualityNotificationItem.Assembly,
I_QualityNotificationItem.DefectClass,
I_QualityNotificationItem.NumberOfDefects,
I_QualityNotificationItem.InspPlanOperationInternalID,
I_QualityNotificationItem.InspectionCharacteristic,
I_QualityNotificationItem.InspectionSubsetInternalID,
I_QualityNotificationItem.MaterialSample,
I_QualityNotificationItem.DefectiveSingleUnit,
I_QualityNotificationItem.WorkCenterTypeCode,
I_QualityNotificationItem.MainWorkCenterInternalID,
I_QualityNotificationItem.MainWorkCenter,
I_QualityNotificationItem.MainWorkCenterPlant,
I_QualityNotificationItem.DefectOrigin,
I_QualityNotificationItem.ReferencedDefect,
@Semantics.booleanIndicator: true
I_QualityNotificationItem.IsDeleted,
// Codes
I_QualityNotificationItem.DefectCodeCatalog,
I_QualityNotificationItem.DefectCodeGroup,
I_QualityNotificationItem.DefectCode,
I_QualityNotificationItem.NotifItmObjectPartCodeCtlg,
I_QualityNotificationItem.NotifItmObjectPartCodeGroup,
I_QualityNotificationItem.NotifItmObjectPartCode,
// Quantities
@Semantics.quantity.unitOfMeasure: 'DefectiveQuantityUnit'
I_QualityNotificationItem.ExternalDefectiveQuantity,
@Semantics.quantity.unitOfMeasure: 'DefectiveQuantityUnit'
I_QualityNotificationItem.InternalDefectiveQuantity,
// @Semantics.quantity.unitOfMeasure: 'DefectiveQuantityUnit'
// I_QualityNotificationItem.DefectiveQuantity, // Only used by Defect application
I_QualityNotificationItem.DefectiveQuantityUnit, // semantics annotation for UoM not allowed in view entities
// Admin Data
@Semantics.user.createdBy: true
I_QualityNotificationItem.CreatedByUser,
@Semantics.systemDate.createdAt: true
I_QualityNotificationItem.CreationDate,
@Semantics.time: true
I_QualityNotificationItem.CreationTime,
@Semantics.user.lastChangedBy: true
I_QualityNotificationItem.LastChangedByUser,
@Semantics.systemDate.lastChangedAt: true
I_QualityNotificationItem.LastChangeDate,
@Semantics.time: true
I_QualityNotificationItem.LastChangeTime,
// I_QualityNotificationItem.ChangedDateTime, // Only used by Defect application
// Associations
_QltyNotification,
_QltyNotifItemLongText,
_QltyNotificationItemCause,
// For auth check mapping role
I_QualityNotificationItem._Notification
}
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