R_MaintPlanningBucketTP_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 R_MaintPlanningBucketTP_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 R_MaintPlanningBucketTP_2 AS
SELECT
  MaintPlanningBucketUUID,
  MaintenancePlanningBucket,
  MaintPlanningBucketType,
  MaintenancePlanningPlant,
  MaintPlngBucketLabel,
  MaintPlanningBucketDescription,
  RefMaintPlanningBucket,
  MaintPlngBucketRecurrenceType,
  NrOfMaintPlngBucketsInAdvance,
  MaintPlngBucketStartDateTime,
  MaintPlngBucketEndDateTime,
  MaintPlanningBucketStartDate,
  MaintPlanningBucketEndDate,
  LastChangeDateTime,
  MaintPlngBucketGenerationDate,
  cast( MaintPlngBucketDuration as duration ) AS MaintPlngBucketDuration,
  MaintPlngBucketDurationUnit,
  cast( MaintPlngBcktRcrrcInterval as eam_plngbckt_recurrence ) AS MaintPlngBcktRcrrcInterval,
  MaintenanceEvent,
  cast( _MaintenanceEvent.MaintenanceEventType as diwps_revty preserving type) AS MaintenanceEventType,
  I_MaintenancePlanningBucket_2.OperationSystemCondition AS OperationSystemCondition,
  MaintOrderForAdministration,
  MaintPlngBucketStatusObject,
  MaintenanceSystemStatusCode,
  cast( _StatusCodeText[1: Language = $session.system_language ].StatusName as j_stext ) AS SystemStatusText,
  MaintenancePlant,
  concat( _CalendarDate.CalendarWeek, concat_with_space( ' /', _CalendarDate.CalendarYear, 1 )) AS MaintPlanningBucketWeekYear,
  _RefMaintPlanningBucket.MaintPlngBucketLabel AS RefMaintPlanningBucketLabel,
  MainWorkCenter,
  AdminvOrdWorkCenterInternal
FROM I_MaintenancePlanningBucket_2
LEFT OUTER JOIN E_MaintPlanningBucket AS _MaintPlanningBucketExtension ON MaintPlanningBucketUUID = _MaintPlanningBucketExtension.MaintPlanningBucketUUID  -- association [0..1]
LEFT OUTER JOIN I_CalendarDate AS _CalendarDate ON _CalendarDate.CalendarDate = I_MaintenancePlanningBucket_2.MaintPlanningBucketStartDate  -- association [0..1]
LEFT OUTER JOIN I_StatusCodeText AS _StatusCodeText ON MaintenanceSystemStatusCode = _StatusCodeText.StatusCode AND _StatusCodeText.Language = $session.system_language  -- association [0..*]
LEFT OUTER JOIN I_Plant AS _MaintenancePlant ON MaintenancePlant = _MaintenancePlant.Plant  -- association [0..1]
LEFT OUTER JOIN I_MaintenanceRevision AS _MaintenanceEvent ON _MaintenanceEvent.MaintenanceRevision = MaintenanceEvent AND _MaintenanceEvent.MaintenancePlanningPlant = MaintenancePlanningPlant  -- association [0..1]
LEFT OUTER JOIN I_MaintenancePlanningBucket_2 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_MaintPlngBucketRcrrcTypeTxt AS _RcrrcTypeTxt ON _RcrrcTypeTxt.MaintPlngBucketRecurrenceType = MaintPlngBucketRecurrenceType  -- association [1..*]
LEFT OUTER JOIN I_MaintenanceEventTypeText AS _MaintenanceEventTypeText ON _MaintenanceEventTypeText.MaintenanceEventType = MaintenanceEventType AND _MaintenanceEventTypeText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _UnitOfMeasure ON _UnitOfMeasure.UnitOfMeasure = 'WCH'  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasureText AS _UnitOfMeasureText ON _UnitOfMeasureText.UnitOfMeasure = MaintPlngBucketDurationUnit  -- association [1..*]
LEFT OUTER JOIN I_MaintPlanningBucketTypeText AS _BucketTypeText ON _BucketTypeText.MaintPlanningBucketType = MaintPlanningBucketType  -- association [1..*]
LEFT OUTER JOIN I_MaintPlanningBucketType AS _MaintPlanningBucketType ON _MaintPlanningBucketType.MaintPlanningBucketType = MaintPlanningBucketType  -- association [1]
LEFT OUTER JOIN I_MaintenanceOrder AS _MaintenanceOrder ON _MaintenanceOrder.MaintenanceOrder = MaintOrderForAdministration  -- association [1..1]
LEFT OUTER JOIN I_PersonWorkAgreement_1 AS _PersonWorkAgreement ON _PersonWorkAgreement.PersonWorkAgreement = MaintPlanningBucketPersonResp  -- association [0..1]
LEFT OUTER JOIN I_MaintOperationSystConditionT AS _OperationSystCondition ON OperationSystemCondition = _OperationSystCondition.OperationSystemCondition AND _OperationSystCondition.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_WorkCenterText AS _MainWorkCenterText ON _MainWorkCenterText.WorkCenterInternalID = AdminvOrdWorkCenterInternal AND _MainWorkCenterText.WorkCenterTypeCode = 'A' AND _MainWorkCenterText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN R_MaintPlngBucketScopeNameTP AS _MaintPlngBucketScopeNameTP ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN R_MaintPlngBcktExecObjectTP AS _MaintPlngBcktExecObjectTP ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN R_MaintPlanningBucketComment AS _MaintPlngBucketComments ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN R_MaintPlngBucketUserStatusTP AS _MaintPlngBucketUserStatus ON /* condition not available in parsed metadata */  -- association [0..*]
;