I_FinTransNominal

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

Fin Trans Nominal Amount

I_FinTransNominal (Composite)

Package: Explore, extend and adapt the SAP S/4HANA Cloud Private 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.

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
The role must grant display authorization for the following authorization objects and fields: Authorization for Product/Transaction Types ( T_DEAL_PD ) Company Code Product Type Transaction Type Portfolio Authorization ( T_DEAL_PF ) Company Code Portfolio Authorization for Securities Account ( T_DEAL_DP ) Company Code Depot

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

StateC1
Line of BusinessFinancial Operations
Application ComponentFIN-FSCM-TRM
CapabilitiesAssociation Target for Defining CDS Entities, Data Source in SQL Select, Data Source for Defining CDS Entities
PackageFinancial Operations for SAP S/4HANA Cloud Private 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