I_MaintPlanCallHistory

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_MaintPlanCallHistory.
-- 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: IMPLANCALLHIST

CREATE VIEW I_MaintPlanCallHistory AS
SELECT
  mhis.warpl AS MaintenancePlan,
  mhis.abnum AS MaintenancePlanCallNumber,
  mhis.zaehl AS MaintenancePackage,
  mpla.strat AS MaintenanceStrategy,
  mhis.nplda AS MaintenanceCallNextPlannedDate,
  mhis.terma AS SchedulingType,
  mhis.tsenm AS MaintenancePlanCallIsLocked,
  mhis.tstat AS SchedulingStatus,
  case mhis.horda when '' then '00000000' else mhis.horda end as MaintenanceCallDate AS hordaendasMaintenanceCallDate,
  mhis.lrmdt AS CompletionDate,
  mhis.cycleseqind AS CycleSetSequence,
  mhis.rzaeh AS MaintCallCompltnCntrRdng,
  mhis.nzaeh AS MaintCallNextPlndCntrRdng,
  mhis.abrna AS ReleasedByUserName,
  mhis.tsabr AS MaintCallIsInvokedOnPlndDate,
  mhis.tsvbt AS MaintenanceCallIsOutstanding,
  mhis.tsenq AS MaintCallHorizonIsNotReached,
  mhis.abrud AS MaintPlanLastScheduledDate,
  mhis.npldz AS MaintPlanPrdcssrCallCompltnDte,
  mhis.manda AS MaintenancePlanManualCallDate,
  mhis.adcycle AS MaintPlanCycRcrrcIntervalQty,
  mhis.adunit AS MaintPlanCycRcrrcIntervalUnit,
  mhis.npldo AS MaintenanceCallLastPlannedDate
FROM mhis
INNER JOIN mpla ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_MaintenancePlan AS _MaintenancePlan ON _MaintenancePlan.MaintenancePlan = MaintenancePlan  -- association [0..1]
LEFT OUTER JOIN I_MaintenancePackage AS _MaintenancePackage ON _MaintenancePackage.MaintenanceStrategy = MaintenanceStrategy AND _MaintenancePackage.MaintenancePackage = MaintenancePackage  -- association [0..1]
LEFT OUTER JOIN I_MaintenanceStrategy AS _MaintenanceStrategy ON _MaintenanceStrategy.MaintenanceStrategy = MaintenanceStrategy  -- association [0..1]
LEFT OUTER JOIN I_Indicator AS _MaintenancePlanCallIsLocked ON _MaintenancePlanCallIsLocked.IndicatorValue = MaintenancePlanCallIsLocked  -- association [0..1]
LEFT OUTER JOIN I_MaintCallSchedulingType AS _SchedulingType ON _SchedulingType.SchedulingType = SchedulingType  -- association [0..1]
LEFT OUTER JOIN I_User AS _ReleasedByUserName ON _ReleasedByUserName.UserID = ReleasedByUserName  -- association [0..1]
;