I_MaintPlngBucketWithRespyData

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_MaintPlngBucketWithRespyData.
-- 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: IMAINTPLNGBKTRSP

CREATE VIEW I_MaintPlngBucketWithRespyData AS
SELECT
  MaintPlanningBucketUUID,
  MaintPlanningBucketType,
  eam_plngbkt.maintenanceplanningplant AS MaintenancePlanningPlant,
  MaintPlngBucketLabel,
  MaintPlanningBucketDescription,
  RefMaintPlanningBucket,
  MaintPlngBucketLabelPattern,
  MaintPlngBucketRecurrenceType,
  NrOfMaintPlngBucketsInAdvance,
  personresponsible AS MaintPlanningBucketPersonResp,
  MaintPlngBucketStartDateTime,
  MaintPlngBucketDuration,
  MaintPlngBucketDurationUnit,
  MaintPlngBucketEndDateTime,
  eam_plngbkt.lastchangedatetime AS LastChangeDateTime,
  MaintPlngBucketGenerationDate,
  maintplngbucketsortfield AS MaintPlngBucketSortUUID,
  MaintPlngBcktRcrrcInterval,
  MaintenanceEvent,
  MaintOrderForAdministration
FROM eam_plngbkt
LEFT OUTER JOIN I_MaintPlanningBucketScope AS _MaintPlanningBucketScope ON _MaintPlanningBucketScope.MaintPlanningBucketUUID = MaintPlanningBucketUUID  -- association [0..*]
LEFT OUTER JOIN I_MaintenancePlanPlant AS _MaintenancePlanningPlant ON _MaintenancePlanningPlant.MaintenancePlanningPlant = MaintenancePlanningPlant  -- association [0..1]
LEFT OUTER JOIN I_PersonWorkAgreement_1 AS _PersonWorkAgreement ON _PersonWorkAgreement.PersonWorkAgreement = MaintPlanningBucketPersonResp  -- association [0..1]
LEFT OUTER JOIN I_MaintPlanningBucketType AS _MaintPlanningBucketType ON _MaintPlanningBucketType.MaintPlanningBucketType = MaintPlanningBucketType  -- association [1]
;