R_QltyNotificationTaskTP

DDL: R_QLTYNOTIFICATIONTASKTP Type: view_entity TRANSACTIONAL

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)

SourceAliasJoin Type
I_QltyNotificationTask I_QltyNotificationTask from

Associations (2)

CardinalityTargetAliasCondition
[1..1] E_NotificationTask _Extension $projection.QualityNotification = _Extension.Notification and $projection.NotificationTask = _Extension.NotificationTask
[0..*] R_QltyNotifTaskLongTextTP _QltyNotificationTaskLongText

Annotations (10)

NameValueLevelField
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)

KeyFieldSource TableSource FieldDescription
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
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_QLTYNOTIFICATIONTASK"
],
"ASSOCIATED":
[
"I_CONTACTPERSON",
"I_CUSTOMER",
"I_PARTNERFUNCTION",
"I_SUPPLIER",
"I_WORKFORCEPERSON",
"R_QLTYNOTIFICATIONTP",
"R_QLTYNOTIFTASKLONGTEXTTP"
],
"BASE":
[
"I_QLTYNOTIFICATIONTASK"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/