I_GLAcctBalanceComprnCube

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_GLAcctBalanceComprnCube.
-- 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.
-- Parameters: P_FromPostingDate : fis_budat_from, P_ToPostingDate : fis_budat_to, P_ComprnFromPostingDate : fis_comprn_budat_from, P_ComprnToPostingDate : fis_comprn_budat_to

CREATE VIEW I_GLAcctBalanceComprnCube AS
SELECT
  Ledger,
  CompanyCode,
  FiscalYear,
  SourceLedger,
  AccountingDocument,
  LedgerGLLineItem,
  GLAccountFlowType,
  FiscalPeriodDate,
  ComprnFiscalPeriodDate,
  LedgerFiscalYear,
  FinancialTransactionType,
  BusinessTransactionType,
  ReferenceDocumentType,
  LogicalSystem,
  ReferenceDocumentContext,
  ReferenceDocument,
  ReferenceDocumentItem,
  ReferenceDocumentItemGroup,
  IsReversal,
  IsReversed,
  ReversalReferenceDocumentCntxt,
  ReversalReferenceDocument,
  IsSettlement,
  IsSettled,
  PredecessorReferenceDocType,
  PredecessorReferenceDocCntxt,
  PredecessorReferenceDocument,
  PredecessorReferenceDocItem,
  GLAccount,
  GLAccount AS GLAccountHierarchy,
  ProfitCenter,
  FunctionalArea,
  BusinessArea,
  ControllingArea,
  Segment,
  CostCenter,
  PartnerCostCenter,
  PartnerProfitCenter,
  PartnerFunctionalArea,
  PartnerBusinessArea,
  PartnerCompany,
  PartnerSegment,
  DebitCreditCode,
  FiscalYearVariant,
  FiscalYearPeriod,
  PostingDate,
  AccountingDocumentType,
  AssignmentReference,
  PostingKey,
  AccountingDocumentCategory,
  TransactionTypeDetermination,
  AccountingDocCreatedByUser,
  EliminationProfitCenter,
  OriginObjectType,
  GLAccountType,
  ChartOfAccounts,
  AlternativeGLAccount,
  CountryChartOfAccounts,
  InvoiceReference,
  InvoiceReferenceFiscalYear,
  FollowOnDocumentType,
  InvoiceItemReference,
  ReferencePurchaseOrderCategory,
  PurchasingDocument,
  PurchasingDocumentItem,
  AccountAssignmentNumber,
  DocumentItemText,
  Material,
  Product,
  Plant,
  Supplier,
  Customer,
  FinancialAccountType,
  SpecialGLCode,
  TaxCode,
  HouseBank,
  HouseBankAccount,
  IsOpenItemManaged,
  ClearingAccountingDocument,
  ClearingDocFiscalYear,
  ClearingJournalEntry,
  ClearingJournalEntryFiscalYear,
  AssetDepreciationArea,
  MasterFixedAsset,
  FixedAsset,
  AssetValueDate,
  AssetTransactionType,
  AssetAcctTransClassfctn,
  DepreciationFiscalPeriod,
  GroupMasterFixedAsset,
  GroupFixedAsset,
  CostEstimate,
  InventorySpecialStockValnType,
  InventorySpecialStockType,
  cast(P_GlAcctBalanceComprn.InventorySpecialStockValnType as fis_inventoryspclstockvalntype preserving type) AS InvtrySpecialStockValnType_2,
  InventorySpclStkSalesDocument,
  InventorySpclStkSalesDocItm,
  InvtrySpclStockWBSElmntIntID,
  cast(_InvtrySpclStockWBSElmntIntID.WBSElement as mlmat_ps_posid preserving type ) AS InventorySpclStockWBSElement,
  cast( _InvtrySpclStkWBSElmntBscData.WBSElementExternalID as fis_invspstock_wbsext_no_conv preserving type ) AS InvtrySpclStockWBSElmntExtID,
  InventorySpecialStockSupplier,
  InventoryValuationType,
  ValuationArea,
  SenderGLAccount,
  SenderAccountAssignment,
  SenderAccountAssignmentType,
  ControllingObjectDebitType,
  QuantityIsIncomplete,
  OffsettingAccount,
  OffsettingAccountType,
  OffsettingChartOfAccounts,
  LineItemIsCompleted,
  PersonnelNumber,
  ControllingObjectClass,
  PartnerCompanyCode,
  PartnerControllingObjectClass,
  OriginCostCenter,
  OriginCostCtrActivityType,
  AccountAssignment,
  AccountAssignmentType,
  ProjectNetwork,
  RelatedNetworkActivity,
  BusinessProcess,
  CostObject,
  CustomerServiceNotification,
  OperatingConcern,
  PartnerAccountAssignment,
  PartnerAccountAssignmentType,
  PartnerCostCtrActivityType,
  PartnerOrder,
  PartnerOrderCategory,
  PartnerWBSElement,
  PartnerProject,
  PartnerSalesDocument,
  PartnerSalesDocumentItem,
  PartnerProjectNetwork,
  PartnerProjectNetworkActivity,
  PartnerBusinessProcess,
  PartnerCostObject,
  ServiceDocumentType,
  ServiceDocument,
  ServiceDocumentItem,
  PartnerServiceDocumentType,
  PartnerServiceDocument,
  PartnerServiceDocumentItem,
  ServiceContractType,
  ServiceContract,
  ServiceContractItem,
  TimeSheetOvertimeCategory,
  cast( _PartnerProjectBasicData.ProjectExternalID as fis_part_projectext_no_conv preserving type ) AS PartnerProjectExternalID,
  BillingDocumentType,
  SalesOrganization,
  DistributionChannel,
  OrganizationDivision,
  SoldMaterial,
  SoldProduct,
  MaterialGroup,
  SoldProductGroup,
  ProductGroup,
  CustomerGroup,
  CustomerSupplierCountry,
  CustomerSupplierIndustry,
  FinancialServicesProductGroup,
  FinancialServicesBranch,
  FinancialDataSource,
  FinancialManagementArea,
  FundsCenter,
  FundedProgram,
  Fund,
  GrantID,
  BudgetPeriod,
  PartnerFund,
  PartnerGrant,
  PartnerBudgetPeriod,
  PubSecBudgetAccount,
  PubSecBudgetAccountCoCode,
  PubSecBudgetCnsmpnDate,
  PubSecBudgetCnsmpnFsclPeriod,
  PubSecBudgetCnsmpnFsclYear,
  PubSecBudgetIsRelevant,
  PubSecBudgetCnsmpnType,
  PubSecBudgetCnsmpnAmtType,
  JointVenture,
  JointVentureEquityGroup,
  JointVentureCostRecoveryCode,
  JointVentureEquityType,
  SettlementReferenceDate,
  CostCtrActivityType,
  OrderID,
  OrderCategory,
  WBSElementInternalID,
  _WBSElementInternalID.WBSElement AS WBSElement,
  cast( _WBSElementBasicData.WBSElementExternalID as fis_wbsext_no_conv preserving type ) AS WBSElementExternalID,
  PartnerWBSElementInternalID,
  cast( _PartnerWBSElementBasicData.WBSElementExternalID as fis_partner_wbsext_no_conv preserving type ) AS PartnerWBSElementExternalID,
  _ProjectInternalID.Project AS Project,
  cast( _ProjectBasicData.ProjectExternalID as fis_projectext_no_conv preserving type ) AS ProjectExternalID,
  P_GlAcctBalanceComprn.ProjectInternalID AS ProjectInternalID,
  PartnerProjectInternalID,
  SalesOrder,
  SalesOrderItem,
  SalesDocument,
  SalesDocumentItem,
  ClearingDate,
  ConsolidationUnit,
  PartnerConsolidationUnit,
  Company,
  ConsolidationChartOfAccounts,
  CnsldtnFinancialStatementItem,
  CnsldtnSubitemCategory,
  CnsldtnSubitem,
  _ChartOfAccounts.CorporateGroupChartOfAccounts AS CorporateGroupChartOfAccounts,
  _GLAccountInChartOfAccounts.CorporateGroupAccount AS CorporateGroupAccount,
  _GLAccountInChartOfAccounts.IsBalanceSheetAccount AS IsBalanceSheetAccount,
  BalanceTransactionCurrency,
  TransactionCurrency,
  CompanyCodeCurrency,
  GlobalCurrency,
  FunctionalCurrency,
  FreeDefinedCurrency1,
  FreeDefinedCurrency2,
  FreeDefinedCurrency3,
  FreeDefinedCurrency4,
  FreeDefinedCurrency5,
  FreeDefinedCurrency6,
  FreeDefinedCurrency7,
  FreeDefinedCurrency8,
  AmountInBalanceTransacCrcy,
  AmountInTransactionCurrency,
  AmountInCompanyCodeCurrency,
  AmountInGlobalCurrency,
  AmountInFunctionalCurrency,
  AmountInFreeDefinedCurrency1,
  AmountInFreeDefinedCurrency2,
  AmountInFreeDefinedCurrency3,
  AmountInFreeDefinedCurrency4,
  AmountInFreeDefinedCurrency5,
  AmountInFreeDefinedCurrency6,
  AmountInFreeDefinedCurrency7,
  AmountInFreeDefinedCurrency8,
  ComprnAmountInBalTransCrcy,
  ComprnAmountInTransCrcy,
  ComprnAmountInCoCodeCrcy,
  ComprnAmountInGlobalCrcy,
  ComprnAmountInFunctionalCrcy,
  ComprnAmountInFreeDfndCrcy1,
  ComprnAmountInFreeDfndCrcy2,
  ComprnAmountInFreeDfndCrcy3,
  ComprnAmountInFreeDfndCrcy4,
  ComprnAmountInFreeDfndCrcy5,
  ComprnAmountInFreeDfndCrcy6,
  ComprnAmountInFreeDfndCrcy7,
  ComprnAmountInFreeDfndCrcy8,
  DebitAmountInCoCodeCrcy,
  CreditAmountInCoCodeCrcy,
  DebitAmountInTransCrcy,
  CreditAmountInTransCrcy,
  DebitAmountInBalanceTransCrcy,
  CreditAmountInBalanceTransCrcy,
  DebitAmountInGlobalCrcy,
  CreditAmountInGlobalCrcy,
  DebitAmountInFunctionalCrcy,
  CreditAmountInFunctionalCrcy,
  DebitAmountInFreeDefinedCrcy1,
  CreditAmountInFreeDefinedCrcy1,
  DebitAmountInFreeDefinedCrcy2,
  CreditAmountInFreeDefinedCrcy2,
  DebitAmountInFreeDefinedCrcy3,
  CreditAmountInFreeDefinedCrcy3,
  DebitAmountInFreeDefinedCrcy4,
  CreditAmountInFreeDefinedCrcy4,
  DebitAmountInFreeDefinedCrcy5,
  CreditAmountInFreeDefinedCrcy5,
  DebitAmountInFreeDefinedCrcy6,
  CreditAmountInFreeDefinedCrcy6,
  DebitAmountInFreeDefinedCrcy7,
  CreditAmountInFreeDefinedCrcy7,
  DebitAmountInFreeDefinedCrcy8,
  CreditAmountInFreeDefinedCrcy8,
  ComprnDebitAmtInCoCodeCrcy,
  ComprnCreditAmtInCoCodeCrcy,
  ComprnDebitAmtInTransCrcy,
  ComprnCreditAmtInTransCrcy,
  ComprnDebitAmtInBalTransCrcy,
  ComprnCreditAmtInBalTransCrcy,
  ComprnDebitAmtInGlobalCrcy,
  ComprnCreditAmtInGlobalCrcy,
  ComprnDebitAmtInFunctionalCrcy,
  ComprnCreditAmtInFuncnlCrcy,
  ComprnDebitAmtInFreeDfndCrcy1,
  ComprnCreditAmtInFreeDfndCrcy1,
  ComprnDebitAmtInFreeDfndCrcy2,
  ComprnCreditAmtInFreeDfndCrcy2,
  ComprnDebitAmtInFreeDfndCrcy3,
  ComprnCreditAmtInFreeDfndCrcy3,
  ComprnDebitAmtInFreeDfndCrcy4,
  ComprnCreditAmtInFreeDfndCrcy4,
  ComprnDebitAmtInFreeDfndCrcy5,
  ComprnCreditAmtInFreeDfndCrcy5,
  ComprnDebitAmtInFreeDfndCrcy6,
  ComprnCreditAmtInFreeDfndCrcy6,
  ComprnDebitAmtInFreeDfndCrcy7,
  ComprnCreditAmtInFreeDfndCrcy7,
  ComprnDebitAmtInFreeDfndCrcy8,
  ComprnCreditAmtInFreeDfndCrcy8,
  FiscalPeriod,
  P_GlAcctBalanceComprn.FlowOfFundsLedgerFiscalYear AS FlowOfFundsLedgerFiscalYear,
  EndingBalanceAmtInCoCodeCrcy,
  EndingBalanceAmtInTransCrcy,
  EndingBalanceAmtInBalTransCrcy,
  EndingBalanceAmtInGlobalCrcy,
  EndingBalanceAmtInFuncnlCrcy,
  EndingBalAmtInFreeDfndCrcy1,
  EndingBalAmtInFreeDfndCrcy2,
  EndingBalAmtInFreeDfndCrcy3,
  EndingBalAmtInFreeDfndCrcy4,
  EndingBalAmtInFreeDfndCrcy5,
  EndingBalAmtInFreeDfndCrcy6,
  EndingBalAmtInFreeDfndCrcy7,
  EndingBalAmtInFreeDfndCrcy8,
  ComprnEndingBalInCoCodeCrcy,
  ComprnEndingBalInTransCrcy,
  ComprnEndingBalInBalTransCrcy,
  ComprnEndingBalInGlobalCrcy,
  ComprnEndingBalInFuncnlCrcy,
  ComprnEndingBalInFreeDfndCrcy1,
  ComprnEndingBalInFreeDfndCrcy2,
  ComprnEndingBalInFreeDfndCrcy3,
  ComprnEndingBalInFreeDfndCrcy4,
  ComprnEndingBalInFreeDfndCrcy5,
  ComprnEndingBalInFreeDfndCrcy6,
  ComprnEndingBalInFreeDfndCrcy7,
  ComprnEndingBalInFreeDfndCrcy8,
  FromPostingDate,
  ToPostingDate,
  ComprnFromPostingDate,
  ComprnToPostingDate,
  AccrualObjectType,
  AccrualObject,
  AccrualSubobject,
  AccrualItemType,
  CashLedgerCompanyCode,
  CashLedgerAccount,
  _CalendarDate.CalendarYear AS CalendarYear,
  _CalendarDate.CalendarQuarter AS CalendarQuarter,
  _CalendarDate.YearQuarter AS CalendarYearQuarter,
  _CalendarDate.CalendarMonth AS CalendarMonth,
  _CalendarDate.YearMonth AS CalendarYearMonth,
  _CalendarDate.CalendarWeek AS CalendarWeek,
  _CalendarDate.YearWeek AS CalendarYearWeek,
  _FiscalCalendarDate.FiscalQuarter AS FiscalQuarter,
  _FiscalCalendarDate.FiscalWeek AS FiscalWeek,
  _FiscalCalendarDate.FiscalYearQuarter AS FiscalYearQuarter,
  _FiscalCalendarDate.FiscalYearWeek AS FiscalYearWeek,
  P_GlAcctBalanceComprn._GLAccountFlowType AS _GLAccountFlowType,
  P_GlAcctBalanceComprn._CustomerCompany AS _CustomerCompany,
  P_GlAcctBalanceComprn._SupplierCompany AS _SupplierCompany,
  P_GlAcctBalanceComprn._FinServicesProductGroup AS _FinServicesProductGroup,
  P_GlAcctBalanceComprn._FinancialServicesBranch AS _FinancialServicesBranch,
  P_GlAcctBalanceComprn._FinancialDataSource AS _FinancialDataSource,
  P_GlAcctBalanceComprn._CustomerSupplierIndustry AS _CustomerSupplierIndustry,
  P_GlAcctBalanceComprn._CustomerSupplierCountry AS _CustomerSupplierCountry,
  cast( '' as brgru) AS GLAccountAuthorizationGroup,
  cast( '' as brgru) AS SupplierBasicAuthorizationGrp,
  cast( '' as brgru) AS CustomerBasicAuthorizationGrp,
  cast( '' as brgru) AS AcctgDocTypeAuthorizationGroup,
  cast( '' as aufart) AS OrderType,
  cast( '' as auart) AS SalesOrderType,
  cast( '' as anlkl) AS AssetClass
FROM P_GlAcctBalanceComprn
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 _FunctionalCurrency on FunctionalCurrency = _FunctionalCurrency.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 FreeDefinedCurrency3 = _FreeDefinedCurrency4.Currency association[0..1] to I_Currency as _FreeDefinedCurrency5 on FreeDefinedCurrency3 = _FreeDefinedCurrency5.Currency association[0..1] to I_Currency as _FreeDefinedCurrency6 on FreeDefinedCurrency3 = _FreeDefinedCurrency6.Currency association[0..1] to I_Currency as _FreeDefinedCurrency7 on FreeDefinedCurrency3 = _FreeDefinedCurrency7.Currency association[0..1] to I_Currency as _FreeDefinedCurrency8 on FreeDefinedCurrency3 = _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]
LEFT OUTER JOIN 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_ChartOfAccounts as _CorporateGroupChartOfAccounts on CorporateGroupChartOfAccounts = _CorporateGroupChartOfAccounts.ChartOfAccounts association[0..1] to I_GLAccountInChartOfAccounts as _CorporateGroupAccount on CorporateGroupChartOfAccounts = _CorporateGroupAccount.ChartOfAccounts AND CorporateGroupAccount = _CorporateGroupAccount.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_FiscalYearForCompanyCode AS _ClearingJrnlEntryFiscalYear ON ClearingJournalEntryFiscalYear = _ClearingJrnlEntryFiscalYear.FiscalYear AND CompanyCode = _ClearingJrnlEntryFiscalYear.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_JournalEntry AS _ClearingJournalEntry ON CompanyCode = _ClearingJournalEntry.CompanyCode AND ClearingJournalEntryFiscalYear = _ClearingJournalEntry.FiscalYear AND ClearingJournalEntry = _ClearingJournalEntry.AccountingDocument association[0..1] to I_FixedAsset as _FixedAsset on CompanyCode = _FixedAsset.CompanyCode AND MasterFixedAsset = _FixedAsset.MasterFixedAsset AND FixedAsset = _FixedAsset.FixedAsset 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] 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]
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]
LEFT OUTER JOIN I_WBSElementBasicData AS _PartnerWBSElementBasicData ON PartnerWBSElementInternalID = _PartnerWBSElementBasicData.WBSElementInternalID  -- association [0..1]
LEFT OUTER JOIN I_WBSElementByExternalID AS _PartnerWBSElementExternalID ON PartnerWBSElementExternalID = _PartnerWBSElementExternalID.WBSElementExternalID  -- association [0..1]
LEFT OUTER JOIN I_WBSElementBasicData AS _InvtrySpclStkWBSElmntBscData ON InvtrySpclStockWBSElmntIntID = _InvtrySpclStkWBSElmntBscData.WBSElementInternalID  -- association [0..1]
LEFT OUTER JOIN I_WBSElementByExternalID AS _InvtrySpclStockWBSElmntExtID ON InvtrySpclStockWBSElmntExtID = _InvtrySpclStockWBSElmntExtID.WBSElementExternalID association[0..1] to I_Project as _PartnerProject on PartnerProject = _PartnerProject.Project  -- association [0..1]
LEFT OUTER JOIN I_ProjectByExternalID AS _ProjectExternalID ON ProjectExternalID = _ProjectExternalID.ProjectExternalID 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..1]
LEFT OUTER JOIN 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] 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] to I_FiscalCalendarDate as _FiscalCalendarDate on FiscalYearVariant = _FiscalCalendarDate.FiscalYearVariant AND PostingDate = _FiscalCalendarDate.CalendarDate association[1..1] to I_CalendarMonth as _CalendarMonth on CalendarMonth = _CalendarMonth.CalendarMonth association[1..1] to I_CalendarQuarter as _CalendarQuarter on CalendarQuarter = _CalendarQuarter.CalendarQuarter association[1..1] to I_YearMonth as _CalendarYearMonth on CalendarYearMonth = _CalendarYearMonth.YearMonth association[0..1] to I_Project as _Project on Project = _Project.Project  -- association [0..*]
LEFT OUTER JOIN I_ProjectBasicData AS _ProjectBasicData ON ProjectInternalID = _ProjectBasicData.ProjectInternalID  -- association [0..1]
LEFT OUTER JOIN I_ProjectBasicData AS _PartnerProjectBasicData ON PartnerProjectInternalID = _PartnerProjectBasicData.ProjectInternalID  -- association [0..1]
LEFT OUTER JOIN I_ProjectByExternalID AS _PartnerProjectExternalID ON PartnerProjectExternalID = _PartnerProjectExternalID.ProjectExternalID association[0..1] to I_ProjectByInternalKey as _ProjectInternalID on ProjectInternalID = _ProjectInternalID.ProjectInternalID association[0..1] to I_ServiceDocumentType as _ServiceDocumentType on ServiceDocumentType = _ServiceDocumentType.ServiceDocumentType association[0..1] to I_SrvcDocByDocumentType as _ServiceDocument on ServiceDocumentType = _ServiceDocument.ServiceDocumentType AND ServiceDocument = _ServiceDocument.ServiceDocument association[0..1] to I_SrvcDocItemByDocumentType as _ServiceDocumentItem on ServiceDocumentType = _ServiceDocumentItem.ServiceDocumentType AND ServiceDocument = _ServiceDocumentItem.ServiceDocument AND ServiceDocumentItem = _ServiceDocumentItem.ServiceDocumentItem association[0..1] to I_ServiceDocumentType as _PartnerServiceDocumentType on PartnerServiceDocumentType = _PartnerServiceDocumentType.ServiceDocumentType association[0..1] to I_SrvcDocByDocumentType as _PartnerServiceDocument on PartnerServiceDocumentType = _PartnerServiceDocument.ServiceDocumentType AND PartnerServiceDocument = _PartnerServiceDocument.ServiceDocument association[0..1] to I_SrvcDocItemByDocumentType as _PartnerServiceDocumentItem on PartnerServiceDocumentType = _PartnerServiceDocumentItem.ServiceDocumentType AND PartnerServiceDocument = _PartnerServiceDocumentItem.ServiceDocument AND PartnerServiceDocumentItem = _PartnerServiceDocumentItem.ServiceDocumentItem  -- 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_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_ServiceDocumentType AS _ServiceContractType ON ServiceContractType = _ServiceContractType.ServiceDocumentType  -- association [0..1]
LEFT OUTER JOIN I_SrvcDocByDocumentType AS _ServiceContract ON ServiceContractType = _ServiceContract.ServiceDocumentType AND ServiceContract = _ServiceContract.ServiceDocument  -- association [0..1]
LEFT OUTER JOIN I_SrvcDocItemByDocumentType AS _ServiceContractItem ON ServiceContractType = _ServiceContractItem.ServiceDocumentType AND ServiceContract = _ServiceContractItem.ServiceDocument AND ServiceContractItem = _ServiceContractItem.ServiceDocumentItem  -- association [0..1]
LEFT OUTER JOIN I_TimeSheetOvertimeCat AS _TimeSheetOvertimeCat ON TimeSheetOvertimeCategory = _TimeSheetOvertimeCat.TimeSheetOvertimeCategory  -- association [0..1]
LEFT OUTER JOIN I_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_BudgetPeriod AS _PartnerBudgetPeriod ON PartnerBudgetPeriod = _PartnerBudgetPeriod.BudgetPeriod  -- association [0..1]
LEFT OUTER JOIN I_FundedProgram AS _FundedProgram ON FinancialManagementArea = _FundedProgram.FinancialManagementArea AND FundedProgram = _FundedProgram.FundedProgram  -- association [0..1]
LEFT OUTER JOIN I_CompanyCode AS _PubSecBudgetAccountCoCode ON PubSecBudgetAccountCoCode = _PubSecBudgetAccountCoCode.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_PubSecBudgetAccount AS _PubSecBudgetAccount ON PubSecBudgetAccountCoCode = _PubSecBudgetAccount.PubSecBudgetAccountCoCode AND PubSecBudgetAccount = _PubSecBudgetAccount.PubSecBudgetAccount  -- association [0..1]
LEFT OUTER JOIN I_FiscCalendarDateForCompCode AS _PubSecBudgetCnsmpnDate ON PubSecBudgetCnsmpnDate = _PubSecBudgetCnsmpnDate.CalendarDate AND PubSecBudgetAccountCoCode = _PubSecBudgetCnsmpnDate.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_FiscalYearPeriodForCmpnyCode AS _PubSecBudgetCnsmpnFsclPeriod ON PubSecBudgetAccountCoCode = _PubSecBudgetCnsmpnFsclPeriod.CompanyCode AND PubSecBudgetCnsmpnFsclYear = _PubSecBudgetCnsmpnFsclPeriod.FiscalYear AND PubSecBudgetCnsmpnFsclPeriod = _PubSecBudgetCnsmpnFsclPeriod.FiscalPeriod  -- association [0..1]
LEFT OUTER JOIN I_FiscalYearForCompanyCode AS _PubSecBudgetCnsmpnFsclYear ON PubSecBudgetAccountCoCode = _PubSecBudgetCnsmpnFsclYear.CompanyCode AND PubSecBudgetCnsmpnFsclYear = _PubSecBudgetCnsmpnFsclYear.FiscalYear  -- association [0..1]
LEFT OUTER JOIN I_PubSecBdgtCnsmpnType AS _PubSecBudgetCnsmpnType ON PubSecBudgetCnsmpnType = _PubSecBudgetCnsmpnType.PubSecBudgetCnsmpnType  -- association [0..1]
LEFT OUTER JOIN I_PubSecBdgtCnsmpnAmtType AS _PubSecBudgetCnsmpnAmtType ON PubSecBudgetCnsmpnAmtType = _PubSecBudgetCnsmpnAmtType.PubSecBudgetCnsmpnAmtType  -- association [0..1]
LEFT OUTER JOIN I_Globalcompany AS _Company ON Company = _Company.Company  -- association [0..1]
LEFT OUTER JOIN I_CnsldtnUnit_3 AS _ConsolidationUnit ON ConsolidationUnit = _ConsolidationUnit.ConsolidationUnit  -- association [0..1]
LEFT OUTER JOIN I_CnsldtnUnit_3 AS _PartnerConsolidationUnit ON PartnerConsolidationUnit = _PartnerConsolidationUnit.ConsolidationUnit  -- association [0..1]
LEFT OUTER JOIN I_CnsldtnChartOfAccounts AS _ConsolidationChartOfAccounts ON ConsolidationChartOfAccounts = _ConsolidationChartOfAccounts.ConsolidationChartOfAccounts  -- association [0..1]
LEFT OUTER JOIN I_CnsldtnFinStmntItem AS _CnsldtnFinancialStatementItem ON ConsolidationChartOfAccounts = _CnsldtnFinancialStatementItem.ConsolidationChartOfAccounts AND CnsldtnFinancialStatementItem = _CnsldtnFinancialStatementItem.FinancialStatementItem  -- association [0..1]
LEFT OUTER JOIN I_CnsldtnSubItemCategory AS _CnsldtnSubitemCategory ON CnsldtnSubitemCategory = _CnsldtnSubitemCategory.SubItemCategory  -- association [0..1]
LEFT OUTER JOIN I_CnsldtnSubItem AS _CnsldtnSubitem ON CnsldtnSubitemCategory = _CnsldtnSubitem.SubItemCategory AND CnsldtnSubitem = _CnsldtnSubitem.SubItem  -- association [0..1]
LEFT OUTER JOIN I_CompanyCode AS _CashLedgerCompanyCode ON CashLedgerCompanyCode = _CashLedgerCompanyCode.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_GLAccountInCompanyCode AS _CashLedgerAccount ON CashLedgerCompanyCode = _CashLedgerAccount.CompanyCode AND CashLedgerAccount = _CashLedgerAccount.GLAccount  -- association [0..1]
;