P_MaintPlngBcktResource

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 P_MaintPlngBcktResource.
-- 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 P_MaintPlngBcktResource AS
SELECT
  cast( ' ' as vornr preserving type ) AS MaintenanceOrderSubOperation,
  MntOrderMainOperation._WorkCenter.WorkCenter AS OperationWorkCenter,
  _WorkCenterTextBySemanticKey[ 1:Language = $session.system_language ].WorkCenterText AS WorkCenterText,
  _MaintOperationExecStageCode._MaintOpExecStageCodeText[1:LanguageCode = $session.system_language ].MaintOpExecStageShortText AS MaintOpExecStageShortText,
  _MaintOperationExecStageCode._MaintOpExecStageCodeText[1:LanguageCode = $session.system_language ].MaintOpExecutionStageName AS MaintOpExecutionStageName,
  cast( 'H' as abap.unit( 3 ) ) AS HoursUnitOfMeasure,
  unit_conversion( quantity => _MaintOrdOpPlngRemainingWork.ConfirmationTotalQuantity, source_unit => _OperationPlanningValues.OperationPlannedWorkUnit, target_unit => cast( 'H' as abap.unit( 3 ) ), error_handling => 'SET_TO_NULL' ) AS ActualWorkInHours,
  unit_conversion( quantity => _MaintOrdOpPlngRemainingWork.RemainingWorkQuantity, source_unit => _OperationPlanningValues.OperationPlannedWorkUnit, target_unit => cast( 'H' as abap.unit( 3 ) ), error_handling => 'SET_TO_NULL' ) AS RemainingWorkQuantityInHours,
  cast ( 0 as abap.int1 ) AS WorkCenterUtilization,
  unit_conversion( quantity => _OperationPlanningValues.OperationPlannedWork, source_unit => _OperationPlanningValues.OperationPlannedWorkUnit, target_unit => cast( 'H' as abap.unit( 3 ) ), error_handling => 'SET_TO_NULL' ) AS PlannedWorkInHours,
  P_MaintPlngBucketMaintOrdBasic._LocationAccountAssignment.PlantSection AS PlantSection,
  P_MaintPlngBucketMaintOrdBasic._LocationAccountAssignment.FunctionalLocation AS FunctionalLocation,
  MntOrderMainOperation.Operation AS MaintenanceOrderOperation,
  MntOrderMainOperation.ObjectInternalID AS ObjectInternalID,
  MntOrderMainOperation.OperationText AS OperationDescription,
  MntOrderMainOperation.MaintOperationExecStageCode AS MaintOperationExecStageCode,
  MntOrderMainOperation.NumberOfCapacities AS NumberOfCapacities,
  MntOrderMainOperation.CapacityRequirement AS CapacityRequirement,
  MntOrderMainOperation.OrderInternalID AS MaintOrderRoutingNumber,
  MntOrderMainOperation.OrderOperationInternalID AS MaintOrderOperationCounter,
  MntOrderMainOperation.Plant AS Plant,
  MntOrderMainOperation.Supplier AS OperationSupplier,
  MntOrderMainOperation.OperationPersonResponsible AS OperationPersonResponsible,
  MntOrderMainOperation.MaterialGroup AS MaterialGroup,
  MntOrderMainOperation.CostElement AS CostElement,
  MntOrderMainOperation.PurchasingGroup AS PurchasingGroup,
  MntOrderMainOperation.PurchasingOrganization AS PurchasingOrganization,
  MntOrderMainOperation.Language AS Language,
  P_MaintPlngBucketMaintOrdBasic.MaintenanceOrder AS MaintenanceOrder,
  P_MaintPlngBucketMaintOrdBasic.MaintenanceOrderDesc AS MaintenanceOrderDesc,
  P_MaintPlngBucketMaintOrdBasic.MaintOrdProcessPhaseCode AS MaintOrdProcessPhaseCode,
  P_MaintPlngBucketMaintOrdBasic.MaintenanceOrderType AS MaintenanceOrderType,
  P_MaintPlngBucketMaintOrdBasic.ScheduledBasicStartDate AS ScheduledBasicStartDate,
  P_MaintPlngBucketMaintOrdBasic.ScheduledBasicStartTime AS ScheduledBasicStartTime,
  P_MaintPlngBucketMaintOrdBasic.ScheduledBasicEndDate AS ScheduledBasicEndDate,
  P_MaintPlngBucketMaintOrdBasic.ScheduledBasicEndTime AS ScheduledBasicEndTime,
  P_MaintPlngBucketMaintOrdBasic.MaintOrdBasicStartDate AS MaintOrdBasicStartDate,
  P_MaintPlngBucketMaintOrdBasic.MaintOrdBasicStartTime AS MaintOrdBasicStartTime,
  P_MaintPlngBucketMaintOrdBasic.MaintOrdBasicEndDate AS MaintOrdBasicEndDate,
  P_MaintPlngBucketMaintOrdBasic.MaintOrdBasicEndTime AS MaintOrdBasicEndTime,
  P_MaintPlngBucketMaintOrdBasic.MaintenancePlanningPlant AS MaintenancePlanningPlant,
  P_MaintPlngBucketMaintOrdBasic.MaintenancePlant AS MaintenancePlant,
  P_MaintPlngBucketMaintOrdBasic.MaintenancePlannerGroup AS MaintenancePlannerGroup,
  P_MaintPlngBucketMaintOrdBasic.WorkCenterInternalID AS WorkCenterInternalID,
  P_MaintPlngBucketMaintOrdBasic.WorkCenterTypeCode AS WorkCenterTypeCode,
  P_MaintPlngBucketMaintOrdBasic.MainWorkCenter AS MainWorkCenter,
  P_MaintPlngBucketMaintOrdBasic.Equipment AS Equipment,
  P_MaintPlngBucketMaintOrdBasic.MaintObjectLocAcctAssgmtNmbr AS MaintObjectLocAcctAssgmtNmbr,
  _MaintOperationExecStageCode.MaintOpExecStageGroupCode AS MaintOpExecStageGroupCode,
  _MaintOrdOpPlngRemainingWork.ConfirmationTotalQuantity AS ConfirmationTotalQuantity,
  _MaintOrdOpPlngRemainingWork.RemainingWorkQuantity AS RemainingWorkQuantity,
  _MaintOrdOpPlngRemainingWork.OpErlstSchedldExecStrtDte AS OpErlstSchedldExecStrtDte,
  _MaintOrdOpPlngRemainingWork.OpErlstSchedldExecStrtTme AS OpErlstSchedldExecStrtTme,
  _MaintOrdOpPlngRemainingWork.OpErlstSchedldExecEndDte AS OpErlstSchedldExecEndDte,
  _MaintOrdOpPlngRemainingWork.OpErlstSchedldExecEndTme AS OpErlstSchedldExecEndTme,
  _MaintOrdOpPlngRemainingWork.OpLtstSchedldExecStrtDte AS OpLtstSchedldExecStrtDte,
  _MaintOrdOpPlngRemainingWork.OpLtstSchedldExecStrtTme AS OpLtstSchedldExecStrtTme,
  _MaintOrdOpPlngRemainingWork.OpLtstSchedldExecEndDte AS OpLtstSchedldExecEndDte,
  _MaintOrdOpPlngRemainingWork.OpLtstSchedldExecEndTme AS OpLtstSchedldExecEndTme,
  _MaintOrdOpPlngRemainingWork.OpActualExecutionStartDate AS OpActualExecutionStartDate,
  _MaintOrdOpPlngRemainingWork.OpActualExecutionStartTime AS OpActualExecutionStartTime,
  _MaintOrdOpPlngRemainingWork.OpActualExecutionEndDate AS OpActualExecutionEndDate,
  _MaintOrdOpPlngRemainingWork.OpActualExecutionEndTime AS OpActualExecutionEndTime,
  _MaintOrdOpPlngRemainingWork.OperationPlannedWorkUnit AS OperationPlannedWorkUnit,
  _OperationPlanningValues.OperationPlannedWork AS OperationPlannedWork
FROM I_OrderOperation AS MntOrderMainOperation
INNER JOIN P_MaintPlngBucketMaintOrdBasic ON /* join condition not captured in parsed metadata */
INNER JOIN I_OperationControlProfile AS _OperationControlKey ON /* join condition not captured in parsed metadata */
INNER JOIN P_MaintPlngBucketMaintOrdBasic AS _PlanningBucketOrder ON /* join condition not captured in parsed metadata */
INNER JOIN I_OrderOperation AS afvc_superior ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN P_MaintOrdOpPlngRemainingWork AS _MaintOrdOpPlngRemainingWork ON _MaintOrdOpPlngRemainingWork.MaintOrderRoutingNumber = MntOrderMainOperation.OrderInternalID AND _MaintOrdOpPlngRemainingWork.MaintOrderOperationCounter = MntOrderMainOperation.OrderOperationInternalID  -- association [0..1]
LEFT OUTER JOIN I_WorkCenterTextBySemanticKey AS _WorkCenterTextBySemanticKey ON MntOrderMainOperation.WorkCenterTypeCode = _WorkCenterTextBySemanticKey.WorkCenterTypeCode AND MntOrderMainOperation.WorkCenterInternalID = _WorkCenterTextBySemanticKey.WorkCenterInternalID AND MntOrderMainOperation.Plant = _WorkCenterTextBySemanticKey.Plant  -- association [0..*]
LEFT OUTER JOIN I_MaintOperationExecStageCode AS _MaintOperationExecStageCode ON MaintOperationExecStageCode = _MaintOperationExecStageCode.MaintOperationExecStageCode  -- association [1..1]
LEFT OUTER JOIN I_MaintOrderOperPlanningValues AS _OperationPlanningValues ON MntOrderMainOperation.OrderInternalID = _OperationPlanningValues.MaintOrderRoutingNumber AND MntOrderMainOperation.OrderOperationInternalID = _OperationPlanningValues.MaintOrderOperationCounter  -- association [1..1]
LEFT OUTER JOIN P_MaintPlngBucketMaintOrdBasic AS _MaintenanceOrder ON _MaintenanceOrder.MaintenanceOrder = P_MaintPlngBucketMaintOrdBasic.MaintenanceOrder  -- association [1..1]
LEFT OUTER JOIN I_PersonWorkAgreement_1 AS _PersonResponsible ON OperationPersonResponsible = _PersonResponsible.PersonWorkAgreement  -- association [0..1]
LEFT OUTER JOIN I_Supplier AS _Supplier ON OperationSupplier = _Supplier.Supplier  -- association [0..1]
LEFT OUTER JOIN I_FunclocationLabelInternal AS _FuncnlLocationLabel ON _FuncnlLocationLabel.FunctionalLocation = functionallocation  -- association [0..*]
-- UNION ALL with additional select branch(es): I_OrderOperation
;