I_GLAccountLineItemCube

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

CREATE VIEW I_GLAccountLineItemCube AS
SELECT
  Ledger,
  SourceLedger,
  CompanyCode,
  cast( FiscalYear as fis_gjahr_no_conv preserving type ) AS FiscalYear,
  AccountingDocument,
  LedgerGLLineItem,
  LedgerFiscalYear,
  GLRecordType,
  JrnlEntrAltvFYConsecutiveID,
  ControllingArea,
  ChartOfAccounts,
  GLAccount,
  CostCenter,
  ProfitCenter,
  FunctionalArea,
  AccountingDocumentItem,
  DebitCreditCode,
  FiscalPeriod,
  FiscalYearVariant,
  FiscalYearPeriod,
  PostingDate,
  DocumentDate,
  AccountingDocumentType,
  AssignmentReference,
  PostingKey,
  TransactionTypeDetermination,
  SubLedgerAcctLineItemType,
  AccountingDocCreatedByUser,
  LastChangeDateTime,
  CreationDateTime,
  CreationDate,
  AlternativeGLAccount,
  CountryChartOfAccounts,
  _ChartOfAccounts.CorporateGroupChartOfAccounts AS CorporateGroupChartOfAccounts,
  _GLAccountInChartOfAccounts.CorporateGroupAccount AS CorporateGroupAccount,
  _GLAccountInChartOfAccounts.IsBalanceSheetAccount AS IsBalanceSheetAccount,
  InvoiceReference,
  InvoiceReferenceFiscalYear,
  FollowOnDocumentType,
  InvoiceItemReference,
  ReferencePurchaseOrderCategory,
  PurchasingDocument,
  PurchasingDocumentItem,
  AccountAssignmentNumber,
  DocumentItemText,
  SalesOrder,
  SalesOrderItem,
  SalesDocument,
  SalesDocumentItem,
  Material,
  Product,
  Plant,
  Supplier,
  Customer,
  ServicesRenderedDate,
  ConditionContract,
  FinancialAccountType,
  SpecialGLCode,
  TaxCode,
  TaxCountry,
  HouseBank,
  HouseBankAccount,
  IsOpenItemManaged,
  ClearingDate,
  ClearingAccountingDocument,
  ClearingDocFiscalYear,
  ClearingJournalEntry,
  ClearingJournalEntryFiscalYear,
  ValueDate,
  MasterFixedAsset,
  FixedAsset,
  AssetValueDate,
  AssetTransactionType,
  InventorySpecialStockValnType,
  InvtrySpecialStockValnType_2,
  InventorySpecialStockType,
  InventoryValuationType,
  ValuationArea,
  OffsettingAccount,
  _OffsettingAccountWithBP.OffsettingAccountName AS OffsettingAccountName,
  OffsettingAccountType,
  OffsettingChartOfAccounts,
  LineItemIsCompleted,
  PersonnelNumber,
  ControllingObjectClass,
  PartnerControllingObjectClass,
  PartnerCompany,
  CostCtrActivityType,
  OrderID,
  OrderCategory,
  WBSElementInternalID,
  PartnerWBSElementInternalID,
  cast( _WBSElementBasicData.WBSElementExternalID as fis_wbsext_no_conv ) AS WBSElementExternalID,
  cast( _PartnerWBSElementBasicData.WBSElementExternalID as fis_partner_wbsext_no_conv ) AS PartnerWBSElementExternalID,
  cast( WBSElement as fis_wbs ) AS WBSElement,
  OperatingConcern,
  PartnerCostCtrActivityType,
  BillingDocumentType,
  SalesOrganization,
  DistributionChannel,
  OrganizationDivision,
  Segment,
  BusinessArea,
  AccountAssignment,
  AccountAssignmentType,
  AccountingDocumentCategory,
  AssetAcctTransClassfctn,
  AssetDepreciationArea,
  BudgetPeriod,
  BusinessProcess,
  BusinessTransactionCategory,
  BusinessTransactionType,
  ControllingBusTransacType,
  ControllingObjectDebitType,
  ControllingDebitCreditCode,
  CostEstimate,
  CostObject,
  BillableControl,
  CustomerGroup,
  CustomerServiceNotification,
  ServiceDocumentType,
  ServiceDocument,
  ServiceDocumentItem,
  PartnerServiceDocumentType,
  PartnerServiceDocument,
  PartnerServiceDocumentItem,
  ServiceContractType,
  ServiceContract,
  ServiceContractItem,
  TimeSheetOvertimeCategory,
  DepreciationFiscalPeriod,
  EliminationProfitCenter,
  FinancialTransactionType,
  Fund,
  FinancialManagementArea,
  CommitmentItem,
  EarmarkedFundsDocument,
  EarmarkedFundsDocumentItem,
  GLAccountType,
  GrantID,
  GroupFixedAsset,
  GroupMasterFixedAsset,
  AssetClass,
  InventorySpclStkSalesDocItm,
  InventorySpclStkSalesDocument,
  InvtrySpclStockWBSElmntIntID,
  cast( _InvtrySpclStockWBSElmntBD.WBSElementExternalID as fis_invspstock_wbsext_no_conv ) AS InvtrySpclStockWBSElmntExtID,
  cast( _InvtrySpclStockWBSElmntBD.WBSElement as fis_invspstock_wbs ) AS InventorySpclStockWBSElement,
  I_GLAccountLineItem.InventorySpecialStockSupplier AS InventorySpecialStockSupplier,
  I_GLAccountLineItem.IsReversal AS IsReversal,
  I_GLAccountLineItem.IsReversed AS IsReversed,
  I_GLAccountLineItem.IsSettled AS IsSettled,
  I_GLAccountLineItem.IsSettlement AS IsSettlement,
  I_GLAccountLineItem.JointVenture AS JointVenture,
  I_GLAccountLineItem.JointVentureEquityGroup AS JointVentureEquityGroup,
  I_GLAccountLineItem.JointVentureCostRecoveryCode AS JointVentureCostRecoveryCode,
  I_GLAccountLineItem.JointVenturePartner AS JointVenturePartner,
  I_GLAccountLineItem.JointVentureBillingType AS JointVentureBillingType,
  I_GLAccountLineItem.JointVentureEquityType AS JointVentureEquityType,
  I_GLAccountLineItem.JointVentureProductionDate AS JointVentureProductionDate,
  I_GLAccountLineItem.JointVentureBillingDate AS JointVentureBillingDate,
  I_GLAccountLineItem.JointVentureOperationalDate AS JointVentureOperationalDate,
  I_GLAccountLineItem.CutbackRun AS CutbackRun,
  I_GLAccountLineItem.JointVentureAccountingActivity AS JointVentureAccountingActivity,
  I_GLAccountLineItem.PartnerVenture AS PartnerVenture,
  I_GLAccountLineItem.PartnerEquityGroup AS PartnerEquityGroup,
  I_GLAccountLineItem.SenderCostRecoveryCode AS SenderCostRecoveryCode,
  I_GLAccountLineItem.CutbackAccount AS CutbackAccount,
  I_GLAccountLineItem.CutbackCostObject AS CutbackCostObject,
  I_GLAccountLineItem.REBusinessEntity AS REBusinessEntity,
  I_GLAccountLineItem.RealEstateBuilding AS RealEstateBuilding,
  I_GLAccountLineItem.RealEstateProperty AS RealEstateProperty,
  I_GLAccountLineItem.RERentalObject AS RERentalObject,
  I_GLAccountLineItem.RealEstateContract AS RealEstateContract,
  I_GLAccountLineItem.REServiceChargeKey AS REServiceChargeKey,
  I_GLAccountLineItem.RESettlementUnitID AS RESettlementUnitID,
  I_GLAccountLineItem.SettlementReferenceDate AS SettlementReferenceDate,
  I_GLAccountLineItem.REPartnerBusinessEntity AS REPartnerBusinessEntity,
  I_GLAccountLineItem.RealEstatePartnerBuilding AS RealEstatePartnerBuilding,
  I_GLAccountLineItem.RealEstatePartnerProperty AS RealEstatePartnerProperty,
  I_GLAccountLineItem.REPartnerRentalObject AS REPartnerRentalObject,
  I_GLAccountLineItem.RealEstatePartnerContract AS RealEstatePartnerContract,
  I_GLAccountLineItem.REPartnerServiceChargeKey AS REPartnerServiceChargeKey,
  I_GLAccountLineItem.REPartnerSettlementUnitID AS REPartnerSettlementUnitID,
  I_GLAccountLineItem.PartnerSettlementReferenceDate AS PartnerSettlementReferenceDate,
  I_GLAccountLineItem.LogicalSystem AS LogicalSystem,
  I_GLAccountLineItem.MaterialGroup AS MaterialGroup,
  I_GLAccountLineItem.SoldProductGroup AS SoldProductGroup,
  I_GLAccountLineItem.OriginCostCenter AS OriginCostCenter,
  I_GLAccountLineItem.OriginProfitCenter AS OriginProfitCenter,
  I_GLAccountLineItem.OriginCostCtrActivityType AS OriginCostCtrActivityType,
  I_GLAccountLineItem.OriginProduct AS OriginProduct,
  I_GLAccountLineItem.VarianceOriginGLAccount AS VarianceOriginGLAccount,
  I_GLAccountLineItem.OriginObjectType AS OriginObjectType,
  I_GLAccountLineItem.PartnerAccountAssignment AS PartnerAccountAssignment,
  I_GLAccountLineItem.PartnerAccountAssignmentType AS PartnerAccountAssignmentType,
  I_GLAccountLineItem.PartnerBudgetPeriod AS PartnerBudgetPeriod,
  I_GLAccountLineItem.PartnerBusinessArea AS PartnerBusinessArea,
  I_GLAccountLineItem.PartnerBusinessProcess AS PartnerBusinessProcess,
  I_GLAccountLineItem.PartnerCompanyCode AS PartnerCompanyCode,
  I_GLAccountLineItem.PartnerCostCenter AS PartnerCostCenter,
  I_GLAccountLineItem.PartnerCostObject AS PartnerCostObject,
  I_GLAccountLineItem.PartnerFunctionalArea AS PartnerFunctionalArea,
  I_GLAccountLineItem.PartnerFund AS PartnerFund,
  I_GLAccountLineItem.PartnerGrant AS PartnerGrant,
  I_GLAccountLineItem.PartnerOrder AS PartnerOrder,
  I_GLAccountLineItem.PartnerOrder_2 AS PartnerOrder_2,
  I_GLAccountLineItem.PartnerOrderCategory AS PartnerOrderCategory,
  I_GLAccountLineItem.PartnerProfitCenter AS PartnerProfitCenter,
  cast( PartnerProject as fis_part_project ) AS PartnerProject,
  PartnerProjectNetwork,
  PartnerProjectNetworkActivity,
  PartnerSalesDocument,
  PartnerSalesDocumentItem,
  PartnerSegment,
  cast( PartnerWBSElement as fis_partner_wbs ) AS PartnerWBSElement,
  PredecessorReferenceDocCntxt,
  PredecessorReferenceDocItem,
  PredecessorReferenceDocType,
  PredecessorReferenceDocument,
  SourceReferenceDocumentType,
  SourceReferenceDocumentCntxt,
  SourceReferenceDocument,
  SourceReferenceDocumentItem,
  SourceReferenceDocSubitem,
  IsCommitment,
  JrnlEntryItemObsoleteReason,
  ProjectInternalID,
  PartnerProjectInternalID,
  cast( _ProjectBasicData.ProjectExternalID as fis_projectext_no_conv ) AS ProjectExternalID,
  cast( _PartnerProjectBasicData.ProjectExternalID as fis_part_projectext_no_conv ) AS PartnerProjectExternalID,
  cast( Project as fis_project ) AS Project,
  ProjectNetwork,
  WorkPackage,
  WorkItem,
  QuantityIsIncomplete,
  ReferenceDocument,
  ReferenceDocumentContext,
  ReferenceDocumentItem,
  ReferenceDocumentItemGroup,
  ReferenceDocumentType,
  RelatedNetworkActivity,
  ReversalReferenceDocument,
  ReversalReferenceDocumentCntxt,
  SenderAccountAssignment,
  SenderAccountAssignmentType,
  SenderGLAccount,
  SoldMaterial,
  SoldProduct,
  CostOriginGroup,
  OriginSenderObject,
  CostAnalysisResource,
  CustomerSupplierCountry,
  CustomerSupplierIndustry,
  SalesDistrict,
  BillToParty,
  ShipToParty,
  CustomerSupplierCorporateGroup,
  FundsCenter,
  FundedProgram,
  IsStatisticalOrder,
  IsStatisticalCostCenter,
  IsStatisticalSalesDocument,
  WBSIsStatisticalWBSElement,
  WorkCenterInternalID,
  OrderOperation,
  OrderItem,
  AccrualObjectType,
  AccrualObject,
  AccrualSubobject,
  AccrualItemType,
  AccrualValueDate,
  FinancialValuationObjectType,
  FinancialValuationObject,
  FinancialValuationSubobject,
  NetDueDate,
  CreditRiskClass,
  OrderSuboperation,
  Equipment,
  FunctionalLocation,
  Assembly,
  MaintenanceActivityType,
  MaintenanceOrderPlanningCode,
  MaintPriorityType,
  MaintPriority,
  SuperiorOrder,
  ProductGroup,
  MaintenanceOrderIsPlanned,
  FinancialServicesProductGroup,
  FinancialServicesBranch,
  FinancialDataSource,
  I_GLAccountLineItem.ConsolidationUnit AS ConsolidationUnit,
  I_GLAccountLineItem.PartnerConsolidationUnit AS PartnerConsolidationUnit,
  I_GLAccountLineItem.Company AS Company,
  I_GLAccountLineItem.ConsolidationChartOfAccounts AS ConsolidationChartOfAccounts,
  I_GLAccountLineItem.CnsldtnFinancialStatementItem AS CnsldtnFinancialStatementItem,
  I_GLAccountLineItem.CnsldtnSubitemCategory AS CnsldtnSubitemCategory,
  I_GLAccountLineItem.CnsldtnSubitem AS CnsldtnSubitem,
  CompanyCodeCurrency,
  AmountInCompanyCodeCurrency,
  DebitAmountInCoCodeCrcy,
  CreditAmountInCoCodeCrcy,
  TransactionCurrency,
  AmountInTransactionCurrency,
  GlobalCurrency,
  AmountInGlobalCurrency,
  FunctionalCurrency,
  AmountInFunctionalCurrency,
  DebitAmountInFunctionalCrcy,
  CreditAmountInFunctionalCrcy,
  FreeDefinedCurrency1,
  AmountInFreeDefinedCurrency1,
  FreeDefinedCurrency2,
  AmountInFreeDefinedCurrency2,
  FreeDefinedCurrency3,
  AmountInFreeDefinedCurrency3,
  FreeDefinedCurrency4,
  AmountInFreeDefinedCurrency4,
  FreeDefinedCurrency5,
  AmountInFreeDefinedCurrency5,
  FreeDefinedCurrency6,
  AmountInFreeDefinedCurrency6,
  FreeDefinedCurrency7,
  AmountInFreeDefinedCurrency7,
  FreeDefinedCurrency8,
  AmountInFreeDefinedCurrency8,
  ControllingObjectCurrency,
  AmountInObjectCurrency,
  BaseUnit,
  Quantity,
  CostSourceUnit,
  ValuationQuantity,
  AdditionalQuantity1Unit,
  AdditionalQuantity1,
  AdditionalQuantity2Unit,
  AdditionalQuantity2,
  AdditionalQuantity3Unit,
  AdditionalQuantity3,
  DebitAmountInTransCrcy,
  CreditAmountInTransCrcy,
  BalanceTransactionCurrency,
  AmountInBalanceTransacCrcy,
  CreditAmountInBalanceTransCrcy,
  DebitAmountInBalanceTransCrcy,
  DebitAmountInGlobalCrcy,
  CreditAmountInGlobalCrcy,
  DebitAmountInFreeDefinedCrcy1,
  CreditAmountInFreeDefinedCrcy1,
  DebitAmountInFreeDefinedCrcy2,
  CreditAmountInFreeDefinedCrcy2,
  DebitAmountInFreeDefinedCrcy3,
  CreditAmountInFreeDefinedCrcy3,
  DebitAmountInFreeDefinedCrcy4,
  CreditAmountInFreeDefinedCrcy4,
  DebitAmountInFreeDefinedCrcy5,
  CreditAmountInFreeDefinedCrcy5,
  DebitAmountInFreeDefinedCrcy6,
  CreditAmountInFreeDefinedCrcy6,
  DebitAmountInFreeDefinedCrcy7,
  CreditAmountInFreeDefinedCrcy7,
  DebitAmountInFreeDefinedCrcy8,
  CreditAmountInFreeDefinedCrcy8,
  FixedAmountInGlobalCrcy,
  GrpValnFixedAmtInGlobCrcy,
  PrftCtrValnFxdAmtInGlobCrcy,
  TotalPriceVarcInGlobalCrcy,
  GrpValnTotPrcVarcInGlobCrcy,
  PrftCtrValnTotPrcVarcInGlbCrcy,
  FixedPriceVarcInGlobalCrcy,
  GrpValnFixedPrcVarcInGlobCrcy,
  PrftCtrValnFxdPrcVarcInGlbCrcy,
  FixedQuantity,
  ValuationFixedQuantity,
  CalendarYear,
  CalendarQuarter,
  CalendarYearQuarter,
  CalendarMonth,
  CalendarYearMonth,
  CalendarWeek,
  CalendarYearWeek,
  _FiscalCalendarDate.FiscalQuarter AS FiscalQuarter,
  _FiscalCalendarDate.FiscalWeek AS FiscalWeek,
  _FiscalCalendarDate.FiscalYearQuarter AS FiscalYearQuarter,
  _FiscalCalendarDate.FiscalYearWeek AS FiscalYearWeek,
  I_GLAccountLineItem._ConsolidationUnit AS _ConsolidationUnit,
  I_GLAccountLineItem._PartnerConsolidationUnit AS _PartnerConsolidationUnit,
  I_GLAccountLineItem._Company AS _Company,
  I_GLAccountLineItem._ConsolidationChartOfAccounts AS _ConsolidationChartOfAccounts,
  I_GLAccountLineItem._CnsldtnFinancialStatementItem AS _CnsldtnFinancialStatementItem,
  I_GLAccountLineItem._CnsldtnSubitemCategory AS _CnsldtnSubitemCategory,
  I_GLAccountLineItem._CnsldtnSubitem AS _CnsldtnSubitem,
  GLAccountAuthorizationGroup,
  SupplierBasicAuthorizationGrp,
  CustomerBasicAuthorizationGrp,
  AcctgDocTypeAuthorizationGroup,
  OrderType,
  SalesOrderType
FROM I_GLAccountLineItem
LEFT OUTER JOIN I_Housebank AS _HouseBank ON CompanyCode = _HouseBank.CompanyCode AND HouseBank = _HouseBank.HouseBank  -- association [0..1]
LEFT OUTER JOIN I_HouseBankAccount AS _HouseBankAccount ON CompanyCode = _HouseBankAccount.CompanyCode AND HouseBank = _HouseBankAccount.HouseBank AND HouseBankAccount = _HouseBankAccount.HouseBankAccount  -- association [0..1]
LEFT OUTER JOIN I_WBSElement AS _WBSElement ON WBSElement = _WBSElement.WBSElement  -- association [0..1]
LEFT OUTER JOIN I_WBSElement AS _WBSElementText ON WBSElement = _WBSElementText.WBSElement  -- association [0..1]
LEFT OUTER JOIN I_WBSElement AS _PartnerWBSElement ON PartnerWBSElement = _PartnerWBSElement.WBSElement  -- association [0..1]
LEFT OUTER JOIN I_WBSElement AS _PartnerWBSElementText ON PartnerWBSElement = _PartnerWBSElementText.WBSElement  -- association [0..1]
LEFT OUTER JOIN I_WBSElement AS _InventorySpclStockWBSElement ON InventorySpclStockWBSElement = _InventorySpclStockWBSElement.WBSElement  -- association [0..1]
LEFT OUTER JOIN I_WBSElementBasicData AS _PartnerWBSElemntBasicDataText ON PartnerWBSElementInternalID = _PartnerWBSElemntBasicDataText.WBSElementInternalID  -- association [0..1]
LEFT OUTER JOIN I_WBSElementBasicData AS _InvtrySpclStockWBSElmntBD ON InvtrySpclStockWBSElmntIntID = _InvtrySpclStockWBSElmntBD.WBSElementInternalID  -- association [0..1]
LEFT OUTER JOIN I_Project AS _Project ON Project = _Project.Project  -- association [0..1]
LEFT OUTER JOIN I_Project AS _ProjectText ON Project = _ProjectText.Project  -- association [0..1]
LEFT OUTER JOIN I_Project AS _PartnerProject ON PartnerProject = _PartnerProject.Project  -- association [0..1]
LEFT OUTER JOIN I_Project AS _PartnerProjectText ON PartnerProject = _PartnerProjectText.Project  -- 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_WBSElementBasicData AS _PartnerWBSElementBasicData ON PartnerWBSElementInternalID = _PartnerWBSElementBasicData.WBSElementInternalID  -- association [0..1]
LEFT OUTER JOIN I_WBSElementBasicData AS _PartnerWBSElmntBasicDataText ON PartnerWBSElementInternalID = _PartnerWBSElmntBasicDataText.WBSElementInternalID  -- association [0..1]
LEFT OUTER JOIN I_WBSElementBasicData AS _InvtrySpclStkWBSElmntBscData ON InvtrySpclStockWBSElmntIntID = _InvtrySpclStkWBSElmntBscData.WBSElementInternalID  -- association [0..1]
LEFT OUTER JOIN I_WBSElementBasicData AS _InvtrySpclStkWBSElmntBscDataT ON InvtrySpclStockWBSElmntIntID = _InvtrySpclStkWBSElmntBscDataT.WBSElementInternalID  -- association [0..1]
LEFT OUTER JOIN I_ProjectBasicData AS _ProjectBasicData ON ProjectInternalID = _ProjectBasicData.ProjectInternalID  -- association [0..1]
LEFT OUTER JOIN I_ProjectBasicData AS _ProjectBasicDataText ON ProjectInternalID = _ProjectBasicDataText.ProjectInternalID  -- association [0..1]
LEFT OUTER JOIN I_ProjectBasicData AS _PartnerProjectBasicData ON PartnerProjectInternalID = _PartnerProjectBasicData.ProjectInternalID  -- association [0..1]
LEFT OUTER JOIN I_ProjectBasicData AS _PartnerProjectBasicDataText ON PartnerProjectInternalID = _PartnerProjectBasicDataText.ProjectInternalID  -- association [0..1]
LEFT OUTER JOIN I_WBSElementByExternalID AS _WBSElementExternalID ON WBSElementExternalID = _WBSElementExternalID.WBSElementExternalID  -- association [0..1]
LEFT OUTER JOIN I_WBSElementByExternalID AS _WBSElementExternalIDText ON WBSElementExternalID = _WBSElementExternalIDText.WBSElementExternalID  -- association [0..1]
LEFT OUTER JOIN I_WBSElementByExternalID AS _PartnerWBSElementExternalID ON PartnerWBSElementExternalID = _PartnerWBSElementExternalID.WBSElementExternalID  -- association [0..1]
LEFT OUTER JOIN I_WBSElementByExternalID AS _PartnerWBSElemntExtrnalIDText ON PartnerWBSElementExternalID = _PartnerWBSElemntExtrnalIDText.WBSElementExternalID  -- association [0..1]
LEFT OUTER JOIN I_WBSElementByExternalID AS _InvtrySpclStockWBSElmntExtID ON InvtrySpclStockWBSElmntExtID = _InvtrySpclStockWBSElmntExtID.WBSElementExternalID  -- association [0..1]
LEFT OUTER JOIN I_ProjectByExternalID AS _ProjectExternalID ON ProjectExternalID = _ProjectExternalID.ProjectExternalID  -- association [0..1]
LEFT OUTER JOIN I_ProjectByExternalID AS _ProjectExternalIDText ON ProjectExternalID = _ProjectExternalIDText.ProjectExternalID  -- association [0..1]
LEFT OUTER JOIN I_ProjectByExternalID AS _PartnerProjectExternalID ON PartnerProjectExternalID = _PartnerProjectExternalID.ProjectExternalID  -- association [0..1]
LEFT OUTER JOIN I_ProjectByExternalID AS _PartnerProjctExtrnalIDText ON PartnerProjectExternalID = _PartnerProjctExtrnalIDText.ProjectExternalID  -- 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_OperationalAcctgDocItem AS _OperationalAcctgDocItem ON CompanyCode = _OperationalAcctgDocItem.CompanyCode AND FiscalYear = _OperationalAcctgDocItem.FiscalYear AND AccountingDocument = _OperationalAcctgDocItem.AccountingDocument AND AccountingDocumentItem = _OperationalAcctgDocItem.AccountingDocumentItem  -- association [0..1]
LEFT OUTER JOIN I_CalendarMonth AS _CalendarMonth ON CalendarMonth = _CalendarMonth.CalendarMonth  -- association [1..1]
LEFT OUTER JOIN I_CalendarQuarter AS _CalendarQuarter ON CalendarQuarter = _CalendarQuarter.CalendarQuarter  -- association [1..1]
LEFT OUTER JOIN I_YearMonth AS _CalendarYearMonth ON CalendarYearMonth = _CalendarYearMonth.YearMonth  -- association [1..1]
LEFT OUTER JOIN E_JournalEntryItem AS _Extension ON SourceLedger = _Extension.SourceLedger AND CompanyCode = _Extension.CompanyCode AND FiscalYear = _Extension.FiscalYear AND AccountingDocument = _Extension.AccountingDocument AND LedgerGLLineItem = _Extension.LedgerGLLineItem  -- association [1..1]
;