A_IntrstRateInstrFXRateAdjmt

DDL: A_INTRSTRATEINSTRFXRATEADJMT Type: view_entity CONSUMPTION Package: RAP_FIN_TRM_TM_FT_API
17 Fields 1 Data Sources 2 OData Services

Foreign Exchange Rate Adjustment

A_IntrstRateInstrFXRateAdjmt is a Consumption CDS View that provides data about "Foreign Exchange Rate Adjustment" in SAP S/4HANA. It reads from 1 data source (I_FinTransFXRateAdjustment) and exposes 17 fields with key fields CompanyCode, FinancialTransaction, FXRateAdjustmentCashFlowCode, FXRateAdjustmentFixingDate, ForeignExchangeFixingReference. It is exposed through 2 OData services (API_FINTRANSINTRSTRATEINSTR_2, API_FINTRANSINTRSTRATEINSTR_3). Part of development package RAP_FIN_TRM_TM_FT_API.

Data Sources (1)

SourceAliasJoin Type
I_FinTransFXRateAdjustment I_FinTransFXRateAdjustment from

Annotations (10)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
AccessControl.personalData.blocking #NOT_REQUIRED view
EndUserText.label Foreign Exchange Rate Adjustment view
Metadata.ignorePropagatedAnnotations true view
OData.entityType.name FXRateAdjustment_Type view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.dataClass #MASTER view
VDM.lifecycle.contract.type #PUBLIC_REMOTE_API view
VDM.viewType #CONSUMPTION view

OData Services (2)

ServiceBindingVersionContractRelease
API_FINTRANSINTRSTRATEINSTR_2
API_FINTRANSINTRSTRATEINSTR_3

Fields (17)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode CompanyCode Receiver Company Code
KEY FinancialTransaction FinancialTransaction Transaction
KEY FXRateAdjustmentCashFlowCode FXRateAdjustmentCashFlowCode
KEY FXRateAdjustmentFixingDate FXRateAdjustmentFixingDate
KEY ForeignExchangeFixingReference ForeignExchangeFixingReference
LeadingCurrency LeadingCurrency Local Currency
FollowingCurrency FollowingCurrency From currency
FXRateAdjustmentFixingRate FXRateAdjustmentFixingRate FX Rate
FXRateAdjustmentLdngCrcyFactor FXRateAdjustmentLdngCrcyFactor
FXRateAdjustmentFllwngCrcyFctr FXRateAdjustmentFllwngCrcyFctr
FXRateAdjustmentFixedByUser FXRateAdjustmentFixedByUser
FXRateAdjustmentEffctvFrmDate FXRateAdjustmentEffctvFrmDate Term From
FXRateAdjustmentStatus FXRateAdjustmentStatus
FXRateAdjustmentTrigger FXRateAdjustmentTrigger
FXRateAdjustmentCreatedDate FXRateAdjustmentCreatedDate Fixing Date
FXRateAdjustmentCreatedTime FXRateAdjustmentCreatedTime Fixing time
_FinTrans _FinTrans

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_IntrstRateInstrFXRateAdjmt.
-- 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_IntrstRateInstrFXRateAdjmt AS
SELECT
  CompanyCode,
  FinancialTransaction,
  FXRateAdjustmentCashFlowCode,
  FXRateAdjustmentFixingDate,
  ForeignExchangeFixingReference,
  LeadingCurrency,
  FollowingCurrency,
  FXRateAdjustmentFixingRate,
  FXRateAdjustmentLdngCrcyFactor,
  FXRateAdjustmentFllwngCrcyFctr,
  FXRateAdjustmentFixedByUser,
  FXRateAdjustmentEffctvFrmDate,
  FXRateAdjustmentStatus,
  FXRateAdjustmentTrigger,
  FXRateAdjustmentCreatedDate,
  FXRateAdjustmentCreatedTime
FROM I_FinTransFXRateAdjustment
;

Learn More