P_CMMDTYFINVERSSUMQTYTRANS

CDS View

Commodity Financial Transaction

P_CMMDTYFINVERSSUMQTYTRANS is a CDS View in S/4HANA. Commodity Financial Transaction. It contains 9 fields. 1 CDS views read from this table.

Used by 1 CDS view(s) 9 fields

CDS Views using this table (1)

ViewTypeJoinVDMDescription
P_CmmdtyFinancialTransaction view from COMPOSITE

Fields (9)

KeyField CDS FieldsUsed in Views
_DCS _DCS 1
CalculationPeriodEndDate FinTransactionPricingEndDate,FinTransactionTermRiskEndDate 1
CalculationPeriodStartDate FinTransactionPricingStartDate 1
CmmdtyPriceExpsrPaymentAmount FinTransPaymentAmount 1
CommodityPriceExposureUnit UnitOfMeasure 1
DeliveryDate FinTransFlowPaymentDate 1
DerivativeContrSpecification DerivativeContrSpecification 1
MarketIdentifierCode MarketIdentifierCode 1
PaymentCurrency FinTransTradedPriceCurrency 1 
@AbapCatalog: { sqlViewName:            'PCMMFINTRSQTY',
                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'

define view P_CmmdtyFinVersSumQtyTrans

  as select from I_DerivativeCmmdtyExpsr as CommodityDeal

{

  //FHAPO / FHAPO_UNFIXED

  CommodityDeal.DerivativeContrSpecification,
  CommodityDeal.MarketIdentifierCode,
  CommodityDeal.CompanyCode,
  CommodityDeal.CommodityPriceExposure,
  CommodityDeal.CommodityPriceExposureVersion,
  CommodityDeal.DeliveryDate,

  @Semantics.amount.currencyCode: 'PaymentCurrency'
  CommodityDeal.CmmdtyPriceExpsrPaymentAmount,
  @Semantics.currencyCode: true
  CommodityDeal.PaymentCurrency,

  //Pricing Periods

  CommodityDeal.CalculationPeriodStartDate,
  CommodityDeal.CalculationPeriodEndDate,

  CommodityDeal.TreasuryPositionLongShortCode,

  //FHAPO / FHAPO_UNFIXED//

  @Semantics.quantity.unitOfMeasure: 'CommodityPriceExposureUnit'
  sum( CommodityDeal.CommodityPriceExposureQuantity ) as CommodityPriceExposureQuantity,
  @Semantics.unitOfMeasure: true
  CommodityDeal.CommodityPriceExposureUnit,
  CommodityDeal.IsNotRelevantForMTMRisk,
  CommodityDeal._DerivativeContrSpecification         as _DCS
}
where
       CommodityDeal.IsNotRelevantForMTMRisk       = ''
  and  CommodityDeal.CommodityPriceExposureVersion = '0000000000'
  and(
       CommodityDeal.FinancialInstrProductCategory = '800' // Commodity Forward

    or CommodityDeal.FinancialInstrProductCategory = '810' // Commodity Swap

  )

group by

  CommodityDeal.DerivativeContrSpecification,
  CommodityDeal.MarketIdentifierCode,
  CommodityDeal.CompanyCode,
  CommodityDeal.CommodityPriceExposure,

  CommodityDeal.DeliveryDate,
  CommodityDeal.CmmdtyPriceExpsrPaymentAmount,
  CommodityDeal.PaymentCurrency,
  CommodityDeal.CommodityPriceExposureVersion,

  //Pricing Periods

  CommodityDeal.CalculationPeriodStartDate,
  CommodityDeal.CalculationPeriodEndDate,
  CommodityDeal.IsNotRelevantForMTMRisk,

  CommodityDeal.TreasuryPositionLongShortCode,


  CommodityDeal.CalculationPeriodEndDate,

  CommodityDeal.CommodityPriceExposureUnit
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_DERIVATIVECMMDTYEXPSR"
],
"ASSOCIATED":
[
"I_DERIVATIVECONTRSPEC"
],
"BASE":
[
"I_DERIVATIVECMMDTYEXPSR"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More