Commodity Position Intraday Current for Logistics and Derivatives (RL)

The Analytical Model "Commodity Position Intraday Current for Logistics and Derivatives (RL) (SAP_CMM_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 are synchronized between the two 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

UnrlzdPricedContrQty

Unrealized Priced Contract Quantity

UnrlzdPricedContrQty from Logistics + PricedFinancialPositionQty from Derivatives

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

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.