I_TODAYSOPERATIONS

CDS View

Todays Operations

I_TODAYSOPERATIONS is a CDS View in S/4HANA. Todays Operations. 3 CDS views read from this table.

CDS Views using this table (3)

ViewTypeJoinVDMDescription
A_WorkCenterDayOperation view from COMPOSITE Daily Operations
C_ResourceObjPgTodayOp view_entity from CONSUMPTION Todays Operations for Resources
C_WrkCntrObjPgTodayOp view from CONSUMPTION Work Center Object Page Todays Operation
@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'Todays Operations'
@VDM.viewType: #COMPOSITE
@ObjectModel.usageType: {serviceQuality: #C, sizeCategory: #XL, dataClass: #MIXED}
@Metadata.ignorePropagatedAnnotations: true
define view entity I_TodaysOperations
  as select from P_MfgOrderWrkCntrOper

  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
 
{
  key    OrderInternalBillOfOperations,
  key    OrderIntBillOfOperationsItem,
  key    WorkCenterInternalID,
          ManufacturingOrder,
          ManufacturingOrderOperation,
          ManufacturingOrderCategory,
             MfgOrderOperationText,
             Material,
             cast(OperationIsReleased as boolean preserving type)                                                                             as OperationIsReleased,
             OpErlstSchedldExecStrtDte,
             OpErlstSchedldExecStrtTme,
             OpErlstSchedldExecEndDte,
             OpErlstSchedldExecEndTme,
             @Semantics.quantity.unitOfMeasure: 'OperationUnit'
             OpPlannedTotalQuantity,
             OperationUnit,
             @DefaultAggregation: #SUM
             @Semantics.quantity.unitOfMeasure: 'ConfirmedQuantityUnit'
             _ConfirmedQty.ConfirmedQuantity,
             @Semantics.quantity.unitOfMeasure: 'OperationUnit'
             @DefaultAggregation: #SUM
             OpTotalConfirmedYieldQty,
             @VDM.lifecycle.status: #DEPRECATED
             @VDM.lifecycle.successor: 'ConfirmedQuantityUnit'
             @Semantics.quantity.unitOfMeasure: 'ConfirmedQuantityUnit'
             cast(0 as abap.quan( 13, 3 )) as ConfirmedQuantityInBaseUnit,
             _ConfirmedQty.ConfirmedQuantityUnit,
             ErlstSchedldExecDurnInWorkdays,
             OpActualExecutionDays,
             ManufacturingOrderSequence,
             cast(MfgOrderOperationIsPhase as boolean preserving type)                                                                        as MfgOrderOperationIsPhase,
             @Semantics.booleanIndicator: true
             OperationIsConfirmed,
             _Material,
             _MfgOrderSequence,
             _MfgOrder
}

where // Today's operations

      OpErlstSchedldExecStrtDte <= $session.system_date
  and OpErlstSchedldExecEndDte  >= $session.system_date     
           
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
 /*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_MFGORDEROBJPGOPCONFQTY",
"P_MFGORDERWRKCNTROPER"
],
"ASSOCIATED":
[
"I_MATERIAL",
"I_MFGORDER",
"I_MFGORDERSEQUENCE"
],
"BASE":
[
"P_MFGORDERWRKCNTROPER"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/