P_INPROCESSOPERATIONS

CDS View

Operations in Progress

P_INPROCESSOPERATIONS is a CDS View in S/4HANA. Operations in Progress. 1 CDS views read from this table.

Used by 1 CDS view(s)

CDS Views using this table (1)

ViewTypeJoinVDMDescription
C_WrkCtrObjPgInProcOp view_entity from CONSUMPTION Wrk Ctr Obj Pg In Process Operations 
@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'Operations in Progress'
@VDM.viewType: #COMPOSITE
@ObjectModel.usageType: {serviceQuality: #C, sizeCategory: #XL, dataClass: #MIXED}
@Metadata.ignorePropagatedAnnotations: true
@VDM.private: true
define view entity P_InProcessOperations
  as select from P_MfgOrderWrkCntrOper as OrdWrkCntOpr
  left outer to one join I_StatusObjectStatusBasic as _isDelivered    on _isDelivered.StatusObject    = OrdWrkCntOpr.ManufacturingObject 
and _isDelivered.StatusCode    = 'I0012' and _isDelivered.StatusIsInactive    = '' //and _isDelivered.StatusObject      like 'OR%'// OrderIsDelivered

 left outer to one join I_StatusObjectStatusBasic as _isTechCompl    on _isTechCompl.StatusObject    = OrdWrkCntOpr.ManufacturingObject 
 and _isTechCompl.StatusCode    = 'I0045' and _isTechCompl.StatusIsInactive    = '' //and _isTechCompl.StatusObject      like 'OR%'// OrderIsTechnicallyCompleted  

  association [0..1] to I_MfgOrderObjPgOpConfQty as _ConfirmedQty on  $projection.WorkCenterInternalID        = _ConfirmedQty.WorkCenterInternalID
                                                                  and $projection.ManufacturingOrder          = _ConfirmedQty.ProductionOrder
                                                                  and $projection.ManufacturingOrderOperation = _ConfirmedQty.Operation
                                                                  and $projection.ManufacturingOrderCategory  = _ConfirmedQty.OrderCategory
 // association [0..1] to I_MfgOrderStatus         as _OrderStatus  on  $projection.ManufacturingOrder = _OrderStatus.ManufacturingOrder

 
{
      key    OrdWrkCntOpr.OrderInternalBillOfOperations,
      key    OrdWrkCntOpr.OrderIntBillOfOperationsItem,
      key    OrdWrkCntOpr.WorkCenterInternalID,
             OrdWrkCntOpr.ManufacturingOrder,
             cast(OrdWrkCntOpr.ManufacturingOrderOperation as vdm_vornr preserving type)                                                                  as ManufacturingOrderOperation,
             OrdWrkCntOpr.ManufacturingOrderCategory,
             OrdWrkCntOpr.MfgOrderOperationText,
             OrdWrkCntOpr.Material,
             cast(OrdWrkCntOpr.OperationIsReleased as boolean preserving type)                                                                             as OperationIsReleased,
             OrdWrkCntOpr.OpErlstSchedldExecStrtDte,
             OrdWrkCntOpr.OpErlstSchedldExecStrtTme,
             OrdWrkCntOpr.OpErlstSchedldExecEndDte,
             OrdWrkCntOpr.OpErlstSchedldExecEndTme,
             @Semantics.quantity.unitOfMeasure: 'OperationUnit'
             @DefaultAggregation: #SUM
             OrdWrkCntOpr.OpTotalConfirmedYieldQty,
             @Semantics.quantity.unitOfMeasure: 'OperationUnit'
             OrdWrkCntOpr.OpPlannedTotalQuantity,
             OrdWrkCntOpr.OperationUnit,
             OrdWrkCntOpr.ErlstSchedldExecDurnInWorkdays,
             OrdWrkCntOpr.OpActualExecutionDays,
             OrdWrkCntOpr.ManufacturingOrderSequence,
             cast(OrdWrkCntOpr.MfgOrderOperationIsPhase as boolean preserving type)                                                                        as MfgOrderOperationIsPhase,
             cast(OrdWrkCntOpr.OperationIsPartiallyConfirmed as boolean preserving type)                                                                   as OperationIsPartiallyConfirmed,
              cast(case when _isDelivered.StatusCode    is null then '' else 'X' end as boolean preserving type)                                       as OrderIsDelivered,
             cast(case when _isTechCompl.StatusCode    is null then '' else 'X' end as boolean preserving type)                                       as OrderIsTechnicallyCompleted,
             OrdWrkCntOpr._Material,
             OrdWrkCntOpr._MfgOrderSequence,
             OrdWrkCntOpr._MfgOrder
}

where // In Process Operations

   OrdWrkCntOpr.OperationIsPartiallyConfirmed = 'X'

Learn More