I_CmmdtyHdgFinTransActivity

@AbapCatalog.sqlViewName: 'ICMMHDGFINTRA'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@AccessControl.personalData.blocking: #BLOCKED_DATA_EXCLUDED
@EndUserText.label: 'Basic for Transaction Table'
@ObjectModel: { usageType.dataClass: #TRANSACTIONAL,
                usageType.sizeCategory: #L,
                usageType.serviceQuality: #C }
@ClientHandling.algorithm: #SESSION_VARIABLE
@VDM: { viewType: #COMPOSITE}
define view I_CmmdtyHdgFinTransActivity
  as select from vtbfha                    as Transaction
    inner join   P_CmmdtyFinTransFlowCount as FlCnt on  FlCnt.CompanyCode                 = Transaction.bukrs
                                                    and FlCnt.FinancialTransaction        = Transaction.rfha
                                                    and FlCnt.FinTransactionNumberOfFlows = 1
{
  key     Transaction.bukrs             as FinTransactionCompanyCode,
  key     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
}
where
     Transaction.sanlf = '800'
  or Transaction.sanlf = '810'

union all select from vtbfha as Transaction
{
  key     Transaction.bukrs             as FinTransactionCompanyCode,
  key     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
}
where
  Transaction.sanlf = '600'
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"P_CMMDTYFINTRANSFLOWCOUNT",
"VTBFHA"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/