What is I_GLAccountBalance in SAP S/4HANA?

I_GLAccountBalance is a composite CDS view in SAP S/4HANA. G/L Account Balance with Flow-Measure It contains 306 fields.

Which tables does I_GLAccountBalance read from?

I_GLAccountBalance reads data from: P_GLAccountBalance.

What VDM layer is I_GLAccountBalance?

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

I_GLAccountBalance

DDL: I_GLACCOUNTBALANCE SQL: IFIGLACCTBAL Type: view COMPOSITE

306 Fields 1 Data Sources 3 Associations

G/L Account Balance with Flow-Measure

I_GLAccountBalance is a Composite CDS View (Cube) that provides data about "G/L Account Balance with Flow-Measure" in SAP S/4HANA. It reads from 1 data source (P_GLAccountBalance) and exposes 306 fields with key fields SourceLedger, CompanyCode, FiscalYear, AccountingDocument, LedgerGLLineItem. It has 3 associations to related views.

Data Sources (1)

Source	Alias	Join Type
P_GLAccountBalance	P_GLAccountBalance	from

Associations (3)

Cardinality	Target	Alias	Condition
[0..1]	I_Grant	_Grant	`$projection.GrantID = _Grant.GrantID`
[0..1]	I_Grant	_PartnerGrant	`$projection.PartnerGrant = _PartnerGrant.GrantID`
[1..1]	E_JournalEntryItem	_Extension	`$projection.SourceLedger = _Extension.SourceLedger and $projection.CompanyCode = _Extension.CompanyCode and $projection.FiscalYear = _Extension.FiscalYear and $projection.AccountingDocument = _Extension.AccountingDocument and $projection.LedgerGLLineItem = _Extension.LedgerGLLineItem`

Annotations (18)

Name	Value	Level
VDM.lifecycle.contract.type	#PUBLIC_LOCAL_API	view
AbapCatalog.preserveKey	true	view
AbapCatalog.compiler.compareFilter	true	view
AbapCatalog.sqlViewName	IFIGLACCTBAL	view
EndUserText.label	G/L Account Balance with Flow-Measure	view
AccessControl.personalData.blocking	#REQUIRED	view
Analytics.dataCategory	#CUBE	view
VDM.viewType	#COMPOSITE	view
AccessControl.authorizationCheck	#CHECK	view
ObjectModel.representativeKey	LedgerGLLineItem	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.ignorePropagatedAnnotations	true	view
Analytics.readClassName	CL_FIS_GL_ACCOUNT_BALANCE_CDS	view
Metadata.allowExtensions	true	view

Fields (306)

Key	Field	Source Table	Source Field	Description
KEY	SourceLedger		SourceLedger	Source Ledger
KEY	CompanyCode		CompanyCode	Receiver Company Code
KEY	FiscalYear		FiscalYear	G/L Fiscal Year
KEY	AccountingDocument		AccountingDocument	Journal Entry
KEY	LedgerGLLineItem		LedgerGLLineItem	Journal Entry Item
KEY	Ledger		Ledger	Ledger
	LedgerFiscalYear		LedgerFiscalYear
	GLRecordType		GLRecordType	Record Type
	ChartOfAccounts		ChartOfAccounts	Node Class
	ControllingArea		ControllingArea	Controlling Area
	FinancialTransactionType		FinancialTransactionType	Transact. Type
	BusinessTransactionType		BusinessTransactionType	Bus.transaction
	ReferenceDocumentType		ReferenceDocumentType	Reference Document Type
	LogicalSystem		LogicalSystem	Logical System
	ReferenceDocumentContext		ReferenceDocumentContext	Reference Document Context
	ReferenceDocument		ReferenceDocument	Reference Document
	ReferenceDocumentItem		ReferenceDocumentItem	Reference item
	ReferenceDocumentItemGroup		ReferenceDocumentItemGroup	Reference Document Item Group
	IsReversal		IsReversal	Reversal doc.
	IsReversed		IsReversed	Reversed?
	ReversalReferenceDocumentCntxt		ReversalReferenceDocumentCntxt	Reversal Reference Document Context
	ReversalReferenceDocument		ReversalReferenceDocument	Reversal Reference Document
	IsSettlement		IsSettlement	Is Settling
	IsSettled		IsSettled	Is Settled
	PredecessorReferenceDocType		PredecessorReferenceDocType	Predecessor Reference Document Type
	PredecessorReferenceDocCntxt		PredecessorReferenceDocCntxt	Predecessor Reference Document Context
	PredecessorReferenceDocument		PredecessorReferenceDocument	Predecessor Reference Document
	PredecessorReferenceDocItem		PredecessorReferenceDocItem	Prec. Ref. Doc. Item
	SourceReferenceDocumentType		SourceReferenceDocumentType	Ref. procedure
	SourceLogicalSystem		SourceLogicalSystem
	SourceReferenceDocumentCntxt		SourceReferenceDocumentCntxt
	SourceReferenceDocument		SourceReferenceDocument	Reference Doc.
	SourceReferenceDocumentItem		SourceReferenceDocumentItem	Ref. Doc. Item
	SourceReferenceDocSubitem		SourceReferenceDocSubitem
	IsCommitment		IsCommitment
	JrnlEntryItemObsoleteReason		JrnlEntryItemObsoleteReason
	GLAccount		GLAccount	General Ledger
	CostCenter		CostCenter	Cost Center
	ProfitCenter		ProfitCenter	Profit Center
	FunctionalArea		FunctionalArea	Sendr Fctl Area
	BusinessArea		BusinessArea	Business Area
	Segment		Segment	Segment number
	PartnerCostCenter		PartnerCostCenter	Sender Cost Ctr
	PartnerProfitCenter		PartnerProfitCenter	Profit Center
	PartnerFunctionalArea		PartnerFunctionalArea	Rec. Fntcl Area
	PartnerBusinessArea		PartnerBusinessArea	Trdg Part.BA
	PartnerCompany		PartnerCompany	Trading Partner
	PartnerSegment		PartnerSegment	Partner Segment
	BalanceTransactionCurrency		BalanceTransactionCurrency	Currency
	AmountInBalanceTransacCrcy		AmountInBalanceTransacCrcy	Amount in Balance Transaction Currency
	FlowAmountInBalanceTransCrcy		FlowAmountInBalanceTransCrcy
	DebitAmountInBalanceTransCrcy		DebitAmountInBalanceTransCrcy	Debit Amount in Balance Trans. Currency
	CreditAmountInBalanceTransCrcy		CreditAmountInBalanceTransCrcy	Credit Amount in Balance Trans. Currency
	TransactionCurrency		TransactionCurrency	Transaction Currency
	AmountInTransactionCurrency		AmountInTransactionCurrency	Pt Crcy Amt
	FlowAmountInTransCrcy		FlowAmountInTransCrcy
	DebitAmountInTransCrcy		DebitAmountInTransCrcy	Debit Amt in DC
	CreditAmountInTransCrcy		CreditAmountInTransCrcy	Credit Amt in DC
	CompanyCodeCurrency		CompanyCodeCurrency	Local Currency
	AmountInCompanyCodeCurrency		AmountInCompanyCodeCurrency	Local Crcy Amt
	FlowAmountInCoCodeCrcy		FlowAmountInCoCodeCrcy
	DebitAmountInCoCodeCrcy		DebitAmountInCoCodeCrcy	Debit Amount in Company Code Currency
	CreditAmountInCoCodeCrcy		CreditAmountInCoCodeCrcy	Credit Amount in Company Code Currency
	GlobalCurrency		GlobalCurrency	GM Billing Element: Global Currency
	AmountInGlobalCurrency		AmountInGlobalCurrency	Amount in Global Currency
	FlowAmountInGlobalCrcy		FlowAmountInGlobalCrcy
	DebitAmountInGlobalCrcy		DebitAmountInGlobalCrcy
	CreditAmountInGlobalCrcy		CreditAmountInGlobalCrcy
	FreeDefinedCurrency1		FreeDefinedCurrency1	Freely Defined Currency 1
	AmountInFreeDefinedCurrency1		AmountInFreeDefinedCurrency1	Amount in Freely Defined Currency 1
	FlowAmountInFreeDfndCrcy1		FlowAmountInFreeDfndCrcy1
	DebitAmountInFreeDfndCrcy1		DebitAmountInFreeDfndCrcy1
	CreditAmountInFreeDfndCrcy1		CreditAmountInFreeDfndCrcy1
	FreeDefinedCurrency2		FreeDefinedCurrency2	Freely Defined Currency 2
	AmountInFreeDefinedCurrency2		AmountInFreeDefinedCurrency2	Amount in Freely Defined Currency 2
	FlowAmountInFreeDfndCrcy2		FlowAmountInFreeDfndCrcy2
	DebitAmountInFreeDfndCrcy2		DebitAmountInFreeDfndCrcy2
	CreditAmountInFreeDfndCrcy2		CreditAmountInFreeDfndCrcy2
	FreeDefinedCurrency3		FreeDefinedCurrency3	Freely Defined Currency 3
	AmountInFreeDefinedCurrency3		AmountInFreeDefinedCurrency3	Amount in Freely Defined Currency 3
	FlowAmountInFreeDfndCrcy3		FlowAmountInFreeDfndCrcy3
	DebitAmountInFreeDfndCrcy3		DebitAmountInFreeDfndCrcy3
	CreditAmountInFreeDfndCrcy3		CreditAmountInFreeDfndCrcy3
	FreeDefinedCurrency4		FreeDefinedCurrency4	Freely Defined Currency 4
	AmountInFreeDefinedCurrency4		AmountInFreeDefinedCurrency4	Amount in Freely Defined Currency 4
	FlowAmountInFreeDfndCrcy4		FlowAmountInFreeDfndCrcy4
	DebitAmountInFreeDfndCrcy4		DebitAmountInFreeDfndCrcy4
	CreditAmountInFreeDfndCrcy4		CreditAmountInFreeDfndCrcy4
	FreeDefinedCurrency5		FreeDefinedCurrency5	Freely Defined Currency 5
	AmountInFreeDefinedCurrency5		AmountInFreeDefinedCurrency5	Amount in Freely Defined Currency 5
	FlowAmountInFreeDfndCrcy5		FlowAmountInFreeDfndCrcy5
	DebitAmountInFreeDfndCrcy5		DebitAmountInFreeDfndCrcy5
	CreditAmountInFreeDfndCrcy5		CreditAmountInFreeDfndCrcy5
	FreeDefinedCurrency6		FreeDefinedCurrency6	Freely Defined Currency 6
	AmountInFreeDefinedCurrency6		AmountInFreeDefinedCurrency6	Amount in Freely Defined Currency 6
	FlowAmountInFreeDfndCrcy6		FlowAmountInFreeDfndCrcy6
	DebitAmountInFreeDfndCrcy6		DebitAmountInFreeDfndCrcy6
	CreditAmountInFreeDfndCrcy6		CreditAmountInFreeDfndCrcy6
	FreeDefinedCurrency7		FreeDefinedCurrency7	Freely Defined Currency 7
	AmountInFreeDefinedCurrency7		AmountInFreeDefinedCurrency7	Amount in Freely Defined Currency 7
	FlowAmountInFreeDfndCrcy7		FlowAmountInFreeDfndCrcy7
	DebitAmountInFreeDfndCrcy7		DebitAmountInFreeDfndCrcy7
	CreditAmountInFreeDfndCrcy7		CreditAmountInFreeDfndCrcy7
	FreeDefinedCurrency8		FreeDefinedCurrency8	Freely Defined Currency 8
	AmountInFreeDefinedCurrency8		AmountInFreeDefinedCurrency8	Amount in Freely Defined Currency 8
	FlowAmountInFreeDfndCrcy8		FlowAmountInFreeDfndCrcy8
	DebitAmountInFreeDfndCrcy8		DebitAmountInFreeDfndCrcy8
	CreditAmountInFreeDfndCrcy8		CreditAmountInFreeDfndCrcy8
	GLAccountFlowType		GLAccountFlowType
	GLAccountTypeFlowType		GLAccountTypeFlowType
	IsBalanceSheetAccount		IsBalanceSheetAccount	Is Balance Sheet Account
	DebitCreditCode		DebitCreditCode	Single-Character Flag
	FiscalPeriod		FiscalPeriod	Tax period
	FiscalYearVariant		FiscalYearVariant	FY Variant
	FiscalYearPeriod		FiscalYearPeriod	Period/Year
	PostingDate		PostingDate	Posting Date for GR
	DocumentDate		DocumentDate	Journal Entry Date
	AccountingDocumentType		AccountingDocumentType	Journal Entry Type
	AccountingDocumentItem		AccountingDocumentItem	Posting View Item
	AssignmentReference		AssignmentReference	Assignment Reference
	AccountingDocumentCategory		AccountingDocumentCategory	Journal Entry Category
	PostingKey		PostingKey	Posting Key
	TransactionTypeDetermination		TransactionTypeDetermination	Transaction Key
	SubLedgerAcctLineItemType		SubLedgerAcctLineItemType	SLALineItemType
	AccountingDocCreatedByUser		AccountingDocCreatedByUser	User which created overhead document
	LastChangeDateTime		LastChangeDateTime	Timestamp
	CreationDateTime		CreationDateTime	Timestamp
	CreationDate		CreationDate	Time Stamp
	EliminationProfitCenter		EliminationProfitCenter
	OriginObjectType		OriginObjectType	Origin
	GLAccountType		GLAccountType	G/L Account Type
	AlternativeGLAccount		AlternativeGLAccount	Group Account
	CountryChartOfAccounts		CountryChartOfAccounts	Chart of Accts
	InvoiceReference		InvoiceReference	Invoice Reference
	InvoiceReferenceFiscalYear		InvoiceReferenceFiscalYear	Invoice Reference Fiscal Year
	FollowOnDocumentType		FollowOnDocumentType	Follow-On Document Type
	InvoiceItemReference		InvoiceItemReference	Item
	ReferencePurchaseOrderCategory		ReferencePurchaseOrderCategory
	PurchasingDocument		PurchasingDocument	Purchasing Document
	PurchasingDocumentItem		PurchasingDocumentItem	Purchasing Doc. Item
	AccountAssignmentNumber		AccountAssignmentNumber	Account Assgmt No.
	DocumentItemText		DocumentItemText	Text
	SalesDocument		SalesDocument	SD Document
	SalesDocumentItem		SalesDocumentItem	Sales Document Item
	Product		Product	Product Sold
	Plant		Plant	Valuation Area
	Supplier		Supplier	Supplier
	Customer		Customer	Sold-to Party
	ServicesRenderedDate		ServicesRenderedDate	Services Rendered Date
	ConditionContract		ConditionContract	Condition Contract
	FinancialAccountType		FinancialAccountType	Fin. Account Type
	SpecialGLCode		SpecialGLCode	Special G/L Ind
	TaxCode		TaxCode	Tax Code
	HouseBank		HouseBank	House Bank
	HouseBankAccount		HouseBankAccount	House Bank Account
	IsOpenItemManaged		IsOpenItemManaged	Open Item Management
	ClearingDate		ClearingDate	Clearing Date
	ClearingAccountingDocument		ClearingAccountingDocument	Clearing Journal Entry
	ClearingDocFiscalYear		ClearingDocFiscalYear	Fiscal Year of Clearing Journal Entry
	ClearingJournalEntry		ClearingJournalEntry	Clrng doc.
	ClearingJournalEntryFiscalYear		ClearingJournalEntryFiscalYear	Fiscal Year of Clearing Journal Entry
	AssetDepreciationArea		AssetDepreciationArea	Deprec. Area
	MasterFixedAsset		MasterFixedAsset	Fixed Asset
	FixedAsset		FixedAsset	Sub-number
	AssetValueDate		AssetValueDate	Reference date
	AssetTransactionType		AssetTransactionType	Trans.Type
	AssetAcctTransClassfctn		AssetAcctTransClassfctn	Trans.Type Cat.
	DepreciationFiscalPeriod		DepreciationFiscalPeriod	Deprec. Period
	GroupMasterFixedAsset		GroupMasterFixedAsset
	GroupFixedAsset		GroupFixedAsset
	CostEstimate		CostEstimate	Cost EstimateNo
	InventorySpecialStockValnType		InventorySpecialStockValnType	Valuation
	InvtrySpecialStockValnType_2		InvtrySpecialStockValnType_2
	InventorySpecialStockType		InventorySpecialStockType	Special Stock Type
	InventorySpclStkSalesDocument		InventorySpclStkSalesDocument
	InventorySpclStkSalesDocItm		InventorySpclStkSalesDocItm
	InvtrySpclStockWBSElmntIntID		InvtrySpclStockWBSElmntIntID
	InvtrySpclStockWBSElmntExtID		InvtrySpclStockWBSElmntExtID
	InventorySpecialStockSupplier		InventorySpecialStockSupplier
	InventoryValuationType		InventoryValuationType	Valuation Type
	ValuationArea		ValuationArea	Valuation Area
	SenderGLAccount		SenderGLAccount
	SenderAccountAssignment		SenderAccountAssignment
	SenderAccountAssignmentType		SenderAccountAssignmentType
	CostOriginGroup		CostOriginGroup	Origin Group
	OriginSenderObject		OriginSenderObject
	ControllingDebitCreditCode		ControllingDebitCreditCode	Dr/Cr ind. CO
	ControllingObjectDebitType		ControllingObjectDebitType
	QuantityIsIncomplete		QuantityIsIncomplete
	OffsettingAccount		OffsettingAccount	Offsetting Acct
	OffsettingAccountType		OffsettingAccountType	Offset Acct Type
	OffsettingChartOfAccounts		OffsettingChartOfAccounts	Offsetting Chart of Accounts
	LineItemIsCompleted		LineItemIsCompleted	Item Completed
	PersonnelNumber		PersonnelNumber	Personnel No.
	ControllingObjectClass		ControllingObjectClass	Object Class
	PartnerCompanyCode		PartnerCompanyCode	Partner Company Code
	PartnerControllingObjectClass		PartnerControllingObjectClass
	OriginCostCenter		OriginCostCenter
	OriginProfitCenter		OriginProfitCenter
	OriginCostCtrActivityType		OriginCostCtrActivityType
	AccountAssignment		AccountAssignment	Sender Acct Assgmt
	AccountAssignmentType		AccountAssignmentType	Sndr AcctAssgmt Type
	CostCtrActivityType		CostCtrActivityType	Activity Type
	OrderID		OrderID	Order ID
	OrderCategory		OrderCategory	Order Category
	ServiceDocumentType		ServiceDocumentType	Transaction Type
	ServiceDocument		ServiceDocument	Transaction ID
	ServiceDocumentItem		ServiceDocumentItem	Service Document
	ServiceContractType		ServiceContractType
	ServiceContract		ServiceContract	Transaction ID
	ServiceContractItem		ServiceContractItem	Item Number in Doc.
	TimeSheetOvertimeCategory		TimeSheetOvertimeCategory
	WBSElementInternalID		WBSElementInternalID	WBS Internal ID
	WBSElementExternalID		WBSElementExternalID	WBS Element External ID
	WBSElement		WBSElement	WBS Internal ID
	ProjectInternalID		ProjectInternalID	Project Def.
	ProjectExternalID		ProjectExternalID	Project def.
	Project		Project	WBS Element
	OperatingConcern		OperatingConcern	Operating concern
	ProjectNetwork		ProjectNetwork	Order
	RelatedNetworkActivity		RelatedNetworkActivity	Netwk activity
	BusinessProcess		BusinessProcess	Business Process
	CostObject		CostObject	Cost Object
	BillableControl		BillableControl	Billable Control
	CostAnalysisResource		CostAnalysisResource
	CustomerServiceNotification		CustomerServiceNotification
	PartnerAccountAssignment		PartnerAccountAssignment	Partner Account Assignment
	PartnerAccountAssignmentType		PartnerAccountAssignmentType	Partner Account Assignment Type
	WorkPackage		WorkPackage	Plan Item
	WorkItem		WorkItem	Work Item ID
	PartnerCostCtrActivityType		PartnerCostCtrActivityType	Partner Cost Center Activity Type
	PartnerOrder		PartnerOrder	Partner Order
	PartnerOrder_2		PartnerOrder_2
	PartnerOrderCategory		PartnerOrderCategory
	PartnerWBSElementInternalID		PartnerWBSElementInternalID	Partner WBS Element Internal ID
	PartnerWBSElementExternalID		PartnerWBSElementExternalID	Partner WBSElmnt ext
	PartnerWBSElement		PartnerWBSElement	WBS Element
	PartnerProjectInternalID		PartnerProjectInternalID
	PartnerProjectExternalID		PartnerProjectExternalID	Partner Project External ID
	PartnerProject		PartnerProject
	PartnerSalesDocument		PartnerSalesDocument	Partner Sales Doc.
	PartnerSalesDocumentItem		PartnerSalesDocumentItem	Partner Sales Document Item
	PartnerProjectNetwork		PartnerProjectNetwork	Part. Proj. Network
	PartnerProjectNetworkActivity		PartnerProjectNetworkActivity	Partner Project Network Activity
	PartnerBusinessProcess		PartnerBusinessProcess	Part. Bus. Process
	PartnerCostObject		PartnerCostObject	Partner Cost Object
	BillingDocumentType		BillingDocumentType	Billing Type
	SalesOrganization		SalesOrganization	Sales Organization
	DistributionChannel		DistributionChannel	RefDistCh-Cust/Mat.
	OrganizationDivision		OrganizationDivision	Org. Division
	SoldProduct		SoldProduct	Product Sold
	SoldProductGroup		SoldProductGroup	Product Sold Group
	CustomerGroup		CustomerGroup	Customer Group
	CustomerSupplierCountry		CustomerSupplierCountry	Customer or Supplier Country/Region
	CustomerSupplierIndustry		CustomerSupplierIndustry	Industry
	SalesDistrict		SalesDistrict	Sales District
	BillToParty		BillToParty	Inv. Recipient
	ShipToParty		ShipToParty	Ship-To Party (obsolete)
	CustomerSupplierCorporateGroup		CustomerSupplierCorporateGroup	Group
	JointVenture		JointVenture	Joint venture
	JointVentureEquityGroup		JointVentureEquityGroup	Joint Venture Equity Group
	JointVentureCostRecoveryCode		JointVentureCostRecoveryCode	Recovery Ind.
	JointVentureEquityType		JointVentureEquityType	Joint Venture Equity Type
	SettlementReferenceDate		SettlementReferenceDate	Reference date
	WorkCenterInternalID		WorkCenterInternalID	Work Center
	OrderOperation		OrderOperation	Operation or Phase
	OrderItem		OrderItem
	OrderSuboperation		OrderSuboperation
	Equipment		Equipment	Equipment check
	FunctionalLocation		FunctionalLocation	Object ID
	Assembly		Assembly	Pegged Reqmt
	MaintenanceActivityType		MaintenanceActivityType	MaintActivType
	MaintenanceOrderPlanningCode		MaintenanceOrderPlanningCode	OrderPlanInd.
	MaintPriorityType		MaintPriorityType	PriorityType
	MaintPriority		MaintPriority	Priority
	SuperiorOrder		SuperiorOrder
	ProductGroup		ProductGroup	Product Sold Group
	MaintenanceOrderIsPlanned		MaintenanceOrderIsPlanned
	IsStatisticalOrder		IsStatisticalOrder	Statistical Order
	IsStatisticalCostCenter		IsStatisticalCostCenter	Cost Center Is Stat.
	IsStatisticalSalesDocument		IsStatisticalSalesDocument
	WBSIsStatisticalWBSElement		WBSIsStatisticalWBSElement	Statistical
	CalendarYear		CalendarYear	Year
	CalendarQuarter		CalendarQuarter	Calendar Quarter
	CalendarYearQuarter		CalendarYearQuarter
	CalendarMonth		CalendarMonth	Calendar Month
	CalendarYearMonth		CalendarYearMonth
	CalendarWeek		CalendarWeek	Calendar Week
	CalendarYearWeek		CalendarYearWeek
	FiscalQuarter	_FiscalCalendarDate	FiscalQuarter
	FiscalWeek	_FiscalCalendarDate	FiscalWeek
	FiscalYearQuarter	_FiscalCalendarDate	FiscalYearQuarter
	FiscalYearWeek	_FiscalCalendarDate	FiscalYearWeek
	AccrualObjectLogicalSystem		AccrualObjectLogicalSystem	Logical System
	AccrualObjectType		AccrualObjectType	Accrual Object Type
	AccrualObject		AccrualObject	External Reference of Accrual Object
	AccrualSubobject		AccrualSubobject	External Reference of Accrual Subobject
	AccrualItemType		AccrualItemType	Accrual Item Type
	CashLedgerCompanyCode		CashLedgerCompanyCode	Cash Origin CoCode
	CashLedgerAccount		CashLedgerAccount	Cash Origin Account
	FinancialManagementArea		FinancialManagementArea	FM Area
	FundsCenter		FundsCenter	Funds Center
	FundedProgram		FundedProgram	Funded Program
	Fund		Fund	Sender Fund
	GrantID		GrantID	Sender Grant
	BudgetPeriod		BudgetPeriod	Budget Period

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_GLAccountBalance.
-- 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: IFIGLACCTBAL

CREATE VIEW I_GLAccountBalance AS
SELECT
  SourceLedger,
  CompanyCode,
  FiscalYear,
  AccountingDocument,
  LedgerGLLineItem,
  Ledger,
  LedgerFiscalYear,
  GLRecordType,
  ChartOfAccounts,
  ControllingArea,
  FinancialTransactionType,
  BusinessTransactionType,
  ReferenceDocumentType,
  LogicalSystem,
  ReferenceDocumentContext,
  ReferenceDocument,
  ReferenceDocumentItem,
  ReferenceDocumentItemGroup,
  IsReversal,
  IsReversed,
  ReversalReferenceDocumentCntxt,
  ReversalReferenceDocument,
  IsSettlement,
  IsSettled,
  PredecessorReferenceDocType,
  PredecessorReferenceDocCntxt,
  PredecessorReferenceDocument,
  PredecessorReferenceDocItem,
  SourceReferenceDocumentType,
  SourceLogicalSystem,
  SourceReferenceDocumentCntxt,
  SourceReferenceDocument,
  SourceReferenceDocumentItem,
  SourceReferenceDocSubitem,
  IsCommitment,
  JrnlEntryItemObsoleteReason,
  GLAccount,
  CostCenter,
  ProfitCenter,
  FunctionalArea,
  BusinessArea,
  Segment,
  PartnerCostCenter,
  PartnerProfitCenter,
  PartnerFunctionalArea,
  PartnerBusinessArea,
  PartnerCompany,
  PartnerSegment,
  BalanceTransactionCurrency,
  AmountInBalanceTransacCrcy,
  FlowAmountInBalanceTransCrcy,
  DebitAmountInBalanceTransCrcy,
  CreditAmountInBalanceTransCrcy,
  TransactionCurrency,
  AmountInTransactionCurrency,
  FlowAmountInTransCrcy,
  DebitAmountInTransCrcy,
  CreditAmountInTransCrcy,
  CompanyCodeCurrency,
  AmountInCompanyCodeCurrency,
  FlowAmountInCoCodeCrcy,
  DebitAmountInCoCodeCrcy,
  CreditAmountInCoCodeCrcy,
  GlobalCurrency,
  AmountInGlobalCurrency,
  FlowAmountInGlobalCrcy,
  DebitAmountInGlobalCrcy,
  CreditAmountInGlobalCrcy,
  FreeDefinedCurrency1,
  AmountInFreeDefinedCurrency1,
  FlowAmountInFreeDfndCrcy1,
  DebitAmountInFreeDfndCrcy1,
  CreditAmountInFreeDfndCrcy1,
  FreeDefinedCurrency2,
  AmountInFreeDefinedCurrency2,
  FlowAmountInFreeDfndCrcy2,
  DebitAmountInFreeDfndCrcy2,
  CreditAmountInFreeDfndCrcy2,
  FreeDefinedCurrency3,
  AmountInFreeDefinedCurrency3,
  FlowAmountInFreeDfndCrcy3,
  DebitAmountInFreeDfndCrcy3,
  CreditAmountInFreeDfndCrcy3,
  FreeDefinedCurrency4,
  AmountInFreeDefinedCurrency4,
  FlowAmountInFreeDfndCrcy4,
  DebitAmountInFreeDfndCrcy4,
  CreditAmountInFreeDfndCrcy4,
  FreeDefinedCurrency5,
  AmountInFreeDefinedCurrency5,
  FlowAmountInFreeDfndCrcy5,
  DebitAmountInFreeDfndCrcy5,
  CreditAmountInFreeDfndCrcy5,
  FreeDefinedCurrency6,
  AmountInFreeDefinedCurrency6,
  FlowAmountInFreeDfndCrcy6,
  DebitAmountInFreeDfndCrcy6,
  CreditAmountInFreeDfndCrcy6,
  FreeDefinedCurrency7,
  AmountInFreeDefinedCurrency7,
  FlowAmountInFreeDfndCrcy7,
  DebitAmountInFreeDfndCrcy7,
  CreditAmountInFreeDfndCrcy7,
  FreeDefinedCurrency8,
  AmountInFreeDefinedCurrency8,
  FlowAmountInFreeDfndCrcy8,
  DebitAmountInFreeDfndCrcy8,
  CreditAmountInFreeDfndCrcy8,
  GLAccountFlowType,
  GLAccountTypeFlowType,
  IsBalanceSheetAccount,
  DebitCreditCode,
  FiscalPeriod,
  FiscalYearVariant,
  FiscalYearPeriod,
  PostingDate,
  DocumentDate,
  AccountingDocumentType,
  AccountingDocumentItem,
  AssignmentReference,
  AccountingDocumentCategory,
  PostingKey,
  TransactionTypeDetermination,
  SubLedgerAcctLineItemType,
  AccountingDocCreatedByUser,
  LastChangeDateTime,
  CreationDateTime,
  CreationDate,
  EliminationProfitCenter,
  OriginObjectType,
  GLAccountType,
  AlternativeGLAccount,
  CountryChartOfAccounts,
  InvoiceReference,
  InvoiceReferenceFiscalYear,
  FollowOnDocumentType,
  InvoiceItemReference,
  ReferencePurchaseOrderCategory,
  PurchasingDocument,
  PurchasingDocumentItem,
  AccountAssignmentNumber,
  DocumentItemText,
  SalesDocument,
  SalesDocumentItem,
  Product,
  Plant,
  Supplier,
  Customer,
  ServicesRenderedDate,
  ConditionContract,
  FinancialAccountType,
  SpecialGLCode,
  TaxCode,
  HouseBank,
  HouseBankAccount,
  IsOpenItemManaged,
  ClearingDate,
  ClearingAccountingDocument,
  ClearingDocFiscalYear,
  ClearingJournalEntry,
  ClearingJournalEntryFiscalYear,
  AssetDepreciationArea,
  MasterFixedAsset,
  FixedAsset,
  AssetValueDate,
  AssetTransactionType,
  AssetAcctTransClassfctn,
  DepreciationFiscalPeriod,
  GroupMasterFixedAsset,
  GroupFixedAsset,
  CostEstimate,
  InventorySpecialStockValnType,
  InvtrySpecialStockValnType_2,
  InventorySpecialStockType,
  InventorySpclStkSalesDocument,
  InventorySpclStkSalesDocItm,
  InvtrySpclStockWBSElmntIntID,
  InvtrySpclStockWBSElmntExtID,
  InventorySpecialStockSupplier,
  InventoryValuationType,
  ValuationArea,
  SenderGLAccount,
  SenderAccountAssignment,
  SenderAccountAssignmentType,
  CostOriginGroup,
  OriginSenderObject,
  ControllingDebitCreditCode,
  ControllingObjectDebitType,
  QuantityIsIncomplete,
  OffsettingAccount,
  OffsettingAccountType,
  OffsettingChartOfAccounts,
  LineItemIsCompleted,
  PersonnelNumber,
  ControllingObjectClass,
  PartnerCompanyCode,
  PartnerControllingObjectClass,
  OriginCostCenter,
  OriginProfitCenter,
  OriginCostCtrActivityType,
  AccountAssignment,
  AccountAssignmentType,
  CostCtrActivityType,
  OrderID,
  OrderCategory,
  ServiceDocumentType,
  ServiceDocument,
  ServiceDocumentItem,
  ServiceContractType,
  ServiceContract,
  ServiceContractItem,
  TimeSheetOvertimeCategory,
  WBSElementInternalID,
  WBSElementExternalID,
  WBSElement,
  ProjectInternalID,
  ProjectExternalID,
  Project,
  OperatingConcern,
  ProjectNetwork,
  RelatedNetworkActivity,
  BusinessProcess,
  CostObject,
  BillableControl,
  CostAnalysisResource,
  CustomerServiceNotification,
  PartnerAccountAssignment,
  PartnerAccountAssignmentType,
  WorkPackage,
  WorkItem,
  PartnerCostCtrActivityType,
  PartnerOrder,
  PartnerOrder_2,
  PartnerOrderCategory,
  PartnerWBSElementInternalID,
  PartnerWBSElementExternalID,
  PartnerWBSElement,
  PartnerProjectInternalID,
  PartnerProjectExternalID,
  PartnerProject,
  PartnerSalesDocument,
  PartnerSalesDocumentItem,
  PartnerProjectNetwork,
  PartnerProjectNetworkActivity,
  PartnerBusinessProcess,
  PartnerCostObject,
  BillingDocumentType,
  SalesOrganization,
  DistributionChannel,
  OrganizationDivision,
  SoldProduct,
  SoldProductGroup,
  CustomerGroup,
  CustomerSupplierCountry,
  CustomerSupplierIndustry,
  SalesDistrict,
  BillToParty,
  ShipToParty,
  CustomerSupplierCorporateGroup,
  JointVenture,
  JointVentureEquityGroup,
  JointVentureCostRecoveryCode,
  JointVentureEquityType,
  SettlementReferenceDate,
  WorkCenterInternalID,
  OrderOperation,
  OrderItem,
  OrderSuboperation,
  Equipment,
  FunctionalLocation,
  Assembly,
  MaintenanceActivityType,
  MaintenanceOrderPlanningCode,
  MaintPriorityType,
  MaintPriority,
  SuperiorOrder,
  ProductGroup,
  MaintenanceOrderIsPlanned,
  IsStatisticalOrder,
  IsStatisticalCostCenter,
  IsStatisticalSalesDocument,
  WBSIsStatisticalWBSElement,
  CalendarYear,
  CalendarQuarter,
  CalendarYearQuarter,
  CalendarMonth,
  CalendarYearMonth,
  CalendarWeek,
  CalendarYearWeek,
  _FiscalCalendarDate.FiscalQuarter AS FiscalQuarter,
  _FiscalCalendarDate.FiscalWeek AS FiscalWeek,
  _FiscalCalendarDate.FiscalYearQuarter AS FiscalYearQuarter,
  _FiscalCalendarDate.FiscalYearWeek AS FiscalYearWeek,
  AccrualObjectLogicalSystem,
  AccrualObjectType,
  AccrualObject,
  AccrualSubobject,
  AccrualItemType,
  CashLedgerCompanyCode,
  CashLedgerAccount,
  FinancialManagementArea,
  FundsCenter,
  FundedProgram,
  Fund,
  GrantID,
  BudgetPeriod
FROM P_GLAccountBalance
LEFT OUTER JOIN I_Grant AS _Grant ON GrantID = _Grant.GrantID  -- association [0..1]
LEFT OUTER JOIN I_Grant AS _PartnerGrant ON PartnerGrant = _PartnerGrant.GrantID  -- association [0..1]
LEFT OUTER JOIN E_JournalEntryItem AS _Extension ON SourceLedger = _Extension.SourceLedger AND CompanyCode = _Extension.CompanyCode AND FiscalYear = _Extension.FiscalYear AND AccountingDocument = _Extension.AccountingDocument AND LedgerGLLineItem = _Extension.LedgerGLLineItem  -- association [1..1]
;

Depth:

I_GLAccountBalance view

P_GLAccountBalance view

C_GLAccountFlow view