What is P_EvaltCapWrkCtrOperationsDets in SAP S/4HANA?

P_EvaltCapWrkCtrOperationsDets is a composite CDS view in SAP S/4HANA. Work Center Capacities Operations It contains 61 fields.

Which tables does P_EvaltCapWrkCtrOperationsDets read from?

P_EvaltCapWrkCtrOperationsDets reads data from: P_EvaltCapWrkCtrOpsInTimestamp.

What VDM layer is P_EvaltCapWrkCtrOperationsDets?

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

P_EvaltCapWrkCtrOperationsDets

DDL: P_EVALTCAPWRKCTROPERATIONSDETS Type: view_entity COMPOSITE

61 Fields 1 Data Sources 8 Associations

Work Center Capacities Operations

P_EvaltCapWrkCtrOperationsDets is a Composite CDS View that provides data about "Work Center Capacities Operations" in SAP S/4HANA. It reads from 1 data source (P_EvaltCapWrkCtrOpsInTimestamp) and exposes 61 fields with key fields WorkCenterInternalID, WorkCenterTypeCode, CapacityCategoryAllocation, CapacityInternalID, CapacityRequirement. It has 8 associations to related views.

Data Sources (1)

Source	Alias	Join Type
P_EvaltCapWrkCtrOpsInTimestamp	WrkCtrCapOp	from

Associations (8)

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_SchedProdnOrderCategoryVH	_OrderCategoryText	`$projection.OrderCategory = _OrderCategoryText.OrderCategory`
[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 (8)

Name	Value	Level
AccessControl.authorizationCheck	#NOT_REQUIRED	view
EndUserText.label	Work Center Capacities Operations	view
Metadata.ignorePropagatedAnnotations	true	view
ObjectModel.usageType.serviceQuality	#D	view
ObjectModel.usageType.sizeCategory	#XL	view
ObjectModel.usageType.dataClass	#TRANSACTIONAL	view
VDM.viewType	#COMPOSITE	view
VDM.private	true	view

Fields (61)

Key	Field	Source Table	Source Field	Description
KEY	WorkCenterInternalID	P_EvaltCapWrkCtrOpsInTimestamp	WorkCenterInternalID	Work Center Internal ID
KEY	WorkCenterTypeCode	P_EvaltCapWrkCtrOpsInTimestamp	WorkCenterTypeCode	Object Type
KEY	CapacityCategoryAllocation	P_EvaltCapWrkCtrOpsInTimestamp	CapacityCategoryAllocation
KEY	CapacityInternalID	P_EvaltCapWrkCtrOpsInTimestamp	CapacityInternalID	Capacity ID
KEY	CapacityRequirement	P_EvaltCapWrkCtrOpsInTimestamp	CapacityRequirement
KEY	CapacityRequirementItem	P_EvaltCapWrkCtrOpsInTimestamp	CapacityRequirementItem
KEY	Material	P_EvaltCapWrkCtrOpsInTimestamp	Material	Product Number
KEY	OrderID	P_EvaltCapWrkCtrOpsInTimestamp	OrderID	Order ID
KEY	Operation	P_EvaltCapWrkCtrOpsInTimestamp	Operation	Transaction
	Plant
	MRPController	P_EvaltCapWrkCtrOpsInTimestamp	MRPController	MRP Controller
	WorkCenter	P_EvaltCapWrkCtrOpsInTimestamp	WorkCenter	Work Center
	CapacityCategory	P_EvaltCapWrkCtrOpsInTimestamp	CapacityCategory
	OrderCategory	P_EvaltCapWrkCtrOpsInTimestamp	OrderCategory	Order Category
	WorkCenterDesc			WorkCenter Description
	WorkCenterResponsible	P_EvaltCapWrkCtrOpsInTimestamp	WorkCenterResponsible	Person Responsible
	MaterialName			Material Name
	WorkCenterCategoryCode	P_EvaltCapWrkCtrOpsInTimestamp	WorkCenterCategoryCode	Work Center Category
	CapacityRequirementOrigin	P_EvaltCapWrkCtrOpsInTimestamp	CapacityRequirementOrigin	Requirement Origin
	OrderType	P_EvaltCapWrkCtrOpsInTimestamp	OrderType	Order Type
	OrderCategoryName			Order Category Name
	BaseUnit
	OrderPlannedTotalQty	P_EvaltCapWrkCtrOpsInTimestamp	OrderPlannedTotalQty	Order Quantity
	ProductionVersion	P_EvaltCapWrkCtrOpsInTimestamp	ProductionVersion	Source Of Supply
	OperationPlanningStatusText			Operation Planning Status
	OperationPlanningStatusCode	P_EvaltCapWrkCtrOpsInTimestamp	OperationPlanningStatusCode	Operation Planning Status Code
	OperationLatestStartDateTime	P_EvaltCapWrkCtrOpsInTimestamp	OperationLatestStartDateTime	Operation Start
	OperationLatestStartDate	P_EvaltCapWrkCtrOpsInTimestamp	OperationLatestStartDate	Operation Start Date
	OperationLatestStartTime	P_EvaltCapWrkCtrOpsInTimestamp	OperationLatestStartTime	Operation Start Time
	OperationLatestEndDate	P_EvaltCapWrkCtrOpsInTimestamp	OperationLatestEndDate	Operation End Date
	OperationLatestEndTime	P_EvaltCapWrkCtrOpsInTimestamp	OperationLatestEndTime	Operation End Time
	OperationLatestEndDateTime	P_EvaltCapWrkCtrOpsInTimestamp	OperationLatestEndDateTime	Operation End
	OrderStatusCode	P_EvaltCapWrkCtrOpsInTimestamp	OrderStatusCode	Order Status Code
	OrderStatusText			Order Status
	OrderStatusShortText			Order Status SHort Code
	OrderFirmingStatusCode	P_EvaltCapWrkCtrOpsInTimestamp	OrderFirmingStatusCode	Firming Status Code
	OrderFirmingStatusText			Firming Status Text
	OpLtstSchedldExecStrtDte	P_EvaltCapWrkCtrOpsInTimestamp	OperationLatestStartDate	Scheduled Start Setup Date
	OpLtstSchedldExecStrtTme	P_EvaltCapWrkCtrOpsInTimestamp	OperationLatestStartTime	Scheduled Start Setup Time
	OpLtstSchedldExecStrtDteTme	P_EvaltCapWrkCtrOpsInTimestamp	OperationLatestStartDateTime	Latest Setup Start
	OpLtstSchedldProcgStrtDte	P_EvaltCapWrkCtrOpsInTimestamp	OpLtstSchedldProcgStrtDte	Scheduled Start Processing Date
	OpLtstSchedldProcgStrtTme	P_EvaltCapWrkCtrOpsInTimestamp	OpLtstSchedldProcgStrtTme	Scheduled Start Processing Time
	OpLtstSchedldProcgStrtDteTme	P_EvaltCapWrkCtrOpsInTimestamp	OpLtstSchedldProcgStrtDteTme	Latest Processing Start
	OpLtstSchedldTrdwnStrtDte	P_EvaltCapWrkCtrOpsInTimestamp	OpLtstSchedldTrdwnStrtDte	Latest Start Teardown Date
	OpLtstSchedldTrdwnStrtTme	P_EvaltCapWrkCtrOpsInTimestamp	OpLtstSchedldTrdwnStrtTme	Latest Start Teardown Time
	OpLtstSchedldTrdwnStrtDteTme	P_EvaltCapWrkCtrOpsInTimestamp	OpLtstSchedldTrdwnStrtDteTme	Latest Teardown Start
	OrderInternalID	P_EvaltCapWrkCtrOpsInTimestamp	OrderInternalID	Order Internal ID
	ScheduledBasicStartDate	P_EvaltCapWrkCtrOpsInTimestamp	ScheduledBasicStartDate	Order Start Date
	ScheduledBasicStartTime	P_EvaltCapWrkCtrOpsInTimestamp	ScheduledBasicStartTime	Order Start Time
	ScheduledBasicStartDateTime	P_EvaltCapWrkCtrOpsInTimestamp	ScheduledBasicStartDateTime	Order Start
	ScheduledBasicEndDateTime	P_EvaltCapWrkCtrOpsInTimestamp	ScheduledBasicEndDateTime	Order End
	ScheduledBasicEndDate	P_EvaltCapWrkCtrOpsInTimestamp	ScheduledBasicEndDate	Order End Date
	ScheduledBasicEndTime	P_EvaltCapWrkCtrOpsInTimestamp	ScheduledBasicEndTime	Order End Time
	LtstSchedldExecStrtDteTme	P_EvaltCapWrkCtrOpsInTimestamp	LtstSchedldExecStrtDteTme
	LtstSchedldExecEndDteTme	P_EvaltCapWrkCtrOpsInTimestamp	LtstSchedldExecEndDteTme
	Sequence	P_EvaltCapWrkCtrOpsInTimestamp	Sequence	Visit Sequence
	PlantTimeZone	P_EvaltCapWrkCtrOpsInTimestamp	PlantTimeZone	Time Zone
	Customer	P_EvaltCapWrkCtrOpsInTimestamp	Customer	Sold-to Party
	CustomerABCClassification	P_EvaltCapWrkCtrOpsInTimestamp	CustomerABCClassification	ABC class
	ProductGroup	P_EvaltCapWrkCtrOpsInTimestamp	ProductGroup	Product Sold Group
	MRPArea	P_EvaltCapWrkCtrOpsInTimestamp	MRPArea	MRP Area

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 P_EvaltCapWrkCtrOperationsDets.
-- 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 P_EvaltCapWrkCtrOperationsDets AS
SELECT
  WrkCtrCapOp.WorkCenterInternalID AS WorkCenterInternalID,
  WrkCtrCapOp.WorkCenterTypeCode AS WorkCenterTypeCode,
  WrkCtrCapOp.CapacityCategoryAllocation AS CapacityCategoryAllocation,
  WrkCtrCapOp.CapacityInternalID AS CapacityInternalID,
  WrkCtrCapOp.CapacityRequirement AS CapacityRequirement,
  WrkCtrCapOp.CapacityRequirementItem AS CapacityRequirementItem,
  WrkCtrCapOp.Material AS Material,
  WrkCtrCapOp.OrderID AS OrderID,
  WrkCtrCapOp.Operation AS Operation,
  cast(WrkCtrCapOp.Plant as werks_d preserving type ) AS Plant,
  WrkCtrCapOp.MRPController AS MRPController,
  WrkCtrCapOp.WorkCenter AS WorkCenter,
  WrkCtrCapOp.CapacityCategory AS CapacityCategory,
  WrkCtrCapOp.OrderCategory AS OrderCategory,
  _WorkCenterText[1:Language=$session.system_language].WorkCenterText AS WorkCenterDesc,
  WrkCtrCapOp.WorkCenterResponsible AS WorkCenterResponsible,
  _MatText[1:Language=$session.system_language].MaterialName AS MaterialName,
  WrkCtrCapOp.WorkCenterCategoryCode AS WorkCenterCategoryCode,
  WrkCtrCapOp.CapacityRequirementOrigin AS CapacityRequirementOrigin,
  WrkCtrCapOp.OrderType AS OrderType,
  _OrderCategoryText[1:Language=$session.system_language].OrderCategoryName AS OrderCategoryName,
  cast(WrkCtrCapOp.BaseUnit as meins preserving type ) AS BaseUnit,
  WrkCtrCapOp.OrderPlannedTotalQty AS OrderPlannedTotalQty,
  WrkCtrCapOp.ProductionVersion AS ProductionVersion,
  _OprPlanningText[1:Language=$session.system_language].CapacityRequirementStatusText AS OperationPlanningStatusText,
  WrkCtrCapOp.OperationPlanningStatusCode AS OperationPlanningStatusCode,
  WrkCtrCapOp.OperationLatestStartDateTime AS OperationLatestStartDateTime,
  WrkCtrCapOp.OperationLatestStartDate AS OperationLatestStartDate,
  WrkCtrCapOp.OperationLatestStartTime AS OperationLatestStartTime,
  WrkCtrCapOp.OperationLatestEndDate AS OperationLatestEndDate,
  WrkCtrCapOp.OperationLatestEndTime AS OperationLatestEndTime,
  WrkCtrCapOp.OperationLatestEndDateTime AS OperationLatestEndDateTime,
  WrkCtrCapOp.OrderStatusCode AS OrderStatusCode,
  _OrderStatusText[1:Language=$session.system_language].SystemStatusName AS OrderStatusText,
  _OrderStatusText[1:Language=$session.system_language].SystemStatusShortName AS OrderStatusShortText,
  WrkCtrCapOp.OrderFirmingStatusCode AS OrderFirmingStatusCode,
  _FirmingStatusText[1:Language=$session.system_language].OrderFirmingStatusText AS OrderFirmingStatusText,
  WrkCtrCapOp.OperationLatestStartDate AS OpLtstSchedldExecStrtDte,
  WrkCtrCapOp.OperationLatestStartTime AS OpLtstSchedldExecStrtTme,
  WrkCtrCapOp.OperationLatestStartDateTime AS OpLtstSchedldExecStrtDteTme,
  WrkCtrCapOp.OpLtstSchedldProcgStrtDte AS OpLtstSchedldProcgStrtDte,
  WrkCtrCapOp.OpLtstSchedldProcgStrtTme AS OpLtstSchedldProcgStrtTme,
  WrkCtrCapOp.OpLtstSchedldProcgStrtDteTme AS OpLtstSchedldProcgStrtDteTme,
  WrkCtrCapOp.OpLtstSchedldTrdwnStrtDte AS OpLtstSchedldTrdwnStrtDte,
  WrkCtrCapOp.OpLtstSchedldTrdwnStrtTme AS OpLtstSchedldTrdwnStrtTme,
  WrkCtrCapOp.OpLtstSchedldTrdwnStrtDteTme AS OpLtstSchedldTrdwnStrtDteTme,
  WrkCtrCapOp.OrderInternalID AS OrderInternalID,
  WrkCtrCapOp.ScheduledBasicStartDate AS ScheduledBasicStartDate,
  WrkCtrCapOp.ScheduledBasicStartTime AS ScheduledBasicStartTime,
  WrkCtrCapOp.ScheduledBasicStartDateTime AS ScheduledBasicStartDateTime,
  WrkCtrCapOp.ScheduledBasicEndDateTime AS ScheduledBasicEndDateTime,
  WrkCtrCapOp.ScheduledBasicEndDate AS ScheduledBasicEndDate,
  WrkCtrCapOp.ScheduledBasicEndTime AS ScheduledBasicEndTime,
  WrkCtrCapOp.LtstSchedldExecStrtDteTme AS LtstSchedldExecStrtDteTme,
  WrkCtrCapOp.LtstSchedldExecEndDteTme AS LtstSchedldExecEndDteTme,
  WrkCtrCapOp.Sequence AS Sequence,
  WrkCtrCapOp.PlantTimeZone AS PlantTimeZone,
  WrkCtrCapOp.Customer AS Customer,
  WrkCtrCapOp.CustomerABCClassification AS CustomerABCClassification,
  WrkCtrCapOp.ProductGroup AS ProductGroup,
  WrkCtrCapOp.MRPArea AS MRPArea
FROM P_EvaltCapWrkCtrOpsInTimestamp AS WrkCtrCapOp
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_SchedProdnOrderCategoryVH AS _OrderCategoryText ON OrderCategory = _OrderCategoryText.OrderCategory  -- 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:

P_EvaltCapWrkCtrOperationsDets view_entity

P_EvaltCapWrkCtrOpsInTimestamp view_entity