I_JournalEntryItemCube

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_JournalEntryItemCube.
-- 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_JournalEntryItemCube AS
SELECT
  SourceLedger,
  CompanyCode,
  FiscalYear,
  AccountingDocument,
  LedgerGLLineItem,
  Ledger,
  LedgerFiscalYear,
  GLRecordType,
  _Ledger._Text[1: Language = $session.system_language].LedgerName AS LedgerName,
  cast( _CompanyCode.CompanyCodeName as fis_butxt preserving type ) AS CompanyCodeName,
  ChartOfAccounts,
  ControllingArea,
  cast( _ControllingArea.ControllingAreaName as fis_bezei preserving type ) AS ControllingAreaName,
  FinancialTransactionType,
  BusinessTransactionCategory,
  BusinessTransactionType,
  ReferenceDocumentType,
  LogicalSystem,
  ReferenceDocumentContext,
  ReferenceDocument,
  ReferenceDocumentItem,
  ReferenceDocumentItemGroup,
  IsReversal,
  IsReversed,
  ReversalReferenceDocumentCntxt,
  ReversalReferenceDocument,
  IsSettlement,
  IsSettled,
  PredecessorReferenceDocType,
  PredecessorReferenceDocCntxt,
  PredecessorReferenceDocument,
  PredecessorReferenceDocItem,
  SourceReferenceDocumentType,
  SourceLogicalSystem,
  SourceReferenceDocumentCntxt,
  SourceReferenceDocument,
  SourceReferenceDocumentItem,
  SourceReferenceDocSubitem,
  IsCommitment,
  JrnlEntryItemObsoleteReason,
  OrganizationalChange,
  GLAccount,
  cast( _GLAccountInChartOfAccounts._Text[1: Language = $session.system_language].GLAccountName as fis_txt30_skat ) AS GLAccountName,
  cast( _GLAccountInChartOfAccounts._Text[1: Language = $session.system_language].GLAccountLongName as fis_txt50_skat preserving type ) AS GLAccountLongName,
  CostCenter,
  cast( _CostCenter[1:ValidityStartDate <= $session.system_date and ValidityEndDate >= $session.system_date]._Text[1: Language = $session.system_language].CostCenterName as fis_kostl_name preserving type ) AS CostCenterName,
  ProfitCenter,
  _ProfitCenter[1:ValidityStartDate <= $session.system_date and ValidityEndDate >= $session.system_date]._Text[1: Language = $session.system_language].ProfitCenterName AS ProfitCenterName,
  FunctionalArea,
  cast( _FunctionalArea._Text[1: Language = $session.system_language].FunctionalAreaName as fis_funcarea_name ) AS FunctionalAreaName,
  BusinessArea,
  cast( _BusinessArea._Text[1: Language = $session.system_language].BusinessAreaName as fis_busarea_name preserving type ) AS BusinessAreaName,
  Segment,
  _Segment._Text[1: Language = $session.system_language].SegmentName AS SegmentName,
  PartnerCostCenter,
  PartnerProfitCenter,
  PartnerFunctionalArea,
  PartnerBusinessArea,
  PartnerCompany,
  PartnerSegment,
  BalanceTransactionCurrency,
  AmountInBalanceTransacCrcy,
  TransactionCurrency,
  AmountInTransactionCurrency,
  CompanyCodeCurrency,
  AmountInCompanyCodeCurrency,
  GlobalCurrency,
  AmountInGlobalCurrency,
  FunctionalCurrency,
  AmountInFunctionalCurrency,
  FreeDefinedCurrency1,
  AmountInFreeDefinedCurrency1,
  FreeDefinedCurrency2,
  AmountInFreeDefinedCurrency2,
  FreeDefinedCurrency3,
  AmountInFreeDefinedCurrency3,
  FreeDefinedCurrency4,
  AmountInFreeDefinedCurrency4,
  FreeDefinedCurrency5,
  AmountInFreeDefinedCurrency5,
  FreeDefinedCurrency6,
  AmountInFreeDefinedCurrency6,
  FreeDefinedCurrency7,
  AmountInFreeDefinedCurrency7,
  FreeDefinedCurrency8,
  AmountInFreeDefinedCurrency8,
  FixedAmountInGlobalCrcy,
  FixedAmountInCoCodeCrcy,
  GrpValnFixedAmtInGlobCrcy,
  PrftCtrValnFxdAmtInGlobCrcy,
  TotalPriceVarcInGlobalCrcy,
  GrpValnTotPrcVarcInGlobCrcy,
  PrftCtrValnTotPrcVarcInGlbCrcy,
  FixedPriceVarcInGlobalCrcy,
  GrpValnFixedPrcVarcInGlobCrcy,
  PrftCtrValnFxdPrcVarcInGlbCrcy,
  ControllingObjectCurrency,
  AmountInObjectCurrency,
  BaseUnit,
  Quantity,
  FixedQuantity,
  CostSourceUnit,
  ValuationQuantity,
  ValuationFixedQuantity,
  ReferenceQuantityUnit,
  ReferenceQuantity,
  AdditionalQuantity1Unit,
  AdditionalQuantity1,
  AdditionalQuantity2Unit,
  AdditionalQuantity2,
  AdditionalQuantity3Unit,
  AdditionalQuantity3,
  DebitCreditCode,
  cast( _DebitCreditCode._Text[1: Language = $session.system_language].DebitCreditCodeName as fis_shkzg_name preserving type ) AS DebitCreditCodeName,
  FiscalPeriod,
  FiscalYearVariant,
  FiscalYearPeriod,
  PostingDate,
  DocumentDate,
  AccountingDocumentType,
  _AccountingDocumentType._Text[1: Language = $session.system_language].AccountingDocumentTypeName AS AccountingDocumentTypeName,
  AccountingDocumentItem,
  AssignmentReference,
  AccountingDocumentCategory,
  PostingKey,
  TransactionTypeDetermination,
  SubLedgerAcctLineItemType,
  AccountingDocCreatedByUser,
  LastChangeDateTime,
  CreationDateTime,
  CreationDate,
  EliminationProfitCenter,
  OriginObjectType,
  GLAccountType,
  AlternativeGLAccount,
  CountryChartOfAccounts,
  InvoiceReference,
  InvoiceReferenceFiscalYear,
  FollowOnDocumentType,
  InvoiceItemReference,
  ReferencePurchaseOrderCategory,
  PurchasingDocument,
  PurchasingDocumentItem,
  AccountAssignmentNumber,
  DocumentItemText,
  SalesOrder,
  SalesOrderItem,
  SalesDocument,
  SalesDocumentItem,
  Material,
  Product,
  Plant,
  Supplier,
  _Supplier.SupplierName AS SupplierName,
  Customer,
  _Customer.CustomerName AS CustomerName,
  ServicesRenderedDate,
  ConditionContract,
  FinancialAccountType,
  SpecialGLCode,
  TaxCode,
  HouseBank,
  HouseBankAccount,
  IsOpenItemManaged,
  ClearingDate,
  ClearingAccountingDocument,
  ClearingDocFiscalYear,
  ClearingJournalEntry,
  ClearingJournalEntryFiscalYear,
  ValueDate,
  AssetDepreciationArea,
  MasterFixedAsset,
  FixedAsset,
  AssetValueDate,
  AssetTransactionType,
  AssetAcctTransClassfctn,
  DepreciationFiscalPeriod,
  GroupMasterFixedAsset,
  GroupFixedAsset,
  AssetClass,
  CostEstimate,
  InventorySpecialStockValnType,
  InvtrySpecialStockValnType_2,
  InventorySpecialStockType,
  InventorySpclStkSalesDocument,
  InventorySpclStkSalesDocItm,
  InvtrySpclStockWBSElmntIntID,
  cast( _InvtrySpclStockWBSElmntBD.WBSElementExternalID as fis_invspstock_wbsext_no_conv preserving type ) AS InvtrySpclStockWBSElmntExtID,
  cast( _InvtrySpclStockWBSElmntBD.WBSElement as fis_invspstock_wbs preserving type ) AS InventorySpclStockWBSElement,
  InventorySpecialStockSupplier,
  InventoryValuationType,
  ValuationArea,
  SenderGLAccount,
  SenderAccountAssignment,
  SenderAccountAssignmentType,
  ControllingObject,
  CostOriginGroup,
  OriginSenderObject,
  ControllingDebitCreditCode,
  ControllingObjectDebitType,
  QuantityIsIncomplete,
  OffsettingAccount,
  _OffsettingAccountWithBP.OffsettingAccountName AS OffsettingAccountName,
  OffsettingAccountType,
  OffsettingChartOfAccounts,
  LineItemIsCompleted,
  PersonnelNumber,
  BillableControl,
  ControllingObjectClass,
  PartnerCompanyCode,
  PartnerControllingObjectClass,
  OriginCostCenter,
  OriginProfitCenter,
  OriginCostCtrActivityType,
  OriginProduct,
  VarianceOriginGLAccount,
  AccountAssignment,
  AccountAssignmentType,
  CostCtrActivityType,
  OrderID,
  OrderCategory,
  WBSElementInternalID,
  PartnerWBSElementInternalID,
  cast( _PartnerWBSElementBasicData.WBSElementExternalID as fis_partner_wbsext_no_conv preserving type ) AS PartnerWBSElementExternalID,
  cast( _WBSElementBasicData.WBSElementExternalID as fis_wbsext_no_conv preserving type ) AS WBSElementExternalID,
  cast( WBSElement as fis_wbs preserving type ) AS WBSElement,
  ProjectInternalID,
  PartnerProjectInternalID,
  cast( _ProjectBasicData.ProjectExternalID as fis_projectext_no_conv preserving type ) AS ProjectExternalID,
  cast( _PartnerProjectBasicData.ProjectExternalID as fis_part_projectext_no_conv preserving type ) AS PartnerProjectExternalID,
  WorkPackage,
  cast( Project as fis_project preserving type ) AS Project,
  OperatingConcern,
  ProjectNetwork,
  RelatedNetworkActivity,
  BusinessProcess,
  CostObject,
  CostAnalysisResource,
  CustomerServiceNotification,
  ServiceDocumentType,
  ServiceDocument,
  ServiceDocumentItem,
  PartnerServiceDocumentType,
  PartnerServiceDocument,
  PartnerServiceDocumentItem,
  ServiceContractType,
  ServiceContract,
  ServiceContractItem,
  BusinessSolutionOrder,
  BusinessSolutionOrderItem,
  TimeSheetOvertimeCategory,
  PartnerAccountAssignment,
  PartnerAccountAssignmentType,
  PartnerCostCtrActivityType,
  PartnerOrder,
  PartnerOrder_2,
  PartnerOrderCategory,
  cast( PartnerWBSElement as fis_partner_wbs preserving type ) AS PartnerWBSElement,
  cast( PartnerProject as fis_part_project preserving type ) AS PartnerProject,
  PartnerSalesDocument,
  PartnerSalesDocumentItem,
  PartnerProjectNetwork,
  PartnerProjectNetworkActivity,
  PartnerBusinessProcess,
  PartnerCostObject,
  WorkItem,
  BillingDocumentType,
  SalesOrganization,
  DistributionChannel,
  OrganizationDivision,
  SoldMaterial,
  SoldProduct,
  MaterialGroup,
  SoldProductGroup,
  CustomerGroup,
  CustomerSupplierCountry,
  CustomerSupplierIndustry,
  SalesDistrict,
  BillToParty,
  ShipToParty,
  CustomerSupplierCorporateGroup,
  CashLedgerCompanyCode,
  CashLedgerAccount,
  FinancialManagementArea,
  CommitmentItem,
  FundsCenter,
  FundedProgram,
  Fund,
  GrantID,
  BudgetPeriod,
  PartnerFund,
  PartnerGrant,
  PartnerBudgetPeriod,
  PubSecBudgetAccount,
  PubSecBudgetAccountCoCode,
  PubSecBudgetCnsmpnDate,
  PubSecBudgetCnsmpnFsclPeriod,
  PubSecBudgetCnsmpnFsclYear,
  PubSecBudgetIsRelevant,
  PubSecBudgetCnsmpnType,
  PubSecBudgetCnsmpnAmtType,
  EarmarkedFundsDocument,
  EarmarkedFundsDocumentItem,
  SponsoredProgram,
  SponsoredClass,
  GteeMBudgetValidityNumber,
  JointVenture,
  JointVentureEquityGroup,
  JointVentureCostRecoveryCode,
  JointVenturePartner,
  JointVentureBillingType,
  JointVentureEquityType,
  JointVentureProductionDate,
  JointVentureBillingDate,
  JointVentureOperationalDate,
  CutbackRun,
  JointVentureAccountingActivity,
  PartnerVenture,
  PartnerEquityGroup,
  SenderCostRecoveryCode,
  CutbackAccount,
  CutbackCostObject,
  SettlementReferenceDate,
  WorkCenterInternalID,
  OrderOperation,
  OrderItem,
  REBusinessEntity,
  RealEstateBuilding,
  RealEstateProperty,
  RERentalObject,
  RealEstateContract,
  REServiceChargeKey,
  RESettlementUnitID,
  AccrualObjectType,
  AccrualObject,
  AccrualSubobject,
  AccrualItemType,
  AccrualValueDate,
  FinancialValuationObjectType,
  FinancialValuationObject,
  FinancialValuationSubobject,
  NetDueDate,
  CreditRiskClass,
  OrderSuboperation,
  Equipment,
  FunctionalLocation,
  Assembly,
  MaintenanceActivityType,
  MaintenanceOrderPlanningCode,
  MaintPriorityType,
  MaintPriority,
  SuperiorOrder,
  ProductGroup,
  MaintenanceOrderIsPlanned,
  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,
  IsStatisticalOrder,
  IsStatisticalCostCenter,
  IsStatisticalSalesDocument,
  WBSIsStatisticalWBSElement,
  NumberOfItems,
  _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,
  cast( _JournalEntry.SenderAccountingDocument as fis_belnr_sender preserving type ) AS SenderAccountingDocument,
  SenderCompanyCode,
  cast( _JournalEntry.SenderFiscalYear as fis_gjahr_sender_no_conv preserving type ) AS SenderFiscalYear,
  cast( _JournalEntry.SenderLogicalSystem as logsystem_sender preserving type ) AS SenderLogicalSystem,
  _LedgerCompanyCodeCrcyRoles.GlobalCurrencyRole AS GlobalCurrencyRole,
  _LedgerCompanyCodeCrcyRoles.FreeDefinedCurrency1Role AS FreeDefinedCurrency1Role,
  _LedgerCompanyCodeCrcyRoles.FreeDefinedCurrency2Role AS FreeDefinedCurrency2Role,
  _LedgerCompanyCodeCrcyRoles.FreeDefinedCurrency3Role AS FreeDefinedCurrency3Role,
  _LedgerCompanyCodeCrcyRoles.FreeDefinedCurrency4Role AS FreeDefinedCurrency4Role,
  _LedgerCompanyCodeCrcyRoles.FreeDefinedCurrency5Role AS FreeDefinedCurrency5Role,
  _LedgerCompanyCodeCrcyRoles.FreeDefinedCurrency6Role AS FreeDefinedCurrency6Role,
  _LedgerCompanyCodeCrcyRoles.FreeDefinedCurrency7Role AS FreeDefinedCurrency7Role,
  _LedgerCompanyCodeCrcyRoles.FreeDefinedCurrency8Role AS FreeDefinedCurrency8Role,
  cast( _BillToParty.CustomerName as bill_to_name preserving type ) AS BillToPartyName,
  cast( _CostCtrActivityType[1:ValidityStartDate <= $session.system_date and ValidityEndDate >= $session.system_date]._Text[1: Language = $session.system_language].CostCtrActivityTypeName as fis_lstar_text ) AS CostCtrActivityTypeName,
  cast( _CustomerGroup._Text[1: Language = $session.system_language].CustomerGroupName as fis_customergroup_name ) AS CustomerGroupName,
  _CustomerSupplierCountry._Text[1: Language = $session.system_language].CountryName AS CustomerSupplierCountryName,
  _CustomerSupplierIndustryText[1: Language = $session.system_language].SupplierIndustryName AS CustomerSupplierIndustryName,
  cast( _DistributionChannel._Text[1: Language = $session.system_language].DistributionChannelName as fis_distributionchannel_name preserving type ) AS DistributionChannelName,
  cast( _Division._Text[1: Language = $session.system_language].DivisionName as fis_division_name ) AS DivisionName,
  _Material._Text[1: Language = $session.system_language].MaterialName AS MaterialName,
  _MaterialGroup._Text[1: Language = $session.system_language].MaterialGroupName AS MaterialGroupName,
  _Product._Text[1: Language = $session.system_language].ProductName AS ProductName,
  _ProductGroup_2._ProductGroupText[1: Language = $session.system_language].ProductGroupName AS ProductGroupName,
  cast( _PartnerBusinessArea._Text[1: Language = $session.system_language].BusinessAreaName as fis_partner_busarea_name preserving type ) AS PartnerBusinessAreaName,
  cast( _PartnerCompany[1: Language = $session.system_language].CompanyName as fis_rcomp_name preserving type ) AS PartnerCompanyName,
  cast( _PartnerCompanyCode.CompanyCodeName as fis_partner_company_code_name preserving type ) AS PartnerCompanyCodeName,
  cast( _PartnerCostCenter[1:ValidityStartDate <= $session.system_date and ValidityEndDate >= $session.system_date]._Text[1: Language = $session.system_language].CostCenterName as fis_partner_kostl_name preserving type ) AS PartnerCostCenterName,
  cast( _PartnerCostCtrActivityType[1:ValidityStartDate <= $session.system_date and ValidityEndDate >= $session.system_date]._Text[1: Language = $session.system_language].CostCtrActivityTypeName as fis_partner_activity_type_name ) AS PartnerCostCtrActivityTypeName,
  cast( _PartnerFunctionalArea._Text[1: Language = $session.system_language].FunctionalAreaName as fis_partner_funcarea_name ) AS PartnerFunctionalAreaName,
  cast( _PartnerProfitCenter[1:ValidityStartDate <= $session.system_date and ValidityEndDate >= $session.system_date]._Text[1: Language = $session.system_language].ProfitCenterName as fis_partner_prctr_name ) AS PartnerProfitCenterName,
  cast( _PartnerProjectBasicData.ProjectDescription as fis_partner_project_descript preserving type ) AS PartnerProjectDescription,
  cast( _PartnerSegment._Text[1: Language = $session.system_language].SegmentName as fis_partner_segment_name preserving type ) AS PartnerSegmentName,
  cast( _PartnerWBSElementBasicData.WBSDescription as fis_partner_wbs_descript preserving type ) AS PartnerWBSElementDescription,
  _Plant.PlantName AS PlantName,
  cast( _ProjectBasicData.ProjectDescription as fis_project_description preserving type ) AS ProjectDescription,
  _SalesDistrict._Text[1: Language = $session.system_language].SalesDistrictName AS SalesDistrictName,
  cast( _SalesOrganization._Text[1: Language = $session.system_language].SalesOrganizationName as fis_sales_organization_name preserving type ) AS SalesOrganizationName,
  cast( _ShipToParty.CustomerName as ship_to_name preserving type ) AS ShipToPartyName,
  cast( _SoldMaterial._Text[1: Language = $session.system_language].MaterialName as fis_matnr_copa_name preserving type ) AS SoldMaterialName,
  cast( _SoldProduct._Text[1: Language = $session.system_language].ProductName as fis_matnr_copa_name preserving type ) AS SoldProductName,
  _SoldProductGroup_2._ProductGroupText[1: Language = $session.system_language].ProductGroupName AS SoldProductGroupName,
  _WBSElementBasicData.WBSDescription AS WBSElementDescription,
  GLAccountAuthorizationGroup,
  SupplierBasicAuthorizationGrp,
  CustomerBasicAuthorizationGrp,
  AcctgDocTypeAuthorizationGroup,
  OrderType,
  SalesOrderType
FROM I_JournalEntryItem
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_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_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_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_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 I_SupplierInvoiceAPI01 AS _SupplierInvoice ON ReferenceDocumentType = 'RMRP' AND LogicalSystem = ' ' AND ReferenceDocumentContext = _SupplierInvoice.FiscalYear AND ReferenceDocument = _SupplierInvoice.SupplierInvoice  -- association [0..1]
LEFT OUTER JOIN E_JournalEntryItem AS _Extension ON SourceLedger = _Extension.SourceLedger AND CompanyCode = _Extension.CompanyCode AND FiscalYear = _Extension.FiscalYear AND AccountingDocument = _Extension.AccountingDocument AND LedgerGLLineItem = _Extension.LedgerGLLineItem  -- association [1..1]
;