P_CMMDTYFINTRANSACTIONHEADER

CDS View

P_CMMDTYFINTRANSACTIONHEADER is a CDS View in S/4HANA. It contains 22 fields. 2 CDS views read from this table.

Used by 2 CDS view(s) 22 fields

CDS Views using this table (2)

ViewTypeJoinVDMDescription
P_CmmdtyFinancialTransaction view inner COMPOSITE
P_CmmdtyFinTransactFlowUnion view inner COMPOSITE

Fields (22)

KeyField CDS FieldsUsed in Views
KEY CompanyCode CompanyCode 2
KEY FinancialTransaction FinancialTransaction 2
_CompanyCode _CompanyCode 1
_Counterparty _Counterparty 1
_ProductType _ProductType 1
Counterparty Counterparty 1
CreatedByUser CreatedByUser 1
FinancialInstrProductCategory FinancialInstrProductCategory 1
FinancialInstrTransactionType FinancialInstrTransactionType 1
FinancialInstrumentProductType FinancialInstrumentProductType 1
FinancialInstrumentStatus FinancialInstrumentStatus 1
FinancialTransactionHedgeBook FinancialTransactionHedgeBook 1
FinancialTransactionPortfolio FinancialTransactionPortfolio 1
FinInstrTransactionCategory FinInstrTransactionCategory 1
FinInstrumentLastChangedTime FinInstrumentLastChangedTime 1
FinTransCreationDate FinTransCreationDate 1
FinTransCreationTime FinTransCreationTime 1
FinTransHedgingClassification FinTransHedgingClassification 1
LastChangeDate LastChangeDate 1
LastChangedByUser LastChangedByUser 1
TermEndDate TermEndDate 1
TermStartDate FinTransTermRiskStartDate,TermStartDate 1 
@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