I_CommodityHedgeTransaction

DDL: I_COMMODITYHEDGETRANSACTION SQL: ICMMHDGFITRANS Type: view BASIC Package: FIN_CMM_CMDTY_HEDGE_SPEC
26 Fields 1 Data Sources

Financial Transaction Details

I_CommodityHedgeTransaction is a Basic CDS View that provides data about "Financial Transaction Details" in SAP S/4HANA. It reads from 1 data source (vtbfha) and exposes 26 fields with key fields FinTransactionCompanyCode, FinTransactionDealIdentifier. Part of development package FIN_CMM_CMDTY_HEDGE_SPEC.

Data Sources (1)

SourceAliasJoin Type
vtbfha Transaction from

Annotations (10)

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

Fields (26)

KeyFieldSource TableSource FieldDescription
KEY FinTransactionCompanyCode vtbfha bukrs Value
KEY FinTransactionDealIdentifier vtbfha rfha Transaction
FinTransactionProductCategory vtbfha sanlf Prod. Category
FinTransactionObjectNumber vtbfha objnr Val. Obj. No.
FinTransactionProductType vtbfha sgsart Product Type
FinancialInstrumentActivity vtbfha rfhazul Active activity
FinTransFactoryCalendar1 vtbfha skalid Calendar
FinTransFactoryCalendar2 vtbfha skalid2 Calendar ID 2
FinancialInstrumentStatus vtbfha saktiv Active Status
FinTransactionCounterparty vtbfha kontrh Partner
FinancialInstrumentProductType vtbfha sgsart Product Type
FinancialInstrTransactionType vtbfha sfhaart Transactn Type
FinancialTransactionHedgeBook vtbfha hedge_book Hedge Book
FinancialTransactionPortfolio vtbfha rportb Portfolio
FinTransGeneralValuationClass vtbfha rcomvalcl2 Gen. Valn Class
FinancialTransactionAssignment vtbfha zuond Assignment
FinTransInternalReference vtbfha refer Reference
FinTransactionCharacteristic vtbfha merkm Characteristics
ContractStartDate vtbfha dblfz Term Start
ContractEndDate vtbfha delfz Term End
OptionUnderlyingActivity vtbfha rfhazul Active activity
HedgeRequestIdentifier vtbfha hedge_request_id Hedge Request ID
CmmdtyHdgSpecificationID vtbfha hedge_specification_id Hedge Spec. ID
CmmdtyHdgSpecQuotaOrderID vtbfha hedge_spec_order_id Order ID
HdggArHedgingClassification vtbfha hedge_class Hedging Classificatn
FinTransOnBehalfOfCompany vtbfha behalf_of_company On Behalf of CoCode

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_CommodityHedgeTransaction.
-- 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: ICMMHDGFITRANS

CREATE VIEW I_CommodityHedgeTransaction AS
SELECT
  Transaction.bukrs AS FinTransactionCompanyCode,
  Transaction.rfha AS FinTransactionDealIdentifier,
  Transaction.sanlf AS FinTransactionProductCategory,
  Transaction.objnr AS FinTransactionObjectNumber,
  Transaction.sgsart AS FinTransactionProductType,
  Transaction.rfhazul AS FinancialInstrumentActivity,
  Transaction.skalid AS FinTransFactoryCalendar1,
  Transaction.skalid2 AS FinTransFactoryCalendar2,
  Transaction.saktiv AS FinancialInstrumentStatus,
  Transaction.kontrh AS FinTransactionCounterparty,
  Transaction.sgsart AS FinancialInstrumentProductType,
  Transaction.sfhaart AS FinancialInstrTransactionType,
  Transaction.hedge_book AS FinancialTransactionHedgeBook,
  Transaction.rportb AS FinancialTransactionPortfolio,
  Transaction.rcomvalcl2 AS FinTransGeneralValuationClass,
  Transaction.zuond AS FinancialTransactionAssignment,
  Transaction.refer AS FinTransInternalReference,
  Transaction.merkm AS FinTransactionCharacteristic,
  Transaction.dblfz AS ContractStartDate,
  Transaction.delfz AS ContractEndDate,
  Transaction.rfhazul AS OptionUnderlyingActivity,
  Transaction.hedge_request_id AS HedgeRequestIdentifier,
  Transaction.hedge_specification_id AS CmmdtyHdgSpecificationID,
  Transaction.hedge_spec_order_id AS CmmdtyHdgSpecQuotaOrderID,
  Transaction.hedge_class AS HdggArHedgingClassification,
  Transaction.behalf_of_company AS FinTransOnBehalfOfCompany
FROM vtbfha AS Transaction
;

Learn More