I_FinancialTransactionStdVH

DDL: I_FINANCIALTRANSACTIONSTDVH SQL: IFTRFT__VH Type: view COMPOSITE
17 Fields 1 Data Sources 2 Associations

FinancialTransaction

I_FinancialTransactionStdVH is a Composite CDS View that provides data about "FinancialTransaction" in SAP S/4HANA. It reads from 1 data source (I_FinancialTransaction) and exposes 17 fields with key fields FinancialTransaction, CompanyCode. It has 2 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_FinancialTransaction I_FinancialTransaction from

Associations (2)

CardinalityTargetAliasCondition
[0..1] I_UserContactCard _CreatedBy $projection.CreatedByUser = _CreatedBy.ContactCardID
[0..1] I_UserContactCard _LastChangedBy $projection.LastChangedByUser = _LastChangedBy.ContactCardID

Annotations (15)

NameValueLevelField
AbapCatalog.sqlViewName IFTRFT__VH view
AbapCatalog.compiler.compareFilter true view
VDM.viewType #COMPOSITE view
ObjectModel.dataCategory #VALUE_HELP view
ObjectModel.representativeKey FinancialTransaction view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
AccessControl.authorizationCheck #CHECK view
ClientHandling.algorithm #SESSION_VARIABLE view
Metadata.ignorePropagatedAnnotations true view
EndUserText.label FinancialTransaction view
Consumption.ranked true view
Search.searchable true view
AccessControl.personalData.blocking #NOT_REQUIRED view

Fields (17)

KeyFieldSource TableSource FieldDescription
KEY FinancialTransaction FinancialTransaction Transaction
KEY CompanyCode CompanyCode Receiver Company Code
FinancialInstrTransactionType FinancialInstrTransactionType
FinancialInstrumentProductType FinancialInstrumentProductType Product Type
Counterparty Counterparty Supplier
CreatedByUser CreatedByUser User Name
CreatedByUserDescription _CreatedBy FullName Created By
FinTransCreationDate FinTransCreationDate
LastChangedByUser LastChangedByUser User Name
LastChangedByUserDescription _LastChangedBy FullName Last Changed By
LastChangeDate LastChangeDate Time Stamp
FinancialInstrumentStatus FinancialInstrumentStatus Active Status
Portfolio Portfolio Portfolio
SecurityAccount SecurityAccount
_CreatedBy _CreatedBy
_LastChangedBy _LastChangedBy
_CompanyCode _CompanyCode

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_FinancialTransactionStdVH.
-- 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: IFTRFT__VH

CREATE VIEW I_FinancialTransactionStdVH AS
SELECT
  FinancialTransaction,
  CompanyCode,
  FinancialInstrTransactionType,
  FinancialInstrumentProductType,
  Counterparty,
  CreatedByUser,
  _CreatedBy.FullName AS CreatedByUserDescription,
  FinTransCreationDate,
  LastChangedByUser,
  _LastChangedBy.FullName AS LastChangedByUserDescription,
  LastChangeDate,
  FinancialInstrumentStatus,
  Portfolio,
  SecurityAccount
FROM I_FinancialTransaction
LEFT OUTER JOIN I_UserContactCard AS _CreatedBy ON CreatedByUser = _CreatedBy.ContactCardID  -- association [0..1]
LEFT OUTER JOIN I_UserContactCard AS _LastChangedBy ON LastChangedByUser = _LastChangedBy.ContactCardID  -- association [0..1]
;

Learn More