I_ProjectBillingElement

DDL: I_PROJECTBILLINGELEMENT Type: view_entity BASIC

Project Billing Element

I_ProjectBillingElement is a Basic CDS View that provides data about "Project Billing Element" in SAP S/4HANA. It reads from 1 data source (projbillgelmnt) and exposes 13 fields with key field ProjectBillingElementUUID. It has 2 associations to related views.

1 data source(s) 13 fields

Data Sources (1)

SourceAliasJoin Type
projbillgelmnt ProjectBillingElement from

Associations (2)

CardinalityTargetAliasCondition
[0..*] I_ProjectBillingElementEntry _ProjectBillingElementEntry $projection.ProjectBillingElementUUID = _ProjectBillingElementEntry.ProjectBillingElementUUID
[0..1] I_WBSElementBasicData _WBSElement $projection.BillingWBSElementInternalID = _WBSElement.WBSElementInternalID and _WBSElement.WBSElementIsBillingElement = 'X'

Annotations (12)

NameValueLevelField
EndUserText.label Project Billing Element view
VDM.lifecycle.contract.type #PUBLIC_LOCAL_API view
VDM.viewType #BASIC view
AccessControl.authorizationCheck #CHECK view
Analytics.dataExtraction.enabled true view
Analytics.dataExtraction.delta.changeDataCapture.automatic true view
ObjectModel.modelingPattern #ANALYTICAL_DIMENSION view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.representativeKey ProjectBillingElementUUID view
Metadata.ignorePropagatedAnnotations true view

Fields (13)

KeyFieldSource TableSource FieldDescription
KEY ProjectBillingElementUUID projbillgelmnt projectbillingelementuuid
BillingWBSElementInternalID projbillgelmnt billingwbselementinternalid
DocumentCurrency projbillgelmnt documentcurrency
BilledRevenueAmtInDocCrcy projbillgelmnt billedrevenueamtindoccrcy
WrittenOffRevenueAmtInDocCrcy projbillgelmnt writtenoffrevenueamtindoccrcy
ProjBillingProfile projbillgelmnt projbillingprofile
ProjectBillingCategory projbillgelmnt projectbillingcategory
ProjBillgElmntCreatedByUser projbillgelmnt projbillgelmntcreatedbyuser
ProjBillgElmntCreatedAtDteTme projbillgelmnt projbillgelmntcreatedatdtetme
ProjBillgElmntLastChgdByUser projbillgelmnt projbillgelmntlastchgdbyuser
ProjBillgElmntLastChgdAtDteTme projbillgelmnt projbillgelmntlastchgdatdtetme
_ProjectBillingElementEntry _ProjectBillingElementEntry
_WBSElement _WBSElement 
@EndUserText.label: 'Project Billing Element'
@VDM.lifecycle.contract.type: #PUBLIC_LOCAL_API
@VDM.viewType: #BASIC
@AccessControl.authorizationCheck: #CHECK
@Analytics.dataExtraction.enabled: true
@Analytics.dataExtraction.delta.changeDataCapture.automatic: true
@ObjectModel: {
    modelingPattern: #ANALYTICAL_DIMENSION,
    supportedCapabilities: [ #SQL_DATA_SOURCE, #CDS_MODELING_DATA_SOURCE, #CDS_MODELING_ASSOCIATION_TARGET, #ANALYTICAL_DIMENSION, #EXTRACTION_DATA_SOURCE  ],
    usageType: {
        sizeCategory: #M,
        dataClass:  #TRANSACTIONAL,
        serviceQuality: #A
    },
    representativeKey: 'ProjectBillingElementUUID'
}
@Metadata.ignorePropagatedAnnotations: true

define view entity I_ProjectBillingElement
  as select from projbillgelmnt as ProjectBillingElement
  association [0..*] to I_ProjectBillingElementEntry as _ProjectBillingElementEntry on  $projection.ProjectBillingElementUUID = _ProjectBillingElementEntry.ProjectBillingElementUUID
  association [0..1] to I_WBSElementBasicData        as _WBSElement                 on  $projection.BillingWBSElementInternalID = _WBSElement.WBSElementInternalID
                                                                                    and _WBSElement.WBSElementIsBillingElement  = 'X'
{
  key ProjectBillingElement.projectbillingelementuuid      as ProjectBillingElementUUID,
      ProjectBillingElement.billingwbselementinternalid    as BillingWBSElementInternalID,
      ProjectBillingElement.documentcurrency               as DocumentCurrency,
      @Semantics.amount.currencyCode: 'DocumentCurrency'
      ProjectBillingElement.billedrevenueamtindoccrcy      as BilledRevenueAmtInDocCrcy,
      @Semantics.amount.currencyCode: 'DocumentCurrency'
      ProjectBillingElement.writtenoffrevenueamtindoccrcy  as WrittenOffRevenueAmtInDocCrcy,
      ProjectBillingElement.projbillingprofile             as ProjBillingProfile,
      ProjectBillingElement.projectbillingcategory         as ProjectBillingCategory,
      @Semantics.user.createdBy: true
      ProjectBillingElement.projbillgelmntcreatedbyuser    as ProjBillgElmntCreatedByUser,
      @Semantics.systemDateTime.createdAt: true
      ProjectBillingElement.projbillgelmntcreatedatdtetme  as ProjBillgElmntCreatedAtDteTme,
      @Semantics.user.lastChangedBy: true
      ProjectBillingElement.projbillgelmntlastchgdbyuser   as ProjBillgElmntLastChgdByUser,
      @Semantics.systemDateTime.lastChangedAt: true
      ProjectBillingElement.projbillgelmntlastchgdatdtetme as ProjBillgElmntLastChgdAtDteTme,

      _ProjectBillingElementEntry,
      _WBSElement
}

Learn More