R_MaintNotificationItemTaskTP

DDL: R_MAINTNOTIFICATIONITEMTASKTP SQL: RNOTIFITEMTASK Type: view_entity TRANSACTIONAL
44 Fields 1 Data Sources 1 Associations

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.

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 Notification
KEY MaintenanceNotificationItem MaintenanceNotificationItem Number of days
KEY MaintenanceNotificationTask MaintenanceNotificationTask Task
MaintNotifTaskTxt MaintNotifTaskTxt Task Text
MaintNotifTaskCodeCatalog MaintNotifTaskCodeCatalog Catalog type
MaintNotifTaskCodeGroup MaintNotifTaskCodeGroup Code Group
MaintNotifTaskCode MaintNotifTaskCode Task Code
PlannedStartDate PlannedStartDate Latest Planned Start
PlannedStartTime PlannedStartTime
PlannedEndDate PlannedEndDate Ltst Planned Finish
PlannedEndTime PlannedEndTime
CompletedByUser CompletedByUser Completed By
CompletionDate CompletionDate Completion Date
CompletionTime CompletionTime Completion Time
ResponsiblePersonFunctionCode Task Processor
MaintNotifPersonResponsible ResponsiblePerson Processor
IsDeleted IsDeleted TRUE
LastChangeDateTime LastChangeDateTime Timestamp
CreatedByUser CreatedByUser User Name
CreationDate CreationDate Time Stamp
LastChangedByUser LastChangedByUser User Name
LastChangeDate LastChangeDate Time Stamp
CreationTime CreationTime Time of Change
LastChangeTime LastChangeTime Time changed
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

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view R_MaintNotificationItemTaskTP.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.
-- SQL view name: RNOTIFITEMTASK

CREATE VIEW R_MaintNotificationItemTaskTP AS
SELECT
  MaintenanceNotification,
  MaintenanceNotificationItem,
  MaintenanceNotificationTask,
  MaintNotifTaskTxt,
  MaintNotifTaskCodeCatalog,
  MaintNotifTaskCodeGroup,
  MaintNotifTaskCode,
  PlannedStartDate,
  PlannedStartTime,
  PlannedEndDate,
  PlannedEndTime,
  CompletedByUser,
  CompletionDate,
  CompletionTime,
  cast( ResponsiblePersonFunctionCode as parvw_unv preserving type ) AS ResponsiblePersonFunctionCode,
  ResponsiblePerson AS MaintNotifPersonResponsible,
  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
FROM I_MaintenanceNotificationTask
LEFT OUTER JOIN R_MaintenanceNotificationTP AS _Notif ON MaintenanceNotification = _Notif.MaintenanceNotification  -- association [1..1]
;

Learn More