VEC_RULE

Transparent Table Customizing Table
31 Fields 6 CDS Views

Validation Engine: Rule

VEC_RULE is an SAP database table in S/4HANA. Validation Engine: Rule. It contains 31 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 (31)

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
createdby VEC_CREATOR Created By
createdat VEC_TIMESTAMP_C Created At
changedby VEC_MODIFIER Changed By
changedat VEC_TIMESTAMP_M Changed At
rule_category VEC_RULE_CATEGORY Rule Category
no_data_processing VEC_NO_DATA_PROCESSING No-Data Processing

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]
    CREATEDBY,           -- Created By [VEC_CREATOR]
    CREATEDAT,           -- Created At [VEC_TIMESTAMP_C]
    CHANGEDBY,           -- Changed By [VEC_MODIFIER]
    CHANGEDAT,           -- Changed At [VEC_TIMESTAMP_M]
    RULE_CATEGORY,       -- Rule Category [VEC_RULE_CATEGORY]
    NO_DATA_PROCESSING,  -- No-Data Processing [VEC_NO_DATA_PROCESSING]
    PRIMARY KEY (MANDT, SCEN_ID, STATE, RULE_NUM)
);

Learn More