C_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 C_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 C_MaintPlanningBucketTP_2 AS
SELECT
  MaintPlanningBucketUUID,
  MaintPlanningBucketType,
  _BucketTypeText.MaintPlanningBucketTypeText : localized AS MaintPlanningBucketTypeTextlocalized,
  MaintenancePlanningPlant,
  _MaintenancePlanningPlant.PlantName1 AS MaintenancePlanningPlantName,
  MaintPlngBucketLabel,
  MaintPlanningBucketDescription,
  RefMaintPlanningBucket,
  RefMaintPlanningBucketLabel,
  MaintPlngBucketRecurrenceType,
  _RecurrenceType._Text.MaintPlngBcktRecurrenceTypeTxt : localized AS MaintPlngBcktRecurrenceTypeTxtlocalized,
  NrOfMaintPlngBucketsInAdvance,
  _PersonWorkAgreement.PersonFullName AS PersonFullName,
  MaintPlngBucketStartDateTime,
  MaintPlngBucketEndDateTime,
  MaintPlanningBucketStartDate,
  MaintPlanningBucketEndDate,
  MaintPlngBucketDuration,
  MaintPlngBucketDurationUnit,
  _UnitOfMeasureText.UnitOfMeasureName : localized AS UnitOfMeasureNamelocalized,
  LastChangeDateTime,
  MaintPlngBucketGenerationDate,
  MaintPlngBcktRcrrcInterval,
  MaintPlngBcktRcrrcIntervalUnit,
  MaintenanceEvent,
  virtual UICT_MaintenanceEvent : boole_d AS virtualUICT_MaintenanceEventboole_d,
  MaintenanceEventType,
  _MaintenanceEventTypeText.MaintEventTypeDescription AS MaintEventTypeDescription,
  MaintOrderForAdministration,
  _MaintenanceOrder.MaintenanceOrderDesc AS MaintenanceOrderDesc,
  OperationSystemCondition,
  _OperationSystCondition.OperationSystemConditionText AS OperationSystemConditionText,
  MaintPlanningBucketCalendarDay,
  MaintPlngBucketCalendarWeek,
  MaintPlngBucketCalendarYear,
  MaintPlanningBucketWeekYear,
  MaintenancePlanningBucket,
  MaintPlngBucketStatusObject,
  MaintenanceSystemStatusCode,
  SystemStatusText,
  MaintenancePlant,
  _MaintenancePlant.PlantName AS PlantName,
  virtual Equipment : rvari_val_255 AS virtualEquipmentrvari_val_255,
  virtual FunctionalLocation : rvari_val_255 AS virtualFunctionalLocationrvari_val_255,
  virtual NumberOfMaintenanceOrders : int4 AS virtualNumberOfMaintenanceOrdersint4,
  virtual NrOfMaintenanceNotifications : int4 AS virtualNrOfMaintenanceNotificationsint4,
  virtual UICT_SystemStatusText : boole_d AS virtualUICT_SystemStatusTextboole_d,
  virtual NrOfCmpltdMaintNotifications : abap.int4 AS int4,
  AdminvOrdWorkCenterInternal,
  MainWorkCenter,
  _MainWorkCenterText.WorkCenterText AS WorkCenterText
FROM R_MaintPlanningBucketTP_2
LEFT OUTER JOIN C_MaintenanceObjectStatus AS _MaintenanceObjectStatus ON _MaintenanceObjectStatus.StatusObject = MaintPlngBucketStatusObject  -- association [0..*]
LEFT OUTER JOIN C_MaintPlngBcktUsrStsWthNmbr AS _MaintPlngBcktUsrStsWthNmbr ON _MaintPlngBcktUsrStsWthNmbr.MaintPlanningBucketUUID = MaintPlanningBucketUUID  -- association [0..*]
LEFT OUTER JOIN C_MaintPlngBcktUsrStsNoNumber AS _MaintPlngBcktStsWthoutNmbr ON _MaintPlngBcktStsWthoutNmbr.MaintPlanningBucketUUID = MaintPlanningBucketUUID  -- association [0..*]
;