P_FIVALUATIONRESULTLISTORI

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_FIVALUATIONRESULTLISTORI.
-- 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_FIVALUATIONRESULTLISTORI AS
SELECT
  result_list.JrnlPerdEndClsgRunResultUUID AS JrnlPerdEndClsgRunResultUUID,
  acdoca.Ledger AS Ledger,
  acdoca.CompanyCode AS CompanyCode,
  acdoca.FiscalYear AS FiscalYear,
  acdoca.AccountingDocument AS AccountingDocument,
  acdoca.LedgerGLLineItem AS LedgerGLLineItem,
  acdoca.IsReversed AS IsReversed,
  result_list.JrnlPeriodEndClosingRunLogUUID AS JrnlPeriodEndClosingRunLogUUID,
  acdoca.BalanceTransactionCurrency AS BalanceTransactionCurrency,
  acdoca.AmountInBalanceTransacCrcy AS AmountInBalanceTransacCrcy,
  acdoca.CompanyCodeCurrency AS CompanyCodeCurrency,
  acdoca.AmountInCompanyCodeCurrency AS AmountInCompanyCodeCurrency,
  acdoca.GlobalCurrency AS GlobalCurrency,
  acdoca.AmountInGlobalCurrency AS AmountInGlobalCurrency,
  acdoca.FreeDefinedCurrency1 AS FreeDefinedCurrency1,
  acdoca.AmountInFreeDefinedCurrency1 AS AmountInFreeDefinedCurrency1,
  acdoca.FreeDefinedCurrency2 AS FreeDefinedCurrency2,
  acdoca.AmountInFreeDefinedCurrency2 AS AmountInFreeDefinedCurrency2,
  acdoca.FreeDefinedCurrency3 AS FreeDefinedCurrency3,
  acdoca.AmountInFreeDefinedCurrency3 AS AmountInFreeDefinedCurrency3,
  acdoca.FreeDefinedCurrency4 AS FreeDefinedCurrency4,
  acdoca.AmountInFreeDefinedCurrency4 AS AmountInFreeDefinedCurrency4,
  acdoca.FreeDefinedCurrency5 AS FreeDefinedCurrency5,
  acdoca.AmountInFreeDefinedCurrency5 AS AmountInFreeDefinedCurrency5,
  acdoca.FreeDefinedCurrency6 AS FreeDefinedCurrency6,
  acdoca.AmountInFreeDefinedCurrency6 AS AmountInFreeDefinedCurrency6,
  acdoca.FreeDefinedCurrency7 AS FreeDefinedCurrency7,
  acdoca.AmountInFreeDefinedCurrency7 AS AmountInFreeDefinedCurrency7,
  acdoca.FreeDefinedCurrency8 AS FreeDefinedCurrency8,
  acdoca.AmountInFreeDefinedCurrency8 AS AmountInFreeDefinedCurrency8,
  acdoca.FinancialTransactionType AS FinancialTransactionType,
  acdoca.ProfitCenter AS ProfitCenter,
  acdoca.SalesDocument AS SalesOrder,
  acdoca.SalesDocumentItem AS SalesOrderItem,
  acdoca.Supplier AS Supplier,
  acdoca.Customer AS Customer,
  acdoca.HouseBank AS HouseBank,
  acdoca.HouseBankAccount AS HouseBankAccount,
  acdoca.CostCtrActivityType AS CostCtrActivityType,
  acdoca.OrderID AS OrderID,
  acdoca.WBSElementInternalID AS WBSElementInternalID,
  acdoca.ProjectNetwork AS ProjectNetwork,
  acdoca.RelatedNetworkActivity AS RelatedNetworkActivity,
  acdoca.BusinessProcess AS BusinessProcess,
  acdoca.CostCenter AS CostCenter,
  acdoca.FunctionalArea AS FunctionalArea,
  acdoca.BusinessArea AS BusinessArea,
  acdoca.ControllingArea AS ControllingArea,
  acdoca.Segment AS Segment,
  acdoca.PartnerCostCenter AS PartnerCostCenter,
  acdoca.PartnerProfitCenter AS PartnerProfitCenter,
  acdoca.PartnerFunctionalArea AS PartnerFunctionalArea,
  acdoca.PartnerBusinessArea AS PartnerBusinessArea,
  acdoca.PartnerCompany AS PartnerCompany,
  acdoca.CostObject AS CostObject,
  acdoca.PartnerSegment AS PartnerSegment,
  acdoca.JointVenture AS JointVenture,
  acdoca.JointVentureEquityGroup AS JointVentureEquityGroup,
  acdoca.JointVentureCostRecoveryCode AS JointVentureCostRecoveryCode,
  acdoca.JointVenturePartner AS JointVenturePartner,
  acdoca.PartnerVenture AS PartnerVenture,
  acdoca.FinancialValuationObjectType AS FinancialValuationObjectType,
  acdoca.FinancialValuationObject AS FinancialValuationObject,
  acdoca.FinancialValuationSubobject AS FinancialValuationSubobject,
  acdoca.REBusinessEntity AS REBusinessEntity,
  acdoca.RealEstateBuilding AS RealEstateBuilding,
  acdoca.RealEstateProperty AS RealEstateProperty,
  acdoca.GLAccount AS GLAccount,
  acdoca.OffsettingAccount AS OffsettingAccount,
  acdoca.SubLedgerAcctLineItemType AS SubLedgerAcctLineItemType,
  acdoca.ChartOfAccounts AS ChartOfAccounts,
  acdoca.PostingDate AS PostingDate,
  acdoca.AccountingDocumentCategory AS AccountingDocumentCategory,
  acdoca.IsOpenItemManaged AS IsOpenItemManaged,
  acdoca.ClearingDate AS ClearingDate,
  acdoca.ClearingAccountingDocument AS ClearingAccountingDocument,
  acdoca.ClearingDocFiscalYear AS ClearingDocFiscalYear,
  acdoca.FiscalPeriod AS FiscalPeriod,
  acdoca.PrdcssrJournalEntryCompanyCode AS PrdcssrJournalEntryCompanyCode,
  acdoca.PrdcssrJournalEntryFiscalYear AS PrdcssrJournalEntryFiscalYear,
  acdoca.PredecessorJournalEntry AS PredecessorJournalEntry,
  acdoca.PredecessorJournalEntryItem AS PredecessorJournalEntryItem,
  acdoca.InvoiceItemReference AS InvoiceItemReference,
  acdoca.InvoiceReference AS InvoiceReference,
  acdoca.InvoiceReferenceFiscalYear AS InvoiceReferenceFiscalYear,
  acdoca.FollowOnDocumentType AS FollowOnDocumentType,
  acdoca.AccountingDocumentItem AS AccountingDocumentItem,
  acdoca.BusinessTransactionType AS BusinessTransactionType,
  acdoca.FinancialAccountType AS FinancialAccountType,
  acdoca.GeneralLedgerAgingScope AS GeneralLedgerAgingScope,
  acdoca.GeneralLedgerAgingIncrement AS PostedAgingIncrement,
  result_list.FreeDefinedCurrency1 AS FinClsgRunRsltFDCrcy1,
  result_list.FinClsgRunRsltAmtInFDCrcy1 AS FinClsgRunRsltAmtInFDCrcy1,
  result_list.FreeDefinedCurrency2 AS FinClsgRunRsltFDCrcy2,
  result_list.FinClsgRunRsltAmtInFDCrcy2 AS FinClsgRunRsltAmtInFDCrcy2,
  result_list.FreeDefinedCurrency3 AS FinClsgRunRsltFDCrcy3,
  result_list.FinClsgRunRsltAmtInFDCrcy3 AS FinClsgRunRsltAmtInFDCrcy3,
  result_list.FreeDefinedCurrency4 AS FinClsgRunRsltFDCrcy4,
  result_list.FinClsgRunRsltAmtInFDCrcy4 AS FinClsgRunRsltAmtInFDCrcy4,
  result_list.FreeDefinedCurrency5 AS FinClsgRunRsltFDCrcy5,
  result_list.FinClsgRunRsltAmtInFDCrcy5 AS FinClsgRunRsltAmtInFDCrcy5,
  result_list.FreeDefinedCurrency6 AS FinClsgRunRsltFDCrcy6,
  result_list.FinClsgRunRsltAmtInFDCrcy6 AS FinClsgRunRsltAmtInFDCrcy6,
  result_list.FreeDefinedCurrency7 AS FinClsgRunRsltFDCrcy7,
  result_list.FinClsgRunRsltAmtInFDCrcy7 AS FinClsgRunRsltAmtInFDCrcy7,
  result_list.FreeDefinedCurrency8 AS FinClsgRunRsltFDCrcy8,
  result_list.FinClsgRunRsltAmtInFDCrcy8 AS FinClsgRunRsltAmtInFDCrcy8,
  result_list.ExchangeRate AS ExchangeRate,
  result_list.FinClosingRunIsTestExecution AS FinClosingRunIsTestExecution,
  result_list.FinancialClosingLineItemType AS FinancialClosingLineItemType,
  result_list.FinancialClosingLineItemStatus AS FinancialClosingLineItemStatus,
  result_list.FinClosingEntryCalculationType AS FinClosingEntryCalculationType,
  result_list.CreditRiskClass AS CreditRiskClass,
  result_list.GeneralLedgerAgingIncrement AS GeneralLedgerAgingIncrement,
  result_list.NetDueDate AS NetDueDate,
  result_list.OldestOpenItemNetDueDate AS OldestOpenItemNetDueDate,
  result_list.ExpectedCreditLossPercent AS ExpectedCreditLossPercent,
  result_list.FinancialClosingGroupingRule AS FinancialClosingGroupingRule,
  result_list.FinClosingGroupingRuleStep AS FinClosingGroupingRuleStep,
  result_list.FinancialClosingGrouping AS FinancialClosingGrouping,
  result_list.FinClosingLineItemDetailStatus AS FinClosingLineItemDetailStatus,
  result_list.InterestCalculationCode AS InterestCalculationCode,
  result_list.DiscountingAnnualInterestRate AS DiscountingAnnualInterestRate,
  result_list.DiscgFiscalPeriodInterestRate AS DiscgFiscalPeriodInterestRate,
  result_list.DiscgDurationInFiscalPeriods AS DiscgDurationInFiscalPeriods,
  result_list.NrOfDiscountedFiscalPeriods AS NrOfDiscountedFiscalPeriods,
  result_list.LongTrmAstLbltyDiscountFactor AS LongTrmAstLbltyDiscountFactor,
  result_list.FinancialClosingValuationRule AS FinancialClosingValuationRule,
  result_list.FinClosingValuationRuleStep AS FinClosingValuationRuleStep,
  result_list.PrdcssrPerdEndClsgRunRsltUUID AS PrdcssrPerdEndClsgRunRsltUUID
FROM I_GLAccountLineItem AS acdoca
INNER JOIN I_JrnlPerdEndClsgRunLogResult AS result_list ON /* join condition not captured in parsed metadata */
;