I_AvgDailyBalKeyFigCube

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_AvgDailyBalKeyFigCube.
-- 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: IADBKFCUBE
-- Parameters: P_ReportingDate : gle_dte_adb_keydate, P_CreationTime : gle_dte_adb_creation_time, P_CreationDate : gle_dte_adb_creation_date

CREATE VIEW I_AvgDailyBalKeyFigCube AS
SELECT
  Ledger,
  CompanyCode,
  FiscalYear,
  AccountingDocument,
  LedgerGLLineItem,
  SourceLedger,
  LedgerFiscalYear,
  FlowOfFundsLedgerFiscalYear,
  GLRecordType,
  FinancialTransactionType,
  ControllingBusTransacType,
  BusinessTransactionType,
  ReferenceDocumentContext,
  ReferenceDocument,
  ReferenceDocumentItem,
  ReferenceDocumentItemGroup,
  TransactionSubitem,
  IsReversal,
  IsReversed,
  ReversalReferenceDocumentCntxt,
  ReversalReferenceDocument,
  IsSettlement,
  IsSettled,
  PredecessorReferenceDocType,
  PredecessorReferenceDocCntxt,
  PredecessorReferenceDocument,
  PredecessorReferenceDocItem,
  SourceReferenceDocumentType,
  SourceLogicalSystem,
  SourceReferenceDocumentCntxt,
  SourceReferenceDocument,
  SourceReferenceDocumentItem,
  SourceReferenceDocSubitem,
  IsCommitment,
  JrnlEntryItemObsoleteReason,
  BaseUnit,
  CostSourceUnit,
  GLAccount,
  CostCenter,
  ProfitCenter,
  FunctionalArea,
  BusinessArea,
  Segment,
  ControllingArea,
  PartnerCostCenter,
  PartnerProfitCenter,
  PartnerFunctionalArea,
  PartnerBusinessArea,
  PartnerCompany,
  PartnerSegment,
  Quantity,
  ValuationQuantity,
  DebitCreditCode,
  FiscalPeriod,
  FiscalYearVariant,
  FiscalYearPeriod,
  PostingDate,
  DocumentDate,
  AccountingDocumentType,
  AccountingDocumentItem,
  AssignmentReference,
  PostingKey,
  AccountingDocumentCategory,
  TransactionTypeDetermination,
  SubLedgerAcctLineItemType,
  AccountingDocCreatedByUser,
  LastChangeDateTime,
  EliminationProfitCenter,
  OriginObjectType,
  GLAccountType,
  ChartOfAccounts,
  AlternativeGLAccount,
  CountryChartOfAccounts,
  InvoiceReference,
  InvoiceReferenceFiscalYear,
  FollowOnDocumentType,
  InvoiceItemReference,
  ReferencePurchaseOrderCategory,
  PurchasingDocument,
  PurchasingDocumentItem,
  AccountAssignmentNumber,
  DocumentItemText,
  SalesDocument,
  SalesDocumentItem,
  Product,
  Plant,
  Supplier,
  Customer,
  ServicesRenderedDate,
  FinancialAccountType,
  SpecialGLCode,
  TaxCode,
  HouseBank,
  HouseBankAccount,
  ClearingDate,
  ClearingAccountingDocument,
  ClearingDocFiscalYear,
  AssetDepreciationArea,
  MasterFixedAsset,
  FixedAsset,
  AssetValueDate,
  AssetTransactionType,
  AssetAcctTransClassfctn,
  DepreciationFiscalPeriod,
  GroupMasterFixedAsset,
  GroupFixedAsset,
  AssetClass,
  CostEstimate,
  cast( InventorySpecialStockValnType as fis_invtryspclstockvalntype_d preserving type ) AS InventorySpecialStockValnType,
  InventorySpecialStockValnType AS InvtrySpecialStockValnType_2,
  InventorySpecialStockType,
  InventorySpclStkSalesDocument,
  InventorySpclStkSalesDocItm,
  InventorySpecialStockSupplier,
  InventoryValuationType,
  ValuationArea,
  SenderGLAccount,
  SenderAccountAssignment,
  SenderAccountAssignmentType,
  CostOriginGroup,
  OriginSenderObject,
  ControllingDebitCreditCode,
  ControllingObjectDebitType,
  QuantityIsIncomplete,
  OffsettingAccount,
  OffsettingAccountType,
  OffsettingChartOfAccounts,
  PersonnelNumber,
  ControllingObjectClass,
  PartnerCompanyCode,
  PartnerControllingObjectClass,
  OriginCostCenter,
  OriginProfitCenter,
  OriginCostCtrActivityType,
  AccountAssignment,
  AccountAssignmentType,
  CostCtrActivityType,
  OrderID,
  OrderCategory,
  WBSElementInternalID,
  ProjectNetwork,
  RelatedNetworkActivity,
  BusinessProcess,
  BillableControl,
  CostAnalysisResource,
  CustomerServiceNotification,
  OperatingConcern,
  PartnerAccountAssignment,
  PartnerAccountAssignmentType,
  PartnerCostCtrActivityType,
  PartnerOrder,
  PartnerOrderCategory,
  PartnerSalesDocument,
  PartnerSalesDocumentItem,
  PartnerProjectNetwork,
  PartnerProjectNetworkActivity,
  PartnerBusinessProcess,
  PartnerCostObject,
  WorkItem,
  WorkCenterInternalID,
  OrderOperation,
  OrderItem,
  OrderSuboperation,
  Equipment,
  FunctionalLocation,
  Assembly,
  MaintenanceActivityType,
  MaintenanceOrderPlanningCode,
  MaintPriorityType,
  MaintPriority,
  SuperiorOrder,
  ProductGroup,
  MaintenanceOrderIsPlanned,
  BillingDocumentType,
  SalesOrganization,
  DistributionChannel,
  OrganizationDivision,
  SoldProduct,
  SoldProductGroup,
  CustomerGroup,
  CustomerSupplierCountry,
  CustomerSupplierIndustry,
  SalesDistrict,
  BillToParty,
  ShipToParty,
  CustomerSupplierCorporateGroup,
  CashLedgerCompanyCode,
  CashLedgerAccount,
  FinancialManagementArea,
  FundsCenter,
  FundedProgram,
  Fund,
  GrantID,
  BudgetPeriod,
  PartnerFund,
  PartnerGrant,
  PartnerBudgetPeriod,
  FinancialServicesProductGroup,
  FinancialServicesBranch,
  FinancialDataSource,
  JointVenture,
  JointVentureEquityGroup,
  JointVentureCostRecoveryCode,
  JointVenturePartner,
  JointVentureBillingType,
  JointVentureEquityType,
  JointVentureProductionDate,
  JointVentureBillingDate,
  JointVentureOperationalDate,
  JointVentureAccountingActivity,
  PartnerVenture,
  PartnerEquityGroup,
  SenderCostRecoveryCode,
  CutbackAccount,
  CutbackCostObject,
  REBusinessEntity,
  RealEstateBuilding,
  RealEstateProperty,
  RERentalObject,
  RealEstateContract,
  REServiceChargeKey,
  RESettlementUnitID,
  SettlementReferenceDate,
  REPartnerBusinessEntity,
  RealEstatePartnerBuilding,
  RealEstatePartnerProperty,
  REPartnerRentalObject,
  RealEstatePartnerContract,
  REPartnerServiceChargeKey,
  REPartnerSettlementUnitID,
  PartnerSettlementReferenceDate,
  AccrualObjectType,
  AccrualObject,
  AccrualSubobject,
  AccrualItemType,
  ServiceDocument,
  ServiceDocumentType,
  ConsolidationUnit,
  PartnerConsolidationUnit,
  Company,
  ConsolidationChartOfAccounts,
  CnsldtnFinancialStatementItem,
  CnsldtnSubitemCategory,
  CnsldtnSubitem,
  BalanceTransactionCurrency,
  AmountInBalanceTransacCrcy,
  cast( PriorDayBalInBalTransCrcy as gle_dte_adb_pd_bal_btc ) AS PriorDayBalInBalTransCrcy,
  cast( CurrentDayActyInBalTransCrcy as gle_dte_adb_cd_acty_btc ) AS CurDayActyAmtInBalTransCrcy,
  cast( PriorMonthBalInBalTransCrcy as gle_dte_adb_pm_bal_btc ) AS PriorMonthBalInBalTransCrcy,
  cast( CurrentMonthActyInBalTransCrcy as gle_dte_adb_cm_acty_btc ) AS CurMonthActyAmtInBalTransCrcy,
  cast( YTDBalInBalTransCrcy as gle_dte_adb_ytd_bal_btc ) AS YTDBalInBalTransCrcy,
  cast( MTDAvgDailyBalInBalTransCrcy as gle_dte_adb_mtd_adb_btc ) AS MTDAvgDailyBalInBalTransCrcy,
  cast( QTDAvgDailyBalInBalTransCrcy as gle_dte_adb_qtd_adb_btc ) AS QTDAvgDailyBalInBalTransCrcy,
  cast( YTDAvgDailyBalInBalTransCrcy as gle_dte_adb_ytd_adb_btc ) AS YTDAvgDailyBalInBalTransCrcy,
  cast( MTDAvgActyInBalTransCrcy as gle_dte_adb_mtd_avg_act_btc ) AS MTDAvgActyAmtInBalTransCrcy,
  cast( QTDActyInBalTransCrcy as gle_dte_adb_qtd_act_btc ) AS QTDActyAmtInBalTransCrcy,
  CompanyCodeCurrency,
  AmountInCompanyCodeCurrency,
  cast( PriorDayBalInCCCrcy as gle_dte_adb_pd_bal_ccc ) AS PriorDayBalInCCCrcy,
  cast( CurrentDayActyInCCCrcy as gle_dte_adb_cd_acty_ccc ) AS CurDayActyAmtInCCCrcy,
  cast( PriorMonthBalInCCCrcy as gle_dte_adb_pm_bal_ccc ) AS PriorMonthBalInCCCrcy,
  cast( CurrentMonthActyInCCCrcy as gle_dte_adb_cm_acty_ccc ) AS CurMonthActyAmtInCCCrcy,
  cast( YTDBalInCCCrcy as gle_dte_adb_ytd_bal_ccc ) AS YTDBalInCCCrcy,
  cast( MTDAvgDailyBalInCCCrcy as gle_dte_adb_mtd_adb_ccc ) AS MTDAvgDailyBalInCCCrcy,
  cast( QTDAvgDailyBalInCCCrcy as gle_dte_adb_qtd_adb_ccc ) AS QTDAvgDailyBalInCCCrcy,
  cast( YTDAvgDailyBalInCCCrcy as gle_dte_adb_ytd_adb_ccc ) AS YTDAvgDailyBalInCCCrcy,
  cast( MTDAvgActyInCCCrcy as gle_dte_adb_mtd_avg_act_ccc ) AS MTDAvgActyAmtInCCCrcy,
  cast( QTDActyInCCCrcy as gle_dte_adb_qtd_act_ccc ) AS QTDActyAmtInCCCrcy,
  GlobalCurrency,
  AmountInGlobalCurrency,
  cast( PriorDayBalInGlobCrcy as gle_dte_adb_pd_bal_gc ) AS PriorDayBalInGlobCrcy,
  cast( CurrentDayActyInGlobCrcy as gle_dte_adb_cd_acty_gc ) AS CurDayActyAmtInGlobCrcy,
  cast( PriorMonthBalInGlobCrcy as gle_dte_adb_pm_bal_gc ) AS PriorMonthBalInGlobCrcy,
  cast( CurrentMonthActyInGlobCrcy as gle_dte_adb_cm_acty_gc ) AS CurMonthActyAmtInGlobCrcy,
  cast( YTDBalInGlobCrcy as gle_dte_adb_ytd_bal_gc ) AS YTDBalInGlobCrcy,
  cast( MTDAvgDailyBalInGlobCrcy as gle_dte_adb_mtd_adb_gc ) AS MTDAvgDailyBalInGlobCrcy,
  cast( QTDAvgDailyBalInGlobCrcy as gle_dte_adb_qtd_adb_gc ) AS QTDAvgDailyBalInGlobCrcy,
  cast( YTDAvgDailyBalInGlobCrcy as gle_dte_adb_ytd_adb_gc ) AS YTDAvgDailyBalInGlobCrcy,
  cast( QTDActyInGlobCrcy as gle_dte_adb_qtd_act_gc ) AS QTDActyAmtInGlobCrcy,
  cast( MTDAvgActyInGlobCrcy as gle_dte_adb_mtd_avg_act_gc ) AS MTDAvgActyAmtInGlobCrcy,
  FunctionalCurrency,
  AmountInFunctionalCurrency,
  cast( PriorDayBalInFuncnlCrcy as gle_dte_adb_pd_bal_fcc ) AS PriorDayBalInFuncnlCrcy,
  cast( CurrentDayActyInFuncnlCrcy as gle_dte_adb_cd_acty_fcc ) AS CurDayActyAmtInFuncnlCrcy,
  cast( PriorMonthBalInFuncnlCrcy as gle_dte_adb_pm_bal_fcc ) AS PriorMonthBalInFuncnlCrcy,
  cast( CurrentMonthActyInFuncnlCrcy as gle_dte_adb_cm_acty_fcc ) AS CurMonthActyAmtInFuncnlCrcy,
  cast( YTDBalInFuncnlCrcy as gle_dte_adb_ytd_bal_fcc ) AS YTDBalInFuncnlCrcy,
  cast( MTDAvgDailyBalInFuncnlCrcy as gle_dte_adb_mtd_adb_fcc ) AS MTDAvgDailyBalInFuncnlCrcy,
  cast( QTDAvgDailyBalInFuncnlCrcy as gle_dte_adb_qtd_adb_fcc ) AS QTDAvgDailyBalInFuncnlCrcy,
  cast( YTDAvgDailyBalInFuncnlCrcy as gle_dte_adb_ytd_adb_fcc ) AS YTDAvgDailyBalInFuncnlCrcy,
  cast( QTDActyInFuncnlCrcy as gle_dte_adb_qtd_act_fcc ) AS QTDActyAmtInFuncnlCrcy,
  cast( MTDAvgActyInFuncnlCrcy as gle_dte_adb_mtd_avg_act_fcc ) AS MTDAvgActyAmtInFuncnlCrcy,
  FreeDefinedCurrency1,
  cast( PriorDayBalInFDCrcy1 as gle_dte_adb_pd_bal_fdc1 ) AS PriorDayBalInFDCrcy1,
  cast( CurrentDayActyInFDCrcy1 as gle_dte_adb_cd_acty_fdc1 ) AS CurDayActyAmtInFDCrcy1,
  cast( PriorMonthBalInFDCrcy1 as gle_dte_adb_pm_bal_fdc1 ) AS PriorMonthBalInFDCrcy1,
  cast( CurrentMonthActyInFDCrcy1 as gle_dte_adb_cm_acty_fdc1 ) AS CurMonthActyAmtInFDCrcy1,
  cast( YTDBalInFDCrcy1 as gle_dte_adb_ytd_bal_fdc1 ) AS YTDBalInFDCrcy1,
  cast( MTDAvgDailyBalInFDCrcy1 as gle_dte_adb_mtd_adb_fdc1 ) AS MTDAvgDailyBalInFDCrcy1,
  cast( QTDAvgDailyBalInFDCrcy1 as gle_dte_adb_qtd_adb_fdc1 ) AS QTDAvgDailyBalInFDCrcy1,
  cast( YTDAvgDailyBalInFDCrcy1 as gle_dte_adb_ytd_adb_fdc1 ) AS YTDAvgDailyBalInFDCrcy1,
  cast( MTDAvgActyInFDCrcy1 as gle_dte_adb_mtd_avg_act_fdc1 ) AS MTDAvgActyAmtInFDCrcy1,
  cast( QTDActyInFDCrcy1 as gle_dte_adb_qtd_act_fdc1 ) AS QTDActyAmtInFDCrcy1,
  FreeDefinedCurrency2,
  AmountInFreeDefinedCurrency2,
  cast( PriorDayBalInFDCrcy2 as gle_dte_adb_pd_bal_fdc2 ) AS PriorDayBalInFDCrcy2,
  cast( CurrentDayActyInFDCrcy2 as gle_dte_adb_cd_acty_fdc2 ) AS CurDayActyAmtInFDCrcy2,
  cast( PriorMonthBalInFDCrcy2 as gle_dte_adb_pm_bal_fdc2 ) AS PriorMonthBalInFDCrcy2,
  cast( CurrentMonthActyInFDCrcy2 as gle_dte_adb_cm_acty_fdc2 ) AS CurMonthActyAmtInFDCrcy2,
  cast( YTDBalInFDCrcy2 as gle_dte_adb_ytd_bal_fdc2 ) AS YTDBalInFDCrcy2,
  cast( MTDAvgDailyBalInFDCrcy2 as gle_dte_adb_mtd_adb_fdc2 ) AS MTDAvgDailyBalInFDCrcy2,
  cast( QTDAvgDailyBalInFDCrcy2 as gle_dte_adb_qtd_adb_fdc2 ) AS QTDAvgDailyBalInFDCrcy2,
  cast( YTDAvgDailyBalInFDCrcy2 as gle_dte_adb_ytd_adb_fdc2 ) AS YTDAvgDailyBalInFDCrcy2,
  cast( MTDAvgActyInFDCrcy2 as gle_dte_adb_mtd_avg_act_fdc2 ) AS MTDAvgActyAmtInFDCrcy2,
  cast( QTDActyInFDCrcy2 as gle_dte_adb_qtd_act_fdc2 ) AS QTDActyAmtInFDCrcy2,
  FreeDefinedCurrency3,
  AmountInFreeDefinedCurrency3,
  cast( PriorDayBalInFDCrcy3 as gle_dte_adb_pd_bal_fdc3 ) AS PriorDayBalInFDCrcy3,
  cast( CurrentDayActyInFDCrcy3 as gle_dte_adb_cd_acty_fdc3 ) AS CurDayActyAmtInFDCrcy3,
  cast( PriorMonthBalInFDCrcy3 as gle_dte_adb_pm_bal_fdc3 ) AS PriorMonthBalInFDCrcy3,
  cast( CurrentMonthActyInFDCrcy3 as gle_dte_adb_cm_acty_fdc3 ) AS CurMonthActyAmtInFDCrcy3,
  cast( YTDBalInFDCrcy3 as gle_dte_adb_ytd_bal_fdc3 ) AS YTDBalInFDCrcy3,
  cast( MTDAvgDailyBalInFDCrcy3 as gle_dte_adb_mtd_adb_fdc3 ) AS MTDAvgDailyBalInFDCrcy3,
  cast( QTDAvgDailyBalInFDCrcy3 as gle_dte_adb_qtd_adb_fdc3 ) AS QTDAvgDailyBalInFDCrcy3,
  cast( YTDAvgDailyBalInFDCrcy3 as gle_dte_adb_ytd_adb_fdc3 ) AS YTDAvgDailyBalInFDCrcy3,
  cast( MTDAvgActyInFDCrcy3 as gle_dte_adb_mtd_avg_act_fdc3 ) AS MTDAvgActyAmtInFDCrcy3,
  cast( QTDActyInFDCrcy3 as gle_dte_adb_qtd_act_fdc3 ) AS QTDActyAmtInFDCrcy3,
  FreeDefinedCurrency4,
  AmountInFreeDefinedCurrency4,
  cast( PriorDayBalInFDCrcy4 as gle_dte_adb_pd_bal_fdc4 ) AS PriorDayBalInFDCrcy4,
  cast( CurrentDayActyInFDCrcy4 as gle_dte_adb_cd_acty_fdc4 ) AS CurDayActyAmtInFDCrcy4,
  cast( PriorMonthBalInFDCrcy4 as gle_dte_adb_pm_bal_fdc4 ) AS PriorMonthBalInFDCrcy4,
  cast( CurrentMonthActyInFDCrcy4 as gle_dte_adb_cm_acty_fdc4 ) AS CurMonthActyAmtInFDCrcy4,
  cast( YTDBalInFDCrcy4 as gle_dte_adb_ytd_bal_fdc4 ) AS YTDBalInFDCrcy4,
  cast( MTDAvgDailyBalInFDCrcy4 as gle_dte_adb_mtd_adb_fdc4 ) AS MTDAvgDailyBalInFDCrcy4,
  cast( QTDAvgDailyBalInFDCrcy4 as gle_dte_adb_qtd_adb_fdc4 ) AS QTDAvgDailyBalInFDCrcy4,
  cast( YTDAvgDailyBalInFDCrcy4 as gle_dte_adb_ytd_adb_fdc4 ) AS YTDAvgDailyBalInFDCrcy4,
  cast( MTDAvgActyInFDCrcy4 as gle_dte_adb_mtd_avg_act_fdc4 ) AS MTDAvgActyAmtInFDCrcy4,
  cast( QTDActyInFDCrcy4 as gle_dte_adb_qtd_act_fdc4 ) AS QTDActyAmtInFDCrcy4,
  FreeDefinedCurrency5,
  AmountInFreeDefinedCurrency5,
  cast( PriorDayBalInFDCrcy5 as gle_dte_adb_pd_bal_fdc5 ) AS PriorDayBalInFDCrcy5,
  cast( CurrentDayActyInFDCrcy5 as gle_dte_adb_cd_acty_fdc5 ) AS CurDayActyAmtInFDCrcy5,
  cast( PriorMonthBalInFDCrcy5 as gle_dte_adb_pm_bal_fdc5 ) AS PriorMonthBalInFDCrcy5,
  cast( CurrentMonthActyInFDCrcy5 as gle_dte_adb_cm_acty_fdc5 ) AS CurMonthActyAmtInFDCrcy5,
  cast( YTDBalInFDCrcy5 as gle_dte_adb_ytd_bal_fdc5 ) AS YTDBalInFDCrcy5,
  cast( MTDAvgDailyBalInFDCrcy5 as gle_dte_adb_mtd_adb_fdc5 ) AS MTDAvgDailyBalInFDCrcy5,
  cast( QTDAvgDailyBalInFDCrcy5 as gle_dte_adb_qtd_adb_fdc5 ) AS QTDAvgDailyBalInFDCrcy5,
  cast( YTDAvgDailyBalInFDCrcy5 as gle_dte_adb_ytd_adb_fdc5 ) AS YTDAvgDailyBalInFDCrcy5,
  cast( MTDAvgActyInFDCrcy5 as gle_dte_adb_mtd_avg_act_fdc5 ) AS MTDAvgActyAmtInFDCrcy5,
  cast( QTDActyInFDCrcy5 as gle_dte_adb_qtd_act_fdc5 ) AS QTDActyAmtInFDCrcy5,
  FreeDefinedCurrency6,
  AmountInFreeDefinedCurrency6,
  cast( PriorDayBalInFDCrcy6 as gle_dte_adb_pd_bal_fdc6 ) AS PriorDayBalInFDCrcy6,
  cast( CurrentDayActyInFDCrcy6 as gle_dte_adb_cd_acty_fdc6 ) AS CurDayActyAmtInFDCrcy6,
  cast( PriorMonthBalInFDCrcy6 as gle_dte_adb_pm_bal_fdc6 ) AS PriorMonthBalInFDCrcy6,
  cast( CurrentMonthActyInFDCrcy6 as gle_dte_adb_cm_acty_fdc6 ) AS CurMonthActyAmtInFDCrcy6,
  cast( YTDBalInFDCrcy6 as gle_dte_adb_ytd_bal_fdc6 ) AS YTDBalInFDCrcy6,
  cast( MTDAvgDailyBalInFDCrcy6 as gle_dte_adb_mtd_adb_fdc6 ) AS MTDAvgDailyBalInFDCrcy6,
  cast( QTDAvgDailyBalInFDCrcy6 as gle_dte_adb_qtd_adb_fdc6 ) AS QTDAvgDailyBalInFDCrcy6,
  cast( YTDAvgDailyBalInFDCrcy6 as gle_dte_adb_ytd_adb_fdc6 ) AS YTDAvgDailyBalInFDCrcy6,
  cast( MTDAvgActyInFDCrcy6 as gle_dte_adb_mtd_avg_act_fdc6 ) AS MTDAvgActyAmtInFDCrcy6,
  cast( QTDActyInFDCrcy6 as gle_dte_adb_qtd_act_fdc6 ) AS QTDActyAmtInFDCrcy6,
  FreeDefinedCurrency7,
  AmountInFreeDefinedCurrency7,
  cast( PriorDayBalInFDCrcy7 as gle_dte_adb_pd_bal_fdc7 ) AS PriorDayBalInFDCrcy7,
  cast( CurrentDayActyInFDCrcy7 as gle_dte_adb_cd_acty_fdc7 ) AS CurDayActyAmtInFDCrcy7,
  cast( PriorMonthBalInFDCrcy7 as gle_dte_adb_pm_bal_fdc7 ) AS PriorMonthBalInFDCrcy7,
  cast( CurrentMonthActyInFDCrcy7 as gle_dte_adb_cm_acty_fdc7 ) AS CurMonthActyAmtInFDCrcy7,
  cast( YTDBalInFDCrcy7 as gle_dte_adb_ytd_bal_fdc7 ) AS YTDBalInFDCrcy7,
  cast( MTDAvgDailyBalInFDCrcy7 as gle_dte_adb_mtd_adb_fdc7 ) AS MTDAvgDailyBalInFDCrcy7,
  cast( QTDAvgDailyBalInFDCrcy7 as gle_dte_adb_qtd_adb_fdc7 ) AS QTDAvgDailyBalInFDCrcy7,
  cast( YTDAvgDailyBalInFDCrcy7 as gle_dte_adb_ytd_adb_fdc7 ) AS YTDAvgDailyBalInFDCrcy7,
  cast( MTDAvgActyInFDCrcy7 as gle_dte_adb_mtd_avg_act_fdc7 ) AS MTDAvgActyAmtInFDCrcy7,
  cast( QTDActyInFDCrcy7 as gle_dte_adb_qtd_act_fdc7 ) AS QTDActyAmtInFDCrcy7,
  FreeDefinedCurrency8,
  AmountInFreeDefinedCurrency8,
  cast( PriorDayBalInFDCrcy8 as gle_dte_adb_pd_bal_fdc8 ) AS PriorDayBalInFDCrcy8,
  cast( CurrentDayActyInFDCrcy8 as gle_dte_adb_cd_acty_fdc8 ) AS CurDayActyAmtInFDCrcy8,
  cast( PriorMonthBalInFDCrcy8 as gle_dte_adb_pm_bal_fdc8 ) AS PriorMonthBalInFDCrcy8,
  cast( CurrentMonthActyInFDCrcy8 as gle_dte_adb_cm_acty_fdc8 ) AS CurMonthActyAmtInFDCrcy8,
  cast( YTDBalInFDCrcy8 as gle_dte_adb_ytd_bal_fdc8 ) AS YTDBalInFDCrcy8,
  cast( MTDAvgDailyBalInFDCrcy8 as gle_dte_adb_mtd_adb_fdc8 ) AS MTDAvgDailyBalInFDCrcy8,
  cast( QTDAvgDailyBalInFDCrcy8 as gle_dte_adb_qtd_adb_fdc8 ) AS QTDAvgDailyBalInFDCrcy8,
  cast( YTDAvgDailyBalInFDCrcy8 as gle_dte_adb_ytd_adb_fdc8 ) AS YTDAvgDailyBalInFDCrcy8,
  cast( MTDAvgActyInFDCrcy8 as gle_dte_adb_mtd_avg_act_fdc8 ) AS MTDAvgActyAmtInFDCrcy8,
  cast( QTDActyInFDCrcy8 as gle_dte_adb_qtd_act_fdc8 ) AS QTDActyAmtInFDCrcy8
FROM P_AvgDailyBalKeyFig
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]
LEFT OUTER JOIN I_JournalEntry AS _JournalEntry ON CompanyCode = _JournalEntry.CompanyCode AND FiscalYear = _JournalEntry.FiscalYear AND AccountingDocument = _JournalEntry.AccountingDocument  -- association [1..1]
LEFT OUTER JOIN I_CompanyCode AS _CompanyCode ON CompanyCode = _CompanyCode.CompanyCode  -- association [1..1]
LEFT OUTER JOIN I_CompanyCode AS _CompanyCodeText ON CompanyCode = _CompanyCodeText.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_FiscalYearVariant AS _FiscalYearVariant ON FiscalYearVariant = _FiscalYearVariant.FiscalYearVariant  -- association [1..1]
LEFT OUTER JOIN I_FiscalYearForCompanyCode AS _FiscalYear ON FiscalYear = _FiscalYear.FiscalYear AND CompanyCode = _FiscalYear.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_FiscalYearForCompanyCode AS _LedgerFiscalYear ON LedgerFiscalYear = _LedgerFiscalYear.FiscalYear AND CompanyCode = _LedgerFiscalYear.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_FiscalYearPeriodForCmpnyCode AS _FiscalPeriod ON LedgerFiscalYear = _FiscalPeriod.FiscalYear AND FiscalPeriod = _FiscalPeriod.FiscalPeriod AND CompanyCode = _FiscalPeriod.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_FiscalCalYearPeriodForCoCode AS _FiscalYearPeriod ON FiscalYearPeriod = _FiscalYearPeriod.FiscalYearPeriod AND CompanyCode = _FiscalYearPeriod.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_FiscalYearForVariant AS _LedgerFiscalYearForVariant ON LedgerFiscalYear = _LedgerFiscalYearForVariant.FiscalYear AND FiscalYearVariant = _LedgerFiscalYearForVariant.FiscalYearVariant  -- association [0..1]
LEFT OUTER JOIN I_FiscalPeriodForVariant AS _FiscalPeriodForVariant ON LedgerFiscalYear = _FiscalPeriodForVariant.FiscalYear AND FiscalPeriod = _FiscalPeriodForVariant.FiscalPeriod AND FiscalYearVariant = _FiscalPeriodForVariant.FiscalYearVariant  -- association [0..1]
LEFT OUTER JOIN I_FiscalYearPeriodForVariant AS _FiscalYearPeriodForVariant ON FiscalYearPeriod = _FiscalYearPeriodForVariant.FiscalYearPeriod AND FiscalYearVariant = _FiscalYearPeriodForVariant.FiscalYearVariant  -- association [0..1]
LEFT OUTER JOIN I_FiscalCalendarDate AS _FiscalCalendarDate ON PostingDate = _FiscalCalendarDate.CalendarDate AND FiscalYearVariant = _FiscalCalendarDate.FiscalYearVariant  -- association [0..1]
LEFT OUTER JOIN I_ControllingArea AS _ControllingArea ON ControllingArea = _ControllingArea.ControllingArea  -- association [0..1]
LEFT OUTER JOIN I_ControllingArea AS _ControllingAreaText ON ControllingArea = _ControllingAreaText.ControllingArea  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _BalanceTransactionCurrency ON BalanceTransactionCurrency = _BalanceTransactionCurrency.Currency  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _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_Segment AS _Segment ON Segment = _Segment.Segment  -- association [0..1]
LEFT OUTER JOIN I_SegmentText AS _SegmentText ON Segment = _SegmentText.Segment  -- association [0..*]
LEFT OUTER JOIN I_ProfitCenter AS _ProfitCenter ON ControllingArea = _ProfitCenter.ControllingArea AND ProfitCenter = _ProfitCenter.ProfitCenter  -- association [0..*]
LEFT OUTER JOIN I_ProfitCenterText AS _ProfitCenterText ON ControllingArea = _ProfitCenterText.ControllingArea AND ProfitCenter = _ProfitCenterText.ProfitCenter  -- association [0..*]
LEFT OUTER JOIN I_ProfitCenter AS _CurrentProfitCenter ON ControllingArea = _CurrentProfitCenter.ControllingArea AND ProfitCenter = _CurrentProfitCenter.ProfitCenter AND _CurrentProfitCenter.ValidityStartDate <= $session.system_date AND _CurrentProfitCenter.ValidityEndDate >= $session.system_date  -- association [0..1]
LEFT OUTER JOIN I_CostCenter AS _CostCenter ON ControllingArea = _CostCenter.ControllingArea AND CostCenter = _CostCenter.CostCenter  -- association [0..*]
LEFT OUTER JOIN I_CostCenterText AS _CostCenterText ON ControllingArea = _CostCenterText.ControllingArea AND CostCenter = _CostCenterText.CostCenter  -- association [0..*]
LEFT OUTER JOIN I_CostCenter AS _CurrentCostCenter ON ControllingArea = _CurrentCostCenter.ControllingArea AND CostCenter = _CurrentCostCenter.CostCenter AND _CurrentCostCenter.ValidityStartDate <= $session.system_date AND _CurrentCostCenter.ValidityEndDate >= $session.system_date  -- association [0..1]
LEFT OUTER JOIN I_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_BusinessArea AS _BusinessArea ON BusinessArea = _BusinessArea.BusinessArea  -- association [0..1]
LEFT OUTER JOIN I_BusinessAreaText AS _BusinessAreaText ON BusinessArea = _BusinessAreaText.BusinessArea  -- association [0..*]
LEFT OUTER JOIN I_FunctionalArea AS _FunctionalArea ON FunctionalArea = _FunctionalArea.FunctionalArea  -- association [0..1]
LEFT OUTER JOIN I_FunctionalAreaText AS _FunctionalAreaText ON FunctionalArea = _FunctionalAreaText.FunctionalArea  -- association [0..*]
LEFT OUTER JOIN I_GLAccountInChartOfAccounts AS _GLAccountInChartOfAccounts ON ChartOfAccounts = _GLAccountInChartOfAccounts.ChartOfAccounts AND GLAccount = _GLAccountInChartOfAccounts.GLAccount  -- association [0..1]
LEFT OUTER JOIN I_GLAccountText AS _GLAcctInChartOfAccountsText ON ChartOfAccounts = _GLAcctInChartOfAccountsText.ChartOfAccounts AND GLAccount = _GLAcctInChartOfAccountsText.GLAccount  -- association [0..*]
LEFT OUTER JOIN I_GLAccountInCompanyCode AS _GLAccountInCompanyCode ON CompanyCode = _GLAccountInCompanyCode.CompanyCode AND GLAccount = _GLAccountInCompanyCode.GLAccount  -- association [0..1]
LEFT OUTER JOIN I_ChartOfAccounts AS _ChartOfAccounts ON ChartOfAccounts = _ChartOfAccounts.ChartOfAccounts  -- association [0..1]
LEFT OUTER JOIN I_ChartOfAccountsText AS _ChartOfAccountsText ON ChartOfAccounts = _ChartOfAccountsText.ChartOfAccounts  -- association [0..*]
LEFT OUTER JOIN I_AccountingDocumentType AS _AccountingDocumentType ON AccountingDocumentType = _AccountingDocumentType.AccountingDocumentType  -- association [0..1]
LEFT OUTER JOIN I_AccountingDocumentTypeText AS _AccountingDocumentTypeText ON AccountingDocumentType = _AccountingDocumentTypeText.AccountingDocumentType  -- association [0..*]
LEFT OUTER JOIN I_FinancialAccountType AS _FinancialAccountType ON FinancialAccountType = _FinancialAccountType.FinancialAccountType  -- association [0..1]
LEFT OUTER JOIN I_FinancialAccountTypeText AS _FinancialAccountTypeText ON FinancialAccountType = _FinancialAccountTypeText.FinancialAccountType  -- association [0..*]
LEFT OUTER JOIN I_DebitCreditCode AS _DebitCreditCode ON DebitCreditCode = _DebitCreditCode.DebitCreditCode  -- association [0..1]
LEFT OUTER JOIN I_DebitCreditCodeText AS _DebitCreditCodeText ON DebitCreditCode = _DebitCreditCodeText.DebitCreditCode  -- association [0..*]
LEFT OUTER JOIN I_Product AS _Product ON Product = _Product.Product  -- association [0..1]
LEFT OUTER JOIN I_ProductDescription AS _ProductText ON Product = _ProductText.Product  -- association [0..*]
LEFT OUTER JOIN I_Plant AS _Plant ON Plant = _Plant.Plant  -- association [0..1]
LEFT OUTER JOIN I_Ledger AS _Ledger ON Ledger = _Ledger.Ledger  -- association [1..1]
LEFT OUTER JOIN I_LedgerText AS _LedgerText ON Ledger = _LedgerText.Ledger  -- association [0..*]
LEFT OUTER JOIN I_Ledger AS _SourceLedger ON SourceLedger = _SourceLedger.Ledger  -- association [0..1]
LEFT OUTER JOIN I_Customer AS _Customer ON Customer = _Customer.Customer  -- association [0..1]
LEFT OUTER JOIN I_Customer AS _CustomerText ON Customer = _CustomerText.Customer  -- association [0..1]
LEFT OUTER JOIN I_CustomerGroup AS _CustomerGroup ON CustomerGroup = _CustomerGroup.CustomerGroup  -- association [0..1]
LEFT OUTER JOIN I_Supplier AS _Supplier ON Supplier = _Supplier.Supplier  -- association [0..1]
LEFT OUTER JOIN I_Supplier AS _SupplierText ON Supplier = _SupplierText.Supplier  -- association [0..1]
LEFT OUTER JOIN I_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_SalesDocument AS _SalesDocument ON SalesDocument = _SalesDocument.SalesDocument  -- association [0..1]
LEFT OUTER JOIN I_SalesDocumentItem AS _SalesDocumentItem ON SalesDocument = _SalesDocumentItem.SalesDocument AND SalesDocumentItem = _SalesDocumentItem.SalesDocumentItem  -- association [0..1]
LEFT OUTER JOIN I_InternalOrder AS _InternalOrder ON OrderID = _InternalOrder.InternalOrder  -- association [0..1]
LEFT OUTER JOIN I_Order AS _Order ON OrderID = _Order.OrderID  -- association [0..1]
LEFT OUTER JOIN I_CostAnalysisResource AS _CostAnalysisResource ON ControllingArea = _CostAnalysisResource.ControllingArea AND CostAnalysisResource = _CostAnalysisResource.CostAnalysisResource  -- association [0..*]
LEFT OUTER JOIN I_CostAnalysisResourceText AS _CostAnalysisResourceText ON ControllingArea = _CostAnalysisResourceText.ControllingArea AND CostAnalysisResource = _CostAnalysisResourceText.CostAnalysisResource  -- association [0..*]
LEFT OUTER JOIN I_Employment AS _Employment ON PersonnelNumber = _Employment.EmploymentInternalID  -- association [0..1]
LEFT OUTER JOIN I_PersonWorkAgreement_1 AS _PersonWorkAgreement_1 ON PersonnelNumber = _PersonWorkAgreement_1.PersonWorkAgreement  -- association [0..1]
LEFT OUTER JOIN I_FinancialTransactionType AS _FinancialTransactionType ON FinancialTransactionType = _FinancialTransactionType.FinancialTransactionType  -- association [0..1]
LEFT OUTER JOIN I_BusinessTransactionType AS _BusinessTransactionType ON BusinessTransactionType = _BusinessTransactionType.BusinessTransactionType  -- association [0..1]
LEFT OUTER JOIN I_BusTransactionTypeText AS _BusinessTransactionTypeText ON BusinessTransactionType = _BusinessTransactionTypeText.BusinessTransactionType  -- association [0..*]
LEFT OUTER JOIN I_ReferenceDocumentType AS _PredecessorReferenceDocType ON PredecessorReferenceDocType = _PredecessorReferenceDocType.ReferenceDocumentType  -- association [0..1]
LEFT OUTER JOIN I_CostCenter AS _PartnerCostCenter ON ControllingArea = _PartnerCostCenter.ControllingArea AND PartnerCostCenter = _PartnerCostCenter.CostCenter  -- association [0..*]
LEFT OUTER JOIN I_ProfitCenter AS _PartnerProfitCenter ON ControllingArea = _PartnerProfitCenter.ControllingArea AND PartnerProfitCenter = _PartnerProfitCenter.ProfitCenter  -- association [0..*]
LEFT OUTER JOIN I_BusinessArea AS _PartnerBusinessArea ON PartnerBusinessArea = _PartnerBusinessArea.BusinessArea  -- association [0..1]
LEFT OUTER JOIN I_BusinessAreaText AS _PartnerBusinessAreaText ON PartnerBusinessArea = _PartnerBusinessAreaText.BusinessArea  -- association [0..*]
LEFT OUTER JOIN I_FunctionalArea AS _PartnerFunctionalArea ON PartnerFunctionalArea = _PartnerFunctionalArea.FunctionalArea  -- association [0..1]
LEFT OUTER JOIN I_CompanyCode AS _PartnerCompanyCode ON PartnerCompanyCode = _PartnerCompanyCode.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_CompanyCode AS _PartnerCompanyCodeText ON PartnerCompanyCode = _PartnerCompanyCodeText.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_Segment AS _PartnerSegment ON PartnerSegment = _PartnerSegment.Segment  -- association [0..1]
LEFT OUTER JOIN I_SegmentText AS _PartnerSegmentText ON PartnerSegment = _PartnerSegmentText.Segment  -- association [0..*]
LEFT OUTER JOIN I_AccountingDocumentCategory AS _AccountingDocumentCategory ON AccountingDocumentCategory = _AccountingDocumentCategory.AccountingDocumentCategory  -- association [0..1]
LEFT OUTER JOIN I_PostingKey AS _PostingKey ON PostingKey = _PostingKey.PostingKey  -- association [0..1]
LEFT OUTER JOIN I_SubLedgerAccLineItemType AS _SubLedgerAccLineItemType ON SubLedgerAcctLineItemType = _SubLedgerAccLineItemType.SubLedgerAcctLineItemType  -- association [0..1]
LEFT OUTER JOIN I_User AS _User ON AccountingDocCreatedByUser = _User.UserID  -- association [0..1]
LEFT OUTER JOIN I_ProfitCenter AS _EliminationProfitCenter ON ControllingArea = _EliminationProfitCenter.ControllingArea AND EliminationProfitCenter = _EliminationProfitCenter.ProfitCenter  -- association [0..*]
LEFT OUTER JOIN I_GLAccountType AS _GLAccountType ON GLAccountType = _GLAccountType.GLAccountType  -- association [0..1]
LEFT OUTER JOIN I_FinancialAccountType AS _OffsettingAccountType ON OffsettingAccountType = _OffsettingAccountType.FinancialAccountType  -- association [0..1]
LEFT OUTER JOIN I_FinancialAccountTypeText AS _OffsettingAccountTypeText ON OffsettingAccountType = _OffsettingAccountTypeText.FinancialAccountType  -- association [0..*]
LEFT OUTER JOIN I_GLAccountInChartOfAccounts AS _AlternativeGLAccount ON CountryChartOfAccounts = _AlternativeGLAccount.ChartOfAccounts AND AlternativeGLAccount = _AlternativeGLAccount.GLAccount  -- association [0..1]
LEFT OUTER JOIN I_GLAccountText AS _AlternativeGLAccountText ON CountryChartOfAccounts = _AlternativeGLAccountText.ChartOfAccounts AND AlternativeGLAccount = _AlternativeGLAccountText.GLAccount  -- association [0..*]
LEFT OUTER JOIN I_GLAccountInChartOfAccounts AS _OffsettingAccount ON ChartOfAccounts = _OffsettingAccount.ChartOfAccounts AND OffsettingAccount = _OffsettingAccount.GLAccount  -- association [0..1]
LEFT OUTER JOIN I_OffsettingAccount AS _OffsettingAccountText ON OffsettingChartOfAccounts = _OffsettingAccountText.ChartOfAccounts AND OffsettingAccountType = _OffsettingAccountText.OffsettingAccountType AND OffsettingAccount = _OffsettingAccountText.OffsettingAccount  -- association [0..1]
LEFT OUTER JOIN I_OffsettingAccount AS _OffsettingAccountWithBP ON OffsettingChartOfAccounts = _OffsettingAccountWithBP.ChartOfAccounts AND OffsettingAccountType = _OffsettingAccountWithBP.OffsettingAccountType AND OffsettingAccount = _OffsettingAccountWithBP.OffsettingAccount  -- association [0..1]
LEFT OUTER JOIN I_ChartOfAccounts AS _OffsettingChartOfAccounts ON OffsettingChartOfAccounts = _OffsettingChartOfAccounts.ChartOfAccounts  -- association [0..1]
LEFT OUTER JOIN I_ChartOfAccountsText AS _OffsettingChartOfAccountsText ON OffsettingChartOfAccounts = _OffsettingChartOfAccountsText.ChartOfAccounts  -- association [0..*]
LEFT OUTER JOIN I_ChartOfAccounts AS _CountryChartOfAccounts ON CountryChartOfAccounts = _CountryChartOfAccounts.ChartOfAccounts  -- association [0..1]
LEFT OUTER JOIN I_ChartOfAccountsText AS _CountryChartOfAccountsText ON CountryChartOfAccounts = _CountryChartOfAccountsText.ChartOfAccounts  -- association [0..*]
LEFT OUTER JOIN I_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_AccountingDocument AS _ClearingAccountingDocument ON CompanyCode = _ClearingAccountingDocument.CompanyCode AND FiscalYear = _ClearingAccountingDocument.FiscalYear AND ClearingAccountingDocument = _ClearingAccountingDocument.AccountingDocument  -- association [1..1]
LEFT OUTER JOIN I_MasterFixedAsset AS _MasterFixedAsset ON CompanyCode = _MasterFixedAsset.CompanyCode AND MasterFixedAsset = _MasterFixedAsset.MasterFixedAsset  -- association [0..1]
LEFT OUTER JOIN I_MasterFixedAsset AS _GroupMasterFixedAsset ON CompanyCode = _GroupMasterFixedAsset.CompanyCode AND GroupMasterFixedAsset = _GroupMasterFixedAsset.MasterFixedAsset  -- association [0..1]
LEFT OUTER JOIN I_MasterFixedAsset AS _GroupMasterFixedAssetText ON CompanyCode = _GroupMasterFixedAssetText.CompanyCode AND GroupMasterFixedAsset = _GroupMasterFixedAssetText.MasterFixedAsset  -- association [0..1]
LEFT OUTER JOIN I_MasterFixedAsset AS _MasterFixedAssetText ON CompanyCode = _MasterFixedAssetText.CompanyCode AND MasterFixedAsset = _MasterFixedAssetText.MasterFixedAsset  -- association [0..1]
LEFT OUTER JOIN I_FixedAsset AS _FixedAsset ON CompanyCode = _FixedAsset.CompanyCode AND MasterFixedAsset = _FixedAsset.MasterFixedAsset AND FixedAsset = _FixedAsset.FixedAsset  -- association [0..1]
LEFT OUTER JOIN I_FixedAsset AS _GroupFixedAsset ON CompanyCode = _GroupFixedAsset.CompanyCode AND GroupMasterFixedAsset = _GroupFixedAsset.MasterFixedAsset AND GroupFixedAsset = _GroupFixedAsset.FixedAsset  -- association [0..1]
LEFT OUTER JOIN I_FixedAsset AS _GroupFixedAssetText ON CompanyCode = _GroupFixedAssetText.CompanyCode AND GroupMasterFixedAsset = _GroupFixedAssetText.MasterFixedAsset AND GroupFixedAsset = _GroupFixedAssetText.FixedAsset  -- association [0..1]
LEFT OUTER JOIN I_FixedAsset AS _FixedAssetText ON CompanyCode = _FixedAssetText.CompanyCode AND MasterFixedAsset = _FixedAssetText.MasterFixedAsset AND FixedAsset = _FixedAssetText.FixedAsset  -- association [0..1]
LEFT OUTER JOIN I_BusinessProcess AS _BusinessProcess ON ControllingArea = _BusinessProcess.ControllingArea AND BusinessProcess = _BusinessProcess.BusinessProcess  -- association [0..1]
LEFT OUTER JOIN I_BusinessProcessText AS _BusinessProcessText ON ControllingArea = _BusinessProcessText.ControllingArea AND BusinessProcess = _BusinessProcessText.BusinessProcess  -- association [0..*]
LEFT OUTER JOIN I_CostCenterActivityType AS _PartnerCostCtrActivityType ON ControllingArea = _PartnerCostCtrActivityType.ControllingArea AND PartnerCostCtrActivityType = _PartnerCostCtrActivityType.CostCtrActivityType  -- association [0..*]
LEFT OUTER JOIN I_InternalOrder AS _PartnerOrder ON PartnerOrder = _PartnerOrder.InternalOrder  -- association [0..1]
LEFT OUTER JOIN I_InternalOrder AS _PartnerOrderText ON PartnerOrder = _PartnerOrderText.InternalOrder  -- association [0..1]
LEFT OUTER JOIN I_OrderCategory AS _PartnerOrderCategory ON PartnerOrderCategory = _PartnerOrderCategory.OrderCategory  -- association [0..1]
LEFT OUTER JOIN I_SalesDocument AS _PartnerSalesDocument ON PartnerSalesDocument = _PartnerSalesDocument.SalesDocument  -- association [0..1]
LEFT OUTER JOIN I_SalesDocumentItem AS _PartnerSalesDocumentItem ON PartnerSalesDocument = _PartnerSalesDocumentItem.SalesDocument AND PartnerSalesDocumentItem = _PartnerSalesDocumentItem.SalesDocumentItem  -- association [0..1]
LEFT OUTER JOIN I_BusinessProcess AS _PartnerBusinessProcess ON ControllingArea = _PartnerBusinessProcess.ControllingArea AND PartnerBusinessProcess = _PartnerBusinessProcess.BusinessProcess  -- association [0..1]
LEFT OUTER JOIN I_BusinessProcessText AS _PartnerBusinessProcessText ON ControllingArea = _PartnerBusinessProcessText.ControllingArea AND PartnerBusinessProcess = _PartnerBusinessProcessText.BusinessProcess  -- association [0..*]
LEFT OUTER JOIN I_BillingDocumentType AS _BillingDocumentType ON BillingDocumentType = _BillingDocumentType.BillingDocumentType  -- association [0..1]
LEFT OUTER JOIN I_SalesOrganization AS _SalesOrganization ON SalesOrganization = _SalesOrganization.SalesOrganization  -- association [0..1]
LEFT OUTER JOIN I_DistributionChannel AS _DistributionChannel ON DistributionChannel = _DistributionChannel.DistributionChannel  -- association [0..1]
LEFT OUTER JOIN I_Product AS _SoldProduct ON SoldProduct = _SoldProduct.Product  -- association [0..1]
LEFT OUTER JOIN I_ProductDescription AS _SoldProductText ON SoldProduct = _SoldProductText.Product  -- association [0..*]
LEFT OUTER JOIN I_Fund AS _Fund ON FinancialManagementArea = _Fund.FinancialManagementArea AND Fund = _Fund.Fund  -- association [0..1]
LEFT OUTER JOIN I_FundText AS _FundText ON FinancialManagementArea = _FundText.FinancialManagementArea AND Fund = _FundText.Fund  -- association [0..*]
LEFT OUTER JOIN I_Fund AS _PartnerFund ON FinancialManagementArea = _PartnerFund.FinancialManagementArea AND PartnerFund = _PartnerFund.Fund  -- association [0..1]
LEFT OUTER JOIN I_FundText AS _PartnerFundText ON FinancialManagementArea = _PartnerFundText.FinancialManagementArea AND PartnerFund = _PartnerFundText.Fund  -- association [0..*]
LEFT OUTER JOIN I_FundsCenter AS _FundsCenter ON FinancialManagementArea = _FundsCenter.FinancialManagementArea AND FundsCenter = _FundsCenter.FundsCenter  -- association [0..*]
LEFT OUTER JOIN I_InventoryValuationType AS _InventorySpecialStockValnType ON InventorySpecialStockValnType = _InventorySpecialStockValnType.InventoryValuationType  -- association [0..1]
LEFT OUTER JOIN I_InvtrySpecialStockValnType AS _InventorySpclStockValnType ON InvtrySpecialStockValnType_2 = _InventorySpclStockValnType.InventorySpecialStockValnType  -- association [0..1]
LEFT OUTER JOIN I_InventorySpecialStockType AS _InventorySpecialStockType ON InventorySpecialStockType = _InventorySpecialStockType.InventorySpecialStockType  -- association [0..1]
LEFT OUTER JOIN I_SalesDocument AS _InventorySpclStkSalesDocument ON InventorySpclStkSalesDocument = _InventorySpclStkSalesDocument.SalesDocument  -- association [0..1]
LEFT OUTER JOIN I_SalesDocumentItem AS _InventorySpclStkSalesDocItm ON InventorySpclStkSalesDocument = _InventorySpclStkSalesDocItm.SalesDocument AND InventorySpclStkSalesDocItm = _InventorySpclStkSalesDocItm.SalesDocumentItem  -- association [0..1]
LEFT OUTER JOIN I_Supplier AS _InventorySpecialStockSupplier ON InventorySpecialStockSupplier = _InventorySpecialStockSupplier.Supplier  -- association [0..1]
LEFT OUTER JOIN I_Supplier AS _InvtrySpclStockSupplierText ON InventorySpecialStockSupplier = _InvtrySpclStockSupplierText.Supplier  -- association [0..1]
LEFT OUTER JOIN I_InventoryValuationType AS _InventoryValuationType ON InventoryValuationType = _InventoryValuationType.InventoryValuationType  -- association [0..1]
LEFT OUTER JOIN I_ControllingDebitCreditCode AS _ControllingDebitCreditCode ON ControllingDebitCreditCode = _ControllingDebitCreditCode.ControllingDebitCreditCode  -- association [0..1]
LEFT OUTER JOIN I_ControllingObject AS _OriginSenderObject ON OriginSenderObject = _OriginSenderObject.ControllingObject  -- association [0..1]
LEFT OUTER JOIN I_ControllingObjectClass AS _ControllingObjectClass ON ControllingObjectClass = _ControllingObjectClass.ControllingObjectClass  -- association [0..1]
LEFT OUTER JOIN I_Partnercompany AS _PartnerCompany ON PartnerCompany = _PartnerCompany.PartnerCompany  -- association [1..1]
LEFT OUTER JOIN I_ControllingObjectClass AS _PartnerControllingObjectClass ON PartnerControllingObjectClass = _PartnerControllingObjectClass.ControllingObjectClass  -- association [0..1]
LEFT OUTER JOIN I_CostCenter AS _OriginCostCenter ON ControllingArea = _OriginCostCenter.ControllingArea AND OriginCostCenter = _OriginCostCenter.CostCenter  -- association [0..*]
LEFT OUTER JOIN I_ProfitCenter AS _OriginProfitCenter ON ControllingArea = _OriginProfitCenter.ControllingArea AND OriginProfitCenter = _OriginProfitCenter.ProfitCenter  -- association [0..*]
LEFT OUTER JOIN I_CostCenterActivityType AS _CostCtrActivityType ON ControllingArea = _CostCtrActivityType.ControllingArea AND CostCtrActivityType = _CostCtrActivityType.CostCtrActivityType  -- association [0..*]
LEFT OUTER JOIN I_CostCenterActivityType AS _OriginCostCtrActivityType ON ControllingArea = _OriginCostCtrActivityType.ControllingArea AND OriginCostCtrActivityType = _OriginCostCtrActivityType.CostCtrActivityType  -- association [0..*]
LEFT OUTER JOIN I_OrderCategory AS _OrderCategory ON OrderCategory = _OrderCategory.OrderCategory  -- association [0..1]
LEFT OUTER JOIN I_MovementCategory AS _MovementCategory ON AssetAcctTransClassfctn = _MovementCategory.AssetAcctTransClassfctn  -- association [0..1]
LEFT OUTER JOIN I_AssetTransactionType AS _AssetTransactionType ON AssetTransactionType = _AssetTransactionType.AssetTransactionType  -- association [0..1]
LEFT OUTER JOIN I_BudgetPeriod AS _BudgetPeriod ON BudgetPeriod = _BudgetPeriod.BudgetPeriod  -- association [0..1]
LEFT OUTER JOIN I_BudgetPeriodText AS _BudgetPeriodText ON BudgetPeriod = _BudgetPeriodText.BudgetPeriod  -- association [0..*]
LEFT OUTER JOIN I_CostOriginGroup AS _CostOriginGroup ON ControllingArea = _CostOriginGroup.ControllingArea AND CostOriginGroup = _CostOriginGroup.CostOriginGroup  -- association [0..*]
LEFT OUTER JOIN I_Country AS _CustomerSupplierCountry ON CustomerSupplierCountry = _CustomerSupplierCountry.Country  -- association [0..1]
LEFT OUTER JOIN I_SalesDistrict AS _SalesDistrict ON SalesDistrict = _SalesDistrict.SalesDistrict  -- association [0..1]
LEFT OUTER JOIN I_Customer AS _BillToParty ON BillToParty = _BillToParty.Customer  -- association [0..1]
LEFT OUTER JOIN I_Customer AS _ShipToParty ON ShipToParty = _ShipToParty.Customer  -- association [0..1]
LEFT OUTER JOIN I_FinancialManagementArea AS _FinancialManagementArea ON FinancialManagementArea = _FinancialManagementArea.FinancialManagementArea  -- association [0..1]
LEFT OUTER JOIN I_FinancialManagementAreaText AS _FinancialManagementAreaText ON FinancialManagementArea = _FinancialManagementAreaText.FinancialManagementArea  -- association [0..*]
LEFT OUTER JOIN I_HouseBankAccountText AS _HouseBankAccountText ON CompanyCode = _HouseBankAccountText.CompanyCode AND HouseBank = _HouseBankAccountText.HouseBank AND HouseBankAccount = _HouseBankAccountText.HouseBankAccount  -- association [0..*]
LEFT OUTER JOIN I_OperatingConcern AS _OperatingConcern ON OperatingConcern = _OperatingConcern.OperatingConcern  -- association [0..1]
LEFT OUTER JOIN I_OperatingConcernText AS _OperatingConcernText ON OperatingConcern = _OperatingConcernText.OperatingConcern  -- association [0..*]
LEFT OUTER JOIN I_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_MaintenanceOrder AS _MaintenanceOrder ON OrderID = _MaintenanceOrder.MaintenanceOrder AND OrderCategory = '30'  -- association [0..1]
LEFT OUTER JOIN I_MaintenanceOrderOperation AS _MaintenanceOrderOperation ON OrderID = _MaintenanceOrderOperation.MaintenanceOrder AND OrderOperation = _MaintenanceOrderOperation.MaintenanceOrderOperation AND OrderCategory = '30'  -- association [0..1]
LEFT OUTER JOIN I_MaintenanceOrderSubOperation AS _MaintenanceOrderSubOperation ON OrderID = _MaintenanceOrderSubOperation.MaintenanceOrder AND OrderOperation = _MaintenanceOrderSubOperation.MaintenanceOrderOperation AND OrderSuboperation = _MaintenanceOrderSubOperation.MaintenanceOrderSubOperation  -- association [0..1]
LEFT OUTER JOIN I_Equipment AS _Equipment ON Equipment = _Equipment.Equipment  -- association [0..1]
LEFT OUTER JOIN I_EquipmentText AS _EquipmentText ON Equipment = _EquipmentText.Equipment  -- association [0..*]
LEFT OUTER JOIN I_FunctionalLocation AS _FunctionalLocation ON FunctionalLocation = _FunctionalLocation.FunctionalLocation  -- association [0..1]
LEFT OUTER JOIN I_FunctionalLocationText AS _FunctionalLocationText ON FunctionalLocation = _FunctionalLocationText.FunctionalLocation  -- association [0..*]
LEFT OUTER JOIN I_Product AS _Assembly ON Assembly = _Assembly.Product  -- association [0..1]
LEFT OUTER JOIN I_ProductDescription AS _AssemblyText ON Assembly = _AssemblyText.Product  -- association [0..*]
LEFT OUTER JOIN I_MaintenanceActivityType AS _MaintenanceActivityType ON MaintenanceActivityType = _MaintenanceActivityType.MaintenanceActivityType  -- association [0..1]
LEFT OUTER JOIN I_MaintenanceActivityTypeText AS _MaintenanceActivityTypeText ON MaintenanceActivityType = _MaintenanceActivityTypeText.MaintenanceActivityType  -- association [0..*]
LEFT OUTER JOIN I_MaintOrdPlngDegreeCode AS _MaintOrdPlngDegreeCode ON MaintenanceOrderPlanningCode = _MaintOrdPlngDegreeCode.MaintenanceOrderPlanningCode  -- association [0..1]
LEFT OUTER JOIN I_GLAccountText AS _GLAccountText ON GLAccount = _GLAccountText.GLAccount  -- association [0..*]
LEFT OUTER JOIN I_GLAccountText AS _GLAccountTxt ON ChartOfAccounts = _GLAccountTxt.ChartOfAccounts AND GLAccount = _GLAccountTxt.GLAccount  -- association [0..*]
LEFT OUTER JOIN I_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_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_SemTagGLAccount AS _SemTagGLAccount ON GLAccount = _SemTagGLAccount.GLAccount AND ChartOfAccounts = _SemTagGLAccount.ChartOfAccounts  -- association [0..*]
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]
;