P_FIVALUATIONRESULTLISTTMP

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_FIVALUATIONRESULTLISTTMP.
-- 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: PFIVALTMP

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