What is I_ProjectCostLineItemsCube in SAP S/4HANA?

I_ProjectCostLineItemsCube is a composite CDS view in SAP S/4HANA. Project Cost Line Items Cube It contains 107 fields.

Which tables does I_ProjectCostLineItemsCube read from?

I_ProjectCostLineItemsCube reads data from: I_ProjectCostLineItems.

What VDM layer is I_ProjectCostLineItemsCube?

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

I_ProjectCostLineItemsCube

DDL: I_PROJECTCOSTLINEITEMSCUBE SQL: IPROCSTLITMCB Type: view COMPOSITE

107 Fields 1 Data Sources 8 Associations

Project Cost Line Items Cube

I_ProjectCostLineItemsCube is a Composite CDS View (Cube) that provides data about "Project Cost Line Items Cube" in SAP S/4HANA. It reads from 1 data source (I_ProjectCostLineItems) and exposes 107 fields with key fields ProjectObjectNode, Ledger, SourceLedger, CompanyCode, FiscalYear. It has 8 associations to related views.

Data Sources (1)

Source	Alias	Join Type
I_ProjectCostLineItems	_ProjCostLineItems	from

Associations (8)

Cardinality	Target	Alias	Condition
[0..1]	I_ProjectStructure	_ProjectHierarchy	`$projection.ProjectObjectNode = _ProjectHierarchy.ProjectObjectNode`
[0..1]	I_PPM_AuthznByUsrH	_AuthUser	`_AuthUser.ReferencedObjectUUID = $projection.ProjectSummaryTaskUUID and _AuthUser.UserID = $session.user and _AuthUser.Activity = 'Financials'`
[0..*]	I_PPM_AuthznBySubstitH	_AuthSubst	`_AuthSubst.ReferencedObjectUUID = $projection.ProjectSummaryTaskUUID and _AuthSubst.UserID = $session.user and _AuthSubst.Activity = 'Financials'`
[0..*]	I_PPM_AuthznByUserRoleH	_AuthRole	`_AuthRole.ReferencedObjectUUID = $projection.ProjectSummaryTaskUUID and _AuthRole.UserID = $session.user and _AuthRole.Activity = 'Financials'`
[0..*]	I_PPM_AuthznByUsrGrpH	_AuthGroup	`_AuthGroup.ReferencedObjectUUID = $projection.ProjectSummaryTaskUUID and _AuthGroup.UserID = $session.user and _AuthGroup.Activity = 'Financials'`
[0..1]	I_SingleResponsibleForProj	_Responsible	`$projection.ProjectSummaryTaskUUID = _Responsible.ReferencedObjectUUID`
[1..1]	I_User	_UserName	`$projection.AccountingDocCreatedByUser = _UserName.UserID`
[0..1]	I_PlanningCategory	_PlanningCategory	`$projection.PlanningCategory = _PlanningCategory.PlanningCategory`

Annotations (15)

Name	Value	Level
AbapCatalog.sqlViewName	IPROCSTLITMCB	view
Analytics.dataCategory	#CUBE	view
Analytics.dataExtraction.enabled	true	view
VDM.viewType	#COMPOSITE	view
EndUserText.label	Project Cost Line Items Cube	view
AccessControl.authorizationCheck	#CHECK	view
AccessControl.personalData.blocking	#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 (107)

Key	Field	Source Table	Source Field	Description
KEY	ProjectObjectNode	I_ProjectCostLineItems	ProjectObjectNode	Object number
KEY	Ledger	I_ProjectCostLineItems	Ledger	Ledger
KEY	SourceLedger	I_ProjectCostLineItems	SourceLedger	Source Ledger
KEY	CompanyCode	I_ProjectCostLineItems	CompanyCode	Receiver Company Code
KEY	FiscalYear	I_ProjectCostLineItems	FiscalYear	G/L Fiscal Year
KEY	AccountingDocument	I_ProjectCostLineItems	AccountingDocument	Journal Entry
KEY	LedgerGLLineItem	I_ProjectCostLineItems	LedgerGLLineItem	Journal Entry Item
KEY	FinancialPlanningReqTransSqnc	I_ProjectCostLineItems	FinancialPlanningReqTransSqnc	Request TSN
KEY	FinancialPlanningDataPacket	I_ProjectCostLineItems	FinancialPlanningDataPacket	Data packet number
KEY	ActualPlanJournalEntryItem	I_ProjectCostLineItems	ActualPlanJournalEntryItem
	ProjectObjectRootNode	_ProjectHierarchy	ProjectObjectRootNode	Object number
	FinancialPlanningEntryItem	I_ProjectCostLineItems	FinancialPlanningEntryItem
	PlanningCategory	I_ProjectCostLineItems	PlanningCategory	Plan Category
	ControllingObjectCurrency	I_ProjectCostLineItems	ControllingObjectCurrency	CO Object Currency
	AmountInObjectCurrency	I_ProjectCostLineItems	AmountInObjectCurrency	Amount in Obj Crcy
	SemanticTag	I_ProjectCostLineItems	SemanticTag	Semantic Tag
	PostingDate	I_ProjectCostLineItems	PostingDate	Posting Date for GR
	AccountingDocCreatedByUser	I_ProjectCostLineItems	AccountingDocCreatedByUser	User which created overhead document
	ProjectSummaryTaskUUID	I_ProjectCostLineItems	ProjectSummaryTaskUUID	Entity GUID
	ProjectCategory	I_ProjectCostLineItems	ProjectCategory	Proj. Category
	BusinessArea	I_ProjectCostLineItems	BusinessArea	Business Area
	GLAccount	I_ProjectCostLineItems	GLAccount	General Ledger
	ChartOfAccounts	I_ProjectCostLineItems	ChartOfAccounts	Node Class
	ProfitCenter	I_ProjectCostLineItems	ProfitCenter	Profit Center
	WBSElementProfitCenter	I_ProjectCostLineItems	WBSElementProfitCenter
	ControllingArea	I_ProjectCostLineItems	ControllingArea	Controlling Area
	Project	I_ProjectCostLineItems	Project	WBS Element
	ProjectUUID	I_ProjectCostLineItems	ProjectUUID	Project UUID
	ProjectDescription	I_ProjectCostLineItems	ProjectDescription	Project Name
	ProjectProfileCode	I_ProjectCostLineItems	ProjectProfileCode	Project Profile
	ProjectInternalID	I_ProjectCostLineItems	ProjectInternalID	Project Def.
	ProjectObject	I_ProjectCostLineItems	ProjectObject	Object number
	WBSElement	I_ProjectCostLineItems	WBSElement	WBS Internal ID
	WBSDescription	I_ProjectCostLineItems	WBSDescription	WBS Element Name
	ResponsibleCostCenter	I_ProjectCostLineItems	ResponsibleCostCenter	Responsible Cost Center
	ProjectType	I_ProjectCostLineItems	ProjectType	Project Type
	OrderID	I_ProjectCostLineItems	OrderID	Order ID
	MaintenanceOrderIsSelected		MaintenanceOrderIsSelected
	BusinessPartnerFullName	_Responsible	BusinessPartnerFullName	Broker Name
	BusinessPartnerUUID	_Responsible	BusinessPartnerUUID	UUID
	IsBusinessPurposeCompleted	_Responsible	IsBusinessPurposeCompleted	Purpose Completed
	IsCommitment		IsCommitment
	UserDescription	_UserName	UserDescription	Created By
	IsSettled		IsSettled	Is Settled
	FiscalPeriod		FiscalPeriod	Tax period
	FiscalYearPeriod		FiscalYearPeriod	Period/Year
	FiscalYearVariant		FiscalYearVariant	FY Variant
	PlanningCategory1		PlanningCategory1	Plan Category
	PlanningCategory2		PlanningCategory2	Plan Category
	TransactionCurrency		TransactionCurrency	Transaction Currency
	CompanyCodeCurrency		CompanyCodeCurrency	Local Currency
	GlobalCurrency		GlobalCurrency	GM Billing Element: Global Currency
	FreeDefinedCurrency1		FreeDefinedCurrency1	Freely Defined Currency 1
	FreeDefinedCurrency2		FreeDefinedCurrency2	Freely Defined Currency 2
	FreeDefinedCurrency3		FreeDefinedCurrency3	Freely Defined Currency 3
	FreeDefinedCurrency4		FreeDefinedCurrency4	Freely Defined Currency 4
	FreeDefinedCurrency5		FreeDefinedCurrency5	Freely Defined Currency 5
	FreeDefinedCurrency6		FreeDefinedCurrency6	Freely Defined Currency 6
	FreeDefinedCurrency7		FreeDefinedCurrency7	Freely Defined Currency 7
	FreeDefinedCurrency8		FreeDefinedCurrency8	Freely Defined Currency 8
	AmountInTransactionCurrency		AmountInTransactionCurrency	Pt Crcy Amt
	AmountInCompanyCodeCurrency		AmountInCompanyCodeCurrency	Local Crcy Amt
	AmountInGlobalCurrency		AmountInGlobalCurrency	Amount in Global Currency
	AmountInFreeDefinedCurrency1		AmountInFreeDefinedCurrency1	Amount in Freely Defined Currency 1
	AmountInFreeDefinedCurrency2		AmountInFreeDefinedCurrency2	Amount in Freely Defined Currency 2
	AmountInFreeDefinedCurrency3		AmountInFreeDefinedCurrency3	Amount in Freely Defined Currency 3
	AmountInFreeDefinedCurrency4		AmountInFreeDefinedCurrency4	Amount in Freely Defined Currency 4
	AmountInFreeDefinedCurrency5		AmountInFreeDefinedCurrency5	Amount in Freely Defined Currency 5
	AmountInFreeDefinedCurrency6		AmountInFreeDefinedCurrency6	Amount in Freely Defined Currency 6
	AmountInFreeDefinedCurrency7		AmountInFreeDefinedCurrency7	Amount in Freely Defined Currency 7
	AmountInFreeDefinedCurrency8		AmountInFreeDefinedCurrency8	Amount in Freely Defined Currency 8
	ActualAmountInGlobalCurrency		ActualAmountInGlobalCurrency
	ActlCostInProjCrcy		ActlCostInProjCrcy
	ActualAmountInFreeDfndCrcy1		ActualAmountInFreeDfndCrcy1
	ActualAmountInFreeDfndCrcy2		ActualAmountInFreeDfndCrcy2
	ActualAmountInFreeDfndCrcy3		ActualAmountInFreeDfndCrcy3
	ActualAmountInFreeDfndCrcy4		ActualAmountInFreeDfndCrcy4
	ActualAmountInFreeDfndCrcy5		ActualAmountInFreeDfndCrcy5
	ActualAmountInFreeDfndCrcy6		ActualAmountInFreeDfndCrcy6
	ActualAmountInFreeDfndCrcy7		ActualAmountInFreeDfndCrcy7
	ActualAmountInFreeDfndCrcy8		ActualAmountInFreeDfndCrcy8
	PlanAmountInGlobalCurrency		PlanAmountInGlobalCurrency
	PlndCostAmtInProjCrcy		PlndCostAmtInProjCrcy
	PlanAmountInFreeDefinedCrcy1		PlanAmountInFreeDefinedCrcy1
	PlanAmountInFreeDefinedCrcy2		PlanAmountInFreeDefinedCrcy2
	PlanAmountInFreeDefinedCrcy3		PlanAmountInFreeDefinedCrcy3
	PlanAmountInFreeDefinedCrcy4		PlanAmountInFreeDefinedCrcy4
	PlanAmountInFreeDefinedCrcy5		PlanAmountInFreeDefinedCrcy5
	PlanAmountInFreeDefinedCrcy6		PlanAmountInFreeDefinedCrcy6
	PlanAmountInFreeDefinedCrcy7		PlanAmountInFreeDefinedCrcy7
	PlanAmountInFreeDefinedCrcy8		PlanAmountInFreeDefinedCrcy8
	CmtmtCostInGlobalCurrency		CmtmtCostInGlobalCurrency
	CmtmtCostInProjCrcy		CmtmtCostInProjCrcy
	CmtmtCostInFreeDefinedCrcy1		CmtmtCostInFreeDefinedCrcy1
	CmtmtCostInFreeDefinedCrcy2		CmtmtCostInFreeDefinedCrcy2
	CmtmtCostInFreeDefinedCrcy3		CmtmtCostInFreeDefinedCrcy3
	CmtmtCostInFreeDefinedCrcy4		CmtmtCostInFreeDefinedCrcy4
	CmtmtCostInFreeDefinedCrcy5		CmtmtCostInFreeDefinedCrcy5
	CmtmtCostInFreeDefinedCrcy6		CmtmtCostInFreeDefinedCrcy6
	CmtmtCostInFreeDefinedCrcy7		CmtmtCostInFreeDefinedCrcy7
	CmtmtCostInFreeDefinedCrcy8		CmtmtCostInFreeDefinedCrcy8
	_ProjectHierarchy		_ProjectHierarchy
	_UserName		_UserName
	_AuthUser		_AuthUser
	_AuthSubst		_AuthSubst
	_AuthRole		_AuthRole
	_AuthGroup		_AuthGroup

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_ProjectCostLineItemsCube.
-- 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: IPROCSTLITMCB

CREATE VIEW I_ProjectCostLineItemsCube AS
SELECT
  _ProjCostLineItems.ProjectObjectNode AS ProjectObjectNode,
  _ProjCostLineItems.Ledger AS Ledger,
  _ProjCostLineItems.SourceLedger AS SourceLedger,
  _ProjCostLineItems.CompanyCode AS CompanyCode,
  _ProjCostLineItems.FiscalYear AS FiscalYear,
  _ProjCostLineItems.AccountingDocument AS AccountingDocument,
  _ProjCostLineItems.LedgerGLLineItem AS LedgerGLLineItem,
  _ProjCostLineItems.FinancialPlanningReqTransSqnc AS FinancialPlanningReqTransSqnc,
  _ProjCostLineItems.FinancialPlanningDataPacket AS FinancialPlanningDataPacket,
  _ProjCostLineItems.ActualPlanJournalEntryItem AS ActualPlanJournalEntryItem,
  _ProjectHierarchy.ProjectObjectRootNode AS ProjectObjectRootNode,
  _ProjCostLineItems.FinancialPlanningEntryItem AS FinancialPlanningEntryItem,
  _ProjCostLineItems.PlanningCategory AS PlanningCategory,
  _ProjCostLineItems.ControllingObjectCurrency AS ControllingObjectCurrency,
  _ProjCostLineItems.AmountInObjectCurrency AS AmountInObjectCurrency,
  _ProjCostLineItems.SemanticTag AS SemanticTag,
  _ProjCostLineItems.PostingDate AS PostingDate,
  _ProjCostLineItems.AccountingDocCreatedByUser AS AccountingDocCreatedByUser,
  _ProjCostLineItems.ProjectSummaryTaskUUID AS ProjectSummaryTaskUUID,
  _ProjCostLineItems.ProjectCategory AS ProjectCategory,
  _ProjCostLineItems.BusinessArea AS BusinessArea,
  _ProjCostLineItems.GLAccount AS GLAccount,
  _ProjCostLineItems.ChartOfAccounts AS ChartOfAccounts,
  _ProjCostLineItems.ProfitCenter AS ProfitCenter,
  _ProjCostLineItems.WBSElementProfitCenter AS WBSElementProfitCenter,
  _ProjCostLineItems.ControllingArea AS ControllingArea,
  _ProjCostLineItems.Project AS Project,
  _ProjCostLineItems.ProjectUUID AS ProjectUUID,
  _ProjCostLineItems.ProjectDescription AS ProjectDescription,
  _ProjCostLineItems.ProjectProfileCode AS ProjectProfileCode,
  _ProjCostLineItems.ProjectInternalID AS ProjectInternalID,
  _ProjCostLineItems.ProjectObject AS ProjectObject,
  _ProjCostLineItems.WBSElement AS WBSElement,
  _ProjCostLineItems.WBSDescription AS WBSDescription,
  _ProjCostLineItems.ResponsibleCostCenter AS ResponsibleCostCenter,
  _ProjCostLineItems.ProjectType AS ProjectType,
  _ProjCostLineItems.OrderID AS OrderID,
  MaintenanceOrderIsSelected,
  _Responsible.BusinessPartnerFullName AS BusinessPartnerFullName,
  _Responsible.BusinessPartnerUUID AS BusinessPartnerUUID,
  _Responsible.IsBusinessPurposeCompleted AS IsBusinessPurposeCompleted,
  IsCommitment,
  _UserName.UserDescription AS UserDescription,
  IsSettled,
  FiscalPeriod,
  FiscalYearPeriod,
  FiscalYearVariant,
  PlanningCategory1,
  PlanningCategory2,
  TransactionCurrency,
  CompanyCodeCurrency,
  GlobalCurrency,
  FreeDefinedCurrency1,
  FreeDefinedCurrency2,
  FreeDefinedCurrency3,
  FreeDefinedCurrency4,
  FreeDefinedCurrency5,
  FreeDefinedCurrency6,
  FreeDefinedCurrency7,
  FreeDefinedCurrency8,
  AmountInTransactionCurrency,
  AmountInCompanyCodeCurrency,
  AmountInGlobalCurrency,
  AmountInFreeDefinedCurrency1,
  AmountInFreeDefinedCurrency2,
  AmountInFreeDefinedCurrency3,
  AmountInFreeDefinedCurrency4,
  AmountInFreeDefinedCurrency5,
  AmountInFreeDefinedCurrency6,
  AmountInFreeDefinedCurrency7,
  AmountInFreeDefinedCurrency8,
  ActualAmountInGlobalCurrency,
  ActlCostInProjCrcy,
  ActualAmountInFreeDfndCrcy1,
  ActualAmountInFreeDfndCrcy2,
  ActualAmountInFreeDfndCrcy3,
  ActualAmountInFreeDfndCrcy4,
  ActualAmountInFreeDfndCrcy5,
  ActualAmountInFreeDfndCrcy6,
  ActualAmountInFreeDfndCrcy7,
  ActualAmountInFreeDfndCrcy8,
  PlanAmountInGlobalCurrency,
  PlndCostAmtInProjCrcy,
  PlanAmountInFreeDefinedCrcy1,
  PlanAmountInFreeDefinedCrcy2,
  PlanAmountInFreeDefinedCrcy3,
  PlanAmountInFreeDefinedCrcy4,
  PlanAmountInFreeDefinedCrcy5,
  PlanAmountInFreeDefinedCrcy6,
  PlanAmountInFreeDefinedCrcy7,
  PlanAmountInFreeDefinedCrcy8,
  CmtmtCostInGlobalCurrency,
  CmtmtCostInProjCrcy,
  CmtmtCostInFreeDefinedCrcy1,
  CmtmtCostInFreeDefinedCrcy2,
  CmtmtCostInFreeDefinedCrcy3,
  CmtmtCostInFreeDefinedCrcy4,
  CmtmtCostInFreeDefinedCrcy5,
  CmtmtCostInFreeDefinedCrcy6,
  CmtmtCostInFreeDefinedCrcy7,
  CmtmtCostInFreeDefinedCrcy8
FROM I_ProjectCostLineItems AS _ProjCostLineItems
LEFT OUTER JOIN I_ProjectStructure AS _ProjectHierarchy ON ProjectObjectNode = _ProjectHierarchy.ProjectObjectNode  -- association [0..1]
LEFT OUTER JOIN I_PPM_AuthznByUsrH AS _AuthUser ON _AuthUser.ReferencedObjectUUID = ProjectSummaryTaskUUID AND _AuthUser.UserID = $session.user AND _AuthUser.Activity = 'Financials'  -- association [0..1]
LEFT OUTER JOIN I_PPM_AuthznBySubstitH AS _AuthSubst ON _AuthSubst.ReferencedObjectUUID = ProjectSummaryTaskUUID AND _AuthSubst.UserID = $session.user AND _AuthSubst.Activity = 'Financials'  -- association [0..*]
LEFT OUTER JOIN I_PPM_AuthznByUserRoleH AS _AuthRole ON _AuthRole.ReferencedObjectUUID = ProjectSummaryTaskUUID AND _AuthRole.UserID = $session.user AND _AuthRole.Activity = 'Financials'  -- association [0..*]
LEFT OUTER JOIN I_PPM_AuthznByUsrGrpH AS _AuthGroup ON _AuthGroup.ReferencedObjectUUID = ProjectSummaryTaskUUID AND _AuthGroup.UserID = $session.user AND _AuthGroup.Activity = 'Financials'  -- association [0..*]
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_PlanningCategory AS _PlanningCategory ON PlanningCategory = _PlanningCategory.PlanningCategory  -- association [0..1]
;

Depth:

I_ProjectCostLineItemsCube view

I_ProjectCostLineItems view

C_ProjectFinancialReport view