What is P_FinTransNomIntRate in SAP S/4HANA?

P_FinTransNomIntRate is a composite CDS view in SAP S/4HANA. It contains 31 fields.

Which tables does P_FinTransNomIntRate read from?

P_FinTransNomIntRate reads data from: atfta, P_FINTRANSINTCOND, I_FinancialTransacCashFlow.

What VDM layer is P_FinTransNomIntRate?

P_FinTransNomIntRate is classified as a Composite view that combines data from multiple basic views.

P_FinTransNomIntRate

DDL: P_FINTRANSNOMINTRATE SQL: PFINTRNOMFLOWIR Type: view COMPOSITE

31 Fields 3 Data Sources 1 Associations

P_FinTransNomIntRate is a Composite CDS View in SAP S/4HANA. It reads from 3 data sources (atfta, P_FINTRANSINTCOND, I_FinancialTransacCashFlow) and exposes 31 fields with key fields CompanyCode, FinancialTransaction, FinInstrConditoinNumber, FinancialInstrumentActivity, ConditionItemValidityStartDate. It has 1 association to related views.

Data Sources (3)

Source	Alias	Join Type
atfta	_AssignFlowType	left_outer
P_FINTRANSINTCOND	P_FINTRANSINTCOND	left_outer
I_FinancialTransacCashFlow	TransactionCashFlow	from

Parameters (1)

Name	Type	Default
P_KeyDate	vdm_v_key_date

Associations (1)

Cardinality	Target	Alias	Condition
[1..1]	at19	_FlowType	`_FlowType.sbewart = _AssignFlowType.sfhazba and _FlowType.rantyp = TransactionCondition.ContractType`

Annotations (6)

Name	Value	Level
AbapCatalog.sqlViewName	PFINTRNOMFLOWIR	view
ClientHandling.algorithm	#SESSION_VARIABLE	view
AbapCatalog.compiler.compareFilter	true	view
AccessControl.authorizationCheck	#NOT_REQUIRED	view
VDM.viewType	#COMPOSITE	view
VDM.private	true	view

Fields (31)

Key	Field	Source Table	Source Field	Description
KEY	CompanyCode	TransactionCondition	CompanyCode	Receiver Company Code
KEY	FinancialTransaction	TransactionCondition	FinancialTransaction	Transaction
KEY	FinInstrConditoinNumber	TransactionCondition	FinInstrConditoinNumber	Condition
KEY	FinancialInstrumentActivity	TransactionCondition	FinancialInstrumentActivity	Activity
KEY	ConditionItemValidityStartDate	TransactionCondition	ConditionItemValidityStartDate	Item Eff. From
KEY	FinInstrConditionLogicGroup	TransactionCondition	FinInstrConditionLogicGroup
	FinInstrConditionType	TransactionCondition	FinInstrConditionType	Condition Type
	CashFlowCalculationCategory	TransactionCondition	CashFlowCalculationCategory	Calc. Category
	ConditionPercentageRate	TransactionCondition	ConditionPercentageRate	Percentage Rate
	ConditionFixAmount	TransactionCondition	ConditionFixAmount	Condition amnt
	ReferenceInterestRate	TransactionCondition	ReferenceInterestRate	Ref.int.rate
	ScaledCondtionLowerLimit	TransactionCondition	ScaledCondtionLowerLimit	Lower Limit
	ScaledConditionUpperLimit	TransactionCondition	ScaledConditionUpperLimit	Upper Limit
	ScaledCondtionType	TransactionCondition	ScaledCondtionType	Scaled Calc.
	CalcDateIsAsEndDateInclusive	TransactionCondition	CalcDateIsAsEndDateInclusive	Inclusive Ind.
	ContractType	TransactionCondition	ContractType	ContractTp
	FinancialInstrProductCategory	TransactionCondition	FinancialInstrProductCategory
	FinancialInstrumentProductType	TransactionCondition	FinancialInstrumentProductType
	FinancialInstrTransactionType	TransactionCondition	FinancialInstrTransactionType
	TransactionCurrency	TransactionCondition	TransactionCurrency	Transaction Currency
	FinancialTranactionDirection	TransactionCondition	FinancialTranactionDirection	Direction
	FinInstrumentIncomingCurrency	TransactionCondition	FinInstrumentIncomingCurrency
	FinInstrumentOutgoingCurrency	TransactionCondition	FinInstrumentOutgoingCurrency
	TermEndDate	TransactionCondition	TermEndDate
	ActivityStartDate	TransactionCondition	ActivityStartDate	Term Start
	ActivityEndDate	TransactionCondition	ActivityEndDate	Term End
	Counterparty	TransactionCondition	Counterparty	Supplier
	CashFlowDirection	I_FinancialTransacCashFlow	CashFlowDirection
	NominalCurrency	I_FinancialTransacCashFlow	NominalCurrency
	DifferentiationPortfolio	I_FinancialTransacCashFlow	DifferentiationPortfolio
	PaymentDate	I_FinancialTransacCashFlow	PaymentDate	Payment Date

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 P_FinTransNomIntRate.
-- 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: PFINTRNOMFLOWIR
-- Parameters: P_KeyDate : vdm_v_key_date

CREATE VIEW P_FinTransNomIntRate AS
SELECT
  TransactionCondition.CompanyCode AS CompanyCode,
  TransactionCondition.FinancialTransaction AS FinancialTransaction,
  TransactionCondition.FinInstrConditoinNumber AS FinInstrConditoinNumber,
  TransactionCondition.FinancialInstrumentActivity AS FinancialInstrumentActivity,
  TransactionCondition.ConditionItemValidityStartDate AS ConditionItemValidityStartDate,
  TransactionCondition.FinInstrConditionLogicGroup AS FinInstrConditionLogicGroup,
  TransactionCondition.FinInstrConditionType AS FinInstrConditionType,
  TransactionCondition.CashFlowCalculationCategory AS CashFlowCalculationCategory,
  TransactionCondition.ConditionPercentageRate AS ConditionPercentageRate,
  TransactionCondition.ConditionFixAmount AS ConditionFixAmount,
  TransactionCondition.ReferenceInterestRate AS ReferenceInterestRate,
  TransactionCondition.ScaledCondtionLowerLimit AS ScaledCondtionLowerLimit,
  TransactionCondition.ScaledConditionUpperLimit AS ScaledConditionUpperLimit,
  TransactionCondition.ScaledCondtionType AS ScaledCondtionType,
  TransactionCondition.CalcDateIsAsEndDateInclusive AS CalcDateIsAsEndDateInclusive,
  TransactionCondition.ContractType AS ContractType,
  TransactionCondition.FinancialInstrProductCategory AS FinancialInstrProductCategory,
  TransactionCondition.FinancialInstrumentProductType AS FinancialInstrumentProductType,
  TransactionCondition.FinancialInstrTransactionType AS FinancialInstrTransactionType,
  TransactionCondition.TransactionCurrency AS TransactionCurrency,
  TransactionCondition.FinancialTranactionDirection AS FinancialTranactionDirection,
  TransactionCondition.FinInstrumentIncomingCurrency AS FinInstrumentIncomingCurrency,
  TransactionCondition.FinInstrumentOutgoingCurrency AS FinInstrumentOutgoingCurrency,
  TransactionCondition.TermEndDate AS TermEndDate,
  TransactionCondition.ActivityStartDate AS ActivityStartDate,
  TransactionCondition.ActivityEndDate AS ActivityEndDate,
  TransactionCondition.Counterparty AS Counterparty,
  TransactionCashFlow.CashFlowDirection AS CashFlowDirection,
  TransactionCashFlow.NominalCurrency AS NominalCurrency,
  TransactionCashFlow.DifferentiationPortfolio AS DifferentiationPortfolio,
  TransactionCashFlow.PaymentDate AS PaymentDate
FROM I_FinancialTransacCashFlow AS TransactionCashFlow
LEFT OUTER JOIN P_FINTRANSINTCOND ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN atfta AS _AssignFlowType ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN at19 AS _FlowType ON _FlowType.sbewart = _AssignFlowType.sfhazba AND _FlowType.rantyp = TransactionCondition.ContractType  -- association [1..1]
;

Depth:

P_FinTransNomIntRate view