I_FinTransNominal

DDL: I_FINTRANSNOMINAL SQL: IFINTRANSNOMINAL Type: view COMPOSITE Package: FTTR_CORE
8 Fields 2 Data Sources 4 Associations

Fin Trans Nominal Amount

I_FinTransNominal (Composite)

Package: Explore, extend and adapt the SAP S/4HANA Cloud Public Edition with built-in and side-by-side extension capabilities.

Financial Operations

I_FinTransNominal is a Composite CDS View that provides data about "Fin Trans Nominal Amount" in SAP S/4HANA. It reads from 2 data sources (I_FinTransCurrentActivity, I_FinTransFlow) and exposes 8 fields with key fields CompanyCode, FinancialTransaction, FinancialTransactionDirection. It has 4 associations to related views. Part of development package FTTR_CORE.

SAP Help Documentation

CategoryFinancial Transaction Data
Data CategoryComposite
StatusReleased
Purpose
This CDS view reads the nominal amount of a financial transaction at a key date from today's perspective. This CDS view provides the prerequisites for answering the following business questions: What is the nominal amount of a financial transaction?

Prerequisites
Users who want to use this CDS view must have a role with the following restriction types set to read access: Company Code/Product Type/Financial Transaction Type Company Code/Securities Account Company Code/Portfolio These restriction types are edited in the Maintain Business Roles app.

Structure
Main parameter and filters of the CDS view The main parameter is the key date. The main filters are as follows: Company code Financial transaction Measures and attributes Some important measures and attributes are: Company Code Financial Transaction Direction of Transaction Nominal amount of a financial transaction flow Nominal amount currency of a financial transaction

View on SAP Help Portal →

SAP API Hub

CategoryComposite
StateC1
Line of BusinessFinancial Operations
Application ComponentFIN-FSCM-TRM-2CL
CapabilitiesAssociation Target for Defining CDS Entities,Data Source in SQL Select,Data Source for Defining CDS Entities
Extensible (Key User)No
Extensible (Developer)No
Release State (Key User)Released
Release State (Developer)Released
PackageFinancial Operations for SAP S/4HANA Cloud Public Edition
Description <p>This CDS view reads the nominal amount of a financial transaction at a key date from today's perspective.</p> <p>This CDS view provides the prerequisites for answering the following business questions:</p> <ul> <li> <p>What is the nominal amount of a financial transaction?</p> </li> </ul>

Documentation

Data Sources (2)

SourceAliasJoin Type
I_FinTransCurrentActivity Activity inner
I_FinTransFlow Flow from

Parameters (1)

NameTypeDefault
P_KeyDate vdm_v_key_date

Associations (4)

CardinalityTargetAliasCondition
[0..1] I_CompanyCode _CompanyCode $projection.CompanyCode = _CompanyCode.CompanyCode
[0..1] I_FinancialTransaction _FinTrans $projection.CompanyCode = _FinTrans.CompanyCode and $projection.FinancialTransaction = _FinTrans.FinancialTransaction
[0..1] I_FinTransactionDirection _Direction $projection.FinancialTransactionDirection = _Direction.FinancialTransactionDirection
[0..1] I_Currency _NominalCurrency $projection.FinTransFlowNomAmtCrcy = _NominalCurrency.Currency

Annotations (14)

NameValueLevelField
AbapCatalog.sqlViewName IFINTRANSNOMINAL view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AbapCatalog.buffering.status #NOT_ALLOWED view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label Fin Trans Nominal Amount view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #L view
Metadata.allowExtensions false view
Metadata.ignorePropagatedAnnotations true view
VDM.viewType #COMPOSITE view

Fields (8)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode I_FinTransFlow CompanyCode Receiver Company Code
KEY FinancialTransaction I_FinTransFlow FinancialTransaction Financial Transaction
KEY FinancialTransactionDirection I_FinTransFlow FinancialTransactionDirection Direction of Transaction
FinTransFlowNomAmtCrcy I_FinTransFlow FinTransFlowNomAmtCrcy Flow Nominal Amount Currency
_CompanyCode _CompanyCode
_FinTrans _FinTrans
_Direction _Direction
_NominalCurrency _NominalCurrency

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_FinTransNominal.
-- 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.
-- SQL view name: IFINTRANSNOMINAL
-- Parameters: P_KeyDate : vdm_v_key_date

CREATE VIEW I_FinTransNominal AS
SELECT
  Flow.CompanyCode AS CompanyCode,
  Flow.FinancialTransaction AS FinancialTransaction,
  Flow.FinancialTransactionDirection AS FinancialTransactionDirection,
  Flow.FinTransFlowNomAmtCrcy AS FinTransFlowNomAmtCrcy
FROM I_FinTransFlow AS Flow
INNER JOIN I_FinTransCurrentActivity AS Activity ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_CompanyCode AS _CompanyCode ON CompanyCode = _CompanyCode.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_FinancialTransaction AS _FinTrans ON CompanyCode = _FinTrans.CompanyCode AND FinancialTransaction = _FinTrans.FinancialTransaction  -- association [0..1]
LEFT OUTER JOIN I_FinTransactionDirection AS _Direction ON FinancialTransactionDirection = _Direction.FinancialTransactionDirection  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _NominalCurrency ON FinTransFlowNomAmtCrcy = _NominalCurrency.Currency  -- association [0..1]
;

Learn More