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,
  _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
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]
;