I_FinValidationResultCube

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_FinValidationResultCube.
-- 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: IFVRCUBE
-- Parameters: P_DataReleaseRequestUsrStatus : vec_drr_ustatus

CREATE VIEW I_FinValidationResultCube AS
SELECT
  result.DataReleaseRequestID AS DataReleaseRequestID,
  result.ResultNodeID AS ResultNodeID,
  result.ValidationRuleID AS ValidationRuleID,
  result.Currency AS Currency,
  result.ToleranceCurrencyCode AS ToleranceCurrencyCode,
  result.GroupByFieldValue AS GroupByFieldValue,
  result.GroupByField1Value AS GroupByField1Value,
  result.GroupByField2Value AS GroupByField2Value,
  result.ValidationResultID AS ValidationResultID,
  result.ExceptionMessageID AS ExceptionMessageID,
  result.LeftOriginalAmount AS LeftOriginalAmount,
  result.RightOriginalAmount AS RightOriginalAmount,
  result.LeftToleranceAmount AS LeftToleranceAmount,
  result.RightToleranceAmount AS RightToleranceAmount,
  result.LeftValueOriginalCurrency AS LeftValueOriginalCurrency,
  result.RightValueOriginalCurrency AS RightValueOriginalCurrency,
  result.DifferenceAmount AS DifferenceAmount,
  result.DifferencePercent AS DifferencePercent,
  result.RuleToleranceValue AS RuleToleranceValue,
  result.RuleTolerancePercent AS RuleTolerancePercent,
  result.ToleranceAndOperatorIndicator AS ToleranceAndOperatorIndicator,
  drr.ValidationScenarioID AS ValidationScenarioID,
  drr.ConsolidationDimension AS ConsolidationDimension,
  drr.ConsolidationVersion AS ConsolidationVersion,
  drr.ConsolidationChartOfAccounts AS ConsolidationChartOfAccounts,
  drr.ConsolidationLedger AS ConsolidationLedger,
  concat( drr.FiscalYear, drr.FiscalPeriod ) AS FiscalYearPeriod,
  drr.FiscalYearVariant AS FiscalYearVariant,
  drr.ValidationTaskID AS ValidationTaskID,
  drr.ConsolidationUnit AS ConsolidationUnit,
  drr.ConsolidationGroup AS ConsolidationGroup,
  drr.CreatedByUser AS CreatedByUser,
  drr.CreationDateTime AS CreationDateTime,
  drr.LastChangedByUser AS LastChangedByUser,
  drr.LastChangeDateTime AS LastChangeDateTime,
  drr.DataReleaseRequestUserStatus AS DataReleaseRequestUserStatus,
  drr.ValidationTaskType AS ValidationTaskType,
  drr.ValidationTaskText AS ValidationTaskText,
  drr.TaskTypeDescription AS TaskTypeDescription,
  _Rule._Text[1:Language = $session.system_language].ValidationRuleDescription AS ValidationRuleDescription,
  drr._Task AS _Task
FROM I_FinValidationResult AS result
INNER JOIN I_FinDataReleaseRequest AS drr ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_GrpRptgValidationRule_2 AS _Rule ON _Rule.ValidationScenarioID = ValidationScenarioID AND _Rule.ValidationRuleID = ValidationRuleID  -- association [0..1]
;