FINRE_UI_VALDTN

Transparent Table Customizing Table
21 Fields 1 CDS Views

SubVal Rule: UI stroage for validation

FINRE_UI_VALDTN is an SAP database table in S/4HANA. SubVal Rule: UI stroage for validation. It contains 21 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_FinValidationRuleValdtn view_entity from BASIC Validation Rule Definition

Fields (21)

KeyField Data ElementDescription DomainTypeLength
KEY client mandt Client
KEY finsubstitutionvalidationrule fin_re_rule_id Rule ID
KEY isactive xfeld Checkbox
KEY finsubstnvaldtnruleexprsqnc finre_ui_sqnc Sequence Number
finsubstnvaldtnrulecndnvaltype finre_ui_condition_value_type Value Type
finsubstnvaldtnrulefieldpath finre_ui_condition_field_path Condition Field Path
finsubstnvaldtnfunccallleft fin_re_func_call_id Fun. Call Id
finsubstnvaldtnrulecndnrgsg ddsign Type of SIGN component in row type of a Ranges type
finsubstnvaldtnrulecndnrgop finre_ui_option Condition Option
finsubstnvaldtnrulecndnrgfr finre_ui_low_value Low Value
finsubstnvaldtnrulecndnrgto finre_ui_high_value High Value
finsubstnvaldtnfunccallrgfr fin_re_func_call_id Fun. Call Id
finsubstnvaldtnfunccallrgto fin_re_func_call_id Fun. Call Id
finsubstnvaldtnrulefieldpath2 finre_ui_tlp_path Table Lookup Path
finsubstncstmbusobjcdsview scbo_cds_view_name CDS View Name
finsubstncstmbusobjsrcefld finre_ui_srcefldincboview Source Field
customeruniversalhierarchy vhrid Hierarchy ID
universalhierarchy hryid_40 Hierarchy ID
hierarchytype hrytype Hierarchy Type
customeruniversalhierarchynode nodevalue Value
finsubstnvaldtnjsonvalue finre_ui_json_value

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.

-- SubVal Rule: UI stroage for validation
-- Category TRANSPARENT · Delivery class C
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE FINRE_UI_VALDTN (
    CLIENT,                          -- Client [mandt]
    FINSUBSTITUTIONVALIDATIONRULE,   -- Rule ID [fin_re_rule_id]
    ISACTIVE,                        -- Checkbox [xfeld]
    FINSUBSTNVALDTNRULEEXPRSQNC,     -- Sequence Number [finre_ui_sqnc]
    FINSUBSTNVALDTNRULECNDNVALTYPE,  -- Value Type [finre_ui_condition_value_type]
    FINSUBSTNVALDTNRULEFIELDPATH,    -- Condition Field Path [finre_ui_condition_field_path]
    FINSUBSTNVALDTNFUNCCALLLEFT,     -- Fun. Call Id [fin_re_func_call_id]
    FINSUBSTNVALDTNRULECNDNRGSG,     -- Type of SIGN component in row type of a Ranges type [ddsign]
    FINSUBSTNVALDTNRULECNDNRGOP,     -- Condition Option [finre_ui_option]
    FINSUBSTNVALDTNRULECNDNRGFR,     -- Low Value [finre_ui_low_value]
    FINSUBSTNVALDTNRULECNDNRGTO,     -- High Value [finre_ui_high_value]
    FINSUBSTNVALDTNFUNCCALLRGFR,     -- Fun. Call Id [fin_re_func_call_id]
    FINSUBSTNVALDTNFUNCCALLRGTO,     -- Fun. Call Id [fin_re_func_call_id]
    FINSUBSTNVALDTNRULEFIELDPATH2,   -- Table Lookup Path [finre_ui_tlp_path]
    FINSUBSTNCSTMBUSOBJCDSVIEW,      -- CDS View Name [scbo_cds_view_name]
    FINSUBSTNCSTMBUSOBJSRCEFLD,      -- Source Field [finre_ui_srcefldincboview]
    CUSTOMERUNIVERSALHIERARCHY,      -- Hierarchy ID [vhrid]
    UNIVERSALHIERARCHY,              -- Hierarchy ID [hryid_40]
    HIERARCHYTYPE,                   -- Hierarchy Type [hrytype]
    CUSTOMERUNIVERSALHIERARCHYNODE,  -- Value [nodevalue]
    FINSUBSTNVALDTNJSONVALUE,        -- finre_ui_json_value
    PRIMARY KEY (CLIENT, FINSUBSTITUTIONVALIDATIONRULE, ISACTIVE, FINSUBSTNVALDTNRULEEXPRSQNC)
);

Learn More