I_FinTransContractActivity

DDL: I_FINTRANSCONTRACTACTIVITY SQL: IFTRCONTRACTACT Type: view COMPOSITE
10 Fields 2 Data Sources

Financial Transaction Contract Activity

I_FinTransContractActivity (Composite)

Package: Explore, extend and adapt the SAP S/4HANA Cloud Private Edition with built-in and side-by-side extension capabilities.

Financial Operations

I_FinTransContractActivity is a Composite CDS View that provides data about "Financial Transaction Contract Activity" in SAP S/4HANA. It reads from 2 data sources (I_FinTransActivity, R_FinTransContractActivity) and exposes 10 fields with key fields CompanyCode, FinancialTransaction, FinancialInstrumentActivity.

SAP Help Documentation

CategoryFinancial Transaction Data
Data CategoryDimension
StatusReleased
Purpose
This CDS view provides access to data of financial transaction contract activity. You can therefore use the data to analyze financial transactions by these attributes. This CDS view provides the prerequisites for answering the following business questions: When was the financial transaction contract activity concluded? Which exhange rate was aggreed on?

Prerequisites
The role must grant display authorization for the following authorization objects and fields: Authorization for Product/Transaction Types ( T_DEAL_PD ) Company Code Product Type Transaction Type Portfolio Authorization ( T_DEAL_PF ) Company Code Portfolio Authorization for Securities Account ( T_DEAL_DP ) Company Code Depot

Structure
The main filters are: Company code Financial transaction Measures and attributes Some important measures and attributes are: Company Code Financial Transaction Transaction Activity Contract Conclusion Date Time of Contract Conclusion Time Zone of Contract Date and Time Rate of Foreign Exchange Transaction

View on SAP Help Portal →

SAP API Hub

StateC1
Line of BusinessFinancial Operations
Application ComponentFIN-FSCM-TRM
CapabilitiesAssociation Target for Defining CDS Entities, Data Source in SQL Select, Data Source for Defining CDS Entities
PackageFinancial Operations for SAP S/4HANA Cloud Private Edition
Description <p>This CDS view provides access to data of financial transaction contract activity. You can therefore use the data to analyze financial transactions by these attributes.</p> <p>This CDS view provides the prerequisites for answering the following business questions:</p> <ul> <li><p>When was the financial transaction contract activity concluded?</p></li> <li><p>Which exhange rate was aggreed on? </p></li> </ul>

Documentation

Data Sources (2)

SourceAliasJoin Type
I_FinTransActivity Activity from
R_FinTransContractActivity Contract inner

Annotations (14)

NameValueLevelField
AbapCatalog.sqlViewName IFTRCONTRACTACT view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AbapCatalog.buffering.status #NOT_ALLOWED view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label Financial Transaction Contract Activity view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
Metadata.allowExtensions false view
Metadata.ignorePropagatedAnnotations true view
VDM.viewType #COMPOSITE view

Fields (10)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode I_FinTransActivity CompanyCode Receiver Company Code
KEY FinancialTransaction I_FinTransActivity FinancialTransaction Financial Transaction
KEY FinancialInstrumentActivity I_FinTransActivity FinancialInstrumentActivity Transaction Activity
FinTransActyConclusionDate I_FinTransActivity FinTransActyConclusionDate Conclusion Date of a Financial Transaction Activity
FinTransActyConclusionTime I_FinTransActivity FinTransActyConclusionTime Time of Contract Conclusion
FinTransActyConclusionTimeZone I_FinTransActivity FinTransActyConclusionTimeZone Time Zone of Contract Date and Time
ExchangeRate I_FinTransActivity ExchangeRate Rate of Foreign Exchange Transaction
_CompanyCode I_FinTransActivity _CompanyCode
_FinTrans I_FinTransActivity _FinTrans
_TimeZone I_FinTransActivity _TimeZone

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 I_FinTransContractActivity.
-- 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: IFTRCONTRACTACT

CREATE VIEW I_FinTransContractActivity AS
SELECT
  Activity.CompanyCode AS CompanyCode,
  Activity.FinancialTransaction AS FinancialTransaction,
  Activity.FinancialInstrumentActivity AS FinancialInstrumentActivity,
  Activity.FinTransActyConclusionDate AS FinTransActyConclusionDate,
  Activity.FinTransActyConclusionTime AS FinTransActyConclusionTime,
  Activity.FinTransActyConclusionTimeZone AS FinTransActyConclusionTimeZone,
  Activity.ExchangeRate AS ExchangeRate,
  Activity._CompanyCode AS _CompanyCode,
  Activity._FinTrans AS _FinTrans,
  Activity._TimeZone AS _TimeZone
FROM I_FinTransActivity AS Activity
INNER JOIN R_FinTransContractActivity AS Contract ON /* join condition not captured in parsed metadata */
;

Learn More