@AbapCatalog.sqlViewName: 'PPPORDEROPSTSA'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel.usageType: {serviceQuality: #B, sizeCategory: #XL, dataClass: #TRANSACTIONAL}
@VDM.viewType: #COMPOSITE
@VDM.private: true
// provides the aggregated main operation status per ObjectInternalID
define view 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;
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"P_ORDEROPERATIONSTATUSBASIC"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/