P_Mpe_Workcenteroperstatus

DDL: P_MPE_WORKCENTEROPERSTATUS Type: view_entity CONSUMPTION
7 Fields 1 Data Sources

Status of operations in a work center

P_Mpe_Workcenteroperstatus is a Consumption CDS View that provides data about "Status of operations in a work center" in SAP S/4HANA. It reads from 1 data source (I_MfgOrderOperationDelay) and exposes 7 fields with key fields WorkCenterInternalID, WorkCenterTypeCode.

Data Sources (1)

SourceAliasJoin Type
I_MfgOrderOperationDelay I_MfgOrderOperationDelay from

Annotations (4)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Status of operations in a work center view
VDM.viewType #CONSUMPTION view
VDM.private true view

Fields (7)

KeyFieldSource TableSource FieldDescription
KEY WorkCenterInternalID WorkCenterInternalID Work Center
KEY WorkCenterTypeCode WorkCenterTypeCode Object Type
int8asCountPartiallyConfirmed
int8asCountConfirmed
int8asCountPartiallyDelivered
int8asCountDelivered
int8asCountTechlyCompleted

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_Mpe_Workcenteroperstatus.
-- 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_Mpe_Workcenteroperstatus AS
SELECT
  WorkCenterInternalID,
  WorkCenterTypeCode,
  cast( sum( case when OperationIsPartiallyConfirmed='X' then 1 else 0 end ) as abap.int8) as CountPartiallyConfirmed AS int8asCountPartiallyConfirmed,
  cast( sum( case when OperationIsConfirmed='X' then 1 else 0 end ) as abap.int8) as CountConfirmed AS int8asCountConfirmed,
  cast( sum( case when OperationIsPartiallyDelivered='X' then 1 else 0 end ) as abap.int8) as CountPartiallyDelivered AS int8asCountPartiallyDelivered,
  cast( sum( case when OperationIsDelivered='X' then 1 else 0 end ) as abap.int8) as CountDelivered AS int8asCountDelivered,
  cast( sum( case when OperationIsTechlyCompleted='X' then 1 else 0 end ) as abap.int8) as CountTechlyCompleted AS int8asCountTechlyCompleted
FROM I_MfgOrderOperationDelay
;

Learn More