R_QltyNotificationTaskTP
Quality Notification Task - TP
R_QltyNotificationTaskTP is a Transactional CDS View that provides data about "Quality Notification Task - TP" in SAP S/4HANA. It reads from 1 data source (I_QltyNotificationTask) and exposes 41 fields with key fields QualityNotification, NotificationTask. It has 2 associations to related views.
Data Sources (1)
| Source | Alias | Join Type |
|---|---|---|
| I_QltyNotificationTask | I_QltyNotificationTask | from |
Associations (2)
| Cardinality | Target | Alias | Condition |
|---|---|---|---|
| [1..1] | E_NotificationTask | _Extension | $projection.QualityNotification = _Extension.Notification and $projection.NotificationTask = _Extension.NotificationTask |
| [0..*] | R_QltyNotifTaskLongTextTP | _QltyNotificationTaskLongText | |
Annotations (10)
| Name | Value | Level | Field |
|---|---|---|---|
| AccessControl.authorizationCheck | #MANDATORY | view | |
| AccessControl.personalData.blocking | #REQUIRED | view | |
| EndUserText.label | Quality Notification Task - TP | view | |
| VDM.viewType | #TRANSACTIONAL | view | |
| VDM.lifecycle.contract.type | #SAP_INTERNAL_API | view | |
| ObjectModel.usageType.dataClass | #TRANSACTIONAL | view | |
| ObjectModel.usageType.sizeCategory | #L | view | |
| ObjectModel.usageType.serviceQuality | #A | view | |
| ObjectModel.representativeKey | NotificationTask | view | |
| Metadata.ignorePropagatedAnnotations | true | view |
Fields (41)
| Key | Field | Source Table | Source Field | Description |
|---|---|---|---|---|
| KEY | QualityNotification | I_QltyNotificationTask | QualityNotification | |
| KEY | NotificationTask | I_QltyNotificationTask | NotificationTask | |
| NotificationTaskText | I_QltyNotificationTask | NotificationTaskText | ||
| IsDeleted | I_QltyNotificationTask | IsDeleted | ||
| NotifTaskPlannedStartDate | I_QltyNotificationTask | NotifTaskPlannedStartDate | ||
| NotifTaskPlannedStartTime | I_QltyNotificationTask | NotifTaskPlannedStartTime | ||
| NotifTaskPlannedEndDate | I_QltyNotificationTask | NotifTaskPlannedEndDate | ||
| NotifTaskPlannedEndTime | I_QltyNotificationTask | NotifTaskPlannedEndTime | ||
| StatusObject | I_QltyNotificationTask | StatusObject | ||
| NotifTaskTimeZone | I_QltyNotificationTask | NotifTaskTimeZone | ||
| NotifTaskCompletedByUser | I_QltyNotificationTask | NotifTaskCompletedByUser | ||
| NotifTaskCompletionDate | I_QltyNotificationTask | NotifTaskCompletionDate | ||
| NotifTaskCompletionTime | I_QltyNotificationTask | NotifTaskCompletionTime | ||
| NotifTaskResubmissionDate | I_QltyNotificationTask | NotifTaskResubmissionDate | ||
| NotifTaskResubmissionTime | I_QltyNotificationTask | NotifTaskResubmissionTime | ||
| ResponsiblePersonFunctionCode | ||||
| PersonResponsible | I_QltyNotificationTask | ResponsiblePerson | ||
| NotificationTaskSortNumber | I_QltyNotificationTask | NotificationTaskSortNumber | ||
| NotificationItem | I_QltyNotificationTask | NotificationItem | ||
| NotificationCauseID | I_QltyNotificationTask | NotificationCauseID | ||
| QualityTaskCodeCatalog | I_QltyNotificationTask | QualityTaskCodeCatalog | ||
| QualityTaskCodeGroup | I_QltyNotificationTask | QualityTaskCodeGroup | ||
| QualityTaskCode | I_QltyNotificationTask | QualityTaskCode | ||
| QltyTaskTimeBasedEffort | I_QltyNotificationTask | QltyTaskTimeBasedEffort | ||
| QltyTaskTimeBasedEffortUoM | I_QltyNotificationTask | QltyTaskTimeBasedEffortUoM | ||
| CreatedByUser | I_QltyNotificationTask | CreatedByUser | ||
| CreationDate | I_QltyNotificationTask | CreationDate | ||
| CreationTime | I_QltyNotificationTask | CreationTime | ||
| LastChangedByUser | I_QltyNotificationTask | LastChangedByUser | ||
| LastChangeDate | I_QltyNotificationTask | LastChangeDate | ||
| LastChangeTime | I_QltyNotificationTask | LastChangeTime | ||
| NotificationType | I_QltyNotificationTask | NotificationType | ||
| Plant | I_QltyNotificationTask | Plant | ||
| IsBusinessPurposeCompleted | I_QltyNotificationTask | IsBusinessPurposeCompleted | ||
| _QltyNotification | _QltyNotification | |||
| _QltyNotificationTaskLongText | _QltyNotificationTaskLongText | |||
| _PartnerFunction | I_QltyNotificationTask | _PartnerFunction | ||
| _ContactPerson | I_QltyNotificationTask | _ContactPerson | ||
| _Employee | I_QltyNotificationTask | _Employee | ||
| _Customer | I_QltyNotificationTask | _Customer | ||
| _Supplier | I_QltyNotificationTask | _Supplier |
@AbapCatalog.viewEnhancementCategory: [#PROJECTION_LIST]
@AccessControl.authorizationCheck: #MANDATORY
@AccessControl.personalData.blocking: #REQUIRED
//@AccessControl.privilegedAssociations: ['_CreatedByUserContactCard', '_LastChangedByUserContactCard', '_StsObjConcatActiveStsILL' ]
@EndUserText.label: 'Quality Notification Task - TP'
@VDM: {
viewType: #TRANSACTIONAL,
lifecycle.contract.type: #SAP_INTERNAL_API
}
@ObjectModel: {
usageType: {
dataClass: #TRANSACTIONAL,
sizeCategory: #L,
serviceQuality: #A
},
representativeKey: 'NotificationTask'
}
@Metadata.ignorePropagatedAnnotations: true
define view entity R_QltyNotificationTaskTP
as select from I_QltyNotificationTask
// left outer to one join I_QualityNotificationItem
// on I_QualityNotificationItem.QualityNotification = I_QltyNotificationTask.QualityNotification
// and I_QualityNotificationItem.NotificationItem = I_QltyNotificationTask.NotificationItem
// left outer to one join I_QltyNotificationCause
// on I_QltyNotificationCause.QualityNotification = I_QltyNotificationTask.QualityNotification
// and I_QltyNotificationCause.NotificationItem = I_QltyNotificationTask.NotificationItem
// and I_QltyNotificationCause.NotificationCauseID = I_QltyNotificationTask.NotificationCauseID
association to parent R_QltyNotificationTP as _QltyNotification on $projection.QualityNotification = _QltyNotification.QualityNotification
// Compositions to child nodes
composition [0..*] of R_QltyNotifTaskLongTextTP as _QltyNotificationTaskLongText
// === Extension
association [1..1] to E_NotificationTask as _Extension on $projection.QualityNotification = _Extension.Notification
and $projection.NotificationTask = _Extension.NotificationTask
{
@ObjectModel.foreignKey.association: '_QltyNotification'
key I_QltyNotificationTask.QualityNotification,
key I_QltyNotificationTask.NotificationTask,
// QualityTask,
// QualityTaskOrigin,
@Semantics.text: true
I_QltyNotificationTask.NotificationTaskText,
@Semantics.booleanIndicator: true
I_QltyNotificationTask.IsDeleted,
// NotifProcessingPhase, // header field!?
I_QltyNotificationTask.NotifTaskPlannedStartDate,
I_QltyNotificationTask.NotifTaskPlannedStartTime,
I_QltyNotificationTask.NotifTaskPlannedEndDate,
I_QltyNotificationTask.NotifTaskPlannedEndTime,
I_QltyNotificationTask.StatusObject,
I_QltyNotificationTask.NotifTaskTimeZone,
I_QltyNotificationTask.NotifTaskCompletedByUser,
I_QltyNotificationTask.NotifTaskCompletionDate,
I_QltyNotificationTask.NotifTaskCompletionTime,
I_QltyNotificationTask.NotifTaskResubmissionDate,
I_QltyNotificationTask.NotifTaskResubmissionTime,
//Restore data element VDM_Q_PARVW_VERA used in basic view
@ObjectModel.foreignKey.association: '_PartnerFunction'
cast( I_QltyNotificationTask.ResponsiblePersonFunctionCode as vdm_q_parvw_vera preserving type ) as ResponsiblePersonFunctionCode,
I_QltyNotificationTask.ResponsiblePerson as PersonResponsible,
I_QltyNotificationTask.NotificationTaskSortNumber,
I_QltyNotificationTask.NotificationItem,
// I_QualityNotificationItem.NotificationItemExternalID,
I_QltyNotificationTask.NotificationCauseID,
// I_QltyNotificationCause.NotificationCauseSortNumber,
//=== Task Code
I_QltyNotificationTask.QualityTaskCodeCatalog,
I_QltyNotificationTask.QualityTaskCodeGroup,
I_QltyNotificationTask.QualityTaskCode,
//====Time Recording for Task
@Semantics.quantity.unitOfMeasure: 'QltyTaskTimeBasedEffortUoM'
I_QltyNotificationTask.QltyTaskTimeBasedEffort,
I_QltyNotificationTask.QltyTaskTimeBasedEffortUoM,
//=== Administrative Data
// I_QltyNotificationTask.ChangedDateTime,
I_QltyNotificationTask.CreatedByUser,
I_QltyNotificationTask.CreationDate,
I_QltyNotificationTask.CreationTime,
I_QltyNotificationTask.LastChangedByUser,
I_QltyNotificationTask.LastChangeDate,
I_QltyNotificationTask.LastChangeTime,
//=== Fields of quality notification header used in DCL for authorization check
I_QltyNotificationTask.NotificationType,
I_QltyNotificationTask.Plant,
@Semantics.booleanIndicator: true
I_QltyNotificationTask.IsBusinessPurposeCompleted,
//=== Model Associations
_QltyNotification,
_QltyNotificationTaskLongText,
//=== Associations
// I_QltyNotificationTask._CreatedByUserContactCard,
// I_QltyNotificationTask._LastChangedByUserContactCard,
// I_QltyNotificationTask._QltyTskCode,
// I_QltyNotificationTask._QltyTskCodeGroup,
// I_QltyNotificationTask._QualityTaskOrigin,
// I_QltyNotificationTask._StsObjConcatActiveStsILL,
//Only included because of authorization check with DPP
I_QltyNotificationTask._PartnerFunction,
I_QltyNotificationTask._ContactPerson,
I_QltyNotificationTask._Employee,
I_QltyNotificationTask._Customer,
I_QltyNotificationTask._Supplier
}
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