What is I_ProjectBudgetItemsCube in SAP S/4HANA?

I_ProjectBudgetItemsCube is a composite CDS view in SAP S/4HANA. Project Budget Items Cube View It contains 83 fields.

Which tables does I_ProjectBudgetItemsCube read from?

I_ProjectBudgetItemsCube reads data from: I_ProjectBudgetItems.

What VDM layer is I_ProjectBudgetItemsCube?

I_ProjectBudgetItemsCube is classified as a Composite view that combines data from multiple basic views.

I_ProjectBudgetItemsCube

DDL: I_PROJECTBUDGETITEMSCUBE SQL: IPROBUDLITMCB Type: view COMPOSITE

83 Fields 1 Data Sources 5 Associations

Project Budget Items Cube View

I_ProjectBudgetItemsCube is a Composite CDS View (Cube) that provides data about "Project Budget Items Cube View" in SAP S/4HANA. It reads from 1 data source (I_ProjectBudgetItems) and exposes 83 fields with key fields ProjectObjectNode, SourceLedger, Ledger, FiscalYear, AccountingDocument. It has 5 associations to related views.

Data Sources (1)

Source	Alias	Join Type
I_ProjectBudgetItems	_ProjBdgtLineItems	from

Parameters (1)

Name	Type	Default
P_PlanningCategory	fcom_category

Associations (5)

Cardinality	Target	Alias	Condition
[0..1]	I_ProjectBudgetPlngCategory	_BudgetPlnCat	`$projection.PlanningCategory = _BudgetPlnCat.PlanningCategory and _BudgetPlnCat.PlanningCatIsForAvailyCtrl = 'X'`
[0..1]	I_ProjectStructure	_ProjectHierarchy	`$projection.ProjectObjectNode = _ProjectHierarchy.ProjectObjectNode`
[0..1]	I_SingleResponsibleForProj	_Responsible	`$projection.ProjectSummaryTaskUUID = _Responsible.ReferencedObjectUUID`
[1..1]	I_User	_UserName	`$projection.AccountingDocCreatedByUser = _UserName.UserID`
[0..1]	I_SemanticTagText	_SemanticTagVH	`$projection.ParentSemanticTag = _SemanticTagVH.SemanticTag and Language = $session.system_language`

Annotations (16)

Name	Value	Level
AbapCatalog.sqlViewName	IPROBUDLITMCB	view
AbapCatalog.compiler.compareFilter	true	view
AccessControl.authorizationCheck	#CHECK	view
Analytics.dataCategory	#CUBE	view
Analytics.dataExtraction.enabled	true	view
VDM.viewType	#COMPOSITE	view
EndUserText.label	Project Budget Items Cube View	view
AccessControl.personalData.blocking	#NOT_REQUIRED	view
ObjectModel.usageType.sizeCategory	#XXL	view
ObjectModel.usageType.dataClass	#MIXED	view
ObjectModel.usageType.serviceQuality	#D	view
ClientHandling.algorithm	#SESSION_VARIABLE	view
AbapCatalog.buffering.status	#NOT_ALLOWED	view
Metadata.allowExtensions	true	view
AbapCatalog.preserveKey	true	view
VDM.lifecycle.contract.type	#SAP_INTERNAL_API	view

Fields (83)

Key	Field	Source Table	Source Field	Description
KEY	ProjectObjectNode		ProjectObjectNode	Object number
KEY	SourceLedger	I_ProjectBudgetItems	SourceLedger	Source Ledger
KEY	Ledger	I_ProjectBudgetItems	Ledger	Ledger
KEY	FiscalYear	I_ProjectBudgetItems	FiscalYear	G/L Fiscal Year
KEY	AccountingDocument	I_ProjectBudgetItems	AccountingDocument	Journal Entry
KEY	CompanyCode	I_ProjectBudgetItems	CompanyCode	Receiver Company Code
KEY	LedgerGLLineItem	I_ProjectBudgetItems	LedgerGLLineItem	Journal Entry Item
KEY	FinancialPlanningReqTransSqnc	I_ProjectBudgetItems	FinancialPlanningReqTransSqnc	Request TSN
KEY	FinancialPlanningDataPacket	I_ProjectBudgetItems	FinancialPlanningDataPacket	Data packet number
KEY	ActualPlanJournalEntryItem		ActualPlanJournalEntryItem
	PlanningCategory		PlanningCategory	Plan Category
	SemanticTag	I_ProjectBudgetItems	SemanticTag	Semantic Tag
	PostingDate	I_ProjectBudgetItems	PostingDate	Posting Date for GR
	AccountingDocCreatedByUser	I_ProjectBudgetItems	AccountingDocCreatedByUser	User which created overhead document
	ProjectSummaryTaskUUID	I_ProjectBudgetItems	ProjectSummaryTaskUUID	Entity GUID
	ProjectCategory	I_ProjectBudgetItems	ProjectCategory	Proj. Category
	BusinessArea	I_ProjectBudgetItems	BusinessArea	Business Area
	FunctionalArea	I_ProjectBudgetItems	FunctionalArea	Sendr Fctl Area
	GLAccount	I_ProjectBudgetItems	GLAccount	General Ledger
	ChartOfAccounts	I_ProjectBudgetItems	ChartOfAccounts	Node Class
	ProfitCenter	I_ProjectBudgetItems	ProfitCenter	Profit Center
	WBSElementProfitCenter	I_ProjectBudgetItems	WBSElementProfitCenter
	ControllingArea	I_ProjectBudgetItems	ControllingArea	Controlling Area
	Project	I_ProjectBudgetItems	Project	WBS Element
	ProjectInternalID	I_ProjectBudgetItems	ProjectInternalID	Project Def.
	ProjectExternalID	I_ProjectBudgetItems	ProjectExternalID	Project def.
	ProjectDescription	I_ProjectBudgetItems	ProjectDescription	Project Name
	ProjectProfileCode	I_ProjectBudgetItems	ProjectProfileCode	Project Profile
	WBSElement	I_ProjectBudgetItems	WBSElement	WBS Internal ID
	WBSDescription	I_ProjectBudgetItems	WBSDescription	WBS Element Name
	ResponsibleCostCenter	I_ProjectBudgetItems	ResponsibleCostCenter	Responsible Cost Center
	ProjectType	I_ProjectBudgetItems	ProjectType	Project Type
	AvailabilityControlProfile	I_ProjectBudgetItems	AvailabilityControlProfile	Budget Availability Control Profile
	AvailabilityControlIsActive	I_ProjectBudgetItems	AvailabilityControlIsActive	Budget Availability Control is Active
	AvailyCtrlTimeRangeType	I_ProjectBudgetItems	AvailyCtrlTimeRangeType
	BudgetCurrencyRole	I_ProjectBudgetItems	BudgetCurrencyRole
	BusinessPartnerFullName	_Responsible	BusinessPartnerFullName	Broker Name
	BusinessPartnerUUID	_Responsible	BusinessPartnerUUID	UUID
	IsBusinessPurposeCompleted	_Responsible	IsBusinessPurposeCompleted	Purpose Completed
	IsCommitment		IsCommitment
	BudgetPlanningCategory		BudgetPlanningCategory	Plan Category
	UserDescription	_UserName	UserDescription	Created By
	IsSettled			Is Settled
	OrderID		OrderID	Order ID
	PartnerAccountAssignmentType		PartnerAccountAssignmentType	Partner Account Assignment Type
	OrderPlanningCategory		OrderPlanningCategory
	MaintenanceOrderIsSelected		MaintenanceOrderIsSelected
	FiscalPeriod		FiscalPeriod	Tax period
	FiscalYearPeriod		FiscalYearPeriod	Period/Year
	FiscalYearVariant		FiscalYearVariant	FY Variant
	GlobalCurrency		GlobalCurrency	GM Billing Element: Global Currency
	ControllingObjectCurrency		ControllingObjectCurrency	CO Object Currency
	AmountInGlobalCurrency		AmountInGlobalCurrency	Amount in Global Currency
	ActualAmountInGlobalCurrency		ActualAmountInGlobalCurrency
	CmtmtCostInGlobalCurrency		CmtmtCostInGlobalCurrency
	CmtmtCostInProjCrcy		CmtmtCostInProjCrcy
	BudgetInGlobalCrcy		BudgetInGlobalCrcy
	AmountInObjectCurrency		AmountInObjectCurrency	Amount in Obj Crcy
	ActlCostInProjCrcy		ActlCostInProjCrcy
	BudgetInProjCrcy		BudgetInProjCrcy
	PartnerWBSElement	I_ProjectBudgetItems	PartnerWBSElement	WBS Element
	ProjectUUID		ProjectUUID	Project UUID
	TaskUUID		TaskUUID
	AvailabilityControlProfileName		AvailabilityControlProfileName
	ParentSemanticTag		ParentSemanticTag
	SemanticTagName	_SemanticTagVH	SemanticTagName
	SemanticTagIsBudgetRelevant		SemanticTagIsBudgetRelevant
	ProjectIsBudgetRelevant		ProjectIsBudgetRelevant
	BdgtCtrldBdgtCostInGlobCrcy		BdgtCtrldBdgtCostInGlobCrcy
	BdgtCtrldBdgtCostInProjCrcy		BdgtCtrldBdgtCostInProjCrcy
	BdgtCtrldActlAmtInGlobCrcy		BdgtCtrldActlAmtInGlobCrcy
	BdgtCtrldActlAmtInProjCrcy		BdgtCtrldActlAmtInProjCrcy
	BdgtCtrldCmtmtCostInGlobCrcy		BdgtCtrldCmtmtCostInGlobCrcy
	BdgtCtrldCmtmtCostInProjCrcy		BdgtCtrldCmtmtCostInProjCrcy
	AssignedValueCurrency		AssignedValueCurrency
	ActualAmountInObjectCurrency		ActualAmountInObjectCurrency
	CmtmtCostInObjCrcy		CmtmtCostInObjCrcy
	BaselineAmtInObjectCrcy		BaselineAmtInObjectCrcy
	ActualAmountInFreeDfndCrcy7		ActualAmountInFreeDfndCrcy7
	CmtmtCostInFreeDefinedCrcy7		CmtmtCostInFreeDefinedCrcy7
	BaselineAmtInFreeDefinedCrcy7		BaselineAmtInFreeDefinedCrcy7
	_ProjectHierarchy		_ProjectHierarchy
	_UserName		_UserName

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_ProjectBudgetItemsCube.
-- 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: IPROBUDLITMCB
-- Parameters: P_PlanningCategory : fcom_category

CREATE VIEW I_ProjectBudgetItemsCube AS
SELECT
  ProjectObjectNode,
  _ProjBdgtLineItems.SourceLedger AS SourceLedger,
  _ProjBdgtLineItems.Ledger AS Ledger,
  _ProjBdgtLineItems.FiscalYear AS FiscalYear,
  _ProjBdgtLineItems.AccountingDocument AS AccountingDocument,
  _ProjBdgtLineItems.CompanyCode AS CompanyCode,
  _ProjBdgtLineItems.LedgerGLLineItem AS LedgerGLLineItem,
  _ProjBdgtLineItems.FinancialPlanningReqTransSqnc AS FinancialPlanningReqTransSqnc,
  _ProjBdgtLineItems.FinancialPlanningDataPacket AS FinancialPlanningDataPacket,
  ActualPlanJournalEntryItem,
  PlanningCategory,
  _ProjBdgtLineItems.SemanticTag AS SemanticTag,
  _ProjBdgtLineItems.PostingDate AS PostingDate,
  _ProjBdgtLineItems.AccountingDocCreatedByUser AS AccountingDocCreatedByUser,
  _ProjBdgtLineItems.ProjectSummaryTaskUUID AS ProjectSummaryTaskUUID,
  _ProjBdgtLineItems.ProjectCategory AS ProjectCategory,
  _ProjBdgtLineItems.BusinessArea AS BusinessArea,
  _ProjBdgtLineItems.FunctionalArea AS FunctionalArea,
  _ProjBdgtLineItems.GLAccount AS GLAccount,
  _ProjBdgtLineItems.ChartOfAccounts AS ChartOfAccounts,
  _ProjBdgtLineItems.ProfitCenter AS ProfitCenter,
  _ProjBdgtLineItems.WBSElementProfitCenter AS WBSElementProfitCenter,
  _ProjBdgtLineItems.ControllingArea AS ControllingArea,
  _ProjBdgtLineItems.Project AS Project,
  _ProjBdgtLineItems.ProjectInternalID AS ProjectInternalID,
  _ProjBdgtLineItems.ProjectExternalID AS ProjectExternalID,
  _ProjBdgtLineItems.ProjectDescription AS ProjectDescription,
  _ProjBdgtLineItems.ProjectProfileCode AS ProjectProfileCode,
  _ProjBdgtLineItems.WBSElement AS WBSElement,
  _ProjBdgtLineItems.WBSDescription AS WBSDescription,
  _ProjBdgtLineItems.ResponsibleCostCenter AS ResponsibleCostCenter,
  _ProjBdgtLineItems.ProjectType AS ProjectType,
  _ProjBdgtLineItems.AvailabilityControlProfile AS AvailabilityControlProfile,
  _ProjBdgtLineItems.AvailabilityControlIsActive AS AvailabilityControlIsActive,
  _ProjBdgtLineItems.AvailyCtrlTimeRangeType AS AvailyCtrlTimeRangeType,
  _ProjBdgtLineItems.BudgetCurrencyRole AS BudgetCurrencyRole,
  _Responsible.BusinessPartnerFullName AS BusinessPartnerFullName,
  _Responsible.BusinessPartnerUUID AS BusinessPartnerUUID,
  _Responsible.IsBusinessPurposeCompleted AS IsBusinessPurposeCompleted,
  IsCommitment,
  BudgetPlanningCategory,
  _UserName.UserDescription AS UserDescription,
  cast( IsSettled as ps_s4_considersettlement ) AS IsSettled,
  OrderID,
  PartnerAccountAssignmentType,
  OrderPlanningCategory,
  MaintenanceOrderIsSelected,
  FiscalPeriod,
  FiscalYearPeriod,
  FiscalYearVariant,
  GlobalCurrency,
  ControllingObjectCurrency,
  AmountInGlobalCurrency,
  ActualAmountInGlobalCurrency,
  CmtmtCostInGlobalCurrency,
  CmtmtCostInProjCrcy,
  BudgetInGlobalCrcy,
  AmountInObjectCurrency,
  ActlCostInProjCrcy,
  BudgetInProjCrcy,
  _ProjBdgtLineItems.PartnerWBSElement AS PartnerWBSElement,
  ProjectUUID,
  TaskUUID,
  AvailabilityControlProfileName,
  ParentSemanticTag,
  _SemanticTagVH.SemanticTagName AS SemanticTagName,
  SemanticTagIsBudgetRelevant,
  ProjectIsBudgetRelevant,
  BdgtCtrldBdgtCostInGlobCrcy,
  BdgtCtrldBdgtCostInProjCrcy,
  BdgtCtrldActlAmtInGlobCrcy,
  BdgtCtrldActlAmtInProjCrcy,
  BdgtCtrldCmtmtCostInGlobCrcy,
  BdgtCtrldCmtmtCostInProjCrcy,
  AssignedValueCurrency,
  ActualAmountInObjectCurrency,
  CmtmtCostInObjCrcy,
  BaselineAmtInObjectCrcy,
  ActualAmountInFreeDfndCrcy7,
  CmtmtCostInFreeDefinedCrcy7,
  BaselineAmtInFreeDefinedCrcy7
FROM I_ProjectBudgetItems AS _ProjBdgtLineItems
LEFT OUTER JOIN I_ProjectBudgetPlngCategory AS _BudgetPlnCat ON PlanningCategory = _BudgetPlnCat.PlanningCategory AND _BudgetPlnCat.PlanningCatIsForAvailyCtrl = 'X'  -- association [0..1]
LEFT OUTER JOIN I_ProjectStructure AS _ProjectHierarchy ON ProjectObjectNode = _ProjectHierarchy.ProjectObjectNode  -- association [0..1]
LEFT OUTER JOIN I_SingleResponsibleForProj AS _Responsible ON ProjectSummaryTaskUUID = _Responsible.ReferencedObjectUUID  -- association [0..1]
LEFT OUTER JOIN I_User AS _UserName ON AccountingDocCreatedByUser = _UserName.UserID  -- association [1..1]
LEFT OUTER JOIN I_SemanticTagText AS _SemanticTagVH ON ParentSemanticTag = _SemanticTagVH.SemanticTag AND Language = $session.system_language  -- association [0..1]
;

Depth:

I_ProjectBudgetItemsCube view

I_ProjectBudgetItems view

C_ProjectBudgetReport view