I_PROJECTBILLINGELEMENT

CDS View

Project Billing Element

I_PROJECTBILLINGELEMENT is a CDS View in S/4HANA. Project Billing Element. It contains 13 fields. 14 CDS views read from this table.

Used by 14 CDS view(s) 13 fields

CDS Views using this table (14)

ViewTypeJoinVDMDescription
C_ProjBillgReqWrkPckgWrkItmVH view_entity inner CONSUMPTION Work Item Work Package
I_EntProjProfnlSrvcBillgElmnt view_entity inner COMPOSITE Billing Elements of Projects
I_ProjectBillingElementTP view_entity from TRANSACTIONAL Details of Billing Element
I_ProjectBillingElmntDueDate view_entity from COMPOSITE Billing Due Date of Billing Element
P_EvtBsdRevnRecgnProjWipJrnAmt view from COMPOSITE
P_PrjBlgElmBllbleRevnAmt view_entity from COMPOSITE Billable Revenue Amt for Billing Elmnt
P_PrjBlgElmRevnAmount view_entity from CONSUMPTION Calculated Amounts for Billing Element
P_ProjBillgElmntForPrjBlgReq view_entity inner CONSUMPTION Additional information in PBR
P_ProjBillgElmntSalesDets2 view_entity from COMPOSITE Project Billing Elements
P_ProjBillingElementEntrFlw00 view inner COMPOSITE
P_ProjBillingElmntAllBillDate view_entity from COMPOSITE Project Billing Element Date = 99991231
P_ProjBillingElmntAllBillDate2 view_entity from COMPOSITE Proj. Billg Element Date = 99991231 (2)
P_ProjBillingElmntBillngDate view_entity from COMPOSITE
R_ProjectBillingElementTP view_entity from TRANSACTIONAL Details of Billing Element

Fields (13)

KeyField CDS FieldsUsed in Views
KEY ProjectBillingElementUUID ProjectBillingElementUUID 11
_ProjectBillingElementEntry _ProjectBillingElementEntry 1
_WBSElement _WBSElement 2
BilledRevenueAmtInDocCrcy BilledRevenueAmtInDocCrcy 3
BillingWBSElementInternalID BillingWBSElementInternalID,WBSElementInternalID 5
DocumentCurrency DocumentCurrency 5
ProjBillgElmntCreatedAtDteTme ProjBillgElmntCreatedAtDteTme 2
ProjBillgElmntCreatedByUser ProjBillgElmntCreatedByUser 2
ProjBillgElmntLastChgdAtDteTme ProjBillgElmntLastChgdAtDteTme 2
ProjBillgElmntLastChgdByUser ProjBillgElmntLastChgdByUser 2
ProjBillingProfile ProjBillingProfile 1
ProjectBillingCategory ProjectBillingCategory 1
WrittenOffRevenueAmtInDocCrcy WrittenOffRevenueAmtInDocCrcy 3 
@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
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"PROJBILLGELMNT"
],
"ASSOCIATED":
[
"I_PROJECTBILLINGELEMENTENTRY",
"I_WBSELEMENTBASICDATA"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More