P_FI_CLS_REC_RL_SRC_doc_base

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_FI_CLS_REC_RL_SRC_doc_base.
-- 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_FI_CLS_REC_RL_SRC_doc_base AS
SELECT
  rl.JrnlPerdEndClsgRunResultUUID AS JrnlPerdEndClsgRunResultUUID,
  rl.AccountingDocument AS key1,
  rl.LedgerGLLineItem AS key2,
  rl.PrdcssrPerdEndClsgRunRsltUUID AS PrdcssrPerdEndClsgRunRsltUUID,
  cast( rl.PrdcssrJournalEntryFiscalYear as cls_rec_original_fiscal_year preserving type ) AS PrdcssrJournalEntryFiscalYear,
  cast( rl.PredecessorJournalEntry as cls_rec_original_journal_entry preserving type ) AS OriginalJournalEntry,
  cast( rl.PredecessorJournalEntryItem as cls_rec_original_journal_item preserving type ) AS OriginalJournalEntryItem,
  cast ( rl.FinancialClosingGrouping as cls_run_group_id preserving type ) AS GROUPID,
  cast( concat( concat(rl.FinancialClosingValuationRule, '/' ) ,rl.FinClosingValuationRuleStep) as cls_val_rule_and_step preserving type ) AS ValuationRuleAndStep,
  rl.FinClosingLineItemDetailStatus AS FinClosingLineItemDetailStatus,
  cast( rl.GLAccount as fins_rec_target_account preserving type ) AS GLAccount,
  cast( rl.OffsettingAccount as fins_rec_source_account preserving type ) AS OffsettingAccount,
  cast(rl.NetDueDate as cls_rec_netduedate preserving type ) AS netduedate,
  cast( rl.GeneralLedgerAgingScope as cls_rec_target_aging preserving type ) AS GeneralLedgerAgingScope,
  cast( rl.PostedAgingIncrement as cls_rec_target_increment preserving type ) AS GeneralLedgerAgingIncrement,
  cast( rl.FinancialAccountType as cls_rec_account_type preserving type ) AS AccountType,
  cast ( rl.BalanceTransactionCurrency as targetcurrency preserving type ) AS Currency,
  cast ( rl.FinClsgRunRsltAmtInFDCrcy1 as cls_rec_nominal_value preserving type ) AS NominalValue,
  cast( rl.FinClsgRunRsltAmtInFDCrcy2 as cls_rec_remaining_amount preserving type ) AS RemainingAmount,
  cast ( rl.FinClsgRunRsltAmtInFDCrcy3 as cls_rec_valuation_adjustments preserving type ) AS ValnAdjmtExcludeImprmt,
  cast ( rl.FinClsgRunRsltAmtInFDCrcy4 as cls_rec_impairment_adjustments preserving type ) AS ImpairmentAdjustment,
  cast ( rl.FinClsgRunRsltAmtInFDCrcy5 as cls_rec_adjustments preserving type ) AS Adjustment,
  rl.Supplier AS Supplier,
  rl.Customer AS Customer,
  rl.FinClosingRunIsTestExecution AS FinClosingRunIsTestExecution,
  rl.FinancialClosingLineItemType AS FinancialClosingLineItemType,
  cast ( rl.FinancialClosingGroupingRule as fins_val_grouping_rule preserving type ) AS GROUPRULE,
  rl.FinancialClosingLineItemStatus AS FinancialClosingLineItemStatus,
  cast ( rl.FinClosingGroupingRuleStep as fins_val_grouping_rule_step preserving type ) AS GROUPRULESTEP,
  rl.Ledger AS Ledger,
  rl.CompanyCode AS CompanyCode,
  rl.FiscalYear AS FiscalYear,
  rl.JrnlPeriodEndClosingRunLogUUID AS JrnlPeriodEndClosingRunLogUUID,
  rl.ChartOfAccounts AS ChartOfAccounts,
  rl.InvoiceItemReference AS InvoiceItemReference,
  rl.InvoiceReference AS InvoiceReference,
  rl.InvoiceReferenceFiscalYear AS InvoiceReferenceFiscalYear,
  rl.SubLedgerAcctLineItemType AS SubLedgerAcctLineItemType
FROM P_FIVALUATIONRESULTLIST AS rl
;