I_MaintPlanningBucketVH

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_MaintPlanningBucketVH.
-- 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: IMAINTPLNGBKTVH

CREATE VIEW I_MaintPlanningBucketVH AS
SELECT
  MaintPlanningBucketUUID,
  MaintPlngBucketLabel,
  MaintPlanningBucketDescription,
  MaintenancePlanningPlant,
  RefMaintPlanningBucket,
  MaintPlngBucketRecurrenceType,
  cast( case when MaintPlngBucketRecurrenceType <> 'ONCE' then 'X' end as maintplanningbucketisrefbucket preserving type ) AS MaintPlanningBucketIsRefBucket,
  PersonResponsible,
  MaintPlngBucketStartDateTime,
  MaintPlngBucketEndDateTime,
  MaintPlngBucketDuration,
  MaintPlngBucketDurationUnit,
  MaintPlngBcktRcrrcInterval,
  MaintPlngBcktRcrrcIntervalUnit,
  MaintPlanningBucketType
FROM I_MaintPlanningBucketTP
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_MaintPlngBucketRcrrcTypeTxt AS _RecurrenceTypeText ON _RecurrenceTypeText.MaintPlngBucketRecurrenceType = MaintPlngBucketRecurrenceType  -- association [0..*]
;