I_CMMDTYFINTRANSFLOWUNFIXED

CDS View

Cmdty Fin Transaction Flows Unfixed

I_CMMDTYFINTRANSFLOWUNFIXED is a CDS View in S/4HANA. Cmdty Fin Transaction Flows Unfixed. It contains 17 fields. 4 CDS views read from this table.

Used by 4 CDS view(s) 17 fields

CDS Views using this table (4)

ViewTypeJoinVDMDescription
I_CmmdtyHdgTransFlowDetails view inner COMPOSITE Constellation Deals flow details
P_CmmdtyFinTransactFlowUnion view inner COMPOSITE
P_CmmdtyFinTransactFlowUnion view union_all COMPOSITE
P_CMMDTYHDGTRDORDTRANSFLW view_entity union_all COMPOSITE Trans Flow details Fxd and Unfxd

Fields (17)

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

@AccessControl.authorizationCheck: #NOT_REQUIRED

@VDM: { viewType: #BASIC }

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

@ClientHandling.algorithm: #SESSION_VARIABLE

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

define view I_CmmdtyFinTransFlowUnfixed
  as select from vtbfhapo_unfixed as fhapo_unfixed
{

  key fhapo_unfixed.bukrs           as CompanyCode,
  key fhapo_unfixed.rfha            as FinancialTransaction,
  key fhapo_unfixed.rfhazu          as FinancialInstrumentActivity,
  key fhapo_unfixed.rfhazb          as FinTransFlowNumber,
  key fhapo_unfixed.dcrdat          as FinTransCreationDate,
  key fhapo_unfixed.tcrtim          as FinTransFlowCreationTime,

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

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

      fhapo_unfixed.dcsid           as DerivativeContrSpecification,
      fhapo_unfixed.mic             as MarketIdentifierCode,

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

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

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

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

      fhapo_unfixed.sbktyp          as FinTransFlowCategory,
      fhapo_unfixed.dzfest          as FinTransFlowIntrstRateFixDate,
      fhapo_unfixed.flowuuid        as FinancialTransactionFlowUUID,
      fhapo_unfixed.ref_flowuuid    as FinTransReferenceFlowUUID,

      fhapo_unfixed.dupdat          as LastChangeDate
}

Learn More