P_RSHWCCapIntDetailsForPeriod

DDL: P_RSHWCCAPINTDETAILSFORPERIOD SQL: PRSHWCINDETPER Type: view CONSUMPTION Package: RSH_CDS_WC_CAPACITY
25 Fields 1 Data Sources

The view refines the intervals with additional details

P_RSHWCCapIntDetailsForPeriod is a Consumption CDS View that provides data about "The view refines the intervals with additional details" in SAP S/4HANA. It reads from 1 data source (P_RSHWCCapHeadAndIntForPeriod) and exposes 25 fields with key fields CapacityInternalID, ValidityEndDate. Part of development package RSH_CDS_WC_CAPACITY.

Data Sources (1)

SourceAliasJoin Type
P_RSHWCCapHeadAndIntForPeriod P_RSHWCCapHeadAndIntForPeriod from

Parameters (2)

NameTypeDefault
P_StartDate datum
P_EndDate datum

Annotations (7)

NameValueLevelField
AbapCatalog.sqlViewName PRSHWCINDETPER view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
VDM.private true view
VDM.viewType #CONSUMPTION view
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label The view refines the intervals with additional details view

Fields (25)

KeyFieldSource TableSource FieldDescription
KEY CapacityInternalID header_w_end CapacityInternalID Capacity ID
KEY ValidityEndDate header_w_end ValidityEndDate ValidTo
ValidityEndDateendasValidityBeginDate
HeaderValidityBeginDate header_w_end HeaderValidityBeginDate
HeaderValidityEndDate header_w_end HeaderValidityEndDate to
IntervalValidityEndDate header_w_end IntervalValidityEndDate ValidTo
WorkCenterInternalID header_w_end WorkCenterInternalID Work Center
CapacityStartTime header_w_end CapacityStartTime
CapacityEndTime header_w_end CapacityEndTime
CapacityNumberOfCapacities header_w_end CapacityNumberOfCapacities
CapacityPlanUtilizationPercent header_w_end CapacityPlanUtilizationPercent
CapacityBreakDuration header_w_end CapacityBreakDuration
TotOperatingDurationInSeconds header_w_end TotOperatingDurationInSeconds Engine Capacity
OperatingDurationInSeconds header_w_end OperatingDurationInSeconds
WorkCenter header_w_end WorkCenter Work Center
WorkCenterCategoryCode header_w_end WorkCenterCategoryCode
WorkCenterTypeCode header_w_end WorkCenterTypeCode Object Type
Plant header_w_end Plant Valuation Area
FactoryCalendar header_w_end FactoryCalendar Factory Calendar
ShiftGroup header_w_end ShiftGroup Shift Grouping
CapacityActiveVersion header_w_end CapacityActiveVersion
AvailableCapacityIntervalDurn header_w_end AvailableCapacityIntervalDurn
WorkDayRule header_w_end WorkDayRule Recurrence Weekdays
StdAvailableCapacityIsValid header_w_end StdAvailableCapacityIsValid
AvailableCapacityType header_w_end AvailableCapacityType

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

CREATE VIEW P_RSHWCCapIntDetailsForPeriod AS
SELECT
  header_w_end.CapacityInternalID AS CapacityInternalID,
  header_w_end.ValidityEndDate AS ValidityEndDate,
  case when header_w_begin.CapacityInternalID is null then cast('00000000' as dats) else max(header_w_begin.ValidityEndDate) end as ValidityBeginDate AS ValidityEndDateendasValidityBeginDate,
  header_w_end.HeaderValidityBeginDate AS HeaderValidityBeginDate,
  header_w_end.HeaderValidityEndDate AS HeaderValidityEndDate,
  header_w_end.IntervalValidityEndDate AS IntervalValidityEndDate,
  header_w_end.WorkCenterInternalID AS WorkCenterInternalID,
  header_w_end.CapacityStartTime AS CapacityStartTime,
  header_w_end.CapacityEndTime AS CapacityEndTime,
  header_w_end.CapacityNumberOfCapacities AS CapacityNumberOfCapacities,
  header_w_end.CapacityPlanUtilizationPercent AS CapacityPlanUtilizationPercent,
  header_w_end.CapacityBreakDuration AS CapacityBreakDuration,
  header_w_end.TotOperatingDurationInSeconds AS TotOperatingDurationInSeconds,
  header_w_end.OperatingDurationInSeconds AS OperatingDurationInSeconds,
  header_w_end.WorkCenter AS WorkCenter,
  header_w_end.WorkCenterCategoryCode AS WorkCenterCategoryCode,
  header_w_end.WorkCenterTypeCode AS WorkCenterTypeCode,
  header_w_end.Plant AS Plant,
  header_w_end.FactoryCalendar AS FactoryCalendar,
  header_w_end.ShiftGroup AS ShiftGroup,
  header_w_end.CapacityActiveVersion AS CapacityActiveVersion,
  header_w_end.AvailableCapacityIntervalDurn AS AvailableCapacityIntervalDurn,
  header_w_end.WorkDayRule AS WorkDayRule,
  header_w_end.StdAvailableCapacityIsValid AS StdAvailableCapacityIsValid,
  header_w_end.AvailableCapacityType AS AvailableCapacityType
FROM P_RSHWCCapHeadAndIntForPeriod
;

Learn More