R_MaintNotificationTaskTP

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_MaintNotificationTaskTP.
-- 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: RNOTIFTASK

CREATE VIEW R_MaintNotificationTaskTP AS
SELECT
  MaintenanceNotification,
  MaintenanceNotificationTask,
  MaintenanceNotificationItem,
  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 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,
  cast (dats_tims_to_tstmp( CreationDate, CreationTime, abap_system_timezone( $session.client,'NULL' ) , $session.client, 'NULL') as tzntstmps preserving type ) AS MaintNotifTaskCreationDateTime,
  cast (dats_tims_to_tstmp( LastChangeDate, LastChangeTime, abap_system_timezone( $session.client,'NULL' ) , $session.client, 'NULL') as tzntstmps preserving type ) AS MaintNotifTaskChangedDateTime
FROM I_MaintenanceNotificationTask
;