P_FI_CLS_REC_RL_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_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_base AS
SELECT
  rl.JrnlPerdEndClsgRunResultUUID AS JrnlPerdEndClsgRunResultUUID,
  rl.AccountingDocument AS key1,
  rl.LedgerGLLineItem AS key2,
  cast ( coalesce(precrl.FinClosingLineItemDetailStatus, rl.FinClosingLineItemDetailStatus ) as cls_line_item_status_detail preserving type ) AS FinClosingLineItemDetailStatus,
  rl.AccountingDocument AS AccountingDocument,
  rl.LedgerGLLineItem AS LedgerGLLineItem,
  precrl.LedgerGLLineItem AS ImpairmentLedgerGLLineItem,
  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,
  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.GLAccount as fins_rec_target_account preserving type ) AS GLAccount,
  cast( rl.OffsettingAccount as fins_rec_source_account preserving type ) AS OffsettingAccount,
  rl.SubLedgerAcctLineItemType AS SubLedgerAcctLineItemType,
  rl.Supplier AS Supplier,
  rl.Customer AS Customer,
  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_reclassified_amount preserving type ) AS ReclassificationInCurrentRun,
  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_cumulative_payments preserving type ) AS CumulativePayments,
  cast ( rl.FinClsgRunRsltAmtInFDCrcy6 as cls_rec_prev_posted_amount preserving type ) AS PreviousPostedReclassification,
  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.PostingDate AS PostingDate
FROM P_FIVALUATIONRESULTLIST AS rl
;