P_WrkCtrMntrSchedInterval

DDL: P_WRKCTRMNTRSCHEDINTERVAL SQL: PWRKCTRMNTRINT Type: view CONSUMPTION
8 Fields 3 Data Sources

Work Center Intervals

P_WrkCtrMntrSchedInterval is a Consumption CDS View that provides data about "Work Center Intervals" in SAP S/4HANA. It reads from 3 data sources (I_WorkCenterCapAlloc, I_Capacity, P_WrkCtrAvailableCapInterval) and exposes 8 fields with key fields CapacityInternalID, AvailableCapacityType, ValidityEndDate.

Data Sources (3)

SourceAliasJoin Type
I_WorkCenterCapAlloc crca from
I_Capacity kako left_outer
P_WrkCtrAvailableCapInterval kazy left_outer

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName PWRKCTRMNTRINT view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Work Center Intervals view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.serviceQuality #D view
VDM.viewType #CONSUMPTION view
VDM.private true view
ClientHandling.algorithm #SESSION_VARIABLE view

Fields (8)

KeyFieldSource TableSource FieldDescription
KEY CapacityInternalID I_WorkCenterCapAlloc CapacityInternalID Capacity ID
KEY AvailableCapacityType P_WrkCtrAvailableCapInterval AvailableCapacityType
KEY ValidityEndDate
ValidityBeginDate
WorkCenterInternalID I_WorkCenterCapAlloc WorkCenterInternalID Work Center
WorkCenterTypeCode I_WorkCenterCapAlloc WorkCenterTypeCode Object Type
HorizonStartDate
HorizonEndDate

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_WrkCtrMntrSchedInterval.
-- 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: PWRKCTRMNTRINT

CREATE VIEW P_WrkCtrMntrSchedInterval AS
SELECT
  crca.CapacityInternalID AS CapacityInternalID,
  kazy.AvailableCapacityType AS AvailableCapacityType,
  coalesce ( kazy.ValidityEndDate, crca.ValidityEndDate ) AS ValidityEndDate,
  coalesce ( kazy.ValidityBeginDate, crca.ValidityStartDate ) AS ValidityBeginDate,
  crca.WorkCenterInternalID AS WorkCenterInternalID,
  crca.WorkCenterTypeCode AS WorkCenterTypeCode,
  cast (DATS_ADD_DAYS(cast ($session.system_date as sydatum),-91,'FAIL') as sydatum) AS HorizonStartDate,
  cast (DATS_ADD_DAYS(cast ($session.system_date as sydatum),+91,'FAIL') as sydatum) AS HorizonEndDate
FROM I_WorkCenterCapAlloc AS crca
LEFT OUTER JOIN I_Capacity AS kako ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN P_WrkCtrAvailableCapInterval AS kazy ON /* join condition not captured in parsed metadata */
;

Learn More