P_ENGMTPROJACTUALAGGRG

CDS View

P_ENGMTPROJACTUALAGGRG is a CDS View in S/4HANA. It contains 6 fields. 1 CDS views read from this table.

Used by 1 CDS view(s) 6 fields

CDS Views using this table (1)

ViewTypeJoinVDMDescription
P_EngmtProjActlCnvrsn view inner COMPOSITE

Fields (6)

KeyField CDS FieldsUsed in Views
KEY Project Project 1
CompanyCode CompanyCode,PartnerCompanyCode 1
ControllingArea ControllingArea 1
CostCenter CostCenter,PartnerCostCenter 1
IsMyProject IsMyProject 1
ProjectManagerName ProjectManagerName 1 
@AbapCatalog.preserveKey: true
@AbapCatalog: {
   sqlViewName: 'PENGPROJACTLAGG',
   compiler.compareFilter: true
}
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ClientHandling.algorithm: #SESSION_VARIABLE
@Metadata.ignorePropagatedAnnotations: true
@ObjectModel.usageType: {
  serviceQuality: #B,
  sizeCategory: #XL,
  dataClass: #TRANSACTIONAL
}
@VDM: {
  viewType: #COMPOSITE,
  private: true,
  lifecycle.contract.type: #NONE
}
//@EndUserText.label: 'Aggregate Engmnt Proj Actual'


define view P_EngmtProjActualAggrg
as select from P_ENGMTPROJACTUAL 
{ 
    key Project, 
    key WorkPackage,
    key Ledger,
    key FiscalYearPeriod, 
    key PostingDate, 
    key FiscalYear, 
    key FiscalPeriod,
    WBSElement, 
    ControllingObject, 
    WorkItem, 
    PartnerCompanyCode, 
    PartnerCostCenter, 
    SalesOrder, 
    SalesOrderItem, 
    Material,
    GLAccount, 
    ChartOfAccounts, 
    ControllingObjectDebitType, 
    BusinessTransactionType,  
    CurrentDate, 
    PartnerCostCtrActivityType, 
    
    CompanyCodeCurrency,
    
    sum(AmountInCompanyCodeCurrency) as AmountInCompanyCodeCurrency, 
    sum(AmountInPlanCurrency) as AmountInPlanCurrency, 
     
    ControllingObjectCurrency,
    
    sum (AmountInObjectCurrency)   as AmountInObjectCurrency,
    
    GlobalCurrency,
    
    sum(AmountInGlobalCurrency)  as AmountInGlobalCurrency,
       
    BaseUnit, 
    
    sum(Quantity)                   as Quantity,  
    CompanyCode, 
    CostCenter, 
    ControllingArea, 
    BillableControl,
    IsCommitment,
    IsMyProject,
    ProjectManagerName         
}  group by

    Project, 
    WBSElement, 
    ControllingObject, 
    WorkPackage, 
    WorkItem, 
    PartnerCompanyCode, 
    PartnerCostCenter,  
    SalesOrder, 
    SalesOrderItem, 
    Material,  
    GLAccount, 
    ChartOfAccounts, 
    ControllingObjectDebitType, 
    BusinessTransactionType, 
//    PersonnelNumber, 

    CurrentDate, 
    PartnerCostCtrActivityType,      
    FiscalYearPeriod, 
    PostingDate, 
    FiscalYear, 
    FiscalPeriod, 
    CompanyCodeCurrency,
    ControllingObjectCurrency,
    GlobalCurrency,
    BaseUnit, 
    Quantity,  
    CompanyCode, 
    CostCenter, 
    ControllingArea, 
    Ledger, 
    BillableControl,
    IsCommitment,
    IsMyProject,
    ProjectManagerName  
 
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"P_ENGMTPROJACTUAL"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More