C_MPEWorkCenterPover

DDL: C_MPEWORKCENTERPOVER Type: view_entity CONSUMPTION Package: ODATA_MPE_WORKCENTER_RESOURCE
35 Fields 5 Associations

Work Center Popover

C_MPEWorkCenterPover is a Consumption CDS View that provides data about "Work Center Popover" in SAP S/4HANA. It has 5 associations to related views. Part of development package ODATA_MPE_WORKCENTER_RESOURCE.

Associations (5)

CardinalityTargetAliasCondition
[1..1] I_WorkCenterCostCenter _WorkCenterCostCenter $projection.WorkCenterTypeCode = _WorkCenterCostCenter.WorkCenterTypeCode and $projection.WorkCenterInternalID = _WorkCenterCostCenter.WorkCenterInternalID and $projection.ValidityEndDate = _WorkCenterCostCenter.ValidityEndDate and _WorkCenterCostCenter.CostCenterAllocation = '0001'
[0..1] P_Mpe_Workcenteroperstatus _MfgOrderOperationStatus $projection.WorkCenterInternalID = _MfgOrderOperationStatus.WorkCenterInternalID and $projection.WorkCenterTypeCode = _MfgOrderOperationStatus.WorkCenterTypeCode
[0..1] I_ProductionResourceText WorkCenterCapacityText $projection.WorkCenterInternalID = WorkCenterCapacityText.ProductionResourceInternalID and WorkCenterCapacityText.ProductionResourceType = 'A' and WorkCenterCapacityText.Language = $session.system_language
[1..1] I_Capacity _CapacityHeader $projection.CapacityInternalID = _CapacityHeader.CapacityInternalID
[0..1] I_CapacityText _CapacityText $projection.CapacityInternalID = _CapacityText.CapacityInternalID and _CapacityText.Language = $session.system_language

Annotations (6)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
EndUserText.label Work Center Popover view
VDM.viewType #CONSUMPTION view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #MASTER view

Fields (35)

KeyFieldSource TableSource FieldDescription
KEY WorkCenterInternalID WorkCenterCapacity WorkCenterInternalID Work Center
KEY WorkCenterTypeCode WorkCenterCapacity WorkCenterTypeCode Object Type
KEY OrderInternalBillOfOperations _OrderItem OrderInternalBillOfOperations Order Internal Bill of Operations
KEY OrderIntBillOfOperationsItem _OrderItem OrderIntBillOfOperationsItem Order Internal Bill of Operations Item
WorkCenter WorkCenterCapacity WorkCenter Work Center
ManufacturingOrder _OrderItem ManufacturingOrder Order
ManufacturingOrderOperation _OrderItem ManufacturingOrderOperation Activity
MfgOrderOperationText _OrderItem MfgOrderOperationText
OpActualExecutionStartDate _OrderItem OpActualExecutionStartDate Execution Start Date
OpActualExecutionStartTime _OrderItem OpActualExecutionStartTime
OpLtstSchedldExecEndDte _OrderItem OpLtstSchedldExecEndDte Lat.finish date
OpLtstSchedldExecEndTme _OrderItem OpLtstSchedldExecEndTme
OperationUnit _OrderItem OperationUnit Act/op UoM
OpPlannedTotalQuantity _OrderItem OpPlannedTotalQuantity
Material _OrderItem Material Vehicle Model
ObjectInternalID _OrderItem ObjectInternalID Object number
OrderIsMarkedForDeletion
WorkCenterText WorkCenterCapacityText ProductionResourceText
WorkCenterResponsible WorkCenterCapacity WorkCenterResponsible
WorkCenterResponsibleName
ValidityEndDate WorkCenterCapacity ValidityEndDate ValidTo
NumberOfCurrentOperations _MfgOrderOperationStatus CountPartiallyConfirmed
WorkCenterCategoryCode WorkCenterCapacity WorkCenterCategoryCode
WorkCenterLocation WorkCenterCapacity WorkCenterLocation
SupplyArea WorkCenterCapacity SupplyArea Supply Area
CapacityCategoryCode _CapacityHeader CapacityCategoryCode
CapacityCategoryName
CapacityInternalID WorkCenterCapacity CapacityInternalID Capacity ID
Capacity _CapacityHeader Capacity Engine Capacity
CapacityText _CapacityText CapacityText
CapacityNumberOfCapacities _CapacityHeader CapacityNumberOfCapacities
MachineType WorkCenterCapacity MachineType
ControllingArea _WorkCenterCostCenter ControllingArea Controlling Area
CostCenter _WorkCenterCostCenter CostCenter Cost Center
Plant WorkCenterCapacity Plant Valuation 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 C_MPEWorkCenterPover.
-- 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 C_MPEWorkCenterPover AS
SELECT
  WorkCenterCapacity.WorkCenterInternalID AS WorkCenterInternalID,
  WorkCenterCapacity.WorkCenterTypeCode AS WorkCenterTypeCode,
  _OrderItem.OrderInternalBillOfOperations AS OrderInternalBillOfOperations,
  _OrderItem.OrderIntBillOfOperationsItem AS OrderIntBillOfOperationsItem,
  WorkCenterCapacity.WorkCenter AS WorkCenter,
  _OrderItem.ManufacturingOrder AS ManufacturingOrder,
  _OrderItem.ManufacturingOrderOperation AS ManufacturingOrderOperation,
  _OrderItem.MfgOrderOperationText AS MfgOrderOperationText,
  _OrderItem.OpActualExecutionStartDate AS OpActualExecutionStartDate,
  _OrderItem.OpActualExecutionStartTime AS OpActualExecutionStartTime,
  _OrderItem.OpLtstSchedldExecEndDte AS OpLtstSchedldExecEndDte,
  _OrderItem.OpLtstSchedldExecEndTme AS OpLtstSchedldExecEndTme,
  _OrderItem.OperationUnit AS OperationUnit,
  _OrderItem.OpPlannedTotalQuantity AS OpPlannedTotalQuantity,
  _OrderItem.Material AS Material,
  _OrderItem.ObjectInternalID AS ObjectInternalID,
  case when _OrderMarkedForDeletion.StatusCode is not null then 'X' end AS OrderIsMarkedForDeletion,
  WorkCenterCapacityText.ProductionResourceText AS WorkCenterText,
  WorkCenterCapacity.WorkCenterResponsible AS WorkCenterResponsible,
  WorkCenterCapacity._WorkCenterResponsible.WorkCenterResponsibleName AS WorkCenterResponsibleName,
  WorkCenterCapacity.ValidityEndDate AS ValidityEndDate,
  _MfgOrderOperationStatus.CountPartiallyConfirmed AS NumberOfCurrentOperations,
  WorkCenterCapacity.WorkCenterCategoryCode AS WorkCenterCategoryCode,
  WorkCenterCapacity.WorkCenterLocation AS WorkCenterLocation,
  WorkCenterCapacity.SupplyArea AS SupplyArea,
  _CapacityHeader.CapacityCategoryCode AS CapacityCategoryCode,
  _CapacityHeader._CapacityCategory._Text[1: Language = $session.system_language ].CapacityCategoryName AS CapacityCategoryName,
  WorkCenterCapacity.CapacityInternalID AS CapacityInternalID,
  _CapacityHeader.Capacity AS Capacity,
  _CapacityText.CapacityText AS CapacityText,
  _CapacityHeader.CapacityNumberOfCapacities AS CapacityNumberOfCapacities,
  WorkCenterCapacity.MachineType AS MachineType,
  _WorkCenterCostCenter.ControllingArea AS ControllingArea,
  _WorkCenterCostCenter.CostCenter AS CostCenter,
  WorkCenterCapacity.Plant AS Plant
LEFT OUTER JOIN I_WorkCenterCostCenter AS _WorkCenterCostCenter ON WorkCenterTypeCode = _WorkCenterCostCenter.WorkCenterTypeCode AND WorkCenterInternalID = _WorkCenterCostCenter.WorkCenterInternalID AND ValidityEndDate = _WorkCenterCostCenter.ValidityEndDate AND _WorkCenterCostCenter.CostCenterAllocation = '0001'  -- association [1..1]
LEFT OUTER JOIN P_Mpe_Workcenteroperstatus AS _MfgOrderOperationStatus ON WorkCenterInternalID = _MfgOrderOperationStatus.WorkCenterInternalID AND WorkCenterTypeCode = _MfgOrderOperationStatus.WorkCenterTypeCode  -- association [0..1]
LEFT OUTER JOIN I_ProductionResourceText AS WorkCenterCapacityText ON WorkCenterInternalID = WorkCenterCapacityText.ProductionResourceInternalID AND WorkCenterCapacityText.ProductionResourceType = 'A' AND WorkCenterCapacityText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_Capacity AS _CapacityHeader ON CapacityInternalID = _CapacityHeader.CapacityInternalID  -- association [1..1]
LEFT OUTER JOIN I_CapacityText AS _CapacityText ON CapacityInternalID = _CapacityText.CapacityInternalID AND _CapacityText.Language = $session.system_language  -- association [0..1]
;

Learn More