P_CmmdtyHdgFinTransQuantitySum

DDL: P_CMMDTYHDGFINTRANSQUANTITYSUM Type: view COMPOSITE Package: FIN_CMM_CMDTY_VDM
6 Fields 4 Data Sources

Commodity Hedge Const. Trans. Quant. Sum

P_CmmdtyHdgFinTransQuantitySum is a Composite CDS View that provides data about "Commodity Hedge Const. Trans. Quant. Sum" in SAP S/4HANA. It reads from 4 data sources (I_CommodityHedgePlanExposure, I_CmmdtyHdgExpsrRelByDteCmpst, I_CmmdtyHdgHdggArRelByDteCmpst, P_CmmdtyHdgCnstltnFinTransQty) and exposes 6 fields with key field CommodityHedgePlanExposureID. Part of development package FIN_CMM_CMDTY_VDM.

Data Sources (4)

SourceAliasJoin Type
I_CommodityHedgePlanExposure cm_exposure inner
I_CmmdtyHdgExpsrRelByDteCmpst I_CmmdtyHdgExpsrRelByDteCmpst inner
I_CmmdtyHdgHdggArRelByDteCmpst I_CmmdtyHdgHdggArRelByDteCmpst inner
P_CmmdtyHdgCnstltnFinTransQty P_CmmdtyHdgCnstltnFinTransQty from

Parameters (1)

NameTypeDefault
P_EvalDate dats

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName PCMMFTRANSQSUM 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 (6)

KeyFieldSource TableSource FieldDescription
KEY CommodityHedgePlanExposureID fintran_qty CommodityHedgePlanExposureID Plan Exposure ID
FinancialTransactionQuantity
FinTransDesignatedQuantity
FinTransPlndDesignatedQuantity
UnitOfMeasure fintran_qty UnitOfMeasure Unit Protected Qty
_CM_Exposure fintran_qty _CM_Exposure

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_CmmdtyHdgFinTransQuantitySum.
-- 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.
-- Parameters: P_EvalDate : dats

CREATE VIEW P_CmmdtyHdgFinTransQuantitySum AS
SELECT
  fintran_qty.CommodityHedgePlanExposureID AS CommodityHedgePlanExposureID,
  sum( fintran_qty.FinancialTransactionQuantity ) AS FinancialTransactionQuantity,
  sum( fintran_qty.FinTransDesignatedQuantity ) AS FinTransDesignatedQuantity,
  sum( fintran_qty.FinTransPlndDesignatedQuantity ) AS FinTransPlndDesignatedQuantity,
  fintran_qty.UnitOfMeasure AS UnitOfMeasure,
  fintran_qty._CM_Exposure AS _CM_Exposure
FROM P_CmmdtyHdgCnstltnFinTransQty
INNER JOIN I_CmmdtyHdgExpsrRelByDteCmpst ON /* join condition not captured in parsed metadata */
INNER JOIN I_CommodityHedgePlanExposure AS cm_exposure ON /* join condition not captured in parsed metadata */
INNER JOIN I_CmmdtyHdgHdggArRelByDteCmpst ON /* join condition not captured in parsed metadata */
;

Learn More