VEC_RESULT
Validation Result table
VEC_RESULT is an SAP database table in S/4HANA. Validation Result table. It contains 24 fields. 1 CDS views read from this table.
CDS Views using this table (1)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| I_FinValidationResult | view | from | BASIC | Validation Result Data |
Fields (24)
| Key | Field | Data Element | Description | Domain | Type | Length |
|---|---|---|---|---|---|---|
| KEY | mandt | mandt | Client | |||
| KEY | drruuid | vec_drr_uuid | DR Request UUID | |||
| KEY | node_id | vec_result_node_id | Node ID | |||
| rule_id | vec_rule_num | Rule ID | ||||
| currency_o | vec_currency | Currency Code | ||||
| currency_t | vec_currency_t | Target Currency Code | ||||
| group_by_val | vec_group_by_val | Group-By Field Value | ||||
| group_by_val1 | vec_group_by_val1 | Value of Group-By 1 | ||||
| group_by_val2 | vec_group_by_val2 | Value of Group-By 2 | ||||
| logic_result | vec_val_result | Validation Result | ||||
| rule_result | vec_val_result | Validation Result | ||||
| rule_excep | vec_excep | Exception | ||||
| upper_operand_o | vec_upper_operand | Left Value | ||||
| lower_operand_o | vec_lower_operand | Right Value | ||||
| upper_operand_t | vec_upper_operand | Left Value | ||||
| lower_operand_t | vec_lower_operand | Right Value | ||||
| upper_currency_o | vec_currency | Currency Code | ||||
| lower_currency_o | vec_currency | Currency Code | ||||
| diff_operand_t | vec_operand_diff_t | Difference | ||||
| diff_operand_t_pct | vec_operand_diff_t_pct | Difference Pct. | ||||
| power | vec_power | Power | ||||
| tol_amt | vec_tol_amt | Tolerance Amount | ||||
| tol_percent | vec_tol_percent | Tolerance Percentage | ||||
| tol_is_and | vec_is_and | Is AND Operator |
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 table
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE VEC_RESULT (
MANDT, -- Client [mandt]
DRRUUID, -- DR Request UUID [vec_drr_uuid]
NODE_ID, -- Node ID [vec_result_node_id]
RULE_ID, -- Rule ID [vec_rule_num]
CURRENCY_O, -- Currency Code [vec_currency]
CURRENCY_T, -- Target Currency Code [vec_currency_t]
GROUP_BY_VAL, -- Group-By Field Value [vec_group_by_val]
GROUP_BY_VAL1, -- Value of Group-By 1 [vec_group_by_val1]
GROUP_BY_VAL2, -- Value of Group-By 2 [vec_group_by_val2]
LOGIC_RESULT, -- Validation Result [vec_val_result]
RULE_RESULT, -- Validation Result [vec_val_result]
RULE_EXCEP, -- Exception [vec_excep]
UPPER_OPERAND_O, -- Left Value [vec_upper_operand]
LOWER_OPERAND_O, -- Right Value [vec_lower_operand]
UPPER_OPERAND_T, -- Left Value [vec_upper_operand]
LOWER_OPERAND_T, -- Right Value [vec_lower_operand]
UPPER_CURRENCY_O, -- Currency Code [vec_currency]
LOWER_CURRENCY_O, -- Currency Code [vec_currency]
DIFF_OPERAND_T, -- Difference [vec_operand_diff_t]
DIFF_OPERAND_T_PCT, -- Difference Pct. [vec_operand_diff_t_pct]
POWER, -- Power [vec_power]
TOL_AMT, -- Tolerance Amount [vec_tol_amt]
TOL_PERCENT, -- Tolerance Percentage [vec_tol_percent]
TOL_IS_AND, -- Is AND Operator [vec_is_and]
PRIMARY KEY (MANDT, DRRUUID, NODE_ID)
);
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