I_ORDEROPERATIONSTATUS

CDS View

Order Operation Status

I_ORDEROPERATIONSTATUS is a CDS View in S/4HANA. Order Operation Status. It contains 4 fields. 3 CDS views read from this table.

Used by 3 CDS view(s) 4 fields

CDS Views using this table (3)

ViewTypeJoinVDMDescription
I_MfgOrderOperationDataList view inner COMPOSITE Mfg Order Sub-/Operation (Data List)
I_MfgOrderOperationPickList view inner COMPOSITE Mfg Order Operation (Pick List)
P_MfgProcgExecOrdOpMainStatus view from CONSUMPTION

Fields (4)

KeyField CDS FieldsUsed in Views
KEY OrderInternalID OrderInternalID 1
KEY OrderOperationInternalID OrderOperationInternalID 1
ObjectInternalID StatusObject 1
OperationIsReleased OperationIsReleased 1 
@AbapCatalog.sqlViewName: 'IPPORDEROPSTS'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #MANDATORY
@AccessControl.personalData.blocking: #NOT_REQUIRED
@Analytics.dataCategory: #DIMENSION
@ClientHandling.algorithm: #SESSION_VARIABLE
@Metadata.allowExtensions: true
@ObjectModel.modelingPattern: #NONE
@ObjectModel.supportedCapabilities: [#CDS_MODELING_DATA_SOURCE, #SQL_DATA_SOURCE]
@ObjectModel.representativeKey: 'OrderOperationInternalID'
@ObjectModel.usageType: {serviceQuality: #C, sizeCategory: #XL, dataClass: #TRANSACTIONAL}
@VDM.viewType: #COMPOSITE
@EndUserText.label: 'Order Operation Status'
// provides the aggregated system status per order operation 

define view I_OrderOperationStatus
  as select from P_OrderOperationStatus

--  association [1..1] to I_OrderInternalID as _OrderInternalID on $projection.OrderInternalID = _OrderInternalID.OrderInternalID
{
      // Technical Key

      @ObjectModel.foreignKey.association: '_OrderInternalID'
  key OrderInternalID,
  key OrderOperationInternalID,
      
      Plant,  // for DCLS


      // Status

      ObjectInternalID,
      max(OperationIsCreated)            as OperationIsCreated,
      max(OperationIsReleased)           as OperationIsReleased,
      max(OperationIsPrinted)            as OperationIsPrinted,
      max(OperationIsConfirmed)          as OperationIsConfirmed,
      max(OperationIsPartiallyConfirmed) as OperationIsPartiallyConfirmed,
      max(OperationIsDeleted)            as OperationIsDeleted,
      max(OperationIsTechlyCompleted)    as OperationIsTechlyCompleted,
      max(OperationIsClosed)             as OperationIsClosed,
      max(OperationIsConfdByMilestone)   as OperationIsConfdByMilestone,
      max(OperationIsManuallyConfirmed)  as OperationIsManuallyConfirmed,
      max(OperationIsScheduled)          as OperationIsScheduled,
      max(OperationIsPartiallyDelivered) as OperationIsPartiallyDelivered,
      max(OperationIsDelivered)          as OperationIsDelivered,
      
      // Associations

      _OrderInternalID      
}
group by
  OrderInternalID,
  OrderOperationInternalID,
  Plant,
  ObjectInternalID;
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"P_ORDEROPERATIONSTATUS"
],
"ASSOCIATED":
[
"I_ORDERINTERNALID"
],
"BASE":
[
"P_ORDEROPERATIONSTATUS"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More