R_ProjectBillingElementEntryTP

DDL: R_PROJECTBILLINGELEMENTENTRYTP SQL: RPRJBLGELMENTRTP Type: view_entity TRANSACTIONAL

Project Billing Element Entry TP

R_ProjectBillingElementEntryTP is a Transactional CDS View that provides data about "Project Billing Element Entry TP" in SAP S/4HANA. It reads from 1 data source (I_ProjectBillingElementEntry) and exposes 61 fields with key field ProjBillgElmntEntrItmUUID. It has 3 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_ProjectBillingElementEntry ProjectBillingElementEntry from

Associations (3)

CardinalityTargetAliasCondition
[0..*] R_ProjectBillgElmntEntrFlwTP _ProjectBillgElmntEntrFlw
[0..1] R_PrjBlgElmEntrJrnlEntrLinkTP _PrjBlgElmEntrJrnlEntrLink
[0..1] R_PrjBlgElmEntrBillgPlnLnkTP _PrjBlgElmEntrBillgPlnLnk

Annotations (7)

NameValueLevelField
VDM.viewType #TRANSACTIONAL view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Project Billing Element Entry TP view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #A view

Fields (61)

KeyFieldSource TableSource FieldDescription
KEY ProjBillgElmntEntrItmUUID I_ProjectBillingElementEntry ProjBillgElmntEntrItmUUID
ProjectBillingElementUUID I_ProjectBillingElementEntry ProjectBillingElementUUID
ProjBillgElmntEntrSourceType I_ProjectBillingElementEntry ProjBillgElmntEntrSourceType
WBSElementInternalID I_ProjectBillingElementEntry WBSElementInternalID
Material I_ProjectBillingElementEntry Material
QuantityUnit I_ProjectBillingElementEntry QuantityUnit
ProjBillgElmntEntrIsCancelled I_ProjectBillingElementEntry ProjBillgElmntEntrIsCancelled
PricingDate I_ProjectBillingElementEntry PricingDate
NetPriceAmountIsManual I_ProjectBillingElementEntry NetPriceAmountIsManual
TransactionCurrency I_ProjectBillingElementEntry TransactionCurrency
ProjectCurrency I_ProjectBillingElementEntry ProjectCurrency
GlobalCurrency I_ProjectBillingElementEntry GlobalCurrency
DocumentCurrency I_ProjectBillingElementEntry DocumentCurrency
ServicesRenderedDate I_ProjectBillingElementEntry ServicesRenderedDate
OriginalTotalQuantity I_ProjectBillingElementEntry OriginalTotalQuantity
OriginalAmountInTransacCrcy I_ProjectBillingElementEntry OriginalAmountInTransacCrcy
OriginalAmountInProjectCrcy I_ProjectBillingElementEntry OriginalAmountInProjectCrcy
OriginalAmountInGlobalCurrency I_ProjectBillingElementEntry OriginalAmountInGlobalCurrency
OpenQuantity I_ProjectBillingElementEntry OpenQuantity
OpenAmountInTransCrcy I_ProjectBillingElementEntry OpenAmountInTransCrcy
OpenAmountInProjectCurrency I_ProjectBillingElementEntry OpenAmountInProjectCurrency
OpenAmountInGlobalCurrency I_ProjectBillingElementEntry OpenAmountInGlobalCurrency
ToBeBilledQuantity I_ProjectBillingElementEntry ToBeBilledQuantity
ToBeBilledAmtInTransCrcy I_ProjectBillingElementEntry ToBeBilledAmtInTransCrcy
ToBeBilledAmtInProjCurrency I_ProjectBillingElementEntry ToBeBilledAmtInProjCurrency
ToBeBilledAmtInGlobCurrency I_ProjectBillingElementEntry ToBeBilledAmtInGlobCurrency
ToBeWrittenOffQuantity I_ProjectBillingElementEntry ToBeWrittenOffQuantity
ToBeWrittenOffAmtInTransCrcy I_ProjectBillingElementEntry ToBeWrittenOffAmtInTransCrcy
ToBeWrittenOffAmtInProjectCrcy I_ProjectBillingElementEntry ToBeWrittenOffAmtInProjectCrcy
ToBeWrittenOffAmtInGlobalCrcy I_ProjectBillingElementEntry ToBeWrittenOffAmtInGlobalCrcy
ToBePostponedQuantity I_ProjectBillingElementEntry ToBePostponedQuantity
ToBePostponedAmtInTransacCrcy I_ProjectBillingElementEntry ToBePostponedAmtInTransacCrcy
ToBePostponedAmtInProjectCrcy I_ProjectBillingElementEntry ToBePostponedAmtInProjectCrcy
ToBePostponedAmtInGlobalCrcy I_ProjectBillingElementEntry ToBePostponedAmtInGlobalCrcy
BillableRevenueAmtInDocCrcy I_ProjectBillingElementEntry BillableRevenueAmtInDocCrcy
ManualNetPriceAmtInDocCrcy I_ProjectBillingElementEntry ManualNetPriceAmtInDocCrcy
NetPriceAmountInDocCrcy I_ProjectBillingElementEntry NetPriceAmountInDocCrcy
NetPriceQuantity I_ProjectBillingElementEntry NetPriceQuantity
NetPriceQuantityUnit I_ProjectBillingElementEntry NetPriceQuantityUnit
OriginalRevenueAmtInDocCrcy I_ProjectBillingElementEntry OriginalRevenueAmtInDocCrcy
OpenRevenueAmtInDocCrcy I_ProjectBillingElementEntry OpenRevenueAmtInDocCrcy
ProjBillgElmntEntrIsReversed I_ProjectBillingElementEntry ProjBillgElmntEntrIsReversed
ProjBillgElmntEntrIsReversal I_ProjectBillingElementEntry ProjBillgElmntEntrIsReversal
PrjBlgElmEntrCanclnSrceCode I_ProjectBillingElementEntry PrjBlgElmEntrCanclnSrceCode
PrjBlgElmEntrCreatedByUser I_ProjectBillingElementEntry PrjBlgElmEntrCreatedByUser
PrjBlgElmEntrCreatedAtDteTme I_ProjectBillingElementEntry PrjBlgElmEntrCreatedAtDteTme
PrjBlgElmEntrLastChgdByUser I_ProjectBillingElementEntry PrjBlgElmEntrLastChgdByUser
PrjBlgElmEntrLastChgdAtDteTme I_ProjectBillingElementEntry PrjBlgElmEntrLastChgdAtDteTme
BillingWBSElementInternalID
PrjBlgElmEntryLongText I_ProjectBillingElementEntry PrjBlgElmEntryLongText
ProjectBillingElementEntryDesc I_ProjectBillingElementEntry ProjectBillingElementEntryDesc
ProjBillgTransfCostQtyCode I_ProjectBillingElementEntry ProjBillgTransfCostQtyCode
ProjBillgItmValIsNotActualCost I_ProjectBillingElementEntry ProjBillgItmValIsNotActualCost
ProjBillgElementEntryObject I_ProjectBillingElementEntry ProjBillgElementEntryObject
PostingDate I_ProjectBillingElementEntry PostingDate
_ProjectBillingElement _ProjectBillingElement
_ProjectBillgElmntEntrFlw _ProjectBillgElmntEntrFlw
_PrjBlgElmEntrJrnlEntrLink _PrjBlgElmEntrJrnlEntrLink
_PrjBlgElmEntrBillgPlnLnk _PrjBlgElmEntrBillgPlnLnk
_Material I_ProjectBillingElementEntry _Material
_WBSElement _WBSElement
//@AbapCatalog.sqlViewName: 'RPRJBLGELMENTRTP'

@VDM.viewType: #TRANSACTIONAL
@VDM.lifecycle.contract.type: #SAP_INTERNAL_API
//@ClientHandling.algorithm: #SESSION_VARIABLE

//@AbapCatalog.compiler.compareFilter: true

//@AbapCatalog.preserveKey: true

@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Project Billing Element Entry TP'

@ObjectModel.usageType: {
    sizeCategory: #L,
    dataClass:  #TRANSACTIONAL,
    serviceQuality: #A
} 



define view entity R_ProjectBillingElementEntryTP
  as select from I_ProjectBillingElementEntry as ProjectBillingElementEntry

  association        to parent R_ProjectBillingElementTP as _ProjectBillingElement on $projection.ProjectBillingElementUUID = _ProjectBillingElement.ProjectBillingElementUUID

  composition [0..*] of R_ProjectBillgElmntEntrFlwTP     as _ProjectBillgElmntEntrFlw
  composition [0..1] of R_PrjBlgElmEntrJrnlEntrLinkTP    as _PrjBlgElmEntrJrnlEntrLink
  composition [0..1] of R_PrjBlgElmEntrBillgPlnLnkTP    as _PrjBlgElmEntrBillgPlnLnk
  
{
  key ProjectBillingElementEntry.ProjBillgElmntEntrItmUUID,
      ProjectBillingElementEntry.ProjectBillingElementUUID,
      ProjectBillingElementEntry.ProjBillgElmntEntrSourceType,
      ProjectBillingElementEntry.WBSElementInternalID,
      ProjectBillingElementEntry.Material,
      ProjectBillingElementEntry.QuantityUnit,
      ProjectBillingElementEntry.ProjBillgElmntEntrIsCancelled,
      ProjectBillingElementEntry.PricingDate,
      ProjectBillingElementEntry.NetPriceAmountIsManual,
      ProjectBillingElementEntry.TransactionCurrency,
      ProjectBillingElementEntry.ProjectCurrency,
      ProjectBillingElementEntry.GlobalCurrency,
      ProjectBillingElementEntry.DocumentCurrency,
      ProjectBillingElementEntry.ServicesRenderedDate,
      ProjectBillingElementEntry.OriginalTotalQuantity,
      @Semantics.amount.currencyCode: 'TransactionCurrency'
      ProjectBillingElementEntry.OriginalAmountInTransacCrcy,
      ProjectBillingElementEntry.OriginalAmountInProjectCrcy,
      ProjectBillingElementEntry.OriginalAmountInGlobalCurrency,
      ProjectBillingElementEntry.OpenQuantity,
      ProjectBillingElementEntry.OpenAmountInTransCrcy,
      ProjectBillingElementEntry.OpenAmountInProjectCurrency,
      ProjectBillingElementEntry.OpenAmountInGlobalCurrency,
      ProjectBillingElementEntry.ToBeBilledQuantity,
      ProjectBillingElementEntry.ToBeBilledAmtInTransCrcy,
      ProjectBillingElementEntry.ToBeBilledAmtInProjCurrency,
      ProjectBillingElementEntry.ToBeBilledAmtInGlobCurrency,
      ProjectBillingElementEntry.ToBeWrittenOffQuantity,
      ProjectBillingElementEntry.ToBeWrittenOffAmtInTransCrcy,
      ProjectBillingElementEntry.ToBeWrittenOffAmtInProjectCrcy,
      ProjectBillingElementEntry.ToBeWrittenOffAmtInGlobalCrcy,
      ProjectBillingElementEntry.ToBePostponedQuantity,
      ProjectBillingElementEntry.ToBePostponedAmtInTransacCrcy,
      ProjectBillingElementEntry.ToBePostponedAmtInProjectCrcy,
      ProjectBillingElementEntry.ToBePostponedAmtInGlobalCrcy,
      ProjectBillingElementEntry.BillableRevenueAmtInDocCrcy,
      ProjectBillingElementEntry.ManualNetPriceAmtInDocCrcy,
      ProjectBillingElementEntry.NetPriceAmountInDocCrcy,
      ProjectBillingElementEntry.NetPriceQuantity,
      ProjectBillingElementEntry.NetPriceQuantityUnit,
      ProjectBillingElementEntry.OriginalRevenueAmtInDocCrcy,
      ProjectBillingElementEntry.OpenRevenueAmtInDocCrcy,
      ProjectBillingElementEntry.ProjBillgElmntEntrIsReversed,
      ProjectBillingElementEntry.ProjBillgElmntEntrIsReversal,
      ProjectBillingElementEntry.PrjBlgElmEntrCanclnSrceCode,
      @Semantics.user.createdBy: true
      ProjectBillingElementEntry.PrjBlgElmEntrCreatedByUser,
      @Semantics.systemDateTime.createdAt: true
      ProjectBillingElementEntry.PrjBlgElmEntrCreatedAtDteTme,
      @Semantics.user.lastChangedBy: true
      ProjectBillingElementEntry.PrjBlgElmEntrLastChgdByUser,
      @Semantics.systemDateTime.lastChangedAt: true
      ProjectBillingElementEntry.PrjBlgElmEntrLastChgdAtDteTme,
      ProjectBillingElementEntry._ProjectBillingElement.BillingWBSElementInternalID,
      ProjectBillingElementEntry.PrjBlgElmEntryLongText,
      ProjectBillingElementEntry.ProjectBillingElementEntryDesc,
      ProjectBillingElementEntry.ProjBillgTransfCostQtyCode,
      ProjectBillingElementEntry.ProjBillgItmValIsNotActualCost,
      ProjectBillingElementEntry.ProjBillgElementEntryObject,
      ProjectBillingElementEntry.PostingDate,
          
      _ProjectBillingElement,
      _ProjectBillgElmntEntrFlw,
      _PrjBlgElmEntrJrnlEntrLink,
      _PrjBlgElmEntrBillgPlnLnk,
      ProjectBillingElementEntry._Material as _Material,
      _WBSElement
      

}