I_GLAcctLineItemItemizationBsc

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_GLAcctLineItemItemizationBsc.
-- 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 I_GLAcctLineItemItemizationBsc AS
SELECT
  cast(I_GLAcctLineItmItmznRawData.SalesDocument as vdm_sales_order preserving type ) AS SalesOrder,
  cast(I_GLAcctLineItmItmznRawData.SalesDocumentItem as sales_order_item preserving type ) AS SalesOrderItem,
  cast(I_GLAcctLineItmItmznRawData.Product as matnr preserving type ) AS Material,
  cast( I_GLAcctLineItmItmznRawData.ClearingJournalEntryFiscalYear as fis_auggj_no_conv_depre preserving type ) AS ClearingDocFiscalYear,
  cast( I_GLAcctLineItmItmznRawData.ClearingJournalEntry as fis_augbl_depre preserving type ) AS ClearingAccountingDocument,
  cast( I_GLAcctLineItmItmznRawData.InventorySpecialStockValnType as fis_invtryspclstockvalntype_d preserving type ) AS InventorySpecialStockValnType,
  cast( I_GLAcctLineItmItmznRawData.InventorySpclStockWBSElement as fis_invspstock_wbs preserving type ) AS InventorySpclStockWBSElement,
  cast( I_GLAcctLineItmItmznRawData.WBSElement as fis_wbs preserving type ) AS WBSElement,
  cast( I_GLAcctLineItmItmznRawData.Project as fis_project preserving type ) AS Project,
  cast(I_GLAcctLineItmItmznRawData.PartnerOrder as fis_par_aufnr_depre preserving type ) AS PartnerOrder,
  cast(I_GLAcctLineItmItmznRawData.PartnerOrder as fis_par_aufnr preserving type ) AS PartnerOrder_2,
  cast( I_GLAcctLineItmItmznRawData.PartnerWBSElement as fis_partner_wbs preserving type ) AS PartnerWBSElement,
  cast( I_GLAcctLineItmItmznRawData.PartnerProject as fis_part_project preserving type ) AS PartnerProject,
  cast(I_GLAcctLineItmItmznRawData.SoldProduct as fis_sold_material preserving type ) AS SoldMaterial,
  cast(I_GLAcctLineItmItmznRawData.SoldProductGroup as fins_matkl_pa preserving type ) AS MaterialGroup,
  I_GLAcctLineItmItmznRawData._CalendarDate.CalendarYear AS CalendarYear,
  I_GLAcctLineItmItmznRawData._CalendarDate.CalendarQuarter AS CalendarQuarter,
  I_GLAcctLineItmItmznRawData._CalendarDate.YearQuarter AS CalendarYearQuarter,
  I_GLAcctLineItmItmznRawData._CalendarDate.CalendarMonth AS CalendarMonth,
  I_GLAcctLineItmItmznRawData._CalendarDate.YearMonth AS CalendarYearMonth,
  I_GLAcctLineItmItmznRawData._CalendarDate.CalendarWeek AS CalendarWeek,
  I_GLAcctLineItmItmznRawData._CalendarDate.YearWeek AS CalendarYearWeek,
  cast( '' as brgru) AS GLAccountAuthorizationGroup,
  cast( '' as brgru) AS SupplierBasicAuthorizationGrp,
  cast( '' as brgru) AS CustomerBasicAuthorizationGrp,
  cast( '' as brgru) AS AcctgDocTypeAuthorizationGroup,
  cast( '' as aufart) AS OrderType,
  cast( '' as auart) AS SalesOrderType,
  I_GLAcctLineItmItmznRawData.SourceLedger AS SourceLedger,
  I_GLAcctLineItmItmznRawData.CompanyCode AS CompanyCode,
  I_GLAcctLineItmItmznRawData.FiscalYear AS FiscalYear,
  I_GLAcctLineItmItmznRawData.AccountingDocument AS AccountingDocument,
  I_GLAcctLineItmItmznRawData.LedgerGLLineItem AS LedgerGLLineItem,
  I_GLAcctLineItmItmznRawData.LedgerFiscalYear AS LedgerFiscalYear,
  I_GLAcctLineItmItmznRawData.GLRecordType AS GLRecordType,
  I_GLAcctLineItmItmznRawData.JrnlEntrAltvFYConsecutiveID AS JrnlEntrAltvFYConsecutiveID,
  I_GLAcctLineItmItmznRawData.ChartOfAccounts AS ChartOfAccounts,
  I_GLAcctLineItmItmznRawData.ControllingArea AS ControllingArea,
  I_GLAcctLineItmItmznRawData.FinancialTransactionType AS FinancialTransactionType,
  I_GLAcctLineItmItmznRawData.GLBusinessTransactionType AS GLBusinessTransactionType,
  I_GLAcctLineItmItmznRawData.BusinessTransactionCategory AS BusinessTransactionCategory,
  I_GLAcctLineItmItmznRawData.BusinessTransactionType AS BusinessTransactionType,
  I_GLAcctLineItmItmznRawData.FinancialClosingStep AS FinancialClosingStep,
  I_GLAcctLineItmItmznRawData.ControllingBusTransacType AS ControllingBusTransacType,
  I_GLAcctLineItmItmznRawData.ReferenceDocumentType AS ReferenceDocumentType,
  I_GLAcctLineItmItmznRawData.LogicalSystem AS LogicalSystem,
  I_GLAcctLineItmItmznRawData.ReferenceDocumentContext AS ReferenceDocumentContext,
  I_GLAcctLineItmItmznRawData.ReferenceDocument AS ReferenceDocument,
  I_GLAcctLineItmItmznRawData.ReferenceDocumentItem AS ReferenceDocumentItem,
  I_GLAcctLineItmItmznRawData.ReferenceDocumentItemGroup AS ReferenceDocumentItemGroup,
  I_GLAcctLineItmItmznRawData.TransactionSubitem AS TransactionSubitem,
  I_GLAcctLineItmItmznRawData.IsReversal AS IsReversal,
  I_GLAcctLineItmItmznRawData.IsReversed AS IsReversed,
  I_GLAcctLineItmItmznRawData.ReversalReferenceDocumentCntxt AS ReversalReferenceDocumentCntxt,
  I_GLAcctLineItmItmznRawData.ReversalReferenceDocument AS ReversalReferenceDocument,
  I_GLAcctLineItmItmznRawData.ReversalTransactionSubitem AS ReversalTransactionSubitem,
  I_GLAcctLineItmItmznRawData.IsSettlement AS IsSettlement,
  I_GLAcctLineItmItmznRawData.IsSettled AS IsSettled,
  I_GLAcctLineItmItmznRawData.PredecessorReferenceDocType AS PredecessorReferenceDocType,
  I_GLAcctLineItmItmznRawData.PredecessorReferenceDocCntxt AS PredecessorReferenceDocCntxt,
  I_GLAcctLineItmItmznRawData.PredecessorReferenceDocument AS PredecessorReferenceDocument,
  I_GLAcctLineItmItmznRawData.PredecessorReferenceDocItem AS PredecessorReferenceDocItem,
  I_GLAcctLineItmItmznRawData.PrdcssrJournalEntryCompanyCode AS PrdcssrJournalEntryCompanyCode,
  I_GLAcctLineItmItmznRawData.PrdcssrJournalEntryFiscalYear AS PrdcssrJournalEntryFiscalYear,
  I_GLAcctLineItmItmznRawData.PredecessorJournalEntry AS PredecessorJournalEntry,
  I_GLAcctLineItmItmznRawData.PredecessorJournalEntryItem AS PredecessorJournalEntryItem,
  I_GLAcctLineItmItmznRawData.SourceReferenceDocumentType AS SourceReferenceDocumentType,
  I_GLAcctLineItmItmznRawData.SourceLogicalSystem AS SourceLogicalSystem,
  I_GLAcctLineItmItmznRawData.SourceReferenceDocumentCntxt AS SourceReferenceDocumentCntxt,
  I_GLAcctLineItmItmznRawData.SourceReferenceDocument AS SourceReferenceDocument,
  I_GLAcctLineItmItmznRawData.SourceReferenceDocumentItem AS SourceReferenceDocumentItem,
  I_GLAcctLineItmItmznRawData.SourceReferenceDocSubitem AS SourceReferenceDocSubitem,
  I_GLAcctLineItmItmznRawData.IsCommitment AS IsCommitment,
  I_GLAcctLineItmItmznRawData.JrnlEntryItemObsoleteReason AS JrnlEntryItemObsoleteReason,
  I_GLAcctLineItmItmznRawData.JrnlPeriodEndClosingRunLogUUID AS JrnlPeriodEndClosingRunLogUUID,
  I_GLAcctLineItmItmznRawData.OrganizationalChange AS OrganizationalChange,
  I_GLAcctLineItmItmznRawData.GLAccount AS GLAccount,
  I_GLAcctLineItmItmznRawData.CostCenter AS CostCenter,
  I_GLAcctLineItmItmznRawData.ProfitCenter AS ProfitCenter,
  I_GLAcctLineItmItmznRawData.FunctionalArea AS FunctionalArea,
  I_GLAcctLineItmItmznRawData.BusinessArea AS BusinessArea,
  I_GLAcctLineItmItmznRawData.Segment AS Segment,
  I_GLAcctLineItmItmznRawData.PartnerCostCenter AS PartnerCostCenter,
  I_GLAcctLineItmItmznRawData.PartnerProfitCenter AS PartnerProfitCenter,
  I_GLAcctLineItmItmznRawData.PartnerFunctionalArea AS PartnerFunctionalArea,
  I_GLAcctLineItmItmznRawData.PartnerBusinessArea AS PartnerBusinessArea,
  I_GLAcctLineItmItmznRawData.PartnerCompany AS PartnerCompany,
  I_GLAcctLineItmItmznRawData.PartnerSegment AS PartnerSegment,
  I_GLAcctLineItmItmznRawData.BalanceTransactionCurrency AS BalanceTransactionCurrency,
  I_GLAcctLineItmItmznRawData.AmountInBalanceTransacCrcy AS AmountInBalanceTransacCrcy,
  I_GLAcctLineItmItmznRawData.TransactionCurrency AS TransactionCurrency,
  I_GLAcctLineItmItmznRawData.AmountInTransactionCurrency AS AmountInTransactionCurrency,
  I_GLAcctLineItmItmznRawData.CompanyCodeCurrency AS CompanyCodeCurrency,
  I_GLAcctLineItmItmznRawData.AmountInCompanyCodeCurrency AS AmountInCompanyCodeCurrency,
  I_GLAcctLineItmItmznRawData.GlobalCurrency AS GlobalCurrency,
  I_GLAcctLineItmItmznRawData.AmountInGlobalCurrency AS AmountInGlobalCurrency,
  I_GLAcctLineItmItmznRawData.FunctionalCurrency AS FunctionalCurrency,
  I_GLAcctLineItmItmznRawData.AmountInFunctionalCurrency AS AmountInFunctionalCurrency,
  I_GLAcctLineItmItmznRawData.FreeDefinedCurrency1 AS FreeDefinedCurrency1,
  I_GLAcctLineItmItmznRawData.AmountInFreeDefinedCurrency1 AS AmountInFreeDefinedCurrency1,
  I_GLAcctLineItmItmznRawData.FreeDefinedCurrency2 AS FreeDefinedCurrency2,
  I_GLAcctLineItmItmznRawData.AmountInFreeDefinedCurrency2 AS AmountInFreeDefinedCurrency2,
  I_GLAcctLineItmItmznRawData.FreeDefinedCurrency3 AS FreeDefinedCurrency3,
  I_GLAcctLineItmItmznRawData.AmountInFreeDefinedCurrency3 AS AmountInFreeDefinedCurrency3,
  I_GLAcctLineItmItmznRawData.FreeDefinedCurrency4 AS FreeDefinedCurrency4,
  I_GLAcctLineItmItmznRawData.AmountInFreeDefinedCurrency4 AS AmountInFreeDefinedCurrency4,
  I_GLAcctLineItmItmznRawData.FreeDefinedCurrency5 AS FreeDefinedCurrency5,
  I_GLAcctLineItmItmznRawData.AmountInFreeDefinedCurrency5 AS AmountInFreeDefinedCurrency5,
  I_GLAcctLineItmItmznRawData.FreeDefinedCurrency6 AS FreeDefinedCurrency6,
  I_GLAcctLineItmItmznRawData.AmountInFreeDefinedCurrency6 AS AmountInFreeDefinedCurrency6,
  I_GLAcctLineItmItmznRawData.FreeDefinedCurrency7 AS FreeDefinedCurrency7,
  I_GLAcctLineItmItmznRawData.AmountInFreeDefinedCurrency7 AS AmountInFreeDefinedCurrency7,
  I_GLAcctLineItmItmznRawData.FreeDefinedCurrency8 AS FreeDefinedCurrency8,
  I_GLAcctLineItmItmznRawData.AmountInFreeDefinedCurrency8 AS AmountInFreeDefinedCurrency8,
  I_GLAcctLineItmItmznRawData.FixedAmountInGlobalCrcy AS FixedAmountInGlobalCrcy,
  I_GLAcctLineItmItmznRawData.GrpValnFixedAmtInGlobCrcy AS GrpValnFixedAmtInGlobCrcy,
  I_GLAcctLineItmItmznRawData.PrftCtrValnFxdAmtInGlobCrcy AS PrftCtrValnFxdAmtInGlobCrcy,
  I_GLAcctLineItmItmznRawData.TotalPriceVarcInGlobalCrcy AS TotalPriceVarcInGlobalCrcy,
  I_GLAcctLineItmItmznRawData.GrpValnTotPrcVarcInGlobCrcy AS GrpValnTotPrcVarcInGlobCrcy,
  I_GLAcctLineItmItmznRawData.PrftCtrValnTotPrcVarcInGlbCrcy AS PrftCtrValnTotPrcVarcInGlbCrcy,
  I_GLAcctLineItmItmznRawData.FixedPriceVarcInGlobalCrcy AS FixedPriceVarcInGlobalCrcy,
  I_GLAcctLineItmItmznRawData.GrpValnFixedPrcVarcInGlobCrcy AS GrpValnFixedPrcVarcInGlobCrcy,
  I_GLAcctLineItmItmznRawData.PrftCtrValnFxdPrcVarcInGlbCrcy AS PrftCtrValnFxdPrcVarcInGlbCrcy,
  I_GLAcctLineItmItmznRawData.FixedAmountInCoCodeCrcy AS FixedAmountInCoCodeCrcy,
  I_GLAcctLineItmItmznRawData.FixedAmountInTransCrcy AS FixedAmountInTransCrcy,
  I_GLAcctLineItmItmznRawData.ControllingObjectCurrency AS ControllingObjectCurrency,
  I_GLAcctLineItmItmznRawData.AmountInObjectCurrency AS AmountInObjectCurrency,
  I_GLAcctLineItmItmznRawData.GrantCurrency AS GrantCurrency,
  I_GLAcctLineItmItmznRawData.AmountInGrantCurrency AS AmountInGrantCurrency,
  I_GLAcctLineItmItmznRawData.BaseUnit AS BaseUnit,
  I_GLAcctLineItmItmznRawData.Quantity AS Quantity,
  I_GLAcctLineItmItmznRawData.FixedQuantity AS FixedQuantity,
  I_GLAcctLineItmItmznRawData.CostSourceUnit AS CostSourceUnit,
  I_GLAcctLineItmItmznRawData.ValuationQuantity AS ValuationQuantity,
  I_GLAcctLineItmItmznRawData.ValuationFixedQuantity AS ValuationFixedQuantity,
  I_GLAcctLineItmItmznRawData.ReferenceQuantityUnit AS ReferenceQuantityUnit,
  I_GLAcctLineItmItmznRawData.ReferenceQuantity AS ReferenceQuantity,
  I_GLAcctLineItmItmznRawData.AdditionalQuantity1Unit AS AdditionalQuantity1Unit,
  I_GLAcctLineItmItmznRawData.AdditionalQuantity1 AS AdditionalQuantity1,
  I_GLAcctLineItmItmznRawData.AdditionalQuantity2Unit AS AdditionalQuantity2Unit,
  I_GLAcctLineItmItmznRawData.AdditionalQuantity2 AS AdditionalQuantity2,
  I_GLAcctLineItmItmznRawData.AdditionalQuantity3Unit AS AdditionalQuantity3Unit,
  I_GLAcctLineItmItmznRawData.AdditionalQuantity3 AS AdditionalQuantity3,
  I_GLAcctLineItmItmznRawData.DebitCreditCode AS DebitCreditCode,
  I_GLAcctLineItmItmznRawData.FiscalPeriod AS FiscalPeriod,
  I_GLAcctLineItmItmznRawData.FiscalYearVariant AS FiscalYearVariant,
  I_GLAcctLineItmItmznRawData.FiscalYearPeriod AS FiscalYearPeriod,
  I_GLAcctLineItmItmznRawData.PostingDate AS PostingDate,
  I_GLAcctLineItmItmznRawData.DocumentDate AS DocumentDate,
  I_GLAcctLineItmItmznRawData.AccountingDocumentType AS AccountingDocumentType,
  I_GLAcctLineItmItmznRawData.AccountingDocumentItem AS AccountingDocumentItem,
  I_GLAcctLineItmItmznRawData.AssignmentReference AS AssignmentReference,
  I_GLAcctLineItmItmznRawData.AccountingDocumentCategory AS AccountingDocumentCategory,
  I_GLAcctLineItmItmznRawData.JournalEntryItemCategory AS JournalEntryItemCategory,
  I_GLAcctLineItmItmznRawData.PostingKey AS PostingKey,
  I_GLAcctLineItmItmznRawData.TransactionTypeDetermination AS TransactionTypeDetermination,
  I_GLAcctLineItmItmznRawData.SubLedgerAcctLineItemType AS SubLedgerAcctLineItemType,
  I_GLAcctLineItmItmznRawData.AccountingDocCreatedByUser AS AccountingDocCreatedByUser,
  I_GLAcctLineItmItmznRawData.LastChangeDateTime AS LastChangeDateTime,
  I_GLAcctLineItmItmznRawData.CreationDateTime AS CreationDateTime,
  I_GLAcctLineItmItmznRawData.CreationDate AS CreationDate,
  I_GLAcctLineItmItmznRawData.EliminationProfitCenter AS EliminationProfitCenter,
  I_GLAcctLineItmItmznRawData.OriginObjectType AS OriginObjectType,
  I_GLAcctLineItmItmznRawData.GLAccountType AS GLAccountType,
  I_GLAcctLineItmItmznRawData.AlternativeGLAccount AS AlternativeGLAccount,
  I_GLAcctLineItmItmznRawData.CountryChartOfAccounts AS CountryChartOfAccounts,
  I_GLAcctLineItmItmznRawData.ItemIsSplit AS ItemIsSplit,
  I_GLAcctLineItmItmznRawData.ConsolidationUnit AS ConsolidationUnit,
  I_GLAcctLineItmItmznRawData.PartnerConsolidationUnit AS PartnerConsolidationUnit,
  I_GLAcctLineItmItmznRawData.Company AS Company,
  I_GLAcctLineItmItmznRawData.ConsolidationChartOfAccounts AS ConsolidationChartOfAccounts,
  I_GLAcctLineItmItmznRawData.CnsldtnFinancialStatementItem AS CnsldtnFinancialStatementItem,
  I_GLAcctLineItmItmznRawData.CnsldtnSubitemCategory AS CnsldtnSubitemCategory,
  I_GLAcctLineItmItmznRawData.CnsldtnSubitem AS CnsldtnSubitem,
  I_GLAcctLineItmItmznRawData.InvoiceReference AS InvoiceReference,
  I_GLAcctLineItmItmznRawData.InvoiceReferenceFiscalYear AS InvoiceReferenceFiscalYear,
  I_GLAcctLineItmItmznRawData.FollowOnDocumentType AS FollowOnDocumentType,
  I_GLAcctLineItmItmznRawData.InvoiceItemReference AS InvoiceItemReference,
  I_GLAcctLineItmItmznRawData.ReferencePurchaseOrderCategory AS ReferencePurchaseOrderCategory,
  I_GLAcctLineItmItmznRawData.PurchasingDocument AS PurchasingDocument,
  I_GLAcctLineItmItmznRawData.PurchasingDocumentItem AS PurchasingDocumentItem,
  I_GLAcctLineItmItmznRawData.AccountAssignmentNumber AS AccountAssignmentNumber,
  I_GLAcctLineItmItmznRawData.DocumentItemText AS DocumentItemText,
  I_GLAcctLineItmItmznRawData.SalesDocument AS SalesDocument,
  I_GLAcctLineItmItmznRawData.SalesDocumentItem AS SalesDocumentItem,
  I_GLAcctLineItmItmznRawData.Product AS Product,
  I_GLAcctLineItmItmznRawData.Plant AS Plant,
  I_GLAcctLineItmItmznRawData.Supplier AS Supplier,
  I_GLAcctLineItmItmznRawData.Customer AS Customer,
  I_GLAcctLineItmItmznRawData.ServicesRenderedDate AS ServicesRenderedDate,
  I_GLAcctLineItmItmznRawData.ConditionContract AS ConditionContract,
  I_GLAcctLineItmItmznRawData.FinancialAccountType AS FinancialAccountType,
  I_GLAcctLineItmItmznRawData.SpecialGLCode AS SpecialGLCode,
  I_GLAcctLineItmItmznRawData.TaxCode AS TaxCode,
  I_GLAcctLineItmItmznRawData.TaxCountry AS TaxCountry,
  I_GLAcctLineItmItmznRawData.HouseBank AS HouseBank,
  I_GLAcctLineItmItmznRawData.HouseBankAccount AS HouseBankAccount,
  I_GLAcctLineItmItmznRawData.IsOpenItemManaged AS IsOpenItemManaged,
  I_GLAcctLineItmItmznRawData.ClearingDate AS ClearingDate,
  I_GLAcctLineItmItmznRawData.ClearingJournalEntryFiscalYear AS ClearingJournalEntryFiscalYear,
  I_GLAcctLineItmItmznRawData.ClearingJournalEntry AS ClearingJournalEntry,
  I_GLAcctLineItmItmznRawData.ValueDate AS ValueDate,
  I_GLAcctLineItmItmznRawData.GeneralLedgerAgingScope AS GeneralLedgerAgingScope,
  I_GLAcctLineItmItmznRawData.GeneralLedgerAgingIncrement AS GeneralLedgerAgingIncrement,
  I_GLAcctLineItmItmznRawData.AssetDepreciationArea AS AssetDepreciationArea,
  I_GLAcctLineItmItmznRawData.MasterFixedAsset AS MasterFixedAsset,
  I_GLAcctLineItmItmznRawData.FixedAsset AS FixedAsset,
  I_GLAcctLineItmItmznRawData.AssetValueDate AS AssetValueDate,
  I_GLAcctLineItmItmznRawData.AssetTransactionType AS AssetTransactionType,
  I_GLAcctLineItmItmznRawData.AssetAcctTransClassfctn AS AssetAcctTransClassfctn,
  I_GLAcctLineItmItmznRawData.DepreciationFiscalPeriod AS DepreciationFiscalPeriod,
  I_GLAcctLineItmItmznRawData.GroupMasterFixedAsset AS GroupMasterFixedAsset,
  I_GLAcctLineItmItmznRawData.GroupFixedAsset AS GroupFixedAsset,
  I_GLAcctLineItmItmznRawData.AssetClass AS AssetClass,
  I_GLAcctLineItmItmznRawData.PartnerMasterFixedAsset AS PartnerMasterFixedAsset,
  I_GLAcctLineItmItmznRawData.PartnerFixedAsset AS PartnerFixedAsset,
  I_GLAcctLineItmItmznRawData.CostEstimate AS CostEstimate,
  I_GLAcctLineItmItmznRawData.InventorySpecialStockValnType AS InvtrySpecialStockValnType_2,
  I_GLAcctLineItmItmznRawData.IsSupplierStockValuation AS IsSupplierStockValuation,
  I_GLAcctLineItmItmznRawData.InventorySpecialStockType AS InventorySpecialStockType,
  I_GLAcctLineItmItmznRawData.InventorySpclStkSalesDocument AS InventorySpclStkSalesDocument,
  I_GLAcctLineItmItmznRawData.InventorySpclStkSalesDocItm AS InventorySpclStkSalesDocItm,
  I_GLAcctLineItmItmznRawData.InvtrySpclStockWBSElmntIntID AS InvtrySpclStockWBSElmntIntID,
  I_GLAcctLineItmItmznRawData.InventorySpecialStockSupplier AS InventorySpecialStockSupplier,
  I_GLAcctLineItmItmznRawData.InventoryValuationType AS InventoryValuationType,
  I_GLAcctLineItmItmznRawData.ValuationArea AS ValuationArea,
  I_GLAcctLineItmItmznRawData.MaterialLedgerProcessType AS MaterialLedgerProcessType,
  I_GLAcctLineItmItmznRawData.MaterialLedgerCategory AS MaterialLedgerCategory,
  I_GLAcctLineItmItmznRawData.SlsPriceAmountInCoCodeCrcy AS SlsPriceAmountInCoCodeCrcy,
  I_GLAcctLineItmItmznRawData.ProductPriceControl AS ProductPriceControl,
  I_GLAcctLineItmItmznRawData.SenderCompanyCode AS SenderCompanyCode,
  I_GLAcctLineItmItmznRawData.SenderGLAccount AS SenderGLAccount,
  I_GLAcctLineItmItmznRawData.SenderAccountAssignment AS SenderAccountAssignment,
  I_GLAcctLineItmItmznRawData.SenderAccountAssignmentType AS SenderAccountAssignmentType,
  I_GLAcctLineItmItmznRawData.ControllingObject AS ControllingObject,
  I_GLAcctLineItmItmznRawData.CostOriginGroup AS CostOriginGroup,
  I_GLAcctLineItmItmznRawData.OriginSenderObject AS OriginSenderObject,
  I_GLAcctLineItmItmznRawData.ControllingDebitCreditCode AS ControllingDebitCreditCode,
  I_GLAcctLineItmItmznRawData.ControllingObjectDebitType AS ControllingObjectDebitType,
  I_GLAcctLineItmItmznRawData.QuantityIsIncomplete AS QuantityIsIncomplete,
  I_GLAcctLineItmItmznRawData.OffsettingAccount AS OffsettingAccount,
  I_GLAcctLineItmItmznRawData.OffsettingAccountType AS OffsettingAccountType,
  I_GLAcctLineItmItmznRawData.OffsettingChartOfAccounts AS OffsettingChartOfAccounts,
  I_GLAcctLineItmItmznRawData.LineItemIsCompleted AS LineItemIsCompleted,
  I_GLAcctLineItmItmznRawData.PersonnelNumber AS PersonnelNumber,
  I_GLAcctLineItmItmznRawData.ControllingObjectClass AS ControllingObjectClass,
  I_GLAcctLineItmItmznRawData.PartnerCompanyCode AS PartnerCompanyCode,
  I_GLAcctLineItmItmznRawData.PartnerControllingObjectClass AS PartnerControllingObjectClass,
  I_GLAcctLineItmItmznRawData.OriginCostCenter AS OriginCostCenter,
  I_GLAcctLineItmItmznRawData.OriginProfitCenter AS OriginProfitCenter,
  I_GLAcctLineItmItmznRawData.OriginCostCtrActivityType AS OriginCostCtrActivityType,
  I_GLAcctLineItmItmznRawData.OriginProduct AS OriginProduct,
  I_GLAcctLineItmItmznRawData.VarianceOriginGLAccount AS VarianceOriginGLAccount,
  I_GLAcctLineItmItmznRawData.AccountAssignment AS AccountAssignment,
  I_GLAcctLineItmItmznRawData.AccountAssignmentType AS AccountAssignmentType,
  I_GLAcctLineItmItmznRawData.CostCtrActivityType AS CostCtrActivityType,
  I_GLAcctLineItmItmznRawData.OrderID AS OrderID,
  I_GLAcctLineItmItmznRawData.OrderCategory AS OrderCategory,
  I_GLAcctLineItmItmznRawData.WBSElementInternalID AS WBSElementInternalID,
  I_GLAcctLineItmItmznRawData.PartnerWBSElementInternalID AS PartnerWBSElementInternalID,
  I_GLAcctLineItmItmznRawData.ProjectInternalID AS ProjectInternalID,
  I_GLAcctLineItmItmznRawData.PartnerProjectInternalID AS PartnerProjectInternalID,
  I_GLAcctLineItmItmznRawData.OperatingConcern AS OperatingConcern,
  I_GLAcctLineItmItmznRawData.ProjectNetwork AS ProjectNetwork,
  I_GLAcctLineItmItmznRawData.RelatedNetworkActivity AS RelatedNetworkActivity,
  I_GLAcctLineItmItmznRawData.BusinessProcess AS BusinessProcess,
  I_GLAcctLineItmItmznRawData.CostObject AS CostObject,
  I_GLAcctLineItmItmznRawData.BillableControl AS BillableControl,
  I_GLAcctLineItmItmznRawData.CostAnalysisResource AS CostAnalysisResource,
  I_GLAcctLineItmItmznRawData.CustomerServiceNotification AS CustomerServiceNotification,
  I_GLAcctLineItmItmznRawData.ServiceDocumentType AS ServiceDocumentType,
  I_GLAcctLineItmItmznRawData.ServiceDocument AS ServiceDocument,
  I_GLAcctLineItmItmznRawData.ServiceDocumentItem AS ServiceDocumentItem,
  I_GLAcctLineItmItmznRawData.PartnerServiceDocumentType AS PartnerServiceDocumentType,
  I_GLAcctLineItmItmznRawData.PartnerServiceDocument AS PartnerServiceDocument,
  I_GLAcctLineItmItmznRawData.PartnerServiceDocumentItem AS PartnerServiceDocumentItem,
  I_GLAcctLineItmItmznRawData.ServiceContractType AS ServiceContractType,
  I_GLAcctLineItmItmznRawData.ServiceContract AS ServiceContract,
  I_GLAcctLineItmItmznRawData.ServiceContractItem AS ServiceContractItem,
  I_GLAcctLineItmItmznRawData.BusinessSolutionOrder AS BusinessSolutionOrder,
  I_GLAcctLineItmItmznRawData.BusinessSolutionOrderItem AS BusinessSolutionOrderItem,
  I_GLAcctLineItmItmznRawData.ProviderContract AS ProviderContract,
  I_GLAcctLineItmItmznRawData.ProviderContractItem AS ProviderContractItem,
  I_GLAcctLineItmItmznRawData.RevenueAccountingContract AS RevenueAccountingContract,
  I_GLAcctLineItmItmznRawData.PerformanceObligation AS PerformanceObligation,
  I_GLAcctLineItmItmznRawData.TimeSheetOvertimeCategory AS TimeSheetOvertimeCategory,
  I_GLAcctLineItmItmznRawData.PartnerAccountAssignment AS PartnerAccountAssignment,
  I_GLAcctLineItmItmznRawData.PartnerAccountAssignmentType AS PartnerAccountAssignmentType,
  I_GLAcctLineItmItmznRawData.WorkPackage AS WorkPackage,
  I_GLAcctLineItmItmznRawData.WorkItem AS WorkItem,
  I_GLAcctLineItmItmznRawData.PartnerCostCtrActivityType AS PartnerCostCtrActivityType,
  I_GLAcctLineItmItmznRawData.PartnerOrderCategory AS PartnerOrderCategory,
  I_GLAcctLineItmItmznRawData.PartnerSalesDocument AS PartnerSalesDocument,
  I_GLAcctLineItmItmznRawData.PartnerSalesDocumentItem AS PartnerSalesDocumentItem,
  I_GLAcctLineItmItmznRawData.PartnerProjectNetwork AS PartnerProjectNetwork,
  I_GLAcctLineItmItmznRawData.PartnerProjectNetworkActivity AS PartnerProjectNetworkActivity,
  I_GLAcctLineItmItmznRawData.PartnerBusinessProcess AS PartnerBusinessProcess,
  I_GLAcctLineItmItmznRawData.PartnerCostObject AS PartnerCostObject,
  I_GLAcctLineItmItmznRawData.ControllingDocumentItem AS ControllingDocumentItem,
  I_GLAcctLineItmItmznRawData.BillingDocumentType AS BillingDocumentType,
  I_GLAcctLineItmItmznRawData.SalesOrganization AS SalesOrganization,
  I_GLAcctLineItmItmznRawData.DistributionChannel AS DistributionChannel,
  I_GLAcctLineItmItmznRawData.OrganizationDivision AS OrganizationDivision,
  I_GLAcctLineItmItmznRawData.SoldProduct AS SoldProduct,
  I_GLAcctLineItmItmznRawData.SoldProductGroup AS SoldProductGroup,
  I_GLAcctLineItmItmznRawData.CustomerGroup AS CustomerGroup,
  I_GLAcctLineItmItmznRawData.CustomerSupplierCountry AS CustomerSupplierCountry,
  I_GLAcctLineItmItmznRawData.CustomerSupplierIndustry AS CustomerSupplierIndustry,
  I_GLAcctLineItmItmznRawData.SalesDistrict AS SalesDistrict,
  I_GLAcctLineItmItmznRawData.BillToParty AS BillToParty,
  I_GLAcctLineItmItmznRawData.ShipToParty AS ShipToParty,
  I_GLAcctLineItmItmznRawData.CustomerSupplierCorporateGroup AS CustomerSupplierCorporateGroup,
  I_GLAcctLineItmItmznRawData.CashLedgerCompanyCode AS CashLedgerCompanyCode,
  I_GLAcctLineItmItmznRawData.CashLedgerAccount AS CashLedgerAccount,
  I_GLAcctLineItmItmznRawData.FinancialManagementArea AS FinancialManagementArea,
  I_GLAcctLineItmItmznRawData.CommitmentItem AS CommitmentItem,
  I_GLAcctLineItmItmznRawData.FundsCenter AS FundsCenter,
  I_GLAcctLineItmItmznRawData.FundedProgram AS FundedProgram,
  I_GLAcctLineItmItmznRawData.Fund AS Fund,
  I_GLAcctLineItmItmznRawData.GrantID AS GrantID,
  I_GLAcctLineItmItmznRawData.BudgetPeriod AS BudgetPeriod,
  I_GLAcctLineItmItmznRawData.PartnerFund AS PartnerFund,
  I_GLAcctLineItmItmznRawData.PartnerGrant AS PartnerGrant,
  I_GLAcctLineItmItmznRawData.PartnerBudgetPeriod AS PartnerBudgetPeriod,
  I_GLAcctLineItmItmznRawData.PubSecBudgetAccount AS PubSecBudgetAccount,
  I_GLAcctLineItmItmznRawData.PubSecBudgetAccountCoCode AS PubSecBudgetAccountCoCode,
  I_GLAcctLineItmItmznRawData.PubSecBudgetCnsmpnDate AS PubSecBudgetCnsmpnDate,
  I_GLAcctLineItmItmznRawData.PubSecBudgetCnsmpnFsclPeriod AS PubSecBudgetCnsmpnFsclPeriod,
  I_GLAcctLineItmItmznRawData.PubSecBudgetCnsmpnFsclYear AS PubSecBudgetCnsmpnFsclYear,
  I_GLAcctLineItmItmznRawData.PubSecBudgetIsRelevant AS PubSecBudgetIsRelevant,
  I_GLAcctLineItmItmznRawData.PubSecBudgetCnsmpnType AS PubSecBudgetCnsmpnType,
  I_GLAcctLineItmItmznRawData.PubSecBudgetCnsmpnAmtType AS PubSecBudgetCnsmpnAmtType,
  I_GLAcctLineItmItmznRawData.SponsoredProgram AS SponsoredProgram,
  I_GLAcctLineItmItmznRawData.SponsoredClass AS SponsoredClass,
  I_GLAcctLineItmItmznRawData.GteeMBudgetValidityNumber AS GteeMBudgetValidityNumber,
  I_GLAcctLineItmItmznRawData.EarmarkedFundsDocument AS EarmarkedFundsDocument,
  I_GLAcctLineItmItmznRawData.EarmarkedFundsDocumentItem AS EarmarkedFundsDocumentItem,
  I_GLAcctLineItmItmznRawData.FinancialServicesProductGroup AS FinancialServicesProductGroup,
  I_GLAcctLineItmItmznRawData.FinancialServicesBranch AS FinancialServicesBranch,
  I_GLAcctLineItmItmznRawData.FinancialDataSource AS FinancialDataSource,
  I_GLAcctLineItmItmznRawData.JointVenture AS JointVenture,
  I_GLAcctLineItmItmznRawData.JointVentureEquityGroup AS JointVentureEquityGroup,
  I_GLAcctLineItmItmznRawData.JointVentureCostRecoveryCode AS JointVentureCostRecoveryCode,
  I_GLAcctLineItmItmznRawData.JointVenturePartner AS JointVenturePartner,
  I_GLAcctLineItmItmznRawData.JointVentureBillingType AS JointVentureBillingType,
  I_GLAcctLineItmItmznRawData.JointVentureEquityType AS JointVentureEquityType,
  I_GLAcctLineItmItmznRawData.JointVentureProductionDate AS JointVentureProductionDate,
  I_GLAcctLineItmItmznRawData.JointVentureBillingDate AS JointVentureBillingDate,
  I_GLAcctLineItmItmznRawData.JointVentureOperationalDate AS JointVentureOperationalDate,
  I_GLAcctLineItmItmznRawData.CutbackRun AS CutbackRun,
  I_GLAcctLineItmItmznRawData.JointVentureAccountingActivity AS JointVentureAccountingActivity,
  I_GLAcctLineItmItmznRawData.PartnerVenture AS PartnerVenture,
  I_GLAcctLineItmItmznRawData.PartnerEquityGroup AS PartnerEquityGroup,
  I_GLAcctLineItmItmznRawData.SenderCostRecoveryCode AS SenderCostRecoveryCode,
  I_GLAcctLineItmItmznRawData.CutbackAccount AS CutbackAccount,
  I_GLAcctLineItmItmznRawData.CutbackCostObject AS CutbackCostObject,
  I_GLAcctLineItmItmznRawData.REBusinessEntity AS REBusinessEntity,
  I_GLAcctLineItmItmznRawData.RealEstateBuilding AS RealEstateBuilding,
  I_GLAcctLineItmItmznRawData.RealEstateProperty AS RealEstateProperty,
  I_GLAcctLineItmItmznRawData.RERentalObject AS RERentalObject,
  I_GLAcctLineItmItmznRawData.RealEstateContract AS RealEstateContract,
  I_GLAcctLineItmItmznRawData.REServiceChargeKey AS REServiceChargeKey,
  I_GLAcctLineItmItmznRawData.RESettlementUnitID AS RESettlementUnitID,
  I_GLAcctLineItmItmznRawData.SettlementReferenceDate AS SettlementReferenceDate,
  I_GLAcctLineItmItmznRawData.REPartnerBusinessEntity AS REPartnerBusinessEntity,
  I_GLAcctLineItmItmznRawData.RealEstatePartnerBuilding AS RealEstatePartnerBuilding,
  I_GLAcctLineItmItmznRawData.RealEstatePartnerProperty AS RealEstatePartnerProperty,
  I_GLAcctLineItmItmznRawData.REPartnerRentalObject AS REPartnerRentalObject,
  I_GLAcctLineItmItmznRawData.RealEstatePartnerContract AS RealEstatePartnerContract,
  I_GLAcctLineItmItmznRawData.REPartnerServiceChargeKey AS REPartnerServiceChargeKey,
  I_GLAcctLineItmItmznRawData.REPartnerSettlementUnitID AS REPartnerSettlementUnitID,
  I_GLAcctLineItmItmznRawData.PartnerSettlementReferenceDate AS PartnerSettlementReferenceDate,
  I_GLAcctLineItmItmznRawData.AccrualObjectType AS AccrualObjectType,
  I_GLAcctLineItmItmznRawData.AccrualObjectLogicalSystem AS AccrualObjectLogicalSystem,
  I_GLAcctLineItmItmznRawData.AccrualObject AS AccrualObject,
  I_GLAcctLineItmItmznRawData.AccrualSubobject AS AccrualSubobject,
  I_GLAcctLineItmItmznRawData.AccrualItemType AS AccrualItemType,
  I_GLAcctLineItmItmznRawData.AccrualReferenceObject AS AccrualReferenceObject,
  I_GLAcctLineItmItmznRawData.AccrualValueDate AS AccrualValueDate,
  I_GLAcctLineItmItmznRawData.FinancialValuationObjectType AS FinancialValuationObjectType,
  I_GLAcctLineItmItmznRawData.FinancialValuationObject AS FinancialValuationObject,
  I_GLAcctLineItmItmznRawData.FinancialValuationSubobject AS FinancialValuationSubobject,
  I_GLAcctLineItmItmznRawData.NetDueDate AS NetDueDate,
  I_GLAcctLineItmItmznRawData.CreditRiskClass AS CreditRiskClass,
  I_GLAcctLineItmItmznRawData.WorkCenterInternalID AS WorkCenterInternalID,
  I_GLAcctLineItmItmznRawData.OrderOperation AS OrderOperation,
  I_GLAcctLineItmItmznRawData.OrderItem AS OrderItem,
  I_GLAcctLineItmItmznRawData.PartnerOrderItem AS PartnerOrderItem,
  I_GLAcctLineItmItmznRawData.OrderSuboperation AS OrderSuboperation,
  I_GLAcctLineItmItmznRawData.Equipment AS Equipment,
  I_GLAcctLineItmItmznRawData.FunctionalLocation AS FunctionalLocation,
  I_GLAcctLineItmItmznRawData.Assembly AS Assembly,
  I_GLAcctLineItmItmznRawData.MaintenanceActivityType AS MaintenanceActivityType,
  I_GLAcctLineItmItmznRawData.MaintenanceOrderPlanningCode AS MaintenanceOrderPlanningCode,
  I_GLAcctLineItmItmznRawData.MaintPriorityType AS MaintPriorityType,
  I_GLAcctLineItmItmznRawData.MaintPriority AS MaintPriority,
  I_GLAcctLineItmItmznRawData.SuperiorOrder AS SuperiorOrder,
  I_GLAcctLineItmItmznRawData.ProductGroup AS ProductGroup,
  I_GLAcctLineItmItmznRawData.MaintenanceOrderIsPlanned AS MaintenanceOrderIsPlanned,
  I_GLAcctLineItmItmznRawData.JrnlEntryItemMigrationSource AS JrnlEntryItemMigrationSource,
  I_GLAcctLineItmItmznRawData._CalendarDate AS _CalendarDate,
  I_GLAcctLineItmItmznRawData._FunctionalCurrency AS _FunctionalCurrency,
  I_GLAcctLineItmItmznRawData._ReferenceQuantityUnit AS _ReferenceQuantityUnit,
  I_GLAcctLineItmItmznRawData._OriginProduct AS _OriginProduct,
  I_GLAcctLineItmItmznRawData._CustomerCompany AS _CustomerCompany,
  I_GLAcctLineItmItmznRawData._SupplierCompany AS _SupplierCompany,
  I_GLAcctLineItmItmznRawData._BusinessTransactionCategory AS _BusinessTransactionCategory,
  I_GLAcctLineItmItmznRawData._TaxCountry AS _TaxCountry,
  I_GLAcctLineItmItmznRawData._PartnerMasterFixedAsset AS _PartnerMasterFixedAsset,
  I_GLAcctLineItmItmznRawData._PartnerFixedAsset AS _PartnerFixedAsset,
  I_GLAcctLineItmItmznRawData._CashLedgerCompanyCode AS _CashLedgerCompanyCode,
  I_GLAcctLineItmItmznRawData._CashLedgerAccount AS _CashLedgerAccount,
  I_GLAcctLineItmItmznRawData._FinancialManagementArea AS _FinancialManagementArea,
  I_GLAcctLineItmItmznRawData._FundsCenter AS _FundsCenter,
  I_GLAcctLineItmItmznRawData._FundedProgram AS _FundedProgram,
  I_GLAcctLineItmItmznRawData._Grant AS _Grant,
  I_GLAcctLineItmItmznRawData._PartnerGrant AS _PartnerGrant,
  I_GLAcctLineItmItmznRawData._PartnerBudgetPeriod AS _PartnerBudgetPeriod,
  I_GLAcctLineItmItmznRawData._PubSecBudgetAccountCoCode AS _PubSecBudgetAccountCoCode,
  I_GLAcctLineItmItmznRawData._PubSecBudgetAccount AS _PubSecBudgetAccount,
  I_GLAcctLineItmItmznRawData._PubSecBudgetCnsmpnDate AS _PubSecBudgetCnsmpnDate,
  I_GLAcctLineItmItmznRawData._PubSecBudgetCnsmpnFsclPeriod AS _PubSecBudgetCnsmpnFsclPeriod,
  I_GLAcctLineItmItmznRawData._PubSecBudgetCnsmpnFsclYear AS _PubSecBudgetCnsmpnFsclYear,
  I_GLAcctLineItmItmznRawData._PubSecBudgetCnsmpnType AS _PubSecBudgetCnsmpnType,
  I_GLAcctLineItmItmznRawData._PubSecBudgetCnsmpnAmtType AS _PubSecBudgetCnsmpnAmtType,
  I_GLAcctLineItmItmznRawData._ConsolidationUnit AS _ConsolidationUnit,
  I_GLAcctLineItmItmznRawData._PartnerConsolidationUnit AS _PartnerConsolidationUnit,
  I_GLAcctLineItmItmznRawData._Company AS _Company,
  I_GLAcctLineItmItmznRawData._ConsolidationChartOfAccounts AS _ConsolidationChartOfAccounts,
  I_GLAcctLineItmItmznRawData._CnsldtnFinancialStatementItem AS _CnsldtnFinancialStatementItem,
  I_GLAcctLineItmItmznRawData._CnsldtnSubitemCategory AS _CnsldtnSubitemCategory,
  I_GLAcctLineItmItmznRawData._CnsldtnSubitem AS _CnsldtnSubitem,
  I_GLAcctLineItmItmznRawData._ProviderContract AS _ProviderContract,
  I_GLAcctLineItmItmznRawData._ProviderContractItem AS _ProviderContractItem,
  I_LedgerSourceLedger.Ledger AS Ledger
FROM I_GLAcctLineItmItmznRawData
INNER JOIN I_LedgerSourceLedger ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_JournalEntry AS _JournalEntry ON CompanyCode = _JournalEntry.CompanyCode AND FiscalYear = _JournalEntry.FiscalYear AND AccountingDocument = _JournalEntry.AccountingDocument  -- association [0..1]
LEFT OUTER JOIN I_CompanyCode AS _CompanyCode ON CompanyCode = _CompanyCode.CompanyCode  -- association [1..1]
LEFT OUTER JOIN I_CompanyCode AS _CompanyCodeText ON CompanyCode = _CompanyCodeText.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_FiscalYearVariant AS _FiscalYearVariant ON FiscalYearVariant = _FiscalYearVariant.FiscalYearVariant  -- association [1..1]
LEFT OUTER JOIN I_FiscalYearForCompanyCode AS _FiscalYear ON FiscalYear = _FiscalYear.FiscalYear AND CompanyCode = _FiscalYear.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_FiscalYearForCompanyCode AS _LedgerFiscalYear ON LedgerFiscalYear = _LedgerFiscalYear.FiscalYear AND CompanyCode = _LedgerFiscalYear.CompanyCode  -- association [0..1]
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_FiscalCalYearPeriodForCoCode AS _FiscalYearPeriod ON FiscalYearPeriod = _FiscalYearPeriod.FiscalYearPeriod AND CompanyCode = _FiscalYearPeriod.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_FiscalYearForVariant AS _LedgerFiscalYearForVariant ON LedgerFiscalYear = _LedgerFiscalYearForVariant.FiscalYear AND FiscalYearVariant = _LedgerFiscalYearForVariant.FiscalYearVariant  -- 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_FiscalYearPeriodForVariant AS _FiscalYearPeriodForVariant ON FiscalYearPeriod = _FiscalYearPeriodForVariant.FiscalYearPeriod AND FiscalYearVariant = _FiscalYearPeriodForVariant.FiscalYearVariant  -- association [0..1]
LEFT OUTER JOIN I_FiscalCalendarDate AS _FiscalCalendarDate ON PostingDate = _FiscalCalendarDate.CalendarDate AND FiscalYearVariant = _FiscalCalendarDate.FiscalYearVariant  -- association [0..1]
LEFT OUTER JOIN I_ControllingArea AS _ControllingArea ON ControllingArea = _ControllingArea.ControllingArea  -- association [0..1]
LEFT OUTER JOIN I_ControllingArea AS _ControllingAreaText ON ControllingArea = _ControllingAreaText.ControllingArea  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _BalanceTransactionCurrency ON BalanceTransactionCurrency = _BalanceTransactionCurrency.Currency  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _TransactionCurrency ON TransactionCurrency = _TransactionCurrency.Currency  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _CompanyCodeCurrency ON CompanyCodeCurrency = _CompanyCodeCurrency.Currency  -- association [1..1]
LEFT OUTER JOIN I_Currency AS _GlobalCurrency ON GlobalCurrency = _GlobalCurrency.Currency  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _FreeDefinedCurrency1 ON FreeDefinedCurrency1 = _FreeDefinedCurrency1.Currency  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _FreeDefinedCurrency2 ON FreeDefinedCurrency2 = _FreeDefinedCurrency2.Currency  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _FreeDefinedCurrency3 ON FreeDefinedCurrency3 = _FreeDefinedCurrency3.Currency  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _FreeDefinedCurrency4 ON FreeDefinedCurrency4 = _FreeDefinedCurrency4.Currency  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _FreeDefinedCurrency5 ON FreeDefinedCurrency5 = _FreeDefinedCurrency5.Currency  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _FreeDefinedCurrency6 ON FreeDefinedCurrency6 = _FreeDefinedCurrency6.Currency  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _FreeDefinedCurrency7 ON FreeDefinedCurrency7 = _FreeDefinedCurrency7.Currency  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _FreeDefinedCurrency8 ON FreeDefinedCurrency8 = _FreeDefinedCurrency8.Currency  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _BaseUnit ON BaseUnit = _BaseUnit.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _CostSourceUnit ON CostSourceUnit = _CostSourceUnit.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _AdditionalQuantity1Unit ON AdditionalQuantity1Unit = _AdditionalQuantity1Unit.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _AdditionalQuantity2Unit ON AdditionalQuantity2Unit = _AdditionalQuantity2Unit.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _AdditionalQuantity3Unit ON AdditionalQuantity3Unit = _AdditionalQuantity3Unit.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN I_Segment AS _Segment ON Segment = _Segment.Segment  -- association [0..1]
LEFT OUTER JOIN I_SegmentText AS _SegmentText ON Segment = _SegmentText.Segment  -- association [0..*]
LEFT OUTER JOIN I_ProfitCenter AS _ProfitCenter ON ControllingArea = _ProfitCenter.ControllingArea AND ProfitCenter = _ProfitCenter.ProfitCenter  -- association [0..*]
LEFT OUTER JOIN I_ProfitCenterText AS _ProfitCenterText ON ControllingArea = _ProfitCenterText.ControllingArea AND ProfitCenter = _ProfitCenterText.ProfitCenter  -- association [0..*]
LEFT OUTER JOIN I_ProfitCenter AS _CurrentProfitCenter ON ControllingArea = _CurrentProfitCenter.ControllingArea AND ProfitCenter = _CurrentProfitCenter.ProfitCenter AND _CurrentProfitCenter.ValidityStartDate <= $session.system_date AND _CurrentProfitCenter.ValidityEndDate >= $session.system_date  -- association [0..1]
LEFT OUTER JOIN I_CostCenter AS _CostCenter ON ControllingArea = _CostCenter.ControllingArea AND CostCenter = _CostCenter.CostCenter  -- association [0..*]
LEFT OUTER JOIN I_CostCenterText AS _CostCenterText ON ControllingArea = _CostCenterText.ControllingArea AND CostCenter = _CostCenterText.CostCenter  -- association [0..*]
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]
LEFT OUTER JOIN I_Project AS _Project ON Project = _Project.Project  -- association [0..1]
LEFT OUTER JOIN I_Project AS _ProjectText ON Project = _ProjectText.Project  -- association [0..1]
LEFT OUTER JOIN I_Project AS _PartnerProject ON PartnerProject = _PartnerProject.Project  -- association [0..1]
LEFT OUTER JOIN I_Project AS _PartnerProjectText ON PartnerProject = _PartnerProjectText.Project  -- association [0..1]
LEFT OUTER JOIN I_ProjectByInternalKey AS _ProjectInternalID ON ProjectInternalID = _ProjectInternalID.ProjectInternalID  -- association [0..1]
LEFT OUTER JOIN I_ProjectByInternalKey AS _ProjectInternalIDText ON ProjectInternalID = _ProjectInternalIDText.ProjectInternalID  -- association [0..1]
LEFT OUTER JOIN I_ProjectBasicData AS _PartnerProjectInternalID ON PartnerProjectInternalID = _PartnerProjectInternalID.ProjectInternalID  -- association [0..1]
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_ProjectBasicData AS _PartnerProjectBasicData ON PartnerProjectInternalID = _PartnerProjectBasicData.ProjectInternalID  -- association [0..1]
LEFT OUTER JOIN I_ProjectBasicData AS _PartnerProjectBasicDataText ON PartnerProjectInternalID = _PartnerProjectBasicDataText.ProjectInternalID  -- association [0..1]
LEFT OUTER JOIN I_WBSElement AS _WBSElement ON WBSElement = _WBSElement.WBSElement  -- association [0..1]
LEFT OUTER JOIN I_WBSElement AS _WBSElementText ON WBSElement = _WBSElementText.WBSElement  -- association [0..1]
LEFT OUTER JOIN I_WBSElement AS _PartnerWBSElement ON PartnerWBSElement = _PartnerWBSElement.WBSElement  -- association [0..1]
LEFT OUTER JOIN I_WBSElement AS _PartnerWBSElementText ON PartnerWBSElement = _PartnerWBSElementText.WBSElement  -- association [0..1]
LEFT OUTER JOIN I_WBSElement AS _InventorySpclStockWBSElement ON InventorySpclStockWBSElement = _InventorySpclStockWBSElement.WBSElement  -- association [0..1]
LEFT OUTER JOIN I_WBSElement AS _InvtrySpclStockWBSElmntText ON InventorySpclStockWBSElement = _InvtrySpclStockWBSElmntText.WBSElement  -- association [0..1]
LEFT OUTER JOIN I_WBSElementByInternalKey AS _WBSElementInternalID ON WBSElementInternalID = _WBSElementInternalID.WBSElementInternalID  -- association [0..1]
LEFT OUTER JOIN I_WBSElementByInternalKey AS _WBSElementInternalIDText ON WBSElementInternalID = _WBSElementInternalIDText.WBSElementInternalID  -- association [0..1]
LEFT OUTER JOIN I_WBSElementByInternalKey AS _InvtrySpclStockWBSElmntIntID ON InvtrySpclStockWBSElmntIntID = _InvtrySpclStockWBSElmntIntID.WBSElementInternalID  -- 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_WBSElementBasicData AS _PartnerWBSElementBasicData ON PartnerWBSElementInternalID = _PartnerWBSElementBasicData.WBSElementInternalID  -- association [0..1]
LEFT OUTER JOIN I_WBSElementBasicData AS _PartnerWBSElmntBasicDataText ON PartnerWBSElementInternalID = _PartnerWBSElmntBasicDataText.WBSElementInternalID  -- association [0..1]
LEFT OUTER JOIN I_WBSElementBasicData AS _InvtrySpclStkWBSElmntBscData ON InvtrySpclStockWBSElmntIntID = _InvtrySpclStkWBSElmntBscData.WBSElementInternalID  -- association [0..1]
LEFT OUTER JOIN I_WBSElementBasicData AS _InvtrySpclStkWBSElmntBscDataT ON InvtrySpclStockWBSElmntIntID = _InvtrySpclStkWBSElmntBscDataT.WBSElementInternalID  -- association [0..1]
LEFT OUTER JOIN I_BusinessArea AS _BusinessArea ON BusinessArea = _BusinessArea.BusinessArea  -- association [0..1]
LEFT OUTER JOIN I_BusinessAreaText AS _BusinessAreaText ON BusinessArea = _BusinessAreaText.BusinessArea  -- association [0..*]
LEFT OUTER JOIN I_FunctionalArea AS _FunctionalArea ON FunctionalArea = _FunctionalArea.FunctionalArea  -- association [0..1]
LEFT OUTER JOIN I_FunctionalAreaText AS _FunctionalAreaText ON FunctionalArea = _FunctionalAreaText.FunctionalArea  -- association [0..*]
LEFT OUTER JOIN I_GLAccountInChartOfAccounts AS _GLAccountInChartOfAccounts ON ChartOfAccounts = _GLAccountInChartOfAccounts.ChartOfAccounts AND GLAccount = _GLAccountInChartOfAccounts.GLAccount  -- association [0..1]
LEFT OUTER JOIN I_GLAccountText AS _GLAcctInChartOfAccountsText ON ChartOfAccounts = _GLAcctInChartOfAccountsText.ChartOfAccounts AND GLAccount = _GLAcctInChartOfAccountsText.GLAccount  -- association [0..*]
LEFT OUTER JOIN I_GLAccountInCompanyCode AS _GLAccountInCompanyCode ON CompanyCode = _GLAccountInCompanyCode.CompanyCode AND GLAccount = _GLAccountInCompanyCode.GLAccount  -- association [0..1]
LEFT OUTER JOIN I_ChartOfAccounts AS _ChartOfAccounts ON ChartOfAccounts = _ChartOfAccounts.ChartOfAccounts  -- association [0..1]
LEFT OUTER JOIN I_ChartOfAccountsText AS _ChartOfAccountsText ON ChartOfAccounts = _ChartOfAccountsText.ChartOfAccounts  -- association [0..*]
LEFT OUTER JOIN I_AccountingDocumentType AS _AccountingDocumentType ON AccountingDocumentType = _AccountingDocumentType.AccountingDocumentType  -- association [0..1]
LEFT OUTER JOIN I_AccountingDocumentTypeText AS _AccountingDocumentTypeText ON AccountingDocumentType = _AccountingDocumentTypeText.AccountingDocumentType  -- association [0..*]
LEFT OUTER JOIN I_FinancialAccountType AS _FinancialAccountType ON FinancialAccountType = _FinancialAccountType.FinancialAccountType  -- association [0..1]
LEFT OUTER JOIN I_FinancialAccountTypeText AS _FinancialAccountTypeText ON FinancialAccountType = _FinancialAccountTypeText.FinancialAccountType  -- association [0..*]
LEFT OUTER JOIN I_DebitCreditCode AS _DebitCreditCode ON DebitCreditCode = _DebitCreditCode.DebitCreditCode  -- association [0..1]
LEFT OUTER JOIN I_DebitCreditCodeText AS _DebitCreditCodeText ON DebitCreditCode = _DebitCreditCodeText.DebitCreditCode  -- association [0..*]
LEFT OUTER JOIN I_Material AS _Material ON Material = _Material.Material  -- association [0..1]
LEFT OUTER JOIN I_Product AS _Product ON Product = _Product.Product  -- association [0..1]
LEFT OUTER JOIN I_ProductDescription AS _ProductText ON Product = _ProductText.Product  -- association [0..*]
LEFT OUTER JOIN I_Plant AS _Plant ON Plant = _Plant.Plant  -- association [0..1]
LEFT OUTER JOIN I_Ledger AS _Ledger ON Ledger = _Ledger.Ledger  -- association [1..1]
LEFT OUTER JOIN I_LedgerText AS _LedgerText ON Ledger = _LedgerText.Ledger  -- association [0..*]
LEFT OUTER JOIN I_Ledger AS _SourceLedger ON SourceLedger = _SourceLedger.Ledger  -- association [0..1]
LEFT OUTER JOIN I_LedgerText AS _SourceLedgerText ON SourceLedger = _SourceLedgerText.Ledger  -- association [0..*]
LEFT OUTER JOIN I_Customer AS _Customer ON Customer = _Customer.Customer  -- association [0..1]
LEFT OUTER JOIN I_Customer AS _CustomerText ON Customer = _CustomerText.Customer  -- association [0..1]
LEFT OUTER JOIN I_CustomerGroup AS _CustomerGroup ON CustomerGroup = _CustomerGroup.CustomerGroup  -- association [0..1]
LEFT OUTER JOIN I_Supplier AS _Supplier ON Supplier = _Supplier.Supplier  -- association [0..1]
LEFT OUTER JOIN I_Supplier AS _SupplierText ON Supplier = _SupplierText.Supplier  -- association [0..1]
LEFT OUTER JOIN I_MaterialGroup AS _MaterialGroup ON MaterialGroup = _MaterialGroup.MaterialGroup  -- association [0..1]
LEFT OUTER JOIN I_ProductGroup AS _SoldProductGroup ON SoldProductGroup = _SoldProductGroup.MaterialGroup  -- association [0..1]
LEFT OUTER JOIN I_ProductGroup_2 AS _SoldProductGroup_2 ON SoldProductGroup = _SoldProductGroup_2.ProductGroup  -- association [0..1]
LEFT OUTER JOIN I_ProductGroup AS _ProductGroup ON ProductGroup = _ProductGroup.MaterialGroup  -- association [0..1]
LEFT OUTER JOIN I_ProductGroup_2 AS _ProductGroup_2 ON ProductGroup = _ProductGroup_2.ProductGroup  -- association [0..1]
LEFT OUTER JOIN I_SalesOrder AS _SalesOrder ON SalesOrder = _SalesOrder.SalesOrder  -- association [0..1]
LEFT OUTER JOIN I_SalesOrderItem AS _SalesOrderItem ON SalesOrder = _SalesOrderItem.SalesOrder AND SalesOrderItem = _SalesOrderItem.SalesOrderItem  -- association [0..1]
LEFT OUTER JOIN I_SalesDocument AS _SalesDocument ON SalesDocument = _SalesDocument.SalesDocument  -- association [0..1]
LEFT OUTER JOIN I_SalesDocumentItem AS _SalesDocumentItem ON SalesDocument = _SalesDocumentItem.SalesDocument AND SalesDocumentItem = _SalesDocumentItem.SalesDocumentItem  -- association [0..1]
LEFT OUTER JOIN I_InternalOrder AS _InternalOrder ON OrderID = _InternalOrder.InternalOrder  -- association [0..1]
LEFT OUTER JOIN I_Order AS _Order ON OrderID = _Order.OrderID  -- association [0..1]
LEFT OUTER JOIN I_CostAnalysisResource AS _CostAnalysisResource ON ControllingArea = _CostAnalysisResource.ControllingArea AND CostAnalysisResource = _CostAnalysisResource.CostAnalysisResource  -- association [0..*]
LEFT OUTER JOIN I_CostAnalysisResourceText AS _CostAnalysisResourceText ON ControllingArea = _CostAnalysisResourceText.ControllingArea AND CostAnalysisResource = _CostAnalysisResourceText.CostAnalysisResource  -- association [0..*]
LEFT OUTER JOIN I_Employment AS _Employment ON PersonnelNumber = _Employment.EmploymentInternalID  -- association [0..1]
LEFT OUTER JOIN I_PersonWorkAgreement_1 AS _PersonWorkAgreement_1 ON PersonnelNumber = _PersonWorkAgreement_1.PersonWorkAgreement  -- association [0..1]
LEFT OUTER JOIN I_FinancialTransactionType AS _FinancialTransactionType ON FinancialTransactionType = _FinancialTransactionType.FinancialTransactionType  -- association [0..1]
LEFT OUTER JOIN I_BusinessTransactionType AS _BusinessTransactionType ON BusinessTransactionType = _BusinessTransactionType.BusinessTransactionType  -- association [0..1]
LEFT OUTER JOIN I_BusTransactionTypeText AS _BusinessTransactionTypeText ON BusinessTransactionType = _BusinessTransactionTypeText.BusinessTransactionType  -- association [0..*]
LEFT OUTER JOIN I_ReferenceDocumentType AS _ReferenceDocumentType ON ReferenceDocumentType = _ReferenceDocumentType.ReferenceDocumentType  -- association [0..1]
LEFT OUTER JOIN I_ReferenceDocumentType AS _PredecessorReferenceDocType ON PredecessorReferenceDocType = _PredecessorReferenceDocType.ReferenceDocumentType  -- association [0..1]
LEFT OUTER JOIN I_CostCenter AS _PartnerCostCenter ON ControllingArea = _PartnerCostCenter.ControllingArea AND PartnerCostCenter = _PartnerCostCenter.CostCenter  -- association [0..*]
LEFT OUTER JOIN I_ProfitCenter AS _PartnerProfitCenter ON ControllingArea = _PartnerProfitCenter.ControllingArea AND PartnerProfitCenter = _PartnerProfitCenter.ProfitCenter  -- association [0..*]
LEFT OUTER JOIN I_BusinessArea AS _PartnerBusinessArea ON PartnerBusinessArea = _PartnerBusinessArea.BusinessArea  -- association [0..1]
LEFT OUTER JOIN I_BusinessAreaText AS _PartnerBusinessAreaText ON PartnerBusinessArea = _PartnerBusinessAreaText.BusinessArea  -- association [0..*]
LEFT OUTER JOIN I_FunctionalArea AS _PartnerFunctionalArea ON PartnerFunctionalArea = _PartnerFunctionalArea.FunctionalArea  -- association [0..1]
LEFT OUTER JOIN I_CompanyCode AS _PartnerCompanyCode ON PartnerCompanyCode = _PartnerCompanyCode.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_CompanyCode AS _PartnerCompanyCodeText ON PartnerCompanyCode = _PartnerCompanyCodeText.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_Segment AS _PartnerSegment ON PartnerSegment = _PartnerSegment.Segment  -- association [0..1]
LEFT OUTER JOIN I_SegmentText AS _PartnerSegmentText ON PartnerSegment = _PartnerSegmentText.Segment  -- association [0..*]
LEFT OUTER JOIN I_AccountingDocumentCategory AS _AccountingDocumentCategory ON AccountingDocumentCategory = _AccountingDocumentCategory.AccountingDocumentCategory  -- association [0..1]
LEFT OUTER JOIN I_PostingKey AS _PostingKey ON PostingKey = _PostingKey.PostingKey  -- association [0..1]
LEFT OUTER JOIN I_SubLedgerAccLineItemType AS _SubLedgerAccLineItemType ON SubLedgerAcctLineItemType = _SubLedgerAccLineItemType.SubLedgerAcctLineItemType  -- association [0..1]
LEFT OUTER JOIN I_User AS _User ON AccountingDocCreatedByUser = _User.UserID  -- association [0..1]
LEFT OUTER JOIN I_ProfitCenter AS _EliminationProfitCenter ON ControllingArea = _EliminationProfitCenter.ControllingArea AND EliminationProfitCenter = _EliminationProfitCenter.ProfitCenter  -- association [0..*]
LEFT OUTER JOIN I_GLAccountType AS _GLAccountType ON GLAccountType = _GLAccountType.GLAccountType  -- association [0..1]
LEFT OUTER JOIN I_FinancialAccountType AS _OffsettingAccountType ON OffsettingAccountType = _OffsettingAccountType.FinancialAccountType  -- association [0..1]
LEFT OUTER JOIN I_FinancialAccountTypeText AS _OffsettingAccountTypeText ON OffsettingAccountType = _OffsettingAccountTypeText.FinancialAccountType  -- association [0..*]
LEFT OUTER JOIN I_GLAccountInChartOfAccounts AS _AlternativeGLAccount ON CountryChartOfAccounts = _AlternativeGLAccount.ChartOfAccounts AND AlternativeGLAccount = _AlternativeGLAccount.GLAccount  -- association [0..1]
LEFT OUTER JOIN I_GLAccountText AS _AlternativeGLAccountText ON CountryChartOfAccounts = _AlternativeGLAccountText.ChartOfAccounts AND AlternativeGLAccount = _AlternativeGLAccountText.GLAccount  -- association [0..*]
LEFT OUTER JOIN I_GLAccountInChartOfAccounts AS _OffsettingAccount ON ChartOfAccounts = _OffsettingAccount.ChartOfAccounts AND OffsettingAccount = _OffsettingAccount.GLAccount  -- association [0..1]
LEFT OUTER JOIN I_OffsettingAccount AS _OffsettingAccountText ON OffsettingChartOfAccounts = _OffsettingAccountText.ChartOfAccounts AND OffsettingAccountType = _OffsettingAccountText.OffsettingAccountType AND OffsettingAccount = _OffsettingAccountText.OffsettingAccount  -- association [0..1]
LEFT OUTER JOIN I_OffsettingAccount AS _OffsettingAccountWithBP ON OffsettingChartOfAccounts = _OffsettingAccountWithBP.ChartOfAccounts AND OffsettingAccountType = _OffsettingAccountWithBP.OffsettingAccountType AND OffsettingAccount = _OffsettingAccountWithBP.OffsettingAccount  -- association [0..1]
LEFT OUTER JOIN I_ChartOfAccounts AS _OffsettingChartOfAccounts ON OffsettingChartOfAccounts = _OffsettingChartOfAccounts.ChartOfAccounts  -- association [0..1]
LEFT OUTER JOIN I_ChartOfAccountsText AS _OffsettingChartOfAccountsText ON OffsettingChartOfAccounts = _OffsettingChartOfAccountsText.ChartOfAccounts  -- association [0..*]
LEFT OUTER JOIN I_ChartOfAccounts AS _CountryChartOfAccounts ON CountryChartOfAccounts = _CountryChartOfAccounts.ChartOfAccounts  -- association [0..1]
LEFT OUTER JOIN I_ChartOfAccountsText AS _CountryChartOfAccountsText ON CountryChartOfAccounts = _CountryChartOfAccountsText.ChartOfAccounts  -- association [0..*]
LEFT OUTER JOIN I_PurchasingDocument AS _PurchasingDocument ON PurchasingDocument = _PurchasingDocument.PurchasingDocument  -- association [0..1]
LEFT OUTER JOIN I_PurchasingDocumentItem AS _PurchasingDocumentItem ON PurchasingDocument = _PurchasingDocumentItem.PurchasingDocument AND PurchasingDocumentItem = _PurchasingDocumentItem.PurchasingDocumentItem  -- association [0..1]
LEFT OUTER JOIN I_SpecialGLCode AS _SpecialGLCode ON SpecialGLCode = _SpecialGLCode.SpecialGLCode AND FinancialAccountType = _SpecialGLCode.FinancialAccountType  -- association [0..1]
LEFT OUTER JOIN I_TaxCode AS _TaxCode ON TaxCode = _TaxCode.TaxCode  -- association [0..*]
LEFT OUTER JOIN I_Housebank AS _HouseBank ON CompanyCode = _HouseBank.CompanyCode AND HouseBank = _HouseBank.HouseBank  -- association [0..1]
LEFT OUTER JOIN I_AccountingDocument AS _ClearingAccountingDocument ON CompanyCode = _ClearingAccountingDocument.CompanyCode AND FiscalYear = _ClearingAccountingDocument.FiscalYear AND ClearingAccountingDocument = _ClearingAccountingDocument.AccountingDocument  -- association [1..1]
LEFT OUTER JOIN I_FiscalYearForCompanyCode AS _ClearingJrnlEntryFiscalYear ON ClearingJournalEntryFiscalYear = _ClearingJrnlEntryFiscalYear.FiscalYear AND CompanyCode = _ClearingJrnlEntryFiscalYear.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_JournalEntry AS _ClearingJournalEntry ON CompanyCode = _ClearingJournalEntry.CompanyCode AND ClearingJournalEntryFiscalYear = _ClearingJournalEntry.FiscalYear AND ClearingJournalEntry = _ClearingJournalEntry.AccountingDocument  -- association [0..1]
LEFT OUTER JOIN I_MasterFixedAsset AS _MasterFixedAsset ON CompanyCode = _MasterFixedAsset.CompanyCode AND MasterFixedAsset = _MasterFixedAsset.MasterFixedAsset  -- association [0..1]
LEFT OUTER JOIN I_MasterFixedAsset AS _GroupMasterFixedAsset ON CompanyCode = _GroupMasterFixedAsset.CompanyCode AND GroupMasterFixedAsset = _GroupMasterFixedAsset.MasterFixedAsset  -- association [0..1]
LEFT OUTER JOIN I_MasterFixedAsset AS _GroupMasterFixedAssetText ON CompanyCode = _GroupMasterFixedAssetText.CompanyCode AND GroupMasterFixedAsset = _GroupMasterFixedAssetText.MasterFixedAsset  -- association [0..1]
LEFT OUTER JOIN I_MasterFixedAsset AS _MasterFixedAssetText ON CompanyCode = _MasterFixedAssetText.CompanyCode AND MasterFixedAsset = _MasterFixedAssetText.MasterFixedAsset  -- 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_FixedAsset AS _GroupFixedAsset ON CompanyCode = _GroupFixedAsset.CompanyCode AND GroupMasterFixedAsset = _GroupFixedAsset.MasterFixedAsset AND GroupFixedAsset = _GroupFixedAsset.FixedAsset  -- association [0..1]
LEFT OUTER JOIN I_FixedAsset AS _GroupFixedAssetText ON CompanyCode = _GroupFixedAssetText.CompanyCode AND GroupMasterFixedAsset = _GroupFixedAssetText.MasterFixedAsset AND GroupFixedAsset = _GroupFixedAssetText.FixedAsset  -- association [0..1]
LEFT OUTER JOIN I_FixedAsset AS _FixedAssetText ON CompanyCode = _FixedAssetText.CompanyCode AND MasterFixedAsset = _FixedAssetText.MasterFixedAsset AND FixedAsset = _FixedAssetText.FixedAsset  -- association [0..1]
LEFT OUTER JOIN I_BusinessProcess AS _BusinessProcess ON ControllingArea = _BusinessProcess.ControllingArea AND BusinessProcess = _BusinessProcess.BusinessProcess  -- association [0..1]
LEFT OUTER JOIN I_BusinessProcessText AS _BusinessProcessText ON ControllingArea = _BusinessProcessText.ControllingArea AND BusinessProcess = _BusinessProcessText.BusinessProcess  -- association [0..*]
LEFT OUTER JOIN I_CostCenterActivityType AS _PartnerCostCtrActivityType ON ControllingArea = _PartnerCostCtrActivityType.ControllingArea AND PartnerCostCtrActivityType = _PartnerCostCtrActivityType.CostCtrActivityType  -- association [0..*]
LEFT OUTER JOIN I_InternalOrder AS _PartnerOrder ON PartnerOrder = _PartnerOrder.InternalOrder  -- association [0..1]
LEFT OUTER JOIN I_InternalOrder AS _PartnerOrderText ON PartnerOrder = _PartnerOrderText.InternalOrder  -- association [0..1]
LEFT OUTER JOIN I_Order AS _PartnerOrder_2 ON PartnerOrder_2 = _PartnerOrder_2.OrderID  -- association [0..1]
LEFT OUTER JOIN I_Order AS _PartnerOrderText_2 ON PartnerOrder_2 = _PartnerOrderText_2.OrderID  -- association [0..1]
LEFT OUTER JOIN I_OrderCategory AS _PartnerOrderCategory ON PartnerOrderCategory = _PartnerOrderCategory.OrderCategory  -- association [0..1]
LEFT OUTER JOIN I_SalesDocument AS _PartnerSalesDocument ON PartnerSalesDocument = _PartnerSalesDocument.SalesDocument  -- association [0..1]
LEFT OUTER JOIN I_SalesDocumentItem AS _PartnerSalesDocumentItem ON PartnerSalesDocument = _PartnerSalesDocumentItem.SalesDocument AND PartnerSalesDocumentItem = _PartnerSalesDocumentItem.SalesDocumentItem  -- association [0..1]
LEFT OUTER JOIN I_BusinessProcess AS _PartnerBusinessProcess ON ControllingArea = _PartnerBusinessProcess.ControllingArea AND PartnerBusinessProcess = _PartnerBusinessProcess.BusinessProcess  -- association [0..1]
LEFT OUTER JOIN I_BusinessProcessText AS _PartnerBusinessProcessText ON ControllingArea = _PartnerBusinessProcessText.ControllingArea AND PartnerBusinessProcess = _PartnerBusinessProcessText.BusinessProcess  -- association [0..*]
LEFT OUTER JOIN I_BillingDocumentType AS _BillingDocumentType ON BillingDocumentType = _BillingDocumentType.BillingDocumentType  -- association [0..1]
LEFT OUTER JOIN I_SalesOrganization AS _SalesOrganization ON SalesOrganization = _SalesOrganization.SalesOrganization  -- association [0..1]
LEFT OUTER JOIN I_DistributionChannel AS _DistributionChannel ON DistributionChannel = _DistributionChannel.DistributionChannel  -- association [0..1]
LEFT OUTER JOIN I_Material AS _SoldMaterial ON SoldMaterial = _SoldMaterial.Material  -- association [0..1]
LEFT OUTER JOIN I_Product AS _SoldProduct ON SoldProduct = _SoldProduct.Product  -- association [0..1]
LEFT OUTER JOIN I_ProductDescription AS _SoldProductText ON SoldProduct = _SoldProductText.Product  -- association [0..*]
LEFT OUTER JOIN I_Fund AS _Fund ON FinancialManagementArea = _Fund.FinancialManagementArea AND Fund = _Fund.Fund  -- association [0..1]
LEFT OUTER JOIN I_FundText AS _FundText ON FinancialManagementArea = _FundText.FinancialManagementArea AND Fund = _FundText.Fund  -- association [0..*]
LEFT OUTER JOIN I_Fund AS _PartnerFund ON FinancialManagementArea = _PartnerFund.FinancialManagementArea AND PartnerFund = _PartnerFund.Fund  -- association [0..1]
LEFT OUTER JOIN I_FundText AS _PartnerFundText ON FinancialManagementArea = _PartnerFundText.FinancialManagementArea AND PartnerFund = _PartnerFundText.Fund  -- association [0..*]
LEFT OUTER JOIN I_FundsCenter AS _FundsCenter ON FinancialManagementArea = _FundsCenter.FinancialManagementArea AND FundsCenter = _FundsCenter.FundsCenter  -- association [0..*]
LEFT OUTER JOIN I_InventoryValuationType AS _InventorySpecialStockValnType ON InventorySpecialStockValnType = _InventorySpecialStockValnType.InventoryValuationType  -- association [0..1]
LEFT OUTER JOIN I_InvtrySpecialStockValnType AS _InventorySpclStockValnType ON InvtrySpecialStockValnType_2 = _InventorySpclStockValnType.InventorySpecialStockValnType  -- association [0..1]
LEFT OUTER JOIN I_InventorySpecialStockType AS _InventorySpecialStockType ON InventorySpecialStockType = _InventorySpecialStockType.InventorySpecialStockType  -- association [0..1]
LEFT OUTER JOIN I_SalesDocument AS _InventorySpclStkSalesDocument ON InventorySpclStkSalesDocument = _InventorySpclStkSalesDocument.SalesDocument  -- association [0..1]
LEFT OUTER JOIN I_SalesDocumentItem AS _InventorySpclStkSalesDocItm ON InventorySpclStkSalesDocument = _InventorySpclStkSalesDocItm.SalesDocument AND InventorySpclStkSalesDocItm = _InventorySpclStkSalesDocItm.SalesDocumentItem  -- association [0..1]
LEFT OUTER JOIN I_Supplier AS _InventorySpecialStockSupplier ON InventorySpecialStockSupplier = _InventorySpecialStockSupplier.Supplier  -- association [0..1]
LEFT OUTER JOIN I_Supplier AS _InvtrySpclStockSupplierText ON InventorySpecialStockSupplier = _InvtrySpclStockSupplierText.Supplier  -- association [0..1]
LEFT OUTER JOIN I_InventoryValuationType AS _InventoryValuationType ON InventoryValuationType = _InventoryValuationType.InventoryValuationType  -- association [0..1]
LEFT OUTER JOIN I_ControllingDebitCreditCode AS _ControllingDebitCreditCode ON ControllingDebitCreditCode = _ControllingDebitCreditCode.ControllingDebitCreditCode  -- association [0..1]
LEFT OUTER JOIN I_ControllingObject AS _OriginSenderObject ON OriginSenderObject = _OriginSenderObject.ControllingObject  -- association [0..1]
LEFT OUTER JOIN I_ControllingObjectClass AS _ControllingObjectClass ON ControllingObjectClass = _ControllingObjectClass.ControllingObjectClass  -- association [0..1]
LEFT OUTER JOIN I_Partnercompany AS _PartnerCompany ON PartnerCompany = _PartnerCompany.PartnerCompany  -- association [0..1]
LEFT OUTER JOIN I_ControllingObjectClass AS _PartnerControllingObjectClass ON PartnerControllingObjectClass = _PartnerControllingObjectClass.ControllingObjectClass  -- association [0..1]
LEFT OUTER JOIN I_CostCenter AS _OriginCostCenter ON ControllingArea = _OriginCostCenter.ControllingArea AND OriginCostCenter = _OriginCostCenter.CostCenter  -- association [0..*]
LEFT OUTER JOIN I_ProfitCenter AS _OriginProfitCenter ON ControllingArea = _OriginProfitCenter.ControllingArea AND OriginProfitCenter = _OriginProfitCenter.ProfitCenter  -- association [0..*]
LEFT OUTER JOIN I_CostCenterActivityType AS _CostCtrActivityType ON ControllingArea = _CostCtrActivityType.ControllingArea AND CostCtrActivityType = _CostCtrActivityType.CostCtrActivityType  -- association [0..*]
LEFT OUTER JOIN I_CostCenterActivityType AS _OriginCostCtrActivityType ON ControllingArea = _OriginCostCtrActivityType.ControllingArea AND OriginCostCtrActivityType = _OriginCostCtrActivityType.CostCtrActivityType  -- association [0..*]
LEFT OUTER JOIN I_OrderCategory AS _OrderCategory ON OrderCategory = _OrderCategory.OrderCategory  -- association [0..1]
LEFT OUTER JOIN I_MovementCategory AS _MovementCategory ON AssetAcctTransClassfctn = _MovementCategory.AssetAcctTransClassfctn  -- association [0..1]
LEFT OUTER JOIN I_AssetTransactionType AS _AssetTransactionType ON AssetTransactionType = _AssetTransactionType.AssetTransactionType  -- association [0..1]
LEFT OUTER JOIN I_BudgetPeriod AS _BudgetPeriod ON BudgetPeriod = _BudgetPeriod.BudgetPeriod  -- association [0..1]
LEFT OUTER JOIN I_BudgetPeriodText AS _BudgetPeriodText ON BudgetPeriod = _BudgetPeriodText.BudgetPeriod  -- association [0..*]
LEFT OUTER JOIN I_CostOriginGroup AS _CostOriginGroup ON ControllingArea = _CostOriginGroup.ControllingArea AND CostOriginGroup = _CostOriginGroup.CostOriginGroup  -- association [0..*]
LEFT OUTER JOIN I_Country AS _CustomerSupplierCountry ON CustomerSupplierCountry = _CustomerSupplierCountry.Country  -- association [0..1]
LEFT OUTER JOIN I_SalesDistrict AS _SalesDistrict ON SalesDistrict = _SalesDistrict.SalesDistrict  -- association [0..1]
LEFT OUTER JOIN I_Customer AS _BillToParty ON BillToParty = _BillToParty.Customer  -- association [0..1]
LEFT OUTER JOIN I_Customer AS _ShipToParty ON ShipToParty = _ShipToParty.Customer  -- association [0..1]
LEFT OUTER JOIN I_FinancialManagementArea AS _FinancialManagementArea ON FinancialManagementArea = _FinancialManagementArea.FinancialManagementArea  -- association [0..1]
LEFT OUTER JOIN I_FinancialManagementAreaText AS _FinancialManagementAreaText ON FinancialManagementArea = _FinancialManagementAreaText.FinancialManagementArea  -- association [0..*]
LEFT OUTER JOIN I_HouseBankAccount AS _HouseBankAccount ON CompanyCode = _HouseBankAccount.CompanyCode AND HouseBank = _HouseBankAccount.HouseBank AND HouseBankAccount = _HouseBankAccount.HouseBankAccount  -- association [0..1]
LEFT OUTER JOIN I_HouseBankAccountText AS _HouseBankAccountText ON CompanyCode = _HouseBankAccountText.CompanyCode AND HouseBank = _HouseBankAccountText.HouseBank AND HouseBankAccount = _HouseBankAccountText.HouseBankAccount  -- association [0..*]
LEFT OUTER JOIN I_LogicalSystem AS _LogicalSystem ON LogicalSystem = _LogicalSystem.LogicalSystem  -- association [0..1]
LEFT OUTER JOIN I_OperatingConcern AS _OperatingConcern ON OperatingConcern = _OperatingConcern.OperatingConcern  -- association [0..1]
LEFT OUTER JOIN I_OperatingConcernText AS _OperatingConcernText ON OperatingConcern = _OperatingConcernText.OperatingConcern  -- association [0..*]
LEFT OUTER JOIN I_ProjectNetwork AS _ProjectNetwork ON ProjectNetwork = _ProjectNetwork.ProjectNetwork  -- association [0..1]
LEFT OUTER JOIN I_ProjectNetwork AS _ProjectNetworkText ON ProjectNetwork = _ProjectNetworkText.ProjectNetwork  -- association [0..1]
LEFT OUTER JOIN I_Purreqvaluationarea AS _PurReqValuationArea ON ValuationArea = _PurReqValuationArea.ValuationArea  -- association [0..1]
LEFT OUTER JOIN I_WorkCenter AS _WorkCenter ON WorkCenterInternalID = _WorkCenter.WorkCenterInternalID AND _WorkCenter.WorkCenterTypeCode = 'A'  -- association [0..1]
LEFT OUTER JOIN I_BillableControl AS _BillableControl ON BillableControl = _BillableControl.BillableControl  -- association [0..1]
LEFT OUTER JOIN I_ConditionContract AS _ConditionContract ON ConditionContract = _ConditionContract.ConditionContract  -- association [0..1]
LEFT OUTER JOIN I_MaintenanceOrder AS _MaintenanceOrder ON OrderID = _MaintenanceOrder.MaintenanceOrder AND OrderCategory = '30'  -- association [0..1]
LEFT OUTER JOIN I_MaintenanceOrderOperation AS _MaintenanceOrderOperation ON OrderID = _MaintenanceOrderOperation.MaintenanceOrder AND OrderOperation = _MaintenanceOrderOperation.MaintenanceOrderOperation AND OrderCategory = '30'  -- association [0..1]
LEFT OUTER JOIN I_MaintenanceOrderSubOperation AS _MaintenanceOrderSubOperation ON OrderID = _MaintenanceOrderSubOperation.MaintenanceOrder AND OrderOperation = _MaintenanceOrderSubOperation.MaintenanceOrderOperation AND OrderSuboperation = _MaintenanceOrderSubOperation.MaintenanceOrderSubOperation  -- association [0..1]
LEFT OUTER JOIN I_Equipment AS _Equipment ON Equipment = _Equipment.Equipment  -- association [0..1]
LEFT OUTER JOIN I_EquipmentText AS _EquipmentText ON Equipment = _EquipmentText.Equipment  -- association [0..*]
LEFT OUTER JOIN I_FunctionalLocation AS _FunctionalLocation ON FunctionalLocation = _FunctionalLocation.FunctionalLocation  -- association [0..1]
LEFT OUTER JOIN I_FunctionalLocationText AS _FunctionalLocationText ON FunctionalLocation = _FunctionalLocationText.FunctionalLocation  -- association [0..*]
LEFT OUTER JOIN I_Product AS _Assembly ON Assembly = _Assembly.Product  -- association [0..1]
LEFT OUTER JOIN I_ProductDescription AS _AssemblyText ON Assembly = _AssemblyText.Product  -- association [0..*]
LEFT OUTER JOIN I_MaintenanceActivityType AS _MaintenanceActivityType ON MaintenanceActivityType = _MaintenanceActivityType.MaintenanceActivityType  -- association [0..1]
LEFT OUTER JOIN I_MaintenanceActivityTypeText AS _MaintenanceActivityTypeText ON MaintenanceActivityType = _MaintenanceActivityTypeText.MaintenanceActivityType  -- association [0..*]
LEFT OUTER JOIN I_MaintOrdPlngDegreeCode AS _MaintOrdPlngDegreeCode ON MaintenanceOrderPlanningCode = _MaintOrdPlngDegreeCode.MaintenanceOrderPlanningCode  -- association [0..1]
LEFT OUTER JOIN I_PMNotificationPriorityType AS _PMNotificationPriorityType ON MaintPriorityType = _PMNotificationPriorityType.MaintPriorityType  -- association [0..1]
LEFT OUTER JOIN I_PMNotificationPriority AS _PMNotificationPriority ON MaintPriority = _PMNotificationPriority.MaintPriority AND MaintPriorityType = _PMNotificationPriority.MaintPriorityType  -- association [0..1]
LEFT OUTER JOIN I_LogisticsOrder AS _SuperiorOrder ON SuperiorOrder = _SuperiorOrder.OrderID  -- association [0..1]
LEFT OUTER JOIN I_GLAccountText AS _GLAccountText ON GLAccount = _GLAccountText.GLAccount  -- association [0..*]
LEFT OUTER JOIN I_GLAccountText AS _GLAccountTxt ON ChartOfAccounts = _GLAccountTxt.ChartOfAccounts AND GLAccount = _GLAccountTxt.GLAccount  -- association [0..*]
LEFT OUTER JOIN I_WorkPackage AS _WorkPackageText ON WorkPackage = _WorkPackageText.WorkPackage  -- association [0..1]
LEFT OUTER JOIN I_WorkPackage AS _WorkPackage ON WorkPackage = _WorkPackage.WorkPackage  -- association [0..1]
LEFT OUTER JOIN I_WorkPackageWorkItem AS _WorkPackageWorkItem ON WorkItem = _WorkPackageWorkItem.WorkItem AND WorkPackage = _WorkPackageWorkItem.WorkPackage  -- association [0..1]
LEFT OUTER JOIN I_TimeSheetOvertimeCat AS _TimeSheetOvertimeCat ON TimeSheetOvertimeCategory = _TimeSheetOvertimeCat.TimeSheetOvertimeCategory  -- association [0..1]
LEFT OUTER JOIN I_ServiceDocumentType AS _ServiceDocumentType ON ServiceDocumentType = _ServiceDocumentType.ServiceDocumentType  -- 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_SrvcDocItemByDocumentType AS _ServiceDocumentItem ON ServiceDocumentType = _ServiceDocumentItem.ServiceDocumentType AND ServiceDocument = _ServiceDocumentItem.ServiceDocument AND ServiceDocumentItem = _ServiceDocumentItem.ServiceDocumentItem  -- association [0..1]
LEFT OUTER JOIN I_ServiceDocumentType AS _ServiceContractType ON ServiceContractType = _ServiceContractType.ServiceDocumentType  -- association [0..1]
LEFT OUTER JOIN I_SrvcDocByDocumentType AS _ServiceContract ON ServiceContractType = _ServiceContract.ServiceDocumentType AND ServiceContract = _ServiceContract.ServiceDocument  -- association [0..1]
LEFT OUTER JOIN I_SrvcDocItemByDocumentType AS _ServiceContractItem ON ServiceContractType = _ServiceContractItem.ServiceDocumentType AND ServiceContract = _ServiceContractItem.ServiceDocument AND ServiceContractItem = _ServiceContractItem.ServiceDocumentItem  -- association [0..1]
LEFT OUTER JOIN I_ServiceDocumentType AS _PartnerServiceDocumentType ON PartnerServiceDocumentType = _PartnerServiceDocumentType.ServiceDocumentType  -- association [0..1]
LEFT OUTER JOIN I_SrvcDocByDocumentType AS _PartnerServiceDocument ON PartnerServiceDocumentType = _PartnerServiceDocument.ServiceDocumentType AND PartnerServiceDocument = _PartnerServiceDocument.ServiceDocument  -- association [0..1]
LEFT OUTER JOIN I_SrvcDocItemByDocumentType AS _PartnerServiceDocumentItem ON PartnerServiceDocumentType = _PartnerServiceDocumentItem.ServiceDocumentType AND PartnerServiceDocument = _PartnerServiceDocumentItem.ServiceDocument AND PartnerServiceDocumentItem = _PartnerServiceDocumentItem.ServiceDocumentItem  -- association [0..1]
LEFT OUTER JOIN I_AccrualObjectType AS _AccrualObjectType ON AccrualObjectType = _AccrualObjectType.AccrualObjectType  -- association [0..1]
LEFT OUTER JOIN I_AccrualObject AS _AccrualObject ON AccrualObjectType = _AccrualObject.AccrualObjectType AND _AccrualObject.AccrualObjectLogicalSystem = '' AND CompanyCode = _AccrualObject.CompanyCode AND AccrualObject = _AccrualObject.AccrualObject  -- association [0..1]
LEFT OUTER JOIN I_AccrualSubObject AS _AccrualSubobject ON AccrualObjectType = _AccrualSubobject.AccrualObjectType AND _AccrualSubobject.AccrualObjectLogicalSystem = '' AND CompanyCode = _AccrualSubobject.CompanyCode AND AccrualObject = _AccrualSubobject.AccrualObject AND AccrualSubobject = _AccrualSubobject.AccrualSubobject  -- association [0..1]
LEFT OUTER JOIN I_AccrualItemType AS _AccrualItemType ON AccrualObjectType = _AccrualItemType.AccrualObjectType AND AccrualItemType = _AccrualItemType.AccrualItemType  -- association [0..1]
LEFT OUTER JOIN I_CreditRiskClass AS _CreditRiskClass ON CreditRiskClass = _CreditRiskClass.CreditRiskClass  -- association [0..1]
LEFT OUTER JOIN I_FinValuationObjectType AS _FinValuationObjectType ON FinancialValuationObjectType = _FinValuationObjectType.FinancialValuationObjectType  -- association [0..1]
LEFT OUTER JOIN I_SemTagGLAccount AS _SemTagGLAccount ON GLAccount = _SemTagGLAccount.GLAccount AND ChartOfAccounts = _SemTagGLAccount.ChartOfAccounts  -- association [0..*]
LEFT OUTER JOIN I_SponsoredClassCore AS _SponsoredClass ON SponsoredClass = _SponsoredClass.SponsoredClass  -- association [0..1]
LEFT OUTER JOIN I_SponsoredProgramCore AS _SponsoredProgram ON SponsoredProgram = _SponsoredProgram.SponsoredProgram  -- 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]
;