I_ProjectBillingElementEntry

DDL: I_PROJECTBILLINGELEMENTENTRY Type: view_entity BASIC

Entries for Project Billing Element

I_ProjectBillingElementEntry is a Basic CDS View that provides data about "Entries for Project Billing Element" in SAP S/4HANA. It reads from 1 data source (projblgelmntentr) and exposes 60 fields with key field ProjBillgElmntEntrItmUUID. It has 6 associations to related views.

1 data source(s) 60 fields

Data Sources (1)

SourceAliasJoin Type
projblgelmntentr ProjectBillingElementEntry from

Associations (6)

CardinalityTargetAliasCondition
[0..1] I_Material _Material $projection.Material = _Material.Material
[1..1] I_ProjectBillingElement _ProjectBillingElement $projection.ProjectBillingElementUUID = _ProjectBillingElement.ProjectBillingElementUUID
[0..*] I_ProjectBillingElementEntrFlw _ProjectBillingElementEntrFlw $projection.ProjBillgElmntEntrItmUUID = _ProjectBillingElementEntrFlw.ProjBillgElmntEntrItmUUID
[0..1] I_PrjBlgElmEntrJrnlEntrLink _PrjBlgElmEntrJrnlEntrLink $projection.ProjBillgElmntEntrItmUUID = _PrjBlgElmEntrJrnlEntrLink.ProjBillgElmntEntrItmUUID
[0..1] I_PrjBlgElmEntrBillgPlnLink _PrjBlgElmEntrBillgPlnLink $projection.ProjBillgElmntEntrItmUUID = _PrjBlgElmEntrBillgPlnLink.ProjBillgElmntEntrItmUUID
[0..1] I_WBSElementBasicData _WBSElement $projection.WBSElementInternalID = _WBSElement.WBSElementInternalID

Annotations (11)

NameValueLevelField
EndUserText.label Entries for 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
ObjectModel.modelingPattern #ANALYTICAL_DIMENSION view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.representativeKey ProjBillgElmntEntrItmUUID view
Metadata.ignorePropagatedAnnotations true view

Fields (60)

KeyFieldSource TableSource FieldDescription
KEY ProjBillgElmntEntrItmUUID projblgelmntentr projbillgelmntentritmuuid
ProjectBillingElementUUID projblgelmntentr projectbillingelementuuid
ProjBillgElmntEntrSourceType projblgelmntentr projbillgelmntentrsourcetype
WBSElementInternalID projblgelmntentr wbselementinternalid
Material projblgelmntentr material
QuantityUnit projblgelmntentr quantityunit
ProjBillgElmntEntrIsCancelled projblgelmntentr projbillgelmntentriscancelled
PricingDate projblgelmntentr pricingdate
NetPriceAmountIsManual projblgelmntentr netpriceamountismanual
TransactionCurrency projblgelmntentr transactioncurrency
ProjectCurrency projblgelmntentr projectcurrency
GlobalCurrency projblgelmntentr globalcurrency
DocumentCurrency _ProjectBillingElement DocumentCurrency
ServicesRenderedDate projblgelmntentr servicesrendereddate
OriginalTotalQuantity projblgelmntentr originaltotalquantity
OriginalAmountInTransacCrcy projblgelmntentr originalamountintransaccrcy
OriginalAmountInProjectCrcy projblgelmntentr originalamountinprojectcrcy
OriginalAmountInGlobalCurrency projblgelmntentr originalamountinglobalcurrency
OpenQuantity projblgelmntentr openquantity
OpenAmountInTransCrcy projblgelmntentr openamountintranscrcy
OpenAmountInProjectCurrency projblgelmntentr openamountinprojectcurrency
OpenAmountInGlobalCurrency projblgelmntentr openamountinglobalcurrency
ToBeBilledQuantity projblgelmntentr tobebilledquantity
ToBeBilledAmtInTransCrcy projblgelmntentr tobebilledamtintranscrcy
ToBeBilledAmtInProjCurrency projblgelmntentr tobebilledamtinprojcurrency
ToBeBilledAmtInGlobCurrency projblgelmntentr tobebilledamtinglobcurrency
ToBeWrittenOffQuantity projblgelmntentr tobewrittenoffquantity
ToBeWrittenOffAmtInTransCrcy projblgelmntentr tobewrittenoffamtintranscrcy
ToBeWrittenOffAmtInProjectCrcy projblgelmntentr tobewrittenoffamtinprojectcrcy
ToBeWrittenOffAmtInGlobalCrcy projblgelmntentr tobewrittenoffamtinglobalcrcy
ToBePostponedQuantity projblgelmntentr tobepostponedquantity
ToBePostponedAmtInTransacCrcy projblgelmntentr tobepostponedamtintransaccrcy
ToBePostponedAmtInProjectCrcy projblgelmntentr tobepostponedamtinprojectcrcy
ToBePostponedAmtInGlobalCrcy projblgelmntentr tobepostponedamtinglobalcrcy
BillableRevenueAmtInDocCrcy projblgelmntentr billablerevenueamtindoccrcy
ManualNetPriceAmtInDocCrcy projblgelmntentr manualnetpriceamtindoccrcy
NetPriceAmountInDocCrcy projblgelmntentr netpriceamountindoccrcy
NetPriceQuantity projblgelmntentr netpricequantity
NetPriceQuantityUnit projblgelmntentr netpricequantityunit
OriginalRevenueAmtInDocCrcy projblgelmntentr originalrevenueamtindoccrcy
OpenRevenueAmtInDocCrcy projblgelmntentr openrevenueamtindoccrcy
ProjBillgElmntEntrIsReversed projblgelmntentr projbillgelmntentrisreversed
ProjBillgElmntEntrIsReversal projblgelmntentr projbillgelmntentrisreversal
PrjBlgElmEntrCanclnSrceCode projblgelmntentr prjblgelmentrcanclnsrcecode
PrjBlgElmEntrCreatedByUser projblgelmntentr prjblgelmentrcreatedbyuser
PrjBlgElmEntrCreatedAtDteTme projblgelmntentr prjblgelmentrcreatedatdtetme
PrjBlgElmEntrLastChgdByUser projblgelmntentr prjblgelmentrlastchgdbyuser
PrjBlgElmEntrLastChgdAtDteTme projblgelmntentr prjblgelmentrlastchgdatdtetme
PrjBlgElmEntryLongText projblgelmntentr prjblgelmentrylongtext
ProjectBillingElementEntryDesc projblgelmntentr projectbillingelemententrydesc
ProjBillgTransfCostQtyCode projblgelmntentr projbillgtransfcostqtycode
ProjBillgItmValIsNotActualCost projblgelmntentr projbillgitmvalisnotactualcost
ProjBillgElementEntryObject projblgelmntentr projbillgelemententryobject
PostingDate projblgelmntentr postingdate
_ProjectBillingElement _ProjectBillingElement
_ProjectBillingElementEntrFlw _ProjectBillingElementEntrFlw
_PrjBlgElmEntrJrnlEntrLink _PrjBlgElmEntrJrnlEntrLink
_PrjBlgElmEntrBillgPlnLink _PrjBlgElmEntrBillgPlnLink
_Material _Material
_WBSElement _WBSElement 
@EndUserText.label: 'Entries for Project Billing Element'
@VDM.lifecycle.contract.type: #PUBLIC_LOCAL_API
@VDM.viewType: #BASIC
@AccessControl.authorizationCheck: #CHECK
@Analytics.dataExtraction.enabled: true
@Analytics.dataExtraction.delta.changeDataCapture.mapping: [{
                                                        table: 'PROJBLGELMNTENTR',
                                                        role: #MAIN,
                                                        viewElement: ['ProjBillgElmntEntrItmUUID'],
                                                        tableElement: ['projbillgelmntentritmuuid']
}]
@ObjectModel: {
    modelingPattern: #ANALYTICAL_DIMENSION,
    supportedCapabilities: [ #SQL_DATA_SOURCE, #CDS_MODELING_DATA_SOURCE, #CDS_MODELING_ASSOCIATION_TARGET, #ANALYTICAL_DIMENSION, #EXTRACTION_DATA_SOURCE ],
    usageType:{
       sizeCategory: #L,
       dataClass:  #TRANSACTIONAL,
       serviceQuality: #A
    },
    representativeKey: 'ProjBillgElmntEntrItmUUID'
}
@Metadata.ignorePropagatedAnnotations: true

define view entity I_ProjectBillingElementEntry
  as select from projblgelmntentr as ProjectBillingElementEntry
  association [0..1] to I_Material                     as _Material                     on $projection.Material = _Material.Material
  association [1..1] to I_ProjectBillingElement        as _ProjectBillingElement        on $projection.ProjectBillingElementUUID = _ProjectBillingElement.ProjectBillingElementUUID
  association [0..*] to I_ProjectBillingElementEntrFlw as _ProjectBillingElementEntrFlw on $projection.ProjBillgElmntEntrItmUUID = _ProjectBillingElementEntrFlw.ProjBillgElmntEntrItmUUID
  association [0..1] to I_PrjBlgElmEntrJrnlEntrLink    as _PrjBlgElmEntrJrnlEntrLink    on $projection.ProjBillgElmntEntrItmUUID = _PrjBlgElmEntrJrnlEntrLink.ProjBillgElmntEntrItmUUID
  association [0..1] to I_PrjBlgElmEntrBillgPlnLink    as _PrjBlgElmEntrBillgPlnLink    on $projection.ProjBillgElmntEntrItmUUID = _PrjBlgElmEntrBillgPlnLink.ProjBillgElmntEntrItmUUID
  association [0..1] to I_WBSElementBasicData          as _WBSElement                   on $projection.WBSElementInternalID = _WBSElement.WBSElementInternalID

{
  key ProjectBillingElementEntry.projbillgelmntentritmuuid      as ProjBillgElmntEntrItmUUID,
      ProjectBillingElementEntry.projectbillingelementuuid      as ProjectBillingElementUUID,
      ProjectBillingElementEntry.projbillgelmntentrsourcetype   as ProjBillgElmntEntrSourceType,
      ProjectBillingElementEntry.wbselementinternalid           as WBSElementInternalID,
      ProjectBillingElementEntry.material                       as Material,
      ProjectBillingElementEntry.quantityunit                   as QuantityUnit,
      ProjectBillingElementEntry.projbillgelmntentriscancelled  as ProjBillgElmntEntrIsCancelled,
      ProjectBillingElementEntry.pricingdate                    as PricingDate,
      ProjectBillingElementEntry.netpriceamountismanual         as NetPriceAmountIsManual,
      ProjectBillingElementEntry.transactioncurrency            as TransactionCurrency,
      ProjectBillingElementEntry.projectcurrency                as ProjectCurrency,
      ProjectBillingElementEntry.globalcurrency                 as GlobalCurrency,
      _ProjectBillingElement.DocumentCurrency                   as DocumentCurrency,
      ProjectBillingElementEntry.servicesrendereddate           as ServicesRenderedDate,
      @Semantics.quantity.unitOfMeasure: 'QuantityUnit'
      ProjectBillingElementEntry.originaltotalquantity          as OriginalTotalQuantity,
      @Semantics.amount.currencyCode: 'TransactionCurrency'
      ProjectBillingElementEntry.originalamountintransaccrcy    as OriginalAmountInTransacCrcy,
      @Semantics.amount.currencyCode: 'ProjectCurrency'
      ProjectBillingElementEntry.originalamountinprojectcrcy    as OriginalAmountInProjectCrcy,
      @Semantics.amount.currencyCode: 'GlobalCurrency'
      ProjectBillingElementEntry.originalamountinglobalcurrency as OriginalAmountInGlobalCurrency,
      @Semantics.quantity.unitOfMeasure: 'QuantityUnit'
      ProjectBillingElementEntry.openquantity                   as OpenQuantity,
      @Semantics.amount.currencyCode: 'TransactionCurrency'
      ProjectBillingElementEntry.openamountintranscrcy          as OpenAmountInTransCrcy,
      @Semantics.amount.currencyCode: 'ProjectCurrency'
      ProjectBillingElementEntry.openamountinprojectcurrency    as OpenAmountInProjectCurrency,
      @Semantics.amount.currencyCode: 'GlobalCurrency'
      ProjectBillingElementEntry.openamountinglobalcurrency     as OpenAmountInGlobalCurrency,
      @Semantics.quantity.unitOfMeasure: 'QuantityUnit'
      ProjectBillingElementEntry.tobebilledquantity             as ToBeBilledQuantity,
      @Semantics.amount.currencyCode: 'TransactionCurrency'
      ProjectBillingElementEntry.tobebilledamtintranscrcy       as ToBeBilledAmtInTransCrcy,
      @Semantics.amount.currencyCode: 'ProjectCurrency'
      ProjectBillingElementEntry.tobebilledamtinprojcurrency    as ToBeBilledAmtInProjCurrency,
      @Semantics.amount.currencyCode: 'GlobalCurrency'
      ProjectBillingElementEntry.tobebilledamtinglobcurrency    as ToBeBilledAmtInGlobCurrency,
      @Semantics.quantity.unitOfMeasure: 'QuantityUnit'
      ProjectBillingElementEntry.tobewrittenoffquantity         as ToBeWrittenOffQuantity,
      @Semantics.amount.currencyCode: 'TransactionCurrency'
      ProjectBillingElementEntry.tobewrittenoffamtintranscrcy   as ToBeWrittenOffAmtInTransCrcy,
      @Semantics.amount.currencyCode: 'ProjectCurrency'
      ProjectBillingElementEntry.tobewrittenoffamtinprojectcrcy as ToBeWrittenOffAmtInProjectCrcy,
      @Semantics.amount.currencyCode: 'GlobalCurrency'
      ProjectBillingElementEntry.tobewrittenoffamtinglobalcrcy  as ToBeWrittenOffAmtInGlobalCrcy,
      @Semantics.quantity.unitOfMeasure: 'QuantityUnit'
      ProjectBillingElementEntry.tobepostponedquantity          as ToBePostponedQuantity,
      @Semantics.amount.currencyCode: 'TransactionCurrency'
      ProjectBillingElementEntry.tobepostponedamtintransaccrcy  as ToBePostponedAmtInTransacCrcy,
      @Semantics.amount.currencyCode: 'ProjectCurrency'
      ProjectBillingElementEntry.tobepostponedamtinprojectcrcy  as ToBePostponedAmtInProjectCrcy,
      @Semantics.amount.currencyCode: 'GlobalCurrency'
      ProjectBillingElementEntry.tobepostponedamtinglobalcrcy   as ToBePostponedAmtInGlobalCrcy,
      @Semantics.amount.currencyCode: 'DocumentCurrency'
      ProjectBillingElementEntry.billablerevenueamtindoccrcy    as BillableRevenueAmtInDocCrcy,
      @Semantics.amount.currencyCode: 'DocumentCurrency'
      ProjectBillingElementEntry.manualnetpriceamtindoccrcy     as ManualNetPriceAmtInDocCrcy,
      @Semantics.amount.currencyCode: 'DocumentCurrency'
      ProjectBillingElementEntry.netpriceamountindoccrcy        as NetPriceAmountInDocCrcy,
      @Semantics.quantity.unitOfMeasure: 'NetPriceQuantityUnit'
      ProjectBillingElementEntry.netpricequantity               as NetPriceQuantity,
      ProjectBillingElementEntry.netpricequantityunit           as NetPriceQuantityUnit,
      @Semantics.amount.currencyCode: 'DocumentCurrency'
      ProjectBillingElementEntry.originalrevenueamtindoccrcy    as OriginalRevenueAmtInDocCrcy,
      @Semantics.amount.currencyCode: 'DocumentCurrency'
      ProjectBillingElementEntry.openrevenueamtindoccrcy        as OpenRevenueAmtInDocCrcy,

      ProjectBillingElementEntry.projbillgelmntentrisreversed   as ProjBillgElmntEntrIsReversed,
      ProjectBillingElementEntry.projbillgelmntentrisreversal   as ProjBillgElmntEntrIsReversal,
      ProjectBillingElementEntry.prjblgelmentrcanclnsrcecode    as PrjBlgElmEntrCanclnSrceCode,

      @Semantics.user.createdBy: true
      ProjectBillingElementEntry.prjblgelmentrcreatedbyuser     as PrjBlgElmEntrCreatedByUser,
      @Semantics.systemDateTime.createdAt: true
      ProjectBillingElementEntry.prjblgelmentrcreatedatdtetme   as PrjBlgElmEntrCreatedAtDteTme,
      @Semantics.user.lastChangedBy: true
      ProjectBillingElementEntry.prjblgelmentrlastchgdbyuser    as PrjBlgElmEntrLastChgdByUser,
      @Semantics.systemDateTime.lastChangedAt: true
      ProjectBillingElementEntry.prjblgelmentrlastchgdatdtetme  as PrjBlgElmEntrLastChgdAtDteTme,
      ProjectBillingElementEntry.prjblgelmentrylongtext         as PrjBlgElmEntryLongText,
      ProjectBillingElementEntry.projectbillingelemententrydesc as ProjectBillingElementEntryDesc,
      ProjectBillingElementEntry.projbillgtransfcostqtycode     as ProjBillgTransfCostQtyCode,
      ProjectBillingElementEntry.projbillgitmvalisnotactualcost as ProjBillgItmValIsNotActualCost,
      ProjectBillingElementEntry.projbillgelemententryobject    as ProjBillgElementEntryObject,
      ProjectBillingElementEntry.postingdate                    as PostingDate,
      
      _ProjectBillingElement,
      _ProjectBillingElementEntrFlw,
      _PrjBlgElmEntrJrnlEntrLink,
      _PrjBlgElmEntrBillgPlnLink,
      _Material,
      _WBSElement
}

Learn More