R_ProjectBillingElementEntryTP

DDL: R_PROJECTBILLINGELEMENTENTRYTP SQL: RPRJBLGELMENTRTP Type: view_entity TRANSACTIONAL
61 Fields 1 Data Sources 3 Associations

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 PBE Entry UUID
ProjectBillingElementUUID I_ProjectBillingElementEntry ProjectBillingElementUUID PBE UUID
ProjBillgElmntEntrSourceType I_ProjectBillingElementEntry ProjBillgElmntEntrSourceType PBE Entry SourceType
WBSElementInternalID I_ProjectBillingElementEntry WBSElementInternalID WBS Internal ID
Material I_ProjectBillingElementEntry Material Vehicle Model
QuantityUnit I_ProjectBillingElementEntry QuantityUnit Unit of measure
ProjBillgElmntEntrIsCancelled I_ProjectBillingElementEntry ProjBillgElmntEntrIsCancelled PBE Entry Cancelled
PricingDate I_ProjectBillingElementEntry PricingDate Pricing Date
NetPriceAmountIsManual I_ProjectBillingElementEntry NetPriceAmountIsManual Net Price Manual
TransactionCurrency I_ProjectBillingElementEntry TransactionCurrency Transaction Currency
ProjectCurrency I_ProjectBillingElementEntry ProjectCurrency Project Currency
GlobalCurrency I_ProjectBillingElementEntry GlobalCurrency GM Billing Element: Global Currency
DocumentCurrency I_ProjectBillingElementEntry DocumentCurrency Document Currency
ServicesRenderedDate I_ProjectBillingElementEntry ServicesRenderedDate Services Rendered Date
OriginalTotalQuantity I_ProjectBillingElementEntry OriginalTotalQuantity Original Quantity
OriginalAmountInTransacCrcy I_ProjectBillingElementEntry OriginalAmountInTransacCrcy Origl Amt Trans Crcy
OriginalAmountInProjectCrcy I_ProjectBillingElementEntry OriginalAmountInProjectCrcy Origl Amt Proj Crcy
OriginalAmountInGlobalCurrency I_ProjectBillingElementEntry OriginalAmountInGlobalCurrency Original Amt InGCrcy
OpenQuantity I_ProjectBillingElementEntry OpenQuantity PBE Entry Open Qty
OpenAmountInTransCrcy I_ProjectBillingElementEntry OpenAmountInTransCrcy Open Amt Trans Crcy
OpenAmountInProjectCurrency I_ProjectBillingElementEntry OpenAmountInProjectCurrency Open Amt Proj Crcy
OpenAmountInGlobalCurrency I_ProjectBillingElementEntry OpenAmountInGlobalCurrency Open Amt Glob Crcy
ToBeBilledQuantity I_ProjectBillingElementEntry ToBeBilledQuantity To Be Blld Qty
ToBeBilledAmtInTransCrcy I_ProjectBillingElementEntry ToBeBilledAmtInTransCrcy To Be Blld Trans Cur
ToBeBilledAmtInProjCurrency I_ProjectBillingElementEntry ToBeBilledAmtInProjCurrency To Be Blld Proj Crcy
ToBeBilledAmtInGlobCurrency I_ProjectBillingElementEntry ToBeBilledAmtInGlobCurrency To Be Blld GlobCrcy
ToBeWrittenOffQuantity I_ProjectBillingElementEntry ToBeWrittenOffQuantity Qty to Write Off
ToBeWrittenOffAmtInTransCrcy I_ProjectBillingElementEntry ToBeWrittenOffAmtInTransCrcy Amt ToWrtOff TrCrcy
ToBeWrittenOffAmtInProjectCrcy I_ProjectBillingElementEntry ToBeWrittenOffAmtInProjectCrcy Amt ToWrtOff PrCrcy
ToBeWrittenOffAmtInGlobalCrcy I_ProjectBillingElementEntry ToBeWrittenOffAmtInGlobalCrcy Amt ToWrtOff GlCrcy
ToBePostponedQuantity I_ProjectBillingElementEntry ToBePostponedQuantity To Be Postponed Qty
ToBePostponedAmtInTransacCrcy I_ProjectBillingElementEntry ToBePostponedAmtInTransacCrcy Amt ToPostpn TrCrcy
ToBePostponedAmtInProjectCrcy I_ProjectBillingElementEntry ToBePostponedAmtInProjectCrcy Amt ToPostpn PrCrcy
ToBePostponedAmtInGlobalCrcy I_ProjectBillingElementEntry ToBePostponedAmtInGlobalCrcy Amt ToPostpn GlCrcy
BillableRevenueAmtInDocCrcy I_ProjectBillingElementEntry BillableRevenueAmtInDocCrcy Billable Revenue
ManualNetPriceAmtInDocCrcy I_ProjectBillingElementEntry ManualNetPriceAmtInDocCrcy Net Price
NetPriceAmountInDocCrcy I_ProjectBillingElementEntry NetPriceAmountInDocCrcy Net Price
NetPriceQuantity I_ProjectBillingElementEntry NetPriceQuantity Price Unit
NetPriceQuantityUnit I_ProjectBillingElementEntry NetPriceQuantityUnit SettlmtPrcUnit
OriginalRevenueAmtInDocCrcy I_ProjectBillingElementEntry OriginalRevenueAmtInDocCrcy Original Revenue
OpenRevenueAmtInDocCrcy I_ProjectBillingElementEntry OpenRevenueAmtInDocCrcy Open Revenue
ProjBillgElmntEntrIsReversed I_ProjectBillingElementEntry ProjBillgElmntEntrIsReversed PBE Entry Reversed
ProjBillgElmntEntrIsReversal I_ProjectBillingElementEntry ProjBillgElmntEntrIsReversal PBE Entry Reversal
PrjBlgElmEntrCanclnSrceCode I_ProjectBillingElementEntry PrjBlgElmEntrCanclnSrceCode Cancln Src PBEE
PrjBlgElmEntrCreatedByUser I_ProjectBillingElementEntry PrjBlgElmEntrCreatedByUser PBE Entry Created By
PrjBlgElmEntrCreatedAtDteTme I_ProjectBillingElementEntry PrjBlgElmEntrCreatedAtDteTme PBE Entry Created On
PrjBlgElmEntrLastChgdByUser I_ProjectBillingElementEntry PrjBlgElmEntrLastChgdByUser PBE Entry Changed By
PrjBlgElmEntrLastChgdAtDteTme I_ProjectBillingElementEntry PrjBlgElmEntrLastChgdAtDteTme PBE Entry Changed On
BillingWBSElementInternalID
PrjBlgElmEntryLongText I_ProjectBillingElementEntry PrjBlgElmEntryLongText long text
ProjectBillingElementEntryDesc I_ProjectBillingElementEntry ProjectBillingElementEntryDesc Item Description
ProjBillgTransfCostQtyCode I_ProjectBillingElementEntry ProjBillgTransfCostQtyCode Transfer Qty/Costs
ProjBillgItmValIsNotActualCost I_ProjectBillingElementEntry ProjBillgItmValIsNotActualCost Item Not Actual Cost
ProjBillgElementEntryObject I_ProjectBillingElementEntry ProjBillgElementEntryObject PBEE Object Number
PostingDate I_ProjectBillingElementEntry PostingDate Posting Date for GR
_ProjectBillingElement _ProjectBillingElement
_ProjectBillgElmntEntrFlw _ProjectBillgElmntEntrFlw
_PrjBlgElmEntrJrnlEntrLink _PrjBlgElmEntrJrnlEntrLink
_PrjBlgElmEntrBillgPlnLnk _PrjBlgElmEntrBillgPlnLnk
_Material I_ProjectBillingElementEntry _Material
_WBSElement _WBSElement

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view R_ProjectBillingElementEntryTP.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.
-- SQL view name: RPRJBLGELMENTRTP

CREATE VIEW R_ProjectBillingElementEntryTP AS
SELECT
  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,
  ProjectBillingElementEntry.DocumentCurrency AS DocumentCurrency,
  ProjectBillingElementEntry.ServicesRenderedDate AS ServicesRenderedDate,
  ProjectBillingElementEntry.OriginalTotalQuantity AS OriginalTotalQuantity,
  ProjectBillingElementEntry.OriginalAmountInTransacCrcy AS OriginalAmountInTransacCrcy,
  ProjectBillingElementEntry.OriginalAmountInProjectCrcy AS OriginalAmountInProjectCrcy,
  ProjectBillingElementEntry.OriginalAmountInGlobalCurrency AS OriginalAmountInGlobalCurrency,
  ProjectBillingElementEntry.OpenQuantity AS OpenQuantity,
  ProjectBillingElementEntry.OpenAmountInTransCrcy AS OpenAmountInTransCrcy,
  ProjectBillingElementEntry.OpenAmountInProjectCurrency AS OpenAmountInProjectCurrency,
  ProjectBillingElementEntry.OpenAmountInGlobalCurrency AS OpenAmountInGlobalCurrency,
  ProjectBillingElementEntry.ToBeBilledQuantity AS ToBeBilledQuantity,
  ProjectBillingElementEntry.ToBeBilledAmtInTransCrcy AS ToBeBilledAmtInTransCrcy,
  ProjectBillingElementEntry.ToBeBilledAmtInProjCurrency AS ToBeBilledAmtInProjCurrency,
  ProjectBillingElementEntry.ToBeBilledAmtInGlobCurrency AS ToBeBilledAmtInGlobCurrency,
  ProjectBillingElementEntry.ToBeWrittenOffQuantity AS ToBeWrittenOffQuantity,
  ProjectBillingElementEntry.ToBeWrittenOffAmtInTransCrcy AS ToBeWrittenOffAmtInTransCrcy,
  ProjectBillingElementEntry.ToBeWrittenOffAmtInProjectCrcy AS ToBeWrittenOffAmtInProjectCrcy,
  ProjectBillingElementEntry.ToBeWrittenOffAmtInGlobalCrcy AS ToBeWrittenOffAmtInGlobalCrcy,
  ProjectBillingElementEntry.ToBePostponedQuantity AS ToBePostponedQuantity,
  ProjectBillingElementEntry.ToBePostponedAmtInTransacCrcy AS ToBePostponedAmtInTransacCrcy,
  ProjectBillingElementEntry.ToBePostponedAmtInProjectCrcy AS ToBePostponedAmtInProjectCrcy,
  ProjectBillingElementEntry.ToBePostponedAmtInGlobalCrcy AS ToBePostponedAmtInGlobalCrcy,
  ProjectBillingElementEntry.BillableRevenueAmtInDocCrcy AS BillableRevenueAmtInDocCrcy,
  ProjectBillingElementEntry.ManualNetPriceAmtInDocCrcy AS ManualNetPriceAmtInDocCrcy,
  ProjectBillingElementEntry.NetPriceAmountInDocCrcy AS NetPriceAmountInDocCrcy,
  ProjectBillingElementEntry.NetPriceQuantity AS NetPriceQuantity,
  ProjectBillingElementEntry.NetPriceQuantityUnit AS NetPriceQuantityUnit,
  ProjectBillingElementEntry.OriginalRevenueAmtInDocCrcy AS OriginalRevenueAmtInDocCrcy,
  ProjectBillingElementEntry.OpenRevenueAmtInDocCrcy AS OpenRevenueAmtInDocCrcy,
  ProjectBillingElementEntry.ProjBillgElmntEntrIsReversed AS ProjBillgElmntEntrIsReversed,
  ProjectBillingElementEntry.ProjBillgElmntEntrIsReversal AS ProjBillgElmntEntrIsReversal,
  ProjectBillingElementEntry.PrjBlgElmEntrCanclnSrceCode AS PrjBlgElmEntrCanclnSrceCode,
  ProjectBillingElementEntry.PrjBlgElmEntrCreatedByUser AS PrjBlgElmEntrCreatedByUser,
  ProjectBillingElementEntry.PrjBlgElmEntrCreatedAtDteTme AS PrjBlgElmEntrCreatedAtDteTme,
  ProjectBillingElementEntry.PrjBlgElmEntrLastChgdByUser AS PrjBlgElmEntrLastChgdByUser,
  ProjectBillingElementEntry.PrjBlgElmEntrLastChgdAtDteTme AS PrjBlgElmEntrLastChgdAtDteTme,
  ProjectBillingElementEntry._ProjectBillingElement.BillingWBSElementInternalID AS BillingWBSElementInternalID,
  ProjectBillingElementEntry.PrjBlgElmEntryLongText AS PrjBlgElmEntryLongText,
  ProjectBillingElementEntry.ProjectBillingElementEntryDesc AS ProjectBillingElementEntryDesc,
  ProjectBillingElementEntry.ProjBillgTransfCostQtyCode AS ProjBillgTransfCostQtyCode,
  ProjectBillingElementEntry.ProjBillgItmValIsNotActualCost AS ProjBillgItmValIsNotActualCost,
  ProjectBillingElementEntry.ProjBillgElementEntryObject AS ProjBillgElementEntryObject,
  ProjectBillingElementEntry.PostingDate AS PostingDate,
  ProjectBillingElementEntry._Material AS _Material
FROM I_ProjectBillingElementEntry AS ProjectBillingElementEntry
LEFT OUTER JOIN R_ProjectBillgElmntEntrFlwTP AS _ProjectBillgElmntEntrFlw ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN R_PrjBlgElmEntrJrnlEntrLinkTP AS _PrjBlgElmEntrJrnlEntrLink ON /* condition not available in parsed metadata */  -- association [0..1]
LEFT OUTER JOIN R_PrjBlgElmEntrBillgPlnLnkTP AS _PrjBlgElmEntrBillgPlnLnk ON /* condition not available in parsed metadata */  -- association [0..1]
;

Learn More