I_CmmdtyHdgFinTransaction

DDL: I_CMMDTYHDGFINTRANSACTION SQL: ICMMHDGFINTR Type: view COMPOSITE
39 Fields 2 Data Sources 7 Associations

Basic for Financial Transaction

I_CmmdtyHdgFinTransaction is a Composite CDS View that provides data about "Basic for Financial Transaction" in SAP S/4HANA. It reads from 2 data sources (I_FinTransActivity, I_CmmdtyHdgFinTransActivity) and exposes 39 fields with key fields FinTransactionCompanyCode, FinTransactionDealIdentifier. It has 7 associations to related views.

Data Sources (2)

SourceAliasJoin Type
I_FinTransActivity FinTransActivity inner
I_CmmdtyHdgFinTransActivity Transaction from

Associations (7)

CardinalityTargetAliasCondition
[1..1] I_FinancialInstrProdTypeText _ProdTypeText $projection.FinTransactionProductType = _ProdTypeText.FinancialInstrumentProductType and _ProdTypeText.Language = $session.system_language
[1..1] I_FinancialInstrTransTypeText _TransactionTypeText $projection.FinTransactionProductType = _TransactionTypeText.FinancialInstrumentProductType and $projection.FinancialInstrTransactionType = _TransactionTypeText.FinancialInstrTransactionType and _TransactionTypeText.Language = $session.system_language
[1..1] I_CompanyCode _CompanyCode $projection.FinTransactionCompanyCode = _CompanyCode.CompanyCode
[1..1] I_DerivativeContractSpecText _DerivativeContractSpecText $projection.FinancialTransactionDCSID = _DerivativeContractSpecText.DerivativeContrSpecification and _DerivativeContractSpecText.Language = $session.system_language
[1..1] I_BusinessPartner _BusinessPartner $projection.FinTransactionCounterparty = _BusinessPartner.BusinessPartner
[1..1] I_TreasuryPortfolio _Portfolio $projection.FinancialTransactionPortfolio = _Portfolio.Portfolio and $projection.FinTransactionCompanyCode = _Portfolio.CompanyCode
[1..1] I_TreasuryHedgingClassfctn _HedgingClassification $projection.FinTransHedgingClassification = _HedgingClassification.HedgingClassification

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName ICMMHDGFINTR view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label Basic for Financial Transaction view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.serviceQuality #D view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #COMPOSITE view

Fields (39)

KeyFieldSource TableSource FieldDescription
KEY FinTransactionCompanyCode I_CmmdtyHdgFinTransActivity FinTransactionCompanyCode Value
KEY FinTransactionDealIdentifier I_CmmdtyHdgFinTransActivity FinTransactionDealIdentifier Transaction
FinTransactionProductCategory I_CmmdtyHdgFinTransActivity FinTransactionProductCategory Prod. Category
FinTransactionObjectNumber I_CmmdtyHdgFinTransActivity FinTransactionObjectNumber Val. Obj. No.
FinTransactionProductType I_CmmdtyHdgFinTransActivity FinTransactionProductType Product Type
FinTransFactoryCalendar1 I_CmmdtyHdgFinTransActivity FinTransFactoryCalendar1 Calendar
FinTransFactoryCalendar2 I_CmmdtyHdgFinTransActivity FinTransFactoryCalendar2 Calendar ID 2
FinancialInstrumentStatus I_CmmdtyHdgFinTransActivity FinancialInstrumentStatus Active Status
FinTransContractStartDate I_FinTransActivity FinTransActyConclusionDate
FinTransContractStartTime I_FinTransActivity FinTransActyConclusionTime ContrConcTime
FinTransactionCounterparty I_CmmdtyHdgFinTransActivity FinTransactionCounterparty Partner
FinancialInstrTransactionType I_CmmdtyHdgFinTransActivity FinancialInstrTransactionType Transactn Type
FinTransHedgingClassification I_CmmdtyHdgFinTransActivity FinTransHedgingClassification Hedging Classificatn
FinTransOnBehalfOfCompany I_CmmdtyHdgFinTransActivity FinTransOnBehalfOfCompany On Behalf of CoCode
FinancialTransactionQuantity FinTransFlow Quantity Value
FinTransactionQuantityUnit FinTransFlow UnitOfMeasure Unit Protected Qty
FinTransFlowPaymentDate FinTransFlow FinTransFlowPaymentDate
FinancialTransactionDCSID FinTransFlow DerivativeContrSpecification DCS ID
FinTransactionPricingStartDate FinTransFlow FinTransactionPricingStartDate
FinTransactionPricingEndDate FinTransFlow FinTransactionPricingEndDate
FinancialTransactionHedgeBook I_CmmdtyHdgFinTransActivity FinancialTransactionHedgeBook Hedge Book
FinTransacTradedPriceAmount FinTransFlow FinTransacTradedPriceAmount
CommodityPriceExposureUnit FinTransFlow CommodityPriceExposureUnit
FinTransTradedPriceCrcyUnit FinTransFlow FinTransTradedPriceCrcyUnit
TermEndDate I_CmmdtyHdgFinTransActivity TermEndDate Term End
FinancialTransactionAmount FinTransFlow FinancialTransactionAmount
FinTransFlowPaytAmtCrcy FinTransFlow FinTransFlowPaytAmtCrcy
FinancialTransactionPortfolio I_CmmdtyHdgFinTransActivity FinancialTransactionPortfolio Portfolio
FinTransGeneralValuationClass I_CmmdtyHdgFinTransActivity FinTransGeneralValuationClass Gen. Valn Class
FinancialTransactionAssignment I_CmmdtyHdgFinTransActivity FinancialTransactionAssignment Assignment
FinTransInternalReference I_CmmdtyHdgFinTransActivity FinTransInternalReference Reference
FinTransactionCharacteristic I_CmmdtyHdgFinTransActivity FinTransactionCharacteristic Characteristics
_DerivativeContractSpecText _DerivativeContractSpecText
_ProdTypeText _ProdTypeText
_CompanyCode _CompanyCode
_BusinessPartner _BusinessPartner
_Portfolio _Portfolio
_HedgingClassification _HedgingClassification
_TransactionTypeText _TransactionTypeText

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_CmmdtyHdgFinTransaction.
-- 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: ICMMHDGFINTR

CREATE VIEW I_CmmdtyHdgFinTransaction AS
SELECT
  Transaction.FinTransactionCompanyCode AS FinTransactionCompanyCode,
  Transaction.FinTransactionDealIdentifier AS FinTransactionDealIdentifier,
  Transaction.FinTransactionProductCategory AS FinTransactionProductCategory,
  Transaction.FinTransactionObjectNumber AS FinTransactionObjectNumber,
  Transaction.FinTransactionProductType AS FinTransactionProductType,
  Transaction.FinTransFactoryCalendar1 AS FinTransFactoryCalendar1,
  Transaction.FinTransFactoryCalendar2 AS FinTransFactoryCalendar2,
  Transaction.FinancialInstrumentStatus AS FinancialInstrumentStatus,
  FinTransActivity.FinTransActyConclusionDate AS FinTransContractStartDate,
  FinTransActivity.FinTransActyConclusionTime AS FinTransContractStartTime,
  Transaction.FinTransactionCounterparty AS FinTransactionCounterparty,
  Transaction.FinancialInstrTransactionType AS FinancialInstrTransactionType,
  Transaction.FinTransHedgingClassification AS FinTransHedgingClassification,
  Transaction.FinTransOnBehalfOfCompany AS FinTransOnBehalfOfCompany,
  FinTransFlow.Quantity AS FinancialTransactionQuantity,
  FinTransFlow.UnitOfMeasure AS FinTransactionQuantityUnit,
  FinTransFlow.FinTransFlowPaymentDate AS FinTransFlowPaymentDate,
  FinTransFlow.DerivativeContrSpecification AS FinancialTransactionDCSID,
  FinTransFlow.FinTransactionPricingStartDate AS FinTransactionPricingStartDate,
  FinTransFlow.FinTransactionPricingEndDate AS FinTransactionPricingEndDate,
  Transaction.FinancialTransactionHedgeBook AS FinancialTransactionHedgeBook,
  FinTransFlow.FinTransacTradedPriceAmount AS FinTransacTradedPriceAmount,
  FinTransFlow.CommodityPriceExposureUnit AS CommodityPriceExposureUnit,
  FinTransFlow.FinTransTradedPriceCrcyUnit AS FinTransTradedPriceCrcyUnit,
  Transaction.TermEndDate AS TermEndDate,
  FinTransFlow.FinancialTransactionAmount AS FinancialTransactionAmount,
  FinTransFlow.FinTransFlowPaytAmtCrcy AS FinTransFlowPaytAmtCrcy,
  Transaction.FinancialTransactionPortfolio AS FinancialTransactionPortfolio,
  Transaction.FinTransGeneralValuationClass AS FinTransGeneralValuationClass,
  Transaction.FinancialTransactionAssignment AS FinancialTransactionAssignment,
  Transaction.FinTransInternalReference AS FinTransInternalReference,
  Transaction.FinTransactionCharacteristic AS FinTransactionCharacteristic
FROM I_CmmdtyHdgFinTransActivity AS Transaction
INNER JOIN I_FinTransActivity AS FinTransActivity ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_FinancialInstrProdTypeText AS _ProdTypeText ON FinTransactionProductType = _ProdTypeText.FinancialInstrumentProductType AND _ProdTypeText.Language = $session.system_language  -- association [1..1]
LEFT OUTER JOIN I_FinancialInstrTransTypeText AS _TransactionTypeText ON FinTransactionProductType = _TransactionTypeText.FinancialInstrumentProductType AND FinancialInstrTransactionType = _TransactionTypeText.FinancialInstrTransactionType AND _TransactionTypeText.Language = $session.system_language  -- association [1..1]
LEFT OUTER JOIN I_CompanyCode AS _CompanyCode ON FinTransactionCompanyCode = _CompanyCode.CompanyCode  -- association [1..1]
LEFT OUTER JOIN I_DerivativeContractSpecText AS _DerivativeContractSpecText ON FinancialTransactionDCSID = _DerivativeContractSpecText.DerivativeContrSpecification AND _DerivativeContractSpecText.Language = $session.system_language  -- association [1..1]
LEFT OUTER JOIN I_BusinessPartner AS _BusinessPartner ON FinTransactionCounterparty = _BusinessPartner.BusinessPartner  -- association [1..1]
LEFT OUTER JOIN I_TreasuryPortfolio AS _Portfolio ON FinancialTransactionPortfolio = _Portfolio.Portfolio AND FinTransactionCompanyCode = _Portfolio.CompanyCode  -- association [1..1]
LEFT OUTER JOIN I_TreasuryHedgingClassfctn AS _HedgingClassification ON FinTransHedgingClassification = _HedgingClassification.HedgingClassification  -- association [1..1]
;

Learn More