What is A_WorkCenterCapPplineOp in SAP S/4HANA?

A_WorkCenterCapPplineOp is a composite CDS view in SAP S/4HANA. Queued Operations Capacity It contains 41 fields.

What VDM layer is A_WorkCenterCapPplineOp?

A_WorkCenterCapPplineOp is classified as a Composite view that combines data from multiple basic views.

A_WorkCenterCapPplineOp

DDL: A_WORKCENTERCAPPPLINEOP SQL: AWCCAPPPLINEOP Type: view COMPOSITE

41 Fields 9 Associations

Queued Operations Capacity

A_WorkCenterCapPplineOp is a Composite CDS View that provides data about "Queued Operations Capacity" in SAP S/4HANA. It has 9 associations to related views.

Associations (9)

Cardinality	Target	Alias	Condition
[0..*]	A_WorkCenterCapOrderPerBucket	_WorkCenterOrders	`$projection.Plant = _WorkCenterOrders.Plant and $projection.MRPController = _WorkCenterOrders.MRPController and $projection.WorkCenter = _WorkCenterOrders.WorkCenter and $projection.WorkCenterInternalID = _WorkCenterOrders.WorkCenterInternalID and $projection.CapacityInternalID = _WorkCenterOrders.CapacityInternalID and $projection.Material = _WorkCenterOrders.Material`
[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	`WrkCtrCapPplineOp.OrderFirmingStatusCode = _FirmingStatusText.OrderFirmingStatusCode`

Annotations (12)

Name	Value	Level
AbapCatalog.sqlViewName	AWCCAPPPLINEOP	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	#COMPOSITE	view
Metadata.ignorePropagatedAnnotations	true	view
ClientHandling.algorithm	#SESSION_VARIABLE	view
EndUserText.label	Queued Operations Capacity	view
VDM.lifecycle.contract.type	#PUBLIC_REMOTE_API	view

Fields (41)

Key	Field	Source Table	Source Field	Description
KEY	Plant	WrkCtrCapPplineOp	Plant	Valuation Area
KEY	MRPController	WrkCtrCapPplineOp	MRPController	MRP Controller
KEY	WorkCenter	WrkCtrCapPplineOp	WorkCenter	Work Center
KEY	CapacityInternalID	WrkCtrCapPplineOp	CapacityInternalID	Capacity ID
KEY	CapacityRequirement	WrkCtrCapPplineOp	CapacityRequirement
KEY	Material	WrkCtrCapPplineOp	Material	Vehicle Model
KEY	OrderID	WrkCtrCapPplineOp	OrderID	Order ID
KEY	Operation	WrkCtrCapPplineOp	Operation	Transaction
	WorkCenterDesc
	WorkCenterResponsible	WrkCtrCapPplineOp	WorkCenterResponsible
	WorkCenterCategoryCode	WrkCtrCapPplineOp	WorkCenterCategoryCode
	WorkCenterInternalID	WrkCtrCapPplineOp	WorkCenterInternalID	Work Center
	CapacityRequirementOrigin	WrkCtrCapPplineOp	CapacityRequirementOrigin
	CapacityRequirementUnit	WrkCtrCapPplineOp	CapacityRequirementUnit
	OrderType	WrkCtrCapPplineOp	OrderType	Order Type
	OrderCategory	WrkCtrCapPplineOp	OrderCategory	Order Category
	BaseUnit
	OrderPlannedTotalQty	WrkCtrCapPplineOp	OrderPlannedTotalQty
	ProductionVersion	WrkCtrCapPplineOp	ProductionVersion	Version ID
	OperationPlanningStatusCode	WrkCtrCapPplineOp	OperationPlanningStatusCode
	OperationPlanningStatusText
	OperationLatestStartDate
	OperationLatestStartTime
	OperationLatestEndDate
	OperationLatestEndTime
	OrderStatusCode	WrkCtrCapPplineOp	OrderStatusCode
	OrderStatusText
	OrderStatusShortText
	OrderFirmingStatusCode
	OrderFirmingStatusText
	OpLtstSchedldProcgStrtDte
	OpLtstSchedldProcgStrtTme
	OpLtstSchedldTrdwnStrtDte
	OpLtstSchedldTrdwnStrtTme
	RemainingCapReqOpSegSetupDurn	WrkCtrCapPplineOp	RemainingCapReqOpSegSetupDurn
	RemainingCapReqOpSegProcgDurn	WrkCtrCapPplineOp	RemainingCapReqOpSegProcgDurn
	RemainingCapReqOpSegTrdwnDurn	WrkCtrCapPplineOp	RemainingCapReqOpSegTrdwnDurn
	CapacityRequirementsAreDtmnd	WrkCtrCapPplineOp	CapacityRequirementsAreDtmnd
	RemainingCapReqExecutionDurn	WrkCtrCapPplineOp	CapacityRequirementsAreDtmnd
	OrderInternalID	WrkCtrCapPplineOp	OrderInternalID	Plan No.f.Oper.
	_WorkCenterOrders		_WorkCenterOrders

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 A_WorkCenterCapPplineOp.
-- 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: AWCCAPPPLINEOP

CREATE VIEW A_WorkCenterCapPplineOp AS
SELECT
  WrkCtrCapPplineOp.Plant AS Plant,
  WrkCtrCapPplineOp.MRPController AS MRPController,
  WrkCtrCapPplineOp.WorkCenter AS WorkCenter,
  WrkCtrCapPplineOp.CapacityInternalID AS CapacityInternalID,
  WrkCtrCapPplineOp.CapacityRequirement AS CapacityRequirement,
  WrkCtrCapPplineOp.Material AS Material,
  WrkCtrCapPplineOp.OrderID AS OrderID,
  WrkCtrCapPplineOp.Operation AS Operation,
  _WorkCenterText[1:Language=$session.system_language].WorkCenterText AS WorkCenterDesc,
  WrkCtrCapPplineOp.WorkCenterResponsible AS WorkCenterResponsible,
  WrkCtrCapPplineOp.WorkCenterCategoryCode AS WorkCenterCategoryCode,
  WrkCtrCapPplineOp.WorkCenterInternalID AS WorkCenterInternalID,
  WrkCtrCapPplineOp.CapacityRequirementOrigin AS CapacityRequirementOrigin,
  WrkCtrCapPplineOp.CapacityRequirementUnit AS CapacityRequirementUnit,
  WrkCtrCapPplineOp.OrderType AS OrderType,
  WrkCtrCapPplineOp.OrderCategory AS OrderCategory,
  cast(WrkCtrCapPplineOp.BaseUnit as meins) AS BaseUnit,
  WrkCtrCapPplineOp.OrderPlannedTotalQty AS OrderPlannedTotalQty,
  WrkCtrCapPplineOp.ProductionVersion AS ProductionVersion,
  WrkCtrCapPplineOp.OperationPlanningStatusCode AS OperationPlanningStatusCode,
  _OprPlanningText[1:Language=$session.system_language].CapacityRequirementStatusText AS OperationPlanningStatusText,
  cast(WrkCtrCapPplineOp.OperationLatestStartDate as char8) AS OperationLatestStartDate,
  cast(WrkCtrCapPplineOp.OperationLatestStartTime as char6) AS OperationLatestStartTime,
  cast(WrkCtrCapPplineOp.OperationLatestEndDate as char8) AS OperationLatestEndDate,
  cast(WrkCtrCapPplineOp.OperationLatestEndTime as char6) AS OperationLatestEndTime,
  WrkCtrCapPplineOp.OrderStatusCode AS OrderStatusCode,
  _OrderStatusText[1:Language=$session.system_language].SystemStatusName AS OrderStatusText,
  _OrderStatusText[1:Language=$session.system_language].SystemStatusShortName AS OrderStatusShortText,
  cast(WrkCtrCapPplineOp.OrderFirmingStatusCode as char1) AS OrderFirmingStatusCode,
  _FirmingStatusText[1:Language=$session.system_language].OrderFirmingStatusText AS OrderFirmingStatusText,
  cast(WrkCtrCapPplineOp.OpLtstSchedldProcgStrtDte as char8) AS OpLtstSchedldProcgStrtDte,
  cast(WrkCtrCapPplineOp.OpLtstSchedldProcgStrtTme as char6) AS OpLtstSchedldProcgStrtTme,
  cast(WrkCtrCapPplineOp.OpLtstSchedldTrdwnStrtDte as char8) AS OpLtstSchedldTrdwnStrtDte,
  cast(WrkCtrCapPplineOp.OpLtstSchedldTrdwnStrtTme as char6) AS OpLtstSchedldTrdwnStrtTme,
  WrkCtrCapPplineOp.RemainingCapReqOpSegSetupDurn AS RemainingCapReqOpSegSetupDurn,
  WrkCtrCapPplineOp.RemainingCapReqOpSegProcgDurn AS RemainingCapReqOpSegProcgDurn,
  WrkCtrCapPplineOp.RemainingCapReqOpSegTrdwnDurn AS RemainingCapReqOpSegTrdwnDurn,
  WrkCtrCapPplineOp.CapacityRequirementsAreDtmnd AS CapacityRequirementsAreDtmnd,
  WrkCtrCapPplineOp.CapacityRequirementsAreDtmnd AS RemainingCapReqExecutionDurn,
  WrkCtrCapPplineOp.OrderInternalID AS OrderInternalID
LEFT OUTER JOIN A_WorkCenterCapOrderPerBucket AS _WorkCenterOrders ON Plant = _WorkCenterOrders.Plant AND MRPController = _WorkCenterOrders.MRPController AND WorkCenter = _WorkCenterOrders.WorkCenter AND WorkCenterInternalID = _WorkCenterOrders.WorkCenterInternalID AND CapacityInternalID = _WorkCenterOrders.CapacityInternalID AND Material = _WorkCenterOrders.Material  -- association [0..*]
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 WrkCtrCapPplineOp.OrderFirmingStatusCode = _FirmingStatusText.OrderFirmingStatusCode  -- association [0..*]
;

Depth:

A_WorkCenterCapPplineOp view

A_WorkCenterCapDayOp view