P_IRM_Financial_Transaction

DDL: P_IRM_FINANCIAL_TRANSACTION SQL: PFINTRANS Type: view BASIC
16 Fields 2 Data Sources 3 Associations

P_IRM_Financial_Transaction is a Basic CDS View in SAP S/4HANA. It reads from 2 data sources (vtbfha, vtbfhazu) and exposes 16 fields with key fields CompanyCode, FinancialTransaction, FinancialInstrumentActivity. It has 3 associations to related views.

Data Sources (2)

SourceAliasJoin Type
vtbfha FinancialTransaction from
vtbfhazu TransactionHistory inner

Associations (3)

CardinalityTargetAliasCondition
[1..1] I_Currency _Currency $projection.TransactionCurrency = _Currency.Currency
[1..1] I_CompanyCode _CompanyCode $projection.CompanyCode = _CompanyCode.CompanyCode
[1..1] I_SecurityAccount _SecurityAccount $projection.CompanyCode = _SecurityAccount.CompanyCode and $projection.SecurityAccount = _SecurityAccount.SecurityAccount

Annotations (7)

NameValueLevelField
AbapCatalog.sqlViewName PFINTRANS view
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
AbapCatalog.preserveKey true view
VDM.viewType #BASIC view
VDM.private true view

Fields (16)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode vtbfha bukrs Value
KEY FinancialTransaction vtbfha rfha Transaction
KEY FinancialInstrumentActivity vtbfha rfhazul Active activity
TreasuryContractType vtbfha rantyp Contract Type
FinancialInstrProductCategory
FinancialInstrumentProductType vtbfha sgsart Product Type
FinancialInstrTransactionType
Counterparty
DifferentiationPortfolio vtbfha rportb Portfolio
TransactionCurrency vtbfha wgschft Trans. Crcy
SecurityAccount vtbfha rldepo Securities Acct
TermStartDate vtbfha dblfz Term Start
TermEndDate vtbfhazu delfz Term End
_Currency _Currency
_CompanyCode _CompanyCode
_SecurityAccount _SecurityAccount

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_IRM_Financial_Transaction.
-- 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: PFINTRANS

CREATE VIEW P_IRM_Financial_Transaction AS
SELECT
  FinancialTransaction.bukrs AS CompanyCode,
  FinancialTransaction.rfha AS FinancialTransaction,
  FinancialTransaction.rfhazul AS FinancialInstrumentActivity,
  FinancialTransaction.rantyp AS TreasuryContractType,
  cast(FinancialTransaction.sanlf as ftr_gen_fin_instr_prod_categ) AS FinancialInstrProductCategory,
  FinancialTransaction.sgsart AS FinancialInstrumentProductType,
  cast(FinancialTransaction.sfhaart as ftr_gen_transaction_type) AS FinancialInstrTransactionType,
  cast(FinancialTransaction.kontrh as rkontrah_new) AS Counterparty,
  FinancialTransaction.rportb AS DifferentiationPortfolio,
  FinancialTransaction.wgschft AS TransactionCurrency,
  FinancialTransaction.rldepo AS SecurityAccount,
  FinancialTransaction.dblfz AS TermStartDate,
  TransactionHistory.delfz AS TermEndDate
FROM vtbfha AS FinancialTransaction
INNER JOIN vtbfhazu AS TransactionHistory ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_Currency AS _Currency ON TransactionCurrency = _Currency.Currency  -- association [1..1]
LEFT OUTER JOIN I_CompanyCode AS _CompanyCode ON CompanyCode = _CompanyCode.CompanyCode  -- association [1..1]
LEFT OUTER JOIN I_SecurityAccount AS _SecurityAccount ON CompanyCode = _SecurityAccount.CompanyCode AND SecurityAccount = _SecurityAccount.SecurityAccount  -- association [1..1]
;

Learn More