P_RSHWCCapPerWorkDayForPrd_1

DDL: P_RSHWCCAPPERWORKDAYFORPRD_1 Type: view_entity CONSUMPTION
20 Fields 2 Data Sources

P_RSHWCCapPerWorkDayForPrd_1 is a Consumption CDS View in SAP S/4HANA. It reads from 2 data sources (P_RSHCALWORKDAYS, P_RSHWCCapacityPerDayForPrd_1) and exposes 20 fields with key fields CapacityInternalID, CalendarDate, CapacityStartTime, WeekDay, WorkCenterInternalID.

Data Sources (2)

SourceAliasJoin Type
P_RSHCALWORKDAYS P_RSHCALWORKDAYS inner
P_RSHWCCapacityPerDayForPrd_1 P_RSHWCCapacityPerDayForPrd_1 from

Parameters (2)

NameTypeDefault
P_StartDate datum
P_EndDate datum

Annotations (4)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
Metadata.ignorePropagatedAnnotations true view
VDM.private true view
VDM.viewType #CONSUMPTION view

Fields (20)

KeyFieldSource TableSource FieldDescription
KEY CapacityInternalID CapacityPerDay CapacityInternalID Capacity ID
KEY CalendarDate CapacityPerDay CalendarDate Calendar Date
KEY CapacityStartTime CapacityPerDay CapacityStartTime
KEY WeekDay CapacityPerDay WeekDay Weekdays
KEY WorkCenterInternalID CapacityPerDay WorkCenterInternalID Work Center
WorkCenter CapacityPerDay WorkCenter Work Center
WorkCenterCategoryCode CapacityPerDay WorkCenterCategoryCode
WorkCenterTypeCode CapacityPerDay WorkCenterTypeCode Object Type
Plant CapacityPerDay Plant Valuation Area
AvailableCapacityShift CapacityPerDay AvailableCapacityShift Capacity Shift
NightSplitDate CapacityPerDay NightSplitDate
AvailableCapacityIntervalDurn CapacityPerDay AvailableCapacityIntervalDurn
WorkDayRule CapacityPerDay WorkDayRule Recurrence Weekdays
CapacityBreakDuration CapacityPerDay CapacityBreakDuration
WorkDays WorkDays WorkDays
CapacityEndTime CapacityPerDay CapacityEndTime
CapacityNumberOfCapacities CapacityPerDay CapacityNumberOfCapacities
CapacityPlanUtilizationPercent CapacityPerDay CapacityPlanUtilizationPercent
FactoryCalendar CapacityPerDay FactoryCalendar Factory Calendar
YearWeek CapacityPerDay YearWeek Year and Calendar Week

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

CREATE VIEW P_RSHWCCapPerWorkDayForPrd_1 AS
SELECT
  CapacityPerDay.CapacityInternalID AS CapacityInternalID,
  CapacityPerDay.CalendarDate AS CalendarDate,
  CapacityPerDay.CapacityStartTime AS CapacityStartTime,
  CapacityPerDay.WeekDay AS WeekDay,
  CapacityPerDay.WorkCenterInternalID AS WorkCenterInternalID,
  CapacityPerDay.WorkCenter AS WorkCenter,
  CapacityPerDay.WorkCenterCategoryCode AS WorkCenterCategoryCode,
  CapacityPerDay.WorkCenterTypeCode AS WorkCenterTypeCode,
  CapacityPerDay.Plant AS Plant,
  CapacityPerDay.AvailableCapacityShift AS AvailableCapacityShift,
  CapacityPerDay.NightSplitDate AS NightSplitDate,
  CapacityPerDay.AvailableCapacityIntervalDurn AS AvailableCapacityIntervalDurn,
  CapacityPerDay.WorkDayRule AS WorkDayRule,
  CapacityPerDay.CapacityBreakDuration AS CapacityBreakDuration,
  WorkDays.WorkDays AS WorkDays,
  CapacityPerDay.CapacityEndTime AS CapacityEndTime,
  CapacityPerDay.CapacityNumberOfCapacities AS CapacityNumberOfCapacities,
  CapacityPerDay.CapacityPlanUtilizationPercent AS CapacityPlanUtilizationPercent,
  CapacityPerDay.FactoryCalendar AS FactoryCalendar,
  CapacityPerDay.YearWeek AS YearWeek
FROM P_RSHWCCapacityPerDayForPrd_1
INNER JOIN P_RSHCALWORKDAYS ON /* join condition not captured in parsed metadata */
;

Learn More