I_FinSubstitutionRuleCndn

DDL: I_FINSUBSTITUTIONRULECNDN Type: view_entity BASIC
19 Fields 2 Data Sources

Substitution Rule Precondition

I_FinSubstitutionRuleCndn is a Basic CDS View that provides data about "Substitution Rule Precondition" in SAP S/4HANA. It reads from 2 data sources (finre_ui_cndn, finre_ui_rule) and exposes 19 fields with key fields FinSubstitutionValidationRule, IsActive, FinSubstnValdtnRuleExprSqnc.

Data Sources (2)

SourceAliasJoin Type
finre_ui_cndn _Condition from
finre_ui_rule _Rule inner

Annotations (7)

NameValueLevelField
Search.searchable true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Substitution Rule Precondition view
VDM.viewType #BASIC view
ObjectModel.usageType.dataClass #CUSTOMIZING view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view

Fields (19)

KeyFieldSource TableSource FieldDescription
KEY FinSubstitutionValidationRule finre_ui_cndn finsubstitutionvalidationrule Rule ID
KEY IsActive finre_ui_cndn isactive Object active?
KEY FinSubstnValdtnRuleExprSqnc finre_ui_cndn finsubstnvaldtnruleexprsqnc Sequence Number
FinSubstnValdtnRuleCndnValType finre_ui_cndn finsubstnvaldtnrulecndnvaltype Value Type
FinSubstnValdtnRuleFieldPath finre_ui_cndn finsubstnvaldtnrulefieldpath Table Lookup Path
FinSubstnValdtnFuncCallLeft finre_ui_cndn finsubstnvaldtnfunccallleft Fun. Call Id
FinSubstnValdtnRuleCndnRgSg finre_ui_cndn finsubstnvaldtnrulecndnrgsg Type of SIGN component in row type of a Ranges type
FinSubstnValdtnRuleCndnRgOp finre_ui_cndn finsubstnvaldtnrulecndnrgop Condition Option
FinSubstnValdtnRuleCndnRgFr finre_ui_cndn finsubstnvaldtnrulecndnrgfr Low Value
FinSubstnValdtnRuleCndnRgTo finre_ui_cndn finsubstnvaldtnrulecndnrgto High Value
FinSubstnValdtnFuncCallRgFr finre_ui_cndn finsubstnvaldtnfunccallrgfr Fun. Call Id
FinSubstnValdtnFuncCallRgTo finre_ui_cndn finsubstnvaldtnfunccallrgto Fun. Call Id
FinSubstnValdtnRuleFieldPath2 finre_ui_cndn finsubstnvaldtnrulefieldpath2 Table Lookup Path
FinSubstnCstmBusObjCDSView finre_ui_cndn finsubstncstmbusobjcdsview CDS View Name
FinSubstnCstmBusObjSrceFld finre_ui_cndn finsubstncstmbusobjsrcefld Source Field
CustomerUniversalHierarchy finre_ui_cndn customeruniversalhierarchy Hierarchy ID
UniversalHierarchy finre_ui_cndn universalhierarchy Hierarchy ID
HierarchyType finre_ui_cndn hierarchytype Hierarchy Type
CustomerUniversalHierarchyNode finre_ui_cndn customeruniversalhierarchynode Value

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view I_FinSubstitutionRuleCndn.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.

CREATE VIEW I_FinSubstitutionRuleCndn AS
SELECT
  _Condition.finsubstitutionvalidationrule AS FinSubstitutionValidationRule,
  _Condition.isactive AS IsActive,
  _Condition.finsubstnvaldtnruleexprsqnc AS FinSubstnValdtnRuleExprSqnc,
  _Condition.finsubstnvaldtnrulecndnvaltype AS FinSubstnValdtnRuleCndnValType,
  _Condition.finsubstnvaldtnrulefieldpath AS FinSubstnValdtnRuleFieldPath,
  _Condition.finsubstnvaldtnfunccallleft AS FinSubstnValdtnFuncCallLeft,
  _Condition.finsubstnvaldtnrulecndnrgsg AS FinSubstnValdtnRuleCndnRgSg,
  _Condition.finsubstnvaldtnrulecndnrgop AS FinSubstnValdtnRuleCndnRgOp,
  _Condition.finsubstnvaldtnrulecndnrgfr AS FinSubstnValdtnRuleCndnRgFr,
  _Condition.finsubstnvaldtnrulecndnrgto AS FinSubstnValdtnRuleCndnRgTo,
  _Condition.finsubstnvaldtnfunccallrgfr AS FinSubstnValdtnFuncCallRgFr,
  _Condition.finsubstnvaldtnfunccallrgto AS FinSubstnValdtnFuncCallRgTo,
  _Condition.finsubstnvaldtnrulefieldpath2 AS FinSubstnValdtnRuleFieldPath2,
  _Condition.finsubstncstmbusobjcdsview AS FinSubstnCstmBusObjCDSView,
  _Condition.finsubstncstmbusobjsrcefld AS FinSubstnCstmBusObjSrceFld,
  _Condition.customeruniversalhierarchy AS CustomerUniversalHierarchy,
  _Condition.universalhierarchy AS UniversalHierarchy,
  _Condition.hierarchytype AS HierarchyType,
  _Condition.customeruniversalhierarchynode AS CustomerUniversalHierarchyNode
FROM finre_ui_cndn AS _Condition
INNER JOIN finre_ui_rule AS _Rule ON /* join condition not captured in parsed metadata */
;

Learn More