What is P_GLAcctItemCurrencyRole in SAP S/4HANA?

P_GLAcctItemCurrencyRole is a composite CDS view in SAP S/4HANA. Private View of G/L Account Line Item with Currency Cube It contains 143 fields.

Which tables does P_GLAcctItemCurrencyRole read from?

P_GLAcctItemCurrencyRole reads data from: I_GLAccountItemCurrencyRoleC, I_SemTagGLAccount.

What VDM layer is P_GLAcctItemCurrencyRole?

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

P_GLAcctItemCurrencyRole

DDL: P_GLACCTITEMCURRENCYROLE Type: view_entity COMPOSITE Package: FINS_COPA_REPORTING

143 Fields 2 Data Sources 12 Associations

Private View of G/L Account Line Item with Currency Cube

P_GLAcctItemCurrencyRole is a Composite CDS View that provides data about "Private View of G/L Account Line Item with Currency Cube" in SAP S/4HANA. It reads from 2 data sources (I_GLAccountItemCurrencyRoleC, I_SemTagGLAccount) and exposes 143 fields with key fields Ledger, SourceLedger, CompanyCode, FiscalYear, JournalEntry. It has 12 associations to related views. Part of development package FINS_COPA_REPORTING.

Data Sources (2)

Source	Alias	Join Type
I_GLAccountItemCurrencyRoleC	I_GLAccountItemCurrencyRoleC	from
I_SemTagGLAccount	I_SemTagGLAccount	inner

Associations (12)

Cardinality	Target	Alias	Condition
[0..1]	I_SemanticTag	_SemanticTag	`$projection.SemanticTag = _SemanticTag.SemanticTag`
[0..*]	I_GLAccountHierarchy	_GLHierarchy	`$projection.GLAccountHierarchy = _GLHierarchy.GLAccountHierarchy`
[0..1]	I_ProjectBasicData	_ProjectBasicData	`$projection.ProjectInternalID = _ProjectBasicData.ProjectInternalID`
[0..1]	I_ProjectBasicData	_ProjectBasicDataText	`$projection.ProjectInternalID = _ProjectBasicDataText.ProjectInternalID`
[0..1]	I_WBSElementBasicData	_WBSElementBasicData	`$projection.WBSElementInternalID = _WBSElementBasicData.WBSElementInternalID`
[0..1]	I_WBSElementBasicData	_WBSElementBasicDataText	`$projection.WBSElementInternalID = _WBSElementBasicDataText.WBSElementInternalID`
[0..1]	I_WBSElementByExternalID	_WBSElementExternalID	`$projection.WBSElementExternalID = _WBSElementExternalID.WBSElementExternalID`
[0..1]	I_WBSElementByExternalID	_WBSElementExternalIDText	`$projection.WBSElementExternalID = _WBSElementExternalIDText.WBSElementExternalID`
[0..1]	I_ProjectByExternalID	_ProjectExternalID	`$projection.ProjectExternalID = _ProjectExternalID.ProjectExternalID`
[0..1]	I_ProjectByExternalID	_ProjectExternalIDText	`$projection.ProjectExternalID = _ProjectExternalIDText.ProjectExternalID`
[0..1]	I_ProfitCenter	_CurrentProfitCenter	`$projection.ControllingArea = _CurrentProfitCenter.ControllingArea and $projection.ProfitCenter = _CurrentProfitCenter.ProfitCenter`
[0..1]	I_CostCenter	_CurrentCostCenter	`$projection.ControllingArea = _CurrentCostCenter.ControllingArea and $projection.CostCenter = _CurrentCostCenter.CostCenter and _CurrentCostCenter.ValidityStartDate <= $session.system_date and _CurrentCostCenter.ValidityEndDate >= $session.system_date`

Annotations (5)

Name	Value	Level
VDM.viewType	#COMPOSITE	view
AccessControl.authorizationCheck	#NOT_REQUIRED	view
ObjectModel.representativeKey	LedgerGLLineItem	view
VDM.private	true	view
EndUserText.label	Private View of G/L Account Line Item with Currency Cube	view

Fields (143)

Key	Field	Source Table	Source Field	Description
KEY	Ledger	I_GLAccountItemCurrencyRoleC	Ledger	Ledger
KEY	SourceLedger	I_GLAccountItemCurrencyRoleC	SourceLedger	Source Ledger
KEY	CompanyCode	I_GLAccountItemCurrencyRoleC	CompanyCode	Receiver Company Code
KEY	FiscalYear	I_GLAccountItemCurrencyRoleC	FiscalYear	G/L Fiscal Year
KEY	JournalEntry	I_GLAccountItemCurrencyRoleC	JournalEntry	Journal Entry
KEY	LedgerGLLineItem	I_GLAccountItemCurrencyRoleC	LedgerGLLineItem	Journal Entry Item
KEY	CurrencyRole	I_GLAccountItemCurrencyRoleC	CurrencyRole	Curr./Val. Type
	FiscalPeriod	I_GLAccountItemCurrencyRoleC	FiscalPeriod	Tax period
	GLAccount	I_GLAccountItemCurrencyRoleC	GLAccount	General Ledger
	GLAccountHierarchy	I_SemTagGLAccount	GLAccountHierarchy
	SemanticTag	I_SemTagGLAccount	SemanticTag	Semantic Tag
	CostCenter	I_GLAccountItemCurrencyRoleC	CostCenter	Cost Center
	ProfitCenter	I_GLAccountItemCurrencyRoleC	ProfitCenter	Profit Center
	FunctionalArea	I_GLAccountItemCurrencyRoleC	FunctionalArea	Sendr Fctl Area
	BusinessArea	I_GLAccountItemCurrencyRoleC	BusinessArea	Business Area
	Segment	I_GLAccountItemCurrencyRoleC	Segment	Segment number
	ChartOfAccounts	I_GLAccountItemCurrencyRoleC	ChartOfAccounts	Node Class
	SalesOrganization	I_GLAccountItemCurrencyRoleC	SalesOrganization	Sales Organization
	ControllingArea	I_GLAccountItemCurrencyRoleC	ControllingArea	Controlling Area
	SubLedgerAcctLineItemType	I_GLAccountItemCurrencyRoleC	SubLedgerAcctLineItemType	SLALineItemType
	DistributionChannel	I_GLAccountItemCurrencyRoleC	DistributionChannel	RefDistCh-Cust/Mat.
	OrganizationDivision	I_GLAccountItemCurrencyRoleC	OrganizationDivision	Org. Division
	WBSElementInternalID	I_GLAccountItemCurrencyRoleC	WBSElementInternalID	WBS Internal ID
	WBSElementExternalID	_WBSElementBasicData	WBSElementExternalID	WBS Element External ID
	ProjectInternalID	I_GLAccountItemCurrencyRoleC	ProjectInternalID	Project Def.
	ProjectExternalID	_ProjectBasicData	ProjectExternalID	Project def.
	ProjectNetwork	I_GLAccountItemCurrencyRoleC	ProjectNetwork	Order
	CurrencyField	I_GLAccountItemCurrencyRoleC	CurrencyField
	CurrencyRoleCurrency	I_GLAccountItemCurrencyRoleC	CurrencyRoleCurrency
	AmountInCurrencyRoleCurrency	I_GLAccountItemCurrencyRoleC	AmountInCurrencyRoleCurrency
	BalanceTransactionCurrency	I_GLAccountItemCurrencyRoleC	BalanceTransactionCurrency	Currency
	AmountInBalanceTransacCrcy	I_GLAccountItemCurrencyRoleC	AmountInBalanceTransacCrcy	Amount in Balance Transaction Currency
	TransactionCurrency	I_GLAccountItemCurrencyRoleC	TransactionCurrency	Transaction Currency
	AmountInTransactionCurrency	I_GLAccountItemCurrencyRoleC	AmountInTransactionCurrency	Pt Crcy Amt
	CompanyCodeCurrency	I_GLAccountItemCurrencyRoleC	CompanyCodeCurrency	Local Currency
	AmountInCompanyCodeCurrency	I_GLAccountItemCurrencyRoleC	AmountInCompanyCodeCurrency	Local Crcy Amt
	GlobalCurrency	I_GLAccountItemCurrencyRoleC	GlobalCurrency	GM Billing Element: Global Currency
	AmountInGlobalCurrency	I_GLAccountItemCurrencyRoleC	AmountInGlobalCurrency	Amount in Global Currency
	FunctionalCurrency	I_GLAccountItemCurrencyRoleC	FunctionalCurrency	Functional Currency
	AmountInFunctionalCurrency	I_GLAccountItemCurrencyRoleC	AmountInFunctionalCurrency	Amount in Functional Currency
	FreeDefinedCurrency1	I_GLAccountItemCurrencyRoleC	FreeDefinedCurrency1	Freely Defined Currency 1
	AmountInFreeDefinedCurrency1	I_GLAccountItemCurrencyRoleC	AmountInFreeDefinedCurrency1	Amount in Freely Defined Currency 1
	FreeDefinedCurrency2	I_GLAccountItemCurrencyRoleC	FreeDefinedCurrency2	Freely Defined Currency 2
	AmountInFreeDefinedCurrency2	I_GLAccountItemCurrencyRoleC	AmountInFreeDefinedCurrency2	Amount in Freely Defined Currency 2
	FreeDefinedCurrency3	I_GLAccountItemCurrencyRoleC	FreeDefinedCurrency3	Freely Defined Currency 3
	AmountInFreeDefinedCurrency3	I_GLAccountItemCurrencyRoleC	AmountInFreeDefinedCurrency3	Amount in Freely Defined Currency 3
	FreeDefinedCurrency4	I_GLAccountItemCurrencyRoleC	FreeDefinedCurrency4	Freely Defined Currency 4
	AmountInFreeDefinedCurrency4	I_GLAccountItemCurrencyRoleC	AmountInFreeDefinedCurrency4	Amount in Freely Defined Currency 4
	FreeDefinedCurrency5	I_GLAccountItemCurrencyRoleC	FreeDefinedCurrency5	Freely Defined Currency 5
	AmountInFreeDefinedCurrency5	I_GLAccountItemCurrencyRoleC	AmountInFreeDefinedCurrency5	Amount in Freely Defined Currency 5
	FreeDefinedCurrency6	I_GLAccountItemCurrencyRoleC	FreeDefinedCurrency6	Freely Defined Currency 6
	AmountInFreeDefinedCurrency6	I_GLAccountItemCurrencyRoleC	AmountInFreeDefinedCurrency6	Amount in Freely Defined Currency 6
	FreeDefinedCurrency7	I_GLAccountItemCurrencyRoleC	FreeDefinedCurrency7	Freely Defined Currency 7
	AmountInFreeDefinedCurrency7	I_GLAccountItemCurrencyRoleC	AmountInFreeDefinedCurrency7	Amount in Freely Defined Currency 7
	FreeDefinedCurrency8	I_GLAccountItemCurrencyRoleC	FreeDefinedCurrency8	Freely Defined Currency 8
	AmountInFreeDefinedCurrency8	I_GLAccountItemCurrencyRoleC	AmountInFreeDefinedCurrency8	Amount in Freely Defined Currency 8
	FixedAmountInGlobalCrcy	I_GLAccountItemCurrencyRoleC	FixedAmountInGlobalCrcy
	FixedAmountInCoCodeCrcy	I_GLAccountItemCurrencyRoleC	FixedAmountInCoCodeCrcy
	FixedAmountInTransCrcy	I_GLAccountItemCurrencyRoleC	FixedAmountInTransCrcy
	BaseUnit	I_GLAccountItemCurrencyRoleC	BaseUnit	Unit of Measure
	Quantity	I_GLAccountItemCurrencyRoleC	Quantity	Value
	FixedQuantity	I_GLAccountItemCurrencyRoleC	FixedQuantity	Fixed Quantity
	CostSourceUnit	I_GLAccountItemCurrencyRoleC	CostSourceUnit
	ValuationQuantity	I_GLAccountItemCurrencyRoleC	ValuationQuantity
	SalesDocument	I_GLAccountItemCurrencyRoleC	SalesDocument	SD Document
	SalesDocumentItem	I_GLAccountItemCurrencyRoleC	SalesDocumentItem	Sales Document Item
	Plant	I_GLAccountItemCurrencyRoleC	Plant	Valuation Area
	Supplier	I_GLAccountItemCurrencyRoleC	Supplier	Supplier
	Customer	I_GLAccountItemCurrencyRoleC	Customer	Sold-to Party
	AccountAssignment	I_GLAccountItemCurrencyRoleC	AccountAssignment	Sender Acct Assgmt
	AccountAssignmentType	I_GLAccountItemCurrencyRoleC	AccountAssignmentType	Sndr AcctAssgmt Type
	OrderID	I_GLAccountItemCurrencyRoleC	OrderID	Order ID
	OrderCategory	I_GLAccountItemCurrencyRoleC	OrderCategory	Order Category
	SoldProduct	I_GLAccountItemCurrencyRoleC	SoldProduct	Product Sold
	SoldProductGroup	I_GLAccountItemCurrencyRoleC	SoldProductGroup	Product Sold Group
	CustomerGroup	I_GLAccountItemCurrencyRoleC	CustomerGroup	Customer Group
	CustomerSupplierCountry	I_GLAccountItemCurrencyRoleC	CustomerSupplierCountry	Customer or Supplier Country/Region
	CustomerSupplierIndustry	I_GLAccountItemCurrencyRoleC	CustomerSupplierIndustry	Industry
	SalesDistrict	I_GLAccountItemCurrencyRoleC	SalesDistrict	Sales District
	ShipToParty	I_GLAccountItemCurrencyRoleC	ShipToParty	Ship-To Party (obsolete)
	BillToParty	I_GLAccountItemCurrencyRoleC	BillToParty	Inv. Recipient
	FinancialAccountType	I_GLAccountItemCurrencyRoleC	FinancialAccountType	Fin. Account Type
	ValuationArea	I_GLAccountItemCurrencyRoleC	ValuationArea	Valuation Area
	AssetClass	I_GLAccountItemCurrencyRoleC	AssetClass	Asset Class
	PostingDate	I_GLAccountItemCurrencyRoleC	PostingDate	Posting Date for GR
	AccountingDocumentType	I_GLAccountItemCurrencyRoleC	AccountingDocumentType	Journal Entry Type
	ServiceDocumentType	I_GLAccountItemCurrencyRoleC	ServiceDocumentType	Transaction Type
	ServiceDocument	I_GLAccountItemCurrencyRoleC	ServiceDocument	Transaction ID
	_ServiceDocument	I_GLAccountItemCurrencyRoleC	_ServiceDocument
	_AccountingDocumentType	I_GLAccountItemCurrencyRoleC	_AccountingDocumentType
	_CurrentProfitCenter		_CurrentProfitCenter
	_CurrentCostCenter		_CurrentCostCenter
	_Ledger	I_GLAccountItemCurrencyRoleC	_Ledger
	_SourceLedger	I_GLAccountItemCurrencyRoleC	_SourceLedger
	_JournalEntry	I_GLAccountItemCurrencyRoleC	_JournalEntry
	_CompanyCode	I_GLAccountItemCurrencyRoleC	_CompanyCode
	_CurrencyRole	I_GLAccountItemCurrencyRoleC	_CurrencyRole
	_GLHierarchy		_GLHierarchy
	_SemanticTag		_SemanticTag
	_FiscalYear	I_GLAccountItemCurrencyRoleC	_FiscalYear
	_ControllingArea	I_GLAccountItemCurrencyRoleC	_ControllingArea
	_Customer	I_GLAccountItemCurrencyRoleC	_Customer
	_CustomerGroup	I_GLAccountItemCurrencyRoleC	_CustomerGroup
	_SoldProduct	I_GLAccountItemCurrencyRoleC	_SoldProduct
	_SoldProductGroup	I_GLAccountItemCurrencyRoleC	_SoldProductGroup
	_CostCenter	I_GLAccountItemCurrencyRoleC	_CostCenter
	_ProfitCenter	I_GLAccountItemCurrencyRoleC	_ProfitCenter
	_CostSourceUnit	I_GLAccountItemCurrencyRoleC	_CostSourceUnit
	_SalesDocument	I_GLAccountItemCurrencyRoleC	_SalesDocument
	_Order	I_GLAccountItemCurrencyRoleC	_Order
	_DistributionChannel	I_GLAccountItemCurrencyRoleC	_DistributionChannel
	_BaseUnit	I_GLAccountItemCurrencyRoleC	_BaseUnit
	_Segment	I_GLAccountItemCurrencyRoleC	_Segment
	_BusinessArea	I_GLAccountItemCurrencyRoleC	_BusinessArea
	_ChartOfAccounts	I_GLAccountItemCurrencyRoleC	_ChartOfAccounts
	_GLAccountInChartOfAccounts	I_GLAccountItemCurrencyRoleC	_GLAccountInChartOfAccounts
	_WBSElementBasicData		_WBSElementBasicData
	_WBSElementExternalID		_WBSElementExternalID
	_ProjectBasicData		_ProjectBasicData
	_ProjectExternalID		_ProjectExternalID
	_BalanceTransactionCurrency	I_GLAccountItemCurrencyRoleC	_BalanceTransactionCurrency
	_TransactionCurrency	I_GLAccountItemCurrencyRoleC	_TransactionCurrency
	_CompanyCodeCurrency	I_GLAccountItemCurrencyRoleC	_CompanyCodeCurrency
	_GlobalCurrency	I_GLAccountItemCurrencyRoleC	_GlobalCurrency
	_FunctionalCurrency	I_GLAccountItemCurrencyRoleC	_FunctionalCurrency
	_FreeDefinedCurrency1	I_GLAccountItemCurrencyRoleC	_FreeDefinedCurrency1
	_FreeDefinedCurrency2	I_GLAccountItemCurrencyRoleC	_FreeDefinedCurrency2
	_FreeDefinedCurrency3	I_GLAccountItemCurrencyRoleC	_FreeDefinedCurrency3
	_FreeDefinedCurrency4	I_GLAccountItemCurrencyRoleC	_FreeDefinedCurrency4
	_FreeDefinedCurrency5	I_GLAccountItemCurrencyRoleC	_FreeDefinedCurrency5
	_FreeDefinedCurrency6	I_GLAccountItemCurrencyRoleC	_FreeDefinedCurrency6
	_FreeDefinedCurrency7	I_GLAccountItemCurrencyRoleC	_FreeDefinedCurrency7
	_FreeDefinedCurrency8	I_GLAccountItemCurrencyRoleC	_FreeDefinedCurrency8
	_FunctionalArea	I_GLAccountItemCurrencyRoleC	_FunctionalArea
	_Plant	I_GLAccountItemCurrencyRoleC	_Plant
	_Supplier	I_GLAccountItemCurrencyRoleC	_Supplier
	_SalesOrganization	I_GLAccountItemCurrencyRoleC	_SalesOrganization
	_SalesDistrict	I_GLAccountItemCurrencyRoleC	_SalesDistrict
	_CustomerSupplierCountry	I_GLAccountItemCurrencyRoleC	_CustomerSupplierCountry
	_ShipToParty	I_GLAccountItemCurrencyRoleC	_ShipToParty
	_BillToParty	I_GLAccountItemCurrencyRoleC	_BillToParty
	_FinancialAccountType	I_GLAccountItemCurrencyRoleC	_FinancialAccountType
	_AccountAssignmentType	I_GLAccountItemCurrencyRoleC	_AccountAssignmentType

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_GLAcctItemCurrencyRole.
-- 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_GLAcctItemCurrencyRole AS
SELECT
  I_GLAccountItemCurrencyRoleC.Ledger AS Ledger,
  I_GLAccountItemCurrencyRoleC.SourceLedger AS SourceLedger,
  I_GLAccountItemCurrencyRoleC.CompanyCode AS CompanyCode,
  I_GLAccountItemCurrencyRoleC.FiscalYear AS FiscalYear,
  I_GLAccountItemCurrencyRoleC.JournalEntry AS JournalEntry,
  I_GLAccountItemCurrencyRoleC.LedgerGLLineItem AS LedgerGLLineItem,
  I_GLAccountItemCurrencyRoleC.CurrencyRole AS CurrencyRole,
  I_GLAccountItemCurrencyRoleC.FiscalPeriod AS FiscalPeriod,
  I_GLAccountItemCurrencyRoleC.GLAccount AS GLAccount,
  I_SemTagGLAccount.GLAccountHierarchy AS GLAccountHierarchy,
  I_SemTagGLAccount.SemanticTag AS SemanticTag,
  I_GLAccountItemCurrencyRoleC.CostCenter AS CostCenter,
  I_GLAccountItemCurrencyRoleC.ProfitCenter AS ProfitCenter,
  I_GLAccountItemCurrencyRoleC.FunctionalArea AS FunctionalArea,
  I_GLAccountItemCurrencyRoleC.BusinessArea AS BusinessArea,
  I_GLAccountItemCurrencyRoleC.Segment AS Segment,
  I_GLAccountItemCurrencyRoleC.ChartOfAccounts AS ChartOfAccounts,
  I_GLAccountItemCurrencyRoleC.SalesOrganization AS SalesOrganization,
  I_GLAccountItemCurrencyRoleC.ControllingArea AS ControllingArea,
  I_GLAccountItemCurrencyRoleC.SubLedgerAcctLineItemType AS SubLedgerAcctLineItemType,
  I_GLAccountItemCurrencyRoleC.DistributionChannel AS DistributionChannel,
  I_GLAccountItemCurrencyRoleC.OrganizationDivision AS OrganizationDivision,
  I_GLAccountItemCurrencyRoleC.WBSElementInternalID AS WBSElementInternalID,
  _WBSElementBasicData.WBSElementExternalID AS WBSElementExternalID,
  I_GLAccountItemCurrencyRoleC.ProjectInternalID AS ProjectInternalID,
  _ProjectBasicData.ProjectExternalID AS ProjectExternalID,
  I_GLAccountItemCurrencyRoleC.ProjectNetwork AS ProjectNetwork,
  I_GLAccountItemCurrencyRoleC.CurrencyField AS CurrencyField,
  I_GLAccountItemCurrencyRoleC.CurrencyRoleCurrency AS CurrencyRoleCurrency,
  I_GLAccountItemCurrencyRoleC.AmountInCurrencyRoleCurrency AS AmountInCurrencyRoleCurrency,
  I_GLAccountItemCurrencyRoleC.BalanceTransactionCurrency AS BalanceTransactionCurrency,
  I_GLAccountItemCurrencyRoleC.AmountInBalanceTransacCrcy AS AmountInBalanceTransacCrcy,
  I_GLAccountItemCurrencyRoleC.TransactionCurrency AS TransactionCurrency,
  I_GLAccountItemCurrencyRoleC.AmountInTransactionCurrency AS AmountInTransactionCurrency,
  I_GLAccountItemCurrencyRoleC.CompanyCodeCurrency AS CompanyCodeCurrency,
  I_GLAccountItemCurrencyRoleC.AmountInCompanyCodeCurrency AS AmountInCompanyCodeCurrency,
  I_GLAccountItemCurrencyRoleC.GlobalCurrency AS GlobalCurrency,
  I_GLAccountItemCurrencyRoleC.AmountInGlobalCurrency AS AmountInGlobalCurrency,
  I_GLAccountItemCurrencyRoleC.FunctionalCurrency AS FunctionalCurrency,
  I_GLAccountItemCurrencyRoleC.AmountInFunctionalCurrency AS AmountInFunctionalCurrency,
  I_GLAccountItemCurrencyRoleC.FreeDefinedCurrency1 AS FreeDefinedCurrency1,
  I_GLAccountItemCurrencyRoleC.AmountInFreeDefinedCurrency1 AS AmountInFreeDefinedCurrency1,
  I_GLAccountItemCurrencyRoleC.FreeDefinedCurrency2 AS FreeDefinedCurrency2,
  I_GLAccountItemCurrencyRoleC.AmountInFreeDefinedCurrency2 AS AmountInFreeDefinedCurrency2,
  I_GLAccountItemCurrencyRoleC.FreeDefinedCurrency3 AS FreeDefinedCurrency3,
  I_GLAccountItemCurrencyRoleC.AmountInFreeDefinedCurrency3 AS AmountInFreeDefinedCurrency3,
  I_GLAccountItemCurrencyRoleC.FreeDefinedCurrency4 AS FreeDefinedCurrency4,
  I_GLAccountItemCurrencyRoleC.AmountInFreeDefinedCurrency4 AS AmountInFreeDefinedCurrency4,
  I_GLAccountItemCurrencyRoleC.FreeDefinedCurrency5 AS FreeDefinedCurrency5,
  I_GLAccountItemCurrencyRoleC.AmountInFreeDefinedCurrency5 AS AmountInFreeDefinedCurrency5,
  I_GLAccountItemCurrencyRoleC.FreeDefinedCurrency6 AS FreeDefinedCurrency6,
  I_GLAccountItemCurrencyRoleC.AmountInFreeDefinedCurrency6 AS AmountInFreeDefinedCurrency6,
  I_GLAccountItemCurrencyRoleC.FreeDefinedCurrency7 AS FreeDefinedCurrency7,
  I_GLAccountItemCurrencyRoleC.AmountInFreeDefinedCurrency7 AS AmountInFreeDefinedCurrency7,
  I_GLAccountItemCurrencyRoleC.FreeDefinedCurrency8 AS FreeDefinedCurrency8,
  I_GLAccountItemCurrencyRoleC.AmountInFreeDefinedCurrency8 AS AmountInFreeDefinedCurrency8,
  I_GLAccountItemCurrencyRoleC.FixedAmountInGlobalCrcy AS FixedAmountInGlobalCrcy,
  I_GLAccountItemCurrencyRoleC.FixedAmountInCoCodeCrcy AS FixedAmountInCoCodeCrcy,
  I_GLAccountItemCurrencyRoleC.FixedAmountInTransCrcy AS FixedAmountInTransCrcy,
  I_GLAccountItemCurrencyRoleC.BaseUnit AS BaseUnit,
  I_GLAccountItemCurrencyRoleC.Quantity AS Quantity,
  I_GLAccountItemCurrencyRoleC.FixedQuantity AS FixedQuantity,
  I_GLAccountItemCurrencyRoleC.CostSourceUnit AS CostSourceUnit,
  I_GLAccountItemCurrencyRoleC.ValuationQuantity AS ValuationQuantity,
  I_GLAccountItemCurrencyRoleC.SalesDocument AS SalesDocument,
  I_GLAccountItemCurrencyRoleC.SalesDocumentItem AS SalesDocumentItem,
  I_GLAccountItemCurrencyRoleC.Plant AS Plant,
  I_GLAccountItemCurrencyRoleC.Supplier AS Supplier,
  I_GLAccountItemCurrencyRoleC.Customer AS Customer,
  I_GLAccountItemCurrencyRoleC.AccountAssignment AS AccountAssignment,
  I_GLAccountItemCurrencyRoleC.AccountAssignmentType AS AccountAssignmentType,
  I_GLAccountItemCurrencyRoleC.OrderID AS OrderID,
  I_GLAccountItemCurrencyRoleC.OrderCategory AS OrderCategory,
  I_GLAccountItemCurrencyRoleC.SoldProduct AS SoldProduct,
  I_GLAccountItemCurrencyRoleC.SoldProductGroup AS SoldProductGroup,
  I_GLAccountItemCurrencyRoleC.CustomerGroup AS CustomerGroup,
  I_GLAccountItemCurrencyRoleC.CustomerSupplierCountry AS CustomerSupplierCountry,
  I_GLAccountItemCurrencyRoleC.CustomerSupplierIndustry AS CustomerSupplierIndustry,
  I_GLAccountItemCurrencyRoleC.SalesDistrict AS SalesDistrict,
  I_GLAccountItemCurrencyRoleC.ShipToParty AS ShipToParty,
  I_GLAccountItemCurrencyRoleC.BillToParty AS BillToParty,
  I_GLAccountItemCurrencyRoleC.FinancialAccountType AS FinancialAccountType,
  I_GLAccountItemCurrencyRoleC.ValuationArea AS ValuationArea,
  I_GLAccountItemCurrencyRoleC.AssetClass AS AssetClass,
  I_GLAccountItemCurrencyRoleC.PostingDate AS PostingDate,
  I_GLAccountItemCurrencyRoleC.AccountingDocumentType AS AccountingDocumentType,
  I_GLAccountItemCurrencyRoleC.ServiceDocumentType AS ServiceDocumentType,
  I_GLAccountItemCurrencyRoleC.ServiceDocument AS ServiceDocument,
  I_GLAccountItemCurrencyRoleC._ServiceDocument AS _ServiceDocument,
  I_GLAccountItemCurrencyRoleC._AccountingDocumentType AS _AccountingDocumentType,
  I_GLAccountItemCurrencyRoleC._Ledger AS _Ledger,
  I_GLAccountItemCurrencyRoleC._SourceLedger AS _SourceLedger,
  I_GLAccountItemCurrencyRoleC._JournalEntry AS _JournalEntry,
  I_GLAccountItemCurrencyRoleC._CompanyCode AS _CompanyCode,
  I_GLAccountItemCurrencyRoleC._CurrencyRole AS _CurrencyRole,
  I_GLAccountItemCurrencyRoleC._FiscalYear AS _FiscalYear,
  I_GLAccountItemCurrencyRoleC._ControllingArea AS _ControllingArea,
  I_GLAccountItemCurrencyRoleC._Customer AS _Customer,
  I_GLAccountItemCurrencyRoleC._CustomerGroup AS _CustomerGroup,
  I_GLAccountItemCurrencyRoleC._SoldProduct AS _SoldProduct,
  I_GLAccountItemCurrencyRoleC._SoldProductGroup AS _SoldProductGroup,
  I_GLAccountItemCurrencyRoleC._CostCenter AS _CostCenter,
  I_GLAccountItemCurrencyRoleC._ProfitCenter AS _ProfitCenter,
  I_GLAccountItemCurrencyRoleC._CostSourceUnit AS _CostSourceUnit,
  I_GLAccountItemCurrencyRoleC._SalesDocument AS _SalesDocument,
  I_GLAccountItemCurrencyRoleC._Order AS _Order,
  I_GLAccountItemCurrencyRoleC._DistributionChannel AS _DistributionChannel,
  I_GLAccountItemCurrencyRoleC._BaseUnit AS _BaseUnit,
  I_GLAccountItemCurrencyRoleC._Segment AS _Segment,
  I_GLAccountItemCurrencyRoleC._BusinessArea AS _BusinessArea,
  I_GLAccountItemCurrencyRoleC._ChartOfAccounts AS _ChartOfAccounts,
  I_GLAccountItemCurrencyRoleC._GLAccountInChartOfAccounts AS _GLAccountInChartOfAccounts,
  I_GLAccountItemCurrencyRoleC._BalanceTransactionCurrency AS _BalanceTransactionCurrency,
  I_GLAccountItemCurrencyRoleC._TransactionCurrency AS _TransactionCurrency,
  I_GLAccountItemCurrencyRoleC._CompanyCodeCurrency AS _CompanyCodeCurrency,
  I_GLAccountItemCurrencyRoleC._GlobalCurrency AS _GlobalCurrency,
  I_GLAccountItemCurrencyRoleC._FunctionalCurrency AS _FunctionalCurrency,
  I_GLAccountItemCurrencyRoleC._FreeDefinedCurrency1 AS _FreeDefinedCurrency1,
  I_GLAccountItemCurrencyRoleC._FreeDefinedCurrency2 AS _FreeDefinedCurrency2,
  I_GLAccountItemCurrencyRoleC._FreeDefinedCurrency3 AS _FreeDefinedCurrency3,
  I_GLAccountItemCurrencyRoleC._FreeDefinedCurrency4 AS _FreeDefinedCurrency4,
  I_GLAccountItemCurrencyRoleC._FreeDefinedCurrency5 AS _FreeDefinedCurrency5,
  I_GLAccountItemCurrencyRoleC._FreeDefinedCurrency6 AS _FreeDefinedCurrency6,
  I_GLAccountItemCurrencyRoleC._FreeDefinedCurrency7 AS _FreeDefinedCurrency7,
  I_GLAccountItemCurrencyRoleC._FreeDefinedCurrency8 AS _FreeDefinedCurrency8,
  I_GLAccountItemCurrencyRoleC._FunctionalArea AS _FunctionalArea,
  I_GLAccountItemCurrencyRoleC._Plant AS _Plant,
  I_GLAccountItemCurrencyRoleC._Supplier AS _Supplier,
  I_GLAccountItemCurrencyRoleC._SalesOrganization AS _SalesOrganization,
  I_GLAccountItemCurrencyRoleC._SalesDistrict AS _SalesDistrict,
  I_GLAccountItemCurrencyRoleC._CustomerSupplierCountry AS _CustomerSupplierCountry,
  I_GLAccountItemCurrencyRoleC._ShipToParty AS _ShipToParty,
  I_GLAccountItemCurrencyRoleC._BillToParty AS _BillToParty,
  I_GLAccountItemCurrencyRoleC._FinancialAccountType AS _FinancialAccountType,
  I_GLAccountItemCurrencyRoleC._AccountAssignmentType AS _AccountAssignmentType
FROM I_GLAccountItemCurrencyRoleC
INNER JOIN I_SemTagGLAccount ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_SemanticTag AS _SemanticTag ON SemanticTag = _SemanticTag.SemanticTag  -- association [0..1]
LEFT OUTER JOIN I_GLAccountHierarchy AS _GLHierarchy ON GLAccountHierarchy = _GLHierarchy.GLAccountHierarchy  -- association [0..*]
LEFT OUTER JOIN I_ProjectBasicData AS _ProjectBasicData ON ProjectInternalID = _ProjectBasicData.ProjectInternalID  -- association [0..1]
LEFT OUTER JOIN I_ProjectBasicData AS _ProjectBasicDataText ON ProjectInternalID = _ProjectBasicDataText.ProjectInternalID  -- association [0..1]
LEFT OUTER JOIN I_WBSElementBasicData AS _WBSElementBasicData ON WBSElementInternalID = _WBSElementBasicData.WBSElementInternalID  -- association [0..1]
LEFT OUTER JOIN I_WBSElementBasicData AS _WBSElementBasicDataText ON WBSElementInternalID = _WBSElementBasicDataText.WBSElementInternalID  -- association [0..1]
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_ProjectByExternalID AS _ProjectExternalID ON ProjectExternalID = _ProjectExternalID.ProjectExternalID  -- association [0..1]
LEFT OUTER JOIN I_ProjectByExternalID AS _ProjectExternalIDText ON ProjectExternalID = _ProjectExternalIDText.ProjectExternalID  -- association [0..1]
LEFT OUTER JOIN I_ProfitCenter AS _CurrentProfitCenter ON ControllingArea = _CurrentProfitCenter.ControllingArea AND ProfitCenter = _CurrentProfitCenter.ProfitCenter  -- association [0..1]
LEFT OUTER JOIN I_CostCenter AS _CurrentCostCenter ON ControllingArea = _CurrentCostCenter.ControllingArea AND CostCenter = _CurrentCostCenter.CostCenter AND _CurrentCostCenter.ValidityStartDate <= $session.system_date AND _CurrentCostCenter.ValidityEndDate >= $session.system_date  -- association [0..1]
;

Depth:

P_GLAcctItemCurrencyRole view_entity

I_GLAccountItemCurrencyRoleC view_entity
I_SemTagGLAccount view