VEC_GRP_SNAPSHOT

Transparent Table Application Table
60 Fields 5 CDS Views

Validation Group Snapshot for the Run

VEC_GRP_SNAPSHOT is an SAP database table in S/4HANA. Validation Group Snapshot for the Run. It contains 60 fields. 5 CDS views read from this table.

CDS Views using this table (5)

ViewTypeJoinVDMDescription
FAC_CDS_VE_COMMENT view inner Validation Group Snapshot Comment
FAC_CDS_VE_COMMENT_RULE view inner Validation Rules with comments
FAC_CDS_VE_RESULT_ITEM view from Validation Result Item
FAC_CDS_VE_RESULT_ITEM view union_all Validation Result Item
FAC_CDS_VE_RULE_STATE_COUNT view from Validation Rule State Count

Fields (60)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY drruuid VEC_DRR_UUID DR Request UUID
KEY node_id NODID Node ID
node_lval NLVAL Node Low Value
hier_hid VHRID Hierarchy ID
parent_id NPNID Node Parent ID
node_type NODTP Node Type
node_lev NLEVL Node Level
node_pos NSEQN Sequence Number
node_entity BNNAM Business Entity
scen_id VEC_SCEN_ID Scenario
state VEC_RULE_STATE Status
rule_id VEC_RULE_NUM Rule ID
currency_o VEC_CURRENCY Currency Code
currency_t VEC_CURRENCY_T Target Currency Code
group_by_name VEC_GROUP_BY_FLD Group By
group_by_val VEC_GROUP_BY_VAL Group-By Field Value
group_by_name1 VEC_GROUP_BY_FLD Group By
group_by_val1 VEC_GROUP_BY_VAL Group-By Field Value
group_by_name2 VEC_GROUP_BY_FLD Group By
group_by_val2 VEC_GROUP_BY_VAL Group-By Field Value
group_by_name3 VEC_GROUP_BY_FLD Group By
group_by_val3 VEC_GROUP_BY_VAL Group-By Field Value
group_by_name4 VEC_GROUP_BY_FLD Group By
group_by_val4 VEC_GROUP_BY_VAL Group-By Field Value
group_by_name5 VEC_GROUP_BY_FLD Group By
group_by_val5 VEC_GROUP_BY_VAL Group-By Field Value
group_by_name6 VEC_GROUP_BY_FLD Group By
group_by_val6 VEC_GROUP_BY_VAL Group-By Field Value
group_by_name7 VEC_GROUP_BY_FLD Group By
group_by_val7 VEC_GROUP_BY_VAL Group-By Field Value
group_by_name8 VEC_GROUP_BY_FLD Group By
group_by_val8 VEC_GROUP_BY_VAL Group-By Field Value
group_by_name9 VEC_GROUP_BY_FLD Group By
group_by_val9 VEC_GROUP_BY_VAL Group-By Field Value
logic_result VEC_VAL_RESULT Validation Result
rule_result VEC_VAL_RESULT Validation Result
rule_excep VEC_EXCEP_EXT Exception
mul_excep VEC_MUL_EXCEP Multiple exceptions
upper_operand_o VEC_UPPER_OPERAND Left Value
upper_currency_o VEC_CURRENCY Currency Code
lower_operand_o VEC_LOWER_OPERAND Right Value
lower_currency_o VEC_CURRENCY Currency Code
upper_operand_t VEC_UPPER_OPERAND Left Value
lower_operand_t VEC_LOWER_OPERAND Right Value
tolerance VEC_TOLERANCE Tolerance
tolerance_pct VEC_TOL_PERCENT Tolerance Percentage
diff_operand_o VEC_OPERAND_DIFF_O Difference
diff_operand_t VEC_OPERAND_DIFF_T Difference
diff_operand_t_pct VEC_OPERAND_DIFF_T_PCT Difference Pct.
power VEC_POWER Power
cmt_count VE_COMMENT_CNT Comment Count
cmt_required VEC_CMT_REQUIRED Comment Required
tol_is_and VEC_IS_AND Is AND Operator
rule_category VEC_RULE_CATEGORY Rule Category
is_in_compound_rule VEC_IS_IN_COMPOUND_RULE Is in compound rule
operator VEC_OPERATOR Operator
lognumber SYSUUID_C32 UUID
group_by_currency VE_GROUPBYCURRENCY Group by Currency
reference_count VE_REFERENCE_COUNT Reference Count

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 Group Snapshot for the Run
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE VEC_GRP_SNAPSHOT (
    MANDT,                -- Client [MANDT]
    DRRUUID,              -- DR Request UUID [VEC_DRR_UUID]
    NODE_ID,              -- Node ID [NODID]
    NODE_LVAL,            -- Node Low Value [NLVAL]
    HIER_HID,             -- Hierarchy ID [VHRID]
    PARENT_ID,            -- Node Parent ID [NPNID]
    NODE_TYPE,            -- Node Type [NODTP]
    NODE_LEV,             -- Node Level [NLEVL]
    NODE_POS,             -- Sequence Number [NSEQN]
    NODE_ENTITY,          -- Business Entity [BNNAM]
    SCEN_ID,              -- Scenario [VEC_SCEN_ID]
    STATE,                -- Status [VEC_RULE_STATE]
    RULE_ID,              -- Rule ID [VEC_RULE_NUM]
    CURRENCY_O,           -- Currency Code [VEC_CURRENCY]
    CURRENCY_T,           -- Target Currency Code [VEC_CURRENCY_T]
    GROUP_BY_NAME,        -- Group By [VEC_GROUP_BY_FLD]
    GROUP_BY_VAL,         -- Group-By Field Value [VEC_GROUP_BY_VAL]
    GROUP_BY_NAME1,       -- Group By [VEC_GROUP_BY_FLD]
    GROUP_BY_VAL1,        -- Group-By Field Value [VEC_GROUP_BY_VAL]
    GROUP_BY_NAME2,       -- Group By [VEC_GROUP_BY_FLD]
    GROUP_BY_VAL2,        -- Group-By Field Value [VEC_GROUP_BY_VAL]
    GROUP_BY_NAME3,       -- Group By [VEC_GROUP_BY_FLD]
    GROUP_BY_VAL3,        -- Group-By Field Value [VEC_GROUP_BY_VAL]
    GROUP_BY_NAME4,       -- Group By [VEC_GROUP_BY_FLD]
    GROUP_BY_VAL4,        -- Group-By Field Value [VEC_GROUP_BY_VAL]
    GROUP_BY_NAME5,       -- Group By [VEC_GROUP_BY_FLD]
    GROUP_BY_VAL5,        -- Group-By Field Value [VEC_GROUP_BY_VAL]
    GROUP_BY_NAME6,       -- Group By [VEC_GROUP_BY_FLD]
    GROUP_BY_VAL6,        -- Group-By Field Value [VEC_GROUP_BY_VAL]
    GROUP_BY_NAME7,       -- Group By [VEC_GROUP_BY_FLD]
    GROUP_BY_VAL7,        -- Group-By Field Value [VEC_GROUP_BY_VAL]
    GROUP_BY_NAME8,       -- Group By [VEC_GROUP_BY_FLD]
    GROUP_BY_VAL8,        -- Group-By Field Value [VEC_GROUP_BY_VAL]
    GROUP_BY_NAME9,       -- Group By [VEC_GROUP_BY_FLD]
    GROUP_BY_VAL9,        -- Group-By Field Value [VEC_GROUP_BY_VAL]
    LOGIC_RESULT,         -- Validation Result [VEC_VAL_RESULT]
    RULE_RESULT,          -- Validation Result [VEC_VAL_RESULT]
    RULE_EXCEP,           -- Exception [VEC_EXCEP_EXT]
    MUL_EXCEP,            -- Multiple exceptions [VEC_MUL_EXCEP]
    UPPER_OPERAND_O,      -- Left Value [VEC_UPPER_OPERAND]
    UPPER_CURRENCY_O,     -- Currency Code [VEC_CURRENCY]
    LOWER_OPERAND_O,      -- Right Value [VEC_LOWER_OPERAND]
    LOWER_CURRENCY_O,     -- Currency Code [VEC_CURRENCY]
    UPPER_OPERAND_T,      -- Left Value [VEC_UPPER_OPERAND]
    LOWER_OPERAND_T,      -- Right Value [VEC_LOWER_OPERAND]
    TOLERANCE,            -- Tolerance [VEC_TOLERANCE]
    TOLERANCE_PCT,        -- Tolerance Percentage [VEC_TOL_PERCENT]
    DIFF_OPERAND_O,       -- Difference [VEC_OPERAND_DIFF_O]
    DIFF_OPERAND_T,       -- Difference [VEC_OPERAND_DIFF_T]
    DIFF_OPERAND_T_PCT,   -- Difference Pct. [VEC_OPERAND_DIFF_T_PCT]
    POWER,                -- Power [VEC_POWER]
    CMT_COUNT,            -- Comment Count [VE_COMMENT_CNT]
    CMT_REQUIRED,         -- Comment Required [VEC_CMT_REQUIRED]
    TOL_IS_AND,           -- Is AND Operator [VEC_IS_AND]
    RULE_CATEGORY,        -- Rule Category [VEC_RULE_CATEGORY]
    IS_IN_COMPOUND_RULE,  -- Is in compound rule [VEC_IS_IN_COMPOUND_RULE]
    OPERATOR,             -- Operator [VEC_OPERATOR]
    LOGNUMBER,            -- UUID [SYSUUID_C32]
    GROUP_BY_CURRENCY,    -- Group by Currency [VE_GROUPBYCURRENCY]
    REFERENCE_COUNT,      -- Reference Count [VE_REFERENCE_COUNT]
    PRIMARY KEY (MANDT, DRRUUID, NODE_ID)
);

Learn More