I_GLAcctBalance

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_GLAcctBalance.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.
-- SQL view name: IFIGLBALANCE
-- Parameters: P_FromPostingDate : fis_budat_from, P_ToPostingDate : fis_budat_to

CREATE VIEW I_GLAcctBalance AS
SELECT
  cast( P_GLAcctBalance.rldnr as fis_rldnr preserving type) AS Ledger,
  cast( P_GLAcctBalance.rbukrs as fis_bukrs preserving type) AS CompanyCode,
  cast( P_GLAcctBalance.gjahr as fis_gjahr_no_conv preserving type) AS FiscalYear,
  cast( P_GLAcctBalance.rldnr_pers as fins_ledger_pers preserving type) AS SourceLedger,
  belnr AS AccountingDocument,
  docln AS LedgerGLLineItem,
  GLAccountFlowType,
  cast( P_GLAcctBalance.awtyp as fis_awtyp ) AS ReferenceDocumentType,
  cast( P_GLAcctBalance.matnr as fis_productnumber_depr preserving type ) AS Material,
  cast( P_GLAcctBalance.matnr_copa as fis_matnr_pa_depr preserving type ) AS SoldMaterial,
  cast (matnr_copa as fins_matnr_pa preserving type) AS SoldProduct,
  cast( P_GLAcctBalance.matkl as fis_matkl_pa_depr preserving type ) AS MaterialGroup,
  cast (matkl_mm as productgroup preserving type) AS ProductGroup,
  cast( P_GLAcctBalance.augbl as fis_augbl_depre preserving type ) AS ClearingAccountingDocument,
  cast( P_GLAcctBalance.auggj as fis_auggj_no_conv_depre preserving type ) AS ClearingDocFiscalYear,
  cast( P_GLAcctBalance.augbl as fis_augbl preserving type ) AS ClearingJournalEntry,
  cast( P_GLAcctBalance.auggj as fis_auggj_no_conv preserving type ) AS ClearingJournalEntryFiscalYear,
  cast(P_GLAcctBalance.kzbws as fis_inventoryspclstockvalntype preserving type) AS InvtrySpecialStockValnType_2,
  cast( P_GLAcctBalance.InvtrySpclStockWBSElmntExtID as fis_invspstock_wbsext_no_conv preserving type ) AS InvtrySpclStockWBSElmntExtID,
  ServiceContractType,
  ServiceContract,
  ServiceContractItem,
  TimeSheetOvertimeCategory,
  cast(P_GLAcctBalance.kdauf as vbeln_va) AS SalesDocument,
  cast(P_GLAcctBalance.kdpos as posnr_va) AS SalesDocumentItem,
  PubSecBudgetCnsmpnDate,
  P_GLAcctBalance.FiscalPeriodDate AS FiscalPeriodDate,
  P_GLAcctBalance.ryear AS LedgerFiscalYear,
  P_GLAcctBalance.rmvct AS FinancialTransactionType,
  P_GLAcctBalance.bttype AS BusinessTransactionType,
  P_GLAcctBalance.awsys AS LogicalSystem,
  P_GLAcctBalance.aworg AS ReferenceDocumentContext,
  P_GLAcctBalance.awref AS ReferenceDocument,
  P_GLAcctBalance.awitem AS ReferenceDocumentItem,
  P_GLAcctBalance.awitgrp AS ReferenceDocumentItemGroup,
  P_GLAcctBalance.xreversing AS IsReversal,
  P_GLAcctBalance.xreversed AS IsReversed,
  P_GLAcctBalance.aworg_rev AS ReversalReferenceDocumentCntxt,
  P_GLAcctBalance.awref_rev AS ReversalReferenceDocument,
  P_GLAcctBalance.xsettling AS IsSettlement,
  P_GLAcctBalance.xsettled AS IsSettled,
  P_GLAcctBalance.prec_awtyp AS PredecessorReferenceDocType,
  P_GLAcctBalance.prec_aworg AS PredecessorReferenceDocCntxt,
  P_GLAcctBalance.prec_awref AS PredecessorReferenceDocument,
  P_GLAcctBalance.prec_awitem AS PredecessorReferenceDocItem,
  P_GLAcctBalance.racct AS GLAccount,
  P_GLAcctBalance.racct AS GLAccountHierarchy,
  P_GLAcctBalance.prctr AS ProfitCenter,
  P_GLAcctBalance.rfarea AS FunctionalArea,
  P_GLAcctBalance.rbusa AS BusinessArea,
  P_GLAcctBalance.kokrs AS ControllingArea,
  P_GLAcctBalance.segment AS Segment,
  P_GLAcctBalance.scntr AS PartnerCostCenter,
  P_GLAcctBalance.pprctr AS PartnerProfitCenter,
  P_GLAcctBalance.sfarea AS PartnerFunctionalArea,
  P_GLAcctBalance.sbusa AS PartnerBusinessArea,
  P_GLAcctBalance.rassc AS PartnerCompany,
  P_GLAcctBalance.psegment AS PartnerSegment,
  P_GLAcctBalance.drcrk AS DebitCreditCode,
  P_GLAcctBalance.periv AS FiscalYearVariant,
  P_GLAcctBalance.fiscyearper AS FiscalYearPeriod,
  P_GLAcctBalance.budat AS PostingDate,
  P_GLAcctBalance.blart AS AccountingDocumentType,
  P_GLAcctBalance.buzei AS AccountingDocumentItem,
  P_GLAcctBalance.zuonr AS AssignmentReference,
  P_GLAcctBalance.bschl AS PostingKey,
  P_GLAcctBalance.bstat AS AccountingDocumentCategory,
  P_GLAcctBalance.ktosl AS TransactionTypeDetermination,
  P_GLAcctBalance.slalittype AS SubLedgerAcctLineItemType,
  P_GLAcctBalance.usnam AS AccountingDocCreatedByUser,
  P_GLAcctBalance.eprctr AS EliminationProfitCenter,
  P_GLAcctBalance.rhoart AS OriginObjectType,
  P_GLAcctBalance.glaccount_type AS GLAccountType,
  P_GLAcctBalance.ktopl AS ChartOfAccounts,
  P_GLAcctBalance.lokkt AS AlternativeGLAccount,
  P_GLAcctBalance.ktop2 AS CountryChartOfAccounts,
  P_GLAcctBalance.CreationDateTime AS CreationDateTime,
  P_GLAcctBalance.rebzg AS InvoiceReference,
  P_GLAcctBalance.rebzj AS InvoiceReferenceFiscalYear,
  P_GLAcctBalance.rebzz AS FollowOnDocumentType,
  P_GLAcctBalance.rebzt AS InvoiceItemReference,
  P_GLAcctBalance.rbest AS ReferencePurchaseOrderCategory,
  P_GLAcctBalance.ebeln AS PurchasingDocument,
  P_GLAcctBalance.ebelp AS PurchasingDocumentItem,
  P_GLAcctBalance.zekkn AS AccountAssignmentNumber,
  P_GLAcctBalance.sgtxt AS DocumentItemText,
  P_GLAcctBalance.werks AS Plant,
  P_GLAcctBalance.lifnr AS Supplier,
  P_GLAcctBalance.kunnr AS Customer,
  P_GLAcctBalance.matnr AS Product,
  P_GLAcctBalance.matkl AS SoldProductGroup,
  P_GLAcctBalance.koart AS FinancialAccountType,
  P_GLAcctBalance.umskz AS SpecialGLCode,
  P_GLAcctBalance.mwskz AS TaxCode,
  P_GLAcctBalance.hbkid AS HouseBank,
  P_GLAcctBalance.hktid AS HouseBankAccount,
  P_GLAcctBalance.xopvw AS IsOpenItemManaged,
  P_GLAcctBalance.afabe AS AssetDepreciationArea,
  P_GLAcctBalance.anln1 AS MasterFixedAsset,
  P_GLAcctBalance.anln2 AS FixedAsset,
  P_GLAcctBalance.bzdat AS AssetValueDate,
  P_GLAcctBalance.anbwa AS AssetTransactionType,
  P_GLAcctBalance.movcat AS AssetAcctTransClassfctn,
  P_GLAcctBalance.depr_period AS DepreciationFiscalPeriod,
  P_GLAcctBalance.anlgr AS GroupMasterFixedAsset,
  P_GLAcctBalance.anlgr2 AS GroupFixedAsset,
  P_GLAcctBalance.kalnr AS CostEstimate,
  P_GLAcctBalance.kzbws AS InventorySpecialStockValnType,
  P_GLAcctBalance.sobkz AS InventorySpecialStockType,
  P_GLAcctBalance.mat_kdauf AS InventorySpclStkSalesDocument,
  P_GLAcctBalance.mat_kdpos AS InventorySpclStkSalesDocItm,
  P_GLAcctBalance.mat_pspnr AS InvtrySpclStockWBSElmntIntID,
  P_GLAcctBalance.mat_ps_posid AS InventorySpclStockWBSElement,
  P_GLAcctBalance.mat_lifnr AS InventorySpecialStockSupplier,
  P_GLAcctBalance.bwtar AS InventoryValuationType,
  P_GLAcctBalance.bwkey AS ValuationArea,
  P_GLAcctBalance.SenderCompanyCode AS SenderCompanyCode,
  P_GLAcctBalance.racct_sender AS SenderGLAccount,
  P_GLAcctBalance.accas_sender AS SenderAccountAssignment,
  P_GLAcctBalance.accasty_sender AS SenderAccountAssignmentType,
  P_GLAcctBalance.beltp AS ControllingObjectDebitType,
  P_GLAcctBalance.muvflg AS QuantityIsIncomplete,
  P_GLAcctBalance.gkont AS OffsettingAccount,
  P_GLAcctBalance.gkoar AS OffsettingAccountType,
  P_GLAcctBalance.OffsettingChartOfAccounts AS OffsettingChartOfAccounts,
  P_GLAcctBalance.erlkz AS LineItemIsCompleted,
  P_GLAcctBalance.pernr AS PersonnelNumber,
  P_GLAcctBalance.scope AS ControllingObjectClass,
  P_GLAcctBalance.pbukrs AS PartnerCompanyCode,
  P_GLAcctBalance.pscope AS PartnerControllingObjectClass,
  P_GLAcctBalance.ukostl AS OriginCostCenter,
  P_GLAcctBalance.ulstar AS OriginCostCtrActivityType,
  P_GLAcctBalance.OriginProduct AS OriginProduct,
  P_GLAcctBalance.VarianceOriginGLAccount AS VarianceOriginGLAccount,
  P_GLAcctBalance.accas AS AccountAssignment,
  P_GLAcctBalance.accasty AS AccountAssignmentType,
  P_GLAcctBalance.nplnr AS ProjectNetwork,
  P_GLAcctBalance.nplnr_vorgn AS RelatedNetworkActivity,
  P_GLAcctBalance.prznr AS BusinessProcess,
  P_GLAcctBalance.kstrg AS CostObject,
  P_GLAcctBalance.qmnum AS CustomerServiceNotification,
  P_GLAcctBalance.ServiceDocumentType AS ServiceDocumentType,
  P_GLAcctBalance.ServiceDocument AS ServiceDocument,
  P_GLAcctBalance.ServiceDocumentItem AS ServiceDocumentItem,
  P_GLAcctBalance.PartnerServiceDocumentType AS PartnerServiceDocumentType,
  P_GLAcctBalance.PartnerServiceDocument AS PartnerServiceDocument,
  P_GLAcctBalance.PartnerServiceDocumentItem AS PartnerServiceDocumentItem,
  P_GLAcctBalance.erkrs AS OperatingConcern,
  P_GLAcctBalance.paccas AS PartnerAccountAssignment,
  P_GLAcctBalance.paccasty AS PartnerAccountAssignmentType,
  P_GLAcctBalance.plstar AS PartnerCostCtrActivityType,
  P_GLAcctBalance.PartnerOrder_2 AS PartnerOrder,
  P_GLAcctBalance.pautyp AS PartnerOrderCategory,
  P_GLAcctBalance.pps_posid AS PartnerWBSElement,
  P_GLAcctBalance.pps_pspid AS PartnerProject,
  P_GLAcctBalance.pkdauf AS PartnerSalesDocument,
  P_GLAcctBalance.pkdpos AS PartnerSalesDocumentItem,
  P_GLAcctBalance.pnplnr AS PartnerProjectNetwork,
  P_GLAcctBalance.pnplnr_vorgn AS PartnerProjectNetworkActivity,
  P_GLAcctBalance.pprznr AS PartnerBusinessProcess,
  P_GLAcctBalance.pkstrg AS PartnerCostObject,
  P_GLAcctBalance.fkart AS BillingDocumentType,
  P_GLAcctBalance.vkorg AS SalesOrganization,
  P_GLAcctBalance.vtweg AS DistributionChannel,
  P_GLAcctBalance.spart AS OrganizationDivision,
  P_GLAcctBalance.kdgrp AS CustomerGroup,
  P_GLAcctBalance.CustomerSupplierCountry AS CustomerSupplierCountry,
  P_GLAcctBalance.CustomerSupplierIndustry AS CustomerSupplierIndustry,
  P_GLAcctBalance.FinancialServicesProductGroup AS FinancialServicesProductGroup,
  P_GLAcctBalance.FinancialServicesBranch AS FinancialServicesBranch,
  P_GLAcctBalance.FinancialDataSource AS FinancialDataSource,
  P_GLAcctBalance.vname AS JointVenture,
  P_GLAcctBalance.egrup AS JointVentureEquityGroup,
  P_GLAcctBalance.recid AS JointVentureCostRecoveryCode,
  P_GLAcctBalance.etype AS JointVentureEquityType,
  P_GLAcctBalance.dabrz AS SettlementReferenceDate,
  P_GLAcctBalance.rcntr AS CostCenter,
  P_GLAcctBalance.lstar AS CostCtrActivityType,
  P_GLAcctBalance.aufnr AS OrderID,
  P_GLAcctBalance.autyp AS OrderCategory,
  P_GLAcctBalance.ps_psp_pnr AS WBSElementInternalID,
  P_GLAcctBalance.posid_edit AS WBSElementExternalID,
  P_GLAcctBalance.ps_posid AS WBSElement,
  P_GLAcctBalance.PartnerWBSElementInternalID AS PartnerWBSElementInternalID,
  P_GLAcctBalance.PartnerWBSElementExternalID AS PartnerWBSElementExternalID,
  P_GLAcctBalance.ps_pspid AS Project,
  P_GLAcctBalance.ps_prj_pnr AS ProjectInternalID,
  P_GLAcctBalance.pspid_edit AS ProjectExternalID,
  P_GLAcctBalance.PartnerProjectInternalID AS PartnerProjectInternalID,
  P_GLAcctBalance.PartnerProjectExternalID AS PartnerProjectExternalID,
  P_GLAcctBalance.kdauf AS SalesOrder,
  P_GLAcctBalance.kdpos AS SalesOrderItem,
  P_GLAcctBalance.augdt AS ClearingDate,
  P_GLAcctBalance.ConsolidationUnit AS ConsolidationUnit,
  P_GLAcctBalance.PartnerConsolidationUnit AS PartnerConsolidationUnit,
  P_GLAcctBalance.Company AS Company,
  P_GLAcctBalance.ConsolidationChartOfAccounts AS ConsolidationChartOfAccounts,
  P_GLAcctBalance.CnsldtnFinancialStatementItem AS CnsldtnFinancialStatementItem,
  P_GLAcctBalance.CnsldtnSubitemCategory AS CnsldtnSubitemCategory,
  P_GLAcctBalance.CnsldtnSubitem AS CnsldtnSubitem,
  P_GLAcctBalance.JrnlEntryItemObsoleteReason AS JrnlEntryItemObsoleteReason,
  P_GLAcctBalance.rtcur AS BalanceTransactionCurrency,
  P_GLAcctBalance.tsl AS AmountInBalanceTransacCrcy,
  P_GLAcctBalance.rwcur AS TransactionCurrency,
  P_GLAcctBalance.wsl AS AmountInTransactionCurrency,
  P_GLAcctBalance.rhcur AS CompanyCodeCurrency,
  P_GLAcctBalance.hsl AS AmountInCompanyCodeCurrency,
  P_GLAcctBalance.rkcur AS GlobalCurrency,
  P_GLAcctBalance.ksl AS AmountInGlobalCurrency,
  P_GLAcctBalance.FunctionalCurrency AS FunctionalCurrency,
  P_GLAcctBalance.AmountInFunctionalCurrency AS AmountInFunctionalCurrency,
  P_GLAcctBalance.rocur AS FreeDefinedCurrency1,
  P_GLAcctBalance.osl AS AmountInFreeDefinedCurrency1,
  P_GLAcctBalance.rvcur AS FreeDefinedCurrency2,
  P_GLAcctBalance.vsl AS AmountInFreeDefinedCurrency2,
  P_GLAcctBalance.rbcur AS FreeDefinedCurrency3,
  P_GLAcctBalance.bsl AS AmountInFreeDefinedCurrency3,
  P_GLAcctBalance.rccur AS FreeDefinedCurrency4,
  P_GLAcctBalance.csl AS AmountInFreeDefinedCurrency4,
  P_GLAcctBalance.rdcur AS FreeDefinedCurrency5,
  P_GLAcctBalance.dsl AS AmountInFreeDefinedCurrency5,
  P_GLAcctBalance.recur AS FreeDefinedCurrency6,
  P_GLAcctBalance.esl AS AmountInFreeDefinedCurrency6,
  P_GLAcctBalance.rfcur AS FreeDefinedCurrency7,
  P_GLAcctBalance.fsl AS AmountInFreeDefinedCurrency7,
  P_GLAcctBalance.rgcur AS FreeDefinedCurrency8,
  P_GLAcctBalance.gsl AS AmountInFreeDefinedCurrency8,
  P_GLAcctBalance.hsl_debit AS DebitAmountInCoCodeCrcy,
  P_GLAcctBalance.hsl_credit AS CreditAmountInCoCodeCrcy,
  P_GLAcctBalance.wsl_debit AS DebitAmountInTransCrcy,
  P_GLAcctBalance.wsl_credit AS CreditAmountInTransCrcy,
  P_GLAcctBalance.tsl_debit AS DebitAmountInBalanceTransCrcy,
  P_GLAcctBalance.tsl_credit AS CreditAmountInBalanceTransCrcy,
  P_GLAcctBalance.ksl_debit AS DebitAmountInGlobalCrcy,
  P_GLAcctBalance.ksl_credit AS CreditAmountInGlobalCrcy,
  P_GLAcctBalance.DebitAmountInFunctionalCrcy AS DebitAmountInFunctionalCrcy,
  P_GLAcctBalance.CreditAmountInFunctionalCrcy AS CreditAmountInFunctionalCrcy,
  P_GLAcctBalance.osl_debit AS DebitAmountInFreeDefinedCrcy1,
  P_GLAcctBalance.osl_credit AS CreditAmountInFreeDefinedCrcy1,
  P_GLAcctBalance.vsl_debit AS DebitAmountInFreeDefinedCrcy2,
  P_GLAcctBalance.vsl_credit AS CreditAmountInFreeDefinedCrcy2,
  P_GLAcctBalance.bsl_debit AS DebitAmountInFreeDefinedCrcy3,
  P_GLAcctBalance.bsl_credit AS CreditAmountInFreeDefinedCrcy3,
  P_GLAcctBalance.csl_debit AS DebitAmountInFreeDefinedCrcy4,
  P_GLAcctBalance.csl_credit AS CreditAmountInFreeDefinedCrcy4,
  P_GLAcctBalance.dsl_debit AS DebitAmountInFreeDefinedCrcy5,
  P_GLAcctBalance.dsl_credit AS CreditAmountInFreeDefinedCrcy5,
  P_GLAcctBalance.esl_debit AS DebitAmountInFreeDefinedCrcy6,
  P_GLAcctBalance.esl_credit AS CreditAmountInFreeDefinedCrcy6,
  P_GLAcctBalance.fsl_debit AS DebitAmountInFreeDefinedCrcy7,
  P_GLAcctBalance.fsl_credit AS CreditAmountInFreeDefinedCrcy7,
  P_GLAcctBalance.gsl_debit AS DebitAmountInFreeDefinedCrcy8,
  P_GLAcctBalance.gsl_credit AS CreditAmountInFreeDefinedCrcy8,
  P_GLAcctBalance.poper AS FiscalPeriod,
  P_GLAcctBalance.hsl_end_bal AS EndingBalanceAmtInCoCodeCrcy,
  P_GLAcctBalance.wsl_end_bal AS EndingBalanceAmtInTransCrcy,
  P_GLAcctBalance.tsl_end_bal AS EndingBalanceAmtInBalTransCrcy,
  P_GLAcctBalance.ksl_end_bal AS EndingBalanceAmtInGlobalCrcy,
  P_GLAcctBalance.EndingBalanceAmtInFuncnlCrcy AS EndingBalanceAmtInFuncnlCrcy,
  P_GLAcctBalance.osl_end_bal AS EndingBalAmtInFreeDfndCrcy1,
  P_GLAcctBalance.vsl_end_bal AS EndingBalAmtInFreeDfndCrcy2,
  P_GLAcctBalance.bsl_end_bal AS EndingBalAmtInFreeDfndCrcy3,
  P_GLAcctBalance.csl_end_bal AS EndingBalAmtInFreeDfndCrcy4,
  P_GLAcctBalance.dsl_end_bal AS EndingBalAmtInFreeDfndCrcy5,
  P_GLAcctBalance.esl_end_bal AS EndingBalAmtInFreeDfndCrcy6,
  P_GLAcctBalance.fsl_end_bal AS EndingBalAmtInFreeDfndCrcy7,
  P_GLAcctBalance.gsl_end_bal AS EndingBalAmtInFreeDfndCrcy8,
  P_GLAcctBalance.AccrualObjectType AS AccrualObjectType,
  P_GLAcctBalance.AccrualObject AS AccrualObject,
  P_GLAcctBalance.AccrualSubobject AS AccrualSubobject,
  P_GLAcctBalance.AccrualItemType AS AccrualItemType,
  P_GLAcctBalance.AccrualObjectLogicalSystem AS AccrualObjectLogicalSystem,
  P_GLAcctBalance.AccrualReferenceObject AS AccrualReferenceObject,
  P_GLAcctBalance.AccrualValueDate AS AccrualValueDate,
  P_GLAcctBalance.CashLedgerCompanyCode AS CashLedgerCompanyCode,
  P_GLAcctBalance.CashLedgerAccount AS CashLedgerAccount,
  P_GLAcctBalance.fikrs AS FinancialManagementArea,
  P_GLAcctBalance.FundsCenter AS FundsCenter,
  P_GLAcctBalance.FundedProgram AS FundedProgram,
  P_GLAcctBalance.rfund AS Fund,
  P_GLAcctBalance.rgrant_nbr AS GrantID,
  P_GLAcctBalance.rbudget_pd AS BudgetPeriod,
  P_GLAcctBalance.sfund AS PartnerFund,
  P_GLAcctBalance.sgrant_nbr AS PartnerGrant,
  P_GLAcctBalance.sbudget_pd AS PartnerBudgetPeriod,
  P_GLAcctBalance.PubSecBudgetAccount AS PubSecBudgetAccount,
  P_GLAcctBalance.PubSecBudgetAccountCoCode AS PubSecBudgetAccountCoCode,
  P_GLAcctBalance.PubSecBudgetCnsmpnFsclPeriod AS PubSecBudgetCnsmpnFsclPeriod,
  P_GLAcctBalance.PubSecBudgetCnsmpnFsclYear AS PubSecBudgetCnsmpnFsclYear,
  P_GLAcctBalance.PubSecBudgetIsRelevant AS PubSecBudgetIsRelevant,
  P_GLAcctBalance.PubSecBudgetCnsmpnType AS PubSecBudgetCnsmpnType,
  P_GLAcctBalance.PubSecBudgetCnsmpnAmtType AS PubSecBudgetCnsmpnAmtType,
  P_GLAcctBalance.FlowOfFundsLedgerFiscalYear AS FlowOfFundsLedgerFiscalYear,
  P_GLAcctBalance.IsStatisticalCostCenter AS IsStatisticalCostCenter,
  P_GLAcctBalance.IsStatisticalOrder AS IsStatisticalOrder,
  P_GLAcctBalance.IsStatisticalSalesDocument AS IsStatisticalSalesDocument,
  P_GLAcctBalance.WBSIsStatisticalWBSElement AS WBSIsStatisticalWBSElement,
  P_GLAcctBalance.GLAccountAuthorizationGroup AS GLAccountAuthorizationGroup,
  P_GLAcctBalance.SupplierBasicAuthorizationGrp AS SupplierBasicAuthorizationGrp,
  P_GLAcctBalance.CustomerBasicAuthorizationGrp AS CustomerBasicAuthorizationGrp,
  P_GLAcctBalance.AcctgDocTypeAuthorizationGroup AS AcctgDocTypeAuthorizationGroup,
  P_GLAcctBalance.OrderType AS OrderType,
  P_GLAcctBalance.SalesOrderType AS SalesOrderType,
  P_GLAcctBalance.AssetClass AS AssetClass
FROM P_GLAcctBalance
LEFT OUTER JOIN I_FiscalYearForCompanyCode AS _FiscalYear ON FiscalYear = _FiscalYear.FiscalYear AND CompanyCode = _FiscalYear.CompanyCode association[0..1] to I_ControllingArea as _ControllingArea on ControllingArea = _ControllingArea.ControllingArea association[0..1] to I_Currency as _BalanceTransactionCurrency on BalanceTransactionCurrency = _BalanceTransactionCurrency.Currency association[0..1] to I_Currency as _TransactionCurrency on TransactionCurrency = _TransactionCurrency.Currency association[1] to I_Currency as _CompanyCodeCurrency on CompanyCodeCurrency = _CompanyCodeCurrency.Currency association[0..1] to I_Currency as _GlobalCurrency on GlobalCurrency = _GlobalCurrency.Currency association[0..1] to I_Currency as _FreeDefinedCurrency1 on FreeDefinedCurrency1 = _FreeDefinedCurrency1.Currency association[0..1] to I_Currency as _FreeDefinedCurrency2 on FreeDefinedCurrency2 = _FreeDefinedCurrency2.Currency association[0..1] to I_Currency as _FreeDefinedCurrency3 on FreeDefinedCurrency3 = _FreeDefinedCurrency3.Currency association[0..1] to I_Currency as _FreeDefinedCurrency4 on FreeDefinedCurrency4 = _FreeDefinedCurrency4.Currency association[0..1] to I_Currency as _FreeDefinedCurrency5 on FreeDefinedCurrency5 = _FreeDefinedCurrency5.Currency association[0..1] to I_Currency as _FreeDefinedCurrency6 on FreeDefinedCurrency6 = _FreeDefinedCurrency6.Currency association[0..1] to I_Currency as _FreeDefinedCurrency7 on FreeDefinedCurrency7 = _FreeDefinedCurrency7.Currency association[0..1] to I_Currency as _FreeDefinedCurrency8 on FreeDefinedCurrency8 = _FreeDefinedCurrency8.Currency association[0..1] to I_Segment as _Segment on Segment = _Segment.Segment association[0..1] to I_Segment as _PartnerSegment on PartnerSegment = _PartnerSegment.Segment association[0..*] to I_ProfitCenter as _ProfitCenter on ControllingArea = _ProfitCenter.ControllingArea AND ProfitCenter = _ProfitCenter.ProfitCenter association[0..*] to I_ProfitCenter as _PartnerProfitCenter on ControllingArea = _PartnerProfitCenter.ControllingArea AND PartnerProfitCenter = _PartnerProfitCenter.ProfitCenter association[0..1] to 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..*] to I_CostCenter as _CostCenter on ControllingArea = _CostCenter.ControllingArea AND CostCenter = _CostCenter.CostCenter association[0..1] to 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..*] to I_CostCenter as _PartnerCostCenter on ControllingArea = _PartnerCostCenter.ControllingArea AND PartnerCostCenter = _PartnerCostCenter.CostCenter association[0..1] to I_BusinessArea as _BusinessArea on BusinessArea = _BusinessArea.BusinessArea association[0..1] to I_BusinessArea as _PartnerBusinessArea on PartnerBusinessArea = _PartnerBusinessArea.BusinessArea association[0..1] to I_FunctionalArea as _FunctionalArea on FunctionalArea = _FunctionalArea.FunctionalArea association[0..1] to I_FunctionalArea as _PartnerFunctionalArea on PartnerFunctionalArea = _PartnerFunctionalArea.FunctionalArea association[0..1] to I_GLAccountInChartOfAccounts as _GLAccountInChartOfAccounts on ChartOfAccounts = _GLAccountInChartOfAccounts.ChartOfAccounts AND GLAccount = _GLAccountInChartOfAccounts.GLAccount association[0..1] to I_GLAccountInChartOfAccounts as _GLAccountHierarchy on ChartOfAccounts = _GLAccountHierarchy.ChartOfAccounts AND GLAccountHierarchy = _GLAccountHierarchy.GLAccount association[1] to I_ChartOfAccounts as _ChartOfAccounts on ChartOfAccounts = _ChartOfAccounts.ChartOfAccounts association[0..1] to I_GLAccountInCompanyCode as _GLAccountInCompanyCode on CompanyCode = _GLAccountInCompanyCode.CompanyCode AND GLAccount = _GLAccountInCompanyCode.GLAccount association[0..1] to I_AccountingDocumentType as _AccountingDocumentType on AccountingDocumentType = _AccountingDocumentType.AccountingDocumentType association[0..1] to I_FinancialAccountType as _FinancialAccountType on FinancialAccountType = _FinancialAccountType.FinancialAccountType association[1] to I_DebitCreditCode as _DebitCreditCode on DebitCreditCode = _DebitCreditCode.DebitCreditCode association[0..1] to I_Material as _Material on Material = _Material.Material association[0..1] to I_Product as _Product on Product = _Product.Product association[0..1] to I_Plant as _Plant on Plant = _Plant.Plant association[0..1] to I_Ledger as _Ledger on Ledger = _Ledger.Ledger association[0..1] to I_CustomerGroup as _CustomerGroup on CustomerGroup = _CustomerGroup.CustomerGroup association[0..1] to I_MaterialGroup as _MaterialGroup on MaterialGroup = _MaterialGroup.MaterialGroup association[0..1] to I_ProductGroup as _ProductGroup on ProductGroup = _ProductGroup.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_Customer AS _Customer ON Customer = _Customer.Customer  -- association [0..1]
LEFT OUTER JOIN I_Supplier AS _Supplier ON Supplier = _Supplier.Supplier  -- association [0..1]
LEFT OUTER JOIN I_CalendarDate AS _CalendarDate ON PostingDate = _CalendarDate.CalendarDate association[0..1] to I_Ledger as _SourceLedger on SourceLedger = _SourceLedger.Ledger association[0..1] to I_PostingKey as _PostingKey on PostingKey = _PostingKey.PostingKey association[0..*] to I_ProfitCenter as _EliminationProfitCenter on ControllingArea = _EliminationProfitCenter.ControllingArea AND EliminationProfitCenter = _EliminationProfitCenter.ProfitCenter  -- association [0..1]
LEFT OUTER JOIN I_Supplier AS _InventorySpecialStockSupplier ON InventorySpecialStockSupplier = _InventorySpecialStockSupplier.Supplier association[0..1] to I_GLAccountInChartOfAccounts as _AlternativeGLAccount on CountryChartOfAccounts = _AlternativeGLAccount.ChartOfAccounts AND AlternativeGLAccount = _AlternativeGLAccount.GLAccount association[0..1] to I_SalesOrder as _SalesOrder on SalesOrder = _SalesOrder.SalesOrder association[0..1] to I_SalesOrderItem as _SalesOrderItem on SalesOrder = _SalesOrderItem.SalesOrder AND SalesOrderItem = _SalesOrderItem.SalesOrderItem association[0..1] to I_SalesDocument as _SalesDocument on SalesDocument = _SalesDocument.SalesDocument association[0..1] to I_SalesDocumentItem as _SalesDocumentItem on SalesDocument = _SalesDocumentItem.SalesDocument AND SalesDocumentItem = _SalesDocumentItem.SalesDocumentItem association[0..1] to I_InternalOrder as _InternalOrder on OrderID = _InternalOrder.InternalOrder association[0..1] to I_Order as _Order on OrderID = _Order.OrderID association[0..1] to I_Employment as _Employment on PersonnelNumber = _Employment.EmploymentInternalID AND PostingDate <= _Employment.EndDate  -- association [0..1]
LEFT OUTER JOIN I_PersonWorkAgreement_1 AS _PersonWorkAgreement_1 ON PersonnelNumber = _PersonWorkAgreement_1.PersonWorkAgreement association[0..1] to I_FinancialTransactionType as _FinancialTransactionType on FinancialTransactionType = _FinancialTransactionType.FinancialTransactionType association[0..1] to I_BusinessTransactionType as _BusinessTransactionType on BusinessTransactionType = _BusinessTransactionType.BusinessTransactionType association[0..1] to I_ReferenceDocumentType as _ReferenceDocumentType on ReferenceDocumentType = _ReferenceDocumentType.ReferenceDocumentType association[0..1] to I_ReferenceDocumentType as _PredecessorReferenceDocType on PredecessorReferenceDocType = _PredecessorReferenceDocType.ReferenceDocumentType association[0..1] to I_AccountingDocumentCategory as _AccountingDocumentCategory on AccountingDocumentCategory = _AccountingDocumentCategory.AccountingDocumentCategory association[0..1] to I_User as _User on AccountingDocCreatedByUser = _User.UserID association[0..1] to I_GLAccountType as _GLAccountType on GLAccountType = _GLAccountType.GLAccountType association[0..1] to I_FinancialAccountType as _OffsettingAccountType on OffsettingAccountType = _OffsettingAccountType.FinancialAccountType association[0..1] to I_GLAccountInChartOfAccounts as _SenderGLAccount on ChartOfAccounts = _SenderGLAccount.ChartOfAccounts AND SenderGLAccount = _SenderGLAccount.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] to I_ChartOfAccounts as _OffsettingChartOfAccounts on OffsettingChartOfAccounts = _OffsettingChartOfAccounts.ChartOfAccounts association[0..1] to I_ChartOfAccounts as _CountryChartOfAccounts on CountryChartOfAccounts = _CountryChartOfAccounts.ChartOfAccounts association[0..1] to I_PurchasingDocument as _PurchasingDocument on PurchasingDocument = _PurchasingDocument.PurchasingDocument association[0..1] to I_PurchasingDocumentItem as _PurchasingDocumentItem on PurchasingDocument = _PurchasingDocumentItem.PurchasingDocument AND PurchasingDocumentItem = _PurchasingDocumentItem.PurchasingDocumentItem association[0..1] to I_SpecialGLCode as _SpecialGLCode on SpecialGLCode = _SpecialGLCode.SpecialGLCode AND FinancialAccountType = _SpecialGLCode.FinancialAccountType association[0..*] to I_TaxCode as _TaxCode on TaxCode = _TaxCode.TaxCode association[0..1] to I_Housebank as _HouseBank on CompanyCode = _HouseBank.CompanyCode AND HouseBank = _HouseBank.HouseBank association[1..1] to I_AccountingDocument as _ClearingAccountingDocument on CompanyCode = _ClearingAccountingDocument.CompanyCode AND FiscalYear = _ClearingAccountingDocument.FiscalYear AND ClearingAccountingDocument = _ClearingAccountingDocument.AccountingDocument  -- 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_FiscalYearForCompanyCode AS _ClearingJrnlEntryFiscalYear ON ClearingJournalEntryFiscalYear = _ClearingJrnlEntryFiscalYear.FiscalYear AND CompanyCode = _ClearingJrnlEntryFiscalYear.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_MasterFixedAsset AS _MasterFixedAsset ON CompanyCode = _MasterFixedAsset.CompanyCode AND MasterFixedAsset = _MasterFixedAsset.MasterFixedAsset association[0..1] to I_FixedAsset as _FixedAsset on CompanyCode = _FixedAsset.CompanyCode AND MasterFixedAsset = _FixedAsset.MasterFixedAsset AND FixedAsset = _FixedAsset.FixedAsset  -- association [0..1]
LEFT OUTER JOIN I_MasterFixedAsset AS _GroupMasterFixedAsset ON CompanyCode = _GroupMasterFixedAsset.CompanyCode AND GroupMasterFixedAsset = _GroupMasterFixedAsset.MasterFixedAsset association[0..1] to I_FixedAsset as _GroupFixedAsset on CompanyCode = _GroupFixedAsset.CompanyCode AND GroupMasterFixedAsset = _GroupFixedAsset.MasterFixedAsset AND GroupFixedAsset = _GroupFixedAsset.FixedAsset association[0..1] to I_BusinessProcess as _BusinessProcess on ControllingArea = _BusinessProcess.ControllingArea AND BusinessProcess = _BusinessProcess.BusinessProcess association[0..*] to I_CostCenterActivityType as _PartnerCostCtrActivityType on ControllingArea = _PartnerCostCtrActivityType.ControllingArea AND PartnerCostCtrActivityType = _PartnerCostCtrActivityType.CostCtrActivityType association[0..1] to I_InternalOrder as _PartnerOrder on PartnerOrder = _PartnerOrder.InternalOrder  -- association [0..1]
LEFT OUTER JOIN I_Order AS _PartnerOrder_2 ON PartnerOrder = _PartnerOrder_2.OrderID association[0..1] to I_OrderCategory as _PartnerOrderCategory on PartnerOrderCategory = _PartnerOrderCategory.OrderCategory  -- association [0..1]
LEFT OUTER JOIN I_WBSElementBasicData AS _WBSElementBasicData ON WBSElementInternalID = _WBSElementBasicData.WBSElementInternalID  -- association [0..1]
LEFT OUTER JOIN I_WBSElementByExternalID AS _WBSElementExternalID ON WBSElementExternalID = _WBSElementExternalID.WBSElementExternalID association[0..1] to I_WBSElementByInternalKey as _WBSElementInternalID on WBSElementInternalID = _WBSElementInternalID.WBSElementInternalID association[0..1] to I_WBSElement as _WBSElement on WBSElement = _WBSElement.WBSElement association[0..1] to I_WBSElement as _PartnerWBSElement on PartnerWBSElement = _PartnerWBSElement.WBSElement association[0..1] to I_Project as _PartnerProject on PartnerProject = _PartnerProject.Project association[0..1] to I_SalesDocument as _PartnerSalesDocument on PartnerSalesDocument = _PartnerSalesDocument.SalesDocument association[0..1] to I_SalesDocumentItem as _PartnerSalesDocumentItem on PartnerSalesDocument = _PartnerSalesDocumentItem.SalesDocument AND PartnerSalesDocumentItem = _PartnerSalesDocumentItem.SalesDocumentItem association[0..1] to I_BusinessProcess as _PartnerBusinessProcess on ControllingArea = _PartnerBusinessProcess.ControllingArea AND PartnerBusinessProcess = _PartnerBusinessProcess.BusinessProcess association[0..1] to I_BillingDocumentType as _BillingDocumentType on BillingDocumentType = _BillingDocumentType.BillingDocumentType association[0..1] to I_SalesOrganization as _SalesOrganization on SalesOrganization = _SalesOrganization.SalesOrganization association[0..1] to I_DistributionChannel as _DistributionChannel on DistributionChannel = _DistributionChannel.DistributionChannel association[0..1] to I_Material as _SoldMaterial on SoldMaterial = _SoldMaterial.Material association[0..1] to I_Product as _SoldProduct on SoldProduct = _SoldProduct.Product association[0..1] to I_Fund as _Fund on FinancialManagementArea = _Fund.FinancialManagementArea AND Fund = _Fund.Fund association[0..1] to I_Fund as _PartnerFund on FinancialManagementArea = _PartnerFund.FinancialManagementArea AND PartnerFund = _PartnerFund.Fund association[0..*] to I_FundsCenter as _FundsCenter on FinancialManagementArea = _FundsCenter.FinancialManagementArea AND FundsCenter = _FundsCenter.FundsCenter association[0..1] to I_CompanyCode as _PartnerCompanyCode on PartnerCompanyCode = _PartnerCompanyCode.CompanyCode association[0..1] to I_InventoryValuationType as _InventorySpecialStockValnType on InventorySpecialStockValnType = _InventorySpecialStockValnType.InventoryValuationType association[0..1] to I_InventorySpecialStockType as _InventorySpecialStockType on InventorySpecialStockType = _InventorySpecialStockType.InventorySpecialStockType association[0..1] to I_InvtrySpecialStockValnType as _InventorySpclStockValnType on InvtrySpecialStockValnType_2 = _InventorySpclStockValnType.InventorySpecialStockValnType association[0..1] to I_SalesDocument as _InventorySpclStkSalesDocument on InventorySpclStkSalesDocument = _InventorySpclStkSalesDocument.SalesDocument association[0..1] to I_SalesDocumentItem as _InventorySpclStkSalesDocItm on InventorySpclStkSalesDocument = _InventorySpclStkSalesDocItm.SalesDocument AND InventorySpclStkSalesDocItm = _InventorySpclStkSalesDocItm.SalesDocumentItem association[0..1] to I_WBSElementByInternalKey as _InvtrySpclStockWBSElmntIntID on InvtrySpclStockWBSElmntIntID = _InvtrySpclStockWBSElmntIntID.WBSElementInternalID association[0..1] to I_WBSElement as _InventorySpclStockWBSElement on InventorySpclStockWBSElement = _InventorySpclStockWBSElement.WBSElement  -- association [0..1]
LEFT OUTER JOIN I_WBSElementBasicData AS _InvtrySpclStkWBSElmntBscData ON InvtrySpclStockWBSElmntIntID = _InvtrySpclStkWBSElmntBscData.WBSElementInternalID association[0..1] to I_InventoryValuationType as _InventoryValuationType on InventoryValuationType = _InventoryValuationType.InventoryValuationType association[0..1] to I_ControllingObjectClass as _ControllingObjectClass on ControllingObjectClass = _ControllingObjectClass.ControllingObjectClass association[1..1] to I_Partnercompany as _PartnerCompany on PartnerCompany = _PartnerCompany.PartnerCompany association[0..1] to I_ControllingObjectClass as _PartnerControllingObjectClass on PartnerControllingObjectClass = _PartnerControllingObjectClass.ControllingObjectClass association[0..*] to I_CostCenter as _OriginCostCenter on ControllingArea = _OriginCostCenter.ControllingArea AND OriginCostCenter = _OriginCostCenter.CostCenter association[0..*] to I_CostCenterActivityType as _CostCtrActivityType on ControllingArea = _CostCtrActivityType.ControllingArea AND CostCtrActivityType = _CostCtrActivityType.CostCtrActivityType association[0..*] to I_CostCenterActivityType as _OriginCostCtrActivityType on ControllingArea = _OriginCostCtrActivityType.ControllingArea AND OriginCostCtrActivityType = _OriginCostCtrActivityType.CostCtrActivityType association[0..1] to I_OrderCategory as _OrderCategory on OrderCategory = _OrderCategory.OrderCategory association[0..1] to I_MovementCategory as _MovementCategory on AssetAcctTransClassfctn = _MovementCategory.AssetAcctTransClassfctn association[0..1] to I_AssetTransactionType as _AssetTransactionType on AssetTransactionType = _AssetTransactionType.AssetTransactionType association[0..1] to I_BudgetPeriod as _BudgetPeriod on BudgetPeriod = _BudgetPeriod.BudgetPeriod association[0..1] to I_FinancialManagementArea as _FinancialManagementArea on FinancialManagementArea = _FinancialManagementArea.FinancialManagementArea association[0..1] to I_HouseBankAccount as _HouseBankAccount on CompanyCode = _HouseBankAccount.CompanyCode AND HouseBank = _HouseBankAccount.HouseBank AND HouseBankAccount = _HouseBankAccount.HouseBankAccount association[0..1] to I_LogicalSystem as _LogicalSystem on LogicalSystem = _LogicalSystem.LogicalSystem association[0..1] to I_OperatingConcern as _OperatingConcern on OperatingConcern = _OperatingConcern.OperatingConcern association[0..1] to I_ProjectNetwork as _ProjectNetwork on ProjectNetwork = _ProjectNetwork.ProjectNetwork association[0..1] to I_Purreqvaluationarea as _PurReqValuationArea on ValuationArea = _PurReqValuationArea.ValuationArea association[0..1] to I_FiscalYearVariant as _FiscalYearVariant on FiscalYearVariant = _FiscalYearVariant.FiscalYearVariant  -- association [0..1]
LEFT OUTER JOIN I_FiscalCalendarDate AS _FiscalCalendarDate ON FiscalYearVariant = _FiscalCalendarDate.FiscalYearVariant AND PostingDate = _FiscalCalendarDate.CalendarDate  -- 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_ProjectByExternalID AS _ProjectExternalID ON ProjectExternalID = _ProjectExternalID.ProjectExternalID  -- association [0..1]
LEFT OUTER JOIN I_GLAccountFlowType AS _GLAccountFlowType ON GLAccountFlowType = _GLAccountFlowType.GLAccountFlowType  -- 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_Grant AS _Grant ON GrantID = _Grant.GrantID  -- association [0..1]
LEFT OUTER JOIN I_Grant AS _PartnerGrant ON PartnerGrant = _PartnerGrant.GrantID  -- association [0..1]
LEFT OUTER JOIN I_FinServicesProductGroup AS _FinServicesProductGroup ON FinancialServicesProductGroup = _FinServicesProductGroup.FinancialServicesProductGroup  -- association [0..1]
LEFT OUTER JOIN I_FinancialServicesBranch AS _FinancialServicesBranch ON FinancialServicesBranch = _FinancialServicesBranch.FinancialServicesBranch  -- association [0..1]
LEFT OUTER JOIN I_FinancialDataSource AS _FinancialDataSource ON FinancialDataSource = _FinancialDataSource.FinancialDataSource  -- association [0..1]
LEFT OUTER JOIN I_CustomerSupplierIndustry AS _CustomerSupplierIndustry ON CustomerSupplierIndustry = _CustomerSupplierIndustry.Industry  -- association [0..1]
LEFT OUTER JOIN I_Country AS _CustomerSupplierCountry ON CustomerSupplierCountry = _CustomerSupplierCountry.Country  -- association [0..1]
;