I_FinValidationResult

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 I_FinValidationResult.
-- 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: IFVRESULT

CREATE VIEW I_FinValidationResult AS
SELECT
  drruuid AS DataReleaseRequestID,
  node_id AS ResultNodeID,
  rule_id AS ValidationRuleID,
  currency_o AS Currency,
  currency_t AS ToleranceCurrencyCode,
  group_by_val AS GroupByFieldValue,
  group_by_val1 AS GroupByField1Value,
  group_by_val2 AS GroupByField2Value,
  rule_result AS ValidationResultID,
  rule_excep AS ExceptionMessageID,
  upper_operand_o AS LeftOriginalAmount,
  lower_operand_o AS RightOriginalAmount,
  upper_operand_t AS LeftToleranceAmount,
  lower_operand_t AS RightToleranceAmount,
  upper_currency_o AS LeftValueOriginalCurrency,
  lower_currency_o AS RightValueOriginalCurrency,
  diff_operand_t AS DifferenceAmount,
  diff_operand_t_pct AS DifferencePercent,
  tol_amt AS RuleToleranceValue,
  tol_percent AS RuleTolerancePercent,
  tol_is_and AS ToleranceAndOperatorIndicator
FROM vec_result
LEFT OUTER JOIN I_FinDomainValueText AS _ResultText ON _ResultText.DomainValueName = 'VEC_VAL_RESULT' AND _ResultText.DomainValue = ValidationResultID AND _ResultText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_FinDomainValueText AS _EXCPText ON _EXCPText.DomainValueName = 'VEC_EXCEP' AND _EXCPText.DomainValue = ExceptionMessageID AND _EXCPText.Language = $session.system_language  -- association [0..1]
;