FINRE_UI_SUBSTN

Transparent Table Customizing Table
13 Fields 1 CDS Views

SubVal Rule: UI stroage for substitution

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

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_FinSubstitutionRuleSubstn view_entity from BASIC Substitution Rule Definition

Fields (13)

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
finsubstnrulesubstnvaltype finre_ui_substn_value_type Value Type
finsubstnruletargetfield finre_ui_target_field Target Field
finsubstnrulesubstitutiontype finre_ui_substition_type Substitution Type
finsubstnrulesubstitutionvalue finre_ui_value Value
finsubstnvaldtnrulefieldpath2 finre_ui_tlp_path Table Lookup Path
substitutionisskipped finre_ui_overwriteflag Skip substitution for populated fields
finsubstncstmbusobjcdsview scbo_cds_view_name CDS View Name
finsubstncstmbusobjsrcefld finre_ui_srcefldincboview Source Field
finsubstnvaldtnfunccallright fin_re_func_call_id Fun. Call Id

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 substitution
-- Category TRANSPARENT · Delivery class C
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE FINRE_UI_SUBSTN (
    CLIENT,                          -- Client [mandt]
    FINSUBSTITUTIONVALIDATIONRULE,   -- Rule ID [fin_re_rule_id]
    ISACTIVE,                        -- Checkbox [xfeld]
    FINSUBSTNVALDTNRULEEXPRSQNC,     -- Sequence Number [finre_ui_sqnc]
    FINSUBSTNRULESUBSTNVALTYPE,      -- Value Type [finre_ui_substn_value_type]
    FINSUBSTNRULETARGETFIELD,        -- Target Field [finre_ui_target_field]
    FINSUBSTNRULESUBSTITUTIONTYPE,   -- Substitution Type [finre_ui_substition_type]
    FINSUBSTNRULESUBSTITUTIONVALUE,  -- Value [finre_ui_value]
    FINSUBSTNVALDTNRULEFIELDPATH2,   -- Table Lookup Path [finre_ui_tlp_path]
    SUBSTITUTIONISSKIPPED,           -- Skip substitution for populated fields [finre_ui_overwriteflag]
    FINSUBSTNCSTMBUSOBJCDSVIEW,      -- CDS View Name [scbo_cds_view_name]
    FINSUBSTNCSTMBUSOBJSRCEFLD,      -- Source Field [finre_ui_srcefldincboview]
    FINSUBSTNVALDTNFUNCCALLRIGHT,    -- Fun. Call Id [fin_re_func_call_id]
    PRIMARY KEY (CLIENT, FINSUBSTITUTIONVALIDATIONRULE, ISACTIVE, FINSUBSTNVALDTNRULEEXPRSQNC)
);

Learn More