C_MaintPlngBucketOverview

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 C_MaintPlngBucketOverview.
-- 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 C_MaintPlngBucketOverview AS
SELECT
  MaintPlanningBucketUUID,
  MaintPlanningBucketType,
  MaintenancePlanningPlant,
  MaintPlngBucketLabel,
  MaintPlanningBucketDescription,
  RefMaintPlanningBucket,
  MaintPlngBucketRecurrenceType,
  MaintPlngBucketStartDateTime,
  MaintPlngBucketEndDateTime,
  LastChangeDateTime,
  MaintPlngBucketDuration,
  MaintPlngBucketDurationUnit,
  MaintPlngBcktRcrrcInterval,
  cast( '' as meins ) AS MaintPlngBcktRcrrcIntervalUnit,
  _Sequence.MaintPlngBucketHasPrecdgBucket AS MaintPlngBucketHasPrecdgBucket,
  _Sequence.MaintPlngBucketHasSuccdgBucket AS MaintPlngBucketHasSuccdgBucket,
  MaintOrderForAdministration
FROM I_MaintPlanningBucket AS _MaintPlanningBucket
LEFT OUTER JOIN C_MaintPlngBcktNonStkProdRqmt AS _NonStockProductRequirements ON _NonStockProductRequirements.MaintPlanningBucketUUID = MaintPlanningBucketUUID  -- association [0..*]
LEFT OUTER JOIN C_MaintPlngBcktService AS _Service ON _Service.MaintPlanningBucketUUID = MaintPlanningBucketUUID  -- association [0..*]
LEFT OUTER JOIN C_MaintPlngBcktResource AS _Resource ON _Resource.MaintPlanningBucketUUID = MaintPlanningBucketUUID  -- association [0..*]
LEFT OUTER JOIN P_MaintPlanningBucketSequence AS _Sequence ON _Sequence.MaintPlanningBucketUUID = MaintPlanningBucketUUID  -- association [0..1]
LEFT OUTER JOIN I_MaintPlngBucketRcrrcType AS _RecurrenceType ON _RecurrenceType.MaintPlngBucketRecurrenceType = MaintPlngBucketRecurrenceType  -- association [0..1]
LEFT OUTER JOIN C_MaintPlngBcktOrderCube AS _OrdersCube ON _OrdersCube.MaintPlanningBucketUUID = MaintPlanningBucketUUID  -- association [0..*]
LEFT OUTER JOIN I_UnitOfMeasureText AS _UnitOfMeasureText ON _UnitOfMeasureText.Language = $session.system_language AND _UnitOfMeasureText.UnitOfMeasure = MaintPlngBucketDurationUnit  -- association [0..1]
LEFT OUTER JOIN C_MaintPlngBcktOrder AS _Orders ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN C_MaintPlngBcktStockProdRqmt AS _StockProductRequirements ON /* condition not available in parsed metadata */  -- association [0..*]
;