I_MaintNotifTaskTechObj

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 I_MaintNotifTaskTechObj.
-- 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: INTFTASKTECHOBJ

CREATE VIEW I_MaintNotifTaskTechObj AS
SELECT
  I_MaintenanceNotificationTask.MaintenanceNotificationTask AS MaintenanceNotificationTask,
  I_MaintenanceNotificationTask.MaintenanceNotification AS MaintenanceNotification,
  I_MaintenanceNotificationTask.MaintenanceNotificationItem AS MaintenanceNotificationItem,
  I_MaintenanceNotificationTask.MaintenanceNotificationCause AS MaintenanceNotificationCause,
  I_MaintenanceNotificationTask.MaintNotifTaskTxt AS MaintNotifTaskTxt,
  I_MaintenanceNotificationTask.MaintNotifTaskCodeCatalog AS MaintNotifTaskCodeCatalog,
  I_MaintenanceNotificationTask.MaintNotifTaskCodeGroup AS MaintNotifTaskCodeGroup,
  I_MaintenanceNotificationTask.MaintNotifTaskCode AS MaintNotifTaskCode,
  I_MaintenanceNotificationTask.PlannedStartDate AS PlannedStartDate,
  I_MaintenanceNotificationTask.PlannedStartTime AS PlannedStartTime,
  I_MaintenanceNotificationTask.PlannedEndDate AS PlannedEndDate,
  I_MaintenanceNotificationTask.PlannedEndTime AS PlannedEndTime,
  I_MaintenanceNotificationTask.CompletedByUser AS CompletedByUser,
  I_MaintenanceNotificationTask.CompletionDate AS CompletionDate,
  I_MaintenanceNotificationTask.CompletionTime AS CompletionTime,
  I_MaintenanceNotificationTask.ResponsiblePersonFunctionCode AS ResponsiblePersonFunctionCode,
  I_MaintenanceNotificationTask.ResponsiblePerson AS ResponsiblePerson,
  I_MaintenanceNotificationTask.MaintNotifTaskInternalID AS MaintNotifTaskInternalID,
  I_MaintenanceNotificationTask.IsDeleted AS IsDeleted,
  I_MaintenanceNotificationTask.LastChangeDateTime AS LastChangeDateTime,
  I_MaintenanceNotificationTask._IsDeleted AS _IsDeleted,
  I_MaintenanceNotificationTask._MaintenanceNotification AS _MaintenanceNotification,
  I_MaintenanceNotificationTask._MaintenanceNotificationItem AS _MaintenanceNotificationItem,
  I_MaintenanceNotificationTask._MaintNotificationTaskCode AS _MaintNotificationTaskCode,
  I_MaintenanceNotificationTask._MaintNotifTaskCodeCatalog AS _MaintNotifTaskCodeCatalog,
  I_MaintenanceNotificationTask._MaintNotifTaskCodeGroup AS _MaintNotifTaskCodeGroup,
  I_MaintenanceNotificationTask._StatusObject AS _StatusObject,
  I_MaintenanceNotificationTask._PartnerFunction AS _PartnerFunction,
  I_MaintenanceNotificationTask._StatusObjectStatus AS _StatusObjectStatus,
  I_MaintenanceNotificationTask._ContactPerson AS _ContactPerson,
  I_MaintenanceNotificationTask._Customer AS _Customer,
  I_MaintenanceNotificationTask._Employee AS _Employee,
  I_MaintenanceNotificationTask._OrganizationalUnitText AS _OrganizationalUnitText,
  I_MaintenanceNotificationTask._PositionText AS _PositionText,
  I_MaintenanceNotificationTask._Supplier AS _Supplier,
  I_MaintenanceNotificationTask._User AS _User
FROM I_MaintenanceNotificationTask
LEFT OUTER JOIN I_MaintNotificationTechObj AS _MaintNotificationTechObj ON MaintenanceNotification = _MaintNotificationTechObj.MaintenanceNotification  -- association [1..1]
;