I_CmmdtyHdgTransFlowNotFixed

DDL: I_CMMDTYHDGTRANSFLOWNOTFIXED Type: view BASIC

Cmdty Fin Transaction Flows Unfixed

I_CmmdtyHdgTransFlowNotFixed is a Basic CDS View that provides data about "Cmdty Fin Transaction Flows Unfixed" in SAP S/4HANA. It reads from 1 data source (vtbfhapo_unfixed) and exposes 15 fields with key fields CompanyCode, CmmdtyHedgeConstellationDeal, FinancialInstrumentActivity, FinTransFlowNumber, FinTransCreationDate.

1 data source(s) 15 fields

Data Sources (1)

SourceAliasJoin Type
vtbfhapo_unfixed fhapo_unfixed from

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName ICMMTOCTRNSFLUNF view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
VDM.viewType #BASIC view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label Cmdty Fin Transaction Flows Unfixed view

Fields (15)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode vtbfhapo_unfixed bukrs
KEY CmmdtyHedgeConstellationDeal vtbfhapo_unfixed rfha
KEY FinancialInstrumentActivity vtbfhapo_unfixed rfhazu
KEY FinTransFlowNumber vtbfhapo_unfixed rfhazb
KEY FinTransCreationDate vtbfhapo_unfixed dcrdat
LastChangeDate vtbfhapo_unfixed dupdat
FinTransFlowPaytAmt vtbfhapo_unfixed bzbetr
FinTransFlowPaytAmtCrcy vtbfhapo_unfixed wzbetr
FinTransacTradedPriceAmount
FinancialTransactionDCSID vtbfhapo_unfixed dcsid
CmmdtyHdgCalcdTradeCurrency
FinTransPositionCrcyCnvrsnRate
UnitOfMeasure vtbfhapo_unfixed unit_of_measure
Quantity vtbfhapo_unfixed quantity
FinTransFlowCategory vtbfhapo_unfixed sbktyp 
@AbapCatalog: { sqlViewName:            'ICMMTOCTRNSFLUNF',
                compiler.compareFilter: true,
                preserveKey:            true }

@AccessControl.authorizationCheck: #NOT_REQUIRED

@VDM: { viewType: #BASIC }

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

@ClientHandling.algorithm: #SESSION_VARIABLE

@EndUserText.label: 'Cmdty Fin Transaction Flows Unfixed'

define view I_CmmdtyHdgTransFlowNotFixed
  as select from vtbfhapo_unfixed as fhapo_unfixed
{

  key  fhapo_unfixed.bukrs                                                 as CompanyCode,
  key  fhapo_unfixed.rfha                                                  as CmmdtyHedgeConstellationDeal,

       // to be checked these keys!!!

  key  fhapo_unfixed.rfhazu                                                as FinancialInstrumentActivity,
  key  fhapo_unfixed.rfhazb                                                as FinTransFlowNumber,
  key  fhapo_unfixed.dcrdat                                                as FinTransCreationDate,
       // key  fhapo_unfixed.tcrtim,

       //      fhapo_unfixed.dcrdat,

       fhapo_unfixed.dupdat                                                as LastChangeDate,
       @Semantics.amount.currencyCode: 'FinTransFlowPaytAmtCrcy'
       fhapo_unfixed.bzbetr                                                as FinTransFlowPaytAmt,
       @Semantics.currencyCode: true
       fhapo_unfixed.wzbetr                                                as FinTransFlowPaytAmtCrcy,
       @Semantics.amount.currencyCode: 'CmmdtyHdgCalcdTradeCurrency'
       cast(fhapo_unfixed.contract_price as tb_bzbetr )                    as FinTransacTradedPriceAmount,
       //       cast(fhapo_unfixed.contract_price as tb_bzbetr )                    as FinTransTradedPriceCrcyUnit,

       fhapo_unfixed.dcsid                                                 as FinancialTransactionDCSID,
       @Semantics.currencyCode: true
       cast( fhapo_unfixed.price_curr_unit as tb_wzbetr )                  as CmmdtyHdgCalcdTradeCurrency,
       cast(fhapo_unfixed.kzwkurs as ftr_crcy_cnvrsn_rate preserving type) as FinTransPositionCrcyCnvrsnRate,
       @Semantics.unitOfMeasure: true
       fhapo_unfixed.unit_of_measure                                       as UnitOfMeasure,
       @Semantics.quantity.unitOfMeasure: 'UnitOfMeasure'
       fhapo_unfixed.quantity                                              as Quantity,
       fhapo_unfixed.sbktyp                                                as FinTransFlowCategory
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"VTBFHAPO_UNFIXED"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More