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_MaintenanceJobTP.
-- 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: RMAINTJOBTP
CREATE VIEW R_MaintenanceJobTP AS
SELECT
MaintenanceOrder,
MaintOrderRoutingNumber,
MaintenanceOrderType,
MaintenanceOrderDesc,
MaintPriority,
MaintPriorityType,
cast(dats_tims_to_tstmp(MaintOrdBasicStartDate, MaintOrdBasicStartTime, abap_system_timezone( $session.client,'NULL' ), $session.client, 'NULL') as timestamp preserving type) AS MaintOrdBasicStartDateTime,
cast(dats_tims_to_tstmp(MaintOrdBasicEndDate, MaintOrdBasicEndTime, abap_system_timezone( $session.client,'NULL' ), $session.client, 'NULL') as timestamp preserving type) AS MaintOrdBasicEndDateTime,
tstmp_to_dats( dats_tims_to_tstmp(MaintOrdBasicStartDate, MaintOrdBasicStartTime, abap_system_timezone( $session.client,'NULL' ), $session.client, 'NULL'), 'UTC', $session.client, 'NULL' ) AS MaintOrdBasicStartDate,
tstmp_to_tims( dats_tims_to_tstmp(MaintOrdBasicStartDate, MaintOrdBasicStartTime, abap_system_timezone( $session.client,'NULL' ), $session.client, 'NULL'), 'UTC', $session.client, 'NULL' ) AS MaintOrdBasicStartTime,
tstmp_to_dats( dats_tims_to_tstmp(MaintOrdBasicEndDate, MaintOrdBasicEndTime, abap_system_timezone( $session.client,'NULL' ), $session.client, 'NULL'), 'UTC', $session.client, 'NULL' ) AS MaintOrdBasicEndDate,
tstmp_to_tims( dats_tims_to_tstmp(MaintOrdBasicEndDate, MaintOrdBasicEndTime, abap_system_timezone( $session.client,'NULL' ), $session.client, 'NULL'), 'UTC', $session.client, 'NULL' ) AS MaintOrdBasicEndTime,
cast(dats_tims_to_tstmp(ScheduledBasicStartDate, ScheduledBasicStartTime, abap_system_timezone( $session.client,'NULL' ), $session.client, 'NULL') as timestamp preserving type) AS MaintOrdSchedldBscStrtDateTime,
cast(dats_tims_to_tstmp(ScheduledBasicEndDate, ScheduledBasicEndTime, abap_system_timezone( $session.client,'NULL' ), $session.client, 'NULL') as timestamp preserving type) AS MaintOrdSchedldBscEndDateTime,
tstmp_to_dats( dats_tims_to_tstmp(ScheduledBasicStartDate, ScheduledBasicStartTime, abap_system_timezone( $session.client,'NULL' ), $session.client, 'NULL'), 'UTC', $session.client, 'NULL' ) AS ScheduledBasicStartDate,
tstmp_to_tims( dats_tims_to_tstmp(ScheduledBasicStartDate, ScheduledBasicStartTime, abap_system_timezone( $session.client,'NULL' ), $session.client, 'NULL'), 'UTC', $session.client, 'NULL' ) AS ScheduledBasicStartTime,
tstmp_to_dats( dats_tims_to_tstmp(ScheduledBasicEndDate, ScheduledBasicEndTime, abap_system_timezone( $session.client,'NULL' ), $session.client, 'NULL'), 'UTC', $session.client, 'NULL' ) AS ScheduledBasicEndDate,
tstmp_to_tims( dats_tims_to_tstmp(ScheduledBasicEndDate, ScheduledBasicEndTime, abap_system_timezone( $session.client,'NULL' ), $session.client, 'NULL'), 'UTC', $session.client, 'NULL' ) AS ScheduledBasicEndTime,
cast(dats_tims_to_tstmp(MaintOrderReferenceDate, MaintOrderReferenceTime, abap_system_timezone( $session.client,'NULL' ), $session.client, 'NULL') as timestamp preserving type) AS MaintOrderReferenceDateTime,
tstmp_to_dats( dats_tims_to_tstmp(MaintOrderReferenceDate, MaintOrderReferenceTime, abap_system_timezone( $session.client,'NULL' ), $session.client, 'NULL'), 'UTC', $session.client, 'NULL' ) AS MaintOrderReferenceDate,
tstmp_to_tims( dats_tims_to_tstmp(MaintOrderReferenceDate, MaintOrderReferenceTime, abap_system_timezone( $session.client,'NULL' ), $session.client, 'NULL'), 'UTC', $session.client, 'NULL' ) AS MaintOrderReferenceTime,
MaintenanceNotification,
OrdIsNotSchedldAutomatically,
MainWorkCenter,
MainWorkCenterPlant,
MaintenancePlanningPlant,
MaintenancePlant,
Assembly,
BusinessArea,
ReferenceElement,
FunctionalArea,
AdditionalDeviceData,
Equipment,
MaintenanceOrderPlanningCode,
MaintenancePlannerGroup,
MaintenanceActivityType,
OrderProcessingGroup,
ProfitCenter,
ResponsibleCostCenter,
MaintenanceRevision,
cast ( SerialNumber as vdm_eam_gernr ) AS SerialNumber,
SuperiorProjectNetwork,
OperationSystemCondition,
cast ( WBSElementInternalID as ps_s4_pspnr ) AS WBSElementInternalID,
ControllingObjectClass,
cast ( _LocationAccountAssignment.FunctionalLocation as vdm_eam_tplnr ) AS FunctionalLocation,
BasicSchedulingType,
LatestAcceptableCompletionDate,
MaintOrdPersonResponsible,
LastChangeDateTime,
CreatedByUser,
MaintObjectLocAcctAssgmtNmbr,
MaintenanceOrderInternalID
FROM I_MaintenanceOrder
LEFT OUTER JOIN I_StatusObjectStatus AS _OrderStatusObjectStatus ON MaintenanceOrderInternalID = _OrderStatusObjectStatus.StatusObject -- association [0..*]
LEFT OUTER JOIN I_Indicator AS _IsFinallyConfirmed ON IsFinallyConfirmed = _IsFinallyConfirmed.IndicatorValue -- association [0..1]
LEFT OUTER JOIN I_Indicator AS _IsInProcess ON IsInProcess = _IsInProcess.IndicatorValue -- association [0..1]
LEFT OUTER JOIN R_MaintenanceJobWorkItemTP AS _MaintenanceJobWorkItem ON /* condition not available in parsed metadata */ -- association [0..*]
;