P_GVoAAccountLineItemEnhcd

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_GVoAAccountLineItemEnhcd.
-- 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 P_GVoAAccountLineItemEnhcd AS
SELECT
  _Source.SourceLedger AS SourceLedger,
  _Source.CompanyCode AS CompanyCode,
  _Source.FiscalYear AS FiscalYear,
  _Source.AccountingDocument AS AccountingDocument,
  _Source.LedgerGLLineItem AS LedgerGLLineItem,
  _Source.Ledger AS Ledger,
  cast( '' as fincs_group_jrnl_entry ) AS CnsldtnGroupJrnlEntry,
  cast( '' as fincs_group_jrnl_entry_item ) AS CnsldtnGroupJrnlEntryItem,
  cast( 'M' as docct preserving type ) AS DocumentCategory,
  cast( '' as fc_ryacq ) AS ConsolidationAcquisitionYear,
  cast( '' as rpacq ) AS ConsolidationAcquisitionPeriod,
  cast( '' as fc_coicu ) AS InvesteeConsolidationUnit,
  cast( '' as autom preserving type ) AS ConsolidationPostgItemAutoFlag,
  cast( '' as fincs_coiac ) AS InvestmentActivityType,
  cast( '' as fincs_coinr ) AS InvestmentActivity,
  cast( '' as fc_rtflg ) AS CurrencyConversionsDiffType,
  cast( '' as docct preserving type ) AS RefConsolidationDocumentType,
  cast( 'Y1' as fc_dimen preserving type ) AS ConsolidationDimension,
  cast( '' as fc_docty ) AS ConsolidationDocumentType,
  cast( '' as fc_congr ) AS ConsolidationGroup,
  cast( 'PER' as fincs_period_mode ) AS PeriodMode,
  cast( 'C' as fincs_rrcty preserving type ) AS GLRecordType,
  cast( '' as fc_plevl ) AS PostingLevel,
  cast( '' as gu_recid ) AS ConsolidationRecordNumber,
  cast( '' as fincs_adhocitem ) AS CnsldtnAdhocItem,
  cast( '' as fincs_adhocset ) AS CnsldtnAdhocSet,
  cast( '' as fincs_adhocsetitem ) AS CnsldtnAdhocSetItem,
  cast( '' as fincs_ghgcategory ) AS GHGCategory,
  cast( '' as fincs_ghgscope ) AS GHGScope,
  cast( '' as fincs_ghgscp2calculationmethod ) AS GHGScope2CalculationMethod,
  cast( '' as fincs_ghgscp2cntrctlinstrument ) AS GHGScope2ContractualInstrument,
  cast( '' as fincs_ghgdtaqltycharc ) AS GHGDataQualityCharacteristic,
  cast( '' as fincs_ghgenergyclassification ) AS GHGEnergyClassification,
  cast( '' as fincs_ghgenergymix ) AS GHGEnergyMix,
  cast( '' as fincs_ghgenergysourcingtype ) AS GHGEnergySourcingType,
  cast( '' as fincs_sustmodeoftransport ) AS SustainabilityModeOfTransport,
  _Version.ConsolidationVersion AS ConsolidationVersion,
  cast( case when _PullRequest.CnsldtnPullRequestDateTime is not initial and _Source.CreationDateTime <= _PullRequest.CnsldtnPullRequestDateTime then 'R' else 'U' end as abap.char( 1 ) ) as CnsldtnPullRequestState AS char1asCnsldtnPullRequestState,
  _UnitByTimeVersion.DocumentEntryIsInGroupCurrency AS DocumentEntryIsInGroupCurrency,
  _Source.LedgerFiscalYear AS LedgerFiscalYear,
  _Source.JrnlEntrAltvFYConsecutiveID AS JrnlEntrAltvFYConsecutiveID,
  _Source.ChartOfAccounts AS ChartOfAccounts,
  _Source.ControllingArea AS ControllingArea,
  _Source.FinancialTransactionType AS FinancialTransactionType,
  _Source.GLBusinessTransactionType AS GLBusinessTransactionType,
  _Source.BusinessTransactionCategory AS BusinessTransactionCategory,
  _Source.BusinessTransactionType AS BusinessTransactionType,
  _Source.FinancialClosingStep AS FinancialClosingStep,
  _Source.ControllingBusTransacType AS ControllingBusTransacType,
  _Source.ReferenceDocumentType AS ReferenceDocumentType,
  _Source.LogicalSystem AS LogicalSystem,
  _Source.ReferenceDocumentContext AS ReferenceDocumentContext,
  _Source.ReferenceDocument AS ReferenceDocument,
  _Source.ReferenceDocumentItem AS ReferenceDocumentItem,
  _Source.ReferenceDocumentItemGroup AS ReferenceDocumentItemGroup,
  _Source.TransactionSubitem AS TransactionSubitem,
  _Source.OffsettingLedgerGLLineItem AS OffsettingLedgerGLLineItem,
  _Source.IsReversal AS IsReversal,
  _Source.IsReversed AS IsReversed,
  _Source.ReversalReferenceDocumentCntxt AS ReversalReferenceDocumentCntxt,
  _Source.ReversalReferenceDocument AS ReversalReferenceDocument,
  _Source.ReversalTransactionSubitem AS ReversalTransactionSubitem,
  _Source.IsSettlement AS IsSettlement,
  _Source.IsSettled AS IsSettled,
  _Source.PredecessorReferenceDocType AS PredecessorReferenceDocType,
  _Source.PredecessorReferenceDocCntxt AS PredecessorReferenceDocCntxt,
  _Source.PredecessorReferenceDocument AS PredecessorReferenceDocument,
  _Source.PredecessorReferenceDocItem AS PredecessorReferenceDocItem,
  _Source.PrdcssrJournalEntryCompanyCode AS PrdcssrJournalEntryCompanyCode,
  _Source.PrdcssrJournalEntryFiscalYear AS PrdcssrJournalEntryFiscalYear,
  _Source.PredecessorJournalEntry AS PredecessorJournalEntry,
  _Source.PredecessorJournalEntryItem AS PredecessorJournalEntryItem,
  _Source.SourceReferenceDocumentType AS SourceReferenceDocumentType,
  _Source.SourceLogicalSystem AS SourceLogicalSystem,
  _Source.SourceReferenceDocumentCntxt AS SourceReferenceDocumentCntxt,
  _Source.SourceReferenceDocument AS SourceReferenceDocument,
  _Source.SourceReferenceDocumentItem AS SourceReferenceDocumentItem,
  _Source.SourceReferenceDocSubitem AS SourceReferenceDocSubitem,
  _Source.IsCommitment AS IsCommitment,
  _Source.JrnlEntryItemObsoleteReason AS JrnlEntryItemObsoleteReason,
  _Source.JrnlPeriodEndClosingRunLogUUID AS JrnlPeriodEndClosingRunLogUUID,
  _Source.OrganizationalChange AS OrganizationalChange,
  _Source.AccountingNotificationUUID AS AccountingNotificationUUID,
  _Source.GLAccount AS GLAccount,
  _Source.CostCenter AS CostCenter,
  _Source.ProfitCenter AS ProfitCenter,
  _Source.FunctionalArea AS FunctionalArea,
  _Source.BusinessArea AS BusinessArea,
  _Source.Segment AS Segment,
  _Source.PartnerCostCenter AS PartnerCostCenter,
  _Source.PartnerProfitCenter AS PartnerProfitCenter,
  _Source.PartnerFunctionalArea AS PartnerFunctionalArea,
  _Source.PartnerBusinessArea AS PartnerBusinessArea,
  _Source.PartnerCompany AS PartnerCompany,
  _Source.PartnerSegment AS PartnerSegment,
  _Source.BalanceTransactionCurrency AS BalanceTransactionCurrency,
  _Source.AmountInBalanceTransacCrcy AS AmountInBalanceTransacCrcy,
  _Source.TransactionCurrency AS TransactionCurrency,
  _Source.AmountInTransactionCurrency AS AmountInTransactionCurrency,
  _Source.CompanyCodeCurrency AS CompanyCodeCurrency,
  _Source.AmountInCompanyCodeCurrency AS AmountInCompanyCodeCurrency,
  _Source.GlobalCurrency AS GlobalCurrency,
  _Source.AmountInGlobalCurrency AS AmountInGlobalCurrency,
  _Source.FunctionalCurrency AS FunctionalCurrency,
  _Source.AmountInFunctionalCurrency AS AmountInFunctionalCurrency,
  _Source.FreeDefinedCurrency1 AS FreeDefinedCurrency1,
  _Source.AmountInFreeDefinedCurrency1 AS AmountInFreeDefinedCurrency1,
  _Source.FreeDefinedCurrency2 AS FreeDefinedCurrency2,
  _Source.AmountInFreeDefinedCurrency2 AS AmountInFreeDefinedCurrency2,
  _Source.FreeDefinedCurrency3 AS FreeDefinedCurrency3,
  _Source.AmountInFreeDefinedCurrency3 AS AmountInFreeDefinedCurrency3,
  _Source.FreeDefinedCurrency4 AS FreeDefinedCurrency4,
  _Source.AmountInFreeDefinedCurrency4 AS AmountInFreeDefinedCurrency4,
  _Source.FreeDefinedCurrency5 AS FreeDefinedCurrency5,
  _Source.AmountInFreeDefinedCurrency5 AS AmountInFreeDefinedCurrency5,
  _Source.FreeDefinedCurrency6 AS FreeDefinedCurrency6,
  _Source.AmountInFreeDefinedCurrency6 AS AmountInFreeDefinedCurrency6,
  _Source.FreeDefinedCurrency7 AS FreeDefinedCurrency7,
  _Source.AmountInFreeDefinedCurrency7 AS AmountInFreeDefinedCurrency7,
  _Source.FreeDefinedCurrency8 AS FreeDefinedCurrency8,
  _Source.AmountInFreeDefinedCurrency8 AS AmountInFreeDefinedCurrency8,
  _Source.FixedAmountInGlobalCrcy AS FixedAmountInGlobalCrcy,
  _Source.GrpValnFixedAmtInGlobCrcy AS GrpValnFixedAmtInGlobCrcy,
  _Source.PrftCtrValnFxdAmtInGlobCrcy AS PrftCtrValnFxdAmtInGlobCrcy,
  _Source.TotalPriceVarcInGlobalCrcy AS TotalPriceVarcInGlobalCrcy,
  _Source.GrpValnTotPrcVarcInGlobCrcy AS GrpValnTotPrcVarcInGlobCrcy,
  _Source.PrftCtrValnTotPrcVarcInGlbCrcy AS PrftCtrValnTotPrcVarcInGlbCrcy,
  _Source.FixedPriceVarcInGlobalCrcy AS FixedPriceVarcInGlobalCrcy,
  _Source.GrpValnFixedPrcVarcInGlobCrcy AS GrpValnFixedPrcVarcInGlobCrcy,
  _Source.PrftCtrValnFxdPrcVarcInGlbCrcy AS PrftCtrValnFxdPrcVarcInGlbCrcy,
  _Source.FixedAmountInCoCodeCrcy AS FixedAmountInCoCodeCrcy,
  _Source.FixedAmountInTransCrcy AS FixedAmountInTransCrcy,
  _Source.ControllingObjectCurrency AS ControllingObjectCurrency,
  _Source.AmountInObjectCurrency AS AmountInObjectCurrency,
  _Source.GrantCurrency AS GrantCurrency,
  _Source.AmountInGrantCurrency AS AmountInGrantCurrency,
  _Source.BaseUnit AS BaseUnit,
  _Source.Quantity AS Quantity,
  _Source.FixedQuantity AS FixedQuantity,
  _Source.CostSourceUnit AS CostSourceUnit,
  _Source.ValuationQuantity AS ValuationQuantity,
  _Source.ValuationFixedQuantity AS ValuationFixedQuantity,
  _Source.ReferenceQuantityUnit AS ReferenceQuantityUnit,
  _Source.ReferenceQuantity AS ReferenceQuantity,
  _Source.AdditionalQuantity1Unit AS AdditionalQuantity1Unit,
  _Source.AdditionalQuantity1 AS AdditionalQuantity1,
  _Source.AdditionalQuantity2Unit AS AdditionalQuantity2Unit,
  _Source.AdditionalQuantity2 AS AdditionalQuantity2,
  _Source.AdditionalQuantity3Unit AS AdditionalQuantity3Unit,
  _Source.AdditionalQuantity3 AS AdditionalQuantity3,
  _Source.DebitCreditCode AS DebitCreditCode,
  _Source.FiscalPeriod AS FiscalPeriod,
  _Source.FiscalYearVariant AS FiscalYearVariant,
  _Source.FiscalYearPeriod AS FiscalYearPeriod,
  _Source.PostingDate AS PostingDate,
  _Source.DocumentDate AS DocumentDate,
  _Source.AccountingDocumentType AS AccountingDocumentType,
  _Source.AssignmentReference AS AssignmentReference,
  _Source.AccountingDocumentCategory AS AccountingDocumentCategory,
  _Source.JournalEntryItemCategory AS JournalEntryItemCategory,
  _Source.PostingKey AS PostingKey,
  _Source.TransactionTypeDetermination AS TransactionTypeDetermination,
  _Source.SubLedgerAcctLineItemType AS SubLedgerAcctLineItemType,
  _Source.AccountingDocCreatedByUser AS AccountingDocCreatedByUser,
  _Source.LastChangeDateTime AS LastChangeDateTime,
  _Source.CreationDateTime AS CreationDateTime,
  _Source.CreationDate AS CreationDate,
  _Source.EliminationProfitCenter AS EliminationProfitCenter,
  _Source.OriginObjectType AS OriginObjectType,
  _Source.GLAccountType AS GLAccountType,
  _Source.AlternativeGLAccount AS AlternativeGLAccount,
  _Source.CountryChartOfAccounts AS CountryChartOfAccounts,
  _Source.ItemIsSplit AS ItemIsSplit,
  _Source.ConsolidationUnit AS ConsolidationUnit,
  _Source.PartnerConsolidationUnit AS PartnerConsolidationUnit,
  _Source.Company AS Company,
  _Source.ConsolidationChartOfAccounts AS ConsolidationChartOfAccounts,
  _Source.CnsldtnFinancialStatementItem AS CnsldtnFinancialStatementItem,
  _Source.CnsldtnSubitemCategory AS CnsldtnSubitemCategory,
  _Source.CnsldtnSubitem AS CnsldtnSubitem,
  _Source.InvoiceReference AS InvoiceReference,
  _Source.InvoiceReferenceFiscalYear AS InvoiceReferenceFiscalYear,
  _Source.FollowOnDocumentType AS FollowOnDocumentType,
  _Source.InvoiceItemReference AS InvoiceItemReference,
  _Source.ReferencePurchaseOrderCategory AS ReferencePurchaseOrderCategory,
  _Source.PurchasingDocument AS PurchasingDocument,
  _Source.PurchasingDocumentItem AS PurchasingDocumentItem,
  _Source.AccountAssignmentNumber AS AccountAssignmentNumber,
  _Source.DocumentItemText AS DocumentItemText,
  _Source.SalesDocument AS SalesDocument,
  _Source.SalesDocumentItem AS SalesDocumentItem,
  _Source.Material AS Material,
  _Source.Product AS Product,
  _Source.Plant AS Plant,
  _Source.Supplier AS Supplier,
  _Source.Customer AS Customer,
  _Source.ServicesRenderedDate AS ServicesRenderedDate,
  _Source.ConditionContract AS ConditionContract,
  _Source.FinancialAccountType AS FinancialAccountType,
  _Source.SpecialGLCode AS SpecialGLCode,
  _Source.TaxCode AS TaxCode,
  _Source.TaxCountry AS TaxCountry,
  _Source.HouseBank AS HouseBank,
  _Source.HouseBankAccount AS HouseBankAccount,
  _Source.IsOpenItemManaged AS IsOpenItemManaged,
  _Source.ClearingDate AS ClearingDate,
  _Source.ClearingJournalEntryFiscalYear AS ClearingJournalEntryFiscalYear,
  _Source.ClearingJournalEntry AS ClearingJournalEntry,
  _Source.ValueDate AS ValueDate,
  _Source.GeneralLedgerAgingScope AS GeneralLedgerAgingScope,
  _Source.GeneralLedgerAgingIncrement AS GeneralLedgerAgingIncrement,
  _Source.AssetDepreciationArea AS AssetDepreciationArea,
  _Source.MasterFixedAsset AS MasterFixedAsset,
  _Source.FixedAsset AS FixedAsset,
  _Source.AssetValueDate AS AssetValueDate,
  _Source.AssetTransactionType AS AssetTransactionType,
  _Source.AssetAcctTransClassfctn AS AssetAcctTransClassfctn,
  _Source.DepreciationFiscalPeriod AS DepreciationFiscalPeriod,
  _Source.GroupMasterFixedAsset AS GroupMasterFixedAsset,
  _Source.GroupFixedAsset AS GroupFixedAsset,
  _Source.AssetClass AS AssetClass,
  _Source.PartnerMasterFixedAsset AS PartnerMasterFixedAsset,
  _Source.PartnerFixedAsset AS PartnerFixedAsset,
  _Source.CostEstimate AS CostEstimate,
  _Source.InvtrySpecialStockValnType_2 AS InvtrySpecialStockValnType_2,
  _Source.IsSupplierStockValuation AS IsSupplierStockValuation,
  _Source.InventorySpecialStockType AS InventorySpecialStockType,
  _Source.InventorySpclStkSalesDocument AS InventorySpclStkSalesDocument,
  _Source.InventorySpclStkSalesDocItm AS InventorySpclStkSalesDocItm,
  _Source.InvtrySpclStockWBSElmntIntID AS InvtrySpclStockWBSElmntIntID,
  _Source.InventorySpecialStockSupplier AS InventorySpecialStockSupplier,
  _Source.InventoryValuationType AS InventoryValuationType,
  _Source.ValuationArea AS ValuationArea,
  _Source.MaterialLedgerProcessType AS MaterialLedgerProcessType,
  _Source.MaterialLedgerCategory AS MaterialLedgerCategory,
  _Source.SlsPriceAmountInCoCodeCrcy AS SlsPriceAmountInCoCodeCrcy,
  _Source.ProductPriceControl AS ProductPriceControl,
  _Source.SenderCompanyCode AS SenderCompanyCode,
  _Source.SenderGLAccount AS SenderGLAccount,
  _Source.SenderAccountAssignment AS SenderAccountAssignment,
  _Source.SenderAccountAssignmentType AS SenderAccountAssignmentType,
  _Source.ControllingObject AS ControllingObject,
  _Source.CostOriginGroup AS CostOriginGroup,
  _Source.OriginSenderObject AS OriginSenderObject,
  _Source.ControllingDebitCreditCode AS ControllingDebitCreditCode,
  _Source.ControllingObjectDebitType AS ControllingObjectDebitType,
  _Source.QuantityIsIncomplete AS QuantityIsIncomplete,
  _Source.OffsettingAccount AS OffsettingAccount,
  _Source.OffsettingAccountType AS OffsettingAccountType,
  _Source.OffsettingChartOfAccounts AS OffsettingChartOfAccounts,
  _Source.LineItemIsCompleted AS LineItemIsCompleted,
  _Source.PersonnelNumber AS PersonnelNumber,
  _Source.ControllingObjectClass AS ControllingObjectClass,
  _Source.PartnerCompanyCode AS PartnerCompanyCode,
  _Source.PartnerControllingObjectClass AS PartnerControllingObjectClass,
  _Source.OriginCostCenter AS OriginCostCenter,
  _Source.OriginProfitCenter AS OriginProfitCenter,
  _Source.OriginCostCtrActivityType AS OriginCostCtrActivityType,
  _Source.OriginProduct AS OriginProduct,
  _Source.VarianceOriginGLAccount AS VarianceOriginGLAccount,
  _Source.AccountAssignment AS AccountAssignment,
  _Source.AccountAssignmentType AS AccountAssignmentType,
  _Source.CostCtrActivityType AS CostCtrActivityType,
  _Source.OrderID AS OrderID,
  _Source.OrderCategory AS OrderCategory,
  _Source.WBSElementInternalID AS WBSElementInternalID,
  _Source.PartnerWBSElementInternalID AS PartnerWBSElementInternalID,
  _Source.ProjectInternalID AS ProjectInternalID,
  _Source.PartnerProjectInternalID AS PartnerProjectInternalID,
  cast(_Source.Project as ps_pspid_edit preserving type) AS Project,
  _Source.OperatingConcern AS OperatingConcern,
  _Source.ProjectNetwork AS ProjectNetwork,
  _Source.RelatedNetworkActivity AS RelatedNetworkActivity,
  _Source.BusinessProcess AS BusinessProcess,
  _Source.CostObject AS CostObject,
  _Source.BillableControl AS BillableControl,
  _Source.CostAnalysisResource AS CostAnalysisResource,
  _Source.CustomerServiceNotification AS CustomerServiceNotification,
  _Source.ServiceDocumentType AS ServiceDocumentType,
  _Source.ServiceDocument AS ServiceDocument,
  _Source.ServiceDocumentItem AS ServiceDocumentItem,
  _Source.PartnerServiceDocumentType AS PartnerServiceDocumentType,
  _Source.PartnerServiceDocument AS PartnerServiceDocument,
  _Source.PartnerServiceDocumentItem AS PartnerServiceDocumentItem,
  _Source.ServiceContractType AS ServiceContractType,
  _Source.ServiceContract AS ServiceContract,
  _Source.ServiceContractItem AS ServiceContractItem,
  _Source.BusinessSolutionOrder AS BusinessSolutionOrder,
  _Source.BusinessSolutionOrderItem AS BusinessSolutionOrderItem,
  _Source.ProviderContract AS ProviderContract,
  _Source.ProviderContractItem AS ProviderContractItem,
  _Source.RevenueAccountingContract AS RevenueAccountingContract,
  _Source.PerformanceObligation AS PerformanceObligation,
  _Source.TimeSheetOvertimeCategory AS TimeSheetOvertimeCategory,
  _Source.PartnerAccountAssignment AS PartnerAccountAssignment,
  _Source.PartnerAccountAssignmentType AS PartnerAccountAssignmentType,
  _Source.WorkPackage AS WorkPackage,
  _Source.WorkItem AS WorkItem,
  _Source.PartnerCostCtrActivityType AS PartnerCostCtrActivityType,
  _Source.PartnerOrder AS PartnerOrder,
  _Source.PartnerOrder_2 AS PartnerOrder_2,
  _Source.PartnerOrderCategory AS PartnerOrderCategory,
  _Source.PartnerSalesDocument AS PartnerSalesDocument,
  _Source.PartnerSalesDocumentItem AS PartnerSalesDocumentItem,
  _Source.PartnerProjectNetwork AS PartnerProjectNetwork,
  _Source.PartnerProjectNetworkActivity AS PartnerProjectNetworkActivity,
  _Source.PartnerBusinessProcess AS PartnerBusinessProcess,
  _Source.PartnerCostObject AS PartnerCostObject,
  _Source.ControllingDocumentItem AS ControllingDocumentItem,
  _Source.BillingDocumentType AS BillingDocumentType,
  _Source.SalesOrganization AS SalesOrganization,
  _Source.DistributionChannel AS DistributionChannel,
  _Source.OrganizationDivision AS OrganizationDivision,
  _Source.SoldMaterial AS SoldMaterial,
  _Source.SoldProduct AS SoldProduct,
  _Source.MaterialGroup AS MaterialGroup,
  _Source.SoldProductGroup AS SoldProductGroup,
  _Source.CustomerGroup AS CustomerGroup,
  _Source.CustomerSupplierCountry AS CustomerSupplierCountry,
  _Source.CustomerSupplierIndustry AS CustomerSupplierIndustry,
  _Source.SalesDistrict AS SalesDistrict,
  _Source.BillToParty AS BillToParty,
  _Source.ShipToParty AS ShipToParty,
  _Source.CustomerSupplierCorporateGroup AS CustomerSupplierCorporateGroup,
  _Source.CashLedgerCompanyCode AS CashLedgerCompanyCode,
  _Source.CashLedgerAccount AS CashLedgerAccount,
  _Source.FinancialManagementArea AS FinancialManagementArea,
  _Source.CommitmentItem AS CommitmentItem,
  _Source.FundsCenter AS FundsCenter,
  _Source.FundedProgram AS FundedProgram,
  _Source.Fund AS Fund,
  _Source.GrantID AS GrantID,
  _Source.BudgetPeriod AS BudgetPeriod,
  _Source.PartnerFund AS PartnerFund,
  _Source.PartnerGrant AS PartnerGrant,
  _Source.PartnerBudgetPeriod AS PartnerBudgetPeriod,
  _Source.PubSecBudgetAccount AS PubSecBudgetAccount,
  _Source.PubSecBudgetAccountCoCode AS PubSecBudgetAccountCoCode,
  _Source.PubSecBudgetCnsmpnDate AS PubSecBudgetCnsmpnDate,
  _Source.PubSecBudgetCnsmpnFsclPeriod AS PubSecBudgetCnsmpnFsclPeriod,
  _Source.PubSecBudgetCnsmpnFsclYear AS PubSecBudgetCnsmpnFsclYear,
  _Source.PubSecBudgetIsRelevant AS PubSecBudgetIsRelevant,
  _Source.PubSecBudgetCnsmpnType AS PubSecBudgetCnsmpnType,
  _Source.PubSecBudgetCnsmpnAmtType AS PubSecBudgetCnsmpnAmtType,
  _Source.SponsoredProgram AS SponsoredProgram,
  _Source.SponsoredClass AS SponsoredClass,
  _Source.GteeMBudgetValidityNumber AS GteeMBudgetValidityNumber,
  _Source.EarmarkedFundsDocument AS EarmarkedFundsDocument,
  _Source.EarmarkedFundsDocumentItem AS EarmarkedFundsDocumentItem,
  _Source.FinancialServicesProductGroup AS FinancialServicesProductGroup,
  _Source.FinancialServicesBranch AS FinancialServicesBranch,
  _Source.FinancialDataSource AS FinancialDataSource,
  _Source.JointVenture AS JointVenture,
  _Source.JointVentureEquityGroup AS JointVentureEquityGroup,
  _Source.JointVentureCostRecoveryCode AS JointVentureCostRecoveryCode,
  _Source.JointVenturePartner AS JointVenturePartner,
  _Source.JointVentureBillingType AS JointVentureBillingType,
  _Source.JointVentureEquityType AS JointVentureEquityType,
  _Source.JointVentureProductionDate AS JointVentureProductionDate,
  _Source.JointVentureBillingDate AS JointVentureBillingDate,
  _Source.JointVentureOperationalDate AS JointVentureOperationalDate,
  _Source.CutbackRun AS CutbackRun,
  _Source.JointVentureAccountingActivity AS JointVentureAccountingActivity,
  _Source.PartnerVenture AS PartnerVenture,
  _Source.PartnerEquityGroup AS PartnerEquityGroup,
  _Source.SenderCostRecoveryCode AS SenderCostRecoveryCode,
  _Source.CutbackAccount AS CutbackAccount,
  _Source.CutbackCostObject AS CutbackCostObject,
  _Source.REBusinessEntity AS REBusinessEntity,
  _Source.RealEstateBuilding AS RealEstateBuilding,
  _Source.RealEstateProperty AS RealEstateProperty,
  _Source.RERentalObject AS RERentalObject,
  _Source.RealEstateContract AS RealEstateContract,
  _Source.REServiceChargeKey AS REServiceChargeKey,
  _Source.RESettlementUnitID AS RESettlementUnitID,
  _Source.SettlementReferenceDate AS SettlementReferenceDate,
  _Source.REPartnerBusinessEntity AS REPartnerBusinessEntity,
  _Source.RealEstatePartnerBuilding AS RealEstatePartnerBuilding,
  _Source.RealEstatePartnerProperty AS RealEstatePartnerProperty,
  _Source.REPartnerRentalObject AS REPartnerRentalObject,
  _Source.RealEstatePartnerContract AS RealEstatePartnerContract,
  _Source.REPartnerServiceChargeKey AS REPartnerServiceChargeKey,
  _Source.REPartnerSettlementUnitID AS REPartnerSettlementUnitID,
  _Source.PartnerSettlementReferenceDate AS PartnerSettlementReferenceDate,
  _Source.AccrualObjectType AS AccrualObjectType,
  _Source.AccrualObjectLogicalSystem AS AccrualObjectLogicalSystem,
  _Source.AccrualObject AS AccrualObject,
  _Source.AccrualSubobject AS AccrualSubobject,
  _Source.AccrualItemType AS AccrualItemType,
  _Source.AccrualReferenceObject AS AccrualReferenceObject,
  _Source.AccrualValueDate AS AccrualValueDate,
  _Source.FinancialValuationObjectType AS FinancialValuationObjectType,
  _Source.FinancialValuationObject AS FinancialValuationObject,
  _Source.FinancialValuationSubobject AS FinancialValuationSubobject,
  _Source.NetDueDate AS NetDueDate,
  _Source.CreditRiskClass AS CreditRiskClass,
  _Source.WorkCenterInternalID AS WorkCenterInternalID,
  _Source.OrderOperation AS OrderOperation,
  _Source.OrderItem AS OrderItem,
  _Source.PartnerOrderItem AS PartnerOrderItem,
  _Source.OrderSuboperation AS OrderSuboperation,
  _Source.Equipment AS Equipment,
  _Source.FunctionalLocation AS FunctionalLocation,
  _Source.Assembly AS Assembly,
  _Source.MaintenanceActivityType AS MaintenanceActivityType,
  _Source.MaintenanceOrderPlanningCode AS MaintenanceOrderPlanningCode,
  _Source.MaintPriorityType AS MaintPriorityType,
  _Source.MaintPriority AS MaintPriority,
  _Source.SuperiorOrder AS SuperiorOrder,
  _Source.ProductGroup AS ProductGroup,
  _Source.MaintenanceOrderIsPlanned AS MaintenanceOrderIsPlanned,
  _Source.JrnlEntryItemMigrationSource AS JrnlEntryItemMigrationSource,
  _Source.DebitAmountInCoCodeCrcy AS DebitAmountInCoCodeCrcy,
  _Source.CreditAmountInCoCodeCrcy AS CreditAmountInCoCodeCrcy,
  _Source.DebitAmountInTransCrcy AS DebitAmountInTransCrcy,
  _Source.CreditAmountInTransCrcy AS CreditAmountInTransCrcy,
  _Source.DebitAmountInBalanceTransCrcy AS DebitAmountInBalanceTransCrcy,
  _Source.CreditAmountInBalanceTransCrcy AS CreditAmountInBalanceTransCrcy,
  _Source.DebitAmountInGlobalCrcy AS DebitAmountInGlobalCrcy,
  _Source.CreditAmountInGlobalCrcy AS CreditAmountInGlobalCrcy,
  _Source.DebitAmountInFunctionalCrcy AS DebitAmountInFunctionalCrcy,
  _Source.CreditAmountInFunctionalCrcy AS CreditAmountInFunctionalCrcy,
  _Source.IsStatisticalOrder AS IsStatisticalOrder,
  _Source.IsStatisticalCostCenter AS IsStatisticalCostCenter,
  _Source.IsStatisticalSalesDocument AS IsStatisticalSalesDocument,
  _Source.WBSIsStatisticalWBSElement AS WBSIsStatisticalWBSElement,
  _Source.CalendarYear AS CalendarYear,
  _Source.CalendarQuarter AS CalendarQuarter,
  _Source.CalendarYearQuarter AS CalendarYearQuarter,
  _Source.CalendarMonth AS CalendarMonth,
  _Source.CalendarYearMonth AS CalendarYearMonth,
  _Source.CalendarWeek AS CalendarWeek,
  _Source.CalendarYearWeek AS CalendarYearWeek,
  _Source._CashLedgerCompanyCode AS _CashLedgerCompanyCode,
  _Source._CashLedgerAccount AS _CashLedgerAccount,
  _Source._FinancialManagementArea AS _FinancialManagementArea,
  _Source._FundsCenter AS _FundsCenter,
  _Source._FundedProgram AS _FundedProgram,
  _Source._Fund AS _Fund,
  _Source._Grant AS _Grant,
  _Source._BudgetPeriod AS _BudgetPeriod,
  _Source._PartnerFund AS _PartnerFund,
  _Source._PartnerGrant AS _PartnerGrant,
  _Source._PartnerBudgetPeriod AS _PartnerBudgetPeriod,
  _Source._PubSecBudgetAccountCoCode AS _PubSecBudgetAccountCoCode,
  _Source._PubSecBudgetAccount AS _PubSecBudgetAccount,
  _Source._PubSecBudgetCnsmpnDate AS _PubSecBudgetCnsmpnDate,
  _Source._PubSecBudgetCnsmpnFsclPeriod AS _PubSecBudgetCnsmpnFsclPeriod,
  _Source._PubSecBudgetCnsmpnFsclYear AS _PubSecBudgetCnsmpnFsclYear,
  _Source._PubSecBudgetCnsmpnType AS _PubSecBudgetCnsmpnType,
  _Source._PubSecBudgetCnsmpnAmtType AS _PubSecBudgetCnsmpnAmtType,
  _Source._SponsoredProgram AS _SponsoredProgram,
  _Source._SponsoredClass AS _SponsoredClass,
  _Source._ConsolidationUnit AS _ConsolidationUnit,
  _Source._PartnerConsolidationUnit AS _PartnerConsolidationUnit,
  _Source._Company AS _Company,
  _Source._ConsolidationChartOfAccounts AS _ConsolidationChartOfAccounts,
  _Source._CnsldtnFinancialStatementItem AS _CnsldtnFinancialStatementItem,
  _Source._CnsldtnSubitemCategory AS _CnsldtnSubitemCategory,
  _Source._CnsldtnSubitem AS _CnsldtnSubitem,
  _Source._ProviderContract AS _ProviderContract,
  _Source._ProviderContractItem AS _ProviderContractItem
FROM I_GLAccountLineItem AS _Source
INNER JOIN I_CnsldtnUnitByTimeVersion AS _UnitByTimeVersion ON /* join condition not captured in parsed metadata */
INNER JOIN I_CnsldtnVersion AS _Version ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN E_JournalEntryItem AS _Extension ON _Source.SourceLedger = _Extension.SourceLedger AND _Source.CompanyCode = _Extension.CompanyCode AND _Source.FiscalYear = _Extension.FiscalYear AND _Source.AccountingDocument = _Extension.AccountingDocument AND _Source.LedgerGLLineItem = _Extension.LedgerGLLineItem  -- association [1..1]
;