VEC_RULE

Transparent Table Customizing Table
28 Fields 6 CDS Views

Validation Engine: Rule

VEC_RULE is an SAP database table in S/4HANA. Validation Engine: Rule. It contains 28 fields. 6 CDS views read from this table.

CDS Views using this table (6)

ViewTypeJoinVDMDescription
FAC_CDS_BASIC_RULE view_entity from CDS for validation basic rule
FAC_CDS_BASIC_RULE view_entity union_all CDS for validation basic rule
fac_cds_ve_validation_rule view from Validation Rule
fac_ve_rule view from Validation Rule
fac_ve_rule_relation view union_all Validation Rule Relation
I_GrpRptgValidationRule_2 view from BASIC Validation Rule

Fields (28)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY scen_id vec_scen_id Scenario
KEY state vec_rule_state Status
KEY rule_num vec_rule_num Rule ID
ctrl_lvl vec_ctrl_lvl Control Level
enable vec_enable Enabled
base_cds vec_cds_ent_name Entity in CDS Views
group_by_fld vec_group_by_fld Group By
group_by_fld1 vec_group_by_fld1 Group By
group_by_fld2 vec_group_by_fld2 Group By
group_by_fld3 vec_group_by_fld Group By
group_by_fld4 vec_group_by_fld Group By
group_by_fld5 vec_group_by_fld Group By
group_by_fld6 vec_group_by_fld Group By
group_by_fld7 vec_group_by_fld Group By
group_by_fld8 vec_group_by_fld Group By
group_by_fld9 vec_group_by_fld Group By
tol_amt vec_tol_amt Tolerance Amount
tol_curr vec_tol_curr Tolerance Currency
tol_percent vec_tol_percent Tolerance Percentage
tol_is_and vec_is_and Is AND Operator
cmt_required vec_cmt_required Comment Required
amdp_name vec_amdp_name AMDP Name
rule_source vec_rule_source Rule Source
dirty_amdp_flag vec_dirty_amdp_flag Dirty AMDP Flag
rule_category vec_rule_category Rule Category
no_data_processing vec_no_data_processing No-Data Processing
is_comparison_rule xcomparison_rule

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 Engine: Rule
-- Category TRANSPARENT · Delivery class C
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE VEC_RULE (
    MANDT,               -- Client [mandt]
    SCEN_ID,             -- Scenario [vec_scen_id]
    STATE,               -- Status [vec_rule_state]
    RULE_NUM,            -- Rule ID [vec_rule_num]
    CTRL_LVL,            -- Control Level [vec_ctrl_lvl]
    ENABLE,              -- Enabled [vec_enable]
    BASE_CDS,            -- Entity in CDS Views [vec_cds_ent_name]
    GROUP_BY_FLD,        -- Group By [vec_group_by_fld]
    GROUP_BY_FLD1,       -- Group By [vec_group_by_fld1]
    GROUP_BY_FLD2,       -- Group By [vec_group_by_fld2]
    GROUP_BY_FLD3,       -- Group By [vec_group_by_fld]
    GROUP_BY_FLD4,       -- Group By [vec_group_by_fld]
    GROUP_BY_FLD5,       -- Group By [vec_group_by_fld]
    GROUP_BY_FLD6,       -- Group By [vec_group_by_fld]
    GROUP_BY_FLD7,       -- Group By [vec_group_by_fld]
    GROUP_BY_FLD8,       -- Group By [vec_group_by_fld]
    GROUP_BY_FLD9,       -- Group By [vec_group_by_fld]
    TOL_AMT,             -- Tolerance Amount [vec_tol_amt]
    TOL_CURR,            -- Tolerance Currency [vec_tol_curr]
    TOL_PERCENT,         -- Tolerance Percentage [vec_tol_percent]
    TOL_IS_AND,          -- Is AND Operator [vec_is_and]
    CMT_REQUIRED,        -- Comment Required [vec_cmt_required]
    AMDP_NAME,           -- AMDP Name [vec_amdp_name]
    RULE_SOURCE,         -- Rule Source [vec_rule_source]
    DIRTY_AMDP_FLAG,     -- Dirty AMDP Flag [vec_dirty_amdp_flag]
    RULE_CATEGORY,       -- Rule Category [vec_rule_category]
    NO_DATA_PROCESSING,  -- No-Data Processing [vec_no_data_processing]
    IS_COMPARISON_RULE,  -- xcomparison_rule
    PRIMARY KEY (MANDT, SCEN_ID, STATE, RULE_NUM)
);

Learn More