What is C_CapEvalPplineOp in SAP S/4HANA?

C_CapEvalPplineOp is a consumption CDS view in SAP S/4HANA. Load all order operations for a capacity It contains 57 fields.

Which tables does C_CapEvalPplineOp read from?

C_CapEvalPplineOp reads data from: I_WorkCenterCapPplineOp.

What VDM layer is C_CapEvalPplineOp?

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

C_CapEvalPplineOp

DDL: C_CAPEVALPPLINEOP SQL: CWCCAPPPLINEOP Type: view CONSUMPTION

57 Fields 1 Data Sources 9 Associations

Load all order operations for a capacity

C_CapEvalPplineOp is a Consumption CDS View that provides data about "Load all order operations for a capacity" in SAP S/4HANA. It reads from 1 data source (I_WorkCenterCapPplineOp) and exposes 57 fields with key fields WorkCenterInternalID, WorkCenterTypeCode, CapacityCategoryAllocation, CapacityInternalID, CapacityRequirement. It has 9 associations to related views.

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 (11)

Name	Value	Level
AbapCatalog.sqlViewName	CWCCAPPPLINEOP	view
AbapCatalog.compiler.compareFilter	true	view
AccessControl.authorizationCheck	#CHECK	view
AccessControl.personalData.blocking	#NOT_REQUIRED	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	Load all order operations for a capacity	view

Fields (57)

Key	Field	Source Table	Source Field	Description
KEY	WorkCenterInternalID	I_WorkCenterCapPplineOp	WorkCenterInternalID	Work Center Internal ID
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	CapacityRequirementItem	I_WorkCenterCapPplineOp	CapacityRequirementItem
KEY	Material	I_WorkCenterCapPplineOp	Material	Product Number
KEY	OrderID
KEY	Operation	I_WorkCenterCapPplineOp	Operation	Transaction
	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
	OperationLatestStartDateTime	I_WorkCenterCapPplineOp	OperationLatestStartDateTime	Operation Start
	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
	OperationLatestEndDateTime	I_WorkCenterCapPplineOp	OperationLatestEndDateTime	Operation End
	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	Scheduled Start Setup Time
	OpLtstSchedldExecStrtDteTme	I_WorkCenterCapPplineOp	OperationLatestStartDateTime	Latest Setup Start
	OpLtstSchedldProcgStrtDte	I_WorkCenterCapPplineOp	OpLtstSchedldProcgStrtDte	Scheduled Start Processing Date
	OpLtstSchedldProcgStrtTme	I_WorkCenterCapPplineOp	OpLtstSchedldProcgStrtTme	Scheduled Start Processing Time
	OpLtstSchedldProcgStrtDteTme	I_WorkCenterCapPplineOp	OpLtstSchedldProcgStrtDteTme	Latest Processing Start
	OpLtstSchedldTrdwnStrtDte	I_WorkCenterCapPplineOp	OpLtstSchedldTrdwnStrtDte	Latest Start Teardown Date
	OpLtstSchedldTrdwnStrtTme	I_WorkCenterCapPplineOp	OpLtstSchedldTrdwnStrtTme	Latest Start Teardown Time
	OpLtstSchedldTrdwnStrtDteTme	I_WorkCenterCapPplineOp	OpLtstSchedldTrdwnStrtDteTme	Latest Teardown Start
	OrderInternalID	I_WorkCenterCapPplineOp	OrderInternalID	Order Internal ID
	ScheduledBasicStartDate	I_WorkCenterCapPplineOp	ScheduledBasicStartDate	Order Start Date
	ScheduledBasicStartTime	I_WorkCenterCapPplineOp	ScheduledBasicStartTime	Order Start Time
	ScheduledBasicStartDateTime	I_WorkCenterCapPplineOp	ScheduledBasicStartDateTime	Order Start
	ScheduledBasicEndDateTime	I_WorkCenterCapPplineOp	ScheduledBasicEndDateTime	Order End
	ScheduledBasicEndDate	I_WorkCenterCapPplineOp	ScheduledBasicEndDate	Order End Date
	ScheduledBasicEndTime	I_WorkCenterCapPplineOp	ScheduledBasicEndTime	Order End Time
	LtstSchedldExecStrtDteTme	I_WorkCenterCapPplineOp	LtstSchedldExecStrtDteTme
	LtstSchedldExecEndDteTme	I_WorkCenterCapPplineOp	LtstSchedldExecEndDteTme
	Sequence	I_WorkCenterCapPplineOp	Sequence	Visit Sequence
	PlantTimeZone	I_WorkCenterCapPplineOp	PlantTimeZone	Time Zone
	SalesOrder	I_WorkCenterCapPplineOp	SalesOrder	SD Document
	SalesOrderItem	I_WorkCenterCapPplineOp	SalesOrderItem	Sales Order Item

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_CapEvalPplineOp.
-- 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: CWCCAPPPLINEOP

CREATE VIEW C_CapEvalPplineOp AS
SELECT
  WrkCtrCapPplineOp.WorkCenterInternalID AS WorkCenterInternalID,
  WrkCtrCapPplineOp.WorkCenterTypeCode AS WorkCenterTypeCode,
  WrkCtrCapPplineOp.CapacityCategoryAllocation AS CapacityCategoryAllocation,
  WrkCtrCapPplineOp.CapacityInternalID AS CapacityInternalID,
  WrkCtrCapPplineOp.CapacityRequirement AS CapacityRequirement,
  WrkCtrCapPplineOp.CapacityRequirementItem AS CapacityRequirementItem,
  WrkCtrCapPplineOp.Material AS Material,
  ltrim(WrkCtrCapPplineOp.OrderID,'0') AS OrderID,
  WrkCtrCapPplineOp.Operation AS Operation,
  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 preserving type ) AS BaseUnit,
  WrkCtrCapPplineOp.OrderPlannedTotalQty AS OrderPlannedTotalQty,
  WrkCtrCapPplineOp.ProductionVersion AS ProductionVersion,
  _OprPlanningText[1:Language=$session.system_language].CapacityRequirementStatusText AS OperationPlanningStatusText,
  WrkCtrCapPplineOp.OperationPlanningStatusCode AS OperationPlanningStatusCode,
  WrkCtrCapPplineOp.OperationLatestStartDateTime AS OperationLatestStartDateTime,
  WrkCtrCapPplineOp.OperationLatestStartDate AS OperationLatestStartDate,
  WrkCtrCapPplineOp.OperationLatestStartTime AS OperationLatestStartTime,
  WrkCtrCapPplineOp.OperationLatestEndDate AS OperationLatestEndDate,
  WrkCtrCapPplineOp.OperationLatestEndTime AS OperationLatestEndTime,
  WrkCtrCapPplineOp.OperationLatestEndDateTime AS OperationLatestEndDateTime,
  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.OperationLatestStartDateTime AS OpLtstSchedldExecStrtDteTme,
  WrkCtrCapPplineOp.OpLtstSchedldProcgStrtDte AS OpLtstSchedldProcgStrtDte,
  WrkCtrCapPplineOp.OpLtstSchedldProcgStrtTme AS OpLtstSchedldProcgStrtTme,
  WrkCtrCapPplineOp.OpLtstSchedldProcgStrtDteTme AS OpLtstSchedldProcgStrtDteTme,
  WrkCtrCapPplineOp.OpLtstSchedldTrdwnStrtDte AS OpLtstSchedldTrdwnStrtDte,
  WrkCtrCapPplineOp.OpLtstSchedldTrdwnStrtTme AS OpLtstSchedldTrdwnStrtTme,
  WrkCtrCapPplineOp.OpLtstSchedldTrdwnStrtDteTme AS OpLtstSchedldTrdwnStrtDteTme,
  WrkCtrCapPplineOp.OrderInternalID AS OrderInternalID,
  WrkCtrCapPplineOp.ScheduledBasicStartDate AS ScheduledBasicStartDate,
  WrkCtrCapPplineOp.ScheduledBasicStartTime AS ScheduledBasicStartTime,
  WrkCtrCapPplineOp.ScheduledBasicStartDateTime AS ScheduledBasicStartDateTime,
  WrkCtrCapPplineOp.ScheduledBasicEndDateTime AS ScheduledBasicEndDateTime,
  WrkCtrCapPplineOp.ScheduledBasicEndDate AS ScheduledBasicEndDate,
  WrkCtrCapPplineOp.ScheduledBasicEndTime AS ScheduledBasicEndTime,
  WrkCtrCapPplineOp.LtstSchedldExecStrtDteTme AS LtstSchedldExecStrtDteTme,
  WrkCtrCapPplineOp.LtstSchedldExecEndDteTme AS LtstSchedldExecEndDteTme,
  WrkCtrCapPplineOp.Sequence AS Sequence,
  WrkCtrCapPplineOp.PlantTimeZone AS PlantTimeZone,
  WrkCtrCapPplineOp.SalesOrder AS SalesOrder,
  WrkCtrCapPplineOp.SalesOrderItem AS SalesOrderItem
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_CapEvalPplineOp view

I_WorkCenterCapPplineOp view