P_CmmdtyFinTransactionHeader

DDL: P_CMMDTYFINTRANSACTIONHEADER Type: view COMPOSITE

P_CmmdtyFinTransactionHeader is a Composite CDS View in SAP S/4HANA. It reads from 1 data source (vtbfha) and exposes 24 fields with key fields CompanyCode, FinancialTransaction. It has 4 associations to related views.

1 data source(s) 24 fields

Data Sources (1)

SourceAliasJoin Type
vtbfha FinTran_Header from

Associations (4)

CardinalityTargetAliasCondition
[1..1] I_FinancialTransaction _FinTran $projection.CompanyCode = _FinTran.CompanyCode and $projection.FinancialTransaction = _FinTran.FinancialTransaction
[1..1] I_CompanyCode _CompanyCode $projection.CompanyCode = _CompanyCode.CompanyCode
[1..1] I_FinancialinstrProductType _ProductType $projection.FinancialInstrumentProductType = _ProductType.FinancialInstrumentProductType
[1..1] I_BusinessPartner _Counterparty $projection.Counterparty = _Counterparty.BusinessPartner

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName PCMMFTRANSHDR view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
VDM.viewType #COMPOSITE view
VDM.private true view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ClientHandling.algorithm #SESSION_VARIABLE view

Fields (24)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode vtbfha bukrs
KEY FinancialTransaction vtbfha rfha
FinInstrLastActiveActivity
FinancialInstrumentStatus vtbfha saktiv
CreatedByUser vtbfha cruser
FinTransCreationDate vtbfha dcrdat
FinTransCreationTime vtbfha tcrtim
LastChangedByUser vtbfha upuser
LastChangeDate vtbfha dupdat
FinInstrumentLastChangedTime vtbfha tuptim
TermStartDate vtbfha dblfz
TermEndDate vtbfha delfz
FinancialInstrProductCategory
FinInstrTransactionCategory vtbfha sfgtyp
FinancialInstrumentProductType vtbfha sgsart
FinancialInstrTransactionType vtbfha sfhaart
Counterparty
FinancialTransactionHedgeBook vtbfha hedge_book
FinancialTransactionPortfolio vtbfha rportb
FinTransHedgingClassification vtbfha hedge_class
_FinTran _FinTran
_CompanyCode _CompanyCode
_ProductType _ProductType
_Counterparty _Counterparty 
@AbapCatalog: { sqlViewName:            'PCMMFTRANSHDR',
                compiler.compareFilter: true }

@AccessControl.authorizationCheck: #NOT_REQUIRED

@VDM: { viewType: #COMPOSITE,
        private: true }

@ObjectModel.usageType: { serviceQuality: #C,
                          sizeCategory:   #L,
                          dataClass:      #TRANSACTIONAL }

@ClientHandling.algorithm: #SESSION_VARIABLE

//@EndUserText.label: 'Commodity Financial Transaction Header'


define view P_CmmdtyFinTransactionHeader

  as select from vtbfha as FinTran_Header

  association [1..1] to I_FinancialTransaction      as _FinTran      on  $projection.CompanyCode          = _FinTran.CompanyCode
                                                                     and $projection.FinancialTransaction = _FinTran.FinancialTransaction
  association [1..1] to I_CompanyCode               as _CompanyCode  on  $projection.CompanyCode = _CompanyCode.CompanyCode
  association [1..1] to I_FinancialinstrProductType as _ProductType  on  $projection.FinancialInstrumentProductType = _ProductType.FinancialInstrumentProductType
  association [1..1] to I_BusinessPartner           as _Counterparty on  $projection.Counterparty = _Counterparty.BusinessPartner
{
  key FinTran_Header.bukrs                                                           as CompanyCode,
  key FinTran_Header.rfha                                                            as FinancialTransaction,

      cast(FinTran_Header.rfhazul as ftr_gen_fin_instr_last_act_act preserving type) as FinInstrLastActiveActivity,
      FinTran_Header.saktiv                                                          as FinancialInstrumentStatus,

      FinTran_Header.cruser                                                          as CreatedByUser,
      FinTran_Header.dcrdat                                                          as FinTransCreationDate,
      FinTran_Header.tcrtim                                                          as FinTransCreationTime,

      FinTran_Header.upuser                                                          as LastChangedByUser,
      FinTran_Header.dupdat                                                          as LastChangeDate,
      FinTran_Header.tuptim                                                          as FinInstrumentLastChangedTime,

      FinTran_Header.dblfz                                                           as TermStartDate,
      FinTran_Header.delfz                                                           as TermEndDate,

      cast(FinTran_Header.sanlf as ftr_gen_fin_instr_prod_categ preserving type)     as FinancialInstrProductCategory,
      FinTran_Header.sfgtyp                                                          as FinInstrTransactionCategory,
      FinTran_Header.sgsart                                                          as FinancialInstrumentProductType,
      FinTran_Header.sfhaart                                                         as FinancialInstrTransactionType,

      cast(FinTran_Header.kontrh   as rkontrah_new preserving type)                  as Counterparty,

      FinTran_Header.hedge_book                                                      as FinancialTransactionHedgeBook,
      FinTran_Header.rportb                                                          as FinancialTransactionPortfolio,
      FinTran_Header.hedge_class                                                     as FinTransHedgingClassification,

      /* Associations */
      _FinTran,
      _CompanyCode,
      _ProductType,
      _Counterparty
}
where
     FinTran_Header.sanlf = '800' // Commodity Forward

  or FinTran_Header.sanlf = '810' // Commodity Swap

Learn More