@AbapCatalog.sqlViewName: 'PORDCOMPSTSBAGGN'
@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 order component status per ObjectInternalID
// to be used in OrderOperationComponent views (join) only!
/*+[hideWarning] { "IDS" : [ "CALCULATED_FIELD_CHECK" ] } */
define view P_OrderOpCompStatusBasicAggrgn
as select from P_OrderOpCompStatusBasic
{
// Key
key ObjectInternalID,
// Status
cast(max(MaterialComponentIsCreated) as componentiscreated preserving type) as MaterialComponentIsCreated,
cast(max(MaterialComponentIsReleased) as componentisreleased preserving type) as MaterialComponentIsReleased,
cast(max(MaterialComponentIsPrinted) as componentisprinted preserving type) as MaterialComponentIsPrinted,
cast(max(MaterialComponentIsDeleted) as componentisdeleted preserving type) as MaterialComponentIsDeleted,
cast(max(MatlCompIsCreatedByOrderSplit) as iscrtedbyordersplit preserving type) as MatlCompIsCreatedByOrderSplit,
// Associations
_StatusObject,
_ComponentIsCreatedCode,
_ComponentIsReleasedCode,
_ComponentIsPrintedCode,
_ComponentIsDeletedCode,
_CompIsCreatedByOrderSplitCode
}
group by
ObjectInternalID
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"P_ORDEROPCOMPSTATUSBASIC"
],
"ASSOCIATED":
[
"I_STATUSCODE",
"I_STATUSOBJECT"
],
"BASE":
[
"P_ORDEROPCOMPSTATUSBASIC"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/