What is C_CapEvalPooledCapacityOps in SAP S/4HANA?

C_CapEvalPooledCapacityOps is a consumption CDS view in SAP S/4HANA. Workcenter Pooled Capacity Operations It contains 46 fields.

Which tables does C_CapEvalPooledCapacityOps read from?

C_CapEvalPooledCapacityOps reads data from: I_WorkCenterCapPplineOp.

What VDM layer is C_CapEvalPooledCapacityOps?

C_CapEvalPooledCapacityOps is classified as a Consumption view optimized for specific business scenarios and reporting.

C_CapEvalPooledCapacityOps

DDL: C_CAPEVALPOOLEDCAPACITYOPS SQL: CWCPOOLCAPOP Type: view CONSUMPTION Package: ODATA_PP_CAP_EVAL

46 Fields 1 Data Sources 9 Associations 1 OData Services

Workcenter Pooled Capacity Operations

C_CapEvalPooledCapacityOps is a Consumption CDS View that provides data about "Workcenter Pooled Capacity Operations" in SAP S/4HANA. It reads from 1 data source (I_WorkCenterCapPplineOp) and exposes 46 fields with key fields WorkCenterTypeCode, CapacityCategoryAllocation, CapacityInternalID, CapacityRequirement, Material. It has 9 associations to related views. It is exposed through 1 OData service (ASQL_F3289). Part of development package ODATA_PP_CAP_EVAL.

Data Sources (1)

Source	Alias	Join Type
I_WorkCenterCapPplineOp	WrkCtrCapPplineOp	from

Associations (9)

Cardinality	Target	Alias	Condition
[0..*]	I_WorkCenterText	_WorkCenterText	`$projection.WorkCenterInternalID = _WorkCenterText.WorkCenterInternalID`
[0..*]	I_PlannedOrderTypeText	_PlannedOrderText	`$projection.OrderType = _PlannedOrderText.PlannedOrderType`
[0..*]	I_OrderTypeText	_WorkOrderText	`$projection.OrderType = _WorkOrderText.OrderType`
[0..*]	I_OrderCategoryText	_WorkOrderCategoryText	`$projection.OrderCategory = _WorkOrderCategoryText.OrderCategory`
[0..*]	I_PlannedOrderCategoryText	_PlannedOrderCategoryText	`$projection.OrderCategory = _PlannedOrderCategoryText.PlannedOrderCategory`
[0..*]	I_CapEvalCapRqmtStsText	_OprPlanningText	`$projection.OperationPlanningStatusCode = _OprPlanningText.CapacityRequirementStatusCode`
[0..*]	I_SystemStatusText	_OrderStatusText	`$projection.OrderStatusCode = _OrderStatusText.SystemStatus`
[0..*]	I_CapEvalFirmingStsText	_FirmingStatusText	`$projection.OrderFirmingStatusCode = _FirmingStatusText.OrderFirmingStatusCode`
[1..1]	I_MaterialText	_MatText	`$projection.Material = _MatText.Material`

Annotations (12)

Name	Value	Level
AbapCatalog.sqlViewName	CWCPOOLCAPOP	view
AbapCatalog.compiler.compareFilter	true	view
AccessControl.authorizationCheck	#CHECK	view
AccessControl.personalData.blocking	#NOT_REQUIRED	view
AbapCatalog.preserveKey	true	view
ObjectModel.usageType.serviceQuality	#D	view
ObjectModel.usageType.sizeCategory	#XL	view
ObjectModel.usageType.dataClass	#TRANSACTIONAL	view
VDM.viewType	#CONSUMPTION	view
Metadata.ignorePropagatedAnnotations	true	view
ClientHandling.algorithm	#SESSION_VARIABLE	view
EndUserText.label	Workcenter Pooled Capacity Operations	view

OData Services (1)

Service	Binding	Version	Contract	Release
ASQL_F3289	ASQL_F3289		C2	NOT_RELEASED

Fields (46)

Key	Field	Source Table	Source Field	Description
KEY	WorkCenterTypeCode	I_WorkCenterCapPplineOp	WorkCenterTypeCode	Object Type
KEY	CapacityCategoryAllocation	I_WorkCenterCapPplineOp	CapacityCategoryAllocation
KEY	CapacityInternalID	I_WorkCenterCapPplineOp	CapacityInternalID	Capacity ID
KEY	CapacityRequirement	I_WorkCenterCapPplineOp	CapacityRequirement
KEY	Material	I_WorkCenterCapPplineOp	Material	Product Number
KEY	OrderID	I_WorkCenterCapPplineOp	OrderID	Order ID
KEY	Operation	I_WorkCenterCapPplineOp	Operation	Transaction
KEY	CapacityRequirementItem	I_WorkCenterCapPplineOp	CapacityRequirementItem
	WorkCenterInternalID	I_WorkCenterCapPplineOp	WorkCenterInternalID	Work Center Internal ID
	Plant
	MRPController	I_WorkCenterCapPplineOp	MRPController	MRP Controller
	WorkCenter	I_WorkCenterCapPplineOp	WorkCenter	Work Center
	OrderCategory	I_WorkCenterCapPplineOp	OrderCategory	Order Category
	WorkCenterDesc			WorkCenter Description
	WorkCenterResponsible	I_WorkCenterCapPplineOp	WorkCenterResponsible	Person Responsible
	MaterialName			Material Name
	WorkCenterCategoryCode	I_WorkCenterCapPplineOp	WorkCenterCategoryCode	Work Center Category
	CapacityRequirementOrigin	I_WorkCenterCapPplineOp	CapacityRequirementOrigin	Requirement Origin
	OrderType	I_WorkCenterCapPplineOp	OrderType	Order Type
	BaseUnit
	OrderPlannedTotalQty	I_WorkCenterCapPplineOp	OrderPlannedTotalQty	Order Quantity
	ProductionVersion	I_WorkCenterCapPplineOp	ProductionVersion	Source Of Supply
	OperationPlanningStatusText			Operation Planning Status
	OperationPlanningStatusCode	I_WorkCenterCapPplineOp	OperationPlanningStatusCode	Operation Planning Status Code
	OperationLatestStartDate	I_WorkCenterCapPplineOp	OperationLatestStartDate	Operation Start Date
	OperationLatestStartTime	I_WorkCenterCapPplineOp	OperationLatestStartTime	Operation Start Time
	OperationLatestEndDate	I_WorkCenterCapPplineOp	OperationLatestEndDate	Operation End Date
	OperationLatestEndTime	I_WorkCenterCapPplineOp	OperationLatestEndTime	Operation End Time
	OrderStatusCode	I_WorkCenterCapPplineOp	OrderStatusCode	Order Status Code
	OrderStatusText			Order Status
	OrderStatusShortText			Order Status SHort Code
	OrderFirmingStatusCode	I_WorkCenterCapPplineOp	OrderFirmingStatusCode	Firming Status Code
	OrderFirmingStatusText			Firming Status Text
	OpLtstSchedldExecStrtDte	I_WorkCenterCapPplineOp	OperationLatestStartDate	Scheduled Start Setup Date
	OpLtstSchedldExecStrtTme	I_WorkCenterCapPplineOp	OperationLatestStartTime	Latest Start Setup
	OpLtstSchedldProcgStrtDte	I_WorkCenterCapPplineOp	OpLtstSchedldProcgStrtDte	Scheduled Start Proccessing Date
	OpLtstSchedldProcgStrtTme	I_WorkCenterCapPplineOp	OpLtstSchedldProcgStrtTme	Latest Start Processing
	OpLtstSchedldTrdwnStrtDte	I_WorkCenterCapPplineOp	OpLtstSchedldTrdwnStrtDte	Latest Start Teardown Date
	OpLtstSchedldTrdwnStrtTme	I_WorkCenterCapPplineOp	OpLtstSchedldTrdwnStrtTme	Latest Start Teardown
	OrderInternalID	I_WorkCenterCapPplineOp	OrderInternalID	Order Internal ID
	ScheduledBasicStartDate	I_WorkCenterCapPplineOp	ScheduledBasicStartDate	Order Start Date
	ScheduledBasicStartTime	I_WorkCenterCapPplineOp	ScheduledBasicStartTime	Order Start
	ScheduledBasicEndDate	I_WorkCenterCapPplineOp	ScheduledBasicEndDate	Order End Date
	ScheduledBasicEndTime	I_WorkCenterCapPplineOp	ScheduledBasicEndTime	Order End
	LtstSchedldExecStrtDteTme	I_WorkCenterCapPplineOp	LtstSchedldExecStrtDteTme
	LtstSchedldExecEndDteTme	I_WorkCenterCapPplineOp	LtstSchedldExecEndDteTme

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 C_CapEvalPooledCapacityOps.
-- 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: CWCPOOLCAPOP

CREATE VIEW C_CapEvalPooledCapacityOps AS
SELECT
  WrkCtrCapPplineOp.WorkCenterTypeCode AS WorkCenterTypeCode,
  WrkCtrCapPplineOp.CapacityCategoryAllocation AS CapacityCategoryAllocation,
  WrkCtrCapPplineOp.CapacityInternalID AS CapacityInternalID,
  WrkCtrCapPplineOp.CapacityRequirement AS CapacityRequirement,
  WrkCtrCapPplineOp.Material AS Material,
  WrkCtrCapPplineOp.OrderID AS OrderID,
  WrkCtrCapPplineOp.Operation AS Operation,
  WrkCtrCapPplineOp.CapacityRequirementItem AS CapacityRequirementItem,
  WrkCtrCapPplineOp.WorkCenterInternalID AS WorkCenterInternalID,
  cast(WrkCtrCapPplineOp.Plant as werks_d preserving type ) AS Plant,
  WrkCtrCapPplineOp.MRPController AS MRPController,
  WrkCtrCapPplineOp.WorkCenter AS WorkCenter,
  WrkCtrCapPplineOp.OrderCategory AS OrderCategory,
  _WorkCenterText[1:Language=$session.system_language].WorkCenterText AS WorkCenterDesc,
  WrkCtrCapPplineOp.WorkCenterResponsible AS WorkCenterResponsible,
  _MatText[1:Language=$session.system_language].MaterialName AS MaterialName,
  WrkCtrCapPplineOp.WorkCenterCategoryCode AS WorkCenterCategoryCode,
  WrkCtrCapPplineOp.CapacityRequirementOrigin AS CapacityRequirementOrigin,
  WrkCtrCapPplineOp.OrderType AS OrderType,
  cast(WrkCtrCapPplineOp.BaseUnit as meins) AS BaseUnit,
  WrkCtrCapPplineOp.OrderPlannedTotalQty AS OrderPlannedTotalQty,
  WrkCtrCapPplineOp.ProductionVersion AS ProductionVersion,
  _OprPlanningText[1:Language=$session.system_language].CapacityRequirementStatusText AS OperationPlanningStatusText,
  WrkCtrCapPplineOp.OperationPlanningStatusCode AS OperationPlanningStatusCode,
  WrkCtrCapPplineOp.OperationLatestStartDate AS OperationLatestStartDate,
  WrkCtrCapPplineOp.OperationLatestStartTime AS OperationLatestStartTime,
  WrkCtrCapPplineOp.OperationLatestEndDate AS OperationLatestEndDate,
  WrkCtrCapPplineOp.OperationLatestEndTime AS OperationLatestEndTime,
  WrkCtrCapPplineOp.OrderStatusCode AS OrderStatusCode,
  _OrderStatusText[1:Language=$session.system_language].SystemStatusName AS OrderStatusText,
  _OrderStatusText[1:Language=$session.system_language].SystemStatusShortName AS OrderStatusShortText,
  WrkCtrCapPplineOp.OrderFirmingStatusCode AS OrderFirmingStatusCode,
  _FirmingStatusText[1:Language=$session.system_language].OrderFirmingStatusText AS OrderFirmingStatusText,
  WrkCtrCapPplineOp.OperationLatestStartDate AS OpLtstSchedldExecStrtDte,
  WrkCtrCapPplineOp.OperationLatestStartTime AS OpLtstSchedldExecStrtTme,
  WrkCtrCapPplineOp.OpLtstSchedldProcgStrtDte AS OpLtstSchedldProcgStrtDte,
  WrkCtrCapPplineOp.OpLtstSchedldProcgStrtTme AS OpLtstSchedldProcgStrtTme,
  WrkCtrCapPplineOp.OpLtstSchedldTrdwnStrtDte AS OpLtstSchedldTrdwnStrtDte,
  WrkCtrCapPplineOp.OpLtstSchedldTrdwnStrtTme AS OpLtstSchedldTrdwnStrtTme,
  WrkCtrCapPplineOp.OrderInternalID AS OrderInternalID,
  WrkCtrCapPplineOp.ScheduledBasicStartDate AS ScheduledBasicStartDate,
  WrkCtrCapPplineOp.ScheduledBasicStartTime AS ScheduledBasicStartTime,
  WrkCtrCapPplineOp.ScheduledBasicEndDate AS ScheduledBasicEndDate,
  WrkCtrCapPplineOp.ScheduledBasicEndTime AS ScheduledBasicEndTime,
  WrkCtrCapPplineOp.LtstSchedldExecStrtDteTme AS LtstSchedldExecStrtDteTme,
  WrkCtrCapPplineOp.LtstSchedldExecEndDteTme AS LtstSchedldExecEndDteTme
FROM I_WorkCenterCapPplineOp AS WrkCtrCapPplineOp
LEFT OUTER JOIN I_WorkCenterText AS _WorkCenterText ON WorkCenterInternalID = _WorkCenterText.WorkCenterInternalID  -- association [0..*]
LEFT OUTER JOIN I_PlannedOrderTypeText AS _PlannedOrderText ON OrderType = _PlannedOrderText.PlannedOrderType  -- association [0..*]
LEFT OUTER JOIN I_OrderTypeText AS _WorkOrderText ON OrderType = _WorkOrderText.OrderType  -- association [0..*]
LEFT OUTER JOIN I_OrderCategoryText AS _WorkOrderCategoryText ON OrderCategory = _WorkOrderCategoryText.OrderCategory  -- association [0..*]
LEFT OUTER JOIN I_PlannedOrderCategoryText AS _PlannedOrderCategoryText ON OrderCategory = _PlannedOrderCategoryText.PlannedOrderCategory  -- association [0..*]
LEFT OUTER JOIN I_CapEvalCapRqmtStsText AS _OprPlanningText ON OperationPlanningStatusCode = _OprPlanningText.CapacityRequirementStatusCode  -- association [0..*]
LEFT OUTER JOIN I_SystemStatusText AS _OrderStatusText ON OrderStatusCode = _OrderStatusText.SystemStatus  -- association [0..*]
LEFT OUTER JOIN I_CapEvalFirmingStsText AS _FirmingStatusText ON OrderFirmingStatusCode = _FirmingStatusText.OrderFirmingStatusCode  -- association [0..*]
LEFT OUTER JOIN I_MaterialText AS _MatText ON Material = _MatText.Material  -- association [1..1]
;

Depth:

C_CapEvalPooledCapacityOps view

I_WorkCenterCapPplineOp view