Which tables does P_CmmdtyFinTransactFlowUnion use?

P_CmmdtyFinTransactFlowUnion reads from 9 data source(s): P_CmmdtyFinTransactionHeader, P_CmmdtyFinTransactionHeader, P_CmmdtyFinTransactionHeader, P_CmmdtyFinTransactionHeader, I_CmmdtyFinTransactionFlow, I_CmmdtyFinTransactionFlow, I_CmmdtyFinTransactionFlow, I_CmmdtyFinTransFlowUnfixed, I_CmmdtyFinTransFlowUnfixed.

P_CmmdtyFinTransactFlowUnion

Q: How many fields does P_CmmdtyFinTransactFlowUnion have?

P_CmmdtyFinTransactFlowUnion has 73 fields. Key fields: CompanyCode, FinancialTransaction, FinancialInstrumentActivity, FinTransFlowNumber, FinancialTransaction.

DDL: P_CMMDTYFINTRANSACTFLOWUNION Type: view COMPOSITE

P_CmmdtyFinTransactFlowUnion is a Composite CDS View in SAP S/4HANA. It reads from 9 data sources and exposes 73 fields with key fields CompanyCode, FinancialTransaction, FinancialInstrumentActivity, FinTransFlowNumber, FinancialTransaction. It has 1 association to related views.

Data Sources (9)

Source	Alias	Join Type
P_CmmdtyFinTransactionHeader	fha	inner
P_CmmdtyFinTransactionHeader	fha	inner
P_CmmdtyFinTransactionHeader	fha	inner
P_CmmdtyFinTransactionHeader	fha	inner
I_CmmdtyFinTransactionFlow	fhapo	from
I_CmmdtyFinTransactionFlow	fhapo	union_all
I_CmmdtyFinTransactionFlow	fhapo	union_all
I_CmmdtyFinTransFlowUnfixed	fhapo_unfixed	inner
I_CmmdtyFinTransFlowUnfixed	fhapo_unfixed	union_all

Associations (1)

Cardinality	Target	Alias	Condition
[0..1]	I_DerivativeContrSpec	_DCS	`_DCS.DerivativeContrSpecification = $projection.DerivativeContrSpecification`

Annotations (10)

Name	Value	Level
AbapCatalog.sqlViewName	PCMMFINTRNSFLUN	view
AbapCatalog.compiler.compareFilter	true	view
AbapCatalog.preserveKey	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 (73)

Key	Field	Source Table	Source Field
KEY	CompanyCode	P_CmmdtyFinTransactionHeader	CompanyCode
KEY	FinancialTransaction	P_CmmdtyFinTransactionHeader	FinancialTransaction
KEY	FinancialInstrumentActivity	I_CmmdtyFinTransactionFlow	FinancialInstrumentActivity
KEY	FinTransFlowNumber	I_CmmdtyFinTransactionFlow	FinTransFlowNumber
	FinTransFlowPaymentDate	I_CmmdtyFinTransactionFlow	FinTransFlowPaymentDate
	FinTransactionPricingStartDate	I_CmmdtyFinTransFlowUnfixed	FinTransactionPricingStartDate
	FinTransactionPricingEndDate	I_CmmdtyFinTransFlowUnfixed	FinTransactionPricingEndDate
	FinTransacTradedPriceAmount	I_CmmdtyFinTransactionFlow	FinTransacTradedPriceAmount
	FinTransTradedPriceCrcyUnit	I_CmmdtyFinTransactionFlow	FinTransTradedPriceCrcyUnit
	FinancialTransactionDirection	I_CmmdtyFinTransactionFlow	FinancialTransactionDirection
	DerivativeContrSpecification	I_CmmdtyFinTransactionFlow	DerivativeContrSpecification
	MarketIdentifierCode	I_CmmdtyFinTransFlowUnfixed	MarketIdentifierCode
	Quantity	I_CmmdtyFinTransactionFlow	Quantity
	UnitOfMeasure	I_CmmdtyFinTransactionFlow	UnitOfMeasure
	CommodityPriceExposureUnit	I_CmmdtyFinTransactionFlow	CommodityPriceExposureUnit
	FinancialTransactionAmount	I_CmmdtyFinTransactionFlow	FinancialTransactionAmount
	FinTransFlowPaytAmtCrcy	I_CmmdtyFinTransactionFlow	FinTransFlowPaytAmtCrcy
	FinTransFlowIntrstRateFixDate	I_CmmdtyFinTransactionFlow	FinTransFlowIntrstRateFixDate
	CompanyCodeasCompanyCode
KEY	FinancialTransaction	P_CmmdtyFinTransactionHeader	FinancialTransaction
KEY	FinancialInstrumentActivity	I_CmmdtyFinTransactionFlow	FinancialInstrumentActivity
KEY	FinTransFlowNumber	I_CmmdtyFinTransactionFlow	FinTransFlowNumber
	FinTransFlowPaymentDate	I_CmmdtyFinTransactionFlow	FinTransFlowPaymentDate
	FinTransactionPricingStartDate	I_CmmdtyFinTransactionFlow	FinTransactionPricingStartDate
	FinTransactionPricingEndDate	I_CmmdtyFinTransactionFlow	FinTransactionPricingEndDate
	FinTransacTradedPriceAmount	I_CmmdtyFinTransactionFlow	FinTransacTradedPriceAmount
	FinTransTradedPriceCrcyUnit	I_CmmdtyFinTransactionFlow	FinTransTradedPriceCrcyUnit
	FinancialTransactionDirection	I_CmmdtyFinTransactionFlow	FinancialTransactionDirection
	DerivativeContrSpecification	I_CmmdtyFinTransactionFlow	DerivativeContrSpecification
	MarketIdentifierCode	I_CmmdtyFinTransactionFlow	MarketIdentifierCode
	Quantity	I_CmmdtyFinTransactionFlow	Quantity
	UnitOfMeasure	I_CmmdtyFinTransactionFlow	UnitOfMeasure
	CommodityPriceExposureUnit	I_CmmdtyFinTransactionFlow	CommodityPriceExposureUnit
	FinancialTransactionAmount	I_CmmdtyFinTransactionFlow	FinancialTransactionAmount
	FinTransFlowPaytAmtCrcy	I_CmmdtyFinTransactionFlow	FinTransFlowPaytAmtCrcy
	FinTransFlowIntrstRateFixDate	I_CmmdtyFinTransactionFlow	FinTransFlowIntrstRateFixDate
	CompanyCodeasCompanyCode
KEY	FinancialTransaction	I_CmmdtyFinTransactionFlow	FinancialTransaction
KEY	FinancialInstrumentActivity	I_CmmdtyFinTransactionFlow	FinancialInstrumentActivity
KEY	FinTransFlowNumber	I_CmmdtyFinTransactionFlow	FinTransFlowNumber
	FinTransFlowPaymentDate	I_CmmdtyFinTransactionFlow	FinTransFlowPaymentDate
	FinTransactionPricingStartDate	I_CmmdtyFinTransactionFlow	FinTransactionPricingStartDate
	FinTransactionPricingEndDate	I_CmmdtyFinTransactionFlow	FinTransactionPricingEndDate
	FinTransacTradedPriceAmount	I_CmmdtyFinTransactionFlow	FinTransacTradedPriceAmount
	FinTransTradedPriceCrcyUnit	I_CmmdtyFinTransactionFlow	FinTransTradedPriceCrcyUnit
	FinancialTransactionDirection	I_CmmdtyFinTransactionFlow	FinancialTransactionDirection
	DerivativeContrSpecification	I_CmmdtyFinTransactionFlow	DerivativeContrSpecification
	MarketIdentifierCode	I_CmmdtyFinTransactionFlow	MarketIdentifierCode
	Quantity	I_CmmdtyFinTransactionFlow	Quantity
	UnitOfMeasure	I_CmmdtyFinTransactionFlow	UnitOfMeasure
	CommodityPriceExposureUnit	I_CmmdtyFinTransactionFlow	CommodityPriceExposureUnit
	FinancialTransactionAmount	I_CmmdtyFinTransactionFlow	FinancialTransactionAmount
	FinTransFlowPaytAmtCrcy	I_CmmdtyFinTransactionFlow	FinTransFlowPaytAmtCrcy
	FinTransFlowIntrstRateFixDate	I_CmmdtyFinTransactionFlow	FinTransFlowIntrstRateFixDate
	CompanyCodeasCompanyCode
KEY	FinancialTransaction	I_CmmdtyFinTransFlowUnfixed	FinancialTransaction
KEY	FinancialInstrumentActivity	I_CmmdtyFinTransFlowUnfixed	FinancialInstrumentActivity
KEY	FinTransFlowNumber	I_CmmdtyFinTransFlowUnfixed	FinTransFlowNumber
	FinTransFlowPaymentDate	I_CmmdtyFinTransFlowUnfixed	FinTransFlowPaymentDate
	FinTransactionPricingStartDate	I_CmmdtyFinTransFlowUnfixed	FinTransactionPricingStartDate
	FinTransactionPricingEndDate	I_CmmdtyFinTransFlowUnfixed	FinTransactionPricingEndDate
	FinTransacTradedPriceAmount	I_CmmdtyFinTransFlowUnfixed	FinTransacTradedPriceAmount
	FinTransTradedPriceCrcyUnit	I_CmmdtyFinTransFlowUnfixed	FinTransTradedPriceCrcyUnit
	FinancialTransactionDirection	I_CmmdtyFinTransFlowUnfixed	FinancialTransactionDirection
	DerivativeContrSpecification	I_CmmdtyFinTransFlowUnfixed	DerivativeContrSpecification
	MarketIdentifierCode	I_CmmdtyFinTransFlowUnfixed	MarketIdentifierCode
	Quantity	I_CmmdtyFinTransFlowUnfixed	Quantity
	UnitOfMeasure	I_CmmdtyFinTransFlowUnfixed	UnitOfMeasure
	CommodityPriceExposureUnit	I_CmmdtyFinTransFlowUnfixed	CommodityPriceExposureUnit
	FinancialTransactionAmount	I_CmmdtyFinTransFlowUnfixed	FinancialTransactionAmount
	FinTransFlowPaytAmtCrcy	I_CmmdtyFinTransFlowUnfixed	FinTransFlowPaytAmtCrcy
	FinTransFlowIntrstRateFixDate	I_CmmdtyFinTransFlowUnfixed	FinTransFlowIntrstRateFixDate
	_DCS		_DCS

@AbapCatalog: { sqlViewName:            'PCMMFINTRNSFLUN',
                compiler.compareFilter: true,
                preserveKey:            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 Flows'


define view P_CmmdtyFinTransactFlowUnion
  as select from I_CmmdtyFinTransactionFlow   as fhapo
    inner join   I_CmmdtyFinTransFlowUnfixed  as fhapo_unfixed on  fhapo_unfixed.CompanyCode                    = fhapo.CompanyCode

                                                               and fhapo_unfixed.FinancialTransaction           = fhapo.FinancialTransaction
                                                               and fhapo_unfixed.FinancialInstrumentActivity    = fhapo.FinancialInstrumentActivity
                                                               and fhapo_unfixed.FinTransCreationDate           = fhapo.FinTransCreationDate
                                                               and fhapo_unfixed.FinTransFlowCreationTime       = fhapo.FinTransFlowCreationTime
                                                               and (
                                                                  fhapo_unfixed.FinTransReferenceFlowUUID       = fhapo.FinancialTransactionFlowUUID
                                                                  or fhapo_unfixed.FinancialTransactionFlowUUID = fhapo.FinTransReferenceFlowUUID
                                                                )
    inner join   P_CmmdtyFinTransactionHeader as fha           on  fha.CompanyCode                   = fhapo.CompanyCode
                                                               and fha.FinancialTransaction          = fhapo.FinancialTransaction
                                                               and fha.FinInstrLastActiveActivity    = fhapo.FinancialInstrumentActivity
                                                               and fha.FinancialInstrProductCategory = '810' // Commodity Swap - not fully fixed


  association [0..1] to I_DerivativeContrSpec as _DCS on _DCS.DerivativeContrSpecification = $projection.DerivativeContrSpecification
  //  association [0..1] to I_CmmdtyDrvtvContrSpec         as _DCS2 on _DCS.CommodityCurveDrvtvContrSpec  = $projection.DerivativeContrSpecification

  //  association [0..1] to I_CmmdtyDrvtvContrSpecValdFrom as _DCS3 on _DCS2.DerivativeContrSpecification = $projection.DerivativeContrSpecification


{
  key fha.CompanyCode                              as CompanyCode,
  key fha.FinancialTransaction                     as FinancialTransaction,
  key fhapo.FinancialInstrumentActivity            as FinancialInstrumentActivity,
  key fhapo.FinTransFlowNumber                     as FinTransFlowNumber,

      fhapo.FinTransFlowPaymentDate                as FinTransFlowPaymentDate,
      fhapo_unfixed.FinTransactionPricingStartDate as FinTransactionPricingStartDate,
      fhapo_unfixed.FinTransactionPricingEndDate   as FinTransactionPricingEndDate,

      fhapo.FinTransacTradedPriceAmount            as FinTransacTradedPriceAmount,
      fhapo.FinTransTradedPriceCrcyUnit            as FinTransTradedPriceCrcyUnit,

      fhapo.FinancialTransactionDirection          as FinancialTransactionDirection,

      fhapo.DerivativeContrSpecification           as DerivativeContrSpecification,
      fhapo_unfixed.MarketIdentifierCode           as MarketIdentifierCode,

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

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

      fhapo.FinancialTransactionAmount             as FinancialTransactionAmount,
      fhapo.FinTransFlowPaytAmtCrcy                as FinTransFlowPaytAmtCrcy,

      fhapo.FinTransFlowIntrstRateFixDate          as FinTransFlowIntrstRateFixDate,

      /* Associations */
      _DCS
}
where
  (
       fhapo.FinTransFlowCategory         = '50'         // Buy

    or fhapo.FinTransFlowCategory         = '51'         // Sell

  )
  and(
       fhapo_unfixed.FinTransFlowCategory = '50'         // Buy

    or fhapo_unfixed.FinTransFlowCategory = '51'         // Sell

  )

union all

select from              I_CmmdtyFinTransactionFlow   as fhapo
  inner join             P_CmmdtyFinTransactionHeader as fha           on  fha.CompanyCode                   = fhapo.CompanyCode
                                                                       and fha.FinancialTransaction          = fhapo.FinancialTransaction
                                                                       and fha.FinancialInstrProductCategory = '810' // Commodity Swap - fully fixed

  left outer to one join I_CmmdtyFinTransFlowUnfixed  as fhapo_unfixed on  fhapo_unfixed.CompanyCode                    = fhapo.CompanyCode

                                                                       and fhapo_unfixed.FinancialTransaction           = fhapo.FinancialTransaction
                                                                       and fhapo_unfixed.FinancialInstrumentActivity    = fhapo.FinancialInstrumentActivity
                                                                       and fhapo_unfixed.FinTransCreationDate           = fhapo.FinTransCreationDate
                                                                       and fhapo_unfixed.FinTransFlowCreationTime       = fhapo.FinTransFlowCreationTime
                                                                       and (
                                                                          fhapo_unfixed.FinTransReferenceFlowUUID       = fhapo.FinancialTransactionFlowUUID
                                                                          or fhapo_unfixed.FinancialTransactionFlowUUID = fhapo.FinTransReferenceFlowUUID
                                                                        )
association [0..1] to I_DerivativeContrSpec as _DCS on _DCS.DerivativeContrSpecification = $projection.DerivativeContrSpecification

{
  key fha.CompanyCode                      as CompanyCode,
  key fha.FinancialTransaction             as FinancialTransaction,
  key fhapo.FinancialInstrumentActivity    as FinancialInstrumentActivity,
  key fhapo.FinTransFlowNumber             as FinTransFlowNumber,

      fhapo.FinTransFlowPaymentDate        as FinTransFlowPaymentDate,
      fhapo.FinTransactionPricingStartDate as FinTransactionPricingStartDate,
      fhapo.FinTransactionPricingEndDate   as FinTransactionPricingEndDate,

      fhapo.FinTransacTradedPriceAmount    as FinTransacTradedPriceAmount,
      fhapo.FinTransTradedPriceCrcyUnit    as FinTransTradedPriceCrcyUnit,

      fhapo.FinancialTransactionDirection  as FinancialTransactionDirection,

      fhapo.DerivativeContrSpecification   as DerivativeContrSpecification,
      fhapo.MarketIdentifierCode           as MarketIdentifierCode,

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

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

      fhapo.FinancialTransactionAmount     as FinancialTransactionAmount,
      fhapo.FinTransFlowPaytAmtCrcy        as FinTransFlowPaytAmtCrcy,

      fhapo.FinTransFlowIntrstRateFixDate  as FinTransFlowIntrstRateFixDate,

      /* Associations */
      _DCS
}
where
  (
       fhapo.FinTransFlowCategory                 = '50' // Buy

    or fhapo.FinTransFlowCategory                 = '51' // Sell

  )
  and  fhapo.FinInterestRateAdjmtStatus           = '02' // Fixed

  and  fhapo_unfixed.FinancialTransactionFlowUUID is null

union all

select from  I_CmmdtyFinTransactionFlow   as fhapo
  inner join P_CmmdtyFinTransactionHeader as fha on  fha.CompanyCode                   = fhapo.CompanyCode
                                                 and fha.FinancialTransaction          = fhapo.FinancialTransaction
                                                 and fha.FinancialInstrProductCategory = '800' // Commodity Forward - simple or completely fixed Avg


association [0..1] to I_DerivativeContrSpec as _DCS on _DCS.DerivativeContrSpecification = $projection.DerivativeContrSpecification

{
  key fhapo.CompanyCode                    as CompanyCode,
  key fhapo.FinancialTransaction           as FinancialTransaction,
  key fhapo.FinancialInstrumentActivity    as FinancialInstrumentActivity,
  key fhapo.FinTransFlowNumber             as FinTransFlowNumber,
      //      fhapo_unfixed.FinTransFlowNumber                   as FinTransFlowNumber,


      fhapo.FinTransFlowPaymentDate        as FinTransFlowPaymentDate,
      fhapo.FinTransactionPricingStartDate as FinTransactionPricingStartDate,
      fhapo.FinTransactionPricingEndDate   as FinTransactionPricingEndDate,

      fhapo.FinTransacTradedPriceAmount    as FinTransacTradedPriceAmount,
      fhapo.FinTransTradedPriceCrcyUnit    as FinTransTradedPriceCrcyUnit,

      fhapo.FinancialTransactionDirection  as FinancialTransactionDirection,

      fhapo.DerivativeContrSpecification   as DerivativeContrSpecification,
      fhapo.MarketIdentifierCode           as MarketIdentifierCode,

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

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

      fhapo.FinancialTransactionAmount     as FinancialTransactionAmount,
      fhapo.FinTransFlowPaytAmtCrcy        as FinTransFlowPaytAmtCrcy,

      fhapo.FinTransFlowIntrstRateFixDate  as FinTransFlowIntrstRateFixDate,

      /* Associations */
      _DCS
}
where
  (
       fhapo.FinTransFlowCategory = '50'                 // Buy

    or fhapo.FinTransFlowCategory = '51'                 // Sell

  )

union all

select from  I_CmmdtyFinTransFlowUnfixed  as fhapo_unfixed
  inner join P_CmmdtyFinTransactionHeader as fha on  fha.CompanyCode                   = fhapo_unfixed.CompanyCode
                                                 and fha.FinancialTransaction          = fhapo_unfixed.FinancialTransaction
                                                 and fha.FinancialInstrProductCategory = '800' // Commodity Forward - Avg


association [0..1] to I_DerivativeContrSpec as _DCS on _DCS.DerivativeContrSpecification = $projection.DerivativeContrSpecification

{
  key fhapo_unfixed.CompanyCode                    as CompanyCode,
  key fhapo_unfixed.FinancialTransaction           as FinancialTransaction,
  key fhapo_unfixed.FinancialInstrumentActivity    as FinancialInstrumentActivity,
  key fhapo_unfixed.FinTransFlowNumber             as FinTransFlowNumber,
      //      fhapo_unfixed.FinTransFlowNumber                   as FinTransFlowNumber,


      fhapo_unfixed.FinTransFlowPaymentDate        as FinTransFlowPaymentDate,
      fhapo_unfixed.FinTransactionPricingStartDate as FinTransactionPricingStartDate,
      fhapo_unfixed.FinTransactionPricingEndDate   as FinTransactionPricingEndDate,

      fhapo_unfixed.FinTransacTradedPriceAmount    as FinTransacTradedPriceAmount,
      fhapo_unfixed.FinTransTradedPriceCrcyUnit    as FinTransTradedPriceCrcyUnit,

      fhapo_unfixed.FinancialTransactionDirection  as FinancialTransactionDirection,

      fhapo_unfixed.DerivativeContrSpecification   as DerivativeContrSpecification,
      fhapo_unfixed.MarketIdentifierCode           as MarketIdentifierCode,

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

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

      fhapo_unfixed.FinancialTransactionAmount     as FinancialTransactionAmount,
      fhapo_unfixed.FinTransFlowPaytAmtCrcy        as FinTransFlowPaytAmtCrcy,

      fhapo_unfixed.FinTransFlowIntrstRateFixDate  as FinTransFlowIntrstRateFixDate,

      /* Associations */
      _DCS
}
where
  (
       fhapo_unfixed.FinTransFlowCategory = '50'         // Buy

    or fhapo_unfixed.FinTransFlowCategory = '51'         // Sell

  )

//union

//

//select from  I_CmmdtyFinTransactionFlow as fhapo

//  inner join vtbfha                     as fha on  fha.bukrs                     = fhapo.CompanyCode

//                                               and fha.rfha                      = fhapo.FinancialTransaction

//                                               and fha.sanlf                     = '600' // FX

//                                               and (

//                                                  (

//                                                    fha.amtinput                 = '1'

//                                                    and fhapo.FinTransFlowNumber = '0002'

//                                                  )

//                                                  or(

//                                                    fha.amtinput                 = '2'

//                                                    and fhapo.FinTransFlowNumber = '0001'

//                                                  )

//                                                )

//

//association [0..1] to I_DerivativeContrSpec as _DCS on _DCS.DerivativeContrSpecification = $projection.DerivativeContrSpecification

//

//{

//  key fhapo.CompanyCode                    as CompanyCode,

//  key fhapo.FinancialTransaction           as FinancialTransaction,

//  key fhapo.FinancialInstrumentActivity    as FinancialInstrumentActivity,

//  key fhapo.FinTransFlowNumber             as FinTransFlowNumber,

//      //      fhapo.FinTransFlowNumber                     as FinTransFlowNumber,

//

//      fhapo.FinTransFlowPaymentDate        as FinTransFlowPaymentDate,

//      fhapo.FinTransactionPricingStartDate as FinTransactionPricingStartDate,

//      fhapo.FinTransactionPricingEndDate   as FinTransactionPricingEndDate,

//

//      fhapo.FinTransacTradedPriceAmount    as FinTransacTradedPriceAmount,

//      fhapo.FinTransTradedPriceCrcyUnit    as FinTransTradedPriceCrcyUnit,

//

//      fhapo.FinancialTransactionDirection  as FinancialTransactionDirection,

//

//      fhapo.DerivativeContrSpecification   as DerivativeContrSpecification,

//      fhapo.MarketIdentifierCode           as MarketIdentifierCode,

//

//      @Semantics.quantity.unitOfMeasure: 'UnitOfMeasure'

//      fhapo.Quantity                       as Quantity,

//

//      @Semantics.unitOfMeasure: true

//      fhapo.UnitOfMeasure                  as UnitOfMeasure,

//      @Semantics.unitOfMeasure: true

//      fhapo.CommodityPriceExposureUnit     as CommodityPriceExposureUnit,

//

//      fhapo.FinancialTransactionAmount     as FinancialTransactionAmount,

//      fhapo.FinTransFlowPaytAmtCrcy        as FinTransFlowPaytAmtCrcy,

//

//      fhapo.FinTransFlowIntrstRateFixDate  as FinTransFlowIntrstRateFixDate,

//

//      /* Associations */

//      _DCS

//}

/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_CMMDTYFINTRANSACTIONFLOW",
"I_CMMDTYFINTRANSFLOWUNFIXED",
"P_CMMDTYFINTRANSACTIONHEADER"
],
"ASSOCIATED":
[
"I_DERIVATIVECONTRSPEC"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Depth:

P_CmmdtyFinTransactFlowUnion view

P_CmmdtyHdgFinTransPrcgPeriod view