What is C_ProjectBillingRequestItemTP in SAP S/4HANA?

C_ProjectBillingRequestItemTP is a consumption CDS view in SAP S/4HANA. Item Details of Project Billing Request It contains 77 fields.

Which tables does C_ProjectBillingRequestItemTP read from?

C_ProjectBillingRequestItemTP reads data from: R_ProjectBillingRequestItemTP.

What VDM layer is C_ProjectBillingRequestItemTP?

C_ProjectBillingRequestItemTP is classified as a Consumption view optimized for specific business scenarios and reporting.

C_ProjectBillingRequestItemTP

DDL: C_PROJECTBILLINGREQUESTITEMTP Type: view_entity CONSUMPTION

77 Fields 1 Data Sources 2 Associations

Item Details of Project Billing Request

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

Data Sources (1)

Source	Alias	Join Type
R_ProjectBillingRequestItemTP	R_ProjectBillingRequestItemTP	projection

Associations (2)

Cardinality	Target	Alias	Condition
[0..1]	I_UserContactCard	_UserContactCard	`$projection.BusinessPartnerUUID = _UserContactCard.BusinessPartnerUUID and _UserContactCard.Person <> ''`
[0..1]	E_JournalEntryItem	_JournalEntryItemExtension	`$projection.Ledger = _JournalEntryItemExtension.SourceLedger and $projection.CompanyCode = _JournalEntryItemExtension.CompanyCode and $projection.FiscalYear = _JournalEntryItemExtension.FiscalYear and $projection.AccountingDocument = _JournalEntryItemExtension.AccountingDocument and $projection.LedgerGLLineItem = _JournalEntryItemExtension.LedgerGLLineItem`

Annotations (8)

Name	Value	Level
EndUserText.label	Item Details of Project Billing Request	view
VDM.viewType	#CONSUMPTION	view
AccessControl.authorizationCheck	#CHECK	view
AccessControl.personalData.blocking	#REQUIRED	view
ObjectModel.usageType.sizeCategory	#XL	view
ObjectModel.usageType.dataClass	#TRANSACTIONAL	view
ObjectModel.usageType.serviceQuality	#C	view
ObjectModel.representativeKey	ProjectBillingRequestItemUUID	view

Fields (77)

Key	Field	Source Table	Source Field	Description
KEY	ProjectBillingRequestItemUUID	ProjectBillingRequestItem	ProjectBillingRequestItemUUID	Item ID
	ProjectBillingRequestUUID	ProjectBillingRequestItem	ProjectBillingRequestUUID	Proj Billg Req UUID
	WBSElement			Work Package
	WBSDescription			Work Package Name
	BillingWBSElementExternalID			Billing Element
	BillingWBSElementDescription			Billing Element Description
	Material	ProjectBillingRequestItem	Material	Material
	MaterialNameasMaterialNamelocalized			Material
	CostCtrActivityTypeDesc	ProjectBillingRequestItem	CostCtrActivityTypeDesc	Expense Type / Activity Type
	char30			Journal Entry/Item/Fiscal Year
	WorkItem	ProjectBillingRequestItem	WorkItem	Work Item
	MaterialGroup	ProjectBillingRequestItem	MaterialGroup	Material Group Name
	curr232			Cost Rate
	CompanyCode			Company Code
	ServicesRenderedDate	ProjectBillingRequestItem	ServicesRenderedDate	Service Date
	curr232			Net Rate
	NetPriceQuantity		NetPriceQuantity	Net Rate Unit
	ProjBillgElmntEntrItmUUID	ProjectBillingRequestItem	ProjBillgElmntEntrItmUUID	PBE Entry UUID
	ProjectBillingElementUUID	ProjectBillingRequestItem	ProjectBillingElementUUID	PBE UUID
	SalesDocumentItem	ProjectBillingRequestItem	SalesDocumentItem	Sales Document Item
	SalesDocument	ProjectBillingRequestItem	SalesDocument	Sales Document/Item
	ToBeBilledAmtInTransCrcy	ProjectBillingRequestItem	ToBeBilledAmtInTransCrcy	Amount/Cost to Bill
	ToBePostponedAmtInTransacCrcy	ProjectBillingRequestItem	ToBePostponedAmtInTransacCrcy	Amount/Cost to Postpone
	curr232			Amount/Cost to Postpone
	ToBePostponedAmtInProjectCrcy	ProjectBillingRequestItem	ToBePostponedAmtInProjectCrcy	Amt ToPostpn PrCrcy
	ToBePostponedAmtInGlobalCrcy	ProjectBillingRequestItem	ToBePostponedAmtInGlobalCrcy	Amt ToPostpn GlCrcy
	ToBeWrittenOffAmtInTransCrcy	ProjectBillingRequestItem	ToBeWrittenOffAmtInTransCrcy	Amount/Cost to Write Off
	OpenQuantity	ProjectBillingRequestItem	OpenQuantity	Open Quantity
	ToBeBilledQuantity	ProjectBillingRequestItem	ToBeBilledQuantity	Quantity to Bill
	ToBePostponedQuantity	ProjectBillingRequestItem	ToBePostponedQuantity	Quantity to Postpone
	ToBeWrittenOffQuantity	ProjectBillingRequestItem	ToBeWrittenOffQuantity	Quantity to Write Off
	ToBeWrittenOffAmtInProjectCrcy	ProjectBillingRequestItem	ToBeWrittenOffAmtInProjectCrcy	Amt ToWrtOff PrCrcy
	ToBeWrittenOffAmtInGlobalCrcy	ProjectBillingRequestItem	ToBeWrittenOffAmtInGlobalCrcy	Amt ToWrtOff GlCrcy
	ToBeBilledAmtInProjCurrency	ProjectBillingRequestItem	ToBeBilledAmtInProjCurrency	To Be Blld Proj Crcy
	ToBeBilledAmtInGlobCurrency	ProjectBillingRequestItem	ToBeBilledAmtInGlobCurrency	To Be Blld GlobCrcy
	OriginalAmountInProjectCrcy	_ProjectBillingElementEntryTP	OriginalAmountInProjectCrcy	Origl Amt Proj Crcy
	PersonFullName	ProjectBillingRequestItem	PersonFullName	Performed By
	BusinessPartnerUUID	ProjectBillingRequestItem	BusinessPartnerUUID	UUID
	ProjBillgReqItmCrtedByUser	ProjectBillingRequestItem	ProjBillgReqItmCrtedByUser	Created By User
	ProjBillgReqItmCrtedAtDteTme	ProjectBillingRequestItem	ProjBillgReqItmCrtedAtDteTme	Created At Time
	ProjBillgReqItmLastChgdBy	ProjectBillingRequestItem	ProjBillgReqItmLastChgdBy	Item Changed By
	ProjBillgReqItmLastChgdDteTme	ProjectBillingRequestItem	ProjBillgReqItmLastChgdDteTme	Item Changed On
	DocumentCurrency	ProjectBillingRequestItem	DocumentCurrency	Document Currency
	QuantityUnit	ProjectBillingRequestItem	QuantityUnit	Unit of measure
	NetPriceQuantityUnit	ProjectBillingRequestItem	NetPriceQuantityUnit	SettlmtPrcUnit
	ProjectCurrency	ProjectBillingRequestItem	ProjectCurrency	Project Currency
	GlobalCurrency	ProjectBillingRequestItem	GlobalCurrency	GM Billing Element: Global Currency
	TransactionCurrency	ProjectBillingRequestItem	TransactionCurrency	Transaction Currency
	virtualWorkItemNamecpdpfp_workitem_name			Work Item
	OpenAmountInTransCrcy	ProjectBillingRequestItem	OpenAmountInTransCrcy	Open Amount/Cost
	OpenAmountInProjectCurrency	ProjectBillingRequestItem	OpenAmountInProjectCurrency	Open Amount/Cost in Project Currency
	OpenAmountInGlobalCurrency	ProjectBillingRequestItem	OpenAmountInGlobalCurrency	Open Amount/Cost in Global Currency
	OpenRevenueAmtInDocCrcy	ProjectBillingRequestItem	OpenRevenueAmtInDocCrcy	Open Revenue
	BillableRevenueAmtInDocCrcy	ProjectBillingRequestItem	BillableRevenueAmtInDocCrcy	To Bill
	MaterialByCustomer	_CustomerMaterial	MaterialByCustomer	Customer Material
	MaterialDescriptionByCustomer	_CustomerMaterial	MaterialDescriptionByCustomer	Customer Material Description
	ProjBillgElmntEntrSourceType	ProjectBillingRequestItem	ProjBillgElmntEntrSourceType	PBE Entry SourceType
	BillingControlCategoryText	_BillingControlCategoryText	BillingControlCategoryText	Billing Control Category
	Ledger	ProjectBillingRequestItem	Ledger	Ledger
	FiscalYear	ProjectBillingRequestItem	FiscalYear	G/L Fiscal Year
	AccountingDocument	ProjectBillingRequestItem	AccountingDocument	Journal Entry/Item/Fiscal Year
	LedgerGLLineItem	ProjectBillingRequestItem	LedgerGLLineItem	Journal Entry Item
	ManualBillgSelForPrjBlgReqItem	ProjectBillingRequestItem	ManualBillgSelForPrjBlgReqItem	MnlBllySelection
	BillingControlCategory	ProjectBillingRequestItem	BillingControlCategory	Billing Category
	PrjBlgElmEntrLastChgdAtDteTme	_ProjectBillingElementEntryTP	PrjBlgElmEntrLastChgdAtDteTme	PBE Entry Changed On
	dats8			Billing Due Date
	DueBillingDate	ProjectBillingRequestItem	DueBillingDate
	_UserContactCard		_UserContactCard
	ProjBillingRequestItemLongText	ProjectBillingRequestItem	ProjBillingRequestItemLongText	Note
	BillingPlanServiceStartDate			Service Start Date
	BillingPlanServiceEndDate			Service End Date
	BillingPlanUsageCategory
	ProjBillgReqItmSourceType	ProjectBillingRequestItem	ProjBillgReqItmSourceType	PBR Item SourceType
	ProjectBillingRequestItemDesc	ProjectBillingRequestItem	ProjectBillingRequestItemDesc	Item Description
	TimeSheetOvertimeCategory	ProjectBillingRequestItem	TimeSheetOvertimeCategory
	TimeSheetOvertimeCategoryText	_TimeSheetOvertimeCatText	TimeSheetOvertimeCategoryText	Overtime Category
	_ProjectBillingRequest	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 C_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.

CREATE VIEW C_ProjectBillingRequestItemTP AS
SELECT
  ProjectBillingRequestItem.ProjectBillingRequestItemUUID AS ProjectBillingRequestItemUUID,
  ProjectBillingRequestItem.ProjectBillingRequestUUID AS ProjectBillingRequestUUID,
  _ProjectBillingElementEntryTP._WBSElement.WBSElementExternalID AS WBSElement,
  _ProjectBillingElementEntryTP._WBSElement.WBSDescription AS WBSDescription,
  _ProjectBillingElementEntryTP._ProjectBillingElement._WBSElement.WBSElementExternalID AS BillingWBSElementExternalID,
  _ProjectBillingElementEntryTP._ProjectBillingElement._WBSElement.WBSDescription AS BillingWBSElementDescription,
  ProjectBillingRequestItem.Material AS Material,
  ProjectBillingRequestItem._Material._Text.MaterialName as MaterialName : localized AS MaterialNameasMaterialNamelocalized,
  ProjectBillingRequestItem.CostCtrActivityTypeDesc AS CostCtrActivityTypeDesc,
  virtual JournalEntrySemanticKey : abap.char( 30 ) AS char30,
  ProjectBillingRequestItem.WorkItem AS WorkItem,
  ProjectBillingRequestItem.MaterialGroup AS MaterialGroup,
  virtual BaseUnitActualCost : abap.curr( 23, 2 ) AS curr232,
  _ProjectBillingElementEntryTP._WBSElement.CompanyCode AS CompanyCode,
  ProjectBillingRequestItem.ServicesRenderedDate AS ServicesRenderedDate,
  NetPriceQuantity,
  ProjectBillingRequestItem.ProjBillgElmntEntrItmUUID AS ProjBillgElmntEntrItmUUID,
  ProjectBillingRequestItem.ProjectBillingElementUUID AS ProjectBillingElementUUID,
  ProjectBillingRequestItem.SalesDocumentItem AS SalesDocumentItem,
  ProjectBillingRequestItem.SalesDocument AS SalesDocument,
  ProjectBillingRequestItem.ToBeBilledAmtInTransCrcy AS ToBeBilledAmtInTransCrcy,
  ProjectBillingRequestItem.ToBePostponedAmtInTransacCrcy AS ToBePostponedAmtInTransacCrcy,
  ProjectBillingRequestItem.ToBePostponedAmtInProjectCrcy AS ToBePostponedAmtInProjectCrcy,
  ProjectBillingRequestItem.ToBePostponedAmtInGlobalCrcy AS ToBePostponedAmtInGlobalCrcy,
  ProjectBillingRequestItem.ToBeWrittenOffAmtInTransCrcy AS ToBeWrittenOffAmtInTransCrcy,
  ProjectBillingRequestItem.OpenQuantity AS OpenQuantity,
  ProjectBillingRequestItem.ToBeBilledQuantity AS ToBeBilledQuantity,
  ProjectBillingRequestItem.ToBePostponedQuantity AS ToBePostponedQuantity,
  ProjectBillingRequestItem.ToBeWrittenOffQuantity AS ToBeWrittenOffQuantity,
  ProjectBillingRequestItem.ToBeWrittenOffAmtInProjectCrcy AS ToBeWrittenOffAmtInProjectCrcy,
  ProjectBillingRequestItem.ToBeWrittenOffAmtInGlobalCrcy AS ToBeWrittenOffAmtInGlobalCrcy,
  ProjectBillingRequestItem.ToBeBilledAmtInProjCurrency AS ToBeBilledAmtInProjCurrency,
  ProjectBillingRequestItem.ToBeBilledAmtInGlobCurrency AS ToBeBilledAmtInGlobCurrency,
  _ProjectBillingElementEntryTP.OriginalAmountInProjectCrcy AS OriginalAmountInProjectCrcy,
  ProjectBillingRequestItem.PersonFullName AS PersonFullName,
  ProjectBillingRequestItem.BusinessPartnerUUID AS BusinessPartnerUUID,
  ProjectBillingRequestItem.ProjBillgReqItmCrtedByUser AS ProjBillgReqItmCrtedByUser,
  ProjectBillingRequestItem.ProjBillgReqItmCrtedAtDteTme AS ProjBillgReqItmCrtedAtDteTme,
  ProjectBillingRequestItem.ProjBillgReqItmLastChgdBy AS ProjBillgReqItmLastChgdBy,
  ProjectBillingRequestItem.ProjBillgReqItmLastChgdDteTme AS ProjBillgReqItmLastChgdDteTme,
  ProjectBillingRequestItem.DocumentCurrency AS DocumentCurrency,
  ProjectBillingRequestItem.QuantityUnit AS QuantityUnit,
  ProjectBillingRequestItem.NetPriceQuantityUnit AS NetPriceQuantityUnit,
  ProjectBillingRequestItem.ProjectCurrency AS ProjectCurrency,
  ProjectBillingRequestItem.GlobalCurrency AS GlobalCurrency,
  ProjectBillingRequestItem.TransactionCurrency AS TransactionCurrency,
  virtual WorkItemName : /cpd/pfp_workitem_name AS virtualWorkItemNamecpdpfp_workitem_name,
  ProjectBillingRequestItem.OpenAmountInTransCrcy AS OpenAmountInTransCrcy,
  ProjectBillingRequestItem.OpenAmountInProjectCurrency AS OpenAmountInProjectCurrency,
  ProjectBillingRequestItem.OpenAmountInGlobalCurrency AS OpenAmountInGlobalCurrency,
  ProjectBillingRequestItem.OpenRevenueAmtInDocCrcy AS OpenRevenueAmtInDocCrcy,
  ProjectBillingRequestItem.BillableRevenueAmtInDocCrcy AS BillableRevenueAmtInDocCrcy,
  _CustomerMaterial.MaterialByCustomer AS MaterialByCustomer,
  _CustomerMaterial.MaterialDescriptionByCustomer AS MaterialDescriptionByCustomer,
  ProjectBillingRequestItem.ProjBillgElmntEntrSourceType AS ProjBillgElmntEntrSourceType,
  _BillingControlCategoryText.BillingControlCategoryText AS BillingControlCategoryText,
  ProjectBillingRequestItem.Ledger AS Ledger,
  ProjectBillingRequestItem.FiscalYear AS FiscalYear,
  ProjectBillingRequestItem.AccountingDocument AS AccountingDocument,
  ProjectBillingRequestItem.LedgerGLLineItem AS LedgerGLLineItem,
  ProjectBillingRequestItem.ManualBillgSelForPrjBlgReqItem AS ManualBillgSelForPrjBlgReqItem,
  ProjectBillingRequestItem.BillingControlCategory AS BillingControlCategory,
  _ProjectBillingElementEntryTP.PrjBlgElmEntrLastChgdAtDteTme AS PrjBlgElmEntrLastChgdAtDteTme,
  virtual BillingPlanBillingDate : abap.dats(8) AS dats8,
  ProjectBillingRequestItem.DueBillingDate AS DueBillingDate,
  ProjectBillingRequestItem.ProjBillingRequestItemLongText AS ProjBillingRequestItemLongText,
  _ProjectBillingElementEntryTP._PrjBlgElmEntrBillgPlnLnk._SalesDocumentBillingPlanItem.BillingPlanServiceStartDate AS BillingPlanServiceStartDate,
  _ProjectBillingElementEntryTP._PrjBlgElmEntrBillgPlnLnk._SalesDocumentBillingPlanItem.BillingPlanServiceEndDate AS BillingPlanServiceEndDate,
  _ProjectBillingElementEntryTP._ProjectBillingElement._SalesDocItemBillPlan.BillingPlanUsageCategory AS BillingPlanUsageCategory,
  ProjectBillingRequestItem.ProjBillgReqItmSourceType AS ProjBillgReqItmSourceType,
  ProjectBillingRequestItem.ProjectBillingRequestItemDesc AS ProjectBillingRequestItemDesc,
  ProjectBillingRequestItem.TimeSheetOvertimeCategory AS TimeSheetOvertimeCategory,
  _TimeSheetOvertimeCatText.TimeSheetOvertimeCategoryText AS TimeSheetOvertimeCategoryText,
  ProjectBillingRequestItem._ProjectBillingRequest AS _ProjectBillingRequest
FROM R_ProjectBillingRequestItemTP
LEFT OUTER JOIN I_UserContactCard AS _UserContactCard ON BusinessPartnerUUID = _UserContactCard.BusinessPartnerUUID AND _UserContactCard.Person <> ''  -- association [0..1]
LEFT OUTER JOIN E_JournalEntryItem AS _JournalEntryItemExtension ON Ledger = _JournalEntryItemExtension.SourceLedger AND CompanyCode = _JournalEntryItemExtension.CompanyCode AND FiscalYear = _JournalEntryItemExtension.FiscalYear AND AccountingDocument = _JournalEntryItemExtension.AccountingDocument AND LedgerGLLineItem = _JournalEntryItemExtension.LedgerGLLineItem  -- association [0..1]
;

Depth:

C_ProjectBillingRequestItemTP view_entity

R_ProjectBillingRequestItemTP view_entity