I_FINVALIDATIONRESULT
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)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| I_FinValidationResultCube | view | from | COMPOSITE | Validation Result |
| P_VECFAILEDRESULT_UNION | view_entity | from | BASIC |
Fields (21)
| Key | Field | CDS Fields | Used 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)
);
Learn More
- Understanding Data Lineage in SAP S/4HANA
- SAP Tables vs CDS Views — Key Differences
- Understanding the SAP S/4HANA Data Model
- BSEG to ACDOCA: The Universal Journal Migration
- Business Partner Migration: KNA1/LFA1 to BUT000
- Material Document Migration: MSEG/MKPF to MATDOC
- How to Find the Right CDS View for an SAP Table
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA