What is I_PubSecFinAcctgItemCube in SAP S/4HANA?

I_PubSecFinAcctgItemCube is a composite CDS view in SAP S/4HANA. Budgetary Accounting Items - Cube It contains 253 fields.

Which tables does I_PubSecFinAcctgItemCube read from?

I_PubSecFinAcctgItemCube reads data from: I_GLAccountLineItem.

What VDM layer is I_PubSecFinAcctgItemCube?

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

I_PubSecFinAcctgItemCube

DDL: I_PUBSECFINACCTGITEMCUBE SQL: IPSMS4CFIACANC Type: view COMPOSITE

253 Fields 1 Data Sources 7 Associations

Budgetary Accounting Items - Cube

I_PubSecFinAcctgItemCube (Composite)

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

Cross Applications

I_PubSecFinAcctgItemCube is a Composite CDS View (Cube) that provides data about "Budgetary Accounting Items - Cube" in SAP S/4HANA. It reads from 1 data source (I_GLAccountLineItem) and exposes 253 fields with key fields Ledger, SourceLedger, CompanyCode, FiscalYear, AccountingDocument. It has 7 associations to related views.

SAP API Hub

State	C1
Line of Business	Cross Applications
Application Component	PSM-FM-IS
Capabilities	Data Provider for Analytical Queries
Package	Cross Applications for SAP S/4HANA Cloud Private Edition

Documentation

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

Data Sources (1)

Source	Alias	Join Type
I_GLAccountLineItem	AcItem	from

Associations (7)

Cardinality	Target	Alias	Condition
[0..1]	I_WBSElementByExternalID	_WBSElementExternalID	`$projection.WBSElementExternalID = _WBSElementExternalID.WBSElementExternalID`
[0..1]	I_WBSElementByExternalID	_WBSElementExternalIDText	`$projection.WBSElementExternalID = _WBSElementExternalIDText.WBSElementExternalID`
[0..1]	I_WBSElementByExternalID	_PartnerWBSElementExternalID	`$projection.PartnerWBSElementExternalID = _PartnerWBSElementExternalID.WBSElementExternalID`
[0..1]	I_PubSecBdgtAcctRevnExpnCode	_PubSecBdgtAcctRevnExpnCode	`$projection.PubSecBdgtAcctRevnExpnCode = _PubSecBdgtAcctRevnExpnCode.PubSecBdgtAcctRevnExpnCode`
[0..1]	I_FundType	_FundType	`$projection.FinancialManagementArea = _FundType.FinancialManagementArea and $projection.FundType = _FundType.FundType`
[0..1]	I_BudgetAccountInChtAccts	_BudgetAccountInChtAccts	`$projection.ChartOfAccounts = _BudgetAccountInChtAccts.ChartOfAccounts and $projection.PubSecBudgetAccount = _BudgetAccountInChtAccts.PubSecBudgetAccount`
[0..1]	I_ReferenceDocumentType	_SourceReferenceDocumentType	`$projection.SourceReferenceDocumentType = _SourceReferenceDocumentType.ReferenceDocumentType`

Annotations (18)

Name	Value	Level
AbapCatalog.sqlViewName	IPSMS4CFIACANC	view
ClientHandling.algorithm	#SESSION_VARIABLE	view
AbapCatalog.compiler.compareFilter	true	view
AbapCatalog.preserveKey	true	view
AccessControl.authorizationCheck	#CHECK	view
AccessControl.personalData.blocking	#BLOCKED_DATA_EXCLUDED	view
AbapCatalog.buffering.status	#NOT_ALLOWED	view
EndUserText.label	Budgetary Accounting Items - Cube	view
VDM.viewType	#COMPOSITE	view
Analytics.dataCategory	#CUBE	view
Analytics.dataExtraction.enabled	false	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 (253)

Key	Field	Source Table	Source Field	Description
KEY	Ledger	I_GLAccountLineItem	Ledger	Ledger in General Ledger Accounting
KEY	SourceLedger	I_GLAccountLineItem	SourceLedger	Source Ledger
KEY	CompanyCode	I_GLAccountLineItem	CompanyCode	Receiver Company Code
KEY	FiscalYear	I_GLAccountLineItem	FiscalYear	G/L Fiscal Year
KEY	AccountingDocument	I_GLAccountLineItem	AccountingDocument	Journal Entry
KEY	LedgerGLLineItem	I_GLAccountLineItem	LedgerGLLineItem	General Ledger Journal Entry Line Item
	LedgerFiscalYear	I_GLAccountLineItem	LedgerFiscalYear	Fiscal Year of Ledger
	ChartOfAccounts	I_GLAccountLineItem	ChartOfAccounts	Chart of Accounts
	ControllingArea	I_GLAccountLineItem	ControllingArea	Controlling Area
	FinancialTransactionType	I_GLAccountLineItem	FinancialTransactionType	Financial Transaction Type
	BusinessTransactionType	I_GLAccountLineItem	BusinessTransactionType	Business Transaction Type
	ReferenceDocumentType	I_GLAccountLineItem	ReferenceDocumentType	Reference Document Type
	LogicalSystem	I_GLAccountLineItem	LogicalSystem	Logical System
	ReferenceDocumentContext	I_GLAccountLineItem	ReferenceDocumentContext	Reference Document Context
	ReferenceDocument	I_GLAccountLineItem	ReferenceDocument	Reference Doc. Number
	ReferenceDocumentItem	I_GLAccountLineItem	ReferenceDocumentItem	Reference Document Item
	ReferenceDocumentItemGroup	I_GLAccountLineItem	ReferenceDocumentItemGroup	Reference Document Item Group
	IsReversal	I_GLAccountLineItem	IsReversal	Indicator: Item is Reversing Another Item
	IsReversed	I_GLAccountLineItem	IsReversed	Indicator: Item is Reversed
	ReversalReferenceDocumentCntxt	I_GLAccountLineItem	ReversalReferenceDocumentCntxt	Reversal Reference Document Context
	ReversalReferenceDocument	I_GLAccountLineItem	ReversalReferenceDocument	Reversal Reference Document
	IsSettlement	I_GLAccountLineItem	IsSettlement	Indicator: Item is Settling or Transferring Another Item
	IsSettled	I_GLAccountLineItem	IsSettled	Indicator: Line Item is Settled or Transferred
	SourceReferenceDocumentType	I_GLAccountLineItem	SourceReferenceDocumentType	Source Reference Document Type
	SourceLogicalSystem	I_GLAccountLineItem	SourceLogicalSystem	Source Logical System
	SourceReferenceDocumentCntxt	I_GLAccountLineItem	SourceReferenceDocumentCntxt	Source Reference Document Context
	SourceReferenceDocument	I_GLAccountLineItem	SourceReferenceDocument	Source Reference Document
	SourceReferenceDocumentItem	I_GLAccountLineItem	SourceReferenceDocumentItem	Source Reference Document Item
	SourceReferenceDocSubitem	I_GLAccountLineItem	SourceReferenceDocSubitem	Source Reference Document Subitem
	IsCommitment	I_GLAccountLineItem	IsCommitment	Indicator: Is Commitment
	GLAccount	I_GLAccountLineItem	GLAccount	General Ledger
	CostCenter	I_GLAccountLineItem	CostCenter	Cost Center
	ProfitCenter	I_GLAccountLineItem	ProfitCenter	Profit Center
	FunctionalArea	I_GLAccountLineItem	FunctionalArea	Sendr Fctl Area
	BusinessArea	I_GLAccountLineItem	BusinessArea	Business Area
	Segment	I_GLAccountLineItem	Segment	Segment for Segmental Reporting
	PartnerCostCenter	I_GLAccountLineItem	PartnerCostCenter	Partner Cost Center
	PartnerProfitCenter	I_GLAccountLineItem	PartnerProfitCenter	Partner Profit Center
	PartnerFunctionalArea	I_GLAccountLineItem	PartnerFunctionalArea	Partner Functional Area
	PartnerBusinessArea	I_GLAccountLineItem	PartnerBusinessArea	Partner Business Area
	PartnerCompany	I_GLAccountLineItem	PartnerCompany	Company ID of Trading Partner
	PartnerSegment	I_GLAccountLineItem	PartnerSegment	Partner Segment for Segmental Reporting
	TransactionCurrency	I_GLAccountLineItem	TransactionCurrency	Transaction Currency
	AmountInTransactionCurrency	I_GLAccountLineItem	AmountInTransactionCurrency	Amount in Transaction Currency
	CompanyCodeCurrency	I_GLAccountLineItem	CompanyCodeCurrency	Company Code Currency
	AmountInCompanyCodeCurrency	I_GLAccountLineItem	AmountInCompanyCodeCurrency	Amount in Company Code Currency
	GlobalCurrency	I_GLAccountLineItem	GlobalCurrency	GM Billing Element: Global Currency
	AmountInGlobalCurrency	I_GLAccountLineItem	AmountInGlobalCurrency	Amount in Global Currency
	CostSourceUnit	I_GLAccountLineItem	CostSourceUnit	Cost Source Unit
	DebitCreditCode	I_GLAccountLineItem	DebitCreditCode	Single-Character Flag
	FiscalYearVariant	I_GLAccountLineItem	FiscalYearVariant	Fiscal Year Variant
	PostingDate	I_GLAccountLineItem	PostingDate	Posting Date for GR
	DocumentDate	I_GLAccountLineItem	DocumentDate	Journal Entry Date
	AccountingDocumentType	I_GLAccountLineItem	AccountingDocumentType	Journal Entry Type
	AccountingDocumentItem	I_GLAccountLineItem	AccountingDocumentItem	Journal Entry Posting View Item
	AccountingDocumentCategory	I_GLAccountLineItem	AccountingDocumentCategory	Journal Entry Category
	PostingKey	I_GLAccountLineItem	PostingKey	Posting Key
	LastChangeDateTime	I_GLAccountLineItem	LastChangeDateTime	Last Change Date Time
	CreationDateTime	I_GLAccountLineItem	CreationDateTime	Creation Date Time
	CreationDate	I_GLAccountLineItem	CreationDate	Creation Date
	GLAccountType	I_GLAccountLineItem	GLAccountType	Type of a General Ledger Account
	InvoiceReference	I_GLAccountLineItem	InvoiceReference	Invoice Reference
	InvoiceReferenceFiscalYear	I_GLAccountLineItem	InvoiceReferenceFiscalYear	Invoice Reference Fiscal Year
	InvoiceItemReference	I_GLAccountLineItem	InvoiceItemReference	Invoice Item Reference
	ReferencePurchaseOrderCategory	I_GLAccountLineItem	ReferencePurchaseOrderCategory	Category of Reference Purchase Order
	PurchasingDocument	I_GLAccountLineItem	PurchasingDocument	Purchasing Document
	PurchasingDocumentItem	I_GLAccountLineItem	PurchasingDocumentItem	Purchasing Document Item
	AccountAssignmentNumber	I_GLAccountLineItem	AccountAssignmentNumber	Account Assignment Number
	DocumentItemText	I_GLAccountLineItem	DocumentItemText	Item Text
	SalesDocument	I_GLAccountLineItem	SalesDocument	Sales Document
	Plant	I_GLAccountLineItem	Plant	Valuation Area
	Supplier	I_GLAccountLineItem	Supplier	Supplier
	Customer	I_GLAccountLineItem	Customer	Customer Number
	FinancialAccountType	I_GLAccountLineItem	FinancialAccountType	Fin. Account Type
	SpecialGLCode	I_GLAccountLineItem	SpecialGLCode	Special G/L Indicator
	TaxCode	I_GLAccountLineItem	TaxCode	Tax on Sales/Purchases Code
	ClearingDate	I_GLAccountLineItem	ClearingDate	Clearing Date
	ClearingAccountingDocument	I_GLAccountLineItem	ClearingAccountingDocument	Clearing Journal Entry (Deprecated)
	ClearingDocFiscalYear	I_GLAccountLineItem	ClearingDocFiscalYear	Fiscal Year of Clearing Journal Entry (Deprecated)
	AssetDepreciationArea	I_GLAccountLineItem	AssetDepreciationArea	Asset Depreciation Area (Real or Derived)
	MasterFixedAsset	I_GLAccountLineItem	MasterFixedAsset	Fixed Asset
	FixedAsset	I_GLAccountLineItem	FixedAsset	Asset Subnumber
	AssetValueDate	I_GLAccountLineItem	AssetValueDate	Asset Value Date
	AssetTransactionType	I_GLAccountLineItem	AssetTransactionType	Asset Transaction Type
	DepreciationFiscalPeriod	I_GLAccountLineItem	DepreciationFiscalPeriod	Fiscal Period of Depreciation
	GroupMasterFixedAsset	I_GLAccountLineItem	GroupMasterFixedAsset	Group Asset
	GroupFixedAsset	I_GLAccountLineItem	GroupFixedAsset	Group Asset Subnumber
	AssetClass	I_GLAccountLineItem	AssetClass	Asset Class
	ValuationArea	I_GLAccountLineItem	ValuationArea	Valuation Area
	PartnerCompanyCode	I_GLAccountLineItem	PartnerCompanyCode	Partner Company Code
	OriginCostCenter	I_GLAccountLineItem	OriginCostCenter	Origin Cost Center
	OriginProfitCenter	I_GLAccountLineItem	OriginProfitCenter	Origin Profit Center
	OriginCostCtrActivityType	I_GLAccountLineItem	OriginCostCtrActivityType	Origin Cost Center Activity Type
	OrderID	I_GLAccountLineItem	OrderID	Order ID
	WBSElementInternalID	I_GLAccountLineItem	WBSElementInternalID	WBS Element Internal ID
	PartnerWBSElementInternalID	I_GLAccountLineItem	PartnerWBSElementInternalID	Partner WBS Element Internal ID
	BusinessProcess	I_GLAccountLineItem	BusinessProcess	Business Process
	ServiceDocumentType	I_GLAccountLineItem	ServiceDocumentType	Service Document Type
	ServiceDocument	I_GLAccountLineItem	ServiceDocument	Service Document ID
	PartnerOrder	I_GLAccountLineItem	PartnerOrder	Partner Order (Deprecated)
	PartnerOrderCategory	I_GLAccountLineItem	PartnerOrderCategory	Partner Order Category
	PartnerBusinessProcess	I_GLAccountLineItem	PartnerBusinessProcess	Partner Business Process
	SalesOrganization	I_GLAccountLineItem	SalesOrganization	Sales Organization
	DistributionChannel	I_GLAccountLineItem	DistributionChannel	Distribution Channel
	OrganizationDivision	I_GLAccountLineItem	OrganizationDivision	Org. Division
	FinancialManagementArea	I_GLAccountLineItem	FinancialManagementArea	Financial Management Area
	Fund	I_GLAccountLineItem	Fund	Sender Fund
	GrantID	I_GLAccountLineItem	GrantID	Sender Grant
	BudgetPeriod	I_GLAccountLineItem	BudgetPeriod	Budget Period
	PartnerFund	I_GLAccountLineItem	PartnerFund	Receiver Fund
	PartnerGrant	I_GLAccountLineItem	PartnerGrant	Receiver Grant
	PartnerBudgetPeriod	I_GLAccountLineItem	PartnerBudgetPeriod	FM: Partner Budget Period
	CashLedgerAccount	I_GLAccountLineItem	CashLedgerAccount	Cash Origin Account
	CashLedgerCompanyCode	I_GLAccountLineItem	CashLedgerCompanyCode	Cash Origin Company Code
	PubSecBudgetAccount	I_GLAccountLineItem	PubSecBudgetAccount	Budget Account
	PubSecBudgetAccountCoCode	I_GLAccountLineItem	PubSecBudgetAccountCoCode	Company Code for Budget Account
	PubSecBudgetCnsmpnDate	I_GLAccountLineItem	PubSecBudgetCnsmpnDate	Budget Consumption Date
	PubSecBudgetCnsmpnFsclPeriod	I_GLAccountLineItem	PubSecBudgetCnsmpnFsclPeriod	CC Fiscal Period for Budget Consumption Date
	PubSecBudgetCnsmpnFsclYear	I_GLAccountLineItem	PubSecBudgetCnsmpnFsclYear	CC Fiscal Year for Budget Consumption Date
	PubSecBudgetCnsmpnType	I_GLAccountLineItem	PubSecBudgetCnsmpnType	Budget Consumption Type
	PubSecBudgetCnsmpnAmtType	I_GLAccountLineItem	PubSecBudgetCnsmpnAmtType	Budget Consumption Amount Type
	PubSecBudgetIsRelevant	I_GLAccountLineItem	PubSecBudgetIsRelevant	Budget-Relevant Indicator
	PubSecBdgtAcctRevnExpnCode			Expense or Revenue on Budget Account
	FundType			FM Fund Type
	SponsoredClass	I_GLAccountLineItem	SponsoredClass	Sponsored Class
	SponsoredProgram	I_GLAccountLineItem	SponsoredProgram	Sponsored Program
	GteeMBudgetValidityNumber	I_GLAccountLineItem	GteeMBudgetValidityNumber	Budget Validity Number
	IsStatisticalOrder	I_GLAccountLineItem	IsStatisticalOrder	Indicator: Internal Order is Statistical Account Assignment
	IsStatisticalCostCenter	I_GLAccountLineItem	IsStatisticalCostCenter	Indicator: Cost Center is Statistical Account Assignment
	IsStatisticalSalesDocument	I_GLAccountLineItem	IsStatisticalSalesDocument	Sales Document is statistical
	WBSIsStatisticalWBSElement	I_GLAccountLineItem	WBSIsStatisticalWBSElement	Indicator: WBS Element is Statistical Account Assignment
	_CashLedgerAccount	I_GLAccountLineItem	_CashLedgerAccount
	_CashLedgerCompanyCode	I_GLAccountLineItem	_CashLedgerCompanyCode
	_BudgetAccountInChtAccts		_BudgetAccountInChtAccts
	_PubSecBudgetAccount	I_GLAccountLineItem	_PubSecBudgetAccount
	_PubSecBdgtAcctRevnExpnCode		_PubSecBdgtAcctRevnExpnCode
	_PubSecBudgetAccountCoCode	I_GLAccountLineItem	_PubSecBudgetAccountCoCode
	_PubSecBudgetCnsmpnFsclYear	I_GLAccountLineItem	_PubSecBudgetCnsmpnFsclYear
	_PubSecBudgetCnsmpnFsclPeriod	I_GLAccountLineItem	_PubSecBudgetCnsmpnFsclPeriod
	_PubSecBudgetCnsmpnType	I_GLAccountLineItem	_PubSecBudgetCnsmpnType
	_PubSecBudgetCnsmpnAmtType	I_GLAccountLineItem	_PubSecBudgetCnsmpnAmtType
	_PubSecBudgetCnsmpnDate	I_GLAccountLineItem	_PubSecBudgetCnsmpnDate
	_AccountingDocumentCategory	I_GLAccountLineItem	_AccountingDocumentCategory
	_AccountingDocumentType	I_GLAccountLineItem	_AccountingDocumentType
	_AccountingDocumentTypeText	I_GLAccountLineItem	_AccountingDocumentTypeText
	_AssetTransactionType	I_GLAccountLineItem	_AssetTransactionType
	_BudgetPeriod	I_GLAccountLineItem	_BudgetPeriod
	_BudgetPeriodText	I_GLAccountLineItem	_BudgetPeriodText
	_BusinessArea	I_GLAccountLineItem	_BusinessArea
	_BusinessAreaText	I_GLAccountLineItem	_BusinessAreaText
	_BusinessProcess	I_GLAccountLineItem	_BusinessProcess
	_BusinessProcessText	I_GLAccountLineItem	_BusinessProcessText
	_BusinessTransactionType	I_GLAccountLineItem	_BusinessTransactionType
	_BusinessTransactionTypeText	I_GLAccountLineItem	_BusinessTransactionTypeText
	_ChartOfAccounts	I_GLAccountLineItem	_ChartOfAccounts
	_ChartOfAccountsText	I_GLAccountLineItem	_ChartOfAccountsText
	_ClearingAccountingDocument	I_GLAccountLineItem	_ClearingAccountingDocument
	_CompanyCode	I_GLAccountLineItem	_CompanyCode
	_CompanyCodeCurrency	I_GLAccountLineItem	_CompanyCodeCurrency
	_CompanyCodeText	I_GLAccountLineItem	_CompanyCodeText
	_ControllingArea	I_GLAccountLineItem	_ControllingArea
	_ControllingAreaText	I_GLAccountLineItem	_ControllingAreaText
	_CostCenter	I_GLAccountLineItem	_CostCenter
	_CostCenterText	I_GLAccountLineItem	_CostCenterText
	_CostSourceUnit	I_GLAccountLineItem	_CostSourceUnit
	_CurrentCostCenter	I_GLAccountLineItem	_CurrentCostCenter
	_CurrentProfitCenter	I_GLAccountLineItem	_CurrentProfitCenter
	_Customer	I_GLAccountLineItem	_Customer
	_CustomerText	I_GLAccountLineItem	_CustomerText
	_DebitCreditCode	I_GLAccountLineItem	_DebitCreditCode
	_DebitCreditCodeText	I_GLAccountLineItem	_DebitCreditCodeText
	_DistributionChannel	I_GLAccountLineItem	_DistributionChannel
	_FinancialAccountType	I_GLAccountLineItem	_FinancialAccountType
	_FinancialAccountTypeText	I_GLAccountLineItem	_FinancialAccountTypeText
	_FinancialManagementArea	I_GLAccountLineItem	_FinancialManagementArea
	_FinancialManagementAreaText	I_GLAccountLineItem	_FinancialManagementAreaText
	_FinancialTransactionType	I_GLAccountLineItem	_FinancialTransactionType
	_FiscalYear	I_GLAccountLineItem	_FiscalYear
	_FiscalYearVariant	I_GLAccountLineItem	_FiscalYearVariant
	_FixedAsset	I_GLAccountLineItem	_FixedAsset
	_FixedAssetText	I_GLAccountLineItem	_FixedAssetText
	_FunctionalArea	I_GLAccountLineItem	_FunctionalArea
	_FunctionalAreaText	I_GLAccountLineItem	_FunctionalAreaText
	_Fund	I_GLAccountLineItem	_Fund
	_FundType		_FundType
	_FundText	I_GLAccountLineItem	_FundText
	_Grant		_Grant
	_PartnerGrant		_PartnerGrant
	_GLAccountInChartOfAccounts	I_GLAccountLineItem	_GLAccountInChartOfAccounts
	_GLAccountInCompanyCode	I_GLAccountLineItem	_GLAccountInCompanyCode
	_GLAccountTxt	I_GLAccountLineItem	_GLAccountTxt
	_GLAccountType	I_GLAccountLineItem	_GLAccountType
	_GLAcctInChartOfAccountsText	I_GLAccountLineItem	_GLAcctInChartOfAccountsText
	_GlobalCurrency	I_GLAccountLineItem	_GlobalCurrency
	_GroupFixedAsset	I_GLAccountLineItem	_GroupFixedAsset
	_GroupFixedAssetText	I_GLAccountLineItem	_GroupFixedAssetText
	_GroupMasterFixedAsset	I_GLAccountLineItem	_GroupMasterFixedAsset
	_GroupMasterFixedAssetText	I_GLAccountLineItem	_GroupMasterFixedAssetText
	_JournalEntry	I_GLAccountLineItem	_JournalEntry
	_Ledger	I_GLAccountLineItem	_Ledger
	_LedgerFiscalYearForVariant	I_GLAccountLineItem	_LedgerFiscalYearForVariant
	_LedgerText	I_GLAccountLineItem	_LedgerText
	_MasterFixedAsset	I_GLAccountLineItem	_MasterFixedAsset
	_MasterFixedAssetText	I_GLAccountLineItem	_MasterFixedAssetText
	_Order	I_GLAccountLineItem	_Order
	_OriginCostCenter	I_GLAccountLineItem	_OriginCostCenter
	_OriginCostCtrActivityType	I_GLAccountLineItem	_OriginCostCtrActivityType
	_OriginProfitCenter	I_GLAccountLineItem	_OriginProfitCenter
	_PartnerBudgetPeriod	I_GLAccountLineItem	_PartnerBudgetPeriod
	_PartnerBusinessArea	I_GLAccountLineItem	_PartnerBusinessArea
	_PartnerBusinessAreaText	I_GLAccountLineItem	_PartnerBusinessAreaText
	_PartnerBusinessProcess	I_GLAccountLineItem	_PartnerBusinessProcess
	_PartnerBusinessProcessText	I_GLAccountLineItem	_PartnerBusinessProcessText
	_PartnerCompany	I_GLAccountLineItem	_PartnerCompany
	_PartnerCompanyCode	I_GLAccountLineItem	_PartnerCompanyCode
	_PartnerCompanyCodeText	I_GLAccountLineItem	_PartnerCompanyCodeText
	_PartnerCostCenter	I_GLAccountLineItem	_PartnerCostCenter
	_PartnerFunctionalArea	I_GLAccountLineItem	_PartnerFunctionalArea
	_PartnerFund	I_GLAccountLineItem	_PartnerFund
	_PartnerFundText	I_GLAccountLineItem	_PartnerFundText
	_PartnerOrder	I_GLAccountLineItem	_PartnerOrder
	_PartnerOrderCategory	I_GLAccountLineItem	_PartnerOrderCategory
	_PartnerOrderText	I_GLAccountLineItem	_PartnerOrderText
	_PartnerProfitCenter	I_GLAccountLineItem	_PartnerProfitCenter
	_PartnerWBSElementExternalID		_PartnerWBSElementExternalID
	_PartnerSegment	I_GLAccountLineItem	_PartnerSegment
	_PartnerSegmentText	I_GLAccountLineItem	_PartnerSegmentText
	_Plant	I_GLAccountLineItem	_Plant
	_PostingKey	I_GLAccountLineItem	_PostingKey
	_ProfitCenter	I_GLAccountLineItem	_ProfitCenter
	_ProfitCenterText	I_GLAccountLineItem	_ProfitCenterText
	_PurchasingDocument	I_GLAccountLineItem	_PurchasingDocument
	_PurchasingDocumentItem	I_GLAccountLineItem	_PurchasingDocumentItem
	_ReferenceDocumentType	I_GLAccountLineItem	_ReferenceDocumentType
	_SalesDocument	I_GLAccountLineItem	_SalesDocument
	_SalesOrganization	I_GLAccountLineItem	_SalesOrganization
	_Segment	I_GLAccountLineItem	_Segment
	_SegmentText	I_GLAccountLineItem	_SegmentText
	_ServiceDocument	I_GLAccountLineItem	_ServiceDocument
	_ServiceDocumentType	I_GLAccountLineItem	_ServiceDocumentType
	_SourceLedger	I_GLAccountLineItem	_SourceLedger
	_SourceLedgerText	I_GLAccountLineItem	_SourceLedgerText
	_SourceReferenceDocumentType		_SourceReferenceDocumentType
	_SpecialGLCode	I_GLAccountLineItem	_SpecialGLCode
	_Supplier	I_GLAccountLineItem	_Supplier
	_SupplierText	I_GLAccountLineItem	_SupplierText
	_TaxCode	I_GLAccountLineItem	_TaxCode
	_TransactionCurrency	I_GLAccountLineItem	_TransactionCurrency
	_WBSElementBasicData	I_GLAccountLineItem	_WBSElementBasicData
	_WBSElementBasicDataText	I_GLAccountLineItem	_WBSElementBasicDataText
	_WBSElementExternalID		_WBSElementExternalID
	_WBSElementExternalIDText		_WBSElementExternalIDText
	_PartnerWBSElementBasicData	I_GLAccountLineItem	_PartnerWBSElementBasicData

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_PubSecFinAcctgItemCube.
-- 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: IPSMS4CFIACANC

CREATE VIEW I_PubSecFinAcctgItemCube AS
SELECT
  AcItem.Ledger AS Ledger,
  AcItem.SourceLedger AS SourceLedger,
  AcItem.CompanyCode AS CompanyCode,
  AcItem.FiscalYear AS FiscalYear,
  AcItem.AccountingDocument AS AccountingDocument,
  AcItem.LedgerGLLineItem AS LedgerGLLineItem,
  AcItem.LedgerFiscalYear AS LedgerFiscalYear,
  AcItem.ChartOfAccounts AS ChartOfAccounts,
  AcItem.ControllingArea AS ControllingArea,
  AcItem.FinancialTransactionType AS FinancialTransactionType,
  AcItem.BusinessTransactionType AS BusinessTransactionType,
  AcItem.ReferenceDocumentType AS ReferenceDocumentType,
  AcItem.LogicalSystem AS LogicalSystem,
  AcItem.ReferenceDocumentContext AS ReferenceDocumentContext,
  AcItem.ReferenceDocument AS ReferenceDocument,
  AcItem.ReferenceDocumentItem AS ReferenceDocumentItem,
  AcItem.ReferenceDocumentItemGroup AS ReferenceDocumentItemGroup,
  AcItem.IsReversal AS IsReversal,
  AcItem.IsReversed AS IsReversed,
  AcItem.ReversalReferenceDocumentCntxt AS ReversalReferenceDocumentCntxt,
  AcItem.ReversalReferenceDocument AS ReversalReferenceDocument,
  AcItem.IsSettlement AS IsSettlement,
  AcItem.IsSettled AS IsSettled,
  AcItem.SourceReferenceDocumentType AS SourceReferenceDocumentType,
  AcItem.SourceLogicalSystem AS SourceLogicalSystem,
  AcItem.SourceReferenceDocumentCntxt AS SourceReferenceDocumentCntxt,
  AcItem.SourceReferenceDocument AS SourceReferenceDocument,
  AcItem.SourceReferenceDocumentItem AS SourceReferenceDocumentItem,
  AcItem.SourceReferenceDocSubitem AS SourceReferenceDocSubitem,
  AcItem.IsCommitment AS IsCommitment,
  AcItem.GLAccount AS GLAccount,
  AcItem.CostCenter AS CostCenter,
  AcItem.ProfitCenter AS ProfitCenter,
  AcItem.FunctionalArea AS FunctionalArea,
  AcItem.BusinessArea AS BusinessArea,
  AcItem.Segment AS Segment,
  AcItem.PartnerCostCenter AS PartnerCostCenter,
  AcItem.PartnerProfitCenter AS PartnerProfitCenter,
  AcItem.PartnerFunctionalArea AS PartnerFunctionalArea,
  AcItem.PartnerBusinessArea AS PartnerBusinessArea,
  AcItem.PartnerCompany AS PartnerCompany,
  AcItem.PartnerSegment AS PartnerSegment,
  AcItem.TransactionCurrency AS TransactionCurrency,
  AcItem.AmountInTransactionCurrency AS AmountInTransactionCurrency,
  AcItem.CompanyCodeCurrency AS CompanyCodeCurrency,
  AcItem.AmountInCompanyCodeCurrency AS AmountInCompanyCodeCurrency,
  AcItem.GlobalCurrency AS GlobalCurrency,
  AcItem.AmountInGlobalCurrency AS AmountInGlobalCurrency,
  AcItem.CostSourceUnit AS CostSourceUnit,
  AcItem.DebitCreditCode AS DebitCreditCode,
  AcItem.FiscalYearVariant AS FiscalYearVariant,
  AcItem.PostingDate AS PostingDate,
  AcItem.DocumentDate AS DocumentDate,
  AcItem.AccountingDocumentType AS AccountingDocumentType,
  AcItem.AccountingDocumentItem AS AccountingDocumentItem,
  AcItem.AccountingDocumentCategory AS AccountingDocumentCategory,
  AcItem.PostingKey AS PostingKey,
  AcItem.LastChangeDateTime AS LastChangeDateTime,
  AcItem.CreationDateTime AS CreationDateTime,
  AcItem.CreationDate AS CreationDate,
  AcItem.GLAccountType AS GLAccountType,
  AcItem.InvoiceReference AS InvoiceReference,
  AcItem.InvoiceReferenceFiscalYear AS InvoiceReferenceFiscalYear,
  AcItem.InvoiceItemReference AS InvoiceItemReference,
  AcItem.ReferencePurchaseOrderCategory AS ReferencePurchaseOrderCategory,
  AcItem.PurchasingDocument AS PurchasingDocument,
  AcItem.PurchasingDocumentItem AS PurchasingDocumentItem,
  AcItem.AccountAssignmentNumber AS AccountAssignmentNumber,
  AcItem.DocumentItemText AS DocumentItemText,
  AcItem.SalesDocument AS SalesDocument,
  AcItem.Plant AS Plant,
  AcItem.Supplier AS Supplier,
  AcItem.Customer AS Customer,
  AcItem.FinancialAccountType AS FinancialAccountType,
  AcItem.SpecialGLCode AS SpecialGLCode,
  AcItem.TaxCode AS TaxCode,
  AcItem.ClearingDate AS ClearingDate,
  AcItem.ClearingAccountingDocument AS ClearingAccountingDocument,
  AcItem.ClearingDocFiscalYear AS ClearingDocFiscalYear,
  AcItem.AssetDepreciationArea AS AssetDepreciationArea,
  AcItem.MasterFixedAsset AS MasterFixedAsset,
  AcItem.FixedAsset AS FixedAsset,
  AcItem.AssetValueDate AS AssetValueDate,
  AcItem.AssetTransactionType AS AssetTransactionType,
  AcItem.DepreciationFiscalPeriod AS DepreciationFiscalPeriod,
  AcItem.GroupMasterFixedAsset AS GroupMasterFixedAsset,
  AcItem.GroupFixedAsset AS GroupFixedAsset,
  AcItem.AssetClass AS AssetClass,
  AcItem.ValuationArea AS ValuationArea,
  AcItem.PartnerCompanyCode AS PartnerCompanyCode,
  AcItem.OriginCostCenter AS OriginCostCenter,
  AcItem.OriginProfitCenter AS OriginProfitCenter,
  AcItem.OriginCostCtrActivityType AS OriginCostCtrActivityType,
  AcItem.OrderID AS OrderID,
  AcItem.WBSElementInternalID AS WBSElementInternalID,
  AcItem.PartnerWBSElementInternalID AS PartnerWBSElementInternalID,
  AcItem.BusinessProcess AS BusinessProcess,
  AcItem.ServiceDocumentType AS ServiceDocumentType,
  AcItem.ServiceDocument AS ServiceDocument,
  AcItem.PartnerOrder AS PartnerOrder,
  AcItem.PartnerOrderCategory AS PartnerOrderCategory,
  AcItem.PartnerBusinessProcess AS PartnerBusinessProcess,
  AcItem.SalesOrganization AS SalesOrganization,
  AcItem.DistributionChannel AS DistributionChannel,
  AcItem.OrganizationDivision AS OrganizationDivision,
  AcItem.FinancialManagementArea AS FinancialManagementArea,
  AcItem.Fund AS Fund,
  AcItem.GrantID AS GrantID,
  AcItem.BudgetPeriod AS BudgetPeriod,
  AcItem.PartnerFund AS PartnerFund,
  AcItem.PartnerGrant AS PartnerGrant,
  AcItem.PartnerBudgetPeriod AS PartnerBudgetPeriod,
  AcItem.CashLedgerAccount AS CashLedgerAccount,
  AcItem.CashLedgerCompanyCode AS CashLedgerCompanyCode,
  AcItem.PubSecBudgetAccount AS PubSecBudgetAccount,
  AcItem.PubSecBudgetAccountCoCode AS PubSecBudgetAccountCoCode,
  AcItem.PubSecBudgetCnsmpnDate AS PubSecBudgetCnsmpnDate,
  AcItem.PubSecBudgetCnsmpnFsclPeriod AS PubSecBudgetCnsmpnFsclPeriod,
  AcItem.PubSecBudgetCnsmpnFsclYear AS PubSecBudgetCnsmpnFsclYear,
  AcItem.PubSecBudgetCnsmpnType AS PubSecBudgetCnsmpnType,
  AcItem.PubSecBudgetCnsmpnAmtType AS PubSecBudgetCnsmpnAmtType,
  AcItem.PubSecBudgetIsRelevant AS PubSecBudgetIsRelevant,
  AcItem._PubSecBudgetAccount.PubSecBdgtAcctRevnExpnCode AS PubSecBdgtAcctRevnExpnCode,
  AcItem._Fund.FundType AS FundType,
  AcItem.SponsoredClass AS SponsoredClass,
  AcItem.SponsoredProgram AS SponsoredProgram,
  AcItem.GteeMBudgetValidityNumber AS GteeMBudgetValidityNumber,
  AcItem.IsStatisticalOrder AS IsStatisticalOrder,
  AcItem.IsStatisticalCostCenter AS IsStatisticalCostCenter,
  AcItem.IsStatisticalSalesDocument AS IsStatisticalSalesDocument,
  AcItem.WBSIsStatisticalWBSElement AS WBSIsStatisticalWBSElement,
  AcItem._CashLedgerAccount AS _CashLedgerAccount,
  AcItem._CashLedgerCompanyCode AS _CashLedgerCompanyCode,
  AcItem._PubSecBudgetAccount AS _PubSecBudgetAccount,
  AcItem._PubSecBudgetAccountCoCode AS _PubSecBudgetAccountCoCode,
  AcItem._PubSecBudgetCnsmpnFsclYear AS _PubSecBudgetCnsmpnFsclYear,
  AcItem._PubSecBudgetCnsmpnFsclPeriod AS _PubSecBudgetCnsmpnFsclPeriod,
  AcItem._PubSecBudgetCnsmpnType AS _PubSecBudgetCnsmpnType,
  AcItem._PubSecBudgetCnsmpnAmtType AS _PubSecBudgetCnsmpnAmtType,
  AcItem._PubSecBudgetCnsmpnDate AS _PubSecBudgetCnsmpnDate,
  AcItem._AccountingDocumentCategory AS _AccountingDocumentCategory,
  AcItem._AccountingDocumentType AS _AccountingDocumentType,
  AcItem._AccountingDocumentTypeText AS _AccountingDocumentTypeText,
  AcItem._AssetTransactionType AS _AssetTransactionType,
  AcItem._BudgetPeriod AS _BudgetPeriod,
  AcItem._BudgetPeriodText AS _BudgetPeriodText,
  AcItem._BusinessArea AS _BusinessArea,
  AcItem._BusinessAreaText AS _BusinessAreaText,
  AcItem._BusinessProcess AS _BusinessProcess,
  AcItem._BusinessProcessText AS _BusinessProcessText,
  AcItem._BusinessTransactionType AS _BusinessTransactionType,
  AcItem._BusinessTransactionTypeText AS _BusinessTransactionTypeText,
  AcItem._ChartOfAccounts AS _ChartOfAccounts,
  AcItem._ChartOfAccountsText AS _ChartOfAccountsText,
  AcItem._ClearingAccountingDocument AS _ClearingAccountingDocument,
  AcItem._CompanyCode AS _CompanyCode,
  AcItem._CompanyCodeCurrency AS _CompanyCodeCurrency,
  AcItem._CompanyCodeText AS _CompanyCodeText,
  AcItem._ControllingArea AS _ControllingArea,
  AcItem._ControllingAreaText AS _ControllingAreaText,
  AcItem._CostCenter AS _CostCenter,
  AcItem._CostCenterText AS _CostCenterText,
  AcItem._CostSourceUnit AS _CostSourceUnit,
  AcItem._CurrentCostCenter AS _CurrentCostCenter,
  AcItem._CurrentProfitCenter AS _CurrentProfitCenter,
  AcItem._Customer AS _Customer,
  AcItem._CustomerText AS _CustomerText,
  AcItem._DebitCreditCode AS _DebitCreditCode,
  AcItem._DebitCreditCodeText AS _DebitCreditCodeText,
  AcItem._DistributionChannel AS _DistributionChannel,
  AcItem._FinancialAccountType AS _FinancialAccountType,
  AcItem._FinancialAccountTypeText AS _FinancialAccountTypeText,
  AcItem._FinancialManagementArea AS _FinancialManagementArea,
  AcItem._FinancialManagementAreaText AS _FinancialManagementAreaText,
  AcItem._FinancialTransactionType AS _FinancialTransactionType,
  AcItem._FiscalYear AS _FiscalYear,
  AcItem._FiscalYearVariant AS _FiscalYearVariant,
  AcItem._FixedAsset AS _FixedAsset,
  AcItem._FixedAssetText AS _FixedAssetText,
  AcItem._FunctionalArea AS _FunctionalArea,
  AcItem._FunctionalAreaText AS _FunctionalAreaText,
  AcItem._Fund AS _Fund,
  AcItem._FundText AS _FundText,
  AcItem._GLAccountInChartOfAccounts AS _GLAccountInChartOfAccounts,
  AcItem._GLAccountInCompanyCode AS _GLAccountInCompanyCode,
  AcItem._GLAccountTxt AS _GLAccountTxt,
  AcItem._GLAccountType AS _GLAccountType,
  AcItem._GLAcctInChartOfAccountsText AS _GLAcctInChartOfAccountsText,
  AcItem._GlobalCurrency AS _GlobalCurrency,
  AcItem._GroupFixedAsset AS _GroupFixedAsset,
  AcItem._GroupFixedAssetText AS _GroupFixedAssetText,
  AcItem._GroupMasterFixedAsset AS _GroupMasterFixedAsset,
  AcItem._GroupMasterFixedAssetText AS _GroupMasterFixedAssetText,
  AcItem._JournalEntry AS _JournalEntry,
  AcItem._Ledger AS _Ledger,
  AcItem._LedgerFiscalYearForVariant AS _LedgerFiscalYearForVariant,
  AcItem._LedgerText AS _LedgerText,
  AcItem._MasterFixedAsset AS _MasterFixedAsset,
  AcItem._MasterFixedAssetText AS _MasterFixedAssetText,
  AcItem._Order AS _Order,
  AcItem._OriginCostCenter AS _OriginCostCenter,
  AcItem._OriginCostCtrActivityType AS _OriginCostCtrActivityType,
  AcItem._OriginProfitCenter AS _OriginProfitCenter,
  AcItem._PartnerBudgetPeriod AS _PartnerBudgetPeriod,
  AcItem._PartnerBusinessArea AS _PartnerBusinessArea,
  AcItem._PartnerBusinessAreaText AS _PartnerBusinessAreaText,
  AcItem._PartnerBusinessProcess AS _PartnerBusinessProcess,
  AcItem._PartnerBusinessProcessText AS _PartnerBusinessProcessText,
  AcItem._PartnerCompany AS _PartnerCompany,
  AcItem._PartnerCompanyCode AS _PartnerCompanyCode,
  AcItem._PartnerCompanyCodeText AS _PartnerCompanyCodeText,
  AcItem._PartnerCostCenter AS _PartnerCostCenter,
  AcItem._PartnerFunctionalArea AS _PartnerFunctionalArea,
  AcItem._PartnerFund AS _PartnerFund,
  AcItem._PartnerFundText AS _PartnerFundText,
  AcItem._PartnerOrder AS _PartnerOrder,
  AcItem._PartnerOrderCategory AS _PartnerOrderCategory,
  AcItem._PartnerOrderText AS _PartnerOrderText,
  AcItem._PartnerProfitCenter AS _PartnerProfitCenter,
  AcItem._PartnerSegment AS _PartnerSegment,
  AcItem._PartnerSegmentText AS _PartnerSegmentText,
  AcItem._Plant AS _Plant,
  AcItem._PostingKey AS _PostingKey,
  AcItem._ProfitCenter AS _ProfitCenter,
  AcItem._ProfitCenterText AS _ProfitCenterText,
  AcItem._PurchasingDocument AS _PurchasingDocument,
  AcItem._PurchasingDocumentItem AS _PurchasingDocumentItem,
  AcItem._ReferenceDocumentType AS _ReferenceDocumentType,
  AcItem._SalesDocument AS _SalesDocument,
  AcItem._SalesOrganization AS _SalesOrganization,
  AcItem._Segment AS _Segment,
  AcItem._SegmentText AS _SegmentText,
  AcItem._ServiceDocument AS _ServiceDocument,
  AcItem._ServiceDocumentType AS _ServiceDocumentType,
  AcItem._SourceLedger AS _SourceLedger,
  AcItem._SourceLedgerText AS _SourceLedgerText,
  AcItem._SpecialGLCode AS _SpecialGLCode,
  AcItem._Supplier AS _Supplier,
  AcItem._SupplierText AS _SupplierText,
  AcItem._TaxCode AS _TaxCode,
  AcItem._TransactionCurrency AS _TransactionCurrency,
  AcItem._WBSElementBasicData AS _WBSElementBasicData,
  AcItem._WBSElementBasicDataText AS _WBSElementBasicDataText,
  AcItem._PartnerWBSElementBasicData AS _PartnerWBSElementBasicData
FROM I_GLAccountLineItem AS AcItem
LEFT OUTER JOIN I_WBSElementByExternalID AS _WBSElementExternalID ON WBSElementExternalID = _WBSElementExternalID.WBSElementExternalID  -- association [0..1]
LEFT OUTER JOIN I_WBSElementByExternalID AS _WBSElementExternalIDText ON WBSElementExternalID = _WBSElementExternalIDText.WBSElementExternalID  -- association [0..1]
LEFT OUTER JOIN I_WBSElementByExternalID AS _PartnerWBSElementExternalID ON PartnerWBSElementExternalID = _PartnerWBSElementExternalID.WBSElementExternalID  -- association [0..1]
LEFT OUTER JOIN I_PubSecBdgtAcctRevnExpnCode AS _PubSecBdgtAcctRevnExpnCode ON PubSecBdgtAcctRevnExpnCode = _PubSecBdgtAcctRevnExpnCode.PubSecBdgtAcctRevnExpnCode  -- association [0..1]
LEFT OUTER JOIN I_FundType AS _FundType ON FinancialManagementArea = _FundType.FinancialManagementArea AND FundType = _FundType.FundType  -- association [0..1]
LEFT OUTER JOIN I_BudgetAccountInChtAccts AS _BudgetAccountInChtAccts ON ChartOfAccounts = _BudgetAccountInChtAccts.ChartOfAccounts AND PubSecBudgetAccount = _BudgetAccountInChtAccts.PubSecBudgetAccount  -- association [0..1]
LEFT OUTER JOIN I_ReferenceDocumentType AS _SourceReferenceDocumentType ON SourceReferenceDocumentType = _SourceReferenceDocumentType.ReferenceDocumentType  -- association [0..1]
;

Depth:

I_PubSecFinAcctgItemCube view

I_GLAccountLineItem view_entity