P_EntProjElementBillingElement

DDL: P_ENTPROJELEMENTBILLINGELEMENT Type: view_entity COMPOSITE Package: ODATA_PPM_PRO_CTRL_PROFNL_SRVC

Project Element with Billing Element

P_EntProjElementBillingElement is a Composite CDS View that provides data about "Project Element with Billing Element" in SAP S/4HANA. It reads from 1 data source (I_EnterpriseProjectElement) and exposes 13 fields with key field ProjectElementUUID. It has 1 association to related views. Part of development package ODATA_PPM_PRO_CTRL_PROFNL_SRVC.

1 data source(s) 13 fields

Data Sources (1)

SourceAliasJoin Type
I_EnterpriseProjectElement ProjectElement from

Associations (1)

CardinalityTargetAliasCondition
[1..1] I_EnterpriseProject _EnterpriseProject _EnterpriseProject.ProjectUUID = $projection.ProjectUUID

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MIXED view
VDM.viewType #COMPOSITE view
VDM.private true view

Fields (13)

KeyFieldSource TableSource FieldDescription
KEY ProjectElementUUID I_EnterpriseProjectElement ProjectElementUUID
ProjectElement I_EnterpriseProjectElement ProjectElement
WBSElementInternalID I_EnterpriseProjectElement WBSElementInternalID
ProjectElementDescription I_EnterpriseProjectElement ProjectElementDescription
ProjectUUID I_EnterpriseProjectElement ProjectUUID
WBSElementExternalID BillingElement WBSElementExternalID
WBSDescription BillingElement WBSDescription
ProfitCenter BillingElement ProfitCenter
ControllingArea BillingElement ControllingArea
BillingPlanUsageCategoryName BillingElement BillingPlanUsageCategoryName
Product BillingElement Product
_EnterpriseProject _EnterpriseProject
_ProfitCenter BillingElement _ProfitCenter 
@AbapCatalog.viewEnhancementCategory: [#NONE]
@AccessControl.authorizationCheck: #NOT_REQUIRED
@Metadata.ignorePropagatedAnnotations: true
@ObjectModel.usageType:{
  serviceQuality: #B,
  sizeCategory: #L,
  dataClass: #MIXED
}
@VDM: {
  viewType:#COMPOSITE,
  private: true
}

define view entity P_EntProjElementBillingElement
  as select from           I_EnterpriseProjectElement    as ProjectElement
    left outer to one join I_EntProjProfnlSrvcBillgElmnt as BillingElement on  ProjectElement.ProjectUUID           = BillingElement.ProjectUUID
                                                                           and ProjectElement.LeadingSalesOrder     = BillingElement.SalesOrder
                                                                           and ProjectElement.LeadingSalesOrderItem = BillingElement.SalesOrderItem

  association [1..1] to I_EnterpriseProject as _EnterpriseProject on _EnterpriseProject.ProjectUUID = $projection.ProjectUUID
{
  key ProjectElement.ProjectElementUUID           as ProjectElementUUID,
      ProjectElement.ProjectElement               as ProjectElement,
      ProjectElement.WBSElementInternalID         as WBSElementInternalID,
      ProjectElement.ProjectElementDescription    as ProjectElementDescription,
      ProjectElement.ProjectUUID                  as ProjectUUID,
      BillingElement.WBSElementExternalID         as WBSElementExternalID,
      BillingElement.WBSDescription               as WBSDescription,
      BillingElement.ProfitCenter                 as ProfitCenter,
      BillingElement.ControllingArea              as ControllingArea,
      BillingElement.BillingPlanUsageCategoryName as BillingPlanUsageCategoryName,
      BillingElement.Product                      as Product,
      // Association

      _EnterpriseProject,
      BillingElement._ProfitCenter
}

where
  ProjectElement.WBSElementIsBillingElement = ''

Learn More