P_RSHOperationsForUtilization

DDL: P_RSHOPERATIONSFORUTILIZATION SQL: PRSHOPUTIL Type: view CONSUMPTION
24 Fields 7 Data Sources

Operations and Sub Operations for utilization

P_RSHOperationsForUtilization is a Consumption CDS View that provides data about "Operations and Sub Operations for utilization" in SAP S/4HANA. It reads from 7 data sources and exposes 24 fields with key fields MaintenanceOrder, MaintenanceOrderOperation, MaintenanceOrderSubOperation.

Data Sources (7)

SourceAliasJoin Type
I_RSHOperationStatusObject excl_status left_outer
I_MaintOrderOperPlanningValues I_MaintOrderOperPlanningValues inner
I_RSHOperationStatusObject incl_status inner
I_MaintOrderOperAndSubOper iop from
I_MaintenanceOrder iorder inner
I_OperationControlProfile operation_controlprofile inner
I_RSHAssignedWorkCenters user_var inner

Parameters (2)

NameTypeDefault
P_StartDate datum
P_EndDate datum

Annotations (7)

NameValueLevelField
AbapCatalog.sqlViewName PRSHOPUTIL view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
VDM.private true view
VDM.viewType #CONSUMPTION view
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label Operations and Sub Operations for utilization view

Fields (24)

KeyFieldSource TableSource FieldDescription
KEY MaintenanceOrder I_MaintOrderOperAndSubOper MaintenanceOrder Order
KEY MaintenanceOrderOperation I_MaintOrderOperAndSubOper MaintenanceOrderOperation Suboperation
KEY MaintenanceOrderSubOperation I_MaintOrderOperAndSubOper MaintenanceOrderSubOperation Suboperation
OperationControlKey I_MaintOrderOperAndSubOper OperationControlKey Control Key
MaintPriority I_MaintenanceOrder MaintPriority Priority
MaintPriorityType I_MaintenanceOrder MaintPriorityType PriorityType
MaintPriorityColorCode
MaintenanceActivityType I_MaintenanceOrder MaintenanceActivityType MaintActivType
MaintenanceOrderType I_MaintenanceOrder MaintenanceOrderType Order Type
WorkCenter I_RSHAssignedWorkCenters WorkCenter Work Center
WorkCenterInternalID I_MaintOrderOperAndSubOper OperationWorkCenterInternalID Object ID
WorkCenterTypeCode I_MaintOrderOperAndSubOper OperationWorkCenterTypeCode
WorkCenterCategoryCode I_RSHAssignedWorkCenters WorkCenterCategoryCode
CapacityInternalID I_RSHAssignedWorkCenters CapacityInternalID Capacity ID
Plant I_MaintOrderOperAndSubOper Plant Valuation Area
OperationPlannedWork I_MaintOrderOperPlanningValues OperationPlannedWork Work
OperationPlannedWorkUnit I_MaintOrderOperPlanningValues OperationPlannedWorkUnit Unit for work
RemainingWorkQuantity
LatestAcceptableCompletionDate I_MaintenanceOrder LatestAcceptableCompletionDate Final Due Date
OperationPersonResponsible I_MaintOrderOperAndSubOper OperationPersonResponsible Personnel no.
MaintOperationExecStageCode I_MaintOrderOperAndSubOper MaintOperationExecStageCode Execution Stage
MaintOrdOpProcessSubPhaseCode I_MaintOrderOperAndSubOper MaintOrdOpProcessSubPhaseCode Process Subphase
ServiceDocument I_MaintenanceOrder ServiceDocument Transaction ID
ServiceDocumentItem I_MaintenanceOrder ServiceDocumentItem Service Document

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_RSHOperationsForUtilization.
-- 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: PRSHOPUTIL
-- Parameters: P_StartDate : datum, P_EndDate : datum

CREATE VIEW P_RSHOperationsForUtilization AS
SELECT
  iop.MaintenanceOrder AS MaintenanceOrder,
  iop.MaintenanceOrderOperation AS MaintenanceOrderOperation,
  iop.MaintenanceOrderSubOperation AS MaintenanceOrderSubOperation,
  iop.OperationControlKey AS OperationControlKey,
  iorder.MaintPriority AS MaintPriority,
  iorder.MaintPriorityType AS MaintPriorityType,
  iorder._MaintenancePriority.MaintPriorityColorCode AS MaintPriorityColorCode,
  iorder.MaintenanceActivityType AS MaintenanceActivityType,
  iorder.MaintenanceOrderType AS MaintenanceOrderType,
  user_var.WorkCenter AS WorkCenter,
  iop.OperationWorkCenterInternalID AS WorkCenterInternalID,
  iop.OperationWorkCenterTypeCode AS WorkCenterTypeCode,
  user_var.WorkCenterCategoryCode AS WorkCenterCategoryCode,
  user_var.CapacityInternalID AS CapacityInternalID,
  iop.Plant AS Plant,
  I_MaintOrderOperPlanningValues.OperationPlannedWork AS OperationPlannedWork,
  I_MaintOrderOperPlanningValues.OperationPlannedWorkUnit AS OperationPlannedWorkUnit,
  I_MaintOrderOperPlanningValues.ForecastedWorkQty - I_MaintOrderOperPlanningValues.ConfirmationTotalQuantity AS RemainingWorkQuantity,
  iorder.LatestAcceptableCompletionDate AS LatestAcceptableCompletionDate,
  iop.OperationPersonResponsible AS OperationPersonResponsible,
  iop.MaintOperationExecStageCode AS MaintOperationExecStageCode,
  iop.MaintOrdOpProcessSubPhaseCode AS MaintOrdOpProcessSubPhaseCode,
  iorder.ServiceDocument AS ServiceDocument,
  iorder.ServiceDocumentItem AS ServiceDocumentItem
FROM I_MaintOrderOperAndSubOper AS iop
INNER JOIN I_MaintenanceOrder AS iorder ON /* join condition not captured in parsed metadata */
INNER JOIN I_MaintOrderOperPlanningValues ON /* join condition not captured in parsed metadata */
INNER JOIN I_RSHAssignedWorkCenters AS user_var ON /* join condition not captured in parsed metadata */
INNER JOIN I_OperationControlProfile AS operation_controlprofile ON /* join condition not captured in parsed metadata */
INNER JOIN I_RSHOperationStatusObject AS incl_status ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_RSHOperationStatusObject AS excl_status ON /* join condition not captured in parsed metadata */
;

Learn More