P_ENGMNTPROJSERVICEORG
Engagement Project Service Org
P_ENGMNTPROJSERVICEORG is a CDS View in S/4HANA. Engagement Project Service Org. It contains 12 fields. 1 CDS views read from this table.
CDS Views using this table (1)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| I_EngmntProjServiceOrgDetails | view | from | COMPOSITE | Engagement Project Service Org Details |
Fields (12)
| Key | Field | CDS Fields | Used in Views |
|---|---|---|---|
| KEY | EngagementProjectServiceOrg | EngagementProjectServiceOrg | 1 |
| EngagementProjectCtrlgArea | EngagementProjectCtrlgArea | 1 | |
| EngagementProjectDistrChnl | EngagementProjectDistrChnl | 1 | |
| EngagementProjectDivision | EngagementProjectDivision | 1 | |
| EngagementProjectPlant | EngagementProjectPlant | 1 | |
| EngagementProjectPurchasingOrg | EngagementProjectPurchasingOrg | 1 | |
| EngagementProjectSalesOrg | EngagementProjectSalesOrg | 1 | |
| EngmntProjectCompanyCode | EngmntProjectCompanyCode | 1 | |
| EngmtProjServiceOrgIsDelivery | EngmtProjServiceOrgIsDelivery | 1 | |
| EngmtProjServiceOrgIsSales | EngmtProjServiceOrgIsSales | 1 | |
| RestrictedTimePosting | RestrictedTimePosting | 1 | |
| ServiceOrgDefaultCostCenter | ServiceOrgDefaultCostCenter | 1 |
@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;