P_WrkCtrMntrSchedValidShift

DDL: P_WRKCTRMNTRSCHEDVALIDSHIFT Type: view_entity CONSUMPTION Package: ODATA_PP_CAP_WRKCTR_MNTR
29 Fields 6 Data Sources 1 Associations

Work Center Valid Shifts

P_WrkCtrMntrSchedValidShift is a Consumption CDS View that provides data about "Work Center Valid Shifts" in SAP S/4HANA. It reads from 6 data sources and exposes 29 fields with key fields WorkCenterInternalID, WorkCenterTypeCode, CapacityCategoryAllocation, CapacityInternalID, CapacityActiveVersion. It has 1 association to related views. Part of development package ODATA_PP_CAP_WRKCTR_MNTR.

Data Sources (6)

SourceAliasJoin Type
P_CapacityDefinition CapacityPerShift inner
P_CapacityDefinition CapacityPerShift inner
P_WrkCtrMntrWorkdayTblFunc P_WrkCtrMntrWorkdayTblFunc inner
P_WrkCtrMntrWorkdayTblFunc P_WrkCtrMntrWorkdayTblFunc inner
I_WorkCenterCapacity WorkCenterCapacity from
I_WorkCenterCapacity WorkCenterCapacity union_all

Associations (1)

CardinalityTargetAliasCondition
[1..1] I_WorkCenter _WorkCenter $projection.WorkCenterTypeCode = _WorkCenter.WorkCenterTypeCode and $projection.WorkCenterInternalID = _WorkCenter.WorkCenterInternalID

Annotations (8)

NameValueLevelField
Metadata.ignorePropagatedAnnotations true view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Work Center Valid Shifts view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.serviceQuality #D view
VDM.viewType #CONSUMPTION view
VDM.private true view

Fields (29)

KeyFieldSource TableSource FieldDescription
KEY WorkCenterInternalID I_WorkCenterCapacity WorkCenterInternalID Work Center
KEY WorkCenterTypeCode I_WorkCenterCapacity WorkCenterTypeCode Object Type
KEY CapacityCategoryAllocation I_WorkCenterCapacity CapacityCategoryAllocation
KEY CapacityInternalID I_WorkCenterCapacity CapacityInternalID Capacity ID
KEY CapacityActiveVersion P_CapacityDefinition CapacityActiveVersion
KEY ValidityEndDate P_CapacityDefinition ValidityEndDate ValidTo
KEY WeekDay
KEY AvailableCapacityShift P_CapacityDefinition AvailableCapacityShift Capacity Shift
KEY CalendarDate WorkDays CalendarDate Calendar Date
WorkCenter I_WorkCenterCapacity WorkCenter Work Center
Plant I_WorkCenterCapacity Plant Valuation Area
WorkCenterCategoryCode I_WorkCenterCapacity WorkCenterCategoryCode
ShiftStartTime P_CapacityDefinition ShiftStartTime
ShiftEndTime P_CapacityDefinition ShiftEndTime
WorkCenterInternalID Work Center
KEY WorkCenterTypeCode I_WorkCenterCapacity WorkCenterTypeCode Object Type
KEY CapacityCategoryAllocation I_WorkCenterCapacity CapacityCategoryAllocation
KEY CapacityInternalID I_WorkCenterCapacity CapacityInternalID Capacity ID
KEY CapacityActiveVersion
KEY ValidityEndDate P_CapacityDefinition ValidityEndDate ValidTo
KEY WeekDay
KEY AvailableCapacityShift P_CapacityDefinition AvailableCapacityShift Capacity Shift
KEY CalendarDate WorkDays CalendarDate Calendar Date
WorkCenter I_WorkCenterCapacity WorkCenter Work Center
Plant I_WorkCenterCapacity Plant Valuation Area
WorkCenterCategoryCode I_WorkCenterCapacity WorkCenterCategoryCode
ShiftStartTime P_CapacityDefinition ShiftStartTime
ShiftEndTime P_CapacityDefinition ShiftEndTime
PlantTimeZone

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_WrkCtrMntrSchedValidShift.
-- 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.

CREATE VIEW P_WrkCtrMntrSchedValidShift AS
SELECT
  WorkCenterCapacity.WorkCenterInternalID AS WorkCenterInternalID,
  WorkCenterCapacity.WorkCenterTypeCode AS WorkCenterTypeCode,
  WorkCenterCapacity.CapacityCategoryAllocation AS CapacityCategoryAllocation,
  WorkCenterCapacity.CapacityInternalID AS CapacityInternalID,
  CapacityPerShift.CapacityActiveVersion AS CapacityActiveVersion,
  CapacityPerShift.ValidityEndDate AS ValidityEndDate,
  cast( WorkDays.Weekday as char1) AS WeekDay,
  CapacityPerShift.AvailableCapacityShift AS AvailableCapacityShift,
  WorkDays.CalendarDate AS CalendarDate,
  WorkCenterCapacity.WorkCenter AS WorkCenter,
  WorkCenterCapacity.Plant AS Plant,
  WorkCenterCapacity.WorkCenterCategoryCode AS WorkCenterCategoryCode,
  CapacityPerShift.ShiftStartTime AS ShiftStartTime,
  CapacityPerShift.ShiftEndTime AS ShiftEndTime,
  _WorkCenter._Plant._StandardOrganizationAddress.AddressTimeZone AS PlantTimeZone
FROM I_WorkCenterCapacity AS WorkCenterCapacity
INNER JOIN P_CapacityDefinition AS CapacityPerShift ON /* join condition not captured in parsed metadata */
INNER JOIN P_WrkCtrMntrWorkdayTblFunc ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_WorkCenter AS _WorkCenter ON WorkCenterTypeCode = _WorkCenter.WorkCenterTypeCode AND WorkCenterInternalID = _WorkCenter.WorkCenterInternalID  -- association [1..1]
-- UNION ALL with additional select branch(es): I_WorkCenterCapacity
;

Learn More