I_TODAYSOPERATIONS
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)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| 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":""
}
}*/