P_GLAcctLineItemEnrcd

DDL: P_GLACCTLINEITEMENRCD SQL: PGLACCTLINEITEME Type: view COMPOSITE Package: GLO_FIN_CN_BAL
151 Fields 5 Data Sources 2 Associations

GLAccount Line Items Enriched

P_GLAcctLineItemEnrcd is a Composite CDS View that provides data about "GLAccount Line Items Enriched" in SAP S/4HANA. It reads from 5 data sources (I_FiscalYearForCompanyCode, I_Ledger, I_Ledger, I_GLAccountLineItem, I_GLAccountLineItem) and exposes 151 fields with key fields CompanyCode, FiscalYear, AccountingDocument, LedgerGLLineItem, Ledger. It has 2 associations to related views. Part of development package GLO_FIN_CN_BAL.

Data Sources (5)

SourceAliasJoin Type
I_FiscalYearForCompanyCode fiscalyear inner
I_Ledger ledger inner
I_Ledger ledger inner
I_GLAccountLineItem lineitem from
I_GLAccountLineItem lineitem union_all

Parameters (2)

NameTypeDefault
P_CompanyCode bukrs
P_FiscalYear gjahr

Associations (2)

CardinalityTargetAliasCondition
[1..1] I_GLAccountInCompanyCode _GLAccountInCompanyCode $projection.CompanyCode = _GLAccountInCompanyCode.CompanyCode and $projection.GLAccount = _GLAccountInCompanyCode.GLAccount
[1..1] I_AccountingDocument _AccountingDocument $projection.CompanyCode = _AccountingDocument.CompanyCode and $projection.FiscalYear = _AccountingDocument.FiscalYear and $projection.AccountingDocument = _AccountingDocument.AccountingDocument

Annotations (7)

NameValueLevelField
AbapCatalog.sqlViewName PGLACCTLINEITEME view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
VDM.private true view
VDM.viewType #COMPOSITE view
ClientHandling.algorithm #SESSION_VARIABLE view

Fields (151)

KeyFieldSource TableSource FieldDescription
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
KEY Ledger I_GLAccountLineItem Ledger Ledger
KEY PostingDate I_GLAccountLineItem PostingDate Posting Date for GR
FiscalPeriod I_GLAccountLineItem FiscalPeriod Tax period
GLAccount I_GLAccountLineItem GLAccount General Ledger
AlternativeGLAccount _GLAccountInCompanyCode AlternativeGLAccount Group Account
Supplier I_GLAccountLineItem Supplier Supplier
Customer I_GLAccountLineItem Customer Sold-to Party
SpecialGLCode I_GLAccountLineItem SpecialGLCode Special G/L Ind
ProfitCenter I_GLAccountLineItem ProfitCenter Profit Center
Segment I_GLAccountLineItem Segment Segment number
BusinessArea I_GLAccountLineItem BusinessArea Business Area
AssignmentReference I_GLAccountLineItem AssignmentReference Assignment Reference
DebitCreditCode I_GLAccountLineItem DebitCreditCode Single-Character Flag
SalesOrganization I_GLAccountLineItem SalesOrganization Sales Organization
DistributionChannel I_GLAccountLineItem DistributionChannel RefDistCh-Cust/Mat.
OrganizationDivision I_GLAccountLineItem OrganizationDivision Org. Division
PartnerProfitCenter I_GLAccountLineItem PartnerProfitCenter Profit Center
FinancialAccountType I_GLAccountLineItem FinancialAccountType Fin. Account Type
AccountingDocumentType I_GLAccountLineItem AccountingDocumentType Journal Entry Type
DocumentDate I_GLAccountLineItem DocumentDate Journal Entry Date
AccountingDocCreatedByUser I_GLAccountLineItem AccountingDocCreatedByUser User which created overhead document
DocumentItemText I_GLAccountLineItem DocumentItemText Text
ClearingDate I_GLAccountLineItem ClearingDate Clearing Date
ClearingJournalEntry I_GLAccountLineItem ClearingJournalEntry Clrng doc.
AlternativeReferenceDocument _AccountingDocument AlternativeReferenceDocument Alternative Reference Document
AccountingDocumentHeaderText _AccountingDocument AccountingDocumentHeaderText Doc.Header Text
CompanyCodeCurrency I_GLAccountLineItem CompanyCodeCurrency Local Currency
GlobalCurrency I_GLAccountLineItem GlobalCurrency GM Billing Element: Global Currency
FreeDefinedCurrency1 I_GLAccountLineItem FreeDefinedCurrency1 Freely Defined Currency 1
FreeDefinedCurrency2 I_GLAccountLineItem FreeDefinedCurrency2 Freely Defined Currency 2
FreeDefinedCurrency3 I_GLAccountLineItem FreeDefinedCurrency3 Freely Defined Currency 3
FreeDefinedCurrency4 I_GLAccountLineItem FreeDefinedCurrency4 Freely Defined Currency 4
FreeDefinedCurrency5 I_GLAccountLineItem FreeDefinedCurrency5 Freely Defined Currency 5
FreeDefinedCurrency6 I_GLAccountLineItem FreeDefinedCurrency6 Freely Defined Currency 6
FreeDefinedCurrency7 I_GLAccountLineItem FreeDefinedCurrency7 Freely Defined Currency 7
FreeDefinedCurrency8 I_GLAccountLineItem FreeDefinedCurrency8 Freely Defined Currency 8
TransactionCurrency I_GLAccountLineItem TransactionCurrency Transaction Currency
AmountInTransactionCurrency I_GLAccountLineItem AmountInTransactionCurrency Pt Crcy Amt
DebitAmountInTransCrcy I_GLAccountLineItem DebitAmountInTransCrcy Debit Amt in DC
CreditAmountInTransCrcy I_GLAccountLineItem CreditAmountInTransCrcy Credit Amt in DC
AmountInCompanyCodeCurrency I_GLAccountLineItem AmountInCompanyCodeCurrency Local Crcy Amt
AmountInGlobalCurrency I_GLAccountLineItem AmountInGlobalCurrency Amount in Global Currency
AmountInFreeDefinedCurrency1 I_GLAccountLineItem AmountInFreeDefinedCurrency1 Amount in Freely Defined Currency 1
AmountInFreeDefinedCurrency2 I_GLAccountLineItem AmountInFreeDefinedCurrency2 Amount in Freely Defined Currency 2
AmountInFreeDefinedCurrency3 I_GLAccountLineItem AmountInFreeDefinedCurrency3 Amount in Freely Defined Currency 3
AmountInFreeDefinedCurrency4 I_GLAccountLineItem AmountInFreeDefinedCurrency4 Amount in Freely Defined Currency 4
AmountInFreeDefinedCurrency5 I_GLAccountLineItem AmountInFreeDefinedCurrency5 Amount in Freely Defined Currency 5
AmountInFreeDefinedCurrency6 I_GLAccountLineItem AmountInFreeDefinedCurrency6 Amount in Freely Defined Currency 6
AmountInFreeDefinedCurrency7 I_GLAccountLineItem AmountInFreeDefinedCurrency7 Amount in Freely Defined Currency 7
AmountInFreeDefinedCurrency8 I_GLAccountLineItem AmountInFreeDefinedCurrency8 Amount in Freely Defined Currency 8
DebitAmountInCoCodeCrcy I_GLAccountLineItem DebitAmountInCoCodeCrcy Debit Amount in Company Code Currency
DebitAmountInGlobalCrcy I_GLAccountLineItem DebitAmountInGlobalCrcy
DebitAmountInFreeDefinedCrcy1 I_GLAccountLineItem DebitAmountInFreeDefinedCrcy1
DebitAmountInFreeDefinedCrcy2 I_GLAccountLineItem DebitAmountInFreeDefinedCrcy2
DebitAmountInFreeDefinedCrcy3 I_GLAccountLineItem DebitAmountInFreeDefinedCrcy3
DebitAmountInFreeDefinedCrcy4 I_GLAccountLineItem DebitAmountInFreeDefinedCrcy4
DebitAmountInFreeDefinedCrcy5 I_GLAccountLineItem DebitAmountInFreeDefinedCrcy5
DebitAmountInFreeDefinedCrcy6 I_GLAccountLineItem DebitAmountInFreeDefinedCrcy6
DebitAmountInFreeDefinedCrcy7 I_GLAccountLineItem DebitAmountInFreeDefinedCrcy7
DebitAmountInFreeDefinedCrcy8 I_GLAccountLineItem DebitAmountInFreeDefinedCrcy8
CreditAmountInCoCodeCrcy I_GLAccountLineItem CreditAmountInCoCodeCrcy Credit Amount in Company Code Currency
CreditAmountInGlobalCrcy I_GLAccountLineItem CreditAmountInGlobalCrcy
CreditAmountInFreeDefinedCrcy1 I_GLAccountLineItem CreditAmountInFreeDefinedCrcy1
CreditAmountInFreeDefinedCrcy2 I_GLAccountLineItem CreditAmountInFreeDefinedCrcy2
CreditAmountInFreeDefinedCrcy3 I_GLAccountLineItem CreditAmountInFreeDefinedCrcy3
CreditAmountInFreeDefinedCrcy4 I_GLAccountLineItem CreditAmountInFreeDefinedCrcy4
CreditAmountInFreeDefinedCrcy5 I_GLAccountLineItem CreditAmountInFreeDefinedCrcy5
CreditAmountInFreeDefinedCrcy6 I_GLAccountLineItem CreditAmountInFreeDefinedCrcy6
CreditAmountInFreeDefinedCrcy7 I_GLAccountLineItem CreditAmountInFreeDefinedCrcy7
CreditAmountInFreeDefinedCrcy8 I_GLAccountLineItem CreditAmountInFreeDefinedCrcy8
_Customer I_GLAccountLineItem _Customer
CompanyCode Receiver Company Code
KEY FiscalYear G/L Fiscal Year
KEY AccountingDocument I_GLAccountLineItem AccountingDocument Journal Entry
KEY LedgerGLLineItem I_GLAccountLineItem LedgerGLLineItem Journal Entry Item
KEY Ledger I_GLAccountLineItem Ledger Ledger
KEY PostingDate I_GLAccountLineItem PostingDate Posting Date for GR
FiscalPeriod Tax period
GLAccount I_GLAccountLineItem GLAccount General Ledger
AlternativeGLAccount _GLAccountInCompanyCode AlternativeGLAccount Group Account
Supplier I_GLAccountLineItem Supplier Supplier
Customer I_GLAccountLineItem Customer Sold-to Party
SpecialGLCode I_GLAccountLineItem SpecialGLCode Special G/L Ind
ProfitCenter I_GLAccountLineItem ProfitCenter Profit Center
Segment I_GLAccountLineItem Segment Segment number
BusinessArea I_GLAccountLineItem BusinessArea Business Area
AssignmentReference I_GLAccountLineItem AssignmentReference Assignment Reference
DebitCreditCode I_GLAccountLineItem DebitCreditCode Single-Character Flag
SalesOrganization I_GLAccountLineItem SalesOrganization Sales Organization
DistributionChannel I_GLAccountLineItem DistributionChannel RefDistCh-Cust/Mat.
OrganizationDivision I_GLAccountLineItem OrganizationDivision Org. Division
PartnerProfitCenter I_GLAccountLineItem PartnerProfitCenter Profit Center
FinancialAccountType I_GLAccountLineItem FinancialAccountType Fin. Account Type
AccountingDocumentType I_GLAccountLineItem AccountingDocumentType Journal Entry Type
DocumentDate I_GLAccountLineItem DocumentDate Journal Entry Date
AccountingDocCreatedByUser I_GLAccountLineItem AccountingDocCreatedByUser User which created overhead document
DocumentItemText I_GLAccountLineItem DocumentItemText Text
ClearingDate I_GLAccountLineItem ClearingDate Clearing Date
ClearingJournalEntry I_GLAccountLineItem ClearingJournalEntry Clrng doc.
AlternativeReferenceDocument _AccountingDocument AlternativeReferenceDocument Alternative Reference Document
AccountingDocumentHeaderText _AccountingDocument AccountingDocumentHeaderText Doc.Header Text
CompanyCodeCurrency I_GLAccountLineItem CompanyCodeCurrency Local Currency
GlobalCurrency I_GLAccountLineItem GlobalCurrency GM Billing Element: Global Currency
FreeDefinedCurrency1 I_GLAccountLineItem FreeDefinedCurrency1 Freely Defined Currency 1
FreeDefinedCurrency2 I_GLAccountLineItem FreeDefinedCurrency2 Freely Defined Currency 2
FreeDefinedCurrency3 I_GLAccountLineItem FreeDefinedCurrency3 Freely Defined Currency 3
FreeDefinedCurrency4 I_GLAccountLineItem FreeDefinedCurrency4 Freely Defined Currency 4
FreeDefinedCurrency5 I_GLAccountLineItem FreeDefinedCurrency5 Freely Defined Currency 5
FreeDefinedCurrency6 I_GLAccountLineItem FreeDefinedCurrency6 Freely Defined Currency 6
FreeDefinedCurrency7 I_GLAccountLineItem FreeDefinedCurrency7 Freely Defined Currency 7
FreeDefinedCurrency8 I_GLAccountLineItem FreeDefinedCurrency8 Freely Defined Currency 8
TransactionCurrency I_GLAccountLineItem TransactionCurrency Transaction Currency
AmountInTransactionCurrency I_GLAccountLineItem AmountInTransactionCurrency Pt Crcy Amt
DebitAmountInTransCrcy I_GLAccountLineItem DebitAmountInTransCrcy Debit Amt in DC
CreditAmountInTransCrcy I_GLAccountLineItem CreditAmountInTransCrcy Credit Amt in DC
AmountInCompanyCodeCurrency I_GLAccountLineItem AmountInCompanyCodeCurrency Local Crcy Amt
AmountInGlobalCurrency I_GLAccountLineItem AmountInGlobalCurrency Amount in Global Currency
AmountInFreeDefinedCurrency1 I_GLAccountLineItem AmountInFreeDefinedCurrency1 Amount in Freely Defined Currency 1
AmountInFreeDefinedCurrency2 I_GLAccountLineItem AmountInFreeDefinedCurrency2 Amount in Freely Defined Currency 2
AmountInFreeDefinedCurrency3 I_GLAccountLineItem AmountInFreeDefinedCurrency3 Amount in Freely Defined Currency 3
AmountInFreeDefinedCurrency4 I_GLAccountLineItem AmountInFreeDefinedCurrency4 Amount in Freely Defined Currency 4
AmountInFreeDefinedCurrency5 I_GLAccountLineItem AmountInFreeDefinedCurrency5 Amount in Freely Defined Currency 5
AmountInFreeDefinedCurrency6 I_GLAccountLineItem AmountInFreeDefinedCurrency6 Amount in Freely Defined Currency 6
AmountInFreeDefinedCurrency7 I_GLAccountLineItem AmountInFreeDefinedCurrency7 Amount in Freely Defined Currency 7
AmountInFreeDefinedCurrency8 I_GLAccountLineItem AmountInFreeDefinedCurrency8 Amount in Freely Defined Currency 8
DebitAmountInCoCodeCrcy I_GLAccountLineItem DebitAmountInCoCodeCrcy Debit Amount in Company Code Currency
DebitAmountInGlobalCrcy I_GLAccountLineItem DebitAmountInGlobalCrcy
DebitAmountInFreeDefinedCrcy1 I_GLAccountLineItem DebitAmountInFreeDefinedCrcy1
DebitAmountInFreeDefinedCrcy2 I_GLAccountLineItem DebitAmountInFreeDefinedCrcy2
DebitAmountInFreeDefinedCrcy3 I_GLAccountLineItem DebitAmountInFreeDefinedCrcy3
DebitAmountInFreeDefinedCrcy4 I_GLAccountLineItem DebitAmountInFreeDefinedCrcy4
DebitAmountInFreeDefinedCrcy5 I_GLAccountLineItem DebitAmountInFreeDefinedCrcy5
DebitAmountInFreeDefinedCrcy6 I_GLAccountLineItem DebitAmountInFreeDefinedCrcy6
DebitAmountInFreeDefinedCrcy7 I_GLAccountLineItem DebitAmountInFreeDefinedCrcy7
DebitAmountInFreeDefinedCrcy8 I_GLAccountLineItem DebitAmountInFreeDefinedCrcy8
CreditAmountInCoCodeCrcy I_GLAccountLineItem CreditAmountInCoCodeCrcy Credit Amount in Company Code Currency
CreditAmountInGlobalCrcy I_GLAccountLineItem CreditAmountInGlobalCrcy
CreditAmountInFreeDefinedCrcy1 I_GLAccountLineItem CreditAmountInFreeDefinedCrcy1
CreditAmountInFreeDefinedCrcy2 I_GLAccountLineItem CreditAmountInFreeDefinedCrcy2
CreditAmountInFreeDefinedCrcy3 I_GLAccountLineItem CreditAmountInFreeDefinedCrcy3
CreditAmountInFreeDefinedCrcy4 I_GLAccountLineItem CreditAmountInFreeDefinedCrcy4
CreditAmountInFreeDefinedCrcy5 I_GLAccountLineItem CreditAmountInFreeDefinedCrcy5
CreditAmountInFreeDefinedCrcy6 I_GLAccountLineItem CreditAmountInFreeDefinedCrcy6
CreditAmountInFreeDefinedCrcy7 I_GLAccountLineItem CreditAmountInFreeDefinedCrcy7
CreditAmountInFreeDefinedCrcy8 I_GLAccountLineItem CreditAmountInFreeDefinedCrcy8
_Customer I_GLAccountLineItem _Customer
_Supplier I_GLAccountLineItem _Supplier

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_GLAcctLineItemEnrcd.
-- 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: PGLACCTLINEITEME
-- Parameters: P_CompanyCode : bukrs, P_FiscalYear : gjahr

CREATE VIEW P_GLAcctLineItemEnrcd AS
SELECT
  lineitem.CompanyCode AS CompanyCode,
  lineitem.FiscalYear AS FiscalYear,
  lineitem.AccountingDocument AS AccountingDocument,
  lineitem.LedgerGLLineItem AS LedgerGLLineItem,
  lineitem.Ledger AS Ledger,
  lineitem.PostingDate AS PostingDate,
  lineitem.FiscalPeriod AS FiscalPeriod,
  lineitem.GLAccount AS GLAccount,
  _GLAccountInCompanyCode.AlternativeGLAccount AS AlternativeGLAccount,
  lineitem.Supplier AS Supplier,
  lineitem.Customer AS Customer,
  lineitem.SpecialGLCode AS SpecialGLCode,
  lineitem.ProfitCenter AS ProfitCenter,
  lineitem.Segment AS Segment,
  lineitem.BusinessArea AS BusinessArea,
  lineitem.AssignmentReference AS AssignmentReference,
  lineitem.DebitCreditCode AS DebitCreditCode,
  lineitem.SalesOrganization AS SalesOrganization,
  lineitem.DistributionChannel AS DistributionChannel,
  lineitem.OrganizationDivision AS OrganizationDivision,
  lineitem.PartnerProfitCenter AS PartnerProfitCenter,
  lineitem.FinancialAccountType AS FinancialAccountType,
  lineitem.AccountingDocumentType AS AccountingDocumentType,
  lineitem.DocumentDate AS DocumentDate,
  lineitem.AccountingDocCreatedByUser AS AccountingDocCreatedByUser,
  lineitem.DocumentItemText AS DocumentItemText,
  lineitem.ClearingDate AS ClearingDate,
  lineitem.ClearingJournalEntry AS ClearingJournalEntry,
  _AccountingDocument.AlternativeReferenceDocument AS AlternativeReferenceDocument,
  _AccountingDocument.AccountingDocumentHeaderText AS AccountingDocumentHeaderText,
  lineitem.CompanyCodeCurrency AS CompanyCodeCurrency,
  lineitem.GlobalCurrency AS GlobalCurrency,
  lineitem.FreeDefinedCurrency1 AS FreeDefinedCurrency1,
  lineitem.FreeDefinedCurrency2 AS FreeDefinedCurrency2,
  lineitem.FreeDefinedCurrency3 AS FreeDefinedCurrency3,
  lineitem.FreeDefinedCurrency4 AS FreeDefinedCurrency4,
  lineitem.FreeDefinedCurrency5 AS FreeDefinedCurrency5,
  lineitem.FreeDefinedCurrency6 AS FreeDefinedCurrency6,
  lineitem.FreeDefinedCurrency7 AS FreeDefinedCurrency7,
  lineitem.FreeDefinedCurrency8 AS FreeDefinedCurrency8,
  lineitem.TransactionCurrency AS TransactionCurrency,
  lineitem.AmountInTransactionCurrency AS AmountInTransactionCurrency,
  lineitem.DebitAmountInTransCrcy AS DebitAmountInTransCrcy,
  lineitem.CreditAmountInTransCrcy AS CreditAmountInTransCrcy,
  lineitem.AmountInCompanyCodeCurrency AS AmountInCompanyCodeCurrency,
  lineitem.AmountInGlobalCurrency AS AmountInGlobalCurrency,
  lineitem.AmountInFreeDefinedCurrency1 AS AmountInFreeDefinedCurrency1,
  lineitem.AmountInFreeDefinedCurrency2 AS AmountInFreeDefinedCurrency2,
  lineitem.AmountInFreeDefinedCurrency3 AS AmountInFreeDefinedCurrency3,
  lineitem.AmountInFreeDefinedCurrency4 AS AmountInFreeDefinedCurrency4,
  lineitem.AmountInFreeDefinedCurrency5 AS AmountInFreeDefinedCurrency5,
  lineitem.AmountInFreeDefinedCurrency6 AS AmountInFreeDefinedCurrency6,
  lineitem.AmountInFreeDefinedCurrency7 AS AmountInFreeDefinedCurrency7,
  lineitem.AmountInFreeDefinedCurrency8 AS AmountInFreeDefinedCurrency8,
  lineitem.DebitAmountInCoCodeCrcy AS DebitAmountInCoCodeCrcy,
  lineitem.DebitAmountInGlobalCrcy AS DebitAmountInGlobalCrcy,
  lineitem.DebitAmountInFreeDefinedCrcy1 AS DebitAmountInFreeDefinedCrcy1,
  lineitem.DebitAmountInFreeDefinedCrcy2 AS DebitAmountInFreeDefinedCrcy2,
  lineitem.DebitAmountInFreeDefinedCrcy3 AS DebitAmountInFreeDefinedCrcy3,
  lineitem.DebitAmountInFreeDefinedCrcy4 AS DebitAmountInFreeDefinedCrcy4,
  lineitem.DebitAmountInFreeDefinedCrcy5 AS DebitAmountInFreeDefinedCrcy5,
  lineitem.DebitAmountInFreeDefinedCrcy6 AS DebitAmountInFreeDefinedCrcy6,
  lineitem.DebitAmountInFreeDefinedCrcy7 AS DebitAmountInFreeDefinedCrcy7,
  lineitem.DebitAmountInFreeDefinedCrcy8 AS DebitAmountInFreeDefinedCrcy8,
  lineitem.CreditAmountInCoCodeCrcy AS CreditAmountInCoCodeCrcy,
  lineitem.CreditAmountInGlobalCrcy AS CreditAmountInGlobalCrcy,
  lineitem.CreditAmountInFreeDefinedCrcy1 AS CreditAmountInFreeDefinedCrcy1,
  lineitem.CreditAmountInFreeDefinedCrcy2 AS CreditAmountInFreeDefinedCrcy2,
  lineitem.CreditAmountInFreeDefinedCrcy3 AS CreditAmountInFreeDefinedCrcy3,
  lineitem.CreditAmountInFreeDefinedCrcy4 AS CreditAmountInFreeDefinedCrcy4,
  lineitem.CreditAmountInFreeDefinedCrcy5 AS CreditAmountInFreeDefinedCrcy5,
  lineitem.CreditAmountInFreeDefinedCrcy6 AS CreditAmountInFreeDefinedCrcy6,
  lineitem.CreditAmountInFreeDefinedCrcy7 AS CreditAmountInFreeDefinedCrcy7,
  lineitem.CreditAmountInFreeDefinedCrcy8 AS CreditAmountInFreeDefinedCrcy8,
  lineitem._Customer AS _Customer,
  lineitem._Supplier AS _Supplier
FROM I_GLAccountLineItem AS lineitem
INNER JOIN I_Ledger AS ledger ON /* join condition not captured in parsed metadata */
INNER JOIN I_FiscalYearForCompanyCode AS fiscalyear ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_GLAccountInCompanyCode AS _GLAccountInCompanyCode ON CompanyCode = _GLAccountInCompanyCode.CompanyCode AND GLAccount = _GLAccountInCompanyCode.GLAccount  -- association [1..1]
LEFT OUTER JOIN I_AccountingDocument AS _AccountingDocument ON CompanyCode = _AccountingDocument.CompanyCode AND FiscalYear = _AccountingDocument.FiscalYear AND AccountingDocument = _AccountingDocument.AccountingDocument  -- association [1..1]
-- UNION ALL with additional select branch(es): I_GLAccountLineItem
;

Learn More