I_MaintenancePlanBasic_2

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_MaintenancePlanBasic_2.
-- 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.

CREATE VIEW I_MaintenancePlanBasic_2 AS
SELECT
  mpla.warpl AS MaintenancePlan,
  mpla.wptxt AS MaintenancePlanDesc,
  mpla.ersdt AS CreationDate,
  mpla.ernam AS CreatedByUser,
  mpla.aedat AS LastChangeDate,
  mpla.aenam AS LastChangedByUser,
  mpla.strat AS MaintenanceStrategy,
  mpla.abrho AS SchedulingDuration,
  mpla.equnr AS Equipment,
  cast( mpla.tplnr as ps_s4_tplnr preserving type ) AS FunctionalLocation,
  mpla.kunum AS Customer,
  mpla.anzps AS NumberOfMaintenanceItems,
  mpla.langu AS Language,
  mpla.sfakt AS CycleModificationRatio,
  mpla.stich AS MaintPlanSchedgIndicator,
  mpla.horiz AS CallHorizonPercent,
  mpla.horiz_days AS CallHorizonInDays,
  mpla.begru AS AuthorizationGroup,
  mpla.objnr AS MaintenancePlanInternalID,
  mpla.abnum AS MaintenanceCall,
  mpla.mptyp AS MaintenancePlanCategory,
  mpla.hunit AS SchedulingDurationUnit,
  mpla.stadt AS BasicStartDate,
  mpla.plan_sort AS MaintPlanFreeDefinedAttrib,
  mpla.fabkl AS FactoryCalendar,
  mpla.lvorm AS MaintPlanIsLockedAgainstCalls,
  mpla.changeddatetime AS LastChangeDateTime,
  mpla.vspos AS LateCompletionShiftInPercent,
  mpla.vsneg AS EarlyCompletionShiftInPercent,
  mpla.topos AS LateCompletionTolerancePercent,
  mpla.toneg AS EarlyCompletionTolerancePct,
  cast (mpla.horiz_qualifier as eam_cc_callhorizon_calc_type preserving type) AS MaintenanceCallHorizonCalcType,
  mpla.andor AS MaintPlanLogicalOperatorCode,
  mpla.mcp_sf AS MultipleCounterPlanShiftFactor,
  mpla.szaeh AS MaintPlanStartCntrReadingValue,
  mpla.start_date AS SchedulingStartDate,
  mpla.start_time AS SchedulingStartTime,
  mpla.end_counter AS MaintPlanEndCntrReadingValue,
  mpla.enddt_for_sched AS SchedulingEndDate,
  mpla.puffp AS MaintenanceLeadFloatInDays,
  mpla.tgoon AS MaintPlnStrtBufDurationInDays,
  cast('TAG' as hunit) AS MaintPlanStartBufferUnit,
  mpla.call_confirm AS PrdcssrCallObjCompltnIsRqd,
  mpla.ltknz AS MaintenancePlanHasLongText,
  _MaintenancePlanCatParam.MaintenancePlanCallObject AS MaintenancePlanCallObject
FROM mpla
LEFT OUTER JOIN I_StatusObjectActiveStatus AS _StatusObjectActiveStatus ON _StatusObjectActiveStatus.StatusObject = MaintenancePlanInternalID  -- association [0..*]
LEFT OUTER JOIN I_MaintenanceItem AS _MaintenanceItem ON _MaintenanceItem.MaintenancePlan = MaintenancePlan  -- association [0..*]
LEFT OUTER JOIN I_MaintenancePlanCatParam AS _MaintenancePlanCatParam ON _MaintenancePlanCatParam.MaintenancePlanCategory = MaintenancePlanCategory  -- association [0..1]
LEFT OUTER JOIN I_Customer AS _Customer ON _Customer.Customer = Customer  -- association [0..1]
LEFT OUTER JOIN I_Equipment AS _Equipment ON _Equipment.Equipment = Equipment  -- association [0..1]
LEFT OUTER JOIN I_FunctionalLocationLabel AS _FunctionalLocationLabel ON _FunctionalLocationLabel.FunctionalLocation = FunctionalLocation  -- association [0..1]
LEFT OUTER JOIN I_MaintenanceCall AS _MaintenanceCall ON _MaintenanceCall.MaintenancePlan = MaintenancePlan AND _MaintenanceCall.MaintenanceCall = MaintenanceCall  -- association [0..*]
LEFT OUTER JOIN I_MaintPlanCallHistory AS _MaintPlanCallHistory ON _MaintPlanCallHistory.MaintenancePlan = MaintenancePlan  -- association [0..*]
LEFT OUTER JOIN I_MaintenanceStrategy AS _MaintenanceStrategy ON _MaintenanceStrategy.MaintenanceStrategy = MaintenanceStrategy  -- association [0..1]
LEFT OUTER JOIN I_FactoryCalendar AS _FactoryCalendar ON _FactoryCalendar.FactoryCalendar = FactoryCalendar  -- association [0..1]
LEFT OUTER JOIN I_MaintenanceCycle AS _MaintenanceCycle ON _MaintenanceCycle.MaintenancePlan = MaintenancePlan  -- association [0..*]
LEFT OUTER JOIN I_MaintenancePlanCycle AS _MaintenancePlanCycle ON _MaintenancePlanCycle.MaintenancePlan = MaintenancePlan  -- association [1..*]
LEFT OUTER JOIN I_MaintPlanSchedgInd AS _SchedulingIndicator ON _SchedulingIndicator.MaintPlanSchedgIndicator = MaintPlanSchedgIndicator  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _SchedulingDurationUnit ON _SchedulingDurationUnit.UnitOfMeasure = SchedulingDurationUnit  -- association [0..1]
LEFT OUTER JOIN I_MaintPlanLgclOptr AS _LogicalOperator ON _LogicalOperator.LogicalOperator = MaintPlanLogicalOperatorCode  -- association [0..1]
LEFT OUTER JOIN I_TechObjAuthznGrp AS _AuthorizationGroup ON _AuthorizationGroup.TechObjAuthorizationGroup = AuthorizationGroup  -- association [0..1]
LEFT OUTER JOIN I_Indicator AS _MaintCallConfIsRequired ON _MaintCallConfIsRequired.IndicatorValue = PrdcssrCallObjCompltnIsRqd  -- association [0..1]
LEFT OUTER JOIN I_MaintenancePlanSortField AS _MaintenancePlanSortField ON _MaintenancePlanSortField.MaintenancePlanSortField = MaintPlanFreeDefinedAttrib  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _MaintPlanStartBufferUnit ON _MaintPlanStartBufferUnit.UnitOfMeasure = MaintPlanStartBufferUnit  -- association [0..1]
LEFT OUTER JOIN E_MaintenancePlan AS _MaintenancePlanExtension ON MaintenancePlan = _MaintenancePlanExtension.MaintenancePlan  -- association [0..1]
;