@AbapCatalog.sqlViewName: 'PORDITMSTSBASAGG'
@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 order item status per ObjectInternalID
// to be used in OrderItem views (join) only!
define view P_OrderItemStatusBasicAggrgn
as select from P_OrderItemStatusBasic
{
// Key
key ObjectInternalID,
// Status
cast(max(OrderItemIsCreated) as orderiscreated preserving type) as OrderItemIsCreated,
cast(max(OrderItemIsReleased) as orderisreleased preserving type) as OrderItemIsReleased,
cast(max(SettlementRuleIsCreated) as settlementruleiscreated preserving type) as SettlementRuleIsCreated,
cast(max(OrderItemIsClosed) as orderisclosed preserving type) as OrderItemIsClosed,
cast(max(OrderItemIsPartiallyDelivered) as ispartiallydelivered preserving type) as OrderItemIsPartiallyDelivered,
_StatusObject
}
group by
ObjectInternalID
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"P_ORDERITEMSTATUSBASIC"
],
"ASSOCIATED":
[
"I_STATUSOBJECT"
],
"BASE":
[
"P_ORDERITEMSTATUSBASIC"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/