Agri Commodity Position Intraday Current for Logistics and Derivatives (RL)

The Analytical Model "Agri Commodity Position Intraday Current for Logistics and Derivatives (RL) (SAP_CMM_AGRI_RL_PositionIntradayCurrent) shows the current position across logistics documents and derivative instruments.

The model values all positions using the End-of-Day (EoD) Snapshot associated with the corresponding snapshot date as a basis for subsequent updates. Whenever a new End-of-Day process is started for a snapshot group, calculating either EoD positions for Logistics or Derivatives, a new ‘base snapshot date’ is set for Intraday. To maintain consistent valuation across logistics and derivatives, the model ensures that the underlying base snapshot dates remain synchronized between both areas.

If the snapshot dates for logistics and derivatives become misaligned for a snapshot group, the model automatically filters the data exclusively for the most recent available base snapshot date. This applies regardless of whether the latest base snapshot originates from logistics or from derivatives.

Data for this model is replicated from SAP Advanced Commodity Risk Analytics using a Replication Flow. Following the layered architecture, data is first processed in the inbound layers, where it is filtered according to the selected criteria and where consistency between logistics and derivatives is ensured. In the Harmonization Layer, the data is associated with the appropriate dimensions and units of measure.

The Harmonization Layer view “Commodity Position Intraday Current (HL)” (SAP_CMM_HL_PositionIntradayCurrent) serves as the core consolidation view for this model. It includes a union node that combines two HL-layer views:

  • Commodity Position Intraday Current for Derivatives (HL) (SAP_CMM_HL_PositionDrvtvIntradayCurrent)

  • Commodity Position Intraday Current for Logistics (HL) (SAP_CMM_HL_PositionLogcIntradayCurrent)

This structure ensures that logistics and derivatives intraday positions are harmonized and made available in a unified analytical model.

The following metrics are provided by this model:

Metric Technical Name

Metric Description

Calculation

CommodityQuantity

Commodity Quantity

Union of Logistics and Derivatives

UnrlzdContrQty

Unrealized Contract Quantity

Mapped to Logistics from ACRA

UnrlzdUnprcContrQty

Unrealized Unpriced Contract Quantity

UnrlzdUnprcContrQty from Logistics + (UnpricedFinancialPositionQty from Derivatives)*-1

UnrlzdGdsRcptContrQty

Unrealized Goods Receipt Quantity

UnrlzdGdsRcptContrQty from Logistics

UnrlzdGdsIssContrQty

Unrealized Goods Issue Quantity

UnrlzdGdsIssContrQty from Logistics

MaterialStockContrQty

Stock on Hand Quantity

MaterialStockContrQty from Logistics.

MaterialStockMrktQty

Stock on Hand Market Quantity

MaterialStockMrktQty from Logistics

UnrlzdMrktQty

Unrealized Market Quantity

UnrlzdMrktQty from Logistics + MarketQty from Derivatives

UnrlzdGdsRcptMrktQty

Unrealized Goods Receipt Market Quantity

UnrlzdGdsRcptMrktQty from Logistics

UnrlzdGdsIssMrktQty

Unrealized Goods Issue Market Quantity

UnrlzdGdsIssMrktQty from Logistics

NetMaterialStockMrktQty

Net Material Stock Market Quantity

NetMaterialStockMrktQty from Logistics

NetUnrlzdGdsRcptMrktQty

Net Unrealized Goods Receipt Market Quantity

NetUnrlzdGdsRcptMrktQty from Logistics

NetUnrlzdGdsIssMrktQty

Net Unrealized Goods Issue Market Quantity

NetUnrlzdGdsIssMrktQty from Logistics

NetMaterialStockContrQty

Net Stock on Hand Quantity

NetMaterialStockContrQty from Logistics

netUnrlzdGdsRcptContrQty

Net Unrealized Goods Receipt Quantity

netUnrlzdGdsRcptContrQty from Logistics

netUnrlzdGdsIssContrQty

Net Unrealized Goods Issue Quantity

netUnrlzdGdsIssContrQty from Logistics

NetRlzdStockQty

Net Realized Stock Quantity

NetMaterialStockMrktQty + NetUnrlzdGdsRcptMrktQty + NetUnrlzdGdsIssMrktQty

UnDlvrdMrktQty

Undelivered Market Quantity

UnDlvrdMrktQty from Logistics + MarketQty from Derivatives

DlvrdMrktQty

Delivered Market Quantity

DlvrdMrktQty from Logistics

OutrightExposureQty

Outright Exposure Quantity

Outright Exposure Quantity from Derivatives + Outright Exposure Quantity from Logistics

OutrightExposureQtyCurMnth

Outright Exposure Quantity Current Month

Outright Exposure Quantity if User selected Adjusted Reporting Date is in same month as Snapshot Date.

OutrightExposureQtyNxtMnth

Outright Exposure Quantity Next Month

Outright Exposure Quantity if Adjusted Reporting Date is next month of User selected Snapshot Date.

UnDlvrdContrQty

Undelivered Contract Quantity

UnrlzdContrQty if DataSourceType = "01"

DlvrdContrQty

Delivered Contract Quantity

UnrlzdContrQty if ContrPriceExposureIsExecuted = "X"

OutboundStockInTransitQty

Outbound Stock In Transit Quantity

NetUnrlzdGdsIssMrktQty if StorageLocation = ""

RlzdStockQty

Realized Stock Quantity

MaterialStockMrktQty + UnrlzdGdsIssMrktQty + UnrlzdGdsRcptMrktQty