What is R_FinSubstnValdtnRuleTP in SAP S/4HANA?

R_FinSubstnValdtnRuleTP is a transactional CDS view in SAP S/4HANA. Financial substitution/validation: rule It contains 15 fields.

Which tables does R_FinSubstnValdtnRuleTP read from?

R_FinSubstnValdtnRuleTP reads data from: fin_re_rule.

What VDM layer is R_FinSubstnValdtnRuleTP?

R_FinSubstnValdtnRuleTP is classified as a Transactional view that supports create, update, and delete operations.

R_FinSubstnValdtnRuleTP

DDL: R_FINSUBSTNVALDTNRULETP Type: view_entity TRANSACTIONAL Package: FINS_GEN_RE_REP

15 Fields 1 Data Sources 3 Associations 17 OData Services 17 Fiori Apps

Financial substitution/validation: rule

R_FinSubstnValdtnRuleTP is a Transactional CDS View that provides data about "Financial substitution/validation: rule" in SAP S/4HANA. It reads from 1 data source (fin_re_rule) and exposes 15 fields with key fields FinSubstitutionValidationRule, IsActive. It has 3 associations to related views. It is exposed through 17 OData services (ASQL_F4407, ASQL_F6968, ASQL_F7595, ...). It is used in 17 Fiori applications: Manage Substitution and Validation Rules, Manage Substitution / Validation Rules - Group Journal Entries, Manage Concur Substitution Rules, .... Part of development package FINS_GEN_RE_REP.

Data Sources (1)

Source	Alias	Join Type
fin_re_rule	fin_re_rule	from

Associations (3)

Cardinality	Target	Alias	Condition
[0..*]	R_FinSubstnValdtnEventRuleTP	_EventRule	`$projection.FinSubstitutionValidationRule = _EventRule.FinSubstitutionValidationRule`
[0..*]	R_FinSubstnValdtnRuleTextTP	_Text
[0..*]	R_FinSubstnValdtnRuleRuleSetTP	_RuleRuleSet

Annotations (13)

Name	Value	Level
Search.searchable	true	view
AccessControl.authorizationCheck	#CHECK	view
EndUserText.label	Financial substitution/validation: rule	view
VDM.viewType	#TRANSACTIONAL	view
VDM.lifecycle.contract.type	#SAP_INTERNAL_API	view
ObjectModel.sapObjectNodeType.name	FinSubstitutionValidationRule	view
ObjectModel.usageType.dataClass	#CUSTOMIZING	view
ObjectModel.usageType.serviceQuality	#C	view
ObjectModel.usageType.sizeCategory	#L	view
UI.headerInfo.typeName	Rule	view
UI.headerInfo.typeNamePlural	Rules	view
UI.headerInfo.title.type	#STANDARD	view
UI.headerInfo.title.value	FinSubstitutionValidationRule	view

OData Services (17)

Service	Binding	Version	Contract	Release
ASQL_F4407	ASQL_F4407		C2	NOT_RELEASED
ASQL_F6968	ASQL_F6968		C2	NOT_RELEASED
ASQL_F7595	ASQL_F7595		C2	NOT_RELEASED
ASQL_F7603	ASQL_F7603		C2	NOT_RELEASED
ASQL_F7682	ASQL_F7682		C2	NOT_RELEASED
ASQL_F7683	ASQL_F7683		C2	NOT_RELEASED
ASQL_F7684	ASQL_F7684		C2	NOT_RELEASED
ASQL_F7685	ASQL_F7685		C2	NOT_RELEASED
ASQL_F7686	ASQL_F7686		C2	NOT_RELEASED
ASQL_F7687	ASQL_F7687		C2	NOT_RELEASED
ASQL_F7688	ASQL_F7688		C2	NOT_RELEASED
ASQL_F7689	ASQL_F7689		C2	NOT_RELEASED
ASQL_F7699	ASQL_F7699		C2	NOT_RELEASED
ASQL_F7818	ASQL_F7818		C2	NOT_RELEASED
R_FINSUBSTNVALDTNEVENTRULE_M
R_FINSUBSTNVALDTNRULE_M
UI_SUBSTNVALDNRULE_MANAGE	UI_SUBSTNVALDNRULE_MANAGE	V2	C1	NOT_RELEASED

Fiori Apps (17)

App ID	App Name	Type	Description
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).
F7595	Payment Reason Determination	Transactional
F7603	Manage Substitution and Validation for Public Sector	Transactional
F7682	Account Assignment References - Exposure Subitems - Substitution Rules	Transactional	With this app, you can display, change, and create substitution rules to determine the account assignment references of exposure subitems. Account assignment references are assigned to each treasury position. You use an account assignment reference to determine the G/L account in which a treasury position is managed. The substitution rules are executed during the automated process for determining account assignment references when a exposure subitem is created.
F7683	Account Assignment References OTC Transactions - Substitution Rules	Transactional	With this app, you can display, change, and create substitution rules to derive account assignment references for OTC transactions. Account assignment references are assigned to each treasury position. You use the account assignment reference to determine the G/L account in which a treasury position is managed. The substitution rules are executed during the automatic process for deriving account assignment references when an OTC transaction is created.
F7684	Account Assignment References Securities - Substitution Rules	Transactional	With this app, you can display, change, and create substitution rules to determine the account assignment references of securities. Account assignment references are assigned to each treasury position. You use an account assignment reference to determine the G/L account in which a treasury position is managed. The substitution rules are executed during the automatic process for determining account assignment references when a security position is created.
F7685	Additional Account Assignments - Substitution Rules	Transactional	With this app, you can create, change, and display substitution rules to derive additional account assignments, such as profit center, partner profit center, partner segment for segmental reporting, financial transaction type, segment for segmental reporting, reference key for line item, and WBS element for the journal entries of posting-relevant treasury flows. The additional account assignments are derived and filled in the corresponding fields of the journal entries when you post treasury flows to Financial Accounting using the Post Flows, Process Business Transactions, and Post Derived Business Transactions apps.
F7686	Define Substitution Rules for Exposure Position Fields	Transactional	With this app, you can display, change, and create substitution rules for exposure position fields that have not been filled in the raw exposure. All fields that serve as differentiation criteria for the exposure positions must be filled. The rules you define here are executed when you release a raw exposure to create an exposure position. Target fields you can derive include the Exposure Position Type which is defined in the Define Exposure Position Types configuration activity. For example, you could assign the same exposure position type to all exposure positions from a specific company code, country/region, cost center, etc.
F7687	Financial Objects Substitution Rules - Default Risk Data	Transactional	With this app, you can display, change, and create substitution rules for some fields of the financial objects that are relevant for default risk limit management. The rules are executed during the automatic derivation process of financial objects, whereby you can replace the field values that have already been filled, for example, from the predefined derivation rules.
F7688	Financial Objects Substitution Rules - Market Risk Data	Transactional	With this app, you can display, change, and create substitution rules for some fields of the financial objects that are relevant for market risk analysis. The rules are executed during the automatic derivation process of financial objects, whereby you can replace the field values that have already been filled, for example, from the predefined derivation rules.
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
F7818	Manage Substitution/Validation Rules - Service Documents	Transactional	Manage substitution and validation rules for service documents
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).

Payment Reason Determination

Business Role: Configuration Expert - Business Process Configuration

To ensure compliance with the regulatory reporting requirements of banks or local authorities, it is necessary to provide purpose codes when processing payment transactions, indicating their intended purpose. The purpose code is derived from the payment reason when creating payment media files. You can determine payment reason for the following areas: transaction management securities account management

Fields (15)

Key	Field	Source Field	Description
KEY	FinSubstitutionValidationRule	finsubstitutionvalidationrule	Rule ID
KEY	IsActive	isactive	Object active?
	FinSubstitutionValdtnRuleName	finsubstitutionvaldtnrulename	Rule Name
	FinSubstnValdtnRuleStatus	finsubstnvaldtnrulestatus	Rule Status
	FinSubstitutionValdtnRuleType	finsubstitutionvaldtnruletype	Rule Type
	FinSubstnValdtnRuleString	finsubstnvaldtnrulestring	Rule Script
	FinSubstnValdtnRuleIsGenerated	finsubstnvaldtnruleisgenerated	Rule Generated
	FinSubstnRuleDeliveryType	finsubstnruledeliverytype	Rule Delivery Type
	FinSubstnRuleActivationRelease	finsubstnruleactivationrelease	FIN RE Version
	CreationDateTime	creationdatetime	Timestamp
	CreatedByUser	createdbyuser	User Name
	LastChangeDateTime	lastchangedatetime	Timestamp
	LastChangedByUser	lastchangedbyuser	User Name
	_Text	_Text
	_EventRule_RuleRuleSet

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 R_FinSubstnValdtnRuleTP.
-- 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 R_FinSubstnValdtnRuleTP AS
SELECT
  FinSubstitutionValidationRule,
  IsActive,
  FinSubstitutionValdtnRuleName,
  FinSubstnValdtnRuleStatus,
  FinSubstitutionValdtnRuleType,
  FinSubstnValdtnRuleString,
  FinSubstnValdtnRuleIsGenerated,
  FinSubstnRuleDeliveryType,
  FinSubstnRuleActivationRelease,
  CreationDateTime,
  CreatedByUser,
  LastChangeDateTime,
  LastChangedByUser
FROM fin_re_rule
LEFT OUTER JOIN R_FinSubstnValdtnEventRuleTP AS _EventRule ON FinSubstitutionValidationRule = _EventRule.FinSubstitutionValidationRule  -- association [0..*]
LEFT OUTER JOIN R_FinSubstnValdtnRuleTextTP AS _Text ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN R_FinSubstnValdtnRuleRuleSetTP AS _RuleRuleSet ON /* condition not available in parsed metadata */  -- association [0..*]
;

Depth:

R_FinSubstnValdtnRuleTP view_entity

fin_re_rule