C_RSHWrkCtrUtilizationKPI

DDL: C_RSHWRKCTRUTILIZATIONKPI SQL: CRSHWCUTILKPI Type: view CONSUMPTION
4 Fields 6 Data Sources

Work Center Utilization Overview

C_RSHWrkCtrUtilizationKPI is a Consumption CDS View that provides data about "Work Center Utilization Overview" in SAP S/4HANA. It reads from 6 data sources and exposes 4 fields with key field WorkCenter.

Data Sources (6)

SourceAliasJoin Type
I_CalendarDate FourthWeek inner
I_CalendarDate NextWeek inner
P_RSHWCUtilizationPerWeek P_RSHWCUtilizationPerWeek from
I_CalendarDate ThirdWeek inner
P_RSHThisWeekAndNextWeek ThisCwNextCw inner
I_CalendarDate ThisWeek inner

Parameters (2)

NameTypeDefault
P_StartDate datum
P_EndDate datum

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName CRSHWCUTILKPI view
AbapCatalog.compiler.compareFilter true view
EndUserText.label Work Center Utilization Overview view
AccessControl.authorizationCheck #CHECK view
VDM.viewType #CONSUMPTION view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #XL view

Fields (4)

KeyFieldSource TableSource FieldDescription
KEY WorkCenter Utilization WorkCenter Work Center
WorkCenterCategoryCode Utilization WorkCenterCategoryCode
Plant Utilization Plant Valuation Area
PeriodType

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 C_RSHWrkCtrUtilizationKPI.
-- 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: CRSHWCUTILKPI
-- Parameters: P_StartDate : datum, P_EndDate : datum

CREATE VIEW C_RSHWrkCtrUtilizationKPI AS
SELECT
  Utilization.WorkCenter AS WorkCenter,
  Utilization.WorkCenterCategoryCode AS WorkCenterCategoryCode,
  Utilization.Plant AS Plant,
  'FUTURE' AS PeriodType
FROM P_RSHWCUtilizationPerWeek
INNER JOIN P_RSHThisWeekAndNextWeek AS ThisCwNextCw ON /* join condition not captured in parsed metadata */
INNER JOIN I_CalendarDate AS ThisWeek ON /* join condition not captured in parsed metadata */
INNER JOIN I_CalendarDate AS NextWeek ON /* join condition not captured in parsed metadata */
INNER JOIN I_CalendarDate AS ThirdWeek ON /* join condition not captured in parsed metadata */
INNER JOIN I_CalendarDate AS FourthWeek ON /* join condition not captured in parsed metadata */
;

Learn More