I_FINVALIDATIONRESULT

CDS View

Validation Result Data

I_FINVALIDATIONRESULT is a CDS View in S/4HANA. Validation Result Data. It contains 21 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
I_FinValidationResultCube view from COMPOSITE Validation Result
P_VECFAILEDRESULT_UNION view_entity from BASIC

Fields (21)

KeyField CDS FieldsUsed in Views
KEY DataReleaseRequestID DataReleaseRequestID 1
KEY ResultNodeID ResultNodeID 1
Currency Currency 1
DifferenceAmount DifferenceAmount 1
DifferencePercent DifferencePercent 1
ExceptionMessageID ExceptionMessageID 1
GroupByField1Value GroupByField1Value 1
GroupByField2Value GroupByField2Value 1
GroupByFieldValue GroupByFieldValue 1
LeftOriginalAmount LeftOriginalAmount 1
LeftToleranceAmount LeftToleranceAmount 1
LeftValueOriginalCurrency LeftValueOriginalCurrency 1
RightOriginalAmount RightOriginalAmount 1
RightToleranceAmount RightToleranceAmount 1
RightValueOriginalCurrency RightValueOriginalCurrency 1
RuleTolerancePercent RuleTolerancePercent 1
RuleToleranceValue RuleToleranceValue 1
ToleranceAndOperatorIndicator ToleranceAndOperatorIndicator 1
ToleranceCurrencyCode ToleranceCurrencyCode 1
ValidationResultID ValidationResultID 1
ValidationRuleID ValidationRuleID 1

Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.

-- Validation Result Data
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_FINVALIDATIONRESULT (
    DATARELEASEREQUESTID,
    RESULTNODEID,
    CURRENCY,
    DIFFERENCEAMOUNT,
    DIFFERENCEPERCENT,
    EXCEPTIONMESSAGEID,
    GROUPBYFIELD1VALUE,
    GROUPBYFIELD2VALUE,
    GROUPBYFIELDVALUE,
    LEFTORIGINALAMOUNT,
    LEFTTOLERANCEAMOUNT,
    LEFTVALUEORIGINALCURRENCY,
    RIGHTORIGINALAMOUNT,
    RIGHTTOLERANCEAMOUNT,
    RIGHTVALUEORIGINALCURRENCY,
    RULETOLERANCEPERCENT,
    RULETOLERANCEVALUE,
    TOLERANCEANDOPERATORINDICATOR,
    TOLERANCECURRENCYCODE,
    VALIDATIONRESULTID,
    VALIDATIONRULEID,
    PRIMARY KEY (DATARELEASEREQUESTID, RESULTNODEID)
);