I_MaintPlanCallObject

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_MaintPlanCallObject.
-- 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: IMPLANCALLOBJ

CREATE VIEW I_MaintPlanCallObject AS
SELECT
  mhio.warpl AS MaintenancePlan,
  mhio.abnum AS MaintenancePlanCallNumber,
  mhio.wppos AS MaintenanceItem,
  mhio.aufnr AS MaintenanceOrder,
  mhio.qmnum AS MaintenanceNotification,
  mhio.tsenq AS MaintCallHorizonIsNotReached,
  mhio.tstat AS SchedulingStatus,
  mhio.gstrp AS PlannedStartDate,
  mhio.usermod AS ReleasedByUserName,
  mhio.service_order AS ServiceOrder,
  mhio.addat AS CompletionDate,
  mhio.adtime AS CompletionTime,
  mhio.lblni AS ServiceEntrySheet,
  cast( mhio.revision_no as j_3rfinv_revno ) AS RevisionNumber
FROM mhio
LEFT OUTER JOIN I_MaintenancePlanBasic AS _MaintenancePlan ON _MaintenancePlan.MaintenancePlan = MaintenancePlan  -- association [0..1]
LEFT OUTER JOIN I_MaintenanceItem AS _MaintenanceItem ON _MaintenanceItem.MaintenanceItem = MaintenanceItem  -- association [0..1]
LEFT OUTER JOIN I_MaintenanceOrder AS _MaintenanceOrder ON _MaintenanceOrder.MaintenanceOrder = MaintenanceOrder  -- association [0..1]
LEFT OUTER JOIN I_MaintenanceNotification AS _MaintenanceNotification ON _MaintenanceNotification.MaintenanceNotification = MaintenanceNotification  -- association [0..1]
LEFT OUTER JOIN I_ServiceDocument AS _ServiceOrder ON _ServiceOrder.ServiceObjectType = 'BUS2000116' AND _ServiceOrder.ServiceDocument = ServiceOrder  -- association [0..1]
LEFT OUTER JOIN I_MaintPlanCallHistory AS _MaintPlanCallHistory ON _MaintPlanCallHistory.MaintenancePlan = MaintenancePlan AND _MaintPlanCallHistory.MaintenancePlanCallNumber = MaintenancePlanCallNumber  -- association [0..*]
;