I_CnsldtnTmpGLAcctRealgnmt

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_CnsldtnTmpGLAcctRealgnmt.
-- 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_CnsldtnTmpGLAcctRealgnmt AS
SELECT
  cast(acdoctemp.rldnr as fins_ledger_pers preserving type) AS SourceLedger,
  cast(acdoctemp.rbukrs as fis_bukrs preserving type) AS CompanyCode,
  cast(acdoctemp.gjahr as fis_gjahr_no_conv preserving type) AS FiscalYear,
  cast(acdoctemp.belnr as fis_belnr preserving type) AS AccountingDocument,
  cast(acdoctemp.docln as fis_docln preserving type) AS LedgerGLLineItem,
  acdoctemp.temp_appl AS TemporaryDataCreatingAppl,
  acdoctemp.temp_id AS TemporaryJournalEntry,
  cast(ryear as fis_ryear_no_conv preserving type) AS LedgerFiscalYear,
  rrcty AS GLRecordType,
  cast(ktopl as fis_ktopl preserving type) AS ChartOfAccounts,
  cast(kokrs as fis_kokrs preserving type) AS ControllingArea,
  cast(rmvct as fis_rmvct preserving type) AS FinancialTransactionType,
  cast(vorgn as fis_vorgn preserving type) AS GLBusinessTransactionType,
  cast(bttype as fis_bttype preserving type) AS BusinessTransactionCategory,
  cast(cbttype as fis_custbttype preserving type) AS BusinessTransactionType,
  cast(closingstep as fis_closingstep preserving type) AS FinancialClosingStep,
  cast(awtyp as fis_awtyp preserving type) AS ReferenceDocumentType,
  awref AS ReferenceDocument,
  cast(awitem as fis_awitem preserving type) AS ReferenceDocumentItem,
  subta AS TransactionSubitem,
  cast(racct as fis_racct preserving type) AS GLAccount,
  cast(rcntr as fis_kostl preserving type) AS CostCenter,
  cast(prctr as fis_prctr preserving type) AS ProfitCenter,
  cast(rfarea as fm_farea preserving type) AS FunctionalArea,
  cast(rbusa as fis_rbusa preserving type) AS BusinessArea,
  Segment,
  cast(scntr as fis_skost preserving type) AS PartnerCostCenter,
  cast(pprctr as fis_pprctr preserving type) AS PartnerProfitCenter,
  cast(sfarea as fis_sfkber preserving type) AS PartnerFunctionalArea,
  cast(sbusa as fis_pargb preserving type) AS PartnerBusinessArea,
  cast(rassc as fis_rassc preserving type) AS PartnerCompany,
  psegment AS PartnerSegment,
  cast(rtcur as fis_rtcur preserving type) AS BalanceTransactionCurrency,
  cast(tsl as fis_tsl preserving type) AS AmountInBalanceTransacCrcy,
  cast(rwcur as fis_rwcur preserving type) AS TransactionCurrency,
  cast(wsl as fis_wsl preserving type) AS AmountInTransactionCurrency,
  cast(rhcur as fis_hwaer preserving type) AS CompanyCodeCurrency,
  cast(hsl as fis_hsl preserving type) AS AmountInCompanyCodeCurrency,
  cast(rkcur as fis_rkcur preserving type) AS GlobalCurrency,
  cast(ksl as fis_ksl preserving type) AS AmountInGlobalCurrency,
  rfccur AS FunctionalCurrency,
  cast(fcsl as fis_vfccur12 preserving type) AS AmountInFunctionalCurrency,
  cast(rocur as fis_rocur preserving type) AS FreeDefinedCurrency1,
  cast(osl as fis_osl preserving type) AS AmountInFreeDefinedCurrency1,
  cast(rvcur as fis_rvcur preserving type) AS FreeDefinedCurrency2,
  cast(vsl as fis_vsl preserving type) AS AmountInFreeDefinedCurrency2,
  cast(rbcur as fis_curr3 preserving type) AS FreeDefinedCurrency3,
  cast(bsl as fis_bsl preserving type) AS AmountInFreeDefinedCurrency3,
  cast(rccur as fis_curr4 preserving type) AS FreeDefinedCurrency4,
  cast(csl as fis_csl preserving type) AS AmountInFreeDefinedCurrency4,
  cast(rdcur as fis_curr5 preserving type) AS FreeDefinedCurrency5,
  cast(dsl as fis_dsl preserving type) AS AmountInFreeDefinedCurrency5,
  cast(recur as fis_curr6 preserving type) AS FreeDefinedCurrency6,
  cast(esl as fis_esl preserving type) AS AmountInFreeDefinedCurrency6,
  cast(rfcur as fis_rfcur preserving type) AS FreeDefinedCurrency7,
  cast(fsl as fis_fsl preserving type) AS AmountInFreeDefinedCurrency7,
  cast(rgcur as fis_curr8 preserving type) AS FreeDefinedCurrency8,
  cast(gsl as fis_gsl preserving type) AS AmountInFreeDefinedCurrency8,
  cast(kfsl as fis_kfsl preserving type) AS FixedAmountInGlobalCrcy,
  cast(kfsl2 as fis_vgcur12_fix2 preserving type) AS GrpValnFixedAmtInGlobCrcy,
  cast(kfsl3 as fis_vgcur12_fix3 preserving type) AS PrftCtrValnFxdAmtInGlobCrcy,
  cast(psl as fis_psl preserving type) AS TotalPriceVarcInGlobalCrcy,
  cast(psl2 as fis_vpcur12_2 preserving type) AS GrpValnTotPrcVarcInGlobCrcy,
  cast(psl3 as fis_vpcur12_3 preserving type) AS PrftCtrValnTotPrcVarcInGlbCrcy,
  cast(pfsl as fis_pfsl preserving type) AS FixedPriceVarcInGlobalCrcy,
  cast(pfsl2 as fis_vpfcur12_2 preserving type) AS GrpValnFixedPrcVarcInGlobCrcy,
  cast(pfsl3 as fis_vpfcur12_3 preserving type) AS PrftCtrValnFxdPrcVarcInGlbCrcy,
  rco_ocur AS ControllingObjectCurrency,
  cast(co_osl as fis_vco_ocur12 preserving type) AS AmountInObjectCurrency,
  rgm_ocur AS GrantCurrency,
  gm_osl AS AmountInGrantCurrency,
  runit AS BaseUnit,
  msl AS Quantity,
  cast(mfsl as fis_quan1_12_fix preserving type) AS FixedQuantity,
  cast(rvunit as fis_co_meinh preserving type) AS CostSourceUnit,
  cast(vmsl as fis_vquan1_12 preserving type) AS ValuationQuantity,
  cast(vmfsl as fis_vquan1_12_fix preserving type) AS ValuationFixedQuantity,
  cast(qunit1 as fis_qunit1 preserving type) AS AdditionalQuantity1Unit,
  cast(quant1 as fis_quan1_l preserving type) AS AdditionalQuantity1,
  cast(qunit2 as fis_qunit2 preserving type) AS AdditionalQuantity2Unit,
  cast(quant2 as fis_quan2_l preserving type) AS AdditionalQuantity2,
  cast(qunit3 as fis_qunit3 preserving type) AS AdditionalQuantity3Unit,
  cast(quant3 as fis_quan3_l preserving type) AS AdditionalQuantity3,
  cast(drcrk as fis_shkzg preserving type) AS DebitCreditCode,
  cast(poper as fins_fiscalperiod preserving type) AS FiscalPeriod,
  cast(periv as fis_periv preserving type) AS FiscalYearVariant,
  cast(fiscyearper as fis_jahrper_conv preserving type) AS FiscalYearPeriod,
  cast(budat as fis_budat preserving type) AS PostingDate,
  cast(bldat as fis_bldat preserving type) AS DocumentDate,
  cast(blart as fis_blart preserving type) AS AccountingDocumentType,
  cast(zuonr as fis_zuonr preserving type) AS AssignmentReference,
  cast(bschl as fis_bschl preserving type) AS PostingKey,
  slalittype AS SubLedgerAcctLineItemType,
  cast(usnam as fis_usnam preserving type) AS AccountingDocCreatedByUser,
  cast(timestamp as fis_creation_datetime preserving type) AS CreationDateTime,
  cast(substring( cast(timestamp as abap.char(30)) , 1 , 8) as fis_cpdat) AS CreationDate,
  glaccount_type AS GLAccountType,
  cast(rbunit as fis_md_bunit preserving type) AS ConsolidationUnit,
  cast(rbuptr as fis_md_buptr preserving type) AS PartnerConsolidationUnit,
  cast(rcomp as fis_rcomp preserving type) AS Company,
  cast(ritclg as fis_itclg preserving type) AS ConsolidationChartOfAccounts,
  cast(ritem as fis_fsi_item preserving type) AS CnsldtnFinancialStatementItem,
  cast(sityp as fis_fc_sityp preserving type) AS CnsldtnSubitemCategory,
  cast(subit as fis_fc_sitem preserving type) AS CnsldtnSubitem,
  cast(sgtxt as farp_sgtxt preserving type) AS DocumentItemText,
  cast(kdauf as vbeln_va preserving type) AS SalesDocument,
  cast(matnr as productnumber) AS Product,
  werks AS Plant,
  cast(lifnr as md_supplier preserving type) AS Supplier,
  cast(kunnr as kunnr preserving type) AS Customer,
  cast(koart as farp_koart preserving type) AS FinancialAccountType,
  cast(xopvw as fis_xopvw preserving type) AS IsOpenItemManaged,
  valut AS ValueDate,
  cast(aging as fis_aging preserving type) AS GeneralLedgerAgingScope,
  cast(aging_incrmnt as fis_incrmnt preserving type) AS GeneralLedgerAgingIncrement,
  cast(anln1 as fis_anln1 preserving type) AS MasterFixedAsset,
  cast(anln2 as fis_anln2 preserving type) AS FixedAsset,
  cast(anlgr as fis_anlgr preserving type) AS GroupMasterFixedAsset,
  anlkl AS AssetClass,
  cast(panl1 as fis_panl1 preserving type) AS PartnerMasterFixedAsset,
  cast(panl2 as fis_panl2 preserving type) AS PartnerFixedAsset,
  bwkey AS ValuationArea,
  cast(racct_sender as fis_racct_sender preserving type) AS SenderGLAccount,
  cast(accasty as fis_accasty preserving type) AS AccountAssignmentType,
  cast(aufnr as fis_aufnr preserving type) AS OrderID,
  cast(ps_psp_pnr as fis_wbsint_no_conv preserving type) AS WBSElementInternalID,
  cast(ps_posid as fis_wbs_no_conv preserving type) AS WBSElement,
  cast(ps_prj_pnr as fis_projectint_no_conv preserving type) AS ProjectInternalID,
  cast(ps_pspid as fis_project_no_conv preserving type) AS Project,
  cast(bemot as fis_bemot preserving type) AS BillableControl,
  cast(rsrce as fis_co_resource preserving type) AS CostAnalysisResource,
  service_doc_type AS ServiceDocumentType,
  service_doc_id AS ServiceDocument,
  fkart AS BillingDocumentType,
  vkorg AS SalesOrganization,
  vtweg AS DistributionChannel,
  spart AS OrganizationDivision,
  matnr_copa AS SoldProduct,
  matkl AS SoldProductGroup,
  kdgrp AS CustomerGroup,
  cast(land1 as fis_land1_gp preserving type) AS CustomerSupplierCountry,
  cast(brsch as fis_brsch preserving type) AS CustomerSupplierIndustry,
  bzirk AS SalesDistrict,
  kunre AS BillToParty,
  kunwe AS ShipToParty,
  cast(konzs as fis_konzs preserving type) AS CustomerSupplierCorporateGroup,
  vname AS JointVenture,
  cast(egrup as jv_egroup_cds preserving type) AS JointVentureEquityGroup,
  cast(risk_class as credit_risk_class preserving type) AS CreditRiskClass,
  cast(vornr as fis_vornr_no_conv preserving type) AS OrderOperation,
  cast(matkl_mm as fis_matkl_mm preserving type) AS ProductGroup
FROM acdoctemp
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_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]
;