What is I_GteeMIndrctCostItemCube in SAP S/4HANA?

I_GteeMIndrctCostItemCube is a composite CDS view in SAP S/4HANA. Grant Indirect Cost Item - Cube It contains 62 fields.

Which tables does I_GteeMIndrctCostItemCube read from?

I_GteeMIndrctCostItemCube reads data from: P_GteeMIndrctCostPostedItem.

What VDM layer is I_GteeMIndrctCostItemCube?

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

I_GteeMIndrctCostItemCube

DDL: I_GTEEMINDRCTCOSTITEMCUBE SQL: IGRTIDCCUBE Type: view COMPOSITE Package: ODATA_PSM_S4C_GM_REPORTING

62 Fields 1 Data Sources 4 Associations

Grant Indirect Cost Item - Cube

I_GteeMIndrctCostItemCube (Composite)

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

Cross Applications

I_GteeMIndrctCostItemCube is a Composite CDS View (Cube) that provides data about "Grant Indirect Cost Item - Cube" in SAP S/4HANA. It reads from 1 data source (P_GteeMIndrctCostPostedItem) and exposes 62 fields with key fields Ledger, SourceLedger, CompanyCode, FiscalYear, AccountingDocument. It has 4 associations to related views. Part of development package ODATA_PSM_S4C_GM_REPORTING.

SAP API Hub

Category	Composite
State	C1
Line of Business	Cross Applications
Application Component	PSM-GM-GTE-IS
Capabilities	Data Provider for Analytical Queries
Extensible (Key User)	No
Extensible (Developer)	No
Release State (Key User)	Released
Release State (Developer)	Not Released
Package	Cross Applications for SAP S/4HANA Cloud Public Edition

Documentation

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

Data Sources (1)

Source	Alias	Join Type
P_GteeMIndrctCostPostedItem	_GteeMIndrctCostPostedItem	from

Associations (4)

Cardinality	Target	Alias	Condition
[1..1]	I_Grant	_Grant	`$projection.GrantID = _Grant.GrantID`
[0..1]	I_GrantStatus	_GrantStatus	`$projection.GrantLifecycleStatus = _GrantStatus.SystemStatus`
[0..1]	I_SponsoredClassCore	_SponsoredClass	`$projection.SponsoredClass = _SponsoredClass.SponsoredClass`
[0..1]	I_SponsoredProgramCore	_SponsoredProgram	`$projection.SponsoredProgram = _SponsoredProgram.SponsoredProgram`

Annotations (17)

Name	Value	Level
AbapCatalog.sqlViewName	IGRTIDCCUBE	view
AbapCatalog.compiler.compareFilter	true	view
AbapCatalog.preserveKey	true	view
AccessControl.authorizationCheck	#CHECK	view
ClientHandling.algorithm	#SESSION_VARIABLE	view
AccessControl.personalData.blocking	#REQUIRED	view
AbapCatalog.buffering.status	#NOT_ALLOWED	view
EndUserText.label	Grant Indirect Cost Item - Cube	view
VDM.viewType	#COMPOSITE	view
Analytics.dataCategory	#CUBE	view
Analytics.internalName	#LOCAL	view
VDM.lifecycle.contract.type	#PUBLIC_LOCAL_API	view
Metadata.allowExtensions	true	view
Metadata.ignorePropagatedAnnotations	true	view
ObjectModel.usageType.dataClass	#MIXED	view
ObjectModel.usageType.serviceQuality	#D	view
ObjectModel.usageType.sizeCategory	#XXL	view

Fields (62)

Key	Field	Source Table	Source Field	Description
KEY	Ledger	P_GteeMIndrctCostPostedItem	Ledger	Ledger in General Ledger Accounting
KEY	SourceLedger	P_GteeMIndrctCostPostedItem	SourceLedger	Source Ledger
KEY	CompanyCode	P_GteeMIndrctCostPostedItem	CompanyCode	Receiver Company Code
KEY	FiscalYear	P_GteeMIndrctCostPostedItem	FiscalYear	G/L Fiscal Year
KEY	AccountingDocument	P_GteeMIndrctCostPostedItem	AccountingDocument	Journal Entry
KEY	LedgerGLLineItem	P_GteeMIndrctCostPostedItem	LedgerGLLineItem	General Ledger Journal Entry Line Item
	AccountingDocumentItem	P_GteeMIndrctCostPostedItem	AccountingDocumentItem	Journal Entry Posting View Item
	GrantID	P_GteeMIndrctCostPostedItem	GrantID	Sender Grant
	GranteeMgmtSponsor	P_GteeMIndrctCostPostedItem	GranteeMgmtSponsor	Grant Sponsor
	GrantType	P_GteeMIndrctCostPostedItem	GrantType	Grant Type
	GteeMIndrctCostShrngRule	P_GteeMIndrctCostPostedItem	GteeMIndrctCostShrngRule	Rule for Determining Indirect Costs
	GrantLifecycleStatus	P_GteeMIndrctCostPostedItem	GrantLifecycleStatus	Lifecycle Status
	ValidityStartDate	P_GteeMIndrctCostPostedItem	ValidityStartDate	Validity Start Date
	ValidityEndDate	P_GteeMIndrctCostPostedItem	ValidityEndDate	Valid-to Date
	SponsoredClassType	P_GteeMIndrctCostPostedItem	SponsoredClassType	Sponsored Class Type
	SponsoredProgram	P_GteeMIndrctCostPostedItem	SponsoredProgram	Sponsored Program
	SponsoredClass	P_GteeMIndrctCostPostedItem	SponsoredClass	Sponsored Class
	Fund	P_GteeMIndrctCostPostedItem	Fund	Sender Fund
	AccountingDocumentType	P_GteeMIndrctCostPostedItem	AccountingDocumentType	Journal Entry Type
	FinancialAccountType	P_GteeMIndrctCostPostedItem	FinancialAccountType	Fin. Account Type
	ControllingArea	P_GteeMIndrctCostPostedItem	ControllingArea	Controlling Area
	FinancialManagementArea	P_GteeMIndrctCostPostedItem	FinancialManagementArea	Financial Management Area
	GLAccount	P_GteeMIndrctCostPostedItem	GLAccount	General Ledger
	CostCenter	P_GteeMIndrctCostPostedItem	CostCenter	Cost Center
	Customer	P_GteeMIndrctCostPostedItem	Customer	Customer Number
	Supplier	P_GteeMIndrctCostPostedItem	Supplier	Supplier
	SalesOrganization	P_GteeMIndrctCostPostedItem	SalesOrganization	Sales Organization
	DistributionChannel	P_GteeMIndrctCostPostedItem	DistributionChannel	Distribution Channel
	OrganizationDivision	P_GteeMIndrctCostPostedItem	OrganizationDivision	Org. Division
	SalesDocument	P_GteeMIndrctCostPostedItem	SalesDocument	Sales Document
	ServiceDocument	P_GteeMIndrctCostPostedItem	ServiceDocument	Service Document ID
	ServiceDocumentType	P_GteeMIndrctCostPostedItem	ServiceDocumentType	Service Document Type
	ProfitCenter	P_GteeMIndrctCostPostedItem	ProfitCenter	Profit Center
	AssetClass	P_GteeMIndrctCostPostedItem	AssetClass	Asset Class
	Plant	P_GteeMIndrctCostPostedItem	Plant	Valuation Area
	ValuationArea	P_GteeMIndrctCostPostedItem	ValuationArea	Valuation Area
	BusinessArea	P_GteeMIndrctCostPostedItem	BusinessArea	Business Area
	OrderID	P_GteeMIndrctCostPostedItem	OrderID	Order ID
	Segment	P_GteeMIndrctCostPostedItem	Segment	Segment for Segmental Reporting
	IndirectCostAmtInCoCodeCrcy			Indirect Cost Amount in Company Code Currency
	CompanyCodeCurrency	P_GteeMIndrctCostPostedItem	CompanyCodeCurrency	Company Code Currency
	GlobalCurrency	P_GteeMIndrctCostPostedItem	GlobalCurrency	GM Billing Element: Global Currency
	AmountInGlobalCurrency	P_GteeMIndrctCostPostedItem	AmountInGlobalCurrency	Amount in Global Currency
	GrantIsNotRelevantGrant	_Grant	GrantIsNotRelevantGrant	Identify the Not Relevant Grant
	_Grant		_Grant
	_SponsoredClass		_SponsoredClass
	_SponsoredProgram		_SponsoredProgram
	_GrantStatus		_GrantStatus
	_Sponsor		_Sponsor
	_GrantType		_GrantType
	_AccountingDocumentType	P_GteeMIndrctCostPostedItem	_AccountingDocumentType
	_CurrentCostCenter	P_GteeMIndrctCostPostedItem	_CurrentCostCenter
	_CurrentProfitCenter	P_GteeMIndrctCostPostedItem	_CurrentProfitCenter
	_Customer	P_GteeMIndrctCostPostedItem	_Customer
	_Fund	P_GteeMIndrctCostPostedItem	_Fund
	_GLAccountInCompanyCode	P_GteeMIndrctCostPostedItem	_GLAccountInCompanyCode
	_Order	P_GteeMIndrctCostPostedItem	_Order
	_SalesDocument	P_GteeMIndrctCostPostedItem	_SalesDocument
	_ServiceDocument	P_GteeMIndrctCostPostedItem	_ServiceDocument
	_Supplier	P_GteeMIndrctCostPostedItem	_Supplier
	GrantAuthznGrp	_Grant	GrantAuthznGrp	Grants Management: Authorization Groups
	FunctionalArea	P_GteeMIndrctCostPostedItem	FunctionalArea	Sendr Fctl Area

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_GteeMIndrctCostItemCube.
-- 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: IGRTIDCCUBE

CREATE VIEW I_GteeMIndrctCostItemCube AS
SELECT
  _GteeMIndrctCostPostedItem.Ledger AS Ledger,
  _GteeMIndrctCostPostedItem.SourceLedger AS SourceLedger,
  _GteeMIndrctCostPostedItem.CompanyCode AS CompanyCode,
  _GteeMIndrctCostPostedItem.FiscalYear AS FiscalYear,
  _GteeMIndrctCostPostedItem.AccountingDocument AS AccountingDocument,
  _GteeMIndrctCostPostedItem.LedgerGLLineItem AS LedgerGLLineItem,
  _GteeMIndrctCostPostedItem.AccountingDocumentItem AS AccountingDocumentItem,
  _GteeMIndrctCostPostedItem.GrantID AS GrantID,
  _GteeMIndrctCostPostedItem.GranteeMgmtSponsor AS GranteeMgmtSponsor,
  _GteeMIndrctCostPostedItem.GrantType AS GrantType,
  _GteeMIndrctCostPostedItem.GteeMIndrctCostShrngRule AS GteeMIndrctCostShrngRule,
  _GteeMIndrctCostPostedItem.GrantLifecycleStatus AS GrantLifecycleStatus,
  _GteeMIndrctCostPostedItem.ValidityStartDate AS ValidityStartDate,
  _GteeMIndrctCostPostedItem.ValidityEndDate AS ValidityEndDate,
  _GteeMIndrctCostPostedItem.SponsoredClassType AS SponsoredClassType,
  _GteeMIndrctCostPostedItem.SponsoredProgram AS SponsoredProgram,
  _GteeMIndrctCostPostedItem.SponsoredClass AS SponsoredClass,
  _GteeMIndrctCostPostedItem.Fund AS Fund,
  _GteeMIndrctCostPostedItem.AccountingDocumentType AS AccountingDocumentType,
  _GteeMIndrctCostPostedItem.FinancialAccountType AS FinancialAccountType,
  _GteeMIndrctCostPostedItem.ControllingArea AS ControllingArea,
  _GteeMIndrctCostPostedItem.FinancialManagementArea AS FinancialManagementArea,
  _GteeMIndrctCostPostedItem.GLAccount AS GLAccount,
  _GteeMIndrctCostPostedItem.CostCenter AS CostCenter,
  _GteeMIndrctCostPostedItem.Customer AS Customer,
  _GteeMIndrctCostPostedItem.Supplier AS Supplier,
  _GteeMIndrctCostPostedItem.SalesOrganization AS SalesOrganization,
  _GteeMIndrctCostPostedItem.DistributionChannel AS DistributionChannel,
  _GteeMIndrctCostPostedItem.OrganizationDivision AS OrganizationDivision,
  _GteeMIndrctCostPostedItem.SalesDocument AS SalesDocument,
  _GteeMIndrctCostPostedItem.ServiceDocument AS ServiceDocument,
  _GteeMIndrctCostPostedItem.ServiceDocumentType AS ServiceDocumentType,
  _GteeMIndrctCostPostedItem.ProfitCenter AS ProfitCenter,
  _GteeMIndrctCostPostedItem.AssetClass AS AssetClass,
  _GteeMIndrctCostPostedItem.Plant AS Plant,
  _GteeMIndrctCostPostedItem.ValuationArea AS ValuationArea,
  _GteeMIndrctCostPostedItem.BusinessArea AS BusinessArea,
  _GteeMIndrctCostPostedItem.OrderID AS OrderID,
  _GteeMIndrctCostPostedItem.Segment AS Segment,
  cast(_GteeMIndrctCostPostedItem.AmountInCompanyCodeCurrency as gm_idc_amt_in_co_code_crcy preserving type ) AS IndirectCostAmtInCoCodeCrcy,
  _GteeMIndrctCostPostedItem.CompanyCodeCurrency AS CompanyCodeCurrency,
  _GteeMIndrctCostPostedItem.GlobalCurrency AS GlobalCurrency,
  _GteeMIndrctCostPostedItem.AmountInGlobalCurrency AS AmountInGlobalCurrency,
  _Grant.GrantIsNotRelevantGrant AS GrantIsNotRelevantGrant,
  _GteeMIndrctCostPostedItem._AccountingDocumentType AS _AccountingDocumentType,
  _GteeMIndrctCostPostedItem._CurrentCostCenter AS _CurrentCostCenter,
  _GteeMIndrctCostPostedItem._CurrentProfitCenter AS _CurrentProfitCenter,
  _GteeMIndrctCostPostedItem._Customer AS _Customer,
  _GteeMIndrctCostPostedItem._Fund AS _Fund,
  _GteeMIndrctCostPostedItem._GLAccountInCompanyCode AS _GLAccountInCompanyCode,
  _GteeMIndrctCostPostedItem._Order AS _Order,
  _GteeMIndrctCostPostedItem._SalesDocument AS _SalesDocument,
  _GteeMIndrctCostPostedItem._ServiceDocument AS _ServiceDocument,
  _GteeMIndrctCostPostedItem._Supplier AS _Supplier,
  _Grant.GrantAuthznGrp AS GrantAuthznGrp,
  _GteeMIndrctCostPostedItem.FunctionalArea AS FunctionalArea
FROM P_GteeMIndrctCostPostedItem AS _GteeMIndrctCostPostedItem
LEFT OUTER JOIN I_Grant AS _Grant ON GrantID = _Grant.GrantID  -- association [1..1]
LEFT OUTER JOIN I_GrantStatus AS _GrantStatus ON GrantLifecycleStatus = _GrantStatus.SystemStatus  -- association [0..1]
LEFT OUTER JOIN I_SponsoredClassCore AS _SponsoredClass ON SponsoredClass = _SponsoredClass.SponsoredClass  -- association [0..1]
LEFT OUTER JOIN I_SponsoredProgramCore AS _SponsoredProgram ON SponsoredProgram = _SponsoredProgram.SponsoredProgram  -- association [0..1]
;

Depth:

I_GteeMIndrctCostItemCube view

P_GteeMIndrctCostPostedItem view

C_GteeMIndrctCostItemQry1 view