P_WrkCtrAvailableCapShift

DDL: P_WRKCTRAVAILABLECAPSHIFT Type: view_entity COMPOSITE Package: ODATA_PP_WORKCENTER_API
21 Fields 1 Data Sources 2 Associations

Work Center Available Capacity Shift

P_WrkCtrAvailableCapShift is a Composite CDS View that provides data about "Work Center Available Capacity Shift" in SAP S/4HANA. It reads from 1 data source (I_AvailableCapacityShift) and exposes 21 fields with key fields CapacityInternalID, AvailableCapacityType, ValidityEndDate, WeekDay, AvailableCapacityShift. It has 2 associations to related views. Part of development package ODATA_PP_WORKCENTER_API.

Data Sources (1)

SourceAliasJoin Type
I_AvailableCapacityShift I_AvailableCapacityShift from

Associations (2)

CardinalityTargetAliasCondition
[1..1] P_WorkCenterCapacityCalc _Capacity $projection.CapacityInternalID = _Capacity.CapacityInternalID
[1..1] I_WorkCenterCapacityInterval_2 _Interval $projection.CapacityInternalID = _Interval.CapacityInternalID and $projection.AvailableCapacityType = _Interval.CapacityActiveVersion and $projection.ValidityEndDate = _Interval.IntervalEndDate

Annotations (3)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
VDM.private true view
VDM.viewType #COMPOSITE view

Fields (21)

KeyFieldSource TableSource FieldDescription
KEY CapacityInternalID CapacityInternalID Capacity ID
KEY AvailableCapacityType AvailableCapacityType Version
KEY ValidityEndDate ValidityEndDate ValidTo
KEY WeekDay WeekDay Weekdays
KEY AvailableCapacityShift AvailableCapacityShift Capacity Shift
WorkDayRule
ShiftDefinition ShiftDefinition Shift Definition
CapacityNumberOfCapacities CapacityNumberOfCapacities Standard Pct.
CapacityPlanUtilizationPercent CapacityPlanUtilizationPercent Utilization
OperatingDurationInSeconds Operating Durn
BreakDurationInSeconds BreakDurationInSeconds Break Length
TotOperatingDurationInSeconds Max. capacity
IntervalEndDate _Interval IntervalEndDate
IntervalStartDate _Interval IntervalStartDate
ShiftGroup _Capacity ShiftGroup Shift Grouping
CapacityEndDate _Capacity ValidityEndDate ValidTo
CapacityStartDate _Capacity ValidityStartDate Validity Start Date
CapacityStartTimeID CapacityStartTimeID Start Time
CapacityEndTimeID CapacityEndTimeID End Time
_Capacity _Capacity
_Interval _Interval

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_WrkCtrAvailableCapShift.
-- 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_WrkCtrAvailableCapShift AS
SELECT
  CapacityInternalID,
  AvailableCapacityType,
  ValidityEndDate,
  WeekDay,
  AvailableCapacityShift,
  cast(coalesce(_Interval.WorkDayRule,'')as workdayrule preserving type ) AS WorkDayRule,
  ShiftDefinition,
  CapacityNumberOfCapacities,
  CapacityPlanUtilizationPercent,
  cast(OperatingDurationInSeconds as abap.fltp) AS OperatingDurationInSeconds,
  BreakDurationInSeconds,
  cast(TotOperatingDurationInSeconds as abap.fltp) AS TotOperatingDurationInSeconds,
  _Interval.IntervalEndDate AS IntervalEndDate,
  _Interval.IntervalStartDate AS IntervalStartDate,
  _Capacity.ShiftGroup AS ShiftGroup,
  _Capacity.ValidityEndDate AS CapacityEndDate,
  _Capacity.ValidityStartDate AS CapacityStartDate,
  CapacityStartTimeID,
  CapacityEndTimeID
FROM I_AvailableCapacityShift
LEFT OUTER JOIN P_WorkCenterCapacityCalc AS _Capacity ON CapacityInternalID = _Capacity.CapacityInternalID  -- association [1..1]
LEFT OUTER JOIN I_WorkCenterCapacityInterval_2 AS _Interval ON CapacityInternalID = _Interval.CapacityInternalID AND AvailableCapacityType = _Interval.CapacityActiveVersion AND ValidityEndDate = _Interval.IntervalEndDate  -- association [1..1]
;

Learn More