P_Mpe_Workcentermaterial

DDL: P_MPE_WORKCENTERMATERIAL Type: view_entity CONSUMPTION

Material for work center

P_Mpe_Workcentermaterial is a Consumption CDS View that provides data about "Material for work center" in SAP S/4HANA. It reads from 1 data source (I_MfgOrderOperation) and exposes 15 fields with key fields WorkCenterInternalID, WorkCenterTypeCode. It has 2 associations to related views.

1 data source(s) 15 fields

Data Sources (1)

SourceAliasJoin Type
I_MfgOrderOperation _OrderOper from

Associations (2)

CardinalityTargetAliasCondition
[0..1] I_LogisticsOrder _Order _Order.OrderID = _OrderOper.ManufacturingOrder
[0..1] I_OrderItem _OrderItem $projection.ManufacturingOrder = _OrderItem.OrderID and _OrderItem.OrderItem = '0001'

Annotations (4)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Material for work center view
VDM.viewType #CONSUMPTION view
VDM.private true view

Fields (15)

KeyFieldSource TableSource FieldDescription
KEY WorkCenterInternalID WorkCenterInternalID
KEY WorkCenterTypeCode WorkCenterTypeCode
OrderInternalBillOfOperations OrderInternalBillOfOperations
OrderIntBillOfOperationsItem OrderIntBillOfOperationsItem
ManufacturingOrder ManufacturingOrder
Material _OrderItem Material
ManufacturingOrderOperation ManufacturingOrderOperation
MfgOrderOperationText MfgOrderOperationText
OpActualExecutionStartDate OpActualExecutionStartDate
OpActualExecutionStartTime OpActualExecutionStartTime
OpLtstSchedldExecEndDte OpLtstSchedldExecEndDte
OpLtstSchedldExecEndTme OpLtstSchedldExecEndTme
OperationUnit OperationUnit
OpPlannedTotalQuantity OpPlannedTotalQuantity
ObjectInternalID _Order ObjectInternalID 
@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'Material for work center'
@VDM.viewType: #CONSUMPTION
@VDM.private: true
define view entity P_Mpe_Workcentermaterial
  as select from I_MfgOrderOperation as _OrderOper
  association [0..1] to I_LogisticsOrder as _Order on _Order.OrderID = _OrderOper.ManufacturingOrder

  association [0..1] to I_OrderItem      as _OrderItem   on  $projection.ManufacturingOrder = _OrderItem.OrderID
                                                              and _OrderItem.OrderItem           = '0001'
                                                  
                                                     
{
  key WorkCenterInternalID,
  key WorkCenterTypeCode,
      OrderInternalBillOfOperations,
      OrderIntBillOfOperationsItem,
      ManufacturingOrder,
      _OrderItem.Material as Material,
      ManufacturingOrderOperation,
      MfgOrderOperationText,
      OpActualExecutionStartDate,
      OpActualExecutionStartTime,
      OpLtstSchedldExecEndDte,
      OpLtstSchedldExecEndTme,
      OperationUnit,
      OpPlannedTotalQuantity,
//      case when _OrderMarkedForDeletion.StatusCode is not null then 'X' end      as  OrderIsMarkedForDeletion,

//      _OrderStatus.OrderIsMarkedForDeletion as OrderIsMarkedForDeletion,

      _Order.ObjectInternalID
}                                       
  
  
  
  
  
 /*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_LOGISTICSORDER",
"I_MFGORDEROPERATION",
"I_ORDERITEM"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More