I_ProcOrderOperationCapacity

DDL: I_PROCORDEROPERATIONCAPACITY Type: view_entity COMPOSITE Package: VDM_PP_PI
52 Fields 1 Data Sources 6 Associations

Individual Capacity of Process Order Operation

I_ProcOrderOperationCapacity (Composite)

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

ProcessOrderOperationCapacity · Manufacturing

I_ProcOrderOperationCapacity is a Composite CDS View that provides data about "Individual Capacity of Process Order Operation" in SAP S/4HANA. It reads from 1 data source (I_MfgOrderOperationBasic) and exposes 52 fields with key fields CapacityRequirement, CapacityRequirementItem. It has 6 associations to related views. Part of development package VDM_PP_PI.

SAP Help Documentation

CategoryCDS Views for Process Manufacturing
Purpose
This CDS view retrieves data for the individual capacity requirements of process order operations. This CDS view provides the data to answer the following business questions: What are the capacity requirements for specific process order operations? How are the capacity requirements distributed across different operations? What are the scheduled durations and remaining durations for setup, processing, and teardown operations? What are the earliest and latest start and end dates and times for process order operations? What are the actual start and end dates and times for completed operations? What is the status of the capacity requirements for process order operations? To help you decide which CDS view to use for your purposes, SAP has introduced the annotation ObjectModel.supportedCapabilities that indicates the most appropriate use cases for each CDS view. To find out what use cases are best supported by this CDS view, access the entry of the CDS view in the View Browser app and find the values for this annotation under the Annotation tab. For more information, see Supported Capabilities for CDS Views .

Prerequisites
Authorizations Users who want to use this CDS view must have a role with the following restriction types set to read access: AUTYP (Order Category) AUFART_WERKS (Order Type/Plant) You can use the Display Restriction Types app to find out in which business catalogs these restriction types are included.

Structure
Important Fields Important fields in this view include the following: Field Name Description CapacityRequirement Capacity Requirement CapacityRequirementItem Capacity Requirement Item CapacityRqmtItemCapacity Capacity Requirement Item Capacity ProcessOrder Process Order ProcessOrderType Order Type Plant Plant ProcessOrderOperation Operation or Phase OperationIsPhase Indicator: Phase WorkCenterInternalID Object ID CapacityRqmtConfirmation Capacity Confirmed CapacityInternalID Capacity ID CapacityRequirementDistrKey Distribution Key CapacityRequirementUnit Capacity Unit ScheduledCapReqOpSegProcgDurn Scheduled Processing RemainingCapReqOpSegProcgDurn Remaining Processing

Data Extraction
Data Extraction Type This CDS view is enabled for data extraction in full mode.

View on SAP Help Portal →

SAP API Hub

CategoryComposite
StateC1
Line of BusinessManufacturing
Application ComponentPP-VDM-2CL
CapabilitiesData Source for Data Extraction,Data Source for Defining CDS Entities,Data Source in SQL Select
Extensible (Key User)No
Extensible (Developer)No
Release State (Key User)Released
Release State (Developer)Released
PackageManufacturing for SAP S/4HANA Cloud Public Edition
Description <p>This CDS view retrieves data for the individual capacity requirements of process order operations.</p> <p>This CDS view provides the data to answer the following business questions:</p> <ul> <li><p>What are the capacity requirements for specific process order operations?</p></li> <li><p>How are the capacity requirements distributed across different operations?</p></li> <li><p>What are the scheduled durations and remaining durations for setup, processing, and teardown operations?</p></li> <li><p>What are the earliest and latest start and end dates and times for process order operations?</p></li> <li><p>What are the actual start and end dates and times for completed operations?</p></li> <li><p>What is the status of the capacity requirements for process order operations?</p></li> </ul> <p>To help you decide which CDS view to use for your purposes, SAP has introduced the annotation ObjectModel.supportedCapabilities that indicates the most appropriate use cases for each CDS view. To find out what use cases are best supported by this CDS view, access the entry of the CDS view in the View Browser app and find the values for this annotation under the Annotation tab. For more information, see Supported Capabilities for CDS Views.</p>

Documentation

Data Sources (1)

SourceAliasJoin Type
I_MfgOrderOperationBasic MfgOrderOperation from

Associations (6)

CardinalityTargetAliasCondition
[1..1] I_ManufacturingOrder _ProcessOrder $projection.ProcessOrder = _ProcessOrder.ManufacturingOrder
[1..1] I_OrderInternalID _OrderInternalID $projection.OrderInternalID = _OrderInternalID.OrderInternalID
[1..1] I_ManufacturingOrderOperation _ProcessOrderOperation $projection.OrderInternalID = _ProcessOrderOperation.MfgOrderInternalID and $projection.OrderOperationInternalID = _ProcessOrderOperation.OrderOperationInternalID
[1..1] I_MfgOrderType _ProcessOrderType $projection.ProcessOrderType = _ProcessOrderType.ManufacturingOrderType
[1..1] I_Plant _Plant $projection.Plant = _Plant.Plant
[0..1] I_WorkCenter _WorkCenter _WorkCenter.WorkCenterTypeCode = 'A ' and $projection.WorkCenterInternalID = _WorkCenter.WorkCenterInternalID

Annotations (13)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
AccessControl.personalData.blocking #NOT_REQUIRED view
Analytics.dataExtraction.enabled true view
Analytics.technicalName IPROCORDOPCAP view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.modelingPattern #NONE view
ObjectModel.sapObjectNodeType.name ProcessOrderOperationCapacity view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
VDM.lifecycle.contract.type #PUBLIC_LOCAL_API view
VDM.viewType #COMPOSITE view
EndUserText.label Individual Capacity of Process Order Operation view

Fields (52)

KeyFieldSource TableSource FieldDescription
KEY CapacityRequirement CapReq CapacityRequirement ID of the Capacity Requirements Record
KEY CapacityRequirementItem CapReq CapacityRequirementItem Capacity Requirement Item
CapacityRqmtItemCapacity Individual Capacity of a Capacity Requirement Item
ProcessOrder Process Order
OrderInternalID I_MfgOrderOperationBasic OrderInternalBillOfOperations Order Internal Bill of Operations
OrderOperationInternalID I_MfgOrderOperationBasic OrderIntBillOfOperationsItem Internal Identifier of an Operation or Activity
ManufacturingOrderCategory I_MfgOrderOperationBasic ManufacturingOrderCategory Manufacturing Order Category
ProcessOrderType I_MfgOrderOperationBasic ManufacturingOrderType Manufacturing Order Type
Plant I_MfgOrderOperationBasic ProductionPlant Prod plnt
ProcessOrderOperation I_MfgOrderOperationBasic ManufacturingOrderOperation_2 Operation or Phase Number
OperationIsPhase I_MfgOrderOperationBasic MfgOrderOperationIsPhase Indicator: Phase
SuperiorOperationIntIDOfPhase I_MfgOrderOperationBasic SuperiorOperationIntIDOfPhase General counter for order
WorkCenterInternalID I_MfgOrderOperationBasic WorkCenterInternalID Work Center Internal ID
WorkCenterTypeCode I_MfgOrderOperationBasic WorkCenterTypeCode_2 Work Center Type
CapacityRqmtConfirmation CapReq CapacityRqmtConfirmation Capacity Requirement Availability Confirmation Code
CapacityInternalID CapReq CapacityInternalID Capacity ID
CapacityRequirementDistrKey CapReq CapacityRequirementDistrKey Distribution of Capacity Requirements (Planned/Prodn Order)
SuperiorOperationInternalID CapReq SuperiorOperationInternalID Internal ID of the Superior Operation
CapacityRequirementUnit CapReq CapacityRequirementUnit Unit of Measure for Capacity Requirements
ScheduledCapReqOpSegProcgDurn CapReq ScheduledCapReqOpSegProcgDurn Scheduled Capacity Requirements for Processing
RemainingCapReqOpSegProcgDurn CapReq RemainingCapReqOpSegProcgDurn Remaining Capacity Requirements for Processing
OperationEarliestStartDate CapReq OperationEarliestStartDate Earliest Start Date
OperationEarliestStartTime CapReq OperationEarliestStartTime Earliest Start Time
OperationEarliestEndDate CapReq OperationEarliestEndDate Earliest End Date
OperationEarliestEndTime CapReq OperationEarliestEndTime Earliest End Time
OperationLatestStartDate CapReq OperationLatestStartDate Latest Start Date
OperationLatestStartTime CapReq OperationLatestStartTime Latest Start Time
OperationLatestEndDate CapReq OperationLatestEndDate Latest End Date
OperationLatestEndTime CapReq OperationLatestEndTime Latest End Time
ActualStartDate CapReq ActualStartDate Actual Start Date
ActualStartTime CapReq ActualStartTime Actual Start Time
ActualEndDate CapReq ActualEndDate Actual End Date
ActualEndTime CapReq ActualEndTime Actual End Time
ErlstSchedldProcStrtDte CapReq ErlstSchedldProcStrtDte Earliest Scheduled Processing Start Date
ErlstSchedldProcStrtTime CapReq ErlstSchedldProcStrtTime Earliest Scheduled Processing Start Time
ErlstSchedldTrdwnStrtDte CapReq ErlstSchedldTrdwnStrtDte Earliest Scheduled Teardown Start Date
ErlstSchedldTrdwnStrtTime CapReq ErlstSchedldTrdwnStrtTime Earliest Scheduled Teardown Start Time
LtstSchedldProcStrtDte CapReq LtstSchedldProcStrtDte Latest Scheduled Processing Start Date
LtstSchedldProcStrtTime CapReq LtstSchedldProcStrtTime Latest Scheduled Processing Start Time
LtstSchedldTrdwnStrtDte CapReq LtstSchedldTrdwnStrtDte Latest Scheduled Teardown Start Date
LtstSchedldTrdwnStrtTime CapReq LtstSchedldTrdwnStrtTime Latest Scheduled Teardown Start Time
_ProcessOrder _ProcessOrder
_OrderInternalID _OrderInternalID
_ProcessOrderType _ProcessOrderType
_ProcessOrderOperation _ProcessOrderOperation
_Plant _Plant
_WorkCenter _WorkCenter
_CapacityRequirement CapReq _CapacityRequirement
_CapacityRequirementItem CapReq _CapacityRequirementItem
_CapacityRequirementConf CapReq _CapacityRequirementConf
_Capacity CapReq _Capacity
_UnitOfMeasure CapReq _UnitOfMeasure

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_ProcOrderOperationCapacity.
-- 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_ProcOrderOperationCapacity AS
SELECT
  CapReq.CapacityRequirement AS CapacityRequirement,
  CapReq.CapacityRequirementItem AS CapacityRequirementItem,
  cast(MfgOrderOperation.ManufacturingOrder as co_bid preserving type) AS ProcessOrder,
  MfgOrderOperation.OrderInternalBillOfOperations AS OrderInternalID,
  MfgOrderOperation.OrderIntBillOfOperationsItem AS OrderOperationInternalID,
  MfgOrderOperation.ManufacturingOrderCategory AS ManufacturingOrderCategory,
  MfgOrderOperation.ManufacturingOrderType AS ProcessOrderType,
  MfgOrderOperation.ProductionPlant AS Plant,
  MfgOrderOperation.ManufacturingOrderOperation_2 AS ProcessOrderOperation,
  MfgOrderOperation.MfgOrderOperationIsPhase AS OperationIsPhase,
  MfgOrderOperation.SuperiorOperationIntIDOfPhase AS SuperiorOperationIntIDOfPhase,
  MfgOrderOperation.WorkCenterInternalID AS WorkCenterInternalID,
  MfgOrderOperation.WorkCenterTypeCode_2 AS WorkCenterTypeCode,
  CapReq.CapacityRqmtConfirmation AS CapacityRqmtConfirmation,
  CapReq.CapacityInternalID AS CapacityInternalID,
  CapReq.CapacityRequirementDistrKey AS CapacityRequirementDistrKey,
  CapReq.SuperiorOperationInternalID AS SuperiorOperationInternalID,
  CapReq.CapacityRequirementUnit AS CapacityRequirementUnit,
  CapReq.ScheduledCapReqOpSegProcgDurn AS ScheduledCapReqOpSegProcgDurn,
  CapReq.RemainingCapReqOpSegProcgDurn AS RemainingCapReqOpSegProcgDurn,
  CapReq.OperationEarliestStartDate AS OperationEarliestStartDate,
  CapReq.OperationEarliestStartTime AS OperationEarliestStartTime,
  CapReq.OperationEarliestEndDate AS OperationEarliestEndDate,
  CapReq.OperationEarliestEndTime AS OperationEarliestEndTime,
  CapReq.OperationLatestStartDate AS OperationLatestStartDate,
  CapReq.OperationLatestStartTime AS OperationLatestStartTime,
  CapReq.OperationLatestEndDate AS OperationLatestEndDate,
  CapReq.OperationLatestEndTime AS OperationLatestEndTime,
  CapReq.ActualStartDate AS ActualStartDate,
  CapReq.ActualStartTime AS ActualStartTime,
  CapReq.ActualEndDate AS ActualEndDate,
  CapReq.ActualEndTime AS ActualEndTime,
  CapReq.ErlstSchedldProcStrtDte AS ErlstSchedldProcStrtDte,
  CapReq.ErlstSchedldProcStrtTime AS ErlstSchedldProcStrtTime,
  CapReq.ErlstSchedldTrdwnStrtDte AS ErlstSchedldTrdwnStrtDte,
  CapReq.ErlstSchedldTrdwnStrtTime AS ErlstSchedldTrdwnStrtTime,
  CapReq.LtstSchedldProcStrtDte AS LtstSchedldProcStrtDte,
  CapReq.LtstSchedldProcStrtTime AS LtstSchedldProcStrtTime,
  CapReq.LtstSchedldTrdwnStrtDte AS LtstSchedldTrdwnStrtDte,
  CapReq.LtstSchedldTrdwnStrtTime AS LtstSchedldTrdwnStrtTime,
  CapReq._CapacityRequirement AS _CapacityRequirement,
  CapReq._CapacityRequirementItem AS _CapacityRequirementItem,
  CapReq._CapacityRequirementConf AS _CapacityRequirementConf,
  CapReq._Capacity AS _Capacity,
  CapReq._UnitOfMeasure AS _UnitOfMeasure
FROM I_MfgOrderOperationBasic AS MfgOrderOperation
LEFT OUTER JOIN I_ManufacturingOrder AS _ProcessOrder ON ProcessOrder = _ProcessOrder.ManufacturingOrder  -- association [1..1]
LEFT OUTER JOIN I_OrderInternalID AS _OrderInternalID ON OrderInternalID = _OrderInternalID.OrderInternalID  -- association [1..1]
LEFT OUTER JOIN I_ManufacturingOrderOperation AS _ProcessOrderOperation ON OrderInternalID = _ProcessOrderOperation.MfgOrderInternalID AND OrderOperationInternalID = _ProcessOrderOperation.OrderOperationInternalID  -- association [1..1]
LEFT OUTER JOIN I_MfgOrderType AS _ProcessOrderType ON ProcessOrderType = _ProcessOrderType.ManufacturingOrderType  -- association [1..1]
LEFT OUTER JOIN I_Plant AS _Plant ON Plant = _Plant.Plant  -- association [1..1]
LEFT OUTER JOIN I_WorkCenter AS _WorkCenter ON _WorkCenter.WorkCenterTypeCode = 'A ' AND WorkCenterInternalID = _WorkCenter.WorkCenterInternalID  -- association [0..1]
;

Learn More