FIN_RE_RULE

Transparent Table Customizing Table
14 Fields 5 CDS Views

Substitution Validation Generic Business Rules

FIN_RE_RULE is an SAP database table in S/4HANA. Substitution Validation Generic Business Rules. It contains 14 fields. 5 CDS views read from this table.

CDS Views using this table (5)

ViewTypeJoinVDMDescription
I_FinSubstnValdtnTranspTask view_entity inner BASIC FIN Substitution Validation Transp Task
P_FinSubstnValdtnEventAllRule view_entity inner BASIC
P_FinSubstnValdtnRule view_entity from BASIC
R_FinSubstnValdtnRule view_entity from BASIC
R_FinSubstnValdtnRuleTP view_entity from TRANSACTIONAL Financial substitution/validation: rule

Fields (14)

KeyField Data ElementDescription DomainTypeLength
KEY client MANDT Client
KEY finsubstitutionvalidationrule FIN_RE_RULE_ID Rule ID
KEY isactive XFELD Checkbox
finsubstitutionvaldtnrulename FIN_RE_RULE_NAME Rule Name
finsubstnvaldtnrulestatus FIN_RE_RULE_STATE Rule Status
finsubstnvaldtnrulestring FIN_RE_RULE_DEFINITION Rule Script
finsubstitutionvaldtnruletype FIN_RE_RULE_TYPE Rule Type
finsubstnvaldtnruleisgenerated FIN_RE_RULE_GENERATED Rule Generated
finsubstnruledeliverytype FIN_RE_RULE_DELIVERY_TYPE Rule Delivery Type
finsubstnruleactivationrelease FIN_RE_VERSION FIN RE Version
creationdatetime ABP_CREATION_TSTMPL Created On
createdbyuser ABP_CREATION_USER Created By
lastchangedatetime ABP_LASTCHANGE_TSTMPL Changed On
lastchangedbyuser ABP_LASTCHANGE_USER Changed By

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.

-- Substitution Validation Generic Business Rules
-- Category TRANSPARENT · Delivery class C
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE FIN_RE_RULE (
    CLIENT,                          -- Client [MANDT]
    FINSUBSTITUTIONVALIDATIONRULE,   -- Rule ID [FIN_RE_RULE_ID]
    ISACTIVE,                        -- Checkbox [XFELD]
    FINSUBSTITUTIONVALDTNRULENAME,   -- Rule Name [FIN_RE_RULE_NAME]
    FINSUBSTNVALDTNRULESTATUS,       -- Rule Status [FIN_RE_RULE_STATE]
    FINSUBSTNVALDTNRULESTRING,       -- Rule Script [FIN_RE_RULE_DEFINITION]
    FINSUBSTITUTIONVALDTNRULETYPE,   -- Rule Type [FIN_RE_RULE_TYPE]
    FINSUBSTNVALDTNRULEISGENERATED,  -- Rule Generated [FIN_RE_RULE_GENERATED]
    FINSUBSTNRULEDELIVERYTYPE,       -- Rule Delivery Type [FIN_RE_RULE_DELIVERY_TYPE]
    FINSUBSTNRULEACTIVATIONRELEASE,  -- FIN RE Version [FIN_RE_VERSION]
    CREATIONDATETIME,                -- Created On [ABP_CREATION_TSTMPL]
    CREATEDBYUSER,                   -- Created By [ABP_CREATION_USER]
    LASTCHANGEDATETIME,              -- Changed On [ABP_LASTCHANGE_TSTMPL]
    LASTCHANGEDBYUSER,               -- Changed By [ABP_LASTCHANGE_USER]
    PRIMARY KEY (CLIENT, FINSUBSTITUTIONVALIDATIONRULE, ISACTIVE)
);

Learn More