C_FinValidationResult

DDL: C_FINVALIDATIONRESULT SQL: CFVALRSLT Type: view CONSUMPTION
44 Fields 1 Data Sources 2 Associations

Financial Validation Result

C_FinValidationResult is a Consumption CDS View that provides data about "Financial Validation Result" in SAP S/4HANA. It reads from 1 data source (I_FinValidationResultCube) and exposes 44 fields with key fields DataReleaseRequestID, ResultNodeID. It has 2 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_FinValidationResultCube I_FinValidationResultCube from

Associations (2)

CardinalityTargetAliasCondition
[0..1] I_FinValidationTaskVH _TaskVH $projection.ValidationScenarioID = _TaskVH.ValidationScenarioID and $projection.ValidationTaskID = _TaskVH.ValidationTaskID
[0..1] I_FinValidationTaskTypeVH _TaskTypeVH $projection.ValidationScenarioID = _TaskTypeVH.ValidationScenarioID and $projection.ValidationTaskType = _TaskTypeVH.ValidationTaskType

Annotations (17)

NameValueLevelField
AbapCatalog.sqlViewName CFVALRSLT view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Financial Validation Result view
VDM.viewType #CONSUMPTION view
ClientHandling.algorithm #SESSION_VARIABLE view
Search.searchable true view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.dataClass #MIXED view
OData.publish true view
UI.headerInfo.typeName Validation Result view
UI.headerInfo.typeNamePlural Validation Results view
UI.headerInfo.title.type #STANDARD view
UI.headerInfo.title.value ConsolidationGroup view
UI.headerInfo.description.type #STANDARD view
UI.headerInfo.description.value ConsolidationUnit view

Fields (44)

KeyFieldSource TableSource FieldDescription
KEY DataReleaseRequestID DataReleaseRequestID Request ID
KEY ResultNodeID ResultNodeID
ValidationScenarioID ValidationScenarioID
ConsolidationDimension ConsolidationDimension Dimension
ConsolidationVersion ConsolidationVersion Version
ConsolidationChartOfAccounts ConsolidationChartOfAccounts Cons. COA
ConsolidationLedger ConsolidationLedger Ledger
FiscalYearPeriod FiscalYearPeriod Fiscal Year Period
ConsolidationGroup ConsolidationGroup Cons. Group
ConsolidationUnit ConsolidationUnit Consolidation Unit
ValidationTaskType ValidationTaskType
ValidationTaskID ValidationTaskID
ValidationTaskText ValidationTaskText Task ID Text
TaskTypeDescription TaskTypeDescription Task Type Description
ValidationRuleID ValidationRuleID
GroupByField _Rule GroupByField Group By 1
GroupByFieldValue GroupByFieldValue Group-By Value 1
GroupByField1 _Rule GroupByField1 Group By 2
GroupByField1Value GroupByField1Value Group-By Value 2
GroupByField2 _Rule GroupByField2 Group By 3
GroupByField2Value GroupByField2Value Group-By Value 3
ValidationResultID ValidationResultID
ValidationResultText _ResultText DomainText Validation Result Text
ExceptionMessageID ExceptionMessageID
ExceptionMessageText _EXCPText DomainText Exception Message Text
Currency Currency Valuation Crcy
LeftOriginalAmount LeftOriginalAmount
ComparisonOperator _Rule ComparisonOperator Comp. Operator
RightOriginalAmount RightOriginalAmount
DifferenceAmount DifferenceAmount Amount Difference in Foreign Currency
DifferencePercent DifferencePercent
ToleranceCurrencyCode ToleranceCurrencyCode
RuleToleranceValue RuleToleranceValue
ToleranceAndOperatorIndicator And/Or Operator for Tolerance
RuleTolerancePercent RuleTolerancePercent
NrOfFailedValdtnRuleResults Failed
TotalNrOfValdtnRuleResults Total
LeftValueOriginalCurrency LeftValueOriginalCurrency Left Value Currency
RightValueOriginalCurrency RightValueOriginalCurrency Right Value Currency
_TaskVH _TaskVH
_TaskTypeVH _TaskTypeVH
_ResultText _ResultText
_EXCPText _EXCPText
_Rule _Rule

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.GroupByField AS GroupByField,
  GroupByFieldValue,
  _Rule.GroupByField1 AS GroupByField1,
  GroupByField1Value,
  _Rule.GroupByField2 AS GroupByField2,
  GroupByField2Value,
  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]
;

Learn More