P_GLAcctBalbyPeriod01

DDL: P_GLACCTBALBYPERIOD01 Type: view_entity COMPOSITE
205 Fields 5 Data Sources

P_GLAcctBalbyPeriod01 is a Composite CDS View in SAP S/4HANA. It reads from 5 data sources (I_GLAccountLineItem, I_GLAccountLineItem, I_LedgerCompanyCodeCrcyRoles, I_LedgerCompanyCodeCrcyRoles, I_LedgerCompanyCodeCrcyRoles) and exposes 205 fields with key fields Ledger, CompanyCode, FiscalYear, AccountingDocument, LedgerGLLineItem.

Data Sources (5)

SourceAliasJoin Type
I_GLAccountLineItem GLAccountLineItem from
I_GLAccountLineItem GLAccountLineItem union_all
I_LedgerCompanyCodeCrcyRoles LedgerCompanyCodeCrcyRole inner
I_LedgerCompanyCodeCrcyRoles LedgerCompanyCodeCrcyRole inner
I_LedgerCompanyCodeCrcyRoles LedgerCompanyCodeCrcyRole inner

Parameters (4)

NameTypeDefault
P_Ledger fis_rldnr
P_FiscalYear fins_gjahr
P_StartFiscalPeriod fins_fiscalperiod
P_EndFiscalPeriod fins_fiscalperiod

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #MIXED view
VDM.private true view
VDM.viewType #COMPOSITE view

Fields (205)

KeyFieldSource TableSource FieldDescription
KEY Ledger I_GLAccountLineItem Ledger 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 Journal Entry Item
LedgerFiscalYear I_GLAccountLineItem LedgerFiscalYear
ChartOfAccounts I_GLAccountLineItem ChartOfAccounts Node Class
AccountingDocumentType I_GLAccountLineItem AccountingDocumentType Journal Entry Type
GLAccount I_GLAccountLineItem GLAccount General Ledger
CountryChartOfAccounts I_GLAccountLineItem CountryChartOfAccounts Chart of Accts
AlternativeGLAccount I_GLAccountLineItem AlternativeGLAccount Group Account
ControllingArea I_GLAccountLineItem ControllingArea Controlling Area
CostCenter I_GLAccountLineItem CostCenter Cost Center
ProfitCenter I_GLAccountLineItem ProfitCenter Profit Center
FinancialTransactionType I_GLAccountLineItem FinancialTransactionType Transact. Type
FunctionalArea I_GLAccountLineItem FunctionalArea Sendr Fctl Area
BusinessArea I_GLAccountLineItem BusinessArea Business Area
Segment I_GLAccountLineItem Segment Segment number
DebitCreditCode I_GLAccountLineItem DebitCreditCode Single-Character Flag
PostingDate I_GLAccountLineItem PostingDate Posting Date for GR
FiscalPeriod I_GLAccountLineItem FiscalPeriod Tax period
PartnerCompany I_GLAccountLineItem PartnerCompany Trading Partner
WBSElement I_GLAccountLineItem WBSElement WBS Internal ID
GLAccountType I_GLAccountLineItem GLAccountType G/L Account Type
CompanyCodeCurrencyRole I_LedgerCompanyCodeCrcyRoles CompanyCodeCurrencyRole
GlobalCurrencyRole I_LedgerCompanyCodeCrcyRoles GlobalCurrencyRole
FreeDefinedCurrency1Role I_LedgerCompanyCodeCrcyRoles FreeDefinedCurrency1Role
FreeDefinedCurrency2Role I_LedgerCompanyCodeCrcyRoles FreeDefinedCurrency2Role
FreeDefinedCurrency3Role I_LedgerCompanyCodeCrcyRoles FreeDefinedCurrency3Role
FreeDefinedCurrency4Role I_LedgerCompanyCodeCrcyRoles FreeDefinedCurrency4Role
FreeDefinedCurrency5Role I_LedgerCompanyCodeCrcyRoles FreeDefinedCurrency5Role
FreeDefinedCurrency6Role I_LedgerCompanyCodeCrcyRoles FreeDefinedCurrency6Role
FreeDefinedCurrency7Role I_LedgerCompanyCodeCrcyRoles FreeDefinedCurrency7Role
FreeDefinedCurrency8Role I_LedgerCompanyCodeCrcyRoles FreeDefinedCurrency8Role
FunctionalCurrencyRole I_LedgerCompanyCodeCrcyRoles FunctionalCurrencyRole
CompanyCodeCurrency I_GLAccountLineItem CompanyCodeCurrency Local Currency
DebitAmtInCoCodeCrcy I_GLAccountLineItem DebitAmountInCoCodeCrcy Debit Amount in Company Code Currency
CreditAmtInCoCodeCrcy I_GLAccountLineItem CreditAmountInCoCodeCrcy Credit Amount in Company Code Currency
GlobalCurrency I_GLAccountLineItem GlobalCurrency GM Billing Element: Global Currency
DebitAmtInGlobalCrcy I_GLAccountLineItem DebitAmountInGlobalCrcy
CreditAmtInGlobalCrcy I_GLAccountLineItem CreditAmountInGlobalCrcy
FreeDefinedCurrency1 I_GLAccountLineItem FreeDefinedCurrency1 Freely Defined Currency 1
DebitAmtInFreeDefinedCrcy1 I_GLAccountLineItem DebitAmountInFreeDefinedCrcy1
CreditAmtInFreeDefinedCrcy1 I_GLAccountLineItem CreditAmountInFreeDefinedCrcy1
FreeDefinedCurrency2 I_GLAccountLineItem FreeDefinedCurrency2 Freely Defined Currency 2
DebitAmtInFreeDefinedCrcy2 I_GLAccountLineItem DebitAmountInFreeDefinedCrcy2
CreditAmtInFreeDefinedCrcy2 I_GLAccountLineItem CreditAmountInFreeDefinedCrcy2
FreeDefinedCurrency3 I_GLAccountLineItem FreeDefinedCurrency3 Freely Defined Currency 3
DebitAmtInFreeDefinedCrcy3 I_GLAccountLineItem DebitAmountInFreeDefinedCrcy3
CreditAmtInFreeDefinedCrcy3 I_GLAccountLineItem CreditAmountInFreeDefinedCrcy3
FreeDefinedCurrency4 I_GLAccountLineItem FreeDefinedCurrency4 Freely Defined Currency 4
DebitAmtInFreeDefinedCrcy4 I_GLAccountLineItem DebitAmountInFreeDefinedCrcy4
CreditAmtInFreeDefinedCrcy4 I_GLAccountLineItem CreditAmountInFreeDefinedCrcy4
FreeDefinedCurrency5 I_GLAccountLineItem FreeDefinedCurrency5 Freely Defined Currency 5
DebitAmtInFreeDefinedCrcy5 I_GLAccountLineItem DebitAmountInFreeDefinedCrcy5
CreditAmtInFreeDefinedCrcy5 I_GLAccountLineItem CreditAmountInFreeDefinedCrcy5
FreeDefinedCurrency6 I_GLAccountLineItem FreeDefinedCurrency6 Freely Defined Currency 6
DebitAmtInFreeDefinedCrcy6 I_GLAccountLineItem DebitAmountInFreeDefinedCrcy6
CreditAmtInFreeDefinedCrcy6 I_GLAccountLineItem CreditAmountInFreeDefinedCrcy6
FreeDefinedCurrency7 I_GLAccountLineItem FreeDefinedCurrency7 Freely Defined Currency 7
DebitAmtInFreeDefinedCrcy7 I_GLAccountLineItem DebitAmountInFreeDefinedCrcy7
CreditAmtInFreeDefinedCrcy7 I_GLAccountLineItem CreditAmountInFreeDefinedCrcy7
FreeDefinedCurrency8 I_GLAccountLineItem FreeDefinedCurrency8 Freely Defined Currency 8
DebitAmtInFreeDefinedCrcy8 I_GLAccountLineItem DebitAmountInFreeDefinedCrcy8
CreditAmtInFreeDefinedCrcy8 I_GLAccountLineItem CreditAmountInFreeDefinedCrcy8
FunctionalCurrency I_GLAccountLineItem FunctionalCurrency Functional Currency
DebitAmountInFunctionalCrcy I_GLAccountLineItem DebitAmountInFunctionalCrcy Debit Amount in Functional Currency
CreditAmountInFunctionalCrcy I_GLAccountLineItem CreditAmountInFunctionalCrcy Credit Amount in Functional Currency
LedgerasLedger
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 Journal Entry Item
LedgerFiscalYear I_GLAccountLineItem LedgerFiscalYear
ChartOfAccounts I_GLAccountLineItem ChartOfAccounts Node Class
AccountingDocumentType I_GLAccountLineItem AccountingDocumentType Journal Entry Type
GLAccount I_GLAccountLineItem GLAccount General Ledger
CountryChartOfAccounts I_GLAccountLineItem CountryChartOfAccounts Chart of Accts
AlternativeGLAccount I_GLAccountLineItem AlternativeGLAccount Group Account
ControllingArea I_GLAccountLineItem ControllingArea Controlling Area
CostCenter I_GLAccountLineItem CostCenter Cost Center
ProfitCenter I_GLAccountLineItem ProfitCenter Profit Center
FinancialTransactionType I_GLAccountLineItem FinancialTransactionType Transact. Type
FunctionalArea I_GLAccountLineItem FunctionalArea Sendr Fctl Area
BusinessArea I_GLAccountLineItem BusinessArea Business Area
Segment I_GLAccountLineItem Segment Segment number
DebitCreditCode I_GLAccountLineItem DebitCreditCode Single-Character Flag
PostingDate I_GLAccountLineItem PostingDate Posting Date for GR
FiscalPeriod I_GLAccountLineItem FiscalPeriod Tax period
PartnerCompany I_GLAccountLineItem PartnerCompany Trading Partner
WBSElement I_GLAccountLineItem WBSElement WBS Internal ID
GLAccountType I_GLAccountLineItem GLAccountType G/L Account Type
CompanyCodeCurrencyRole I_LedgerCompanyCodeCrcyRoles CompanyCodeCurrencyRole
GlobalCurrencyRole I_LedgerCompanyCodeCrcyRoles GlobalCurrencyRole
FreeDefinedCurrency1Role I_LedgerCompanyCodeCrcyRoles FreeDefinedCurrency1Role
FreeDefinedCurrency2Role I_LedgerCompanyCodeCrcyRoles FreeDefinedCurrency2Role
FreeDefinedCurrency3Role I_LedgerCompanyCodeCrcyRoles FreeDefinedCurrency3Role
FreeDefinedCurrency4Role I_LedgerCompanyCodeCrcyRoles FreeDefinedCurrency4Role
FreeDefinedCurrency5Role I_LedgerCompanyCodeCrcyRoles FreeDefinedCurrency5Role
FreeDefinedCurrency6Role I_LedgerCompanyCodeCrcyRoles FreeDefinedCurrency6Role
FreeDefinedCurrency7Role I_LedgerCompanyCodeCrcyRoles FreeDefinedCurrency7Role
FreeDefinedCurrency8Role I_LedgerCompanyCodeCrcyRoles FreeDefinedCurrency8Role
FunctionalCurrencyRole I_LedgerCompanyCodeCrcyRoles FunctionalCurrencyRole
CompanyCodeCurrency I_GLAccountLineItem CompanyCodeCurrency Local Currency
DebitAmtInCoCodeCrcy I_GLAccountLineItem DebitAmountInCoCodeCrcy Debit Amount in Company Code Currency
CreditAmtInCoCodeCrcy I_GLAccountLineItem CreditAmountInCoCodeCrcy Credit Amount in Company Code Currency
GlobalCurrency I_GLAccountLineItem GlobalCurrency GM Billing Element: Global Currency
DebitAmtInGlobalCrcy I_GLAccountLineItem DebitAmountInGlobalCrcy
CreditAmtInGlobalCrcy I_GLAccountLineItem CreditAmountInGlobalCrcy
FreeDefinedCurrency1 I_GLAccountLineItem FreeDefinedCurrency1 Freely Defined Currency 1
DebitAmtInFreeDefinedCrcy1 I_GLAccountLineItem DebitAmountInFreeDefinedCrcy1
CreditAmtInFreeDefinedCrcy1 I_GLAccountLineItem CreditAmountInFreeDefinedCrcy1
FreeDefinedCurrency2 I_GLAccountLineItem FreeDefinedCurrency2 Freely Defined Currency 2
DebitAmtInFreeDefinedCrcy2 I_GLAccountLineItem DebitAmountInFreeDefinedCrcy2
CreditAmtInFreeDefinedCrcy2 I_GLAccountLineItem CreditAmountInFreeDefinedCrcy2
FreeDefinedCurrency3 I_GLAccountLineItem FreeDefinedCurrency3 Freely Defined Currency 3
DebitAmtInFreeDefinedCrcy3 I_GLAccountLineItem DebitAmountInFreeDefinedCrcy3
CreditAmtInFreeDefinedCrcy3 I_GLAccountLineItem CreditAmountInFreeDefinedCrcy3
FreeDefinedCurrency4 I_GLAccountLineItem FreeDefinedCurrency4 Freely Defined Currency 4
DebitAmtInFreeDefinedCrcy4 I_GLAccountLineItem DebitAmountInFreeDefinedCrcy4
CreditAmtInFreeDefinedCrcy4 I_GLAccountLineItem CreditAmountInFreeDefinedCrcy4
FreeDefinedCurrency5 I_GLAccountLineItem FreeDefinedCurrency5 Freely Defined Currency 5
DebitAmtInFreeDefinedCrcy5 I_GLAccountLineItem DebitAmountInFreeDefinedCrcy5
CreditAmtInFreeDefinedCrcy5 I_GLAccountLineItem CreditAmountInFreeDefinedCrcy5
FreeDefinedCurrency6 I_GLAccountLineItem FreeDefinedCurrency6 Freely Defined Currency 6
DebitAmtInFreeDefinedCrcy6 I_GLAccountLineItem DebitAmountInFreeDefinedCrcy6
CreditAmtInFreeDefinedCrcy6 I_GLAccountLineItem CreditAmountInFreeDefinedCrcy6
FreeDefinedCurrency7 I_GLAccountLineItem FreeDefinedCurrency7 Freely Defined Currency 7
DebitAmtInFreeDefinedCrcy7 I_GLAccountLineItem DebitAmountInFreeDefinedCrcy7
CreditAmtInFreeDefinedCrcy7 I_GLAccountLineItem CreditAmountInFreeDefinedCrcy7
FreeDefinedCurrency8 I_GLAccountLineItem FreeDefinedCurrency8 Freely Defined Currency 8
DebitAmtInFreeDefinedCrcy8 I_GLAccountLineItem DebitAmountInFreeDefinedCrcy8
CreditAmtInFreeDefinedCrcy8 I_GLAccountLineItem CreditAmountInFreeDefinedCrcy8
FunctionalCurrency I_GLAccountLineItem FunctionalCurrency Functional Currency
DebitAmountInFunctionalCrcy I_GLAccountLineItem DebitAmountInFunctionalCrcy Debit Amount in Functional Currency
CreditAmountInFunctionalCrcy I_GLAccountLineItem CreditAmountInFunctionalCrcy Credit Amount in Functional Currency
LedgerasLedger
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 Journal Entry Item
LedgerFiscalYear I_GLAccountLineItem LedgerFiscalYear
ChartOfAccounts I_GLAccountLineItem ChartOfAccounts Node Class
AccountingDocumentType I_GLAccountLineItem AccountingDocumentType Journal Entry Type
GLAccount I_GLAccountLineItem GLAccount General Ledger
CountryChartOfAccounts I_GLAccountLineItem CountryChartOfAccounts Chart of Accts
AlternativeGLAccount I_GLAccountLineItem AlternativeGLAccount Group Account
ControllingArea I_GLAccountLineItem ControllingArea Controlling Area
CostCenter I_GLAccountLineItem CostCenter Cost Center
ProfitCenter I_GLAccountLineItem ProfitCenter Profit Center
FinancialTransactionType I_GLAccountLineItem FinancialTransactionType Transact. Type
FunctionalArea I_GLAccountLineItem FunctionalArea Sendr Fctl Area
BusinessArea I_GLAccountLineItem BusinessArea Business Area
Segment I_GLAccountLineItem Segment Segment number
DebitCreditCode I_GLAccountLineItem DebitCreditCode Single-Character Flag
PostingDate I_GLAccountLineItem PostingDate Posting Date for GR
FiscalPeriod I_GLAccountLineItem FiscalPeriod Tax period
PartnerCompany I_GLAccountLineItem PartnerCompany Trading Partner
WBSElement I_GLAccountLineItem WBSElement WBS Internal ID
GLAccountType I_GLAccountLineItem GLAccountType G/L Account Type
CompanyCodeCurrencyRole I_LedgerCompanyCodeCrcyRoles CompanyCodeCurrencyRole
GlobalCurrencyRole I_LedgerCompanyCodeCrcyRoles GlobalCurrencyRole
FreeDefinedCurrency1Role I_LedgerCompanyCodeCrcyRoles FreeDefinedCurrency1Role
FreeDefinedCurrency2Role I_LedgerCompanyCodeCrcyRoles FreeDefinedCurrency2Role
FreeDefinedCurrency3Role I_LedgerCompanyCodeCrcyRoles FreeDefinedCurrency3Role
FreeDefinedCurrency4Role I_LedgerCompanyCodeCrcyRoles FreeDefinedCurrency4Role
FreeDefinedCurrency5Role I_LedgerCompanyCodeCrcyRoles FreeDefinedCurrency5Role
FreeDefinedCurrency6Role I_LedgerCompanyCodeCrcyRoles FreeDefinedCurrency6Role
FreeDefinedCurrency7Role I_LedgerCompanyCodeCrcyRoles FreeDefinedCurrency7Role
FreeDefinedCurrency8Role I_LedgerCompanyCodeCrcyRoles FreeDefinedCurrency8Role
FunctionalCurrencyRole I_LedgerCompanyCodeCrcyRoles FunctionalCurrencyRole
CompanyCodeCurrency I_GLAccountLineItem CompanyCodeCurrency Local Currency
DebitAmtInCoCodeCrcy I_GLAccountLineItem DebitAmountInCoCodeCrcy Debit Amount in Company Code Currency
CreditAmtInCoCodeCrcy I_GLAccountLineItem CreditAmountInCoCodeCrcy Credit Amount in Company Code Currency
GlobalCurrency I_GLAccountLineItem GlobalCurrency GM Billing Element: Global Currency
DebitAmtInGlobalCrcy I_GLAccountLineItem DebitAmountInGlobalCrcy
CreditAmtInGlobalCrcy I_GLAccountLineItem CreditAmountInGlobalCrcy
FreeDefinedCurrency1 I_GLAccountLineItem FreeDefinedCurrency1 Freely Defined Currency 1
DebitAmtInFreeDefinedCrcy1 I_GLAccountLineItem DebitAmountInFreeDefinedCrcy1
CreditAmtInFreeDefinedCrcy1 I_GLAccountLineItem CreditAmountInFreeDefinedCrcy1
FreeDefinedCurrency2 I_GLAccountLineItem FreeDefinedCurrency2 Freely Defined Currency 2
DebitAmtInFreeDefinedCrcy2 I_GLAccountLineItem DebitAmountInFreeDefinedCrcy2
CreditAmtInFreeDefinedCrcy2 I_GLAccountLineItem CreditAmountInFreeDefinedCrcy2
FreeDefinedCurrency3 I_GLAccountLineItem FreeDefinedCurrency3 Freely Defined Currency 3
DebitAmtInFreeDefinedCrcy3 I_GLAccountLineItem DebitAmountInFreeDefinedCrcy3
CreditAmtInFreeDefinedCrcy3 I_GLAccountLineItem CreditAmountInFreeDefinedCrcy3
FreeDefinedCurrency4 I_GLAccountLineItem FreeDefinedCurrency4 Freely Defined Currency 4
DebitAmtInFreeDefinedCrcy4 I_GLAccountLineItem DebitAmountInFreeDefinedCrcy4
CreditAmtInFreeDefinedCrcy4 I_GLAccountLineItem CreditAmountInFreeDefinedCrcy4
FreeDefinedCurrency5 I_GLAccountLineItem FreeDefinedCurrency5 Freely Defined Currency 5
DebitAmtInFreeDefinedCrcy5 I_GLAccountLineItem DebitAmountInFreeDefinedCrcy5
CreditAmtInFreeDefinedCrcy5 I_GLAccountLineItem CreditAmountInFreeDefinedCrcy5
FreeDefinedCurrency6 I_GLAccountLineItem FreeDefinedCurrency6 Freely Defined Currency 6
DebitAmtInFreeDefinedCrcy6 I_GLAccountLineItem DebitAmountInFreeDefinedCrcy6
CreditAmtInFreeDefinedCrcy6 I_GLAccountLineItem CreditAmountInFreeDefinedCrcy6
FreeDefinedCurrency7 I_GLAccountLineItem FreeDefinedCurrency7 Freely Defined Currency 7
DebitAmtInFreeDefinedCrcy7 I_GLAccountLineItem DebitAmountInFreeDefinedCrcy7
CreditAmtInFreeDefinedCrcy7 I_GLAccountLineItem CreditAmountInFreeDefinedCrcy7
FreeDefinedCurrency8 I_GLAccountLineItem FreeDefinedCurrency8 Freely Defined Currency 8
DebitAmtInFreeDefinedCrcy8 I_GLAccountLineItem DebitAmountInFreeDefinedCrcy8
CreditAmtInFreeDefinedCrcy8 I_GLAccountLineItem CreditAmountInFreeDefinedCrcy8
FunctionalCurrency I_GLAccountLineItem FunctionalCurrency Functional Currency
DebitAmountInFunctionalCrcy I_GLAccountLineItem DebitAmountInFunctionalCrcy Debit Amount in Functional Currency
CreditAmountInFunctionalCrcy I_GLAccountLineItem CreditAmountInFunctionalCrcy Credit Amount in Functional Currency
PeriodFlag

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_GLAcctBalbyPeriod01.
-- 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.
-- Parameters: P_Ledger : fis_rldnr, P_FiscalYear : fins_gjahr, P_StartFiscalPeriod : fins_fiscalperiod, P_EndFiscalPeriod : fins_fiscalperiod

CREATE VIEW P_GLAcctBalbyPeriod01 AS
SELECT
  GLAccountLineItem.Ledger AS Ledger,
  GLAccountLineItem.CompanyCode AS CompanyCode,
  GLAccountLineItem.FiscalYear AS FiscalYear,
  GLAccountLineItem.AccountingDocument AS AccountingDocument,
  GLAccountLineItem.LedgerGLLineItem AS LedgerGLLineItem,
  GLAccountLineItem.LedgerFiscalYear AS LedgerFiscalYear,
  GLAccountLineItem.ChartOfAccounts AS ChartOfAccounts,
  GLAccountLineItem.AccountingDocumentType AS AccountingDocumentType,
  GLAccountLineItem.GLAccount AS GLAccount,
  GLAccountLineItem.CountryChartOfAccounts AS CountryChartOfAccounts,
  GLAccountLineItem.AlternativeGLAccount AS AlternativeGLAccount,
  GLAccountLineItem.ControllingArea AS ControllingArea,
  GLAccountLineItem.CostCenter AS CostCenter,
  GLAccountLineItem.ProfitCenter AS ProfitCenter,
  GLAccountLineItem.FinancialTransactionType AS FinancialTransactionType,
  GLAccountLineItem.FunctionalArea AS FunctionalArea,
  GLAccountLineItem.BusinessArea AS BusinessArea,
  GLAccountLineItem.Segment AS Segment,
  GLAccountLineItem.DebitCreditCode AS DebitCreditCode,
  GLAccountLineItem.PostingDate AS PostingDate,
  GLAccountLineItem.FiscalPeriod AS FiscalPeriod,
  GLAccountLineItem.PartnerCompany AS PartnerCompany,
  GLAccountLineItem.WBSElement AS WBSElement,
  GLAccountLineItem.GLAccountType AS GLAccountType,
  LedgerCompanyCodeCrcyRole.CompanyCodeCurrencyRole AS CompanyCodeCurrencyRole,
  LedgerCompanyCodeCrcyRole.GlobalCurrencyRole AS GlobalCurrencyRole,
  LedgerCompanyCodeCrcyRole.FreeDefinedCurrency1Role AS FreeDefinedCurrency1Role,
  LedgerCompanyCodeCrcyRole.FreeDefinedCurrency2Role AS FreeDefinedCurrency2Role,
  LedgerCompanyCodeCrcyRole.FreeDefinedCurrency3Role AS FreeDefinedCurrency3Role,
  LedgerCompanyCodeCrcyRole.FreeDefinedCurrency4Role AS FreeDefinedCurrency4Role,
  LedgerCompanyCodeCrcyRole.FreeDefinedCurrency5Role AS FreeDefinedCurrency5Role,
  LedgerCompanyCodeCrcyRole.FreeDefinedCurrency6Role AS FreeDefinedCurrency6Role,
  LedgerCompanyCodeCrcyRole.FreeDefinedCurrency7Role AS FreeDefinedCurrency7Role,
  LedgerCompanyCodeCrcyRole.FreeDefinedCurrency8Role AS FreeDefinedCurrency8Role,
  LedgerCompanyCodeCrcyRole.FunctionalCurrencyRole AS FunctionalCurrencyRole,
  GLAccountLineItem.CompanyCodeCurrency AS CompanyCodeCurrency,
  GLAccountLineItem.DebitAmountInCoCodeCrcy AS DebitAmtInCoCodeCrcy,
  GLAccountLineItem.CreditAmountInCoCodeCrcy AS CreditAmtInCoCodeCrcy,
  GLAccountLineItem.GlobalCurrency AS GlobalCurrency,
  GLAccountLineItem.DebitAmountInGlobalCrcy AS DebitAmtInGlobalCrcy,
  GLAccountLineItem.CreditAmountInGlobalCrcy AS CreditAmtInGlobalCrcy,
  GLAccountLineItem.FreeDefinedCurrency1 AS FreeDefinedCurrency1,
  GLAccountLineItem.DebitAmountInFreeDefinedCrcy1 AS DebitAmtInFreeDefinedCrcy1,
  GLAccountLineItem.CreditAmountInFreeDefinedCrcy1 AS CreditAmtInFreeDefinedCrcy1,
  GLAccountLineItem.FreeDefinedCurrency2 AS FreeDefinedCurrency2,
  GLAccountLineItem.DebitAmountInFreeDefinedCrcy2 AS DebitAmtInFreeDefinedCrcy2,
  GLAccountLineItem.CreditAmountInFreeDefinedCrcy2 AS CreditAmtInFreeDefinedCrcy2,
  GLAccountLineItem.FreeDefinedCurrency3 AS FreeDefinedCurrency3,
  GLAccountLineItem.DebitAmountInFreeDefinedCrcy3 AS DebitAmtInFreeDefinedCrcy3,
  GLAccountLineItem.CreditAmountInFreeDefinedCrcy3 AS CreditAmtInFreeDefinedCrcy3,
  GLAccountLineItem.FreeDefinedCurrency4 AS FreeDefinedCurrency4,
  GLAccountLineItem.DebitAmountInFreeDefinedCrcy4 AS DebitAmtInFreeDefinedCrcy4,
  GLAccountLineItem.CreditAmountInFreeDefinedCrcy4 AS CreditAmtInFreeDefinedCrcy4,
  GLAccountLineItem.FreeDefinedCurrency5 AS FreeDefinedCurrency5,
  GLAccountLineItem.DebitAmountInFreeDefinedCrcy5 AS DebitAmtInFreeDefinedCrcy5,
  GLAccountLineItem.CreditAmountInFreeDefinedCrcy5 AS CreditAmtInFreeDefinedCrcy5,
  GLAccountLineItem.FreeDefinedCurrency6 AS FreeDefinedCurrency6,
  GLAccountLineItem.DebitAmountInFreeDefinedCrcy6 AS DebitAmtInFreeDefinedCrcy6,
  GLAccountLineItem.CreditAmountInFreeDefinedCrcy6 AS CreditAmtInFreeDefinedCrcy6,
  GLAccountLineItem.FreeDefinedCurrency7 AS FreeDefinedCurrency7,
  GLAccountLineItem.DebitAmountInFreeDefinedCrcy7 AS DebitAmtInFreeDefinedCrcy7,
  GLAccountLineItem.CreditAmountInFreeDefinedCrcy7 AS CreditAmtInFreeDefinedCrcy7,
  GLAccountLineItem.FreeDefinedCurrency8 AS FreeDefinedCurrency8,
  GLAccountLineItem.DebitAmountInFreeDefinedCrcy8 AS DebitAmtInFreeDefinedCrcy8,
  GLAccountLineItem.CreditAmountInFreeDefinedCrcy8 AS CreditAmtInFreeDefinedCrcy8,
  GLAccountLineItem.FunctionalCurrency AS FunctionalCurrency,
  GLAccountLineItem.DebitAmountInFunctionalCrcy AS DebitAmountInFunctionalCrcy,
  GLAccountLineItem.CreditAmountInFunctionalCrcy AS CreditAmountInFunctionalCrcy,
  'O' as PeriodFlag AS LedgerasLedger,
  'R' AS PeriodFlag
FROM I_GLAccountLineItem AS GLAccountLineItem
INNER JOIN I_LedgerCompanyCodeCrcyRoles AS LedgerCompanyCodeCrcyRole ON /* join condition not captured in parsed metadata */
-- UNION ALL with additional select branch(es): I_GLAccountLineItem
;

Learn More