What is C_RSHWorkCenterCapacityChange in SAP S/4HANA?

C_RSHWorkCenterCapacityChange is a consumption CDS view in SAP S/4HANA. Consumption view for work center capacity change It contains 36 fields.

Which tables does C_RSHWorkCenterCapacityChange read from?

C_RSHWorkCenterCapacityChange reads data from: P_RSHWorkCenterCapacityChange.

What VDM layer is C_RSHWorkCenterCapacityChange?

C_RSHWorkCenterCapacityChange is classified as a Consumption view optimized for specific business scenarios and reporting.

C_RSHWorkCenterCapacityChange

DDL: C_RSHWORKCENTERCAPACITYCHANGE SQL: CRSHWCCAPCHG Type: view CONSUMPTION

36 Fields 1 Data Sources

Consumption view for work center capacity change

C_RSHWorkCenterCapacityChange is a Consumption CDS View that provides data about "Consumption view for work center capacity change" in SAP S/4HANA. It reads from 1 data source (P_RSHWorkCenterCapacityChange) and exposes 36 fields with key fields WorkCenterInternalID, WorkCenterTypeCode, CapacityStartTime, CapacityEndTime, WorkCenter.

Data Sources (1)

Source	Alias	Join Type
P_RSHWorkCenterCapacityChange	ShiftsPerDay	from

Parameters (2)

Name	Type	Default
P_StartDate	datum
P_EndDate	datum

Annotations (13)

Name	Value	Level
AbapCatalog.sqlViewName	CRSHWCCAPCHG	view
AbapCatalog.compiler.compareFilter	true	view
AccessControl.authorizationCheck	#CHECK	view
EndUserText.label	Consumption view for work center capacity change	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
ObjectModel.updateEnabled	true	view
ObjectModel.createEnabled	true	view
ObjectModel.deleteEnabled	true	view
AbapCatalog.preserveKey	true	view

Fields (36)

Key	Field	Source Table	Source Field	Description
KEY	WorkCenterInternalID	P_RSHWorkCenterCapacityChange	WorkCenterInternalID	Work Center
KEY	WorkCenterTypeCode	P_RSHWorkCenterCapacityChange	WorkCenterTypeCode	Object Type
KEY	CapacityStartTime	P_RSHWorkCenterCapacityChange	CapacityStartTime
KEY	CapacityEndTime	P_RSHWorkCenterCapacityChange	CapacityEndTime
KEY	WorkCenter	P_RSHWorkCenterCapacityChange	WorkCenter	Work Center
KEY	Plant	P_RSHWorkCenterCapacityChange	Plant	Valuation Area
KEY	ShiftDefinition	P_RSHWorkCenterCapacityChange	ShiftDefinition
	CapacityActiveVersion	P_RSHWorkCenterCapacityChange	CapacityActiveVersion
	CapacityInternalID	P_RSHWorkCenterCapacityChange	CapacityInternalID	Capacity ID
	CapacityCategoryAllocation		CapacityCategoryAllocation
	ShiftStartTime	P_RSHWorkCenterCapacityChange	ShiftStartTime
	ShiftEndTime	P_RSHWorkCenterCapacityChange	ShiftEndTime
	WorkCenterCategoryCode	P_RSHWorkCenterCapacityChange	WorkCenterCategoryCode
	ShiftDefinitionName	P_RSHWorkCenterCapacityChange	ShiftDefinitionName
	int2asWrkCtrCapDay1NmbrOfCapacities
	dec242endasWrkCtrCapDay1OperatingHours
	WrkCtrCapDay1NmbrOfCapModified
	int2asWrkCtrCapDay2NmbrOfCapacities
	dec242endasWrkCtrCapDay2OperatingHours
	WrkCtrCapDay2NmbrOfCapModified
	int2asWrkCtrCapDay3NmbrOfCapacities
	dec242endasWrkCtrCapDay3OperatingHours
	WrkCtrCapDay3NmbrOfCapModified
	int2asWrkCtrCapDay4NmbrOfCapacities
	dec242endasWrkCtrCapDay4OperatingHours
	WrkCtrCapDay4NmbrOfCapModified
	int2asWrkCtrCapDay5NmbrOfCapacities
	dec242endasWrkCtrCapDay5OperatingHours
	WrkCtrCapDay5NmbrOfCapModified
	int2asWrkCtrCapDay6NmbrOfCapacities
	dec242endasWrkCtrCapDay6OperatingHours
	WrkCtrCapDay6NmbrOfCapModified
	int2asWrkCtrCapDay7NmbrOfCapacities
	dec242endasWrkCtrCapDay7OperatingHours
	WrkCtrCapDay7NmbrOfCapModified
	WorkCenterCapacityUnit

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_RSHWorkCenterCapacityChange.
-- 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: CRSHWCCAPCHG
-- Parameters: P_StartDate : datum, P_EndDate : datum

CREATE VIEW C_RSHWorkCenterCapacityChange AS
SELECT
  ShiftsPerDay.WorkCenterInternalID AS WorkCenterInternalID,
  ShiftsPerDay.WorkCenterTypeCode AS WorkCenterTypeCode,
  ShiftsPerDay.CapacityStartTime AS CapacityStartTime,
  ShiftsPerDay.CapacityEndTime AS CapacityEndTime,
  ShiftsPerDay.WorkCenter AS WorkCenter,
  ShiftsPerDay.Plant AS Plant,
  ShiftsPerDay.ShiftDefinition AS ShiftDefinition,
  ShiftsPerDay.CapacityActiveVersion AS CapacityActiveVersion,
  ShiftsPerDay.CapacityInternalID AS CapacityInternalID,
  CapacityCategoryAllocation,
  ShiftsPerDay.ShiftStartTime AS ShiftStartTime,
  ShiftsPerDay.ShiftEndTime AS ShiftEndTime,
  ShiftsPerDay.WorkCenterCategoryCode AS WorkCenterCategoryCode,
  ShiftsPerDay.ShiftDefinitionName AS ShiftDefinitionName,
  cast ( max( case when WeekDay = '1' then ShiftsPerDay.CapacityNumberOfCapacities end ) as abap.int2 ) as WrkCtrCapDay1NmbrOfCapacities AS int2asWrkCtrCapDay1NmbrOfCapacities,
  max( case when WeekDay = '1' then cast( unit_conversion( QUANTITY => ShiftsPerDay.OperatingDurationInSeconds, SOURCE_UNIT => cast( 'S' as abap.unit(3) ), TARGET_UNIT => cast( 'H' as abap.unit(3) ), ERROR_HANDLING => 'SET_TO_NULL' ) as abap.dec(24,2) ) end ) as WrkCtrCapDay1OperatingHours AS dec242endasWrkCtrCapDay1OperatingHours,
  cast( '' as abap.char(1) ) AS WrkCtrCapDay1NmbrOfCapModified,
  cast ( max( case when WeekDay = '2' then CapacityNumberOfCapacities end ) as abap.int2 ) as WrkCtrCapDay2NmbrOfCapacities AS int2asWrkCtrCapDay2NmbrOfCapacities,
  max( case when WeekDay = '2' then cast( unit_conversion( QUANTITY => ShiftsPerDay.OperatingDurationInSeconds, SOURCE_UNIT => cast( 'S' as abap.unit(3) ), TARGET_UNIT => cast( 'H' as abap.unit(3) ), ERROR_HANDLING => 'SET_TO_NULL' ) as abap.dec(24,2) ) end ) as WrkCtrCapDay2OperatingHours AS dec242endasWrkCtrCapDay2OperatingHours,
  cast( '' as abap.char(1) ) AS WrkCtrCapDay2NmbrOfCapModified,
  cast ( max( case when WeekDay = '3' then ShiftsPerDay.CapacityNumberOfCapacities end ) as abap.int2 ) as WrkCtrCapDay3NmbrOfCapacities AS int2asWrkCtrCapDay3NmbrOfCapacities,
  max( case when WeekDay = '3' then cast( unit_conversion( QUANTITY => ShiftsPerDay.OperatingDurationInSeconds, SOURCE_UNIT => cast( 'S' as abap.unit(3) ), TARGET_UNIT => cast( 'H' as abap.unit(3) ), ERROR_HANDLING => 'SET_TO_NULL' ) as abap.dec(24,2) ) end ) as WrkCtrCapDay3OperatingHours AS dec242endasWrkCtrCapDay3OperatingHours,
  cast( '' as abap.char(1) ) AS WrkCtrCapDay3NmbrOfCapModified,
  cast ( max( case when WeekDay = '4' then ShiftsPerDay.CapacityNumberOfCapacities end ) as abap.int2 ) as WrkCtrCapDay4NmbrOfCapacities AS int2asWrkCtrCapDay4NmbrOfCapacities,
  max( case when WeekDay = '4' then cast( unit_conversion( QUANTITY => ShiftsPerDay.OperatingDurationInSeconds, SOURCE_UNIT => cast( 'S' as abap.unit(3) ), TARGET_UNIT => cast( 'H' as abap.unit(3) ), ERROR_HANDLING => 'SET_TO_NULL' ) as abap.dec(24,2) ) end ) as WrkCtrCapDay4OperatingHours AS dec242endasWrkCtrCapDay4OperatingHours,
  cast( '' as abap.char(1) ) AS WrkCtrCapDay4NmbrOfCapModified,
  cast ( max( case when WeekDay = '5' then ShiftsPerDay.CapacityNumberOfCapacities end ) as abap.int2 ) as WrkCtrCapDay5NmbrOfCapacities AS int2asWrkCtrCapDay5NmbrOfCapacities,
  max( case when WeekDay = '5' then cast( unit_conversion( QUANTITY => ShiftsPerDay.OperatingDurationInSeconds, SOURCE_UNIT => cast( 'S' as abap.unit(3) ), TARGET_UNIT => cast( 'H' as abap.unit(3) ), ERROR_HANDLING => 'SET_TO_NULL' ) as abap.dec(24,2) ) end ) as WrkCtrCapDay5OperatingHours AS dec242endasWrkCtrCapDay5OperatingHours,
  cast( '' as abap.char(1) ) AS WrkCtrCapDay5NmbrOfCapModified,
  cast ( max( case when WeekDay = '6' then ShiftsPerDay.CapacityNumberOfCapacities end ) as abap.int2 ) as WrkCtrCapDay6NmbrOfCapacities AS int2asWrkCtrCapDay6NmbrOfCapacities,
  max( case when WeekDay = '6' then cast( unit_conversion( QUANTITY => ShiftsPerDay.OperatingDurationInSeconds, SOURCE_UNIT => cast( 'S' as abap.unit(3) ), TARGET_UNIT => cast( 'H' as abap.unit(3) ), ERROR_HANDLING => 'SET_TO_NULL' ) as abap.dec(24,2) ) end ) as WrkCtrCapDay6OperatingHours AS dec242endasWrkCtrCapDay6OperatingHours,
  cast( '' as abap.char(1) ) AS WrkCtrCapDay6NmbrOfCapModified,
  cast ( max( case when WeekDay = '7' then ShiftsPerDay.CapacityNumberOfCapacities end ) as abap.int2 ) as WrkCtrCapDay7NmbrOfCapacities AS int2asWrkCtrCapDay7NmbrOfCapacities,
  max( case when WeekDay = '7' then cast( unit_conversion( QUANTITY => ShiftsPerDay.OperatingDurationInSeconds, SOURCE_UNIT => cast( 'S' as abap.unit(3) ), TARGET_UNIT => cast( 'H' as abap.unit(3) ), ERROR_HANDLING => 'SET_TO_NULL' ) as abap.dec(24,2) ) end ) as WrkCtrCapDay7OperatingHours AS dec242endasWrkCtrCapDay7OperatingHours,
  cast( '' as abap.char(1) ) AS WrkCtrCapDay7NmbrOfCapModified,
  cast (' ' as mseh3 ) AS WorkCenterCapacityUnit
FROM P_RSHWorkCenterCapacityChange AS ShiftsPerDay
;

Depth:

C_RSHWorkCenterCapacityChange view

P_RSHWorkCenterCapacityChange view