P_LatestOperation

DDL: P_LATESTOPERATION Type: view_entity CONSUMPTION

P_LatestOperation is a Consumption CDS View in SAP S/4HANA. It reads from 2 data sources (P_MfgOperationsList, P_OrdLatestOperAggr) and exposes 9 fields with key field OrderInternalBillOfOperations.

2 data source(s) 9 fields

Data Sources (2)

SourceAliasJoin Type
P_MfgOperationsList _AORListDistinct inner
P_OrdLatestOperAggr _LastOper from

Annotations (6)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MIXED view
VDM.viewType #CONSUMPTION view
VDM.private true view

Fields (9)

KeyFieldSource TableSource FieldDescription
KEY OrderInternalBillOfOperations P_OrdLatestOperAggr OrderInternalBillOfOperations
LatestOperation P_OrdLatestOperAggr LatestOperation
LatestOperationText _latestOp OperationText
LatestOperDet
OpLtstConfirmedYieldQty _latestOp OpTotalConfirmedYieldQty
OpLtstConfirmedScrapQty _latestOp OpTotalConfirmedScrapQty
OpLtstPlannedTotalQty _latestOp OpPlannedTotalQuantity
OperationIsConfirmed
OperationUnit _latestOp OperationUnit 
@AccessControl.authorizationCheck: #NOT_REQUIRED
//@EndUserText.label: 'Order Latest Operation Details'

@ObjectModel.usageType: {serviceQuality: #C, sizeCategory: #XL, dataClass: #MIXED}
@VDM.viewType:   #CONSUMPTION
@VDM.private: true

define view entity P_LatestOperation
  as select from P_OrdLatestOperAggr as _LastOper
  left outer to one join I_ProductionOrdOpBasic as _latestOp on  _LastOper.OrderInternalBillOfOperations = _latestOp.OrderInternalID
                                                              and _LastOper.LatestOperation    = _latestOp.Operation
  inner join P_MfgOperationsList as _AORListDistinct on  _AORListDistinct.OrderInternalID = _LastOper.OrderInternalBillOfOperations
                                                                                and _AORListDistinct.OrderOperationInternalID  = _latestOp.OrderOperationInternalID

 left outer to one join I_StatusObjectStatusBasic as _isConfirmed on _isConfirmed.StatusObject = _latestOp.ObjectInternalID and _isConfirmed.StatusCode = 'I0009' and _isConfirmed.StatusIsInactive = ''  // OperationIsConfirmed

{
  key _LastOper.OrderInternalBillOfOperations,
      _LastOper.LatestOperation,
      _latestOp.OperationText                                                    as LatestOperationText,
      concat( concat (_latestOp.OperationText, concat('(',_LastOper.LatestOperation)),')') as LatestOperDet,
      _latestOp.OpTotalConfirmedYieldQty                                                 as OpLtstConfirmedYieldQty,
      _latestOp.OpTotalConfirmedScrapQty                                                 as OpLtstConfirmedScrapQty,
      _latestOp.OpPlannedTotalQuantity                                                   as OpLtstPlannedTotalQty,
      case when _isConfirmed.StatusCode is null then '' else 'X' end as OperationIsConfirmed,
      _latestOp.OperationUnit
}
where
      _latestOp.SuperiorOperationInternalID is initial
  and _latestOp.Sequence     = '000000'
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_PRODUCTIONORDOPBASIC",
"I_STATUSOBJECTSTATUSBASIC",
"P_MFGOPERATIONSLIST",
"P_ORDLATESTOPERAGGR"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More