What is I_PubSecGteeMBdgtActlCube in SAP S/4HANA?

I_PubSecGteeMBdgtActlCube is a composite CDS view in SAP S/4HANA. Grant Budget Actual Items - Cube It contains 109 fields.

Which tables does I_PubSecGteeMBdgtActlCube read from?

I_PubSecGteeMBdgtActlCube reads data from: I_Grant.

What VDM layer is I_PubSecGteeMBdgtActlCube?

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

I_PubSecGteeMBdgtActlCube

DDL: I_PUBSECGTEEMBDGTACTLCUBE SQL: IGMTGTACTCUBE Type: view COMPOSITE Package: ODATA_PSM_S4C_GM_REPORTING

109 Fields 1 Data Sources 7 Associations

Grant Budget Actual Items - Cube

I_PubSecGteeMBdgtActlCube (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_PubSecGteeMBdgtActlCube is a Composite CDS View (Cube) that provides data about "Grant Budget Actual Items - Cube" in SAP S/4HANA. It reads from 1 data source (I_Grant) and exposes 109 fields with key fields SourceLedger, Ledger, CompanyCode, FiscalYear, AccountingDocument. It has 7 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
I_Grant	_iGrant	from

Associations (7)

Cardinality	Target	Alias	Condition
[0..1]	I_PubSecBudgetAccount	_PubSecBudgetAccount	`$projection.PubSecBudgetAccountCoCode = _PubSecBudgetAccount.PubSecBudgetAccountCoCode and $projection.PubSecBudgetAccount = _PubSecBudgetAccount.PubSecBudgetAccount`
[0..1]	I_PubSecBdgtAcctRevnExpnCode	_PubSecBdgtAcctRevnExpnCode	`$projection.PubSecBdgtAcctRevnExpnCode = _PubSecBdgtAcctRevnExpnCode.PubSecBdgtAcctRevnExpnCode`
[1..1]	I_BPEmploymentIndustry	_BPEmploymentIndustry	`$projection.BusPartEmplrIndstryCode = _BPEmploymentIndustry.BusPartEmplrIndstryCode`
[1..1]	I_Grant	_GrantMaster	`$projection.GrantID = _GrantMaster.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	IGMTGTACTCUBE	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 Budget Actual Items - 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 (109)

Key	Field	Source Table	Source Field	Description
KEY	SourceLedger	AcItem	SourceLedger	Source Ledger
KEY	Ledger	AcItem	Ledger	Ledger in General Ledger Accounting
KEY	CompanyCode	AcItem	CompanyCode	Receiver Company Code
KEY	FiscalYear	AcItem	FiscalYear	G/L Fiscal Year
KEY	AccountingDocument	AcItem	AccountingDocument	Journal Entry
KEY	FinancialPlanningReqTransSqnc	AcItem	FinancialPlanningReqTransSqnc	Financial Planning Request Transaction Sequence Number
KEY	FinancialPlanningDataPacket	AcItem	FinancialPlanningDataPacket	Financial Planning Data Packet Number
KEY	ActualPlanJournalEntryItem	AcItem	ActualPlanJournalEntryItem	Actual Plan Journal Entry Item
KEY	GrantID	I_Grant	GrantID	Sender Grant
	ActualPlanCode	AcItem	ActualPlanCode	Actual Plan Code
	Fund	AcItem	Fund	Sender Fund
	FundType			Fund Type
	GranteeMgmtFundType			Fund Type for Grants Management
	GranteeMgmtSponsor	I_Grant	GranteeMgmtSponsor	Grant Sponsor
	GrantLifecycleStatus	I_Grant	GrantLifecycleStatus	Lifecycle Status
	GrantStatus	I_Grant	GrantStatus	Workflow Status
	GrantType	I_Grant	GrantType	Grant Type
	BusPartEmplrIndstryCode			Industry
	ValidityEndDate	I_Grant	ValidityEndDate	Valid-to Date
	ValidityStartDate	I_Grant	ValidityStartDate	Validity Start Date
	SponsoredClass	AcItem	SponsoredClass	Sponsored Class
	SponsoredProgram	AcItem	SponsoredProgram	Sponsored Program
	CompanyCodeCurrency	AcItem	CompanyCodeCurrency	Company Code Currency
	AmountInCompanyCodeCurrency	AcItem	AmountInCompanyCodeCurrency	Amount in Company Code Currency
	AmountInGlobalCurrency	AcItem	AmountInGlobalCurrency	Amount in Global Currency
	PostingDate	AcItem	PostingDate	Posting Date for GR
	PubSecBudgetCnsmpnDate	AcItem	PubSecBudgetCnsmpnDate	Budget Consumption Date
	Country			Country/Region Key
	CityName			City
	Region			Region (State, Province, County)
	PubSecBdgtAcctRevnExpnCode	_PubSecBudgetAccount	PubSecBdgtAcctRevnExpnCode	Expense or Revenue on Budget Account
	LedgerGLLineItem	AcItem	LedgerGLLineItem	General Ledger Journal Entry Line Item
	FinancialPlanningEntryItem	AcItem	FinancialPlanningEntryItem	Financial Planning Entry Item
	ControllingArea	AcItem	ControllingArea	Controlling Area
	GLAccount	AcItem	GLAccount	General Ledger
	BusinessArea	AcItem	BusinessArea	Business Area
	ProfitCenter	AcItem	ProfitCenter	Profit Center
	FunctionalArea	AcItem	FunctionalArea	Sendr Fctl Area
	CostCenter	AcItem	CostCenter	Cost Center
	WBSElementExternalID	AcItem	WBSElementExternalID	WBS Element External ID
	Segment	AcItem	Segment	Segment for Segmental Reporting
	OrderID	AcItem	OrderID	Order ID
	AccountingDocumentType	AcItem	AccountingDocumentType	Journal Entry Type
	FinancialAccountType	AcItem	FinancialAccountType	Fin. Account Type
	FiscalPeriod	AcItem	FiscalPeriod	Fiscal Period
	PlanningCategory	AcItem	PlanningCategory	Plan Category
	ValuationArea	AcItem	ValuationArea	Valuation Area
	Plant	AcItem	Plant	Valuation Area
	Customer	AcItem	Customer	Customer Number
	Supplier	AcItem	Supplier	Supplier
	SalesDocument	AcItem	SalesDocument	Sales Document
	ServiceDocument	AcItem	ServiceDocument	Service Document ID
	ServiceDocumentType	AcItem	ServiceDocumentType	Service Document Type
	SalesOrganization	AcItem	SalesOrganization	Sales Organization
	DistributionChannel	AcItem	DistributionChannel	Distribution Channel
	OrganizationDivision	AcItem	OrganizationDivision	Organization Division
	FinancialManagementArea	AcItem	FinancialManagementArea	Financial Management Area
	PubSecBudgetAccount	AcItem	PubSecBudgetAccount	Budget Account
	PubSecBudgetAccountCoCode	AcItem	PubSecBudgetAccountCoCode	Company Code for Budget Account
	PubSecBudgetCnsmpnType	AcItem	PubSecBudgetCnsmpnType	Budget Consumption Type
	PubSecBudgetCnsmpnTypeGroup			Budget Consumption Type Group
	PubSecBudgetIsRelevant	AcItem	PubSecBudgetIsRelevant	Budget-Relevant Indicator
	GlobalCurrency	AcItem	GlobalCurrency	GM Billing Element: Global Currency
	BudgetProcess	AcItem	BudgetProcess	Budget Process Type
	BudgetingType	AcItem	BudgetingType	Budget Type (Subcategory)
	GrantIsNotRelevantGrant	I_Grant	GrantIsNotRelevantGrant	Identify the Not Relevant Grant
	FiscalYearVariant	AcItem	FiscalYearVariant	Fiscal Year Variant
	_FinancialManagementArea	AcItem	_FinancialManagementArea
	_ProfitCenter	AcItem	_ProfitCenter
	_FunctionalArea	AcItem	_FunctionalArea
	_BudgetingType	AcItem	_BudgetingType
	_Segment	AcItem	_Segment
	_GLAccountInCompanyCode	AcItem	_GLAccountInCompanyCode
	_CompanyCode	AcItem	_CompanyCode
	_CompanyCodeCurrency	AcItem	_CompanyCodeCurrency
	_GlobalCurrency	AcItem	_GlobalCurrency
	_FiscalYear	AcItem	_FiscalYear
	_JournalEntry	AcItem	_JournalEntry
	_Ledger	AcItem	_Ledger
	_SourceLedger	AcItem	_SourceLedger
	_Fund	AcItem	_Fund
	_CostCenter	AcItem	_CostCenter
	_WBSElementExternalID	AcItem	_WBSElementExternalID
	_ControllingArea	AcItem	_ControllingArea
	_Sponsor	I_Grant	_Sponsor
	_Text	I_Grant	_Text
	_GrantLifecycleStatus	I_Grant	_GrantLifecycleStatus
	_Status	I_Grant	_GrantStatus
	_GrantType	I_Grant	_GrantType
	_GrantMaster		_GrantMaster
	_GrantStatus		_GrantStatus
	_BPEmploymentIndustry		_BPEmploymentIndustry
	_SponsoredProgram		_SponsoredProgram
	_SponsoredClass		_SponsoredClass
	_PubSecBudgetAccount		_PubSecBudgetAccount
	_PubSecBdgtAcctRevnExpnCode		_PubSecBdgtAcctRevnExpnCode
	_PubSecBdgtCnsmpnType	AcItem	_PubSecBdgtCnsmpnType
	_PubSecBudgetCnsmpnTypeGroup
	GrantAuthznGrp	I_Grant	GrantAuthznGrp	Grants Management: Authorization Groups
	GrantLfcycStatusForAuthzn	I_Grant	GrantLfcycStatusForAuthzn	GM Lifecycle Status for Auth Grp
	AssetClass	AcItem	AssetClass	Asset Class
	_CurrentCostCenter	AcItem	_CurrentCostCenter
	_AccountingDocumentType	AcItem	_AccountingDocumentType
	_Customer	AcItem	_Customer
	_Supplier	AcItem	_Supplier
	_SalesDocument	AcItem	_SalesDocument
	_ServiceDocument	AcItem	_ServiceDocument
	_Order	AcItem	_Order
	_CurrentProfitCenter	AcItem	_CurrentProfitCenter

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_PubSecGteeMBdgtActlCube.
-- 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: IGMTGTACTCUBE

CREATE VIEW I_PubSecGteeMBdgtActlCube AS
SELECT
  AcItem.SourceLedger AS SourceLedger,
  AcItem.Ledger AS Ledger,
  AcItem.CompanyCode AS CompanyCode,
  AcItem.FiscalYear AS FiscalYear,
  AcItem.AccountingDocument AS AccountingDocument,
  AcItem.FinancialPlanningReqTransSqnc AS FinancialPlanningReqTransSqnc,
  AcItem.FinancialPlanningDataPacket AS FinancialPlanningDataPacket,
  AcItem.ActualPlanJournalEntryItem AS ActualPlanJournalEntryItem,
  _iGrant.GrantID AS GrantID,
  AcItem.ActualPlanCode AS ActualPlanCode,
  AcItem.Fund AS Fund,
  AcItem._Fund._FundType.FundType AS FundType,
  AcItem._Fund._FundType.GranteeMgmtFundType AS GranteeMgmtFundType,
  _iGrant.GranteeMgmtSponsor AS GranteeMgmtSponsor,
  _iGrant.GrantLifecycleStatus AS GrantLifecycleStatus,
  _iGrant.GrantStatus AS GrantStatus,
  _iGrant.GrantType AS GrantType,
  _iGrant._Sponsor._BusinessPartnerIndustry.IndustrySector AS BusPartEmplrIndstryCode,
  _iGrant.ValidityEndDate AS ValidityEndDate,
  _iGrant.ValidityStartDate AS ValidityStartDate,
  AcItem.SponsoredClass AS SponsoredClass,
  AcItem.SponsoredProgram AS SponsoredProgram,
  AcItem.CompanyCodeCurrency AS CompanyCodeCurrency,
  AcItem.AmountInCompanyCodeCurrency AS AmountInCompanyCodeCurrency,
  AcItem.AmountInGlobalCurrency AS AmountInGlobalCurrency,
  AcItem.PostingDate AS PostingDate,
  AcItem.PubSecBudgetCnsmpnDate AS PubSecBudgetCnsmpnDate,
  _iGrant._Sponsor._DefaultAddress._Address.Country AS Country,
  _iGrant._Sponsor._DefaultAddress._Address.CityName AS CityName,
  _iGrant._Sponsor._DefaultAddress._Address.Region AS Region,
  _PubSecBudgetAccount.PubSecBdgtAcctRevnExpnCode AS PubSecBdgtAcctRevnExpnCode,
  AcItem.LedgerGLLineItem AS LedgerGLLineItem,
  AcItem.FinancialPlanningEntryItem AS FinancialPlanningEntryItem,
  AcItem.ControllingArea AS ControllingArea,
  AcItem.GLAccount AS GLAccount,
  AcItem.BusinessArea AS BusinessArea,
  AcItem.ProfitCenter AS ProfitCenter,
  AcItem.FunctionalArea AS FunctionalArea,
  AcItem.CostCenter AS CostCenter,
  AcItem.WBSElementExternalID AS WBSElementExternalID,
  AcItem.Segment AS Segment,
  AcItem.OrderID AS OrderID,
  AcItem.AccountingDocumentType AS AccountingDocumentType,
  AcItem.FinancialAccountType AS FinancialAccountType,
  AcItem.FiscalPeriod AS FiscalPeriod,
  AcItem.PlanningCategory AS PlanningCategory,
  AcItem.ValuationArea AS ValuationArea,
  AcItem.Plant AS Plant,
  AcItem.Customer AS Customer,
  AcItem.Supplier AS Supplier,
  AcItem.SalesDocument AS SalesDocument,
  AcItem.ServiceDocument AS ServiceDocument,
  AcItem.ServiceDocumentType AS ServiceDocumentType,
  AcItem.SalesOrganization AS SalesOrganization,
  AcItem.DistributionChannel AS DistributionChannel,
  AcItem.OrganizationDivision AS OrganizationDivision,
  AcItem.FinancialManagementArea AS FinancialManagementArea,
  AcItem.PubSecBudgetAccount AS PubSecBudgetAccount,
  AcItem.PubSecBudgetAccountCoCode AS PubSecBudgetAccountCoCode,
  AcItem.PubSecBudgetCnsmpnType AS PubSecBudgetCnsmpnType,
  AcItem._PubSecBdgtCnsmpnType.PubSecBudgetCnsmpnTypeGroup AS PubSecBudgetCnsmpnTypeGroup,
  AcItem.PubSecBudgetIsRelevant AS PubSecBudgetIsRelevant,
  AcItem.GlobalCurrency AS GlobalCurrency,
  AcItem.BudgetProcess AS BudgetProcess,
  AcItem.BudgetingType AS BudgetingType,
  _iGrant.GrantIsNotRelevantGrant AS GrantIsNotRelevantGrant,
  AcItem.FiscalYearVariant AS FiscalYearVariant,
  AcItem._FinancialManagementArea AS _FinancialManagementArea,
  AcItem._ProfitCenter AS _ProfitCenter,
  AcItem._FunctionalArea AS _FunctionalArea,
  AcItem._BudgetingType AS _BudgetingType,
  AcItem._Segment AS _Segment,
  AcItem._GLAccountInCompanyCode AS _GLAccountInCompanyCode,
  AcItem._CompanyCode AS _CompanyCode,
  AcItem._CompanyCodeCurrency AS _CompanyCodeCurrency,
  AcItem._GlobalCurrency AS _GlobalCurrency,
  AcItem._FiscalYear AS _FiscalYear,
  AcItem._JournalEntry AS _JournalEntry,
  AcItem._Ledger AS _Ledger,
  AcItem._SourceLedger AS _SourceLedger,
  AcItem._Fund AS _Fund,
  AcItem._CostCenter AS _CostCenter,
  AcItem._WBSElementExternalID AS _WBSElementExternalID,
  AcItem._ControllingArea AS _ControllingArea,
  _iGrant._Sponsor AS _Sponsor,
  _iGrant._Text AS _Text,
  _iGrant._GrantLifecycleStatus AS _GrantLifecycleStatus,
  _iGrant._GrantStatus AS _Status,
  _iGrant._GrantType AS _GrantType,
  AcItem._PubSecBdgtCnsmpnType AS _PubSecBdgtCnsmpnType,
  AcItem._PubSecBdgtCnsmpnType._PubSecBudgetCnsmpnTypeGroup AS _PubSecBudgetCnsmpnTypeGroup,
  _iGrant.GrantAuthznGrp AS GrantAuthznGrp,
  _iGrant.GrantLfcycStatusForAuthzn AS GrantLfcycStatusForAuthzn,
  AcItem.AssetClass AS AssetClass,
  AcItem._CurrentCostCenter AS _CurrentCostCenter,
  AcItem._AccountingDocumentType AS _AccountingDocumentType,
  AcItem._Customer AS _Customer,
  AcItem._Supplier AS _Supplier,
  AcItem._SalesDocument AS _SalesDocument,
  AcItem._ServiceDocument AS _ServiceDocument,
  AcItem._Order AS _Order,
  AcItem._CurrentProfitCenter AS _CurrentProfitCenter
FROM I_Grant AS _iGrant
LEFT OUTER JOIN I_PubSecBudgetAccount AS _PubSecBudgetAccount ON PubSecBudgetAccountCoCode = _PubSecBudgetAccount.PubSecBudgetAccountCoCode AND PubSecBudgetAccount = _PubSecBudgetAccount.PubSecBudgetAccount  -- association [0..1]
LEFT OUTER JOIN I_PubSecBdgtAcctRevnExpnCode AS _PubSecBdgtAcctRevnExpnCode ON PubSecBdgtAcctRevnExpnCode = _PubSecBdgtAcctRevnExpnCode.PubSecBdgtAcctRevnExpnCode  -- association [0..1]
LEFT OUTER JOIN I_BPEmploymentIndustry AS _BPEmploymentIndustry ON BusPartEmplrIndstryCode = _BPEmploymentIndustry.BusPartEmplrIndstryCode  -- association [1..1]
LEFT OUTER JOIN I_Grant AS _GrantMaster ON GrantID = _GrantMaster.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_PubSecGteeMBdgtActlCube view

I_Grant view