I_JournalEntryItem

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_JournalEntryItem.
-- 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_JournalEntryItem AS
SELECT
  BusinessTransactionCategory,
  FinancialClosingStep,
  FunctionalCurrency,
  AmountInFunctionalCurrency,
  GrantCurrency,
  AmountInGrantCurrency,
  cast(I_GLAccountLineItemRawData.SalesDocument as vdm_sales_order preserving type ) AS SalesOrder,
  cast(I_GLAccountLineItemRawData.SalesDocumentItem as sales_order_item preserving type ) AS SalesOrderItem,
  cast(I_GLAccountLineItemRawData.Product as matnr preserving type ) AS Material,
  PerformancePeriodStartDate,
  PerformancePeriodEndDate,
  cast( I_GLAccountLineItemRawData.ClearingJournalEntryFiscalYear as fis_auggj_no_conv_depre preserving type ) AS ClearingDocFiscalYear,
  cast( I_GLAccountLineItemRawData.ClearingJournalEntry as fis_augbl_depre preserving type ) AS ClearingAccountingDocument,
  cast( I_GLAccountLineItemRawData.InventorySpecialStockValnType as fis_invtryspclstockvalntype_d preserving type ) AS InventorySpecialStockValnType,
  IsSupplierStockValuation,
  cast( I_GLAccountLineItemRawData.InvtrySpclStockWBSElmntIntID as fis_invspstock_wbsint_no_conv preserving type ) AS InvtrySpclStockWBSElmntIntID,
  cast( I_GLAccountLineItemRawData.InventorySpclStockWBSElement as fis_invspstock_wbs preserving type ) AS InventorySpclStockWBSElement,
  MaterialLedgerProcessType,
  MaterialLedgerCategory,
  SlsPriceAmountInCoCodeCrcy,
  ProductPriceControl,
  OriginOrder,
  OriginProduct,
  VarianceOriginGLAccount,
  cast( I_GLAccountLineItemRawData.WBSElement as fis_wbs preserving type ) AS WBSElement,
  cast( I_GLAccountLineItemRawData.Project as fis_project preserving type ) AS Project,
  BusinessSolutionOrder,
  BusinessSolutionOrderItem,
  RevenueAccountingContract,
  PerformanceObligation,
  cast(I_GLAccountLineItemRawData.PartnerOrder as fis_par_aufnr_depre preserving type ) AS PartnerOrder,
  cast(I_GLAccountLineItemRawData.PartnerOrder as fis_par_aufnr preserving type ) AS PartnerOrder_2,
  cast( I_GLAccountLineItemRawData.PartnerWBSElement as fis_partner_wbs preserving type ) AS PartnerWBSElement,
  cast( I_GLAccountLineItemRawData.PartnerProject as fis_part_project preserving type ) AS PartnerProject,
  cast(I_GLAccountLineItemRawData.SoldProduct as fis_sold_material preserving type ) AS SoldMaterial,
  cast(I_GLAccountLineItemRawData.SoldProductGroup as fins_matkl_pa preserving type ) AS MaterialGroup,
  CashLedgerCompanyCode,
  CashLedgerAccount,
  FinancialManagementArea,
  CommitmentItem,
  FundsCenter,
  FundedProgram,
  Fund,
  GrantID,
  BudgetPeriod,
  PartnerFund,
  PartnerGrant,
  PartnerBudgetPeriod,
  PubSecBudgetAccount,
  PubSecBudgetAccountCoCode,
  PubSecBudgetCnsmpnDate,
  PubSecBudgetCnsmpnFsclPeriod,
  PubSecBudgetCnsmpnFsclYear,
  PubSecBudgetIsRelevant,
  PubSecBudgetCnsmpnType,
  PubSecBudgetCnsmpnAmtType,
  SponsoredProgram,
  SponsoredClass,
  EarmarkedFundsDocument,
  EarmarkedFundsDocumentItem,
  GteeMBudgetValidityNumber,
  FinancialServicesProductGroup,
  FinancialServicesBranch,
  FinancialDataSource,
  REBusinessEntity,
  RealEstateBuilding,
  RealEstateProperty,
  RERentalObject,
  RealEstateContract,
  REServiceChargeKey,
  RESettlementUnitID,
  SettlementReferenceDate,
  REPartnerBusinessEntity,
  RealEstatePartnerBuilding,
  RealEstatePartnerProperty,
  REPartnerRentalObject,
  RealEstatePartnerContract,
  REPartnerServiceChargeKey,
  REPartnerSettlementUnitID,
  PartnerSettlementReferenceDate,
  JrnlEntryItemMigrationSource,
  cast( cast(1 as abap.dec( 12, 0 )) as fis_nbritm preserving type ) AS NumberOfItems,
  cast( '' as fis_brgru_glaccount) AS GLAccountAuthorizationGroup,
  cast( '' as fis_brgru_supplier) AS SupplierBasicAuthorizationGrp,
  cast( '' as fis_brgru_customer) AS CustomerBasicAuthorizationGrp,
  cast( '' as fis_brgru_acctgdoctype) AS AcctgDocTypeAuthorizationGroup,
  cast( '' as aufart) AS OrderType,
  cast( '' as auart) AS SalesOrderType,
  I_CoCodeLedgerSourceLedger.Ledger AS Ledger,
  I_GLAccountLineItemRawData.SourceLedger AS SourceLedger,
  I_GLAccountLineItemRawData.CompanyCode AS CompanyCode,
  I_GLAccountLineItemRawData.FiscalYear AS FiscalYear,
  I_GLAccountLineItemRawData.AccountingDocument AS AccountingDocument,
  I_GLAccountLineItemRawData.LedgerGLLineItem AS LedgerGLLineItem,
  I_GLAccountLineItemRawData.LedgerFiscalYear AS LedgerFiscalYear,
  I_GLAccountLineItemRawData.GLRecordType AS GLRecordType,
  I_GLAccountLineItemRawData.JrnlEntrAltvFYConsecutiveID AS JrnlEntrAltvFYConsecutiveID,
  I_GLAccountLineItemRawData.ChartOfAccounts AS ChartOfAccounts,
  I_GLAccountLineItemRawData.ControllingArea AS ControllingArea,
  I_GLAccountLineItemRawData.FinancialTransactionType AS FinancialTransactionType,
  I_GLAccountLineItemRawData.BusinessTransactionType AS BusinessTransactionType,
  I_GLAccountLineItemRawData.ControllingBusTransacType AS ControllingBusTransacType,
  I_GLAccountLineItemRawData.ReferenceDocumentType AS ReferenceDocumentType,
  I_GLAccountLineItemRawData.LogicalSystem AS LogicalSystem,
  I_GLAccountLineItemRawData.ReferenceDocumentContext AS ReferenceDocumentContext,
  I_GLAccountLineItemRawData.ReferenceDocument AS ReferenceDocument,
  I_GLAccountLineItemRawData.ReferenceDocumentItem AS ReferenceDocumentItem,
  I_GLAccountLineItemRawData.ReferenceDocumentItemGroup AS ReferenceDocumentItemGroup,
  I_GLAccountLineItemRawData.IsReversal AS IsReversal,
  I_GLAccountLineItemRawData.IsReversed AS IsReversed,
  I_GLAccountLineItemRawData.ReversalReferenceDocumentCntxt AS ReversalReferenceDocumentCntxt,
  I_GLAccountLineItemRawData.ReversalReferenceDocument AS ReversalReferenceDocument,
  I_GLAccountLineItemRawData.IsSettlement AS IsSettlement,
  I_GLAccountLineItemRawData.IsSettled AS IsSettled,
  I_GLAccountLineItemRawData.PredecessorReferenceDocType AS PredecessorReferenceDocType,
  I_GLAccountLineItemRawData.PredecessorReferenceDocCntxt AS PredecessorReferenceDocCntxt,
  I_GLAccountLineItemRawData.PredecessorReferenceDocument AS PredecessorReferenceDocument,
  I_GLAccountLineItemRawData.PredecessorReferenceDocItem AS PredecessorReferenceDocItem,
  I_GLAccountLineItemRawData.PrdcssrJournalEntryCompanyCode AS PrdcssrJournalEntryCompanyCode,
  I_GLAccountLineItemRawData.PrdcssrJournalEntryFiscalYear AS PrdcssrJournalEntryFiscalYear,
  I_GLAccountLineItemRawData.PredecessorJournalEntry AS PredecessorJournalEntry,
  I_GLAccountLineItemRawData.PredecessorJournalEntryItem AS PredecessorJournalEntryItem,
  I_GLAccountLineItemRawData.SourceReferenceDocumentType AS SourceReferenceDocumentType,
  I_GLAccountLineItemRawData.SourceLogicalSystem AS SourceLogicalSystem,
  I_GLAccountLineItemRawData.SourceReferenceDocumentCntxt AS SourceReferenceDocumentCntxt,
  I_GLAccountLineItemRawData.SourceReferenceDocument AS SourceReferenceDocument,
  I_GLAccountLineItemRawData.SourceReferenceDocumentItem AS SourceReferenceDocumentItem,
  I_GLAccountLineItemRawData.SourceReferenceDocSubitem AS SourceReferenceDocSubitem,
  I_GLAccountLineItemRawData.IsCommitment AS IsCommitment,
  I_GLAccountLineItemRawData.JrnlEntryItemObsoleteReason AS JrnlEntryItemObsoleteReason,
  I_GLAccountLineItemRawData.OrganizationalChange AS OrganizationalChange,
  I_GLAccountLineItemRawData.AccountingNotificationUUID AS AccountingNotificationUUID,
  I_GLAccountLineItemRawData.GLAccount AS GLAccount,
  I_GLAccountLineItemRawData.CostCenter AS CostCenter,
  I_GLAccountLineItemRawData.ProfitCenter AS ProfitCenter,
  I_GLAccountLineItemRawData.FunctionalArea AS FunctionalArea,
  I_GLAccountLineItemRawData.BusinessArea AS BusinessArea,
  I_GLAccountLineItemRawData.Segment AS Segment,
  I_GLAccountLineItemRawData.PartnerCostCenter AS PartnerCostCenter,
  I_GLAccountLineItemRawData.PartnerProfitCenter AS PartnerProfitCenter,
  I_GLAccountLineItemRawData.PartnerFunctionalArea AS PartnerFunctionalArea,
  I_GLAccountLineItemRawData.PartnerBusinessArea AS PartnerBusinessArea,
  I_GLAccountLineItemRawData.PartnerCompany AS PartnerCompany,
  I_GLAccountLineItemRawData.PartnerSegment AS PartnerSegment,
  I_GLAccountLineItemRawData.BalanceTransactionCurrency AS BalanceTransactionCurrency,
  I_GLAccountLineItemRawData.AmountInBalanceTransacCrcy AS AmountInBalanceTransacCrcy,
  I_GLAccountLineItemRawData.TransactionCurrency AS TransactionCurrency,
  I_GLAccountLineItemRawData.AmountInTransactionCurrency AS AmountInTransactionCurrency,
  I_GLAccountLineItemRawData.CompanyCodeCurrency AS CompanyCodeCurrency,
  I_GLAccountLineItemRawData.AmountInCompanyCodeCurrency AS AmountInCompanyCodeCurrency,
  I_GLAccountLineItemRawData.GlobalCurrency AS GlobalCurrency,
  I_GLAccountLineItemRawData.AmountInGlobalCurrency AS AmountInGlobalCurrency,
  I_GLAccountLineItemRawData.FreeDefinedCurrency1 AS FreeDefinedCurrency1,
  I_GLAccountLineItemRawData.AmountInFreeDefinedCurrency1 AS AmountInFreeDefinedCurrency1,
  I_GLAccountLineItemRawData.FreeDefinedCurrency2 AS FreeDefinedCurrency2,
  I_GLAccountLineItemRawData.AmountInFreeDefinedCurrency2 AS AmountInFreeDefinedCurrency2,
  I_GLAccountLineItemRawData.FreeDefinedCurrency3 AS FreeDefinedCurrency3,
  I_GLAccountLineItemRawData.AmountInFreeDefinedCurrency3 AS AmountInFreeDefinedCurrency3,
  I_GLAccountLineItemRawData.FreeDefinedCurrency4 AS FreeDefinedCurrency4,
  I_GLAccountLineItemRawData.AmountInFreeDefinedCurrency4 AS AmountInFreeDefinedCurrency4,
  I_GLAccountLineItemRawData.FreeDefinedCurrency5 AS FreeDefinedCurrency5,
  I_GLAccountLineItemRawData.AmountInFreeDefinedCurrency5 AS AmountInFreeDefinedCurrency5,
  I_GLAccountLineItemRawData.FreeDefinedCurrency6 AS FreeDefinedCurrency6,
  I_GLAccountLineItemRawData.AmountInFreeDefinedCurrency6 AS AmountInFreeDefinedCurrency6,
  I_GLAccountLineItemRawData.FreeDefinedCurrency7 AS FreeDefinedCurrency7,
  I_GLAccountLineItemRawData.AmountInFreeDefinedCurrency7 AS AmountInFreeDefinedCurrency7,
  I_GLAccountLineItemRawData.FreeDefinedCurrency8 AS FreeDefinedCurrency8,
  I_GLAccountLineItemRawData.AmountInFreeDefinedCurrency8 AS AmountInFreeDefinedCurrency8,
  I_GLAccountLineItemRawData.FixedAmountInGlobalCrcy AS FixedAmountInGlobalCrcy,
  I_GLAccountLineItemRawData.FixedAmountInCoCodeCrcy AS FixedAmountInCoCodeCrcy,
  I_GLAccountLineItemRawData.GrpValnFixedAmtInGlobCrcy AS GrpValnFixedAmtInGlobCrcy,
  I_GLAccountLineItemRawData.PrftCtrValnFxdAmtInGlobCrcy AS PrftCtrValnFxdAmtInGlobCrcy,
  I_GLAccountLineItemRawData.TotalPriceVarcInGlobalCrcy AS TotalPriceVarcInGlobalCrcy,
  I_GLAccountLineItemRawData.GrpValnTotPrcVarcInGlobCrcy AS GrpValnTotPrcVarcInGlobCrcy,
  I_GLAccountLineItemRawData.PrftCtrValnTotPrcVarcInGlbCrcy AS PrftCtrValnTotPrcVarcInGlbCrcy,
  I_GLAccountLineItemRawData.FixedPriceVarcInGlobalCrcy AS FixedPriceVarcInGlobalCrcy,
  I_GLAccountLineItemRawData.GrpValnFixedPrcVarcInGlobCrcy AS GrpValnFixedPrcVarcInGlobCrcy,
  I_GLAccountLineItemRawData.PrftCtrValnFxdPrcVarcInGlbCrcy AS PrftCtrValnFxdPrcVarcInGlbCrcy,
  I_GLAccountLineItemRawData.ControllingObjectCurrency AS ControllingObjectCurrency,
  I_GLAccountLineItemRawData.AmountInObjectCurrency AS AmountInObjectCurrency,
  I_GLAccountLineItemRawData.BaseUnit AS BaseUnit,
  I_GLAccountLineItemRawData.Quantity AS Quantity,
  I_GLAccountLineItemRawData.FixedQuantity AS FixedQuantity,
  I_GLAccountLineItemRawData.CostSourceUnit AS CostSourceUnit,
  I_GLAccountLineItemRawData.ValuationQuantity AS ValuationQuantity,
  I_GLAccountLineItemRawData.ValuationFixedQuantity AS ValuationFixedQuantity,
  I_GLAccountLineItemRawData.ReferenceQuantityUnit AS ReferenceQuantityUnit,
  I_GLAccountLineItemRawData.ReferenceQuantity AS ReferenceQuantity,
  I_GLAccountLineItemRawData.AdditionalQuantity1Unit AS AdditionalQuantity1Unit,
  I_GLAccountLineItemRawData.AdditionalQuantity1 AS AdditionalQuantity1,
  I_GLAccountLineItemRawData.AdditionalQuantity2Unit AS AdditionalQuantity2Unit,
  I_GLAccountLineItemRawData.AdditionalQuantity2 AS AdditionalQuantity2,
  I_GLAccountLineItemRawData.AdditionalQuantity3Unit AS AdditionalQuantity3Unit,
  I_GLAccountLineItemRawData.AdditionalQuantity3 AS AdditionalQuantity3,
  I_GLAccountLineItemRawData.IncmpltSummableValnQtyUnt AS IncmpltSummableValnQtyUnt,
  I_GLAccountLineItemRawData.IncmpltSummableValnQty AS IncmpltSummableValnQty,
  I_GLAccountLineItemRawData.IncmpltSummableValnFxdQty AS IncmpltSummableValnFxdQty,
  I_GLAccountLineItemRawData.DebitCreditCode AS DebitCreditCode,
  I_GLAccountLineItemRawData.FiscalPeriod AS FiscalPeriod,
  I_GLAccountLineItemRawData.FiscalYearVariant AS FiscalYearVariant,
  I_GLAccountLineItemRawData.FiscalYearPeriod AS FiscalYearPeriod,
  I_GLAccountLineItemRawData.PostingDate AS PostingDate,
  I_GLAccountLineItemRawData.DocumentDate AS DocumentDate,
  I_GLAccountLineItemRawData.AccountingDocumentType AS AccountingDocumentType,
  I_GLAccountLineItemRawData.AccountingDocumentItem AS AccountingDocumentItem,
  I_GLAccountLineItemRawData.AssignmentReference AS AssignmentReference,
  I_GLAccountLineItemRawData.AccountingDocumentCategory AS AccountingDocumentCategory,
  I_GLAccountLineItemRawData.JournalEntryItemCategory AS JournalEntryItemCategory,
  I_GLAccountLineItemRawData.PostingKey AS PostingKey,
  I_GLAccountLineItemRawData.TransactionTypeDetermination AS TransactionTypeDetermination,
  I_GLAccountLineItemRawData.SubLedgerAcctLineItemType AS SubLedgerAcctLineItemType,
  I_GLAccountLineItemRawData.AccountingDocCreatedByUser AS AccountingDocCreatedByUser,
  I_GLAccountLineItemRawData.LastChangeDateTime AS LastChangeDateTime,
  I_GLAccountLineItemRawData.CreationDateTime AS CreationDateTime,
  I_GLAccountLineItemRawData.CreationDate AS CreationDate,
  I_GLAccountLineItemRawData.EliminationProfitCenter AS EliminationProfitCenter,
  I_GLAccountLineItemRawData.OriginObjectType AS OriginObjectType,
  I_GLAccountLineItemRawData.GLAccountType AS GLAccountType,
  I_GLAccountLineItemRawData.AlternativeGLAccount AS AlternativeGLAccount,
  I_GLAccountLineItemRawData.CountryChartOfAccounts AS CountryChartOfAccounts,
  I_GLAccountLineItemRawData.ConsolidationUnit AS ConsolidationUnit,
  I_GLAccountLineItemRawData.PartnerConsolidationUnit AS PartnerConsolidationUnit,
  I_GLAccountLineItemRawData.Company AS Company,
  I_GLAccountLineItemRawData.ConsolidationChartOfAccounts AS ConsolidationChartOfAccounts,
  I_GLAccountLineItemRawData.CnsldtnFinancialStatementItem AS CnsldtnFinancialStatementItem,
  I_GLAccountLineItemRawData.CnsldtnSubitemCategory AS CnsldtnSubitemCategory,
  I_GLAccountLineItemRawData.CnsldtnSubitem AS CnsldtnSubitem,
  I_GLAccountLineItemRawData.InvoiceReference AS InvoiceReference,
  I_GLAccountLineItemRawData.InvoiceReferenceFiscalYear AS InvoiceReferenceFiscalYear,
  I_GLAccountLineItemRawData.FollowOnDocumentType AS FollowOnDocumentType,
  I_GLAccountLineItemRawData.InvoiceItemReference AS InvoiceItemReference,
  I_GLAccountLineItemRawData.ReferencePurchaseOrderCategory AS ReferencePurchaseOrderCategory,
  I_GLAccountLineItemRawData.PurchasingDocument AS PurchasingDocument,
  I_GLAccountLineItemRawData.PurchasingDocumentItem AS PurchasingDocumentItem,
  I_GLAccountLineItemRawData.AccountAssignmentNumber AS AccountAssignmentNumber,
  I_GLAccountLineItemRawData.DocumentItemText AS DocumentItemText,
  I_GLAccountLineItemRawData.SalesDocument AS SalesDocument,
  I_GLAccountLineItemRawData.SalesDocumentItem AS SalesDocumentItem,
  I_GLAccountLineItemRawData.Product AS Product,
  I_GLAccountLineItemRawData.Plant AS Plant,
  I_GLAccountLineItemRawData.Supplier AS Supplier,
  I_GLAccountLineItemRawData.Customer AS Customer,
  I_GLAccountLineItemRawData.ServicesRenderedDate AS ServicesRenderedDate,
  I_GLAccountLineItemRawData.ConditionContract AS ConditionContract,
  I_GLAccountLineItemRawData.FinancialAccountType AS FinancialAccountType,
  I_GLAccountLineItemRawData.SpecialGLCode AS SpecialGLCode,
  I_GLAccountLineItemRawData.TaxCode AS TaxCode,
  I_GLAccountLineItemRawData.TaxCountry AS TaxCountry,
  I_GLAccountLineItemRawData.HouseBank AS HouseBank,
  I_GLAccountLineItemRawData.HouseBankAccount AS HouseBankAccount,
  I_GLAccountLineItemRawData.IsOpenItemManaged AS IsOpenItemManaged,
  I_GLAccountLineItemRawData.ClearingDate AS ClearingDate,
  I_GLAccountLineItemRawData.ClearingJournalEntryFiscalYear AS ClearingJournalEntryFiscalYear,
  I_GLAccountLineItemRawData.ClearingJournalEntry AS ClearingJournalEntry,
  I_GLAccountLineItemRawData.ValueDate AS ValueDate,
  I_GLAccountLineItemRawData.GeneralLedgerAgingScope AS GeneralLedgerAgingScope,
  I_GLAccountLineItemRawData.GeneralLedgerAgingIncrement AS GeneralLedgerAgingIncrement,
  I_GLAccountLineItemRawData.AssetDepreciationArea AS AssetDepreciationArea,
  I_GLAccountLineItemRawData.MasterFixedAsset AS MasterFixedAsset,
  I_GLAccountLineItemRawData.FixedAsset AS FixedAsset,
  I_GLAccountLineItemRawData.AssetValueDate AS AssetValueDate,
  I_GLAccountLineItemRawData.AssetTransactionType AS AssetTransactionType,
  I_GLAccountLineItemRawData.AssetAcctTransClassfctn AS AssetAcctTransClassfctn,
  I_GLAccountLineItemRawData.DepreciationFiscalPeriod AS DepreciationFiscalPeriod,
  I_GLAccountLineItemRawData.GroupMasterFixedAsset AS GroupMasterFixedAsset,
  I_GLAccountLineItemRawData.GroupFixedAsset AS GroupFixedAsset,
  I_GLAccountLineItemRawData.AssetClass AS AssetClass,
  I_GLAccountLineItemRawData.PartnerMasterFixedAsset AS PartnerMasterFixedAsset,
  I_GLAccountLineItemRawData.PartnerFixedAsset AS PartnerFixedAsset,
  I_GLAccountLineItemRawData.CostEstimate AS CostEstimate,
  I_GLAccountLineItemRawData.InventorySpecialStockValnType AS InvtrySpecialStockValnType_2,
  I_GLAccountLineItemRawData.InventorySpecialStockType AS InventorySpecialStockType,
  I_GLAccountLineItemRawData.InventorySpclStkSalesDocument AS InventorySpclStkSalesDocument,
  I_GLAccountLineItemRawData.InventorySpclStkSalesDocItm AS InventorySpclStkSalesDocItm,
  I_GLAccountLineItemRawData.InventorySpecialStockSupplier AS InventorySpecialStockSupplier,
  I_GLAccountLineItemRawData.InventoryValuationType AS InventoryValuationType,
  I_GLAccountLineItemRawData.ValuationArea AS ValuationArea,
  I_GLAccountLineItemRawData.SenderCompanyCode AS SenderCompanyCode,
  I_GLAccountLineItemRawData.SenderGLAccount AS SenderGLAccount,
  I_GLAccountLineItemRawData.SenderAccountAssignment AS SenderAccountAssignment,
  I_GLAccountLineItemRawData.SenderAccountAssignmentType AS SenderAccountAssignmentType,
  I_GLAccountLineItemRawData.ControllingObject AS ControllingObject,
  I_GLAccountLineItemRawData.CostOriginGroup AS CostOriginGroup,
  I_GLAccountLineItemRawData.OriginSenderObject AS OriginSenderObject,
  I_GLAccountLineItemRawData.ControllingDebitCreditCode AS ControllingDebitCreditCode,
  I_GLAccountLineItemRawData.OriginCtrlgDebitCreditCode AS OriginCtrlgDebitCreditCode,
  I_GLAccountLineItemRawData.ControllingObjectDebitType AS ControllingObjectDebitType,
  I_GLAccountLineItemRawData.QuantityIsIncomplete AS QuantityIsIncomplete,
  I_GLAccountLineItemRawData.OffsettingAccount AS OffsettingAccount,
  I_GLAccountLineItemRawData.OffsettingAccountType AS OffsettingAccountType,
  I_GLAccountLineItemRawData.OffsettingChartOfAccounts AS OffsettingChartOfAccounts,
  I_GLAccountLineItemRawData.LineItemIsCompleted AS LineItemIsCompleted,
  I_GLAccountLineItemRawData.PersonnelNumber AS PersonnelNumber,
  I_GLAccountLineItemRawData.ControllingObjectClass AS ControllingObjectClass,
  I_GLAccountLineItemRawData.PartnerCompanyCode AS PartnerCompanyCode,
  I_GLAccountLineItemRawData.PartnerControllingObjectClass AS PartnerControllingObjectClass,
  I_GLAccountLineItemRawData.OriginCostCenter AS OriginCostCenter,
  I_GLAccountLineItemRawData.OriginProfitCenter AS OriginProfitCenter,
  I_GLAccountLineItemRawData.OriginCostCtrActivityType AS OriginCostCtrActivityType,
  I_GLAccountLineItemRawData.AccountAssignment AS AccountAssignment,
  I_GLAccountLineItemRawData.AccountAssignmentType AS AccountAssignmentType,
  I_GLAccountLineItemRawData.CostCtrActivityType AS CostCtrActivityType,
  I_GLAccountLineItemRawData.OrderID AS OrderID,
  I_GLAccountLineItemRawData.OrderCategory AS OrderCategory,
  I_GLAccountLineItemRawData.WBSElementInternalID AS WBSElementInternalID,
  I_GLAccountLineItemRawData.PartnerWBSElementInternalID AS PartnerWBSElementInternalID,
  I_GLAccountLineItemRawData.ProjectInternalID AS ProjectInternalID,
  I_GLAccountLineItemRawData.PartnerProjectInternalID AS PartnerProjectInternalID,
  I_GLAccountLineItemRawData.WorkPackage AS WorkPackage,
  I_GLAccountLineItemRawData.OperatingConcern AS OperatingConcern,
  I_GLAccountLineItemRawData.ProjectNetwork AS ProjectNetwork,
  I_GLAccountLineItemRawData.RelatedNetworkActivity AS RelatedNetworkActivity,
  I_GLAccountLineItemRawData.BusinessProcess AS BusinessProcess,
  I_GLAccountLineItemRawData.CostObject AS CostObject,
  I_GLAccountLineItemRawData.BillableControl AS BillableControl,
  I_GLAccountLineItemRawData.CostAnalysisResource AS CostAnalysisResource,
  I_GLAccountLineItemRawData.CustomerServiceNotification AS CustomerServiceNotification,
  I_GLAccountLineItemRawData.ServiceDocumentType AS ServiceDocumentType,
  I_GLAccountLineItemRawData.ServiceDocument AS ServiceDocument,
  I_GLAccountLineItemRawData.ServiceDocumentItem AS ServiceDocumentItem,
  I_GLAccountLineItemRawData.PartnerServiceDocumentType AS PartnerServiceDocumentType,
  I_GLAccountLineItemRawData.PartnerServiceDocument AS PartnerServiceDocument,
  I_GLAccountLineItemRawData.PartnerServiceDocumentItem AS PartnerServiceDocumentItem,
  I_GLAccountLineItemRawData.ServiceContractType AS ServiceContractType,
  I_GLAccountLineItemRawData.ServiceContract AS ServiceContract,
  I_GLAccountLineItemRawData.ServiceContractItem AS ServiceContractItem,
  I_GLAccountLineItemRawData.ProviderContract AS ProviderContract,
  I_GLAccountLineItemRawData.ProviderContractItem AS ProviderContractItem,
  I_GLAccountLineItemRawData.TimeSheetOvertimeCategory AS TimeSheetOvertimeCategory,
  I_GLAccountLineItemRawData.PartnerAccountAssignment AS PartnerAccountAssignment,
  I_GLAccountLineItemRawData.PartnerAccountAssignmentType AS PartnerAccountAssignmentType,
  I_GLAccountLineItemRawData.PartnerCostCtrActivityType AS PartnerCostCtrActivityType,
  I_GLAccountLineItemRawData.PartnerOrderCategory AS PartnerOrderCategory,
  I_GLAccountLineItemRawData.PartnerSalesDocument AS PartnerSalesDocument,
  I_GLAccountLineItemRawData.PartnerSalesDocumentItem AS PartnerSalesDocumentItem,
  I_GLAccountLineItemRawData.PartnerProjectNetwork AS PartnerProjectNetwork,
  I_GLAccountLineItemRawData.PartnerProjectNetworkActivity AS PartnerProjectNetworkActivity,
  I_GLAccountLineItemRawData.PartnerBusinessProcess AS PartnerBusinessProcess,
  I_GLAccountLineItemRawData.PartnerCostObject AS PartnerCostObject,
  I_GLAccountLineItemRawData.WorkItem AS WorkItem,
  I_GLAccountLineItemRawData.VarianceOriginGroup AS VarianceOriginGroup,
  I_GLAccountLineItemRawData.BillingDocumentType AS BillingDocumentType,
  I_GLAccountLineItemRawData.SalesOrganization AS SalesOrganization,
  I_GLAccountLineItemRawData.DistributionChannel AS DistributionChannel,
  I_GLAccountLineItemRawData.OrganizationDivision AS OrganizationDivision,
  I_GLAccountLineItemRawData.SoldProduct AS SoldProduct,
  I_GLAccountLineItemRawData.SoldProductGroup AS SoldProductGroup,
  I_GLAccountLineItemRawData.CustomerGroup AS CustomerGroup,
  I_GLAccountLineItemRawData.CustomerSupplierCountry AS CustomerSupplierCountry,
  I_GLAccountLineItemRawData.CustomerSupplierIndustry AS CustomerSupplierIndustry,
  I_GLAccountLineItemRawData.SalesDistrict AS SalesDistrict,
  I_GLAccountLineItemRawData.BillToParty AS BillToParty,
  I_GLAccountLineItemRawData.ShipToParty AS ShipToParty,
  I_GLAccountLineItemRawData.CustomerSupplierCorporateGroup AS CustomerSupplierCorporateGroup,
  I_GLAccountLineItemRawData.JointVenture AS JointVenture,
  I_GLAccountLineItemRawData.JointVentureEquityGroup AS JointVentureEquityGroup,
  I_GLAccountLineItemRawData.JointVentureCostRecoveryCode AS JointVentureCostRecoveryCode,
  I_GLAccountLineItemRawData.JointVenturePartner AS JointVenturePartner,
  I_GLAccountLineItemRawData.JointVentureBillingType AS JointVentureBillingType,
  I_GLAccountLineItemRawData.JointVentureEquityType AS JointVentureEquityType,
  I_GLAccountLineItemRawData.JointVentureProductionDate AS JointVentureProductionDate,
  I_GLAccountLineItemRawData.JointVentureBillingDate AS JointVentureBillingDate,
  I_GLAccountLineItemRawData.JointVentureOperationalDate AS JointVentureOperationalDate,
  I_GLAccountLineItemRawData.CutbackRun AS CutbackRun,
  I_GLAccountLineItemRawData.JointVentureAccountingActivity AS JointVentureAccountingActivity,
  I_GLAccountLineItemRawData.PartnerVenture AS PartnerVenture,
  I_GLAccountLineItemRawData.PartnerEquityGroup AS PartnerEquityGroup,
  I_GLAccountLineItemRawData.SenderCostRecoveryCode AS SenderCostRecoveryCode,
  I_GLAccountLineItemRawData.CutbackAccount AS CutbackAccount,
  I_GLAccountLineItemRawData.CutbackCostObject AS CutbackCostObject,
  I_GLAccountLineItemRawData.AccrualObjectType AS AccrualObjectType,
  I_GLAccountLineItemRawData.AccrualObjectLogicalSystem AS AccrualObjectLogicalSystem,
  I_GLAccountLineItemRawData.AccrualObject AS AccrualObject,
  I_GLAccountLineItemRawData.AccrualSubobject AS AccrualSubobject,
  I_GLAccountLineItemRawData.AccrualItemType AS AccrualItemType,
  I_GLAccountLineItemRawData.AccrualReferenceObject AS AccrualReferenceObject,
  I_GLAccountLineItemRawData.AccrualValueDate AS AccrualValueDate,
  I_GLAccountLineItemRawData.FinancialValuationObjectType AS FinancialValuationObjectType,
  I_GLAccountLineItemRawData.FinancialValuationObject AS FinancialValuationObject,
  I_GLAccountLineItemRawData.FinancialValuationSubobject AS FinancialValuationSubobject,
  I_GLAccountLineItemRawData.NetDueDate AS NetDueDate,
  I_GLAccountLineItemRawData.CreditRiskClass AS CreditRiskClass,
  I_GLAccountLineItemRawData.WorkCenterInternalID AS WorkCenterInternalID,
  I_GLAccountLineItemRawData.OrderOperation AS OrderOperation,
  I_GLAccountLineItemRawData.OrderItem AS OrderItem,
  I_GLAccountLineItemRawData.PartnerOrderItem AS PartnerOrderItem,
  I_GLAccountLineItemRawData.OrderSuboperation AS OrderSuboperation,
  I_GLAccountLineItemRawData.Equipment AS Equipment,
  I_GLAccountLineItemRawData.FunctionalLocation AS FunctionalLocation,
  I_GLAccountLineItemRawData.Assembly AS Assembly,
  I_GLAccountLineItemRawData.MaintenanceActivityType AS MaintenanceActivityType,
  I_GLAccountLineItemRawData.MaintenanceOrderPlanningCode AS MaintenanceOrderPlanningCode,
  I_GLAccountLineItemRawData.MaintPriorityType AS MaintPriorityType,
  I_GLAccountLineItemRawData.MaintPriority AS MaintPriority,
  I_GLAccountLineItemRawData.SuperiorOrder AS SuperiorOrder,
  I_GLAccountLineItemRawData.ProductGroup AS ProductGroup,
  I_GLAccountLineItemRawData.MaintenanceOrderIsPlanned AS MaintenanceOrderIsPlanned
FROM I_GLAccountLineItemRawData
INNER JOIN I_CoCodeLedgerSourceLedger ON /* join condition not captured in parsed metadata */
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 _PartnerWBSElemntBasicDataText ON PartnerWBSElementInternalID = _PartnerWBSElemntBasicDataText.WBSElementInternalID  -- association [0..1]
LEFT OUTER JOIN I_WBSElementBasicData AS _PartnerWBSElmntBasicDataText ON PartnerWBSElementInternalID = _PartnerWBSElmntBasicDataText.WBSElementInternalID  -- association [0..1]
LEFT OUTER JOIN I_WBSElementBasicData AS _InvtrySpclStockWBSElmntBD ON InvtrySpclStockWBSElmntIntID = _InvtrySpclStockWBSElmntBD.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_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 _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_AccountingDocumentTypeText AS _AccountingDocumentTypeText ON AccountingDocumentType = _AccountingDocumentTypeText.AccountingDocumentType  -- association [0..*]
LEFT OUTER JOIN I_BudgetPeriodText AS _BudgetPeriodText ON BudgetPeriod = _BudgetPeriodText.BudgetPeriod  -- association [0..*]
LEFT OUTER JOIN I_BusTransactionTypeText AS _BusinessTransactionTypeText ON BusinessTransactionType = _BusinessTransactionTypeText.BusinessTransactionType  -- association [0..*]
LEFT OUTER JOIN I_BusinessAreaText AS _BusinessAreaText ON BusinessArea = _BusinessAreaText.BusinessArea  -- association [0..*]
LEFT OUTER JOIN I_BusinessAreaText AS _PartnerBusinessAreaText ON PartnerBusinessArea = _PartnerBusinessAreaText.BusinessArea  -- association [0..*]
LEFT OUTER JOIN I_BusinessProcessText AS _BusinessProcessText ON ControllingArea = _BusinessProcessText.ControllingArea AND BusinessProcess = _BusinessProcessText.BusinessProcess  -- association [0..*]
LEFT OUTER JOIN I_BusinessProcessText AS _PartnerBusinessProcessText ON ControllingArea = _PartnerBusinessProcessText.ControllingArea AND PartnerBusinessProcess = _PartnerBusinessProcessText.BusinessProcess  -- association [0..*]
LEFT OUTER JOIN I_ChartOfAccountsText AS _ChartOfAccountsText ON ChartOfAccounts = _ChartOfAccountsText.ChartOfAccounts  -- association [0..*]
LEFT OUTER JOIN I_ChartOfAccountsText AS _CountryChartOfAccountsText ON CountryChartOfAccounts = _CountryChartOfAccountsText.ChartOfAccounts  -- association [0..*]
LEFT OUTER JOIN I_ChartOfAccountsText AS _OffsettingChartOfAccountsText ON OffsettingChartOfAccounts = _OffsettingChartOfAccountsText.ChartOfAccounts  -- association [0..*]
LEFT OUTER JOIN I_CompanyCode AS _PartnerCompanyCodeText ON PartnerCompanyCode = _PartnerCompanyCodeText.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_ControllingArea AS _ControllingAreaText ON ControllingArea = _ControllingAreaText.ControllingArea  -- association [0..1]
LEFT OUTER JOIN I_CostAnalysisResourceText AS _CostAnalysisResourceText ON ControllingArea = _CostAnalysisResourceText.ControllingArea AND CostAnalysisResource = _CostAnalysisResourceText.CostAnalysisResource  -- association [0..*]
LEFT OUTER JOIN I_Customer AS _CustomerText ON Customer = _CustomerText.Customer  -- association [0..1]
LEFT OUTER JOIN I_EquipmentText AS _EquipmentText ON Equipment = _EquipmentText.Equipment  -- association [0..*]
LEFT OUTER JOIN I_FinancialManagementAreaText AS _FinancialManagementAreaText ON FinancialManagementArea = _FinancialManagementAreaText.FinancialManagementArea  -- association [0..*]
LEFT OUTER JOIN I_FinancialAccountTypeText AS _FinancialAccountTypeText ON FinancialAccountType = _FinancialAccountTypeText.FinancialAccountType  -- association [0..*]
LEFT OUTER JOIN I_FinancialAccountTypeText AS _OffsettingAccountTypeText ON OffsettingAccountType = _OffsettingAccountTypeText.FinancialAccountType  -- association [0..*]
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_FixedAsset AS _GroupFixedAssetText ON CompanyCode = _GroupFixedAssetText.CompanyCode AND GroupMasterFixedAsset = _GroupFixedAssetText.MasterFixedAsset AND GroupFixedAsset = _GroupFixedAssetText.FixedAsset  -- association [0..1]
LEFT OUTER JOIN I_FunctionalLocationText AS _FunctionalLocationText ON FunctionalLocation = _FunctionalLocationText.FunctionalLocation  -- association [0..*]
LEFT OUTER JOIN I_FundText AS _FundText ON FinancialManagementArea = _FundText.FinancialManagementArea AND Fund = _FundText.Fund  -- association [0..*]
LEFT OUTER JOIN I_FundText AS _PartnerFundText ON FinancialManagementArea = _PartnerFundText.FinancialManagementArea AND PartnerFund = _PartnerFundText.Fund  -- association [0..*]
LEFT OUTER JOIN I_GLAccountText AS _AlternativeGLAccountText ON CountryChartOfAccounts = _AlternativeGLAccountText.ChartOfAccounts AND AlternativeGLAccount = _AlternativeGLAccountText.GLAccount  -- association [0..*]
LEFT OUTER JOIN I_GLAccountText AS _GLAcctInChartOfAccountsText ON ChartOfAccounts = _GLAcctInChartOfAccountsText.ChartOfAccounts AND GLAccount = _GLAcctInChartOfAccountsText.GLAccount  -- association [0..*]
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_InternalOrder AS _PartnerOrderText ON PartnerOrder = _PartnerOrderText.InternalOrder  -- association [0..1]
LEFT OUTER JOIN I_Order AS _PartnerOrderText_2 ON PartnerOrder_2 = _PartnerOrderText_2.OrderID  -- association [0..1]
LEFT OUTER JOIN I_LedgerText AS _LedgerText ON Ledger = _LedgerText.Ledger  -- association [0..*]
LEFT OUTER JOIN I_LedgerText AS _SourceLedgerText ON SourceLedger = _SourceLedgerText.Ledger  -- association [0..*]
LEFT OUTER JOIN I_MaintenanceActivityTypeText AS _MaintenanceActivityTypeText ON MaintenanceActivityType = _MaintenanceActivityTypeText.MaintenanceActivityType  -- association [0..*]
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_OperatingConcernText AS _OperatingConcernText ON OperatingConcern = _OperatingConcernText.OperatingConcern  -- association [0..*]
LEFT OUTER JOIN I_ProductDescription AS _AssemblyText ON Assembly = _AssemblyText.Product  -- association [0..*]
LEFT OUTER JOIN I_ProductDescription AS _ProductText ON Product = _ProductText.Product  -- association [0..*]
LEFT OUTER JOIN I_ProductDescription AS _SoldProductText ON SoldProduct = _SoldProductText.Product  -- association [0..*]
LEFT OUTER JOIN I_ProjectNetwork AS _ProjectNetworkText ON ProjectNetwork = _ProjectNetworkText.ProjectNetwork  -- association [0..1]
LEFT OUTER JOIN I_SegmentText AS _PartnerSegmentText ON PartnerSegment = _PartnerSegmentText.Segment  -- association [0..*]
LEFT OUTER JOIN I_SegmentText AS _SegmentText ON Segment = _SegmentText.Segment  -- association [0..*]
LEFT OUTER JOIN I_Supplier AS _InvtrySpclStockSupplierText ON InventorySpecialStockSupplier = _InvtrySpclStockSupplierText.Supplier  -- association [0..1]
LEFT OUTER JOIN I_Supplier AS _SupplierText ON Supplier = _SupplierText.Supplier  -- association [0..1]
LEFT OUTER JOIN I_WorkPackage AS _WorkPackageText ON WorkPackage = _WorkPackageText.WorkPackage  -- association [0..1]
LEFT OUTER JOIN I_WorkPackageWorkItem AS _WorkPackageWorkItemText ON WorkItem = _WorkPackageWorkItemText.WorkItem AND WorkPackage = _WorkPackageWorkItemText.WorkPackage  -- association [0..1]
LEFT OUTER JOIN I_DebitCreditCodeText AS _DebitCreditCodeText ON DebitCreditCode = _DebitCreditCodeText.DebitCreditCode  -- association [0..*]
LEFT OUTER JOIN I_FunctionalAreaText AS _FunctionalAreaText ON FunctionalArea = _FunctionalAreaText.FunctionalArea  -- association [0..*]
LEFT OUTER JOIN I_ProfitCenterText AS _ProfitCenterText ON ProfitCenter = _ProfitCenterText.ProfitCenter  -- association [0..*]
LEFT OUTER JOIN I_CostCenterText AS _CostCenterText ON CostCenter = _CostCenterText.CostCenter  -- association [0..*]
LEFT OUTER JOIN I_GLAccountText AS _GLAccountText ON GLAccount = _GLAccountText.GLAccount  -- association [0..*]
LEFT OUTER JOIN I_ProfitCenterText AS _ProfitCenterTxt ON ControllingArea = _ProfitCenterTxt.ControllingArea AND ProfitCenter = _ProfitCenterTxt.ProfitCenter  -- association [0..*]
LEFT OUTER JOIN I_CostCenterText AS _CostCenterTxt ON ControllingArea = _CostCenterTxt.ControllingArea AND CostCenter = _CostCenterTxt.CostCenter  -- association [0..*]
LEFT OUTER JOIN I_GLAccountText AS _GLAccountTxt ON ChartOfAccounts = _GLAccountTxt.ChartOfAccounts AND GLAccount = _GLAccountTxt.GLAccount  -- association [0..*]
LEFT OUTER JOIN I_CompanyCode AS _CompanyCodeText ON CompanyCode = _CompanyCodeText.CompanyCode  -- 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_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_FiscalYearVariant AS _FiscalYearVariant ON FiscalYearVariant = _FiscalYearVariant.FiscalYearVariant  -- association [1..1]
LEFT OUTER JOIN I_FiscalYearForCompanyCode AS _LedgerFiscalYear ON LedgerFiscalYear = _LedgerFiscalYear.FiscalYear AND CompanyCode = _LedgerFiscalYear.CompanyCode association[0..1] to I_FiscalYearPeriodForCmpnyCode as _FiscalPeriod on LedgerFiscalYear = _FiscalPeriod.FiscalYear AND FiscalPeriod = _FiscalPeriod.FiscalPeriod AND CompanyCode = _FiscalPeriod.CompanyCode association[0..1] to I_FiscalCalYearPeriodForCoCode as _FiscalYearPeriod on FiscalYearPeriod = _FiscalYearPeriod.FiscalYearPeriod AND CompanyCode = _FiscalYearPeriod.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_FiscalYearForCompanyCode AS _FiscalYear ON FiscalYear = _FiscalYear.FiscalYear AND CompanyCode = _FiscalYear.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_CalendarDate AS _CalendarDate ON PostingDate = _CalendarDate.CalendarDate  -- 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_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_ProfitCenter AS _ProfitCenter ON ControllingArea = _ProfitCenter.ControllingArea AND ProfitCenter = _ProfitCenter.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_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_BusinessArea AS _BusinessArea ON BusinessArea = _BusinessArea.BusinessArea  -- association [0..1]
LEFT OUTER JOIN I_FunctionalArea AS _FunctionalArea ON FunctionalArea = _FunctionalArea.FunctionalArea  -- association [0..1]
LEFT OUTER JOIN I_GLAccountInChartOfAccounts AS _GLAccountInChartOfAccounts ON ChartOfAccounts = _GLAccountInChartOfAccounts.ChartOfAccounts AND GLAccount = _GLAccountInChartOfAccounts.GLAccount  -- association [0..1]
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_AccountingDocumentType AS _AccountingDocumentType ON AccountingDocumentType = _AccountingDocumentType.AccountingDocumentType  -- association [0..1]
LEFT OUTER JOIN I_FinancialAccountType AS _FinancialAccountType ON FinancialAccountType = _FinancialAccountType.FinancialAccountType  -- association [0..1]
LEFT OUTER JOIN I_DebitCreditCode AS _DebitCreditCode ON DebitCreditCode = _DebitCreditCode.DebitCreditCode  -- association [0..1]
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_Plant AS _Plant ON Plant = _Plant.Plant  -- 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_WorkPackage AS _WorkPackage ON WorkPackage = _WorkPackage.WorkPackage  -- association [0..1]
LEFT OUTER JOIN I_Ledger AS _Ledger ON Ledger = _Ledger.Ledger  -- association [1..1]
LEFT OUTER JOIN I_Ledger AS _SourceLedger ON SourceLedger = _SourceLedger.Ledger  -- association [0..1]
LEFT OUTER JOIN I_Customer AS _Customer ON Customer = _Customer.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_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_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_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_CostCenter AS _CurrentPartnerCostCenter ON ControllingArea = _CurrentPartnerCostCenter.ControllingArea AND PartnerCostCenter = _CurrentPartnerCostCenter.CostCenter AND _CurrentPartnerCostCenter.ValidityStartDate <= $session.system_date AND _CurrentPartnerCostCenter.ValidityEndDate >= $session.system_date  -- association [0..1]
LEFT OUTER JOIN I_ProfitCenter AS _CurrentPartnerProfitCenter ON ControllingArea = _CurrentPartnerProfitCenter.ControllingArea AND PartnerProfitCenter = _CurrentPartnerProfitCenter.ProfitCenter AND _CurrentPartnerProfitCenter.ValidityStartDate <= $session.system_date AND _CurrentPartnerProfitCenter.ValidityEndDate >= $session.system_date  -- association [0..1]
LEFT OUTER JOIN I_BusinessArea AS _PartnerBusinessArea ON PartnerBusinessArea = _PartnerBusinessArea.BusinessArea  -- association [0..1]
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_Segment AS _PartnerSegment ON PartnerSegment = _PartnerSegment.Segment  -- association [0..1]
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_ControllingObject AS _ControllingObject ON ControllingObject = _ControllingObject.ControllingObject  -- association [0..1]
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_GLAccountInChartOfAccounts AS _AlternativeGLAccount ON CountryChartOfAccounts = _AlternativeGLAccount.ChartOfAccounts AND AlternativeGLAccount = _AlternativeGLAccount.GLAccount  -- association [0..1]
LEFT OUTER JOIN I_GLAccountInChartOfAccounts AS _OffsettingAccount ON ChartOfAccounts = _OffsettingAccount.ChartOfAccounts AND OffsettingAccount = _OffsettingAccount.GLAccount  -- 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_ChartOfAccounts AS _CountryChartOfAccounts ON CountryChartOfAccounts = _CountryChartOfAccounts.ChartOfAccounts  -- association [0..1]
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_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_BusinessProcess AS _BusinessProcess ON ControllingArea = _BusinessProcess.ControllingArea AND BusinessProcess = _BusinessProcess.BusinessProcess  -- association [0..1]
LEFT OUTER JOIN I_CostCenterActivityType AS _PartnerCostCtrActivityType ON ControllingArea = _PartnerCostCtrActivityType.ControllingArea AND PartnerCostCtrActivityType = _PartnerCostCtrActivityType.CostCtrActivityType  -- association [0..*]
LEFT OUTER JOIN I_CostCenterActivityType AS _CurrentPartnerCostCtrActyType ON ControllingArea = _CurrentPartnerCostCtrActyType.ControllingArea AND PartnerCostCtrActivityType = _CurrentPartnerCostCtrActyType.CostCtrActivityType AND _CurrentPartnerCostCtrActyType.ValidityStartDate <= $session.system_date AND _CurrentPartnerCostCtrActyType.ValidityEndDate >= $session.system_date  -- association [0..1]
LEFT OUTER JOIN I_InternalOrder AS _PartnerOrder ON PartnerOrder = _PartnerOrder.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_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_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_Division AS _Division ON OrganizationDivision = _Division.Division  -- 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_Fund AS _Fund ON FinancialManagementArea = _Fund.FinancialManagementArea AND Fund = _Fund.Fund  -- association [0..1]
LEFT OUTER JOIN I_Fund AS _PartnerFund ON FinancialManagementArea = _PartnerFund.FinancialManagementArea AND PartnerFund = _PartnerFund.Fund  -- association [0..1]
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_InventoryValuationType AS _InventoryValuationType ON InventoryValuationType = _InventoryValuationType.InventoryValuationType  -- 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 _CurrentCostCtrActyType ON ControllingArea = _CurrentCostCtrActyType.ControllingArea AND CostCtrActivityType = _CurrentCostCtrActyType.CostCtrActivityType AND _CurrentCostCtrActyType.ValidityStartDate <= $session.system_date AND _CurrentCostCtrActyType.ValidityEndDate >= $session.system_date  -- association [0..1]
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_Country AS _CustomerSupplierCountry ON CustomerSupplierCountry = _CustomerSupplierCountry.Country  -- association [0..1]
LEFT OUTER JOIN I_SupplierIndustryText AS _CustomerSupplierIndustryText ON CustomerSupplierIndustry = _CustomerSupplierIndustryText.SupplierIndustry  -- association [0..*]
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_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_CostOriginGroup AS _CostOriginGroup ON ControllingArea = _CostOriginGroup.ControllingArea AND CostOriginGroup = _CostOriginGroup.CostOriginGroup  -- association [0..*]
LEFT OUTER JOIN I_FinancialManagementArea AS _FinancialManagementArea ON FinancialManagementArea = _FinancialManagementArea.FinancialManagementArea  -- association [0..1]
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_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_ProjectNetwork AS _ProjectNetwork ON ProjectNetwork = _ProjectNetwork.ProjectNetwork  -- association [0..1]
LEFT OUTER JOIN I_Purreqvaluationarea AS _PurReqValuationArea ON ValuationArea = _PurReqValuationArea.ValuationArea  -- association [0..1]
LEFT OUTER JOIN I_LedgerCompanyCodeCrcyRoles AS _LedgerCompanyCodeCrcyRoles ON CompanyCode = _LedgerCompanyCodeCrcyRoles.CompanyCode AND Ledger = _LedgerCompanyCodeCrcyRoles.Ledger  -- 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_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_FunctionalLocation AS _FunctionalLocation ON FunctionalLocation = _FunctionalLocation.FunctionalLocation  -- association [0..1]
LEFT OUTER JOIN I_Product AS _Assembly ON Assembly = _Assembly.Product  -- association [0..1]
LEFT OUTER JOIN I_MaintenanceActivityType AS _MaintenanceActivityType ON MaintenanceActivityType = _MaintenanceActivityType.MaintenanceActivityType  -- association [0..1]
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_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 _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_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_TimeSheetOvertimeCat AS _TimeSheetOvertimeCat ON TimeSheetOvertimeCategory = _TimeSheetOvertimeCat.TimeSheetOvertimeCategory  -- 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 I_OrganizationalChange AS _OrganizationalChange ON OrganizationalChange = _OrganizationalChange.OrganizationalChange  -- 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]
;