P_RshWCCapacityIntervalDetails

DDL: P_RSHWCCAPACITYINTERVALDETAILS SQL: PRSHWCINDET Type: view CONSUMPTION
25 Fields 1 Data Sources

The view refines the intervals with additional details

P_RshWCCapacityIntervalDetails 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_RSHWCCapaHeaderAndInterval) and exposes 25 fields with key fields CapacityInternalID, ValidityEndDate.

Data Sources (1)

SourceAliasJoin Type
P_RSHWCCapaHeaderAndInterval header_w_end from

Annotations (8)

NameValueLevelField
AbapCatalog.sqlViewName PRSHWCINDET view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK 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 P_RSHWCCapaHeaderAndInterval CapacityInternalID Capacity ID
KEY ValidityEndDate P_RSHWCCapaHeaderAndInterval ValidityEndDate ValidTo
ValidityEndDateendasValidityBeginDate
HeaderValidityBeginDate P_RSHWCCapaHeaderAndInterval HeaderValidityBeginDate
HeaderValidityEndDate P_RSHWCCapaHeaderAndInterval HeaderValidityEndDate to
IntervalValidityEndDate P_RSHWCCapaHeaderAndInterval IntervalValidityEndDate ValidTo
WorkCenterInternalID P_RSHWCCapaHeaderAndInterval WorkCenterInternalID Work Center
CapacityStartTime P_RSHWCCapaHeaderAndInterval CapacityStartTime
CapacityEndTime P_RSHWCCapaHeaderAndInterval CapacityEndTime
CapacityNumberOfCapacities P_RSHWCCapaHeaderAndInterval CapacityNumberOfCapacities
CapacityPlanUtilizationPercent P_RSHWCCapaHeaderAndInterval CapacityPlanUtilizationPercent
CapacityBreakDuration P_RSHWCCapaHeaderAndInterval CapacityBreakDuration
TotOperatingDurationInSeconds P_RSHWCCapaHeaderAndInterval TotOperatingDurationInSeconds Engine Capacity
OperatingDurationInSeconds P_RSHWCCapaHeaderAndInterval OperatingDurationInSeconds
WorkCenter P_RSHWCCapaHeaderAndInterval WorkCenter Work Center
WorkCenterCategoryCode P_RSHWCCapaHeaderAndInterval WorkCenterCategoryCode
WorkCenterTypeCode P_RSHWCCapaHeaderAndInterval WorkCenterTypeCode Object Type
Plant P_RSHWCCapaHeaderAndInterval Plant Valuation Area
FactoryCalendar P_RSHWCCapaHeaderAndInterval FactoryCalendar Factory Calendar
ShiftGroup P_RSHWCCapaHeaderAndInterval ShiftGroup Shift Grouping
CapacityActiveVersion P_RSHWCCapaHeaderAndInterval CapacityActiveVersion
AvailableCapacityIntervalDurn P_RSHWCCapaHeaderAndInterval AvailableCapacityIntervalDurn
WorkDayRule P_RSHWCCapaHeaderAndInterval WorkDayRule Recurrence Weekdays
StdAvailableCapacityIsValid P_RSHWCCapaHeaderAndInterval StdAvailableCapacityIsValid
AvailableCapacityType P_RSHWCCapaHeaderAndInterval 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_RshWCCapacityIntervalDetails.
-- 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: PRSHWCINDET

CREATE VIEW P_RshWCCapacityIntervalDetails 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_RSHWCCapaHeaderAndInterval AS header_w_end
;

Learn More