I_CmmdtyHdgFinTransActivity

DDL: I_CMMDTYHDGFINTRANSACTIVITY SQL: ICMMHDGFINTRA Type: view COMPOSITE
39 Fields 3 Data Sources

Basic for Transaction Table

I_CmmdtyHdgFinTransActivity is a Composite CDS View that provides data about "Basic for Transaction Table" in SAP S/4HANA. It reads from 3 data sources (P_CmmdtyFinTransFlowCount, vtbfha, vtbfha) and exposes 39 fields with key fields FinTransactionCompanyCode, FinTransactionDealIdentifier, FinTransactionDealIdentifier.

Data Sources (3)

SourceAliasJoin Type
P_CmmdtyFinTransFlowCount FlCnt inner
vtbfha Transaction from
vtbfha Transaction union_all

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName ICMMHDGFINTRA view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
AccessControl.personalData.blocking #BLOCKED_DATA_EXCLUDED view
EndUserText.label Basic for Transaction Table view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.serviceQuality #C view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #COMPOSITE view

Fields (39)

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
FinTransFactoryCalendar1 vtbfha skalid Calendar
FinTransFactoryCalendar2 vtbfha skalid2 Calendar ID 2
FinancialInstrumentStatus vtbfha saktiv Active Status
FinTransactionCounterparty vtbfha kontrh Partner
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
TermEndDate vtbfha delfz Term End
OptionUnderlyingActivity vtbfha rfhazul Active activity
FinTransHedgingClassification vtbfha hedge_class Hedging Classificatn
bukrsasFinTransactionCompanyCode
KEY FinTransactionDealIdentifier vtbfha rfha Transaction
FinTransactionProductCategory vtbfha sanlf Prod. Category
FinTransactionObjectNumber vtbfha objnr Val. Obj. No.
FinTransactionProductType vtbfha sgsart Product Type
FinTransFactoryCalendar1 vtbfha skalid Calendar
FinTransFactoryCalendar2 vtbfha skalid2 Calendar ID 2
FinancialInstrumentStatus vtbfha saktiv Active Status
FinTransactionCounterparty vtbfha kontrh Partner
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
TermEndDate vtbfha delfz Term End
OptionUnderlyingActivity vtbfha rfhazul Active activity
FinTransHedgingClassification 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_CmmdtyHdgFinTransActivity.
-- 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: ICMMHDGFINTRA

CREATE VIEW I_CmmdtyHdgFinTransActivity AS
SELECT
  Transaction.bukrs AS FinTransactionCompanyCode,
  Transaction.rfha AS FinTransactionDealIdentifier,
  Transaction.sanlf AS FinTransactionProductCategory,
  Transaction.objnr AS FinTransactionObjectNumber,
  Transaction.sgsart AS FinTransactionProductType,
  Transaction.skalid AS FinTransFactoryCalendar1,
  Transaction.skalid2 AS FinTransFactoryCalendar2,
  Transaction.saktiv AS FinancialInstrumentStatus,
  Transaction.kontrh AS FinTransactionCounterparty,
  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.delfz AS TermEndDate,
  Transaction.rfhazul AS OptionUnderlyingActivity,
  Transaction.hedge_class AS FinTransHedgingClassification,
  Transaction.behalf_of_company as FinTransOnBehalfOfCompany AS bukrsasFinTransactionCompanyCode,
  Transaction.behalf_of_company AS FinTransOnBehalfOfCompany
FROM vtbfha AS Transaction
INNER JOIN P_CmmdtyFinTransFlowCount AS FlCnt ON /* join condition not captured in parsed metadata */
-- UNION ALL with additional select branch(es): vtbfha
;

Learn More