P_RSHSmltdOpInSeconds

DDL: P_RSHSMLTDOPINSECONDS SQL: PRSHSIMOPINSEC Type: view CONSUMPTION
24 Fields 2 Data Sources

P_RSHSmltdOpInSeconds is a Consumption CDS View in SAP S/4HANA. It reads from 2 data sources (I_MaintOrderOperAndSubOper, P_RSHMaintSchedSmltdDueStatus) and exposes 24 fields with key fields MaintSchedSimlnUUID, MaintenanceOrder, MaintenanceOrderOperation, MaintenanceOrderSubOperation.

Data Sources (2)

SourceAliasJoin Type
I_MaintOrderOperAndSubOper OperationDetails inner
P_RSHMaintSchedSmltdDueStatus OperationStatus inner

Annotations (5)

NameValueLevelField
AbapCatalog.sqlViewName PRSHSIMOPINSEC view
AccessControl.authorizationCheck #NOT_REQUIRED view
VDM.private true view
VDM.viewType #CONSUMPTION view
ClientHandling.algorithm #SESSION_VARIABLE view

Fields (24)

KeyFieldSource TableSource FieldDescription
KEY MaintSchedSimlnUUID SimulatedOperations MaintSchedSimlnUUID UUID
KEY MaintenanceOrder I_MaintOrderOperAndSubOper MaintenanceOrder Order
KEY MaintenanceOrderOperation I_MaintOrderOperAndSubOper MaintenanceOrderOperation Suboperation
KEY MaintenanceOrderSubOperation I_MaintOrderOperAndSubOper MaintenanceOrderSubOperation Suboperation
MaintPriority MaintPriority Priority
MaintPriorityType MaintPriorityType PriorityType
MaintPriorityColorCode MaintPriorityColorCode
OrderType OrderType Order Type
ActivityType SimulatedOperations ActivityType Activity Type
OperationControlKey I_MaintOrderOperAndSubOper OperationControlKey Control Key
ProcessingStatusendasProcessingStatus
MaintOrdOpSimulationStatus SimulatedOperations MaintOrdOpSimulationStatus Technical Status
MaintOrdOpSimulatedStartDate SimulatedOperations MaintOrdOpSimulatedStartDate Simulated Start Date
MaintOrdOpSimulatedEndDate SimulatedOperations MaintOrdOpSimulatedEndDate Simulated End Date
NumberOfCapacities SimulatedOperations NumberOfResources
int4endasSimulatedStartTimeInSeconds
int4endasSimulatedEndTimeInSeconds
int4endasConsumingStartTimeInSeconds
int4endasConsumingEndTimeInSeconds
OperationDurationendasOperationDuration
OperationDurationUnit SimulatedOperations OperationDurationUnit
OperationPlannedWorkUnit SimulatedOperations OperationPlannedWorkUnit
MaintSchedSimulationStartDate _MaintSchedSimulation MaintSchedSimulationStartDate Start Date
MaintSchedSimulationEndDate _MaintSchedSimulation MaintSchedSimulationEndDate End Date

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_RSHSmltdOpInSeconds.
-- 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: PRSHSIMOPINSEC

CREATE VIEW P_RSHSmltdOpInSeconds AS
SELECT
  SimulatedOperations.MaintSchedSimlnUUID AS MaintSchedSimlnUUID,
  OperationDetails.MaintenanceOrder AS MaintenanceOrder,
  OperationDetails.MaintenanceOrderOperation AS MaintenanceOrderOperation,
  OperationDetails.MaintenanceOrderSubOperation AS MaintenanceOrderSubOperation,
  MaintPriority,
  MaintPriorityType,
  MaintPriorityColorCode,
  OrderType,
  SimulatedOperations.ActivityType AS ActivityType,
  OperationDetails.OperationControlKey AS OperationControlKey,
  case OperationStatus.ProcessingStatus when 20 then SimulatedOperations.ProcessingStatus else OperationStatus.ProcessingStatus end as ProcessingStatus AS ProcessingStatusendasProcessingStatus,
  SimulatedOperations.MaintOrdOpSimulationStatus AS MaintOrdOpSimulationStatus,
  SimulatedOperations.MaintOrdOpSimulatedStartDate AS MaintOrdOpSimulatedStartDate,
  SimulatedOperations.MaintOrdOpSimulatedEndDate AS MaintOrdOpSimulatedEndDate,
  SimulatedOperations.NumberOfResources AS NumberOfCapacities,
  case when SimulatedOperations.MaintOrdOpSimulatedStartTime = '240000' and MaintOrdOpSimulatedStartDate < MaintOrdOpSimulatedEndDate then 0 else cast( cast( substring(SimulatedOperations.MaintOrdOpSimulatedStartTime, 1, 2) as abap.numc(2) ) as abap.int4 ) * 3600 + cast( cast( substring(SimulatedOperations.MaintOrdOpSimulatedStartTime, 3, 2) as abap.numc(2) ) as abap.int4 ) * 60 + cast( cast( substring(SimulatedOperations.MaintOrdOpSimulatedStartTime, 5, 2) as abap.numc(2) ) as abap.int4 ) end as SimulatedStartTimeInSeconds AS int4endasSimulatedStartTimeInSeconds,
  case when SimulatedOperations.MaintOrdOpSimulatedEndTime = '240000' or ( SimulatedOperations.MaintOrdOpSimulatedEndTime = '000000' and MaintOrdOpSimulatedStartDate < MaintOrdOpSimulatedEndDate ) then 86400 else cast( cast( substring(SimulatedOperations.MaintOrdOpSimulatedEndTime, 1, 2) as abap.numc(2) ) as abap.int4 ) * 3600 + cast( cast( substring(SimulatedOperations.MaintOrdOpSimulatedEndTime, 3, 2) as abap.numc(2) ) as abap.int4 ) * 60 + cast( cast( substring(SimulatedOperations.MaintOrdOpSimulatedEndTime, 5, 2) as abap.numc(2) ) as abap.int4 ) end as SimulatedEndTimeInSeconds AS int4endasSimulatedEndTimeInSeconds,
  case when SimulatedOperations.MaintOrdOpSimulatedStartTime = '240000' and MaintOrdOpSimulatedStartDate < MaintOrdOpSimulatedEndDate then 0 else cast( cast( substring(SimulatedOperations.MaintOrdOpSimulatedStartTime, 1, 2) as abap.numc(2) ) as abap.int4 ) * 3600 + cast( cast( substring(SimulatedOperations.MaintOrdOpSimulatedStartTime, 3, 2) as abap.numc(2) ) as abap.int4 ) * 60 + cast( cast( substring(SimulatedOperations.MaintOrdOpSimulatedStartTime, 5, 2) as abap.numc(2) ) as abap.int4 ) end as ConsumingStartTimeInSeconds AS int4endasConsumingStartTimeInSeconds,
  case when SimulatedOperations.MaintOrdOpSimulatedEndTime = '240000' or MaintOrdOpSimulatedEndDate = '00000000' or ( SimulatedOperations.MaintOrdOpSimulatedEndTime = '000000' and MaintOrdOpSimulatedStartDate < MaintOrdOpSimulatedEndDate ) then 86400 else cast( cast( substring(SimulatedOperations.MaintOrdOpSimulatedEndTime, 1, 2) as abap.numc(2) ) as abap.int4 ) * 3600 + cast( cast( substring(SimulatedOperations.MaintOrdOpSimulatedEndTime, 3, 2) as abap.numc(2) ) as abap.int4 ) * 60 + cast( cast( substring(SimulatedOperations.MaintOrdOpSimulatedEndTime, 5, 2) as abap.numc(2) ) as abap.int4 ) end as ConsumingEndTimeInSeconds AS int4endasConsumingEndTimeInSeconds,
  case when ( ( SimulatedOperations.OperationDuration = 0 or SimulatedOperations.OperationDuration is null ) and SimulatedOperations.OperationPlannedWork > 0 ) then cast ( SimulatedOperations.OperationPlannedWork as abap.fltp ) / cast ( SimulatedOperations.NumberOfResources as abap.fltp ) else SimulatedOperations.OperationDuration end as OperationDuration AS OperationDurationendasOperationDuration,
  SimulatedOperations.OperationDurationUnit AS OperationDurationUnit,
  SimulatedOperations.OperationPlannedWorkUnit AS OperationPlannedWorkUnit,
  _MaintSchedSimulation.MaintSchedSimulationStartDate AS MaintSchedSimulationStartDate,
  _MaintSchedSimulation.MaintSchedSimulationEndDate AS MaintSchedSimulationEndDate
INNER JOIN I_MaintOrderOperAndSubOper AS OperationDetails ON /* join condition not captured in parsed metadata */
INNER JOIN P_RSHMaintSchedSmltdDueStatus AS OperationStatus ON /* join condition not captured in parsed metadata */
;

Learn More