P_Glacctbalance2

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 P_Glacctbalance2.
-- 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: PFIGLACCTBAL2
-- Parameters: P_FromPostingDate : fis_budat_from, P_ToPostingDate : fis_budat_to

CREATE VIEW P_Glacctbalance2 AS
SELECT
  I_GLAccountLineItem.Ledger AS rldnr,
  I_GLAccountLineItem.CompanyCode AS rbukrs,
  I_GLAccountLineItem.FiscalYear AS gjahr,
  I_GLAccountLineItem.AccountingDocument AS belnr,
  I_GLAccountLineItem.LedgerGLLineItem AS docln,
  I_GLAccountLineItem.SourceLedger AS rldnr_pers,
  I_GLAccountLineItem.LedgerFiscalYear AS ryear,
  I_GLAccountLineItem.FinancialTransactionType AS rmvct,
  I_GLAccountLineItem.BusinessTransactionType AS bttype,
  I_GLAccountLineItem.ReferenceDocumentType AS awtyp,
  I_GLAccountLineItem.LogicalSystem AS awsys,
  I_GLAccountLineItem.ReferenceDocumentContext AS aworg,
  I_GLAccountLineItem.ReferenceDocument AS awref,
  I_GLAccountLineItem.ReferenceDocumentItem AS awitem,
  I_GLAccountLineItem.ReferenceDocumentItemGroup AS awitgrp,
  I_GLAccountLineItem.IsReversal AS xreversing,
  I_GLAccountLineItem.IsReversed AS xreversed,
  I_GLAccountLineItem.ReversalReferenceDocumentCntxt AS aworg_rev,
  I_GLAccountLineItem.ReversalReferenceDocument AS awref_rev,
  I_GLAccountLineItem.IsSettlement AS xsettling,
  I_GLAccountLineItem.IsSettled AS xsettled,
  I_GLAccountLineItem.PredecessorReferenceDocType AS prec_awtyp,
  I_GLAccountLineItem.PredecessorReferenceDocCntxt AS prec_aworg,
  I_GLAccountLineItem.PredecessorReferenceDocument AS prec_awref,
  I_GLAccountLineItem.PredecessorReferenceDocItem AS prec_awitem,
  I_GLAccountLineItem.GLAccount AS racct,
  I_GLAccountLineItem.ProfitCenter AS prctr,
  I_GLAccountLineItem.FunctionalArea AS rfarea,
  I_GLAccountLineItem.BusinessArea AS rbusa,
  I_GLAccountLineItem.ControllingArea AS kokrs,
  I_GLAccountLineItem.Segment AS segment,
  I_GLAccountLineItem.PartnerCostCenter AS scntr,
  I_GLAccountLineItem.PartnerProfitCenter AS pprctr,
  I_GLAccountLineItem.PartnerFunctionalArea AS sfarea,
  I_GLAccountLineItem.PartnerBusinessArea AS sbusa,
  I_GLAccountLineItem.PartnerCompany AS rassc,
  I_GLAccountLineItem.PartnerSegment AS psegment,
  I_GLAccountLineItem.DebitCreditCode AS drcrk,
  I_GLAccountLineItem.FiscalYearVariant AS periv,
  I_GLAccountLineItem.FiscalYearPeriod AS fiscyearper,
  I_GLAccountLineItem.AccountingDocumentType AS blart,
  I_GLAccountLineItem.AccountingDocumentItem AS buzei,
  I_GLAccountLineItem.AssignmentReference AS zuonr,
  I_GLAccountLineItem.PostingKey AS bschl,
  I_GLAccountLineItem.AccountingDocumentCategory AS bstat,
  I_GLAccountLineItem.TransactionTypeDetermination AS ktosl,
  I_GLAccountLineItem.SubLedgerAcctLineItemType AS slalittype,
  I_GLAccountLineItem.AccountingDocCreatedByUser AS usnam,
  I_GLAccountLineItem.EliminationProfitCenter AS eprctr,
  I_GLAccountLineItem.OriginObjectType AS rhoart,
  I_GLAccountLineItem.ChartOfAccounts AS ktopl,
  I_GLAccountLineItem.AlternativeGLAccount AS lokkt,
  I_GLAccountLineItem.CountryChartOfAccounts AS ktop2,
  I_GLAccountLineItem.CreationDateTime AS CreationDateTime,
  I_GLAccountLineItem.InvoiceReference AS rebzg,
  I_GLAccountLineItem.InvoiceReferenceFiscalYear AS rebzj,
  I_GLAccountLineItem.FollowOnDocumentType AS rebzz,
  I_GLAccountLineItem.InvoiceItemReference AS rebzt,
  I_GLAccountLineItem.ReferencePurchaseOrderCategory AS rbest,
  I_GLAccountLineItem.PurchasingDocument AS ebeln,
  I_GLAccountLineItem.PurchasingDocumentItem AS ebelp,
  I_GLAccountLineItem.AccountAssignmentNumber AS zekkn,
  I_GLAccountLineItem.DocumentItemText AS sgtxt,
  I_GLAccountLineItem.Plant AS werks,
  I_GLAccountLineItem.Supplier AS lifnr,
  I_GLAccountLineItem.Customer AS kunnr,
  I_GLAccountLineItem.Product AS matnr,
  I_GLAccountLineItem.SoldProduct AS matnr_copa,
  I_GLAccountLineItem.SoldProductGroup AS matkl,
  I_GLAccountLineItem.ProductGroup AS matkl_mm,
  I_GLAccountLineItem.FinancialAccountType AS koart,
  I_GLAccountLineItem.SpecialGLCode AS umskz,
  I_GLAccountLineItem.TaxCode AS mwskz,
  I_GLAccountLineItem.HouseBank AS hbkid,
  I_GLAccountLineItem.HouseBankAccount AS hktid,
  I_GLAccountLineItem.IsOpenItemManaged AS xopvw,
  I_GLAccountLineItem.ClearingAccountingDocument AS augbl,
  I_GLAccountLineItem.ClearingDocFiscalYear AS auggj,
  I_GLAccountLineItem.AssetDepreciationArea AS afabe,
  I_GLAccountLineItem.MasterFixedAsset AS anln1,
  I_GLAccountLineItem.FixedAsset AS anln2,
  I_GLAccountLineItem.AssetValueDate AS bzdat,
  I_GLAccountLineItem.AssetTransactionType AS anbwa,
  I_GLAccountLineItem.AssetAcctTransClassfctn AS movcat,
  I_GLAccountLineItem.DepreciationFiscalPeriod AS depr_period,
  I_GLAccountLineItem.GroupMasterFixedAsset AS anlgr,
  I_GLAccountLineItem.GroupFixedAsset AS anlgr2,
  I_GLAccountLineItem.AssetClass AS AssetClass,
  I_GLAccountLineItem.CostEstimate AS kalnr,
  I_GLAccountLineItem.InventorySpecialStockValnType AS kzbws,
  I_GLAccountLineItem.InventorySpecialStockType AS sobkz,
  I_GLAccountLineItem.InventorySpclStkSalesDocument AS mat_kdauf,
  I_GLAccountLineItem.InventorySpclStkSalesDocItm AS mat_kdpos,
  I_GLAccountLineItem.InvtrySpclStockWBSElmntIntID AS mat_pspnr,
  I_GLAccountLineItem.InventorySpclStockWBSElement AS mat_ps_posid,
  I_GLAccountLineItem.InventorySpecialStockSupplier AS mat_lifnr,
  I_GLAccountLineItem.InventoryValuationType AS bwtar,
  I_GLAccountLineItem.ValuationArea AS bwkey,
  _InvtrySpclStockWBSElmntBD.WBSElementExternalID AS InvtrySpclStockWBSElmntExtID,
  I_GLAccountLineItem.SenderCompanyCode AS SenderCompanyCode,
  I_GLAccountLineItem.SenderGLAccount AS racct_sender,
  I_GLAccountLineItem.SenderAccountAssignment AS accas_sender,
  I_GLAccountLineItem.ControllingObjectDebitType AS beltp,
  I_GLAccountLineItem.QuantityIsIncomplete AS muvflg,
  I_GLAccountLineItem.OffsettingAccount AS gkont,
  I_GLAccountLineItem.OffsettingAccountType AS gkoar,
  I_GLAccountLineItem.LineItemIsCompleted AS erlkz,
  I_GLAccountLineItem.PersonnelNumber AS pernr,
  I_GLAccountLineItem.ControllingObjectClass AS scope,
  I_GLAccountLineItem.PartnerCompanyCode AS pbukrs,
  I_GLAccountLineItem.PartnerControllingObjectClass AS pscope,
  I_GLAccountLineItem.OriginCostCenter AS ukostl,
  I_GLAccountLineItem.OriginCostCtrActivityType AS ulstar,
  I_GLAccountLineItem.OriginProduct AS OriginProduct,
  I_GLAccountLineItem.VarianceOriginGLAccount AS VarianceOriginGLAccount,
  I_GLAccountLineItem.AccountAssignment AS accas,
  I_GLAccountLineItem.ProjectNetwork AS nplnr,
  I_GLAccountLineItem.RelatedNetworkActivity AS nplnr_vorgn,
  I_GLAccountLineItem.BusinessProcess AS prznr,
  I_GLAccountLineItem.CostObject AS kstrg,
  I_GLAccountLineItem.CustomerServiceNotification AS qmnum,
  I_GLAccountLineItem.ServiceDocumentType AS ServiceDocumentType,
  I_GLAccountLineItem.ServiceDocument AS ServiceDocument,
  I_GLAccountLineItem.ServiceDocumentItem AS ServiceDocumentItem,
  I_GLAccountLineItem.PartnerServiceDocumentType AS PartnerServiceDocumentType,
  I_GLAccountLineItem.PartnerServiceDocument AS PartnerServiceDocument,
  I_GLAccountLineItem.PartnerServiceDocumentItem AS PartnerServiceDocumentItem,
  I_GLAccountLineItem.ServiceContract AS ServiceContract,
  I_GLAccountLineItem.ServiceContractType AS ServiceContractType,
  I_GLAccountLineItem.ServiceContractItem AS ServiceContractItem,
  I_GLAccountLineItem.TimeSheetOvertimeCategory AS TimeSheetOvertimeCategory,
  I_GLAccountLineItem.OperatingConcern AS erkrs,
  I_GLAccountLineItem.PartnerAccountAssignment AS paccas,
  I_GLAccountLineItem.PartnerCostCtrActivityType AS plstar,
  I_GLAccountLineItem.PartnerOrder AS paufnr,
  I_GLAccountLineItem.PartnerOrder_2 AS PartnerOrder_2,
  I_GLAccountLineItem.PartnerOrderCategory AS pautyp,
  I_GLAccountLineItem.PartnerWBSElement AS pps_posid,
  I_GLAccountLineItem.PartnerProject AS pps_pspid,
  I_GLAccountLineItem.PartnerSalesDocument AS pkdauf,
  I_GLAccountLineItem.PartnerSalesDocumentItem AS pkdpos,
  I_GLAccountLineItem.PartnerProjectNetwork AS pnplnr,
  I_GLAccountLineItem.PartnerProjectNetworkActivity AS pnplnr_vorgn,
  I_GLAccountLineItem.PartnerBusinessProcess AS pprznr,
  I_GLAccountLineItem.PartnerCostObject AS pkstrg,
  I_GLAccountLineItem.BillingDocumentType AS fkart,
  I_GLAccountLineItem.SalesOrganization AS vkorg,
  I_GLAccountLineItem.DistributionChannel AS vtweg,
  I_GLAccountLineItem.OrganizationDivision AS spart,
  I_GLAccountLineItem.CustomerGroup AS kdgrp,
  I_GLAccountLineItem.CustomerSupplierCountry AS CustomerSupplierCountry,
  I_GLAccountLineItem.CustomerSupplierIndustry AS CustomerSupplierIndustry,
  I_GLAccountLineItem.FinancialServicesProductGroup AS FinancialServicesProductGroup,
  I_GLAccountLineItem.FinancialServicesBranch AS FinancialServicesBranch,
  I_GLAccountLineItem.FinancialDataSource AS FinancialDataSource,
  I_GLAccountLineItem.FinancialManagementArea AS fikrs,
  I_GLAccountLineItem.Fund AS rfund,
  I_GLAccountLineItem.GrantID AS rgrant_nbr,
  I_GLAccountLineItem.BudgetPeriod AS rbudget_pd,
  I_GLAccountLineItem.PartnerFund AS sfund,
  I_GLAccountLineItem.PartnerGrant AS sgrant_nbr,
  I_GLAccountLineItem.PartnerBudgetPeriod AS sbudget_pd,
  I_GLAccountLineItem.JointVenture AS vname,
  I_GLAccountLineItem.JointVentureEquityGroup AS egrup,
  I_GLAccountLineItem.JointVentureCostRecoveryCode AS recid,
  I_GLAccountLineItem.JointVentureEquityType AS etype,
  I_GLAccountLineItem.SettlementReferenceDate AS dabrz,
  I_GLAccountLineItem.CostCenter AS rcntr,
  I_GLAccountLineItem.CostCtrActivityType AS lstar,
  I_GLAccountLineItem.OrderID AS aufnr,
  I_GLAccountLineItem.OrderCategory AS autyp,
  I_GLAccountLineItem.WBSElementInternalID AS ps_psp_pnr,
  PartnerWBSElementInternalID,
  cast( _WBSElementBasicData.WBSElementExternalID as fis_wbsext_no_conv ) AS posid_edit,
  cast( _PartnerWBSElementBasicData.WBSElementExternalID as fis_partner_wbsext_no_conv ) AS PartnerWBSElementExternalID,
  I_GLAccountLineItem.WBSElement AS ps_posid,
  I_GLAccountLineItem.Project AS ps_pspid,
  I_GLAccountLineItem.ProjectInternalID AS ps_prj_pnr,
  PartnerProjectInternalID,
  cast( _ProjectBasicData.ProjectExternalID as fis_projectext_no_conv ) AS pspid_edit,
  cast( _PartnerProjectBasicData.ProjectExternalID as fis_part_projectext_no_conv ) AS PartnerProjectExternalID,
  I_GLAccountLineItem.SalesOrder AS kdauf,
  I_GLAccountLineItem.SalesOrderItem AS kdpos,
  I_GLAccountLineItem.FiscalPeriod AS poper,
  I_GLAccountLineItem.ClearingDate AS augdt,
  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,
  I_GLAccountLineItem._CompanyCode AS _CompanyCode,
  I_GLAccountLineItem._ControllingArea AS _ControllingArea,
  I_GLAccountLineItem._BalanceTransactionCurrency AS _BalanceTransactionCurrency,
  I_GLAccountLineItem._TransactionCurrency AS _TransactionCurrency,
  I_GLAccountLineItem._CompanyCodeCurrency AS _CompanyCodeCurrency,
  I_GLAccountLineItem._GlobalCurrency AS _GlobalCurrency,
  I_GLAccountLineItem._FreeDefinedCurrency1 AS _FreeDefinedCurrency1,
  I_GLAccountLineItem._FreeDefinedCurrency2 AS _FreeDefinedCurrency2,
  I_GLAccountLineItem._FreeDefinedCurrency3 AS _FreeDefinedCurrency3,
  I_GLAccountLineItem._FreeDefinedCurrency4 AS _FreeDefinedCurrency4,
  I_GLAccountLineItem._FreeDefinedCurrency5 AS _FreeDefinedCurrency5,
  I_GLAccountLineItem._FreeDefinedCurrency6 AS _FreeDefinedCurrency6,
  I_GLAccountLineItem._FreeDefinedCurrency7 AS _FreeDefinedCurrency7,
  I_GLAccountLineItem._FreeDefinedCurrency8 AS _FreeDefinedCurrency8,
  I_GLAccountLineItem._FunctionalCurrency AS _FunctionalCurrency,
  I_GLAccountLineItem._Segment AS _Segment,
  I_GLAccountLineItem._ProfitCenter AS _ProfitCenter,
  I_GLAccountLineItem._BusinessArea AS _BusinessArea,
  I_GLAccountLineItem._FunctionalArea AS _FunctionalArea,
  I_GLAccountLineItem._GLAccountInChartOfAccounts AS _GLAccountInChartOfAccounts,
  I_GLAccountLineItem._ChartOfAccounts AS _ChartOfAccounts,
  I_GLAccountLineItem._AccountingDocumentType AS _AccountingDocumentType,
  I_GLAccountLineItem._FinancialAccountType AS _FinancialAccountType,
  I_GLAccountLineItem._DebitCreditCode AS _DebitCreditCode,
  I_GLAccountLineItem._Plant AS _Plant,
  I_GLAccountLineItem._Ledger AS _Ledger,
  I_GLAccountLineItem.BalanceTransactionCurrency AS rtcur,
  I_GLAccountLineItem.TransactionCurrency AS rwcur,
  I_GLAccountLineItem.CompanyCodeCurrency AS rhcur,
  I_GLAccountLineItem.GlobalCurrency AS rkcur,
  FunctionalCurrency,
  I_GLAccountLineItem.FreeDefinedCurrency1 AS rocur,
  I_GLAccountLineItem.FreeDefinedCurrency2 AS rvcur,
  I_GLAccountLineItem.FreeDefinedCurrency3 AS rbcur,
  I_GLAccountLineItem.FreeDefinedCurrency4 AS rccur,
  I_GLAccountLineItem.FreeDefinedCurrency5 AS rdcur,
  I_GLAccountLineItem.FreeDefinedCurrency6 AS recur,
  I_GLAccountLineItem.FreeDefinedCurrency7 AS rfcur,
  I_GLAccountLineItem.FreeDefinedCurrency8 AS rgcur,
  I_GLAccountLineItem.PostingDate AS budat,
  I_GLAccountLineItem.AmountInCompanyCodeCurrency AS hsl,
  I_GLAccountLineItem.AmountInTransactionCurrency AS wsl,
  I_GLAccountLineItem.AmountInBalanceTransacCrcy AS tsl,
  I_GLAccountLineItem.AmountInGlobalCurrency AS ksl,
  I_GLAccountLineItem.AmountInFreeDefinedCurrency1 AS osl,
  I_GLAccountLineItem.AmountInFreeDefinedCurrency2 AS vsl,
  I_GLAccountLineItem.AmountInFreeDefinedCurrency3 AS bsl,
  I_GLAccountLineItem.AmountInFreeDefinedCurrency4 AS csl,
  I_GLAccountLineItem.AmountInFreeDefinedCurrency5 AS dsl,
  I_GLAccountLineItem.AmountInFreeDefinedCurrency6 AS esl,
  I_GLAccountLineItem.AmountInFreeDefinedCurrency7 AS fsl,
  I_GLAccountLineItem.AmountInFreeDefinedCurrency8 AS gsl,
  I_GLAccountLineItem.AmountInFunctionalCurrency AS AmountInFunctionalCurrency,
  I_GLAccountLineItem.OffsettingChartOfAccounts AS OffsettingChartOfAccounts,
  I_GLAccountLineItem.JrnlEntryItemObsoleteReason AS JrnlEntryItemObsoleteReason,
  AccrualObjectType,
  AccrualObjectLogicalSystem,
  AccrualObject,
  AccrualSubobject,
  AccrualItemType,
  AccrualReferenceObject,
  AccrualValueDate,
  CashLedgerCompanyCode,
  CashLedgerAccount,
  FinancialManagementArea,
  FundsCenter,
  FundedProgram,
  Fund,
  GrantID,
  BudgetPeriod,
  PartnerFund,
  PartnerGrant,
  PartnerBudgetPeriod,
  PubSecBudgetAccount,
  PubSecBudgetAccountCoCode,
  PubSecBudgetCnsmpnDate,
  PubSecBudgetCnsmpnFsclPeriod,
  PubSecBudgetCnsmpnFsclYear,
  PubSecBudgetIsRelevant,
  PubSecBudgetCnsmpnType,
  PubSecBudgetCnsmpnAmtType,
  I_GLAccountLineItem.IsStatisticalCostCenter AS IsStatisticalCostCenter,
  I_GLAccountLineItem.IsStatisticalOrder AS IsStatisticalOrder,
  I_GLAccountLineItem.IsStatisticalSalesDocument AS IsStatisticalSalesDocument,
  I_GLAccountLineItem.WBSIsStatisticalWBSElement AS WBSIsStatisticalWBSElement
FROM P_DistinctFiscalYearStartDate
INNER JOIN I_GLAccountLineItem ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_WBSElementByExternalID AS _WBSElementExternalID ON posid_edit = _WBSElementExternalID.WBSElementExternalID  -- association [0..1]
LEFT OUTER JOIN I_WBSElementByExternalID AS _WBSElementExternalIDText ON posid_edit = _WBSElementExternalIDText.WBSElementExternalID  -- association [0..1]
LEFT OUTER JOIN I_ProjectBasicData AS _ProjectBasicData ON ps_prj_pnr = _ProjectBasicData.ProjectInternalID  -- association [0..1]
LEFT OUTER JOIN I_ProjectBasicData AS _ProjectBasicDataText ON ps_prj_pnr = _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_WBSElementBasicData AS _WBSElementBasicData ON ps_psp_pnr = _WBSElementBasicData.WBSElementInternalID  -- association [0..1]
LEFT OUTER JOIN I_WBSElementBasicData AS _WBSElementBasicDataText ON ps_psp_pnr = _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 _InvtrySpclStockWBSElmntBD ON mat_pspnr = _InvtrySpclStockWBSElmntBD.WBSElementInternalID  -- association [0..1]
LEFT OUTER JOIN I_WBSElementByExternalID AS _InvtrySpclStockWBSElmntExtID ON InvtrySpclStockWBSElmntExtID = _InvtrySpclStockWBSElmntExtID.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_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_ProjectByExternalID AS _ProjectExternalID ON pspid_edit = _ProjectExternalID.ProjectExternalID  -- association [0..1]
LEFT OUTER JOIN I_ProjectByExternalID AS _ProjectExternalIDText ON pspid_edit = _ProjectExternalIDText.ProjectExternalID  -- association [0..1]
;