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