What is I_ProjectBillingElementEntry in SAP S/4HANA?

I_ProjectBillingElementEntry is a basic CDS view in SAP S/4HANA. Entries for Project Billing Element It contains 60 fields.

Which tables does I_ProjectBillingElementEntry read from?

I_ProjectBillingElementEntry reads data from: projblgelmntentr.

What VDM layer is I_ProjectBillingElementEntry?

I_ProjectBillingElementEntry is classified as a Basic (interface) view providing a 1:1 representation of a database table.

I_ProjectBillingElementEntry

DDL: I_PROJECTBILLINGELEMENTENTRY Type: view_entity BASIC

60 Fields 1 Data Sources 6 Associations

Entries for Project Billing Element

I_ProjectBillingElementEntry (Basic)

Package: Explore, extend and adapt the SAP S/4HANA Cloud Private Edition with built-in and side-by-side extension capabilities.

ProjectBillingElementEntry · R&D Engineering

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.

SAP Help Documentation

Category	CDS Views for Project Billing
Status	Released

Purpose
This CDS view contains the details of a project billing element item. For example, you can create billing plan items for relevant Time and Expenses, Fixed Price or other contract type postings.. This CDS view provides the data to answer the following business questions: What is the pricing date? What are amounts to be billed, written off and posponed? Who and when created and changed the project billing element entry? To help you decide which CDS view to use for your purposes, SAP has introduced the annotation ObjectModel.supportedCapabilities that indicates the most appropriate use cases for each CDS view. To find out what use cases are best supported by this CDS view, access the entry of the CDS view in the View Browser app and find the values for this annotation under the Annotation tab. For more information, see Supported Capabilities for CDS Views .

Prerequisites
Authorizations The following business catalog needs to be assigned to a user to be able to use this CDS view: SAP_PS_BC_PROJ_BLNG_PC

Structure
Important fields Important fields in this view include the following: Field Name Description ProjBillgElmntEntrItmUUID Internal identification number for project billing element item ProjBillgElmntEntrIsCancelled Indicates if a project billing element item is deleted PricingDate Pricing Date NetPriceAmountIsManual Indicates if the net price is maintained manually ToBeBilledQuantity To be billed quantity ToBeWrittenOffQuantity To be written off quantity ToBePostponedQuantity To be postponed quantity OriginalRevenueAmtInDocCrcy Revenue for original quantity/cost OpenRevenueAmtInDocCrcy Revenue for open cost/quantity PrjBlgElmEntrCreatedByUser Created by PrjBlgElmEntrCreatedAtDteTme Created on PrjBlgElmEntrLastChgdByUser Changed by PrjBlgElmEntrLastChgdAtDteTme Changed on

View on SAP Help Portal →

SAP API Hub

State	C1
Line of Business	R&D Engineering
Application Component	PPM-SCL-BIL
Capabilities	Data Source in SQL Select, Association Target for Defining CDS Entities, Data Source for Defining CDS Entities, Analytical Dimension, Data Source for Data Extraction
Package	R&D Engineering for SAP S/4HANA Cloud Private Edition

Documentation

Analytics with CDS Views — Build Analytics for S/4HANA Cloud Private Edition ABAP CDS views replicated to SAP Cloud Platform
CDS Views on SAP Business Accelerator Hub — Explore SAP S/4HANA Cloud Private Edition Private Edition CDS Views on SAP Business Accelerator Hub
Create CDS View as API — Create CDS views in SAP S/4HANA Cloud Private Edition and consume them as APIs
Custom CDS Views — Access data using a Custom Core Data Service view (Custom CDS view)
Key User Extensibility Tools — The Key User Extensibility Tools of S/4HANA
SAP Extensibility Explorer for SAP S/4HANA Cloud Private Edition — Explore SAP S/4HANA Cloud Private Edition Extensibility options by leveraging the sample scenarios from SAP
SAP S/4HANA Extensibility — SAP S/4HANA Extensibility Tutorial
VDM View Types — The Virtual Data Model in SAP S/4HANA Cloud Private Edition
View Browser — Search, browse and tag CDS Views

Data Sources (1)

Source	Alias	Join Type
projblgelmntentr	ProjectBillingElementEntry	from

Associations (6)

Cardinality	Target	Alias	Condition
[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 (12)

Name	Value	Level
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
ObjectModel.sapObjectNodeType.name	ProjectBillingElementEntry	view

Fields (60)

Key	Field	Source Table	Source Field	Description
KEY	ProjBillgElmntEntrItmUUID	projblgelmntentr	projbillgelmntentritmuuid	Project Billing Element Entry UUID
	ProjectBillingElementUUID	projblgelmntentr	projectbillingelementuuid	Project Billing Element UUID
	ProjBillgElmntEntrSourceType	projblgelmntentr	projbillgelmntentrsourcetype	Project Billing Element Entry Source Type
	WBSElementInternalID	projblgelmntentr	wbselementinternalid	WBS Internal ID
	Material	projblgelmntentr	material	Material Number
	QuantityUnit	projblgelmntentr	quantityunit	Unit of measure
	ProjBillgElmntEntrIsCancelled	projblgelmntentr	projbillgelmntentriscancelled	Project Billing Element Entry is Cancelled
	PricingDate	projblgelmntentr	pricingdate	Project Billing Element Entry Pricing Date
	NetPriceAmountIsManual	projblgelmntentr	netpriceamountismanual	Project Billing Element Entry Net Price Manual Flag
	TransactionCurrency	projblgelmntentr	transactioncurrency	Project Billing Element Entry Transaction Currency
	ProjectCurrency	projblgelmntentr	projectcurrency	Project Billing Element Entry Project Currency
	GlobalCurrency	projblgelmntentr	globalcurrency	Project Billing Element Entry Global Currency
	DocumentCurrency	_ProjectBillingElement	DocumentCurrency	Document Currency
	ServicesRenderedDate	projblgelmntentr	servicesrendereddate	Date on which services are rendered
	OriginalTotalQuantity	projblgelmntentr	originaltotalquantity	Project Billing Element Entry Original Quantity
	OriginalAmountInTransacCrcy	projblgelmntentr	originalamountintransaccrcy	Original Amount in Transaction Currency
	OriginalAmountInProjectCrcy	projblgelmntentr	originalamountinprojectcrcy	Original Amount in Project Currency
	OriginalAmountInGlobalCurrency	projblgelmntentr	originalamountinglobalcurrency	Original Amount in Global Currency
	OpenQuantity	projblgelmntentr	openquantity	Project Billing Element Entry Open Quantity
	OpenAmountInTransCrcy	projblgelmntentr	openamountintranscrcy	Open Amount in Transaction Currency
	OpenAmountInProjectCurrency	projblgelmntentr	openamountinprojectcurrency	Open Amount in Project Currency
	OpenAmountInGlobalCurrency	projblgelmntentr	openamountinglobalcurrency	Open Amount in Global Currency
	ToBeBilledQuantity	projblgelmntentr	tobebilledquantity	Project Billing Element Entry: To Be Billed Quantity
	ToBeBilledAmtInTransCrcy	projblgelmntentr	tobebilledamtintranscrcy	To be Billed Amount in Transaction Currency
	ToBeBilledAmtInProjCurrency	projblgelmntentr	tobebilledamtinprojcurrency	To be Billed Amount in Project Currency
	ToBeBilledAmtInGlobCurrency	projblgelmntentr	tobebilledamtinglobcurrency	To be Billed Amount in Global Currecny
	ToBeWrittenOffQuantity	projblgelmntentr	tobewrittenoffquantity	Project Billing Element Entry: To Be Written-Off Quantity
	ToBeWrittenOffAmtInTransCrcy	projblgelmntentr	tobewrittenoffamtintranscrcy	To Be Written-Off Amount in Transaction Currency
	ToBeWrittenOffAmtInProjectCrcy	projblgelmntentr	tobewrittenoffamtinprojectcrcy	To Be Written-Off Amount in Project Currency
	ToBeWrittenOffAmtInGlobalCrcy	projblgelmntentr	tobewrittenoffamtinglobalcrcy	To be Written-off Amount in Global Currency
	ToBePostponedQuantity	projblgelmntentr	tobepostponedquantity	To be Postponed Quantity
	ToBePostponedAmtInTransacCrcy	projblgelmntentr	tobepostponedamtintransaccrcy	To Be Postponed Amount in Transaction Currency
	ToBePostponedAmtInProjectCrcy	projblgelmntentr	tobepostponedamtinprojectcrcy	To Be Postponed Amount in Project Currency
	ToBePostponedAmtInGlobalCrcy	projblgelmntentr	tobepostponedamtinglobalcrcy	To Be Postponed Amount in Global Currency
	BillableRevenueAmtInDocCrcy	projblgelmntentr	billablerevenueamtindoccrcy	Billable Revenue
	ManualNetPriceAmtInDocCrcy	projblgelmntentr	manualnetpriceamtindoccrcy	Manual Net Price
	NetPriceAmountInDocCrcy	projblgelmntentr	netpriceamountindoccrcy	Net Price
	NetPriceQuantity	projblgelmntentr	netpricequantity	Pricing Unit for Sales Rate
	NetPriceQuantityUnit	projblgelmntentr	netpricequantityunit	Unit of Measure for Sales rate
	OriginalRevenueAmtInDocCrcy	projblgelmntentr	originalrevenueamtindoccrcy	Original Revenue
	OpenRevenueAmtInDocCrcy	projblgelmntentr	openrevenueamtindoccrcy	Open Revenue in Document Currency
	ProjBillgElmntEntrIsReversed	projblgelmntentr	projbillgelmntentrisreversed	Project Billing Element Entry is Reversed
	ProjBillgElmntEntrIsReversal	projblgelmntentr	projbillgelmntentrisreversal	Project Billing Element Entry is a Reversal
	PrjBlgElmEntrCanclnSrceCode	projblgelmntentr	prjblgelmentrcanclnsrcecode	Source which cancels Project Billing Element Entry
	PrjBlgElmEntrCreatedByUser	projblgelmntentr	prjblgelmentrcreatedbyuser	Project Billing Element Entry Created By
	PrjBlgElmEntrCreatedAtDteTme	projblgelmntentr	prjblgelmentrcreatedatdtetme	Project Billing Element Entry Created On
	PrjBlgElmEntrLastChgdByUser	projblgelmntentr	prjblgelmentrlastchgdbyuser	Project Billing Element Entry Changed By
	PrjBlgElmEntrLastChgdAtDteTme	projblgelmntentr	prjblgelmentrlastchgdatdtetme	Project Billing Element Entry Changed On
	PrjBlgElmEntryLongText	projblgelmntentr	prjblgelmentrylongtext	Element Entry Long Text
	ProjectBillingElementEntryDesc	projblgelmntentr	projectbillingelemententrydesc	Item Description
	ProjBillgTransfCostQtyCode	projblgelmntentr	projbillgtransfcostqtycode	Transfer Quantity and Costs
	ProjBillgItmValIsNotActualCost	projblgelmntentr	projbillgitmvalisnotactualcost	Project Billing Item is Not Actual Cost
	ProjBillgElementEntryObject	projblgelmntentr	projbillgelemententryobject	Project Billing Element Entry Object Number
	PostingDate	projblgelmntentr	postingdate	Posting Date in the Document
	_ProjectBillingElement		_ProjectBillingElement
	_ProjectBillingElementEntrFlw		_ProjectBillingElementEntrFlw
	_PrjBlgElmEntrJrnlEntrLink		_PrjBlgElmEntrJrnlEntrLink
	_PrjBlgElmEntrBillgPlnLink		_PrjBlgElmEntrBillgPlnLink
	_Material		_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 I_ProjectBillingElementEntry.
-- 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.

CREATE VIEW I_ProjectBillingElementEntry 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,
  _ProjectBillingElement.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.prjblgelmentrylongtext AS PrjBlgElmEntryLongText,
  ProjectBillingElementEntry.projectbillingelemententrydesc AS ProjectBillingElementEntryDesc,
  ProjectBillingElementEntry.projbillgtransfcostqtycode AS ProjBillgTransfCostQtyCode,
  ProjectBillingElementEntry.projbillgitmvalisnotactualcost AS ProjBillgItmValIsNotActualCost,
  ProjectBillingElementEntry.projbillgelemententryobject AS ProjBillgElementEntryObject,
  ProjectBillingElementEntry.postingdate AS PostingDate
FROM projblgelmntentr AS ProjectBillingElementEntry
LEFT OUTER JOIN I_Material AS _Material ON Material = _Material.Material  -- association [0..1]
LEFT OUTER JOIN I_ProjectBillingElement AS _ProjectBillingElement ON ProjectBillingElementUUID = _ProjectBillingElement.ProjectBillingElementUUID  -- association [1..1]
LEFT OUTER JOIN I_ProjectBillingElementEntrFlw AS _ProjectBillingElementEntrFlw ON ProjBillgElmntEntrItmUUID = _ProjectBillingElementEntrFlw.ProjBillgElmntEntrItmUUID  -- association [0..*]
LEFT OUTER JOIN I_PrjBlgElmEntrJrnlEntrLink AS _PrjBlgElmEntrJrnlEntrLink ON ProjBillgElmntEntrItmUUID = _PrjBlgElmEntrJrnlEntrLink.ProjBillgElmntEntrItmUUID  -- association [0..1]
LEFT OUTER JOIN I_PrjBlgElmEntrBillgPlnLink AS _PrjBlgElmEntrBillgPlnLink ON ProjBillgElmntEntrItmUUID = _PrjBlgElmEntrBillgPlnLink.ProjBillgElmntEntrItmUUID  -- association [0..1]
LEFT OUTER JOIN I_WBSElementBasicData AS _WBSElement ON WBSElementInternalID = _WBSElement.WBSElementInternalID  -- association [0..1]
;

Depth:

I_ProjectBillingElementEntry view_entity

projblgelmntentr

C_ProjBillingReqDetsForWrkflw view_entity
I_ProjectBillingElementEntryTP view_entity
I_WrittenOffPrjBlgElmEntrDets view
P_EvtBsdRevnRecgnProjWIPBeeFlw view
P_PrjBlgElmBillingReqRevnAmt view
P_PrjBlgElmntToBillAmtSrvcDte view_entity
P_ProjBillingElementEntrFlw00 view
R_ProjectBillingElementEntryTP view_entity