I_PROJECTBILLINGELEMENTENTRY

CDS View

Entries for Project Billing Element

I_PROJECTBILLINGELEMENTENTRY is a CDS View in S/4HANA. Entries for Project Billing Element. It contains 55 fields. 8 CDS views read from this table.

Used by 8 CDS view(s) 55 fields

CDS Views using this table (8)

ViewTypeJoinVDMDescription
C_ProjBillingReqDetsForWrkflw view_entity inner CONSUMPTION Aggregation for PBRI details
I_ProjectBillingElementEntryTP view_entity from TRANSACTIONAL Entry Details of Billing Element
I_WrittenOffPrjBlgElmEntrDets view inner COMPOSITE Details for Written off items
P_EvtBsdRevnRecgnProjWIPBeeFlw view from COMPOSITE
P_PrjBlgElmBillingReqRevnAmt view inner COMPOSITE Billing Requested Amt for Billing Elmnt
P_PrjBlgElmntToBillAmtSrvcDte view_entity from COMPOSITE ToBill Amt for Prj.Bil.Elmnt by Srvc.Dte
P_ProjBillingElementEntrFlw00 view inner COMPOSITE
R_ProjectBillingElementEntryTP view_entity from TRANSACTIONAL Project Billing Element Entry TP

Fields (55)

KeyField CDS FieldsUsed in Views
KEY ProjBillgElmntEntrItmUUID ProjBillgElmntEntrItmUUID 2
_Material _Material 2
BillableRevenueAmtInDocCrcy BillableRevenueAmtInDocCrcy 2
DocumentCurrency DocumentCurrency 3
GlobalCurrency GlobalCurrency 2
ManualNetPriceAmtInDocCrcy ManualNetPriceAmtInDocCrcy 2
Material Material 2
NetPriceAmountInDocCrcy NetPriceAmountInDocCrcy 2
NetPriceAmountIsManual NetPriceAmountIsManual 2
NetPriceQuantity NetPriceQuantity 1
NetPriceQuantityUnit NetPriceQuantityUnit 1
OpenAmountInGlobalCurrency OpenAmountInGlobalCurrency 2
OpenAmountInProjectCurrency OpenAmountInProjectCurrency 2
OpenAmountInTransCrcy OpenAmountInTransCrcy 2
OpenQuantity OpenQuantity 2
OpenRevenueAmtInDocCrcy OpenRevenueAmtInDocCrcy 2
OriginalAmountInGlobalCurrency OriginalAmountInGlobalCurrency 2
OriginalAmountInProjectCrcy OriginalAmountInProjectCrcy 2
OriginalAmountInTransacCrcy OriginalAmountInTransacCrcy 2
OriginalRevenueAmtInDocCrcy OriginalRevenueAmtInDocCrcy 2
OriginalTotalQuantity OriginalTotalQuantity 2
PostingDate PostingDate 1
PricingDate PricingDate 2
PrjBlgElmEntrCanclnSrceCode PrjBlgElmEntrCanclnSrceCode 2
PrjBlgElmEntrCreatedAtDteTme PrjBlgElmEntrCreatedAtDteTme 2
PrjBlgElmEntrCreatedByUser PrjBlgElmEntrCreatedByUser 2
PrjBlgElmEntrLastChgdAtDteTme PrjBlgElmEntrLastChgdAtDteTme 2
PrjBlgElmEntrLastChgdByUser PrjBlgElmEntrLastChgdByUser 2
PrjBlgElmEntryLongText PrjBlgElmEntryLongText 2
ProjBillgElementEntryObject ProjBillgElementEntryObject 1
ProjBillgElmntEntrIsCancelled ProjBillgElmntEntrIsCancelled 2
ProjBillgElmntEntrIsReversal ProjBillgElmntEntrIsReversal 2
ProjBillgElmntEntrIsReversed ProjBillgElmntEntrIsReversed 2
ProjBillgElmntEntrSourceType ProjBillgElmntEntrSourceType 2
ProjBillgItmValIsNotActualCost ProjBillgItmValIsNotActualCost 2
ProjBillgTransfCostQtyCode ProjBillgTransfCostQtyCode 2
ProjectBillingElementEntryDesc ProjectBillingElementEntryDesc 1
ProjectBillingElementUUID ProjectBillingElementUUID 3
ProjectCurrency ProjectCurrency 2
QuantityUnit QuantityUnit 2
ServicesRenderedDate ServicesRenderedDate 3
ToBeBilledAmtInGlobCurrency ToBeBilledAmtInGlobCurrency 2
ToBeBilledAmtInProjCurrency ToBeBilledAmtInProjCurrency 2
ToBeBilledAmtInTransCrcy ToBeBilledAmtInTransCrcy 2
ToBeBilledQuantity ToBeBilledQuantity 2
ToBePostponedAmtInGlobalCrcy ToBePostponedAmtInGlobalCrcy 2
ToBePostponedAmtInProjectCrcy ToBePostponedAmtInProjectCrcy 2
ToBePostponedAmtInTransacCrcy ToBePostponedAmtInTransacCrcy 2
ToBePostponedQuantity ToBePostponedQuantity 2
ToBeWrittenOffAmtInGlobalCrcy ToBeWrittenOffAmtInGlobalCrcy 2
ToBeWrittenOffAmtInProjectCrcy ToBeWrittenOffAmtInProjectCrcy 2
ToBeWrittenOffAmtInTransCrcy ToBeWrittenOffAmtInTransCrcy 2
ToBeWrittenOffQuantity ToBeWrittenOffQuantity 2
TransactionCurrency TransactionCurrency 2
WBSElementInternalID WBSElementInternalID 2 
@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
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_PROJECTBILLINGELEMENT",
"PROJBLGELMNTENTR"
],
"ASSOCIATED":
[
"I_MATERIAL",
"I_PRJBLGELMENTRBILLGPLNLINK",
"I_PRJBLGELMENTRJRNLENTRLINK",
"I_PROJECTBILLINGELEMENT",
"I_PROJECTBILLINGELEMENTENTRFLW",
"I_WBSELEMENTBASICDATA"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More