What is P_ActualPlanGLAcctBalance in SAP S/4HANA?

P_ActualPlanGLAcctBalance is a composite CDS view in SAP S/4HANA. Actual Plan G/L Account Balances It contains 119 fields.

Which tables does P_ActualPlanGLAcctBalance read from?

P_ActualPlanGLAcctBalance reads data from: I_SemTagGLAccount, P_ActualPlanGLAcctBalance2.

What VDM layer is P_ActualPlanGLAcctBalance?

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

P_ActualPlanGLAcctBalance

DDL: P_ACTUALPLANGLACCTBALANCE Type: view_entity COMPOSITE Package: FINS_FIS_FICO

119 Fields 2 Data Sources 12 Associations

Actual Plan G/L Account Balances

P_ActualPlanGLAcctBalance is a Composite CDS View that provides data about "Actual Plan G/L Account Balances" in SAP S/4HANA. It reads from 2 data sources (I_SemTagGLAccount, P_ActualPlanGLAcctBalance2) and exposes 119 fields with key fields SourceLedger, CompanyCode, FiscalYear, AccountingDocument, LedgerGLLineItem. It has 12 associations to related views. Part of development package FINS_FIS_FICO.

Data Sources (2)

Source	Alias	Join Type
I_SemTagGLAccount	I_SemTagGLAccount	inner
P_ActualPlanGLAcctBalance2	P_ActualPlanGLAcctBalance2	from

Associations (12)

Cardinality	Target	Alias	Condition
[0..1]	I_FiscalYearPeriodForCmpnyCode	_FiscalPeriod	`$projection.LedgerFiscalYear = _FiscalPeriod.FiscalYear and $projection.FiscalPeriod = _FiscalPeriod.FiscalPeriod and $projection.CompanyCode = _FiscalPeriod.CompanyCode`
[0..1]	I_FiscalPeriodForVariant	_FiscalPeriodForVariant	`$projection.LedgerFiscalYear = _FiscalPeriodForVariant.FiscalYear and $projection.FiscalPeriod = _FiscalPeriodForVariant.FiscalPeriod and $projection.FiscalYearVariant = _FiscalPeriodForVariant.FiscalYearVariant`
[0..1]	I_FiscalCalYearPeriodForCoCode	_FiscalYearPeriod	`$projection.FiscalYearPeriod = _FiscalYearPeriod.FiscalYearPeriod and $projection.CompanyCode = _FiscalYearPeriod.CompanyCode`
[0..1]	I_FiscalYearPeriodForVariant	_FiscalYearPeriodForVariant	`$projection.FiscalYearPeriod = _FiscalYearPeriodForVariant.FiscalYearPeriod and $projection.FiscalYearVariant = _FiscalYearPeriodForVariant.FiscalYearVariant`
[0..1]	I_AccountingDocumentType	_AccountingDocumentType	`$projection.AccountingDocumentType = _AccountingDocumentType.AccountingDocumentType`
[0..1]	I_Customer	_Customer	`$projection.Customer = _Customer.Customer`
[0..1]	I_Supplier	_Supplier	`$projection.Supplier = _Supplier.Supplier`
[0..1]	I_FixedAsset	_FixedAsset	`$projection.CompanyCode = _FixedAsset.CompanyCode and $projection.MasterFixedAsset = _FixedAsset.MasterFixedAsset and $projection.FixedAsset = _FixedAsset.FixedAsset`
[0..1]	I_Order	_Order	`$projection.OrderID = _Order.OrderID`
[0..1]	I_SalesDocument	_SalesDocument	`$projection.SalesDocument = _SalesDocument.SalesDocument`
[0..1]	I_SrvcDocByDocumentType	_ServiceDocument	`$projection.ServiceDocumentType = _ServiceDocument.ServiceDocumentType and $projection.ServiceDocument = _ServiceDocument.ServiceDocument`
[0..1]	I_PlanningCategory	_PlanningCategory	`$projection.PlanningCategory = _PlanningCategory.PlanningCategory`

Annotations (6)

Name	Value	Level
AbapCatalog.entityBuffer.definitionAllowed	false	view
VDM.viewType	#COMPOSITE	view
VDM.private	true	view
AccessControl.authorizationCheck	#CHECK	view
Metadata.ignorePropagatedAnnotations	true	view
Environment.sql.passValueForClient	true	view

Fields (119)

Key	Field	Source Table	Source Field	Description
KEY	SourceLedger	P_ActualPlanGLAcctBalance2	SourceLedger	Source Ledger
KEY	CompanyCode	P_ActualPlanGLAcctBalance2	CompanyCode	Receiver Company Code
KEY	FiscalYear	P_ActualPlanGLAcctBalance2	FiscalYear	G/L Fiscal Year
KEY	AccountingDocument	P_ActualPlanGLAcctBalance2	AccountingDocument	Journal Entry
KEY	LedgerGLLineItem	P_ActualPlanGLAcctBalance2	LedgerGLLineItem	Journal Entry Item
KEY	Ledger	P_ActualPlanGLAcctBalance2	Ledger	Ledger
	LedgerFiscalYear	P_ActualPlanGLAcctBalance2	LedgerFiscalYear
	ActualPlanCode	P_ActualPlanGLAcctBalance2	ActualPlanCode
	ChartOfAccounts	P_ActualPlanGLAcctBalance2	ChartOfAccounts	Node Class
	ControllingArea	P_ActualPlanGLAcctBalance2	ControllingArea	Controlling Area
	GLAccount	P_ActualPlanGLAcctBalance2	GLAccount	General Ledger
	CostCenter	P_ActualPlanGLAcctBalance2	CostCenter	Cost Center
	ProfitCenter	P_ActualPlanGLAcctBalance2	ProfitCenter	Profit Center
	FunctionalArea	P_ActualPlanGLAcctBalance2	FunctionalArea	Sendr Fctl Area
	BusinessArea	P_ActualPlanGLAcctBalance2	BusinessArea	Business Area
	Segment	P_ActualPlanGLAcctBalance2	Segment	Segment number
	Product	P_ActualPlanGLAcctBalance2	Product	Product Sold
	PlanningCategory	P_ActualPlanGLAcctBalance2	PlanningCategory	Plan Category
	GLAccountFlowType	P_ActualPlanGLAcctBalance2	GLAccountFlowType
	GLAccountTypeFlowType	P_ActualPlanGLAcctBalance2	GLAccountTypeFlowType
	IsBalanceSheetAccount	P_ActualPlanGLAcctBalance2	IsBalanceSheetAccount	Is Balance Sheet Account
	GLAccountType	P_ActualPlanGLAcctBalance2	GLAccountType	G/L Account Type
	DebitCreditCode	P_ActualPlanGLAcctBalance2	DebitCreditCode	Single-Character Flag
	AccountingDocumentCategory	P_ActualPlanGLAcctBalance2	AccountingDocumentCategory	Journal Entry Category
	OrderType	P_ActualPlanGLAcctBalance2	OrderType	Order Type
	AssetClass	P_ActualPlanGLAcctBalance2	AssetClass	Asset Class
	FinancialAccountType	P_ActualPlanGLAcctBalance2	FinancialAccountType	Fin. Account Type
	SalesOrganization	P_ActualPlanGLAcctBalance2	SalesOrganization	Sales Organization
	DistributionChannel	P_ActualPlanGLAcctBalance2	DistributionChannel	RefDistCh-Cust/Mat.
	OrganizationDivision	P_ActualPlanGLAcctBalance2	OrganizationDivision	Org. Division
	ServiceDocumentType	P_ActualPlanGLAcctBalance2	ServiceDocumentType	Transaction Type
	Plant	P_ActualPlanGLAcctBalance2	Plant	Valuation Area
	ValuationArea	P_ActualPlanGLAcctBalance2	ValuationArea	Valuation Area
	ServiceDocument	P_ActualPlanGLAcctBalance2	ServiceDocument	Transaction ID
	SalesDocument	P_ActualPlanGLAcctBalance2	SalesDocument	SD Document
	MasterFixedAsset	P_ActualPlanGLAcctBalance2	MasterFixedAsset	Fixed Asset
	FixedAsset	P_ActualPlanGLAcctBalance2	FixedAsset	Sub-number
	AccountingDocumentType	P_ActualPlanGLAcctBalance2	AccountingDocumentType	Journal Entry Type
	Customer	P_ActualPlanGLAcctBalance2	Customer	Sold-to Party
	Supplier	P_ActualPlanGLAcctBalance2	Supplier	Supplier
	OrderID	P_ActualPlanGLAcctBalance2	OrderID	Order ID
	GLAccountHierarchy	I_SemTagGLAccount	GLAccountHierarchy
	HierarchyNode	I_SemTagGLAccount	HierarchyNode	Node
	SemanticTag	I_SemTagGLAccount	SemanticTag	Semantic Tag
	ValidityEndDate	I_SemTagGLAccount	ValidityEndDate	ValidTo
	ValidityStartDate	I_SemTagGLAccount	ValidityStartDate	Validity Start Date
	BalanceTransactionCurrency	P_ActualPlanGLAcctBalance2	BalanceTransactionCurrency	Currency
	AmountInBalanceTransacCrcy	P_ActualPlanGLAcctBalance2	AmountInBalanceTransacCrcy	Amount in Balance Transaction Currency
	TransactionCurrency	P_ActualPlanGLAcctBalance2	TransactionCurrency	Transaction Currency
	AmountInTransactionCurrency	P_ActualPlanGLAcctBalance2	AmountInTransactionCurrency	Pt Crcy Amt
	CompanyCodeCurrency	P_ActualPlanGLAcctBalance2	CompanyCodeCurrency	Local Currency
	AmountInCompanyCodeCurrency	P_ActualPlanGLAcctBalance2	AmountInCompanyCodeCurrency	Local Crcy Amt
	HslwoBCF
	HslonlyBCF
	GlobalCurrency	P_ActualPlanGLAcctBalance2	GlobalCurrency	GM Billing Element: Global Currency
	AmountInGlobalCurrency	P_ActualPlanGLAcctBalance2	AmountInGlobalCurrency	Amount in Global Currency
	FixedAmountInGlobalCrcy	P_ActualPlanGLAcctBalance2	FixedAmountInGlobalCrcy
	CostSourceUnit	P_ActualPlanGLAcctBalance2	CostSourceUnit
	ValuationQuantity	P_ActualPlanGLAcctBalance2	ValuationQuantity
	FiscalPeriod	P_ActualPlanGLAcctBalance2	FiscalPeriod	Tax period
	FiscalYearVariant	P_ActualPlanGLAcctBalance2	FiscalYearVariant	FY Variant
	FiscalYearPeriod	P_ActualPlanGLAcctBalance2	FiscalYearPeriod	Period/Year
	PostingDate	P_ActualPlanGLAcctBalance2	PostingDate	Posting Date for GR
	CalendarYear	P_ActualPlanGLAcctBalance2	CalendarYear	Year
	CalendarQuarter	P_ActualPlanGLAcctBalance2	CalendarQuarter	Calendar Quarter
	CalendarYearQuarter	P_ActualPlanGLAcctBalance2	CalendarYearQuarter
	CalendarMonth	P_ActualPlanGLAcctBalance2	CalendarMonth	Calendar Month
	CalendarYearMonth	P_ActualPlanGLAcctBalance2	CalendarYearMonth
	CalendarWeek	P_ActualPlanGLAcctBalance2	CalendarWeek	Calendar Week
	CalendarYearWeek	P_ActualPlanGLAcctBalance2	CalendarYearWeek
	CalendarDate	P_ActualPlanGLAcctBalance2	CalendarDate	Calendar Date
	FiscalQuarter	P_ActualPlanGLAcctBalance2	FiscalQuarter
	FiscalWeek	P_ActualPlanGLAcctBalance2	FiscalWeek
	FiscalYearQuarter	P_ActualPlanGLAcctBalance2	FiscalYearQuarter
	FiscalYearWeek	P_ActualPlanGLAcctBalance2	FiscalYearWeek
	_AccountingDocumentType		_AccountingDocumentType
	_BalanceTransactionCurrency	P_ActualPlanGLAcctBalance2	_BalanceTransactionCurrency
	_BusinessArea	P_ActualPlanGLAcctBalance2	_BusinessArea
	_ChartOfAccounts	P_ActualPlanGLAcctBalance2	_ChartOfAccounts
	_CompanyCode	P_ActualPlanGLAcctBalance2	_CompanyCode
	_CompanyCodeCurrency	P_ActualPlanGLAcctBalance2	_CompanyCodeCurrency
	_ControllingArea	P_ActualPlanGLAcctBalance2	_ControllingArea
	_CostCenter	P_ActualPlanGLAcctBalance2	_CostCenter
	_CostSourceUnit	P_ActualPlanGLAcctBalance2	_CostSourceUnit
	_CurrentCostCenter	P_ActualPlanGLAcctBalance2	_CurrentCostCenter
	_CurrentProfitCenter	P_ActualPlanGLAcctBalance2	_CurrentProfitCenter
	_Customer		_Customer
	_DebitCreditCode	P_ActualPlanGLAcctBalance2	_DebitCreditCode
	_FiscalCalendarDate	P_ActualPlanGLAcctBalance2	_FiscalCalendarDate
	_FiscalPeriod		_FiscalPeriod
	_FiscalPeriodForVariant		_FiscalPeriodForVariant
	_FiscalYear	P_ActualPlanGLAcctBalance2	_FiscalYear
	_FiscalYearPeriod		_FiscalYearPeriod
	_FiscalYearPeriodForVariant		_FiscalYearPeriodForVariant
	_FiscalYearVariant	P_ActualPlanGLAcctBalance2	_FiscalYearVariant
	_FixedAsset		_FixedAsset
	_FunctionalArea	P_ActualPlanGLAcctBalance2	_FunctionalArea
	_GLAccountFlowType	P_ActualPlanGLAcctBalance2	_GLAccountFlowType
	_GLAccountFlowTypeText	P_ActualPlanGLAcctBalance2	_GLAccountFlowTypeText
	_GLAccountInChartOfAccounts	P_ActualPlanGLAcctBalance2	_GLAccountInChartOfAccounts
	_GLAccountInCompanyCode	P_ActualPlanGLAcctBalance2	_GLAccountInCompanyCode
	_GLAccountType	P_ActualPlanGLAcctBalance2	_GLAccountType
	_GLAccountTypeFlowType	P_ActualPlanGLAcctBalance2	_GLAccountTypeFlowType
	_GLAccountTypeFlowTypeTxt	P_ActualPlanGLAcctBalance2	_GLAccountTypeFlowTypeTxt
	_GlobalCurrency	P_ActualPlanGLAcctBalance2	_GlobalCurrency
	_JournalEntry	P_ActualPlanGLAcctBalance2	_JournalEntry
	_Ledger	P_ActualPlanGLAcctBalance2	_Ledger
	_LedgerFiscalYearForVariant	P_ActualPlanGLAcctBalance2	_LedgerFiscalYearForVariant
	_Order		_Order
	_PlanningCategory		_PlanningCategory
	_ProfitCenter	P_ActualPlanGLAcctBalance2	_ProfitCenter
	_SalesDocument		_SalesDocument
	_ServiceDocument		_ServiceDocument
	_Segment	P_ActualPlanGLAcctBalance2	_Segment
	_SourceLedger	P_ActualPlanGLAcctBalance2	_SourceLedger
	_Supplier		_Supplier
	_TransactionCurrency	P_ActualPlanGLAcctBalance2	_TransactionCurrency
	_SemanticTag	I_SemTagGLAccount	_SemanticTag
	_Hierarchy	I_SemTagGLAccount	_Hierarchy

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 P_ActualPlanGLAcctBalance.
-- 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.

CREATE VIEW P_ActualPlanGLAcctBalance AS
SELECT
  P_ActualPlanGLAcctBalance2.SourceLedger AS SourceLedger,
  P_ActualPlanGLAcctBalance2.CompanyCode AS CompanyCode,
  P_ActualPlanGLAcctBalance2.FiscalYear AS FiscalYear,
  P_ActualPlanGLAcctBalance2.AccountingDocument AS AccountingDocument,
  P_ActualPlanGLAcctBalance2.LedgerGLLineItem AS LedgerGLLineItem,
  P_ActualPlanGLAcctBalance2.Ledger AS Ledger,
  P_ActualPlanGLAcctBalance2.LedgerFiscalYear AS LedgerFiscalYear,
  P_ActualPlanGLAcctBalance2.ActualPlanCode AS ActualPlanCode,
  P_ActualPlanGLAcctBalance2.ChartOfAccounts AS ChartOfAccounts,
  P_ActualPlanGLAcctBalance2.ControllingArea AS ControllingArea,
  P_ActualPlanGLAcctBalance2.GLAccount AS GLAccount,
  P_ActualPlanGLAcctBalance2.CostCenter AS CostCenter,
  P_ActualPlanGLAcctBalance2.ProfitCenter AS ProfitCenter,
  P_ActualPlanGLAcctBalance2.FunctionalArea AS FunctionalArea,
  P_ActualPlanGLAcctBalance2.BusinessArea AS BusinessArea,
  P_ActualPlanGLAcctBalance2.Segment AS Segment,
  P_ActualPlanGLAcctBalance2.Product AS Product,
  P_ActualPlanGLAcctBalance2.PlanningCategory AS PlanningCategory,
  P_ActualPlanGLAcctBalance2.GLAccountFlowType AS GLAccountFlowType,
  P_ActualPlanGLAcctBalance2.GLAccountTypeFlowType AS GLAccountTypeFlowType,
  P_ActualPlanGLAcctBalance2.IsBalanceSheetAccount AS IsBalanceSheetAccount,
  P_ActualPlanGLAcctBalance2.GLAccountType AS GLAccountType,
  P_ActualPlanGLAcctBalance2.DebitCreditCode AS DebitCreditCode,
  P_ActualPlanGLAcctBalance2.AccountingDocumentCategory AS AccountingDocumentCategory,
  P_ActualPlanGLAcctBalance2.OrderType AS OrderType,
  P_ActualPlanGLAcctBalance2.AssetClass AS AssetClass,
  P_ActualPlanGLAcctBalance2.FinancialAccountType AS FinancialAccountType,
  P_ActualPlanGLAcctBalance2.SalesOrganization AS SalesOrganization,
  P_ActualPlanGLAcctBalance2.DistributionChannel AS DistributionChannel,
  P_ActualPlanGLAcctBalance2.OrganizationDivision AS OrganizationDivision,
  P_ActualPlanGLAcctBalance2.ServiceDocumentType AS ServiceDocumentType,
  P_ActualPlanGLAcctBalance2.Plant AS Plant,
  P_ActualPlanGLAcctBalance2.ValuationArea AS ValuationArea,
  P_ActualPlanGLAcctBalance2.ServiceDocument AS ServiceDocument,
  P_ActualPlanGLAcctBalance2.SalesDocument AS SalesDocument,
  P_ActualPlanGLAcctBalance2.MasterFixedAsset AS MasterFixedAsset,
  P_ActualPlanGLAcctBalance2.FixedAsset AS FixedAsset,
  P_ActualPlanGLAcctBalance2.AccountingDocumentType AS AccountingDocumentType,
  P_ActualPlanGLAcctBalance2.Customer AS Customer,
  P_ActualPlanGLAcctBalance2.Supplier AS Supplier,
  P_ActualPlanGLAcctBalance2.OrderID AS OrderID,
  I_SemTagGLAccount.GLAccountHierarchy AS GLAccountHierarchy,
  I_SemTagGLAccount.HierarchyNode AS HierarchyNode,
  I_SemTagGLAccount.SemanticTag AS SemanticTag,
  I_SemTagGLAccount.ValidityEndDate AS ValidityEndDate,
  I_SemTagGLAccount.ValidityStartDate AS ValidityStartDate,
  P_ActualPlanGLAcctBalance2.BalanceTransactionCurrency AS BalanceTransactionCurrency,
  P_ActualPlanGLAcctBalance2.AmountInBalanceTransacCrcy AS AmountInBalanceTransacCrcy,
  P_ActualPlanGLAcctBalance2.TransactionCurrency AS TransactionCurrency,
  P_ActualPlanGLAcctBalance2.AmountInTransactionCurrency AS AmountInTransactionCurrency,
  P_ActualPlanGLAcctBalance2.CompanyCodeCurrency AS CompanyCodeCurrency,
  P_ActualPlanGLAcctBalance2.AmountInCompanyCodeCurrency AS AmountInCompanyCodeCurrency,
  cast (0 as fis_hsl) AS HslwoBCF,
  cast (0 as fis_hsl) AS HslonlyBCF,
  P_ActualPlanGLAcctBalance2.GlobalCurrency AS GlobalCurrency,
  P_ActualPlanGLAcctBalance2.AmountInGlobalCurrency AS AmountInGlobalCurrency,
  P_ActualPlanGLAcctBalance2.FixedAmountInGlobalCrcy AS FixedAmountInGlobalCrcy,
  P_ActualPlanGLAcctBalance2.CostSourceUnit AS CostSourceUnit,
  P_ActualPlanGLAcctBalance2.ValuationQuantity AS ValuationQuantity,
  P_ActualPlanGLAcctBalance2.FiscalPeriod AS FiscalPeriod,
  P_ActualPlanGLAcctBalance2.FiscalYearVariant AS FiscalYearVariant,
  P_ActualPlanGLAcctBalance2.FiscalYearPeriod AS FiscalYearPeriod,
  P_ActualPlanGLAcctBalance2.PostingDate AS PostingDate,
  P_ActualPlanGLAcctBalance2.CalendarYear AS CalendarYear,
  P_ActualPlanGLAcctBalance2.CalendarQuarter AS CalendarQuarter,
  P_ActualPlanGLAcctBalance2.CalendarYearQuarter AS CalendarYearQuarter,
  P_ActualPlanGLAcctBalance2.CalendarMonth AS CalendarMonth,
  P_ActualPlanGLAcctBalance2.CalendarYearMonth AS CalendarYearMonth,
  P_ActualPlanGLAcctBalance2.CalendarWeek AS CalendarWeek,
  P_ActualPlanGLAcctBalance2.CalendarYearWeek AS CalendarYearWeek,
  P_ActualPlanGLAcctBalance2.CalendarDate AS CalendarDate,
  P_ActualPlanGLAcctBalance2.FiscalQuarter AS FiscalQuarter,
  P_ActualPlanGLAcctBalance2.FiscalWeek AS FiscalWeek,
  P_ActualPlanGLAcctBalance2.FiscalYearQuarter AS FiscalYearQuarter,
  P_ActualPlanGLAcctBalance2.FiscalYearWeek AS FiscalYearWeek,
  P_ActualPlanGLAcctBalance2._BalanceTransactionCurrency AS _BalanceTransactionCurrency,
  P_ActualPlanGLAcctBalance2._BusinessArea AS _BusinessArea,
  P_ActualPlanGLAcctBalance2._ChartOfAccounts AS _ChartOfAccounts,
  P_ActualPlanGLAcctBalance2._CompanyCode AS _CompanyCode,
  P_ActualPlanGLAcctBalance2._CompanyCodeCurrency AS _CompanyCodeCurrency,
  P_ActualPlanGLAcctBalance2._ControllingArea AS _ControllingArea,
  P_ActualPlanGLAcctBalance2._CostCenter AS _CostCenter,
  P_ActualPlanGLAcctBalance2._CostSourceUnit AS _CostSourceUnit,
  P_ActualPlanGLAcctBalance2._CurrentCostCenter AS _CurrentCostCenter,
  P_ActualPlanGLAcctBalance2._CurrentProfitCenter AS _CurrentProfitCenter,
  P_ActualPlanGLAcctBalance2._DebitCreditCode AS _DebitCreditCode,
  P_ActualPlanGLAcctBalance2._FiscalCalendarDate AS _FiscalCalendarDate,
  P_ActualPlanGLAcctBalance2._FiscalYear AS _FiscalYear,
  P_ActualPlanGLAcctBalance2._FiscalYearVariant AS _FiscalYearVariant,
  P_ActualPlanGLAcctBalance2._FunctionalArea AS _FunctionalArea,
  P_ActualPlanGLAcctBalance2._GLAccountFlowType AS _GLAccountFlowType,
  P_ActualPlanGLAcctBalance2._GLAccountFlowTypeText AS _GLAccountFlowTypeText,
  P_ActualPlanGLAcctBalance2._GLAccountInChartOfAccounts AS _GLAccountInChartOfAccounts,
  P_ActualPlanGLAcctBalance2._GLAccountInCompanyCode AS _GLAccountInCompanyCode,
  P_ActualPlanGLAcctBalance2._GLAccountType AS _GLAccountType,
  P_ActualPlanGLAcctBalance2._GLAccountTypeFlowType AS _GLAccountTypeFlowType,
  P_ActualPlanGLAcctBalance2._GLAccountTypeFlowTypeTxt AS _GLAccountTypeFlowTypeTxt,
  P_ActualPlanGLAcctBalance2._GlobalCurrency AS _GlobalCurrency,
  P_ActualPlanGLAcctBalance2._JournalEntry AS _JournalEntry,
  P_ActualPlanGLAcctBalance2._Ledger AS _Ledger,
  P_ActualPlanGLAcctBalance2._LedgerFiscalYearForVariant AS _LedgerFiscalYearForVariant,
  P_ActualPlanGLAcctBalance2._ProfitCenter AS _ProfitCenter,
  P_ActualPlanGLAcctBalance2._Segment AS _Segment,
  P_ActualPlanGLAcctBalance2._SourceLedger AS _SourceLedger,
  P_ActualPlanGLAcctBalance2._TransactionCurrency AS _TransactionCurrency,
  I_SemTagGLAccount._SemanticTag AS _SemanticTag,
  I_SemTagGLAccount._Hierarchy AS _Hierarchy
FROM P_ActualPlanGLAcctBalance2
INNER JOIN I_SemTagGLAccount ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_FiscalYearPeriodForCmpnyCode AS _FiscalPeriod ON LedgerFiscalYear = _FiscalPeriod.FiscalYear AND FiscalPeriod = _FiscalPeriod.FiscalPeriod AND CompanyCode = _FiscalPeriod.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_FiscalPeriodForVariant AS _FiscalPeriodForVariant ON LedgerFiscalYear = _FiscalPeriodForVariant.FiscalYear AND FiscalPeriod = _FiscalPeriodForVariant.FiscalPeriod AND FiscalYearVariant = _FiscalPeriodForVariant.FiscalYearVariant  -- association [0..1]
LEFT OUTER JOIN I_FiscalCalYearPeriodForCoCode AS _FiscalYearPeriod ON FiscalYearPeriod = _FiscalYearPeriod.FiscalYearPeriod AND CompanyCode = _FiscalYearPeriod.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_FiscalYearPeriodForVariant AS _FiscalYearPeriodForVariant ON FiscalYearPeriod = _FiscalYearPeriodForVariant.FiscalYearPeriod AND FiscalYearVariant = _FiscalYearPeriodForVariant.FiscalYearVariant  -- association [0..1]
LEFT OUTER JOIN I_AccountingDocumentType AS _AccountingDocumentType ON AccountingDocumentType = _AccountingDocumentType.AccountingDocumentType  -- association [0..1]
LEFT OUTER JOIN I_Customer AS _Customer ON Customer = _Customer.Customer  -- association [0..1]
LEFT OUTER JOIN I_Supplier AS _Supplier ON Supplier = _Supplier.Supplier  -- association [0..1]
LEFT OUTER JOIN I_FixedAsset AS _FixedAsset ON CompanyCode = _FixedAsset.CompanyCode AND MasterFixedAsset = _FixedAsset.MasterFixedAsset AND FixedAsset = _FixedAsset.FixedAsset  -- association [0..1]
LEFT OUTER JOIN I_Order AS _Order ON OrderID = _Order.OrderID  -- association [0..1]
LEFT OUTER JOIN I_SalesDocument AS _SalesDocument ON SalesDocument = _SalesDocument.SalesDocument  -- association [0..1]
LEFT OUTER JOIN I_SrvcDocByDocumentType AS _ServiceDocument ON ServiceDocumentType = _ServiceDocument.ServiceDocumentType AND ServiceDocument = _ServiceDocument.ServiceDocument  -- association [0..1]
LEFT OUTER JOIN I_PlanningCategory AS _PlanningCategory ON PlanningCategory = _PlanningCategory.PlanningCategory  -- association [0..1]
;

Depth:

P_ActualPlanGLAcctBalance view_entity

P_ActualPlanGLAcctBalance2 view_entity
I_SemTagGLAccount view

I_GLAccountFlowSemTag view_entity