@AbapCatalog.sqlViewName: 'PMAINTORDER'
@AccessControl.authorizationCheck: #NOT_REQUIRED
@VDM.viewType: #COMPOSITE
@VDM.private: true
@AbapCatalog.preserveKey:true
@AbapCatalog.compiler.compareFilter:true
@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel.usageType.serviceQuality: #A
@ObjectModel.usageType.sizeCategory: #XL
define view P_MAINTORDERBASICDATA as select from I_MaintenanceOrder
association [1..1] to I_WBSElementBasicData as _WBSElement on $projection.WBSElementInternalID = _WBSElement.WBSElementInternalID
association [1..1] to I_EnterpriseProject as _EnterpriseProject on $projection.projectinternalid = _EnterpriseProject.ProjectInternalID
{
key MaintenanceOrder,
MaintenanceOrderDesc as OrderDescription,
MaintenanceOrderInternalID,
MaintenanceOrderCategory,
_WBSElement.WBSElementObject as WBSElementObject,
WBSElementInternalID,
_WBSElement._Project.Project as project,
_WBSElement._Project.ProjectInternalID as projectinternalid,
_WBSElement._Project.ProjectObject as ProjectObject,
_WBSElement.CompanyCode,
_WBSElement.ProfitCenter,
_EnterpriseProject,
_WBSElement
}
where _WBSElement.WBSElementObject is not initial
and MaintenanceOrderCategory = '30'
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_MAINTENANCEORDER",
"I_PROJECTBASICDATA",
"I_WBSELEMENTBASICDATA"
],
"ASSOCIATED":
[
"I_ENTERPRISEPROJECT",
"I_WBSELEMENTBASICDATA"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/