C_FinSubstnValdtnHierNode

DDL: C_FINSUBSTNVALDTNHIERNODE Type: view_entity CONSUMPTION Package: FINS_GEN_RE_UI
12 Fields 1 Data Sources 15 OData Services 17 Fiori Apps

Universal Hierarchy Node

C_FinSubstnValdtnHierNode is a Consumption CDS View that provides data about "Universal Hierarchy Node" in SAP S/4HANA. It reads from 1 data source (I_FinSubstnValdtnHierNode) and exposes 12 fields with key fields RuntimeHierarchy, ValidityEndDate, HierarchyNode, HierarchyNodeClass, ParentNode. It is exposed through 15 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_UI.

Data Sources (1)

SourceAliasJoin Type
I_FinSubstnValdtnHierNode I_FinSubstnValdtnHierNode from

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label Universal Hierarchy Node view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #MIXED view
VDM.viewType #CONSUMPTION view

OData Services (15)

ServiceBindingVersionContractRelease
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
UI_SUBSTNVALDNRULE_MANAGE UI_SUBSTNVALDNRULE_MANAGE V2 C1 NOT_RELEASED

Fiori Apps (17)

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).
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 (12)

KeyFieldSource TableSource FieldDescription
KEY RuntimeHierarchy RuntimeHierarchy
KEY ValidityEndDate ValidityEndDate ValidTo
KEY HierarchyNode HierarchyNode Node
KEY HierarchyNodeClass HierarchyNodeClass
KEY ParentNode ParentNode Parent Node
HierarchyType HierarchyType Hierarchy Type
HierarchyNodeLevel HierarchyNodeLevel Hierarchy Node Level
HierarchyNodeVal HierarchyNodeVal
NodeType NodeType Object Type
HierarchyNodeText
_Parent _Parent
_Text _Text

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_FinSubstnValdtnHierNode.
-- 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_FinSubstnValdtnHierNode AS
SELECT
  RuntimeHierarchy,
  ValidityEndDate,
  HierarchyNode,
  HierarchyNodeClass,
  ParentNode,
  HierarchyType,
  HierarchyNodeLevel,
  HierarchyNodeVal,
  NodeType,
  _Text[1: Language = $session.system_language ].HierarchyNodeText AS HierarchyNodeText
FROM I_FinSubstnValdtnHierNode
;

Learn More