I_CapacityShift

DDL: I_CAPACITYSHIFT Type: view_entity COMPOSITE
23 Fields 2 Data Sources 1 Associations

Ent Resource Capacity Interval Shift

I_CapacityShift (Composite)

Package: Explore, extend and adapt the SAP S/4HANA Cloud Private Edition with built-in and side-by-side extension capabilities.

EntRsceCapacityIntervalShift · Manufacturing

I_CapacityShift is a Composite CDS View (Dimension) that provides data about "Ent Resource Capacity Interval Shift" in SAP S/4HANA. It reads from 2 data sources (I_CapacityBasic, I_WorkCenterCapacityShift_2) and exposes 23 fields with key fields CapacityInternalID, CapacityActiveVersion, IntervalEndDate, WeekDay, AvailableCapacityShift. It has 1 association to related views.

SAP API Hub

StateC1
Line of BusinessManufacturing
Application ComponentPP-VDM-MD
CapabilitiesAnalytical Dimension, Association Target for Defining CDS Entities, Data Source in SQL Select, Data Source for Defining CDS Entities, Data Source for Data Extraction
PackageManufacturing for SAP S/4HANA Cloud Private Edition

Documentation

Data Sources (2)

SourceAliasJoin Type
I_CapacityBasic PooledCapHeader inner
I_WorkCenterCapacityShift_2 Shift from

Associations (1)

CardinalityTargetAliasCondition
[1..1] I_CapacityBasic _EntRsceCapacity $projection.CapacityInternalID = _EntRsceCapacity.CapacityInternalID

Annotations (15)

NameValueLevelField
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #MASTER view
VDM.viewType #COMPOSITE view
AccessControl.authorizationCheck #MANDATORY view
AccessControl.personalData.blocking #NOT_REQUIRED view
EndUserText.label Ent Resource Capacity Interval Shift view
Analytics.dataCategory #DIMENSION view
Analytics.dataExtraction.enabled true view
Analytics.internalName #LOCAL view
Metadata.allowExtensions true view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.modelingPattern #ANALYTICAL_DIMENSION view
ObjectModel.representativeKey AvailableCapacityShift view
ObjectModel.sapObjectNodeType.name EntRsceCapacityIntervalShift view

Fields (23)

KeyFieldSource TableSource FieldDescription
KEY CapacityInternalID I_WorkCenterCapacityShift_2 CapacityInternalID Capacity ID
KEY CapacityActiveVersion I_WorkCenterCapacityShift_2 CapacityActiveVersion Available capacity version
KEY IntervalEndDate I_WorkCenterCapacityShift_2 IntervalEndDate Valid-to date
KEY WeekDay I_WorkCenterCapacityShift_2 WeekDay Weekdays
KEY AvailableCapacityShift Shift Number of an Available Capacity
IntervalStartDate I_WorkCenterCapacityShift_2 IntervalStartDate Valid-From Date
WorkDayRule I_WorkCenterCapacityShift_2 WorkDayRule Recurrence Weekdays
ShiftDefinition I_WorkCenterCapacityShift_2 ShiftDefinition Shift Definition
ShiftStartTime I_WorkCenterCapacityShift_2 ShiftStartTime Start Time
ShiftEndTime I_WorkCenterCapacityShift_2 ShiftEndTime End Time
ShiftDefValidityStartDate I_WorkCenterCapacityShift_2 ShiftDefValidityStartDate Start Date
ShiftDefValidityEndDate I_WorkCenterCapacityShift_2 ShiftDefValidityEndDate End Date
CapacityNumberOfCapacities I_WorkCenterCapacityShift_2 CapacityNumberOfCapacities Number of Individual Capacities
CapacityPlanUtilizationPercent I_WorkCenterCapacityShift_2 CapacityPlanUtilizationPercent Capacity Utilization Ratio in Percent
CapacityBreakDuration I_WorkCenterCapacityShift_2 CapacityBreakDuration Cumulative Break Duration in Seconds (internal)
OperatingDurationInSeconds I_WorkCenterCapacityShift_2 OperatingDurationInSeconds Operating Duration in Seconds
TotOperatingDurationInSeconds I_WorkCenterCapacityShift_2 TotOperatingDurationInSeconds Total Operating Duration In Seconds
CapacityLastChangeDateTime I_WorkCenterCapacityShift_2 CapacityLastChangeDateTime Capacity Last Change Date Time
_Capacity I_WorkCenterCapacityShift_2 _Capacity
_EntRsceCapacity _EntRsceCapacity
_AvailableCapacityType I_WorkCenterCapacityShift_2 _AvailableCapacityType
_EndDate I_WorkCenterCapacityShift_2 _EndDate
_WeekDay I_WorkCenterCapacityShift_2 _WeekDay

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 I_CapacityShift.
-- 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 I_CapacityShift AS
SELECT
  Shift.CapacityInternalID AS CapacityInternalID,
  Shift.CapacityActiveVersion AS CapacityActiveVersion,
  Shift.IntervalEndDate AS IntervalEndDate,
  Shift.WeekDay AS WeekDay,
  cast(coalesce(Shift.AvailableCapacityShift,'0')as schichtnr preserving type ) AS AvailableCapacityShift,
  Shift.IntervalStartDate AS IntervalStartDate,
  Shift.WorkDayRule AS WorkDayRule,
  Shift.ShiftDefinition AS ShiftDefinition,
  Shift.ShiftStartTime AS ShiftStartTime,
  Shift.ShiftEndTime AS ShiftEndTime,
  Shift.ShiftDefValidityStartDate AS ShiftDefValidityStartDate,
  Shift.ShiftDefValidityEndDate AS ShiftDefValidityEndDate,
  Shift.CapacityNumberOfCapacities AS CapacityNumberOfCapacities,
  Shift.CapacityPlanUtilizationPercent AS CapacityPlanUtilizationPercent,
  Shift.CapacityBreakDuration AS CapacityBreakDuration,
  Shift.OperatingDurationInSeconds AS OperatingDurationInSeconds,
  Shift.TotOperatingDurationInSeconds AS TotOperatingDurationInSeconds,
  Shift.CapacityLastChangeDateTime AS CapacityLastChangeDateTime,
  Shift._Capacity AS _Capacity,
  Shift._AvailableCapacityType AS _AvailableCapacityType,
  Shift._EndDate AS _EndDate,
  Shift._WeekDay AS _WeekDay
FROM I_WorkCenterCapacityShift_2 AS Shift
INNER JOIN I_CapacityBasic AS PooledCapHeader ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_CapacityBasic AS _EntRsceCapacity ON CapacityInternalID = _EntRsceCapacity.CapacityInternalID  -- association [1..1]
;

Learn More