A_FinTransIntrstRateInstr_3

DDL: A_FINTRANSINTRSTRATEINSTR_3 Type: view_entity CONSUMPTION Package: RAP_FIN_TRM_TM_FT_API
26 Fields 1 Data Sources 4 Associations 1 OData Services

Interest Rate Instrument

A_FinTransIntrstRateInstr_3 is a Consumption CDS View that provides data about "Interest Rate Instrument" in SAP S/4HANA. It reads from 1 data source (R_FinancialTransactionTP) and exposes 26 fields with key fields CompanyCode, FinancialTransaction. It has 4 associations to related views. It is exposed through 1 OData service (API_FINTRANSINTRSTRATEINSTR_3). Part of development package RAP_FIN_TRM_TM_FT_API.

Data Sources (1)

SourceAliasJoin Type
R_FinancialTransactionTP R_FinancialTransactionTP projection

Associations (4)

CardinalityTargetAliasCondition
[0..*] A_IntrstRateInstrIntrstAdjmt _InterestRateAdjustment $projection.CompanyCode = _InterestRateAdjustment.CompanyCode and $projection.FinancialTransaction = _InterestRateAdjustment.FinancialTransaction
[0..*] A_IntrstRateInstrFXRateAdjmt _FXRateAdjustment $projection.CompanyCode = _FXRateAdjustment.CompanyCode and $projection.FinancialTransaction = _FXRateAdjustment.FinancialTransaction
[0..*] A_IntrstRateInstrPrcIdxAdjmt _PrcIdxAdjustment $projection.CompanyCode = _PrcIdxAdjustment.CompanyCode and $projection.FinancialTransaction = _PrcIdxAdjustment.FinancialTransaction
[0..*] A_IntrstRateInstrCorrespnc _Correspondence $projection.CompanyCode = _Correspondence.CompanyCode and $projection.FinancialTransaction = _Correspondence.FinancialTransaction

Annotations (10)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
AccessControl.personalData.blocking #NOT_REQUIRED view
EndUserText.label Interest Rate Instrument view
Metadata.ignorePropagatedAnnotations true view
OData.entityType.name FinTransIntrstRateInstr_Type view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
VDM.lifecycle.contract.type #PUBLIC_REMOTE_API view
VDM.viewType #CONSUMPTION view

OData Services (1)

ServiceBindingVersionContractRelease
API_FINTRANSINTRSTRATEINSTR_3

Fields (26)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode CompanyCode Receiver Company Code
KEY FinancialTransaction FinancialTransaction Transaction
FinancialInstrumentActivity FinancialInstrumentActivity
FinancialInstrumentStatus FinancialInstrumentStatus
Counterparty Counterparty Supplier
FinTransActyConclusionDate FinTransActyConclusionDate
FinTransActyConclusionTime FinTransActyConclusionTime
FinTransActyConclusionTimeZone FinTransActyConclusionTimeZone
FinInstrExternalReference FinInstrExternalReference
MarketIdentifierCode MarketIdentifierCode MIC
Trader Trader Trader
FinancialInstrContactPerson FinancialInstrContactPerson
CreatedByUser CreatedByUser User Name
FinTransCreationDate FinTransCreationDate
FinTransCreationTime FinTransCreationTime
LastChangedByUser LastChangedByUser User Name
LastChangeDate LastChangeDate Time Stamp
FinInstrumentLastChangedTime FinInstrumentLastChangedTime
FinancialInstrumentProductType FinancialInstrumentProductType
FinancialInstrTransactionType FinancialInstrTransactionType
ClassificationOfFinInstr ClassificationOfFinInstr
TreasuryFinancialObject TreasuryFinancialObject
_InterestRateAdjustment _InterestRateAdjustment
_FXRateAdjustment _FXRateAdjustment
_PrcIdxAdjustment _PrcIdxAdjustment
_Correspondence _Correspondence

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 A_FinTransIntrstRateInstr_3.
-- 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.

CREATE VIEW A_FinTransIntrstRateInstr_3 AS
SELECT
  CompanyCode,
  FinancialTransaction,
  FinancialInstrumentActivity,
  FinancialInstrumentStatus,
  Counterparty,
  FinTransActyConclusionDate,
  FinTransActyConclusionTime,
  FinTransActyConclusionTimeZone,
  FinInstrExternalReference,
  MarketIdentifierCode,
  Trader,
  FinancialInstrContactPerson,
  CreatedByUser,
  FinTransCreationDate,
  FinTransCreationTime,
  LastChangedByUser,
  LastChangeDate,
  FinInstrumentLastChangedTime,
  FinancialInstrumentProductType,
  FinancialInstrTransactionType,
  ClassificationOfFinInstr,
  TreasuryFinancialObject
FROM R_FinancialTransactionTP
LEFT OUTER JOIN A_IntrstRateInstrIntrstAdjmt AS _InterestRateAdjustment ON CompanyCode = _InterestRateAdjustment.CompanyCode AND FinancialTransaction = _InterestRateAdjustment.FinancialTransaction  -- association [0..*]
LEFT OUTER JOIN A_IntrstRateInstrFXRateAdjmt AS _FXRateAdjustment ON CompanyCode = _FXRateAdjustment.CompanyCode AND FinancialTransaction = _FXRateAdjustment.FinancialTransaction  -- association [0..*]
LEFT OUTER JOIN A_IntrstRateInstrPrcIdxAdjmt AS _PrcIdxAdjustment ON CompanyCode = _PrcIdxAdjustment.CompanyCode AND FinancialTransaction = _PrcIdxAdjustment.FinancialTransaction  -- association [0..*]
LEFT OUTER JOIN A_IntrstRateInstrCorrespnc AS _Correspondence ON CompanyCode = _Correspondence.CompanyCode AND FinancialTransaction = _Correspondence.FinancialTransaction  -- association [0..*]
;

Learn More