I_CmmdtyHdgTransActyHistory

DDL: I_CMMDTYHDGTRANSACTYHISTORY SQL: ICMMDTYTRANACTHI Type: view BASIC
6 Fields 1 Data Sources

Transaction Flow

I_CmmdtyHdgTransActyHistory is a Basic CDS View that provides data about "Transaction Flow" in SAP S/4HANA. It reads from 1 data source (vtbfhazu) and exposes 6 fields with key fields FinTransactionCompanyCode, FinTransactionDealIdentifier, FinancialInstrumentActivity.

Data Sources (1)

SourceAliasJoin Type
vtbfhazu FinTransActivity from

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName ICMMDTYTRANACTHI view
AbapCatalog.compiler.compareFilter true view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Transaction Flow view
VDM.viewType #BASIC view

Fields (6)

KeyFieldSource TableSource FieldDescription
KEY FinTransactionCompanyCode vtbfhazu bukrs Value
KEY FinTransactionDealIdentifier vtbfhazu rfha Transaction
KEY FinancialInstrumentActivity vtbfhazu rfhazu Activity
CmmdtyHdgFrgnExchTradeRate vtbfhazu kkurs Rate
CmmdtyHdgCalcdTradeCurrency
FinTransPaytRateLdngCurrency vtbfhazu wlwaers Lead. Currency

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_CmmdtyHdgTransActyHistory.
-- 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: ICMMDTYTRANACTHI

CREATE VIEW I_CmmdtyHdgTransActyHistory AS
SELECT
  FinTransActivity.bukrs AS FinTransactionCompanyCode,
  FinTransActivity.rfha AS FinTransactionDealIdentifier,
  FinTransActivity.rfhazu AS FinancialInstrumentActivity,
  FinTransActivity.kkurs AS CmmdtyHdgFrgnExchTradeRate,
  cast( FinTransActivity.wfwaers as cmm_hdg_waers ) AS CmmdtyHdgCalcdTradeCurrency,
  FinTransActivity.wlwaers AS FinTransPaytRateLdngCurrency
FROM vtbfhazu AS FinTransActivity
;

Learn More