R_MaintNotificationTaskTP

DDL: R_MAINTNOTIFICATIONTASKTP SQL: RNOTIFTASK Type: view_entity TRANSACTIONAL

Maintenance Notification Task

R_MaintNotificationTaskTP is a Transactional CDS View that provides data about "Maintenance Notification Task" in SAP S/4HANA. It reads from 1 data source (I_MaintenanceNotificationTask) and exposes 43 fields with key fields MaintenanceNotification, MaintenanceNotificationTask.

1 data source(s) 43 fields

Data Sources (1)

SourceAliasJoin Type
I_MaintenanceNotificationTask I_MaintenanceNotificationTask from

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
EndUserText.label Maintenance Notification 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 (43)

KeyFieldSource TableSource FieldDescription
KEY MaintenanceNotification MaintenanceNotification
KEY MaintenanceNotificationTask MaintenanceNotificationTask
MaintenanceNotificationItem MaintenanceNotificationItem
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
MaintNotifTaskPlndStrtDateTime
MaintNotifTaskPlndEndDateTime
MaintNotifTaskCompltnDateTime
MaintNotifTaskCreationDateTime
MaintNotifTaskChangedDateTime
_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: 'RNOTIFTASK'

//@AbapCatalog.compiler.compareFilter: true

//@AbapCatalog.preserveKey: true

@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Maintenance Notification 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_MaintNotificationTaskTP
  as select from I_MaintenanceNotificationTask

  //Parent

  association to parent R_MaintenanceNotificationTP as _Notif on _Notif.MaintenanceNotification = $projection.MaintenanceNotification
{

  key MaintenanceNotification,

  key MaintenanceNotificationTask,

      //this field will differentiate between header task and item task. For header, this value should be blank.

      MaintenanceNotificationItem,

      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 MaintNotifTaskPlndStrtDateTime,
      cast (dats_tims_to_tstmp( PlannedEndDate, PlannedEndTime, I_MaintenanceNotificationTask._MaintenanceNotification.NotificationTimeZone , $session.client, 'NULL') as  tzntstmps preserving type )     as MaintNotifTaskPlndEndDateTime,
      cast (dats_tims_to_tstmp( CompletionDate, CompletionTime, I_MaintenanceNotificationTask._MaintenanceNotification.NotificationTimeZone , $session.client, 'NULL') as  tzntstmps preserving type )     as MaintNotifTaskCompltnDateTime,  //N3311795

      cast (dats_tims_to_tstmp( CreationDate, CreationTime, abap_system_timezone( $session.client,'NULL' ) , $session.client, 'NULL') as  tzntstmps preserving type )         as MaintNotifTaskCreationDateTime, //N3311795

      cast (dats_tims_to_tstmp( LastChangeDate, LastChangeTime, abap_system_timezone( $session.client,'NULL' ) , $session.client, 'NULL') as  tzntstmps preserving type )     as MaintNotifTaskChangedDateTime,  //N3311795


      // Parent View

      _Notif,

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

      _MaintNotifTaskCodeGroup,
      //      _StatusObject,

      _IsDeleted,
      _PartnerFunction,
      //      _StatusObjectStatus,


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

}
where
  MaintenanceNotificationItem is initial
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_MAINTENANCENOTIFICATION",
"I_MAINTENANCENOTIFICATIONTASK"
],
"ASSOCIATED":
[
"I_CONTACTPERSON",
"I_CUSTOMER",
"I_INDICATOR",
"I_INSPECTIONCODE",
"I_INSPECTIONCODEGROUP",
"I_MAINTENANCENOTIFICATION",
"I_MAINTENANCENOTIFICATIONITEM",
"I_ORGANIZATIONALUNITTEXT",
"I_PARTNERFUNCTION",
"I_PMPOSITIONTEXT",
"I_SUPPLIER",
"I_USER",
"I_WORKFORCEPERSON",
"R_MAINTENANCENOTIFICATIONTP"
],
"BASE":
[
"I_MAINTENANCENOTIFICATIONTASK"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More