What is I_ProjectBillingRequestItemTP in SAP S/4HANA?

I_ProjectBillingRequestItemTP is a transactional CDS view in SAP S/4HANA. Item Details of Project Billing Request It contains 60 fields.

Which tables does I_ProjectBillingRequestItemTP read from?

I_ProjectBillingRequestItemTP reads data from: I_ProjectBillingRequestItem.

What VDM layer is I_ProjectBillingRequestItemTP?

I_ProjectBillingRequestItemTP is classified as a Transactional view that supports create, update, and delete operations.

I_ProjectBillingRequestItemTP

DDL: I_PROJECTBILLINGREQUESTITEMTP SQL: IPROJBILREQITM Type: view_entity TRANSACTIONAL

60 Fields 1 Data Sources 5 Associations

Item Details of Project Billing Request

I_ProjectBillingRequestItemTP is a Transactional CDS View that provides data about "Item Details of Project Billing Request" in SAP S/4HANA. It reads from 1 data source (I_ProjectBillingRequestItem) and exposes 60 fields with key field ProjectBillingRequestItemUUID. It has 5 associations to related views.

Data Sources (1)

Source	Alias	Join Type
I_ProjectBillingRequestItem	ProjectBillingRequestItem	from

Associations (5)

Cardinality	Target	Alias	Condition
[0..1]	I_ProjectBillingElementEntryTP	_ProjectBillingElementEntryTP	`$projection.ProjBillgElmntEntrItmUUID = _ProjectBillingElementEntryTP.ProjBillgElmntEntrItmUUID`
[0..1]	I_WorkItem	_WorkItem	`$projection.WorkItem = _WorkItem.WorkItem`
[0..1]	I_MaterialGroup	_MaterialGroup	`$projection.MaterialGroup = _MaterialGroup.MaterialGroup`
[0..1]	I_BillingControlCategoryText	_BillingControlCategoryText	`$projection.BillingControlCategory = _BillingControlCategoryText.BillingControlCategory and _BillingControlCategoryText.Language = $session.system_language`
[1..1]	I_SalesDocumentItem	_SalesDocumentItem	`$projection.SalesDocument = _SalesDocumentItem.SalesDocument and $projection.SalesDocumentItem = _SalesDocumentItem.SalesDocumentItem`

Annotations (8)

Name	Value	Level
VDM.viewType	#TRANSACTIONAL	view
VDM.lifecycle.contract.type	#SAP_INTERNAL_API	view
AccessControl.authorizationCheck	#CHECK	view
AccessControl.personalData.blocking	#NOT_REQUIRED	view
EndUserText.label	Item Details of Project Billing Request	view
ObjectModel.usageType.sizeCategory	#XL	view
ObjectModel.usageType.dataClass	#TRANSACTIONAL	view
ObjectModel.usageType.serviceQuality	#X	view

Fields (60)

Key	Field	Source Table	Source Field	Description
KEY	ProjectBillingRequestItemUUID	I_ProjectBillingRequestItem	ProjectBillingRequestItemUUID	Item UUID
	_ProjectBillingRequestTP		_ProjectBillingRequestTP
	_ProjectBillingElementEntryTP		_ProjectBillingElementEntryTP
	ProjectBillingRequestUUID	I_ProjectBillingRequestItem	ProjectBillingRequestUUID	Proj Billg Req UUID
	ProjBillgElmntEntrItmUUID	I_ProjectBillingRequestItem	ProjBillgElmntEntrItmUUID	PBE Entry UUID
	ProjectBillingElementUUID	I_ProjectBillingRequestItem	ProjectBillingElementUUID	PBE UUID
	SalesDocumentItem	I_ProjectBillingRequestItem	SalesDocumentItem	Sales Document Item
	ToBePostponedQuantity	I_ProjectBillingRequestItem	ToBePostponedQuantity	To Be Postponed Qty
	ToBePostponedAmtInTransacCrcy	I_ProjectBillingRequestItem	ToBePostponedAmtInTransacCrcy	Amt ToPostpn TrCrcy
	ToBePostponedAmtInProjectCrcy	I_ProjectBillingRequestItem	ToBePostponedAmtInProjectCrcy	Amt ToPostpn PrCrcy
	ToBePostponedAmtInGlobalCrcy	I_ProjectBillingRequestItem	ToBePostponedAmtInGlobalCrcy	Amt ToPostpn GlCrcy
	ToBeWrittenOffQuantity	I_ProjectBillingRequestItem	ToBeWrittenOffQuantity	Qty to Write Off
	ToBeWrittenOffAmtInTransCrcy	I_ProjectBillingRequestItem	ToBeWrittenOffAmtInTransCrcy	Amt ToWrtOff TrCrcy
	ToBeWrittenOffAmtInProjectCrcy	I_ProjectBillingRequestItem	ToBeWrittenOffAmtInProjectCrcy	Amt ToWrtOff PrCrcy
	ToBeWrittenOffAmtInGlobalCrcy	I_ProjectBillingRequestItem	ToBeWrittenOffAmtInGlobalCrcy	Amt ToWrtOff GlCrcy
	BillableRevenueAmtInDocCrcy	I_ProjectBillingRequestItem	BillableRevenueAmtInDocCrcy	Billable Revenue
	ProjBillgReqItmCrtedByUser	I_ProjectBillingRequestItem	ProjBillgReqItmCrtedByUser	Created By
	ProjBillgReqItmCrtedAtDteTme	I_ProjectBillingRequestItem	ProjBillgReqItmCrtedAtDteTme	Created On
	ProjBillgReqItmLastChgdBy	I_ProjectBillingRequestItem	ProjBillgReqItmLastChgdBy	Item Changed By
	ProjBillgReqItmLastChgdDteTme	I_ProjectBillingRequestItem	ProjBillgReqItmLastChgdDteTme	Item Changed On
	ServicesRenderedDate	I_ProjectBillingRequestItem	ServicesRenderedDate	Services Rendered Date
	ToBeBilledQuantity	I_ProjectBillingRequestItem	ToBeBilledQuantity	To Be Blld Qty
	ToBeBilledAmtInTransCrcy	I_ProjectBillingRequestItem	ToBeBilledAmtInTransCrcy	To Be Blld Trans Cur
	ToBeBilledAmtInProjCurrency	I_ProjectBillingRequestItem	ToBeBilledAmtInProjCurrency	To Be Blld Proj Crcy
	ToBeBilledAmtInGlobCurrency	I_ProjectBillingRequestItem	ToBeBilledAmtInGlobCurrency	To Be Blld GlobCrcy
	OpenQuantity	I_ProjectBillingRequestItem	OpenQuantity	PBE Entry Open Qty
	OpenAmountInTransCrcy	I_ProjectBillingRequestItem	OpenAmountInTransCrcy	Open Amt Trans Crcy
	OpenAmountInProjectCurrency	I_ProjectBillingRequestItem	OpenAmountInProjectCurrency	Open Amt Proj Crcy
	OpenAmountInGlobalCurrency	I_ProjectBillingRequestItem	OpenAmountInGlobalCurrency	Open Amt Glob Crcy
	OpenRevenueAmtInDocCrcy	I_ProjectBillingRequestItem	OpenRevenueAmtInDocCrcy	Open Revenue
	NetPriceAmountInDocCrcy	I_ProjectBillingRequestItem	NetPriceAmountInDocCrcy	Net Price
	Material	I_ProjectBillingRequestItem	Material	Vehicle Model
	CostCtrActivityTypeDesc
	MaterialGroup
	TransactionCurrency	I_ProjectBillingRequestItem	TransactionCurrency	Transaction Currency
	ProjectCurrency	I_ProjectBillingRequestItem	ProjectCurrency	Project Currency
	QuantityUnit	I_ProjectBillingRequestItem	QuantityUnit	Unit of measure
	GlobalCurrency	I_ProjectBillingRequestItem	GlobalCurrency	GM Billing Element: Global Currency
	DocumentCurrency	I_ProjectBillingRequestItem	DocumentCurrency	Document Currency
	ProjBillgTransfCostQtyCode	I_ProjectBillingRequestItem	ProjBillgTransfCostQtyCode	Transfer Qty/Costs
	ProjBillgItmValIsNotActualCost	I_ProjectBillingRequestItem	ProjBillgItmValIsNotActualCost	Item Not Actual Cost
	ManualBillgSelForPrjBlgReqItem	I_ProjectBillingRequestItem	ManualBillgSelForPrjBlgReqItem	MnlBllySelection
	_MaterialGroup		_MaterialGroup
	BillingControlCategory	_PrjBlgElmEntrJrnlEntrLinkTP	BillingControlCategory	Billing Category
	PersonFullName	_WorkForcePerson	PersonFullName	Full Name
	PersonNumber
	BusinessPartnerUUID
	WorkItem
	PersonnelNumber	_PrjBlgElmEntrJrnlEntrLinkTP	PersonnelNumber	Personnel No.
	SalesDocument	_ProjectBillingRequestTP	SalesDocument	SD Document
	_WorkItem		_WorkItem
	_BillingControlCategoryText		_BillingControlCategoryText
	FiscalYear	_PrjBlgElmEntrJrnlEntrLinkTP	FiscalYear	G/L Fiscal Year
	LedgerGLLineItem	_PrjBlgElmEntrJrnlEntrLinkTP	LedgerGLLineItem	Journal Entry Item
	AccountingDocument	_PrjBlgElmEntrJrnlEntrLinkTP	AccountingDocument	Journal Entry
	DueBillingDate
	_SalesDocumentItem		_SalesDocumentItem
	PrjBlgElmEntryLongText	_ProjectBillingElementEntryTP	PrjBlgElmEntryLongText	long text
	ProjBillingRequestItemLongText	I_ProjectBillingRequestItem	ProjBillingRequestItemLongText	Note
	_ProjectBillingRequest	I_ProjectBillingRequestItem	_ProjectBillingRequest

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_ProjectBillingRequestItemTP.
-- 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: IPROJBILREQITM

CREATE VIEW I_ProjectBillingRequestItemTP AS
SELECT
  ProjectBillingRequestItem.ProjectBillingRequestItemUUID AS ProjectBillingRequestItemUUID,
  ProjectBillingRequestItem.ProjectBillingRequestUUID AS ProjectBillingRequestUUID,
  ProjectBillingRequestItem.ProjBillgElmntEntrItmUUID AS ProjBillgElmntEntrItmUUID,
  ProjectBillingRequestItem.ProjectBillingElementUUID AS ProjectBillingElementUUID,
  ProjectBillingRequestItem.SalesDocumentItem AS SalesDocumentItem,
  ProjectBillingRequestItem.ToBePostponedQuantity AS ToBePostponedQuantity,
  ProjectBillingRequestItem.ToBePostponedAmtInTransacCrcy AS ToBePostponedAmtInTransacCrcy,
  ProjectBillingRequestItem.ToBePostponedAmtInProjectCrcy AS ToBePostponedAmtInProjectCrcy,
  ProjectBillingRequestItem.ToBePostponedAmtInGlobalCrcy AS ToBePostponedAmtInGlobalCrcy,
  ProjectBillingRequestItem.ToBeWrittenOffQuantity AS ToBeWrittenOffQuantity,
  ProjectBillingRequestItem.ToBeWrittenOffAmtInTransCrcy AS ToBeWrittenOffAmtInTransCrcy,
  ProjectBillingRequestItem.ToBeWrittenOffAmtInProjectCrcy AS ToBeWrittenOffAmtInProjectCrcy,
  ProjectBillingRequestItem.ToBeWrittenOffAmtInGlobalCrcy AS ToBeWrittenOffAmtInGlobalCrcy,
  ProjectBillingRequestItem.BillableRevenueAmtInDocCrcy AS BillableRevenueAmtInDocCrcy,
  ProjectBillingRequestItem.ProjBillgReqItmCrtedByUser AS ProjBillgReqItmCrtedByUser,
  ProjectBillingRequestItem.ProjBillgReqItmCrtedAtDteTme AS ProjBillgReqItmCrtedAtDteTme,
  ProjectBillingRequestItem.ProjBillgReqItmLastChgdBy AS ProjBillgReqItmLastChgdBy,
  ProjectBillingRequestItem.ProjBillgReqItmLastChgdDteTme AS ProjBillgReqItmLastChgdDteTme,
  ProjectBillingRequestItem.ServicesRenderedDate AS ServicesRenderedDate,
  ProjectBillingRequestItem.ToBeBilledQuantity AS ToBeBilledQuantity,
  ProjectBillingRequestItem.ToBeBilledAmtInTransCrcy AS ToBeBilledAmtInTransCrcy,
  ProjectBillingRequestItem.ToBeBilledAmtInProjCurrency AS ToBeBilledAmtInProjCurrency,
  ProjectBillingRequestItem.ToBeBilledAmtInGlobCurrency AS ToBeBilledAmtInGlobCurrency,
  ProjectBillingRequestItem.OpenQuantity AS OpenQuantity,
  ProjectBillingRequestItem.OpenAmountInTransCrcy AS OpenAmountInTransCrcy,
  ProjectBillingRequestItem.OpenAmountInProjectCurrency AS OpenAmountInProjectCurrency,
  ProjectBillingRequestItem.OpenAmountInGlobalCurrency AS OpenAmountInGlobalCurrency,
  ProjectBillingRequestItem.OpenRevenueAmtInDocCrcy AS OpenRevenueAmtInDocCrcy,
  ProjectBillingRequestItem.NetPriceAmountInDocCrcy AS NetPriceAmountInDocCrcy,
  ProjectBillingRequestItem.Material AS Material,
  _PrjBlgElmEntrJrnlEntrLinkTP._GLAccountLineItemRawData._OriginCostCtrActivityType._Text[1:Language = $session.system_language].CostCtrActivityTypeDesc AS CostCtrActivityTypeDesc,
  _ProjectBillingElementEntryTP._Material.MaterialGroup AS MaterialGroup,
  ProjectBillingRequestItem.TransactionCurrency AS TransactionCurrency,
  ProjectBillingRequestItem.ProjectCurrency AS ProjectCurrency,
  ProjectBillingRequestItem.QuantityUnit AS QuantityUnit,
  ProjectBillingRequestItem.GlobalCurrency AS GlobalCurrency,
  ProjectBillingRequestItem.DocumentCurrency AS DocumentCurrency,
  ProjectBillingRequestItem.ProjBillgTransfCostQtyCode AS ProjBillgTransfCostQtyCode,
  ProjectBillingRequestItem.ProjBillgItmValIsNotActualCost AS ProjBillgItmValIsNotActualCost,
  ProjectBillingRequestItem.ManualBillgSelForPrjBlgReqItem AS ManualBillgSelForPrjBlgReqItem,
  _PrjBlgElmEntrJrnlEntrLinkTP.BillingControlCategory AS BillingControlCategory,
  _WorkForcePerson.PersonFullName AS PersonFullName,
  _WorkForcePerson._BusinessPartner.PersonNumber AS PersonNumber,
  _WorkForcePerson._BusinessPartner.BusinessPartnerUUID AS BusinessPartnerUUID,
  _PrjBlgElmEntrJrnlEntrLinkTP._GLAccountLineItemRawData.WorkItem AS WorkItem,
  _PrjBlgElmEntrJrnlEntrLinkTP.PersonnelNumber AS PersonnelNumber,
  _ProjectBillingRequestTP.SalesDocument AS SalesDocument,
  _PrjBlgElmEntrJrnlEntrLinkTP.FiscalYear AS FiscalYear,
  _PrjBlgElmEntrJrnlEntrLinkTP.LedgerGLLineItem AS LedgerGLLineItem,
  _PrjBlgElmEntrJrnlEntrLinkTP.AccountingDocument AS AccountingDocument,
  _ProjectBillingElementEntryTP._ProjectBillingElement.BillingPlanBillingDate AS DueBillingDate,
  _ProjectBillingElementEntryTP.PrjBlgElmEntryLongText AS PrjBlgElmEntryLongText,
  ProjectBillingRequestItem.ProjBillingRequestItemLongText AS ProjBillingRequestItemLongText,
  ProjectBillingRequestItem._ProjectBillingRequest AS _ProjectBillingRequest
FROM I_ProjectBillingRequestItem AS ProjectBillingRequestItem
LEFT OUTER JOIN I_ProjectBillingElementEntryTP AS _ProjectBillingElementEntryTP ON ProjBillgElmntEntrItmUUID = _ProjectBillingElementEntryTP.ProjBillgElmntEntrItmUUID  -- association [0..1]
LEFT OUTER JOIN I_WorkItem AS _WorkItem ON WorkItem = _WorkItem.WorkItem  -- association [0..1]
LEFT OUTER JOIN I_MaterialGroup AS _MaterialGroup ON MaterialGroup = _MaterialGroup.MaterialGroup  -- association [0..1]
LEFT OUTER JOIN I_BillingControlCategoryText AS _BillingControlCategoryText ON BillingControlCategory = _BillingControlCategoryText.BillingControlCategory AND _BillingControlCategoryText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_SalesDocumentItem AS _SalesDocumentItem ON SalesDocument = _SalesDocumentItem.SalesDocument AND SalesDocumentItem = _SalesDocumentItem.SalesDocumentItem  -- association [1..1]
;

Depth:

I_ProjectBillingRequestItemTP view_entity

I_ProjectBillingRequestItem view_entity