R_MaintNotificationItemTaskTP

DDL: R_MAINTNOTIFICATIONITEMTASKTP SQL: RNOTIFITEMTASK Type: view_entity TRANSACTIONAL Package: RAP_EAM_NTF

Maintenance Notification Item Task

R_MaintNotificationItemTaskTP is a Transactional CDS View that provides data about "Maintenance Notification Item Task" in SAP S/4HANA. It reads from 1 data source (I_MaintenanceNotificationTask) and exposes 44 fields with key fields MaintenanceNotification, MaintenanceNotificationItem, MaintenanceNotificationTask. It has 1 association to related views. Part of development package RAP_EAM_NTF.

1 data source(s) 44 fields

Data Sources (1)

SourceAliasJoin Type
I_MaintenanceNotificationTask I_MaintenanceNotificationTask from

Associations (1)

CardinalityTargetAliasCondition
[1..1] R_MaintenanceNotificationTP _Notif $projection.MaintenanceNotification = _Notif.MaintenanceNotification

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
EndUserText.label Maintenance Notification Item Task view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
Metadata.ignorePropagatedAnnotations true view
VDM.viewType #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MASTER view

Fields (44)

KeyFieldSource TableSource FieldDescription
KEY MaintenanceNotification MaintenanceNotification
KEY MaintenanceNotificationItem MaintenanceNotificationItem
KEY MaintenanceNotificationTask MaintenanceNotificationTask
MaintNotifTaskTxt MaintNotifTaskTxt
MaintNotifTaskCodeCatalog MaintNotifTaskCodeCatalog
MaintNotifTaskCodeGroup MaintNotifTaskCodeGroup
MaintNotifTaskCode MaintNotifTaskCode
PlannedStartDate PlannedStartDate
PlannedStartTime PlannedStartTime
PlannedEndDate PlannedEndDate
PlannedEndTime PlannedEndTime
CompletedByUser CompletedByUser
CompletionDate CompletionDate
CompletionTime CompletionTime
ResponsiblePersonFunctionCode
MaintNotifPersonResponsible ResponsiblePerson
IsDeleted IsDeleted
LastChangeDateTime LastChangeDateTime
CreatedByUser CreatedByUser
CreationDate CreationDate
LastChangedByUser LastChangedByUser
LastChangeDate LastChangeDate
CreationTime CreationTime
LastChangeTime LastChangeTime
MaintNotifItmTskPlndStrtDteTme
MaintNotifItmTskPlndEndDteTime
MaintNotifItemTaskCrtnDateTime
MaintNotifItemTaskChgdDateTime
MaintNotifItmTskCompltnDteTime
_Item _Item
_Notif _Notif
_MaintenanceNotification _MaintenanceNotification
_MaintenanceNotificationItem _MaintenanceNotificationItem
_MaintNotificationTaskCode _MaintNotificationTaskCode
_MaintNotifTaskCodeGroup _MaintNotifTaskCodeGroup
_IsDeleted _IsDeleted
_PartnerFunction _PartnerFunction
_ContactPerson _ContactPerson
_Customer _Customer
_Employee _Employee
_OrganizationalUnitText _OrganizationalUnitText
_PositionText _PositionText
_Supplier _Supplier
_User _User 
//@AbapCatalog.sqlViewName: 'RNOTIFITEMTASK'

//@AbapCatalog.compiler.compareFilter: true

//@AbapCatalog.preserveKey: true

@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Maintenance Notification Item Task'

@VDM.lifecycle.contract.type: #SAP_INTERNAL_API
@Metadata.ignorePropagatedAnnotations: true
//@ClientHandling.algorithm: #SESSION_VARIABLE

@VDM.viewType: #TRANSACTIONAL

@ObjectModel.usageType: {serviceQuality: #C, sizeCategory: #L, dataClass: #MASTER}

define view entity R_MaintNotificationItemTaskTP
  as select from I_MaintenanceNotificationTask

  // Root

  association [1..1] to R_MaintenanceNotificationTP      as _Notif on  $projection.MaintenanceNotification = _Notif.MaintenanceNotification


  //Parent

  association        to parent R_MaintNotificationItemTP as _Item  on  _Item.MaintenanceNotification     = $projection.MaintenanceNotification
                                                                   and _Item.MaintenanceNotificationItem = $projection.MaintenanceNotificationItem
{

  key MaintenanceNotification,

      //this field will differentiate between header task and item task

  key MaintenanceNotificationItem,

  key MaintenanceNotificationTask,

      MaintNotifTaskTxt,

      MaintNotifTaskCodeCatalog,

      MaintNotifTaskCodeGroup,

      MaintNotifTaskCode,

      PlannedStartDate,

      PlannedStartTime,

      PlannedEndDate,

      PlannedEndTime,

      CompletedByUser,

      CompletionDate,

      CompletionTime,

      cast( ResponsiblePersonFunctionCode as parvw_unv preserving type )                                                                                                                                   as ResponsiblePersonFunctionCode,

      ResponsiblePerson                                                                                                                                                                                    as MaintNotifPersonResponsible,

      //      MaintNotifTaskInternalID,


      @Semantics.booleanIndicator: true
      IsDeleted,

      LastChangeDateTime,

      CreatedByUser,

      CreationDate,

      LastChangedByUser,

      LastChangeDate,

      CreationTime,

      LastChangeTime,

      cast (dats_tims_to_tstmp( PlannedStartDate, PlannedStartTime, I_MaintenanceNotificationTask._MaintenanceNotification.NotificationTimeZone , $session.client, 'NULL') as  tzntstmps preserving type ) as MaintNotifItmTskPlndStrtDteTme,
      cast (dats_tims_to_tstmp( PlannedEndDate, PlannedEndTime, I_MaintenanceNotificationTask._MaintenanceNotification.NotificationTimeZone , $session.client, 'NULL') as  tzntstmps preserving type )     as MaintNotifItmTskPlndEndDteTime,
      cast (dats_tims_to_tstmp( CreationDate, CreationTime, abap_system_timezone( $session.client,'NULL' ) , $session.client, 'NULL') as  tzntstmps preserving type )         as MaintNotifItemTaskCrtnDateTime,
      cast (dats_tims_to_tstmp( LastChangeDate, LastChangeTime, abap_system_timezone( $session.client,'NULL' ) , $session.client, 'NULL') as  tzntstmps preserving type )     as MaintNotifItemTaskChgdDateTime,
      cast (dats_tims_to_tstmp( CompletionDate, CompletionTime, I_MaintenanceNotificationTask._MaintenanceNotification.NotificationTimeZone , $session.client, 'NULL') as  tzntstmps preserving type )     as MaintNotifItmTskCompltnDteTime,

      // Parent View

      _Item,
      // Root View

      _Notif,

      /* Associations */
      _MaintenanceNotification,
      _MaintenanceNotificationItem,
      _MaintNotificationTaskCode,
      //      _MaintNotifTaskCodeCatalog,

      _MaintNotifTaskCodeGroup,
      //      _StatusObject,

      _IsDeleted,
      _PartnerFunction,
      //      _StatusObjectStatus,


      /* Associations - DPP */
      _ContactPerson,
      _Customer,
      _Employee,
      _OrganizationalUnitText,
      _PositionText,
      _Supplier,
      _User

}
where
  MaintenanceNotificationItem is not initial

Learn More