C_FinValidationRuleValdtnTP

DDL: C_FINVALIDATIONRULEVALDTNTP Type: view_entity CONSUMPTION

Validation Rule Definition

C_FinValidationRuleValdtnTP is a Consumption CDS View that provides data about "Validation Rule Definition" in SAP S/4HANA. It reads from 1 data source (I_FinValidationRuleValdtnTP) and exposes 15 fields with key fields FinSubstitutionValidationRule, IsActive, FinSubstnValdtnRuleExprSqnc. It is exposed through 1 OData service (UI_SUBSTNVALDNRULE_MANAGE). It is used in 7 Fiori applications: Manage Substitution and Validation Rules, Manage Substitution / Validation Rules - Group Journal Entries, Manage Concur Substitution Rules, ....

Data Sources (1)

SourceAliasJoin Type
I_FinValidationRuleValdtnTP I_FinValidationRuleValdtnTP projection

Annotations (6)

NameValueLevelField
EndUserText.label Validation Rule Definition view
AccessControl.authorizationCheck #NOT_REQUIRED view
VDM.viewType #CONSUMPTION view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #D view

OData Services (1)

ServiceBindingVersionContractRelease
UI_SUBSTNVALDNRULE_MANAGE UI_SUBSTNVALDNRULE_MANAGE V2 C1 NOT_RELEASED

Fiori Apps (7)

App IDApp NameTypeDescription
F4406 Manage Substitution and Validation Rules Transactional Manage substitution and validation rules for different financial processes.
F4407 Manage Substitution / Validation Rules - Group Journal Entries Transactional
F6846 Manage Concur Substitution Rules Transactional Manage substitution and validation rules for Concur integration.
F6968 Manage Substitution and Validation - For Asset Master Data Transactional You can only use this app if you have activated the business function Universal Parallel Accounting (FINS_PARALLEL_ACCOUNTING_BF, short: UPA).
F7689 Substitution Rules for Planning Levels - Treasury Flows Transactional With this app, you can display, change, and create substitution rules for assigning cash management planning levels to the internal flows that are generated by system for each Cash Management-relevant flow in Treasury and Risk Management.
F7699 Manage Substitution and Validation - For Asset Postings Transactional
F7886 Manage Substitution Rules for CIT Classification Transactional An app for creating new substitution rules for Corporate Income Tax.

Manage Substitution and Validation Rules

Business Role: Configuration Expert - Business Process Configuration

With this app, you can display, change, and create substitution and validation rules for your selected business contexts and events. These rules can be used in the respective business processes to validate, derive, or replace values at the time of entry for the relevant fields.

Manage Substitution / Validation Rules - Group Journal Entries

Business Role: Group Accountant

Manage Concur Substitution Rules

Business Role: Administrator - Concur Integration

Manage Substitution and Validation - For Asset Master Data

Business Role: Others

As of release SAP S/4HANA 2023, the app Manage Substitution and Validation Rules - For Asset Master Data (app ID F6968) is available. You can use this app to create your own rules: In validation rules, you can specify how the system should check values that the user enters for the asset master record. In substitution rules, you can specify the preconditions under which the system is to fill or overwrite (replace) certain fields from the asset master record. The rules apply to the manual creation and change of asset master records using the Manage Fixed Assets app (F3425). They also apply to the manual legacy data transfer using the Manage Legacy Assets app (F7280).Note:You can only use the app if you have activated the business function Universal Parallel Accounting (FINS_PARALLEL_ACCOUNTING_BF).

Substitution Rules for Planning Levels - Treasury Flows

Business Role: Treasury Specialist - Back Office

With this app, you can display, change, and create substitution rules for assigning cash management planning levels to the internal flows that are generated by system for each Cash Management-relevant flow in Treasury and Risk Management. Note You can only use the new app if you are using the simplified data transfer process from Treasury and Risk Management to the One Exposure from Operations hub. For more information, see also

Key Features: This app uses the framework provided by the Manage Substitution/Validation Rules app. The app provides the following key features: Create Substitution Rules Change Rules Display Rules Transport Rules Developer Extensibility With the Substitution/Validation Logs app, you can view the detailed logs for substitution rule execution at runtime. However, before you do this, you need to activate logging using the Set Substitution/Validation Logs app.

Fields (15)

KeyFieldSource TableSource FieldDescription
KEY FinSubstitutionValidationRule FinSubstitutionValidationRule Rule ID
KEY IsActive IsActive Object active?
KEY FinSubstnValdtnRuleExprSqnc FinSubstnValdtnRuleExprSqnc Sequence Number
FinSubstnValdtnRuleCndnValType FinSubstnValdtnRuleCndnValType Value Type
FinSubstnValdtnRuleFieldPath FinSubstnValdtnRuleFieldPath Table Lookup Path
FinSubstnValdtnFuncCallLeft FinSubstnValdtnFuncCallLeft Fun. Call Id
FinSubstnValdtnRuleCndnRgSg FinSubstnValdtnRuleCndnRgSg Type of SIGN component in row type of a Ranges type
FinSubstnValdtnRuleCndnRgOp FinSubstnValdtnRuleCndnRgOp Condition Option
FinSubstnValdtnRuleCndnRgFr FinSubstnValdtnRuleCndnRgFr Low Value
FinSubstnValdtnRuleCndnRgTo FinSubstnValdtnRuleCndnRgTo High Value
FinSubstnValdtnRuleFieldPath2 FinSubstnValdtnRuleFieldPath2 Table Lookup Path
FinSubstnValdtnFuncCallRgFr FinSubstnValdtnFuncCallRgFr Fun. Call Id
FinSubstnValdtnFuncCallRgTo FinSubstnValdtnFuncCallRgTo Fun. Call Id
FinSubstnCstmBusObjCDSView FinSubstnCstmBusObjCDSView CDS View Name
FinSubstnCstmBusObjSrceFld FinSubstnCstmBusObjSrceFld Source Field

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 C_FinValidationRuleValdtnTP.
-- 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 C_FinValidationRuleValdtnTP AS
SELECT
  FinSubstitutionValidationRule,
  IsActive,
  FinSubstnValdtnRuleExprSqnc,
  FinSubstnValdtnRuleCndnValType,
  FinSubstnValdtnRuleFieldPath,
  FinSubstnValdtnFuncCallLeft,
  FinSubstnValdtnRuleCndnRgSg,
  FinSubstnValdtnRuleCndnRgOp,
  FinSubstnValdtnRuleCndnRgFr,
  FinSubstnValdtnRuleCndnRgTo,
  FinSubstnValdtnRuleFieldPath2,
  FinSubstnValdtnFuncCallRgFr,
  FinSubstnValdtnFuncCallRgTo,
  FinSubstnCstmBusObjCDSView,
  FinSubstnCstmBusObjSrceFld
FROM I_FinValidationRuleValdtnTP
;