R_EnterpriseProjectBriefCost

DDL: R_ENTERPRISEPROJECTBRIEFCOST Type: view_entity COMPOSITE

Project Brief Cost Per Month

R_EnterpriseProjectBriefCost is a Composite CDS View that provides data about "Project Brief Cost Per Month" in SAP S/4HANA. It reads from 1 data source (R_EntProjBriefCostYearMonth) and exposes 14 fields with key fields ProjectUUID, ProjectInternalID, YearMonth, FunctionalArea.

1 data source(s) 14 fields

Data Sources (1)

SourceAliasJoin Type
R_EntProjBriefCostYearMonth _CostMonth from

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label Project Brief Cost Per Month view
Metadata.ignorePropagatedAnnotations true view
VDM.viewType #COMPOSITE view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.sizeCategory #XL view

Fields (14)

KeyFieldSource TableSource FieldDescription
KEY ProjectUUID R_EntProjBriefCostYearMonth ProjectUUID
KEY ProjectInternalID R_EntProjBriefCostYearMonth ProjectInternalID
KEY YearMonth R_EntProjBriefCostYearMonth YearMonth
KEY FunctionalArea R_EntProjBriefCostYearMonth FunctionalArea
Ledger R_EntProjBriefCostYearMonth Ledger
CompanyCode R_EntProjBriefCostYearMonth CompanyCode
ControllingArea R_EntProjBriefCostYearMonth ControllingArea
BusinessArea R_EntProjBriefCostYearMonth BusinessArea
ProfitCenter R_EntProjBriefCostYearMonth ProfitCenter
GlobalCurrency R_EntProjBriefCostYearMonth GlobalCurrency
CalendarYear R_EntProjBriefCostYearMonth CalendarYear
CalendarMonthName R_EntProjBriefCostYearMonth CalendarMonthName
ActualAmountInGlobalCurrency _ActualCostSum ActualAmountInGlobalCurrency
PlanAmountInGlobalCurrency _PlanCostSum AmountInGlobalCurrency 
@AbapCatalog.viewEnhancementCategory: [#NONE]
@AccessControl.authorizationCheck: #MANDATORY
@EndUserText.label: 'Project Brief Cost Per Month'
@Metadata.ignorePropagatedAnnotations: true
@VDM: {
    viewType: #COMPOSITE,
    lifecycle.contract.type: #SAP_INTERNAL_API
}
@ObjectModel.usageType:{
     serviceQuality:  #D,
     dataClass:       #MIXED,
     sizeCategory:    #XL
}

define view entity R_EnterpriseProjectBriefCost as select from R_EntProjBriefCostYearMonth as _CostMonth
  left outer to one join R_EntProjBriefCostActual as _ActualCostSum on _ActualCostSum.ProjectInternalID = _CostMonth.ProjectInternalID
                                                          and _ActualCostSum.YearMonth = _CostMonth.YearMonth
  left outer to one join R_EntProjBriefCostPlan as _PlanCostSum on _PlanCostSum.ProjectInternalID = _CostMonth.ProjectInternalID
                                                          and _PlanCostSum.YearMonth = _CostMonth.YearMonth
  
{

  key _CostMonth.ProjectUUID,
  
  key _CostMonth.ProjectInternalID,
  
  key _CostMonth.YearMonth,
  
  key _CostMonth.FunctionalArea,
      
      _CostMonth.Ledger,
    
      _CostMonth.CompanyCode,
      
      _CostMonth.ControllingArea,
      
      _CostMonth.BusinessArea,
      
      _CostMonth.ProfitCenter,
    
      _CostMonth.GlobalCurrency,
      
      _CostMonth.CalendarYear,
      
      _CostMonth.CalendarMonthName,
      
      @Semantics.amount.currencyCode: 'GlobalCurrency'
      _ActualCostSum.ActualAmountInGlobalCurrency as ActualAmountInGlobalCurrency,
      
      @Semantics.amount.currencyCode: 'GlobalCurrency'
      _PlanCostSum.AmountInGlobalCurrency as PlanAmountInGlobalCurrency
  
}

/*+[internal] {
"BASEINFO":
{
"FROM":
[
"R_ENTPROJBRIEFCOSTACTUAL",
"R_ENTPROJBRIEFCOSTPLAN",
"R_ENTPROJBRIEFCOSTYEARMONTH"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More