I_CnsldtnTskLgItmRealgnmt

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_CnsldtnTskLgItmRealgnmt.
-- 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_CnsldtnTskLgItmRealgnmt AS
SELECT
  mapping.CnsldtnTaskLogUUID AS CnsldtnTaskLogUUID,
  mapping.ReferenceDocument AS ReferenceDocument,
  item.SourceLedger AS SourceLedger,
  item.CompanyCode AS CompanyCode,
  item.FiscalYear AS FiscalYear,
  item.AccountingDocument AS AccountingDocument,
  item.LedgerGLLineItem AS LedgerGLLineItem,
  item.LedgerFiscalYear AS LedgerFiscalYear,
  item.GLRecordType AS GLRecordType,
  item.ChartOfAccounts AS ChartOfAccounts,
  item.ControllingArea AS ControllingArea,
  item.FinancialTransactionType AS FinancialTransactionType,
  item.GLBusinessTransactionType AS GLBusinessTransactionType,
  item.BusinessTransactionCategory AS BusinessTransactionCategory,
  item.BusinessTransactionType AS BusinessTransactionType,
  item.FinancialClosingStep AS FinancialClosingStep,
  item.ReferenceDocumentType AS ReferenceDocumentType,
  item.ReferenceDocumentItem AS ReferenceDocumentItem,
  item.TransactionSubitem AS TransactionSubitem,
  item.GLAccount AS GLAccount,
  item.CostCenter AS CostCenter,
  item.ProfitCenter AS ProfitCenter,
  item.FunctionalArea AS FunctionalArea,
  item.BusinessArea AS BusinessArea,
  item.Segment AS Segment,
  item.PartnerCostCenter AS PartnerCostCenter,
  item.PartnerProfitCenter AS PartnerProfitCenter,
  item.PartnerFunctionalArea AS PartnerFunctionalArea,
  item.PartnerBusinessArea AS PartnerBusinessArea,
  item.PartnerCompany AS PartnerCompany,
  item.PartnerSegment AS PartnerSegment,
  item.BalanceTransactionCurrency AS BalanceTransactionCurrency,
  item.AmountInBalanceTransacCrcy AS AmountInBalanceTransacCrcy,
  item.TransactionCurrency AS TransactionCurrency,
  item.AmountInTransactionCurrency AS AmountInTransactionCurrency,
  item.CompanyCodeCurrency AS CompanyCodeCurrency,
  item.AmountInCompanyCodeCurrency AS AmountInCompanyCodeCurrency,
  item.GlobalCurrency AS GlobalCurrency,
  item.AmountInGlobalCurrency AS AmountInGlobalCurrency,
  item.FunctionalCurrency AS FunctionalCurrency,
  item.AmountInFunctionalCurrency AS AmountInFunctionalCurrency,
  item.FreeDefinedCurrency1 AS FreeDefinedCurrency1,
  item.AmountInFreeDefinedCurrency1 AS AmountInFreeDefinedCurrency1,
  item.FreeDefinedCurrency2 AS FreeDefinedCurrency2,
  item.AmountInFreeDefinedCurrency2 AS AmountInFreeDefinedCurrency2,
  item.FreeDefinedCurrency3 AS FreeDefinedCurrency3,
  item.AmountInFreeDefinedCurrency3 AS AmountInFreeDefinedCurrency3,
  item.FreeDefinedCurrency4 AS FreeDefinedCurrency4,
  item.AmountInFreeDefinedCurrency4 AS AmountInFreeDefinedCurrency4,
  item.FreeDefinedCurrency5 AS FreeDefinedCurrency5,
  item.AmountInFreeDefinedCurrency5 AS AmountInFreeDefinedCurrency5,
  item.FreeDefinedCurrency6 AS FreeDefinedCurrency6,
  item.AmountInFreeDefinedCurrency6 AS AmountInFreeDefinedCurrency6,
  item.FreeDefinedCurrency7 AS FreeDefinedCurrency7,
  item.AmountInFreeDefinedCurrency7 AS AmountInFreeDefinedCurrency7,
  item.FreeDefinedCurrency8 AS FreeDefinedCurrency8,
  item.AmountInFreeDefinedCurrency8 AS AmountInFreeDefinedCurrency8,
  item.FixedAmountInGlobalCrcy AS FixedAmountInGlobalCrcy,
  item.GrpValnFixedAmtInGlobCrcy AS GrpValnFixedAmtInGlobCrcy,
  item.PrftCtrValnFxdAmtInGlobCrcy AS PrftCtrValnFxdAmtInGlobCrcy,
  item.TotalPriceVarcInGlobalCrcy AS TotalPriceVarcInGlobalCrcy,
  item.GrpValnTotPrcVarcInGlobCrcy AS GrpValnTotPrcVarcInGlobCrcy,
  item.PrftCtrValnTotPrcVarcInGlbCrcy AS PrftCtrValnTotPrcVarcInGlbCrcy,
  item.FixedPriceVarcInGlobalCrcy AS FixedPriceVarcInGlobalCrcy,
  item.GrpValnFixedPrcVarcInGlobCrcy AS GrpValnFixedPrcVarcInGlobCrcy,
  item.PrftCtrValnFxdPrcVarcInGlbCrcy AS PrftCtrValnFxdPrcVarcInGlbCrcy,
  item.ControllingObjectCurrency AS ControllingObjectCurrency,
  item.AmountInObjectCurrency AS AmountInObjectCurrency,
  item.GrantCurrency AS GrantCurrency,
  item.AmountInGrantCurrency AS AmountInGrantCurrency,
  item.BaseUnit AS BaseUnit,
  item.Quantity AS Quantity,
  item.FixedQuantity AS FixedQuantity,
  item.CostSourceUnit AS CostSourceUnit,
  item.ValuationQuantity AS ValuationQuantity,
  item.ValuationFixedQuantity AS ValuationFixedQuantity,
  item.AdditionalQuantity1Unit AS AdditionalQuantity1Unit,
  item.AdditionalQuantity1 AS AdditionalQuantity1,
  item.AdditionalQuantity2Unit AS AdditionalQuantity2Unit,
  item.AdditionalQuantity2 AS AdditionalQuantity2,
  item.AdditionalQuantity3Unit AS AdditionalQuantity3Unit,
  item.AdditionalQuantity3 AS AdditionalQuantity3,
  item.DebitCreditCode AS DebitCreditCode,
  item.FiscalPeriod AS FiscalPeriod,
  item.FiscalYearVariant AS FiscalYearVariant,
  item.FiscalYearPeriod AS FiscalYearPeriod,
  item.PostingDate AS PostingDate,
  item.DocumentDate AS DocumentDate,
  item.AccountingDocumentType AS AccountingDocumentType,
  item.AssignmentReference AS AssignmentReference,
  item.PostingKey AS PostingKey,
  item.SubLedgerAcctLineItemType AS SubLedgerAcctLineItemType,
  item.AccountingDocCreatedByUser AS AccountingDocCreatedByUser,
  item.CreationDateTime AS CreationDateTime,
  item.CreationDate AS CreationDate,
  item.GLAccountType AS GLAccountType,
  item.ConsolidationUnit AS ConsolidationUnit,
  item.PartnerConsolidationUnit AS PartnerConsolidationUnit,
  item.Company AS Company,
  item.ConsolidationChartOfAccounts AS ConsolidationChartOfAccounts,
  item.CnsldtnFinancialStatementItem AS CnsldtnFinancialStatementItem,
  item.CnsldtnSubitemCategory AS CnsldtnSubitemCategory,
  item.CnsldtnSubitem AS CnsldtnSubitem,
  item.DocumentItemText AS DocumentItemText,
  item.SalesDocument AS SalesDocument,
  item.Product AS Product,
  item.Plant AS Plant,
  item.Supplier AS Supplier,
  item.Customer AS Customer,
  item.FinancialAccountType AS FinancialAccountType,
  cast( item.IsOpenItemManaged as fis_xopvw ) AS IsOpenItemManaged,
  item.ValueDate AS ValueDate,
  item.GeneralLedgerAgingScope AS GeneralLedgerAgingScope,
  item.GeneralLedgerAgingIncrement AS GeneralLedgerAgingIncrement,
  item.MasterFixedAsset AS MasterFixedAsset,
  item.FixedAsset AS FixedAsset,
  item.GroupMasterFixedAsset AS GroupMasterFixedAsset,
  item.AssetClass AS AssetClass,
  item.PartnerMasterFixedAsset AS PartnerMasterFixedAsset,
  item.PartnerFixedAsset AS PartnerFixedAsset,
  item.ValuationArea AS ValuationArea,
  item.SenderGLAccount AS SenderGLAccount,
  item.AccountAssignmentType AS AccountAssignmentType,
  item.OrderID AS OrderID,
  item.WBSElementInternalID AS WBSElementInternalID,
  cast( item.WBSElement as fis_wbs_no_conv preserving type ) AS WBSElement,
  item.ProjectInternalID AS ProjectInternalID,
  cast( item.Project as fis_project_no_conv preserving type ) AS Project,
  item.BillableControl AS BillableControl,
  item.CostAnalysisResource AS CostAnalysisResource,
  item.ServiceDocumentType AS ServiceDocumentType,
  item.ServiceDocument AS ServiceDocument,
  item.BillingDocumentType AS BillingDocumentType,
  item.SalesOrganization AS SalesOrganization,
  item.DistributionChannel AS DistributionChannel,
  item.OrganizationDivision AS OrganizationDivision,
  item.SoldProduct AS SoldProduct,
  item.SoldProductGroup AS SoldProductGroup,
  item.CustomerGroup AS CustomerGroup,
  item.CustomerSupplierCountry AS CustomerSupplierCountry,
  item.CustomerSupplierIndustry AS CustomerSupplierIndustry,
  item.SalesDistrict AS SalesDistrict,
  item.BillToParty AS BillToParty,
  item.ShipToParty AS ShipToParty,
  item.CustomerSupplierCorporateGroup AS CustomerSupplierCorporateGroup,
  item.JointVenture AS JointVenture,
  item.JointVentureEquityGroup AS JointVentureEquityGroup,
  item.CreditRiskClass AS CreditRiskClass,
  item.OrderOperation AS OrderOperation,
  item.ProductGroup AS ProductGroup
FROM I_CnsldtnTskLgItmRealgnmtMappg AS mapping
INNER JOIN I_GLAccountLineItemRawData AS item ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_ConsolidationTaskLog AS _ConsolidationTaskLog ON CnsldtnTaskLogUUID = _ConsolidationTaskLog.CnsldtnTaskLogUUID  -- association [1..1]
LEFT OUTER JOIN I_Ledger AS _SourceLedger ON SourceLedger = _SourceLedger.Ledger  -- association [1..1]
LEFT OUTER JOIN I_CompanyCode AS _CompanyCode ON CompanyCode = _CompanyCode.CompanyCode  -- 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_JournalEntry AS _JournalEntry ON CompanyCode = _JournalEntry.CompanyCode AND FiscalYear = _JournalEntry.FiscalYear AND AccountingDocument = _JournalEntry.AccountingDocument  -- 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_CostAnalysisResource AS _CostAnalysisResource ON ControllingArea = _CostAnalysisResource.ControllingArea AND CostAnalysisResource = _CostAnalysisResource.CostAnalysisResource  -- association [0..*]
LEFT OUTER JOIN I_FinancialTransactionType AS _FinancialTransactionType ON FinancialTransactionType = _FinancialTransactionType.FinancialTransactionType  -- association [0..1]
LEFT OUTER JOIN I_BusinessTransactionCategory AS _BusinessTransactionCategory ON BusinessTransactionCategory = _BusinessTransactionCategory.BusinessTransactionCategory  -- 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_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_FunctionalArea AS _PartnerFunctionalArea ON PartnerFunctionalArea = _PartnerFunctionalArea.FunctionalArea  -- association [0..1]
LEFT OUTER JOIN I_PostingKey AS _PostingKey ON PostingKey = _PostingKey.PostingKey  -- association [0..1]
LEFT OUTER JOIN I_SubLedgerAccLineItemType AS _AcctLineItmType ON SubLedgerAcctLineItemType = _AcctLineItmType.SubLedgerAcctLineItemType  -- association [0..1]
LEFT OUTER JOIN I_GLAccountType AS _GLAccountType ON GLAccountType = _GLAccountType.GLAccountType  -- 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 _PartnerMasterFixedAsset ON CompanyCode = _PartnerMasterFixedAsset.CompanyCode AND PartnerMasterFixedAsset = _PartnerMasterFixedAsset.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 _PartnerFixedAsset ON CompanyCode = _PartnerFixedAsset.CompanyCode AND PartnerMasterFixedAsset = _PartnerFixedAsset.MasterFixedAsset AND PartnerFixedAsset = _PartnerFixedAsset.FixedAsset  -- 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_Product AS _SoldProduct ON SoldProduct = _SoldProduct.Product  -- association [0..1]
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_ValuationArea AS _ValuationArea ON ValuationArea = _ValuationArea.ValuationArea  -- 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_FiscalPeriodForVariant AS _FiscalPeriodForVariant ON LedgerFiscalYear = _FiscalPeriodForVariant.FiscalYear AND FiscalPeriod = _FiscalPeriodForVariant.FiscalPeriod AND FiscalYearVariant = _FiscalPeriodForVariant.FiscalYearVariant  -- association [0..1]
LEFT OUTER JOIN I_FiscalYearVariant AS _FiscalYearVariant ON FiscalYearVariant = _FiscalYearVariant.FiscalYearVariant  -- association [1..1]
LEFT OUTER JOIN I_FiscalYearPeriodForVariant AS _FiscalYearPeriodForVariant ON FiscalYearPeriod = _FiscalYearPeriodForVariant.FiscalYearPeriod AND FiscalYearVariant = _FiscalYearPeriodForVariant.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 _FunctionalCurrency ON FunctionalCurrency = _FunctionalCurrency.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_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..*]
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..*]
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_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_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_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_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_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_SalesDocument AS _SalesDocument ON SalesDocument = _SalesDocument.SalesDocument  -- association [0..1]
LEFT OUTER JOIN I_Order AS _Order ON OrderID = _Order.OrderID  -- association [0..1]
LEFT OUTER JOIN I_Segment AS _Segment ON Segment = _Segment.Segment  -- association [0..1]
LEFT OUTER JOIN I_Partnercompany AS _PartnerCompany ON PartnerCompany = _PartnerCompany.PartnerCompany  -- association [0..1]
LEFT OUTER JOIN I_ProfitCenter AS _ProfitCenter ON ControllingArea = _ProfitCenter.ControllingArea AND ProfitCenter = _ProfitCenter.ProfitCenter  -- association [0..*]
LEFT OUTER JOIN I_CostCenter AS _CostCenter ON ControllingArea = _CostCenter.ControllingArea AND CostCenter = _CostCenter.CostCenter  -- association [0..*]
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_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_CnsldtnUnit_4 AS _ConsolidationUnit ON ConsolidationUnit = _ConsolidationUnit.ConsolidationUnit  -- association [0..1]
LEFT OUTER JOIN I_CnsldtnUnit_4 AS _PartnerConsolidationUnit ON PartnerConsolidationUnit = _PartnerConsolidationUnit.ConsolidationUnit  -- association [0..1]
LEFT OUTER JOIN I_Globalcompany AS _Company ON Company = _Company.Company  -- association [0..1]
LEFT OUTER JOIN I_CnsldtnChartOfAccounts AS _CnsldtnChartOfAccounts ON ConsolidationChartOfAccounts = _CnsldtnChartOfAccounts.ConsolidationChartOfAccounts  -- association [0..1]
LEFT OUTER JOIN I_CnsldtnFSItem_2 AS _CnsldtnFSItem ON ConsolidationChartOfAccounts = _CnsldtnFSItem.ConsolidationChartOfAccounts AND CnsldtnFinancialStatementItem = _CnsldtnFSItem.CnsldtnFinancialStatementItem  -- association [0..1]
LEFT OUTER JOIN I_CnsldtnSubitemCategory_2 AS _CnsldtnSubitemCategory ON CnsldtnSubitemCategory = _CnsldtnSubitemCategory.CnsldtnSubitemCategory  -- association [0..1]
LEFT OUTER JOIN I_CnsldtnSubitem_2 AS _CnsldtnSubitem ON CnsldtnSubitemCategory = _CnsldtnSubitem.CnsldtnSubitemCategory AND CnsldtnSubitem = _CnsldtnSubitem.CnsldtnSubitem  -- association [0..1]
LEFT OUTER JOIN I_WBSElementBasicData AS _WBSElementBasicData ON WBSElementInternalID = _WBSElementBasicData.WBSElementInternalID  -- association [0..1]
LEFT OUTER JOIN I_ProjectBasicData AS _ProjectBasicData ON ProjectInternalID = _ProjectBasicData.ProjectInternalID  -- association [0..1]
LEFT OUTER JOIN I_AccountAssignmentType AS _AccountAssignmentType ON AccountAssignmentType = _AccountAssignmentType.AccountAssignmentType  -- 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]
;