FINRE_UI_CNDN
SubVal Rule: UI storage for Conditions
FINRE_UI_CNDN is an SAP database table in S/4HANA. SubVal Rule: UI storage for Conditions. It contains 16 fields. 2 CDS views read from this table.
CDS Views using this table (2)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| I_FinSubstitutionRuleCndn | view_entity | from | BASIC | Substitution Rule Precondition |
| I_FinValidationRuleCndn | view_entity | from | BASIC | Validation Rule Precondition |
Fields (16)
| Key | Field | Data Element | Description | Domain | Type | Length |
|---|---|---|---|---|---|---|
| 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 |
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 storage for Conditions
-- Category TRANSPARENT · Delivery class C
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE FINRE_UI_CNDN (
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]
PRIMARY KEY (CLIENT, FINSUBSTITUTIONVALIDATIONRULE, ISACTIVE, FINSUBSTNVALDTNRULEEXPRSQNC)
);
Learn More
- Understanding Data Lineage in SAP S/4HANA
- SAP Tables vs CDS Views — Key Differences
- Understanding the SAP S/4HANA Data Model
- BSEG to ACDOCA: The Universal Journal Migration
- Business Partner Migration: KNA1/LFA1 to BUT000
- Material Document Migration: MSEG/MKPF to MATDOC
- How to Find the Right CDS View for an SAP Table
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA