I_MaintPlanningBucketTP

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_MaintPlanningBucketTP.
-- 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_MaintPlanningBucketTP AS
SELECT
  MaintPlanningBucketUUID,
  MaintPlanningBucketType,
  MaintenancePlanningPlant,
  MaintPlngBucketLabel,
  MaintPlanningBucketDescription,
  RefMaintPlanningBucket,
  ' ' AS MaintPlngBcktLabelPatternDesc,
  cast(' ' as abap.dats) AS MaintPlngBcktNextGnrtnDate,
  MaintPlngBucketLabelPattern,
  MaintPlngBucketRecurrenceType,
  NrOfMaintPlngBucketsInAdvance,
  MaintPlanningBucketPersonResp AS PersonResponsible,
  MaintPlngBucketStartDateTime,
  MaintPlngBucketEndDateTime,
  LastChangeDateTime,
  MaintPlngBucketGenerationDate,
  MaintPlngBucketSortUUID AS MaintPlngBucketSortField,
  MaintPlngBucketDuration,
  MaintPlngBucketDurationUnit,
  MaintPlngBcktRcrrcInterval,
  MaintenanceEvent,
  ' ' AS MaintenanceRevision,
  ' ' AS MaintenanceEventType,
  ' ' AS OperationSystemCondition,
  MaintOrderForAdministration,
  cast( '' as xfeld ) AS MaintEventHasOrderAssigned,
  cast( '00' as maintordselfordateadjmt ) AS MaintOrdSelForDateAdjmt
FROM I_MaintPlngBucketWithRespyData
LEFT OUTER JOIN I_MaintPlanningBucketScopeTP AS _MaintPlanningBucketScope ON _MaintPlanningBucketScope.MaintPlanningBucketUUID = MaintPlanningBucketUUID  -- association [0..*]
LEFT OUTER JOIN I_MaintPlanningBucketTP AS _RefMaintPlanningBucket ON _RefMaintPlanningBucket.MaintPlanningBucketUUID = RefMaintPlanningBucket  -- association [0..1]
LEFT OUTER JOIN I_MaintenancePlanPlant AS _MaintenancePlanningPlant ON _MaintenancePlanningPlant.MaintenancePlanningPlant = MaintenancePlanningPlant  -- association [0..1]
LEFT OUTER JOIN I_MaintPlngBucketRcrrcType AS _RecurrenceType ON _RecurrenceType.MaintPlngBucketRecurrenceType = MaintPlngBucketRecurrenceType  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _UnitOfMeasure ON _UnitOfMeasure.UnitOfMeasureSAPCode = 'WCH' AND _UnitOfMeasure.UnitOfMeasureISOCode = 'WEE' AND _UnitOfMeasure.IsPrimaryUnitForISOCode = 'X'  -- association [0..1]
;