@AbapCatalog: {
sqlViewName: 'PEPRSERORG',
compiler.compareFilter: true,
preserveKey: true
}
@VDM: {
viewType:#COMPOSITE,
private: true,
lifecycle.contract.type: #NONE
}
@AccessControl: {
authorizationCheck:#NOT_REQUIRED,
personalData.blocking: #NOT_REQUIRED
}
@ObjectModel: {
usageType.serviceQuality: #A,
usageType.sizeCategory: #S,
usageType.dataClass: #CUSTOMIZING
}
@ClientHandling.algorithm: #SESSION_VARIABLE
define view P_EngmntProjServiceOrg
as select from I_EngmntProjServiceOrg as A
{
key A.EngagementProjectServiceOrg,
@Semantics.booleanIndicator:true
A.EngmtProjServiceOrgIsSales,
@Semantics.booleanIndicator:true
A.EngmtProjServiceOrgIsDelivery,
A.RestrictedTimePosting,
max( A.EngmntProjectCompanyCode ) as EngmntProjectCompanyCode,
max( A.EngagementProjectCtrlgArea ) as EngagementProjectCtrlgArea,
max( A.EngagementProjectSalesOrg ) as EngagementProjectSalesOrg,
max( A.EngagementProjectDistrChnl ) as EngagementProjectDistrChnl,
max( A.EngagementProjectDivision ) as EngagementProjectDivision,
max( A.EngagementProjectPurchasingOrg ) as EngagementProjectPurchasingOrg,
max( A.EngagementProjectPlant ) as EngagementProjectPlant,
max( A.ServiceOrgDefaultCostCenter ) as ServiceOrgDefaultCostCenter
}
group by
A.EngagementProjectServiceOrg,
A.EngmtProjServiceOrgIsSales,
A.EngmtProjServiceOrgIsDelivery,
A.RestrictedTimePosting;