@AbapCatalog.sqlViewName: 'PFUNCLOCSTATAGGR'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel.usageType: {serviceQuality: #B, sizeCategory: #XL, dataClass: #TRANSACTIONAL}
@VDM.viewType: #COMPOSITE // technically a BASIC but due to view layering a COMPOSITE)
@VDM.private: true
define view P_FuncnlLocStatusAggrgn as select from P_FunctionalLocationStatus as _FuncnlLocStatus
{
key _FuncnlLocStatus.FunctionalLocation,
_FuncnlLocStatus.MaintObjectInternalID,
max(FuncnlLocIsMarkedForDeletion) as FuncnlLocIsMarkedForDeletion,
max(FuncnlLocIsDeleted) as FuncnlLocIsDeleted,
max(FunctionalLocationIsActive) as FunctionalLocationIsActive,
max(FunctionalLocationIsCreated) as FunctionalLocationIsCreated, //Added : 2308
max(FuncnlLocIsDeactivated) as FuncnlLocIsDeactivated
}group by
FunctionalLocation,
MaintObjectInternalID
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"P_FUNCTIONALLOCATIONSTATUS"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/