I_CMMDTYFINTRANSACTIONFLOW

CDS View

Commodity Financial Transaction Flows

I_CMMDTYFINTRANSACTIONFLOW is a CDS View in S/4HANA. Commodity Financial Transaction Flows. It contains 21 fields. 5 CDS views read from this table.

Used by 5 CDS view(s) 21 fields

CDS Views using this table (5)

ViewTypeJoinVDMDescription
I_CmmdtyHdgTransFlowDetails view inner COMPOSITE Constellation Deals flow details
P_CmmdtyFinTransactFlowUnion view from COMPOSITE
P_CmmdtyFinTransactFlowUnion view union_all COMPOSITE
P_CmmdtyFinTransFlowCount view from COMPOSITE
P_CmmdtyHdgFXFinTransFlow view inner COMPOSITE

Fields (21)

KeyField CDS FieldsUsed in Views
KEY CompanyCode CompanyCode 2
KEY FinancialInstrumentActivity FinancialInstrumentActivity 2
KEY FinancialTransaction CmmdtyHedgeConstellationDeal,FinancialTransaction 3
KEY FinTransCreationDate FinTransCreationDate 2
KEY FinTransFlowCreationTime FinTransFlowCreationTime 1
KEY FinTransFlowNumber FinTransFlowNumber 2
CommodityPriceExposureUnit CommodityPriceExposureUnit 2
DerivativeContrSpecification DerivativeContrSpecification 2
FinancialTransactionAmount FinancialTransactionAmount,FinTransFlowPaytAmt 3
FinancialTransactionDirection FinancialTransactionDirection 2
FinTransactionPricingEndDate FinTransactionPricingEndDate 2
FinTransactionPricingStartDate FinTransactionPricingStartDate 2
FinTransacTradedPriceAmount FinTransacTradedPriceAmount 2
FinTransFlowIntrstRateFixDate FinTransFlowIntrstRateFixDate 2
FinTransFlowPaymentDate FinTransFlowPaymentDate 2
FinTransFlowPaytAmtCrcy FinTransFlowPaytAmtCrcy 3
FinTransTradedPriceCrcyUnit FinTransTradedPriceCrcyUnit 2
LastChangeDate LastChangeDate 1
MarketIdentifierCode MarketIdentifierCode 2
Quantity Quantity 2
UnitOfMeasure UnitOfMeasure 3 
@AbapCatalog: { sqlViewName:            'ICMMFINTRANSFLOW',
                compiler.compareFilter: true,
                preserveKey:            true }

@AccessControl.authorizationCheck: #NOT_REQUIRED

@VDM: { viewType: #BASIC }

@ObjectModel.usageType: { serviceQuality: #C,
                          sizeCategory:   #XXL,
                          dataClass:      #MIXED }

@ClientHandling.algorithm: #SESSION_VARIABLE

@EndUserText.label: 'Commodity Financial Transaction Flows'

define view I_CmmdtyFinTransactionFlow

  as select from vtbfhapo as fhapo
{
  key fhapo.bukrs           as CompanyCode,
  key fhapo.rfha            as FinancialTransaction,
  key fhapo.rfhazu          as FinancialInstrumentActivity,
  key fhapo.rfhazb          as FinTransFlowNumber,
  key fhapo.dcrdat          as FinTransCreationDate,
  key fhapo.tcrtim          as FinTransFlowCreationTime,

      fhapo.dzterm          as FinTransFlowPaymentDate,
      fhapo.dbervon         as FinTransactionPricingStartDate,
      fhapo.dberbis         as FinTransactionPricingEndDate,

      fhapo.contract_price  as FinTransacTradedPriceAmount,
      fhapo.price_curr_unit as FinTransTradedPriceCrcyUnit,
      fhapo.rkondgr         as FinancialTransactionDirection,

      fhapo.dcsid           as DerivativeContrSpecification,
      fhapo.mic             as MarketIdentifierCode,

      @Semantics.quantity.unitOfMeasure: 'UnitOfMeasure'
      fhapo.quantity        as Quantity,

      @Semantics.unitOfMeasure: true
      fhapo.unit_of_measure as UnitOfMeasure,

      @Semantics.unitOfMeasure: true
      fhapo.price_uom       as CommodityPriceExposureUnit,

      @Semantics.amount.currencyCode: 'FinTransFlowPaytAmtCrcy'
      fhapo.bzbetr          as FinancialTransactionAmount,
      fhapo.wzbetr          as FinTransFlowPaytAmtCrcy,

      fhapo.sbktyp          as FinTransFlowCategory,
      fhapo.dzfest          as FinTransFlowIntrstRateFixDate,
      fhapo.regi_state      as FinInterestRateAdjmtStatus,
      fhapo.flowuuid        as FinancialTransactionFlowUUID,
      fhapo.ref_flowuuid    as FinTransReferenceFlowUUID,

      fhapo.dupdat          as LastChangeDate
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"VTBFHAPO"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More