P_RSHSmltdWrkCtrUtilznPerDay

DDL: P_RSHSMLTDWRKCTRUTILZNPERDAY SQL: PRSHSMLTWCUTILPD Type: view CONSUMPTION Package: RSH_CDS_MAINT_SCHED_SIM
22 Fields 2 Data Sources

Utilization per day

P_RSHSmltdWrkCtrUtilznPerDay is a Consumption CDS View that provides data about "Utilization per day" in SAP S/4HANA. It reads from 2 data sources (P_RSHSmltdOpConsumption, I_RSHMaintSchedSmltdWrkCtr) and exposes 22 fields with key fields MaintSchedSimlnUUID, CalendarDate, CapacityStartTime, CalendarDate, CapacityStartTime. Part of development package RSH_CDS_MAINT_SCHED_SIM.

Data Sources (2)

SourceAliasJoin Type
P_RSHSmltdOpConsumption P_RSHSmltdOpConsumption from
I_RSHMaintSchedSmltdWrkCtr SimulatedWorkCenters inner

Parameters (2)

NameTypeDefault
P_StartDate datum
P_EndDate datum

Annotations (5)

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

Fields (22)

KeyFieldSource TableSource FieldDescription
KEY MaintSchedSimlnUUID MaintSchedSimlnUUID UUID
KEY CalendarDate CalendarDate Calendar Date
KEY CapacityStartTime
WorkCenterInternalID WorkCenterInternalID Work Center
WorkCenterTypeCode WorkCenterTypeCode Object Type
WorkCenter WorkCenter Work Center
CapacityInternalID CapacityInternalID Capacity ID
Plant Plant Valuation Area
WorkCenterCategoryCode WorkCenterCategoryCode
UsedCapacity
P_StartDate
MaintSchedSimlnUUIDasMaintSchedSimlnUUID
KEY CalendarDate CalendarDate Calendar Date
KEY CapacityStartTime CapacityStartTime
WorkCenterInternalID WorkCenterCapacity WorkCenterInternalID Work Center
WorkCenterTypeCode Object Type
WorkCenter WorkCenterCapacity WorkCenter Work Center
CapacityInternalID WorkCenterCapacity CapacityInternalID Capacity ID
Plant WorkCenterCapacity Plant Valuation Area
WorkCenterCategoryCode WorkCenterCapacity WorkCenterCategoryCode
UsedCapacity
WorkCenterCapacity TotOperatingDurationInSeconds

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_RSHSmltdWrkCtrUtilznPerDay.
-- 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: PRSHSMLTWCUTILPD
-- Parameters: P_StartDate : datum, P_EndDate : datum

CREATE VIEW P_RSHSmltdWrkCtrUtilznPerDay AS
SELECT
  MaintSchedSimlnUUID,
  CalendarDate,
  cast( 0 as kapbegzt ) AS CapacityStartTime,
  WorkCenterInternalID,
  WorkCenterTypeCode,
  WorkCenter,
  CapacityInternalID,
  Plant,
  WorkCenterCategoryCode,
  sum ( UsedCapacity ) AS UsedCapacity,
  cast ( 0 as abap.fltp ) as WorkCenterCapacity AS P_StartDate,
  TotOperatingDurationInSeconds AS WorkCenterCapacity
FROM P_RSHSmltdOpConsumption
INNER JOIN I_RSHMaintSchedSmltdWrkCtr AS SimulatedWorkCenters ON /* join condition not captured in parsed metadata */
;

Learn More