P_ORDEROPERATIONSTATUSBASICAGG
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)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| 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)
| Key | Field | CDS Fields | Used 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;