P_CmmdtyFinVersSumQtyTrans

DDL: P_CMMDTYFINVERSSUMQTYTRANS Type: view COMPOSITE
15 Fields 1 Data Sources

Commodity Financial Transaction

P_CmmdtyFinVersSumQtyTrans is a Composite CDS View that provides data about "Commodity Financial Transaction" in SAP S/4HANA. It reads from 1 data source (I_DerivativeCmmdtyExpsr) and exposes 15 fields.

Data Sources (1)

SourceAliasJoin Type
I_DerivativeCmmdtyExpsr CommodityDeal from

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName PCMMFINTRSQTY view
AbapCatalog.compiler.compareFilter 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
EndUserText.label Commodity Financial Transaction view

Fields (15)

KeyFieldSource TableSource FieldDescription
DerivativeContrSpecification I_DerivativeCmmdtyExpsr DerivativeContrSpecification DCS ID
MarketIdentifierCode I_DerivativeCmmdtyExpsr MarketIdentifierCode MIC
CompanyCode I_DerivativeCmmdtyExpsr CompanyCode Receiver Company Code
CommodityPriceExposure I_DerivativeCmmdtyExpsr CommodityPriceExposure Exposure ID
CommodityPriceExposureVersion I_DerivativeCmmdtyExpsr CommodityPriceExposureVersion Exposure Version
DeliveryDate I_DerivativeCmmdtyExpsr DeliveryDate Delivery Date
CmmdtyPriceExpsrPaymentAmount I_DerivativeCmmdtyExpsr CmmdtyPriceExpsrPaymentAmount Value Amount
PaymentCurrency I_DerivativeCmmdtyExpsr PaymentCurrency Payment Currency
CalculationPeriodStartDate I_DerivativeCmmdtyExpsr CalculationPeriodStartDate Calc. Start Date
CalculationPeriodEndDate I_DerivativeCmmdtyExpsr CalculationPeriodEndDate Calc. End Date
TreasuryPositionLongShortCode I_DerivativeCmmdtyExpsr TreasuryPositionLongShortCode Long/Short Position
CommodityPriceExposureQuantity
CommodityPriceExposureUnit I_DerivativeCmmdtyExpsr CommodityPriceExposureUnit Unit of Measure
IsNotRelevantForMTMRisk I_DerivativeCmmdtyExpsr IsNotRelevantForMTMRisk Reporting Relevant
_DCS I_DerivativeCmmdtyExpsr _DerivativeContrSpecification

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view P_CmmdtyFinVersSumQtyTrans.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.

CREATE VIEW P_CmmdtyFinVersSumQtyTrans AS
SELECT
  CommodityDeal.DerivativeContrSpecification AS DerivativeContrSpecification,
  CommodityDeal.MarketIdentifierCode AS MarketIdentifierCode,
  CommodityDeal.CompanyCode AS CompanyCode,
  CommodityDeal.CommodityPriceExposure AS CommodityPriceExposure,
  CommodityDeal.CommodityPriceExposureVersion AS CommodityPriceExposureVersion,
  CommodityDeal.DeliveryDate AS DeliveryDate,
  CommodityDeal.CmmdtyPriceExpsrPaymentAmount AS CmmdtyPriceExpsrPaymentAmount,
  CommodityDeal.PaymentCurrency AS PaymentCurrency,
  CommodityDeal.CalculationPeriodStartDate AS CalculationPeriodStartDate,
  CommodityDeal.CalculationPeriodEndDate AS CalculationPeriodEndDate,
  CommodityDeal.TreasuryPositionLongShortCode AS TreasuryPositionLongShortCode,
  sum( CommodityDeal.CommodityPriceExposureQuantity ) AS CommodityPriceExposureQuantity,
  CommodityDeal.CommodityPriceExposureUnit AS CommodityPriceExposureUnit,
  CommodityDeal.IsNotRelevantForMTMRisk AS IsNotRelevantForMTMRisk,
  CommodityDeal._DerivativeContrSpecification AS _DCS
FROM I_DerivativeCmmdtyExpsr AS CommodityDeal
;

Learn More