P_RSHWorkCenterCapacityChange

DDL: P_RSHWORKCENTERCAPACITYCHANGE SQL: PRSHWCCAPCHG Type: view CONSUMPTION
28 Fields 5 Data Sources

Work Center Capacity Change

P_RSHWorkCenterCapacityChange is a Consumption CDS View that provides data about "Work Center Capacity Change" in SAP S/4HANA. It reads from 5 data sources (P_RSHWCCapacityDefinition, I_CalendarDate, I_Capacity, I_WorkCenterCapacity, P_RSHCALWORKDAYS) and exposes 28 fields with key fields CapacityInternalID, CalendarDate, WorkCenterInternalID, WorkCenter, CapacityActiveVersion.

Data Sources (5)

SourceAliasJoin Type
P_RSHWCCapacityDefinition CapaDef from
I_CalendarDate date_series inner
I_Capacity I_Capacity inner
I_WorkCenterCapacity I_WorkCenterCapacity left_outer
P_RSHCALWORKDAYS P_RSHCALWORKDAYS inner

Annotations (8)

NameValueLevelField
AbapCatalog.sqlViewName PRSHWCCAPCHG view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
VDM.private true view
VDM.viewType #CONSUMPTION view
EndUserText.label Work Center Capacity Change view
AbapCatalog.preserveKey true view
ClientHandling.algorithm #SESSION_VARIABLE view

Fields (28)

KeyFieldSource TableSource FieldDescription
KEY CapacityInternalID P_RSHWCCapacityDefinition CapacityInternalID Capacity ID
KEY CalendarDate I_CalendarDate CalendarDate Calendar Date
KEY WorkCenterInternalID P_RSHWCCapacityDefinition WorkCenterInternalID Work Center
KEY WorkCenter P_RSHWCCapacityDefinition WorkCenter Work Center
KEY CapacityActiveVersion P_RSHWCCapacityDefinition CapacityActiveVersion RA Version
KEY CapacityStartTime P_RSHWCCapacityDefinition CapacityStartTime Start Time
WorkCenterCategoryCode P_RSHWCCapacityDefinition WorkCenterCategoryCode
WorkCenterTypeCode P_RSHWCCapacityDefinition WorkCenterTypeCode Object Type
Plant P_RSHWCCapacityDefinition Plant Valuation Area
WeekDay I_CalendarDate WeekDay Weekdays
CalendarWeek I_CalendarDate CalendarWeek Calendar Week
AvailableCapacityShift AvailableCapacityShift Capacity Shift
AvailableCapacityIntervalDurn AvailableCapacityIntervalDurn
WorkDayRule WorkDayRule Recurrence Weekdays
CapacityEndTime P_RSHWCCapacityDefinition CapacityEndTime End Time
ShiftDefinition P_RSHWCCapacityDefinition ShiftDefinition
ShiftDefinitionName P_RSHWCCapacityDefinition ShiftDefinitionName
CapacityNumberOfCapacities P_RSHWCCapacityDefinition CapacityNumberOfCapacities Number
CapacityPlanUtilizationPercent P_RSHWCCapacityDefinition CapacityPlanUtilizationPercent Utilization
FactoryCalendar P_RSHWCCapacityDefinition FactoryCalendar Factory Calendar
YearWeek YearWeek Year and Calendar Week
timsasShiftStartTime
timsasShiftEndTime
CapacityBreakDuration P_RSHWCCapacityDefinition CapacityBreakDuration Break Length
CapacityCategoryAllocation I_WorkCenterCapacity CapacityCategoryAllocation
ReferencedCapacityInternalID I_Capacity ReferencedCapacityInternalID
CapacityIsPooled I_Capacity CapacityIsPooled Pooled Capacity
WorkDayRule0thenelseXendasIsEditable

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_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: PRSHWCCAPCHG

CREATE VIEW P_RSHWorkCenterCapacityChange AS
SELECT
  CapaDef.CapacityInternalID AS CapacityInternalID,
  date_series.CalendarDate AS CalendarDate,
  CapaDef.WorkCenterInternalID AS WorkCenterInternalID,
  CapaDef.WorkCenter AS WorkCenter,
  CapaDef.CapacityActiveVersion AS CapacityActiveVersion,
  CapaDef.CapacityStartTime AS CapacityStartTime,
  CapaDef.WorkCenterCategoryCode AS WorkCenterCategoryCode,
  CapaDef.WorkCenterTypeCode AS WorkCenterTypeCode,
  CapaDef.Plant AS Plant,
  date_series.WeekDay AS WeekDay,
  date_series.CalendarWeek AS CalendarWeek,
  AvailableCapacityShift,
  AvailableCapacityIntervalDurn,
  WorkDayRule,
  CapaDef.CapacityEndTime AS CapacityEndTime,
  CapaDef.ShiftDefinition AS ShiftDefinition,
  CapaDef.ShiftDefinitionName AS ShiftDefinitionName,
  CapaDef.CapacityNumberOfCapacities AS CapacityNumberOfCapacities,
  CapaDef.CapacityPlanUtilizationPercent AS CapacityPlanUtilizationPercent,
  CapaDef.FactoryCalendar AS FactoryCalendar,
  YearWeek,
  cast ( substring( cast ( tstmp_add_seconds( cast ('10010102000000' as abap.dec(15,0)), cast( CapaDef.CapacityStartTime as abap.dec(15,0) ), 'FAIL') as abap.sstring(50)), 9,6) as abap.tims) as ShiftStartTime AS timsasShiftStartTime,
  cast ( substring( cast ( tstmp_add_seconds( cast ('10010102000000' as abap.dec(15,0)), cast( CapaDef.CapacityEndTime as abap.dec(15,0) ), 'FAIL') as abap.sstring(50)), 9,6) as abap.tims) as ShiftEndTime AS timsasShiftEndTime,
  CapaDef.CapacityBreakDuration AS CapacityBreakDuration,
  I_WorkCenterCapacity.CapacityCategoryAllocation AS CapacityCategoryAllocation,
  I_Capacity.ReferencedCapacityInternalID AS ReferencedCapacityInternalID,
  I_Capacity.CapacityIsPooled AS CapacityIsPooled,
  case when CapaDef.CapacityActiveVersion = '00' or ReferencedCapacityInternalID is not initial or CapacityIsPooled is not initial or I_WorkCenterCapacity.CapacityCategoryAllocation is null or ( WorkDays.WorkDays = 0 and CapaDef.WorkDayRule = '' ) or CapaDef.WorkDayRule = '0' then '' else 'X' end as IsEditable AS WorkDayRule0thenelseXendasIsEditable
FROM P_RSHWCCapacityDefinition AS CapaDef
INNER JOIN I_CalendarDate AS date_series ON /* join condition not captured in parsed metadata */
INNER JOIN P_RSHCALWORKDAYS ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_WorkCenterCapacity ON /* join condition not captured in parsed metadata */
INNER JOIN I_Capacity ON /* join condition not captured in parsed metadata */
;

Learn More