P_SecClassNormFlowIntRate

DDL: P_SECCLASSNORMFLOWINTRATE SQL: PSECCLASSNFIR Type: view COMPOSITE Package: FTR_IRM_CORE
23 Fields 2 Data Sources

Nominal Flows with Sec. Class

P_SecClassNormFlowIntRate is a Composite CDS View that provides data about "Nominal Flows with Sec. Class" in SAP S/4HANA. It reads from 2 data sources (P_SecClassIntCond, I_FinancialTransacCashFlow) and exposes 23 fields with key fields CompanyCode, SecurityClass, SecurityAccount, CalculationDate, TreasuryUpdateType. Part of development package FTR_IRM_CORE.

Data Sources (2)

SourceAliasJoin Type
P_SecClassIntCond P_SecClassIntCond left_outer
I_FinancialTransacCashFlow TransactionCashFlow from

Parameters (1)

NameTypeDefault
P_KeyDate vdm_v_key_date

Annotations (6)

NameValueLevelField
AbapCatalog.sqlViewName PSECCLASSNFIR 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 (23)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode I_FinancialTransacCashFlow CompanyCode Receiver Company Code
KEY SecurityClass I_FinancialTransacCashFlow SecurityClass Key 1
KEY SecurityAccount I_FinancialTransacCashFlow SecurityAccount Securities Acct
KEY CalculationDate I_FinancialTransacCashFlow CalculationDate
KEY TreasuryUpdateType I_FinancialTransacCashFlow TreasuryUpdateType
Counterparty I_FinancialTransacCashFlow Counterparty Supplier
DifferentiationPortfolio I_FinancialTransacCashFlow DifferentiationPortfolio
PaymentDate I_FinancialTransacCashFlow PaymentDate Payment Date
FinInstrConditoinType TransactionCondition FinInstrConditoinType Condition Type
ConditionItemValidityStartDate TransactionCondition ConditionItemValidityStartDate Item Eff. From
ContractType TransactionCondition ContractType ContractTp
FinancialInstrProductCategory TransactionCondition FinancialInstrProductCategory Prod. Category
CalcDateIsAsEndDateInclusive TransactionCondition CalcDateIsAsEndDateInclusive Inclusive Ind.
FinancialInstrumentProductType TransactionCondition FinancialInstrumentProductType Product Type
FinancialInstrTransactionType TransactionCondition FinancialInstrTransactionType
TransactionCurrency TransactionCondition TransactionCurrency Transaction Currency
ConditionPercentageRate TransactionCondition ConditionPercentageRate Percentage Rate
ConditionFixAmount TransactionCondition ConditionFixAmount Condition amnt
ReferenceInterestRate TransactionCondition ReferenceInterestRate Ref.int.rate
TermStartDate TransactionCondition TermStartDate Term Start
TermEndDate TransactionCondition TermEndDate Term End
CashFlowDirection I_FinancialTransacCashFlow CashFlowDirection +/- Sign
NominalCurrency I_FinancialTransacCashFlow 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 P_SecClassNormFlowIntRate.
-- 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: PSECCLASSNFIR
-- Parameters: P_KeyDate : vdm_v_key_date

CREATE VIEW P_SecClassNormFlowIntRate AS
SELECT
  TransactionCashFlow.CompanyCode AS CompanyCode,
  TransactionCashFlow.SecurityClass AS SecurityClass,
  TransactionCashFlow.SecurityAccount AS SecurityAccount,
  TransactionCashFlow.CalculationDate AS CalculationDate,
  TransactionCashFlow.TreasuryUpdateType AS TreasuryUpdateType,
  TransactionCashFlow.Counterparty AS Counterparty,
  TransactionCashFlow.DifferentiationPortfolio AS DifferentiationPortfolio,
  TransactionCashFlow.PaymentDate AS PaymentDate,
  TransactionCondition.FinInstrConditoinType AS FinInstrConditoinType,
  TransactionCondition.ConditionItemValidityStartDate AS ConditionItemValidityStartDate,
  TransactionCondition.ContractType AS ContractType,
  TransactionCondition.FinancialInstrProductCategory AS FinancialInstrProductCategory,
  TransactionCondition.CalcDateIsAsEndDateInclusive AS CalcDateIsAsEndDateInclusive,
  TransactionCondition.FinancialInstrumentProductType AS FinancialInstrumentProductType,
  TransactionCondition.FinancialInstrTransactionType AS FinancialInstrTransactionType,
  TransactionCondition.TransactionCurrency AS TransactionCurrency,
  TransactionCondition.ConditionPercentageRate AS ConditionPercentageRate,
  TransactionCondition.ConditionFixAmount AS ConditionFixAmount,
  TransactionCondition.ReferenceInterestRate AS ReferenceInterestRate,
  TransactionCondition.TermStartDate AS TermStartDate,
  TransactionCondition.TermEndDate AS TermEndDate,
  TransactionCashFlow.CashFlowDirection AS CashFlowDirection,
  TransactionCashFlow.NominalCurrency AS NominalCurrency
FROM I_FinancialTransacCashFlow AS TransactionCashFlow
LEFT OUTER JOIN P_SecClassIntCond ON /* join condition not captured in parsed metadata */
;

Learn More