P_ORDEROPERATIONSTATUSBASICAGG

CDS View

Aggregated Main System Status of Order Operation

P_ORDEROPERATIONSTATUSBASICAGG is a CDS View in S/4HANA. Aggregated Main System Status of Order Operation. It contains 11 fields. 3 CDS views read from this table.

CDS Views using this table (3)

ViewTypeJoinVDMDescription
I_MfgOrderOperationCube view inner COMPOSITE Manufacturing Order Operation - Cube
I_MfgOrderOperationDelayBasic view inner COMPOSITE Manufacturing Order Operation Delay Basic Data
I_MfgOrderOperationWithStatus view inner COMPOSITE Manufacturing Order Operation with Status

Fields (11)

KeyField CDS FieldsUsed in Views
OperationIsClosed OperationIsClosed 2
OperationIsConfirmed OperationIsConfirmed 2
OperationIsCreated OperationIsCreated 2
OperationIsDeleted OperationIsDeleted 2
OperationIsDelivered OperationIsDelivered 2
OperationIsPartiallyConfirmed OperationIsPartiallyConfirmed 2
OperationIsPartiallyDelivered OperationIsPartiallyDelivered 2
OperationIsPrinted OperationIsPrinted 2
OperationIsReleased OperationIsReleased 2
OperationIsScheduled OperationIsScheduled 2
OperationIsTechlyCompleted OperationIsTechlyCompleted 2
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ObjectModel.usageType: {serviceQuality: #B, sizeCategory: #XL, dataClass: #TRANSACTIONAL}
@VDM.viewType: #COMPOSITE
@VDM.private: true
// provides the aggregated main operation status per ObjectInternalID

define view entity P_OrderOperationStatusBasicAgg
  as select from P_OrderOperationStatusBasic
{
      // Technical Key

  key ObjectInternalID,
      // Status

      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(OperationIsGenerated)          as OperationIsGenerated,
      max(OperationIsPartiallyDelivered) as OperationIsPartiallyDelivered,
      max(OperationIsDelivered)          as OperationIsDelivered,
      max(ControlRecipeIsCreated)        as ControlRecipeIsCreated
}
group by
  ObjectInternalID;