P_RSHTaskListOperations

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_RSHTaskListOperations.
-- 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: PRSHTASKLST

CREATE VIEW P_RSHTaskListOperations AS
SELECT
  plas.BillOfOperationsType AS BillOfOperationsType,
  plas.BillOfOperationsGroup AS BillOfOperationsGroup,
  plas.BillOfOperationsVariant AS BillOfOperationsVariant,
  plas.BillOfOperationsSequence AS BillOfOperationsSequence,
  plas.BOOOperationInternalID AS BOOOperationInternalID,
  plpo.SuperiorOperationInternalID AS SuperiorOperationInternalID,
  plpo.WorkCenterInternalID AS WorkCenterInternalID,
  plpo.WorkCenterTypeCode AS WorkCenterTypeCode,
  I_RSHAssignedWorkCenters.CapacityInternalID AS CapacityInternalId,
  I_RSHAssignedWorkCenters.WorkCenter AS WorkCenter,
  I_RSHAssignedWorkCenters.WorkCenterCategoryCode AS WorkCenterCategoryCode,
  plpo.Plant AS Plant,
  Operation,
  case when ( plas.BOOOperationInternalID = plpo.BOOOperationInternalID ) then ' ' else plpo.Operation end as SubOperation AS OperationendasSubOperation,
  plpo.OperationControlProfile AS ControlKey,
  plpo.OpPlannedWorkQuantity AS OpPlannedWorkQuantity,
  plpo.OpWorkQuantityUnit AS OpWorkQuantityUnit,
  cast( unit_conversion( QUANTITY =>plpo.OpPlannedWorkQuantity , SOURCE_UNIT =>plpo.OpWorkQuantityUnit, TARGET_UNIT => cast( 'S' as abap.unit(3) ), ERROR_HANDLING => 'SET_TO_NULL' ) as abap.fltp ) as TotalWork AS fltpasTotalWork,
  'S' AS TotalWorkUnit,
  plpo.MaintOperationExecStageCode AS MaintOperationExecStageCode
FROM I_BillOfOperationsOpBasic AS plpo
INNER JOIN I_BOOSqncOperationAssgmtChgSt AS plas ON /* join condition not captured in parsed metadata */
INNER JOIN I_RSHAssignedWorkCenters ON /* join condition not captured in parsed metadata */
INNER JOIN I_OperationControlProfile AS OperationControlProfile ON /* join condition not captured in parsed metadata */
;