C_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 C_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: CFVALRSLT

CREATE VIEW C_FinValidationResult AS
SELECT
  DataReleaseRequestID,
  ResultNodeID,
  ValidationScenarioID,
  ConsolidationDimension,
  ConsolidationVersion,
  ConsolidationChartOfAccounts,
  ConsolidationLedger,
  FiscalYearPeriod,
  ConsolidationGroup,
  ConsolidationUnit,
  ValidationTaskType,
  ValidationTaskID,
  ValidationTaskText,
  TaskTypeDescription,
  ValidationRuleID,
  _Rule._Text[1:Language = $session.system_language].ValidationRuleDescription AS ValidationRuleDescription,
  _Rule.GroupByField AS GroupByField,
  GroupByFieldValue,
  ValidationResultID,
  _ResultText.DomainText AS ValidationResultText,
  ExceptionMessageID,
  _EXCPText.DomainText AS ExceptionMessageText,
  Currency,
  LeftOriginalAmount,
  _Rule.ComparisonOperator AS ComparisonOperator,
  RightOriginalAmount,
  DifferenceAmount,
  DifferencePercent,
  ToleranceCurrencyCode,
  RuleToleranceValue,
  case when ToleranceAndOperatorIndicator = 'X' then cast( 'AND' as abap.char(4) ) else cast( 'OR' as abap.char(4) ) end AS ToleranceAndOperatorIndicator,
  RuleTolerancePercent,
  case when ValidationResultID = 'E' then cast(1 as abap.int4 ) else cast(0 as abap.int4) end AS NrOfFailedValdtnRuleResults,
  cast(1 as abap.int4 ) AS TotalNrOfValdtnRuleResults,
  LeftValueOriginalCurrency,
  RightValueOriginalCurrency
FROM I_FinValidationResultCube
LEFT OUTER JOIN I_FinValidationTaskVH AS _TaskVH ON ValidationScenarioID = _TaskVH.ValidationScenarioID AND ValidationTaskID = _TaskVH.ValidationTaskID  -- association [0..1]
LEFT OUTER JOIN I_FinValidationTaskTypeVH AS _TaskTypeVH ON ValidationScenarioID = _TaskTypeVH.ValidationScenarioID AND ValidationTaskType = _TaskTypeVH.ValidationTaskType  -- association [0..1]
;