Agri Commodity Position End of Day for Logistics and Derivatives (RL)
The Analytical Model "Agri Commodity Position End of Day for Logistics and Derivatives (RL) (SAP_CMM_AGRI_RL_PositionEoD)" provides the position of both logistics contracts as well as derivatives on the selected day.
This model takes a mandatory prompt for Snapshot Date to pick the required snapshot from the LocalTable, which is defaulted to the current day.
1. Data for this model is replicated from SAP Advanced Commodity Risk Analytics using Replication Flow. By following the layering approach, data is filtered in inbound layers for the selected Snapshot Date, associated with corresponding dimensions and units of measure in the Harmonization layer.
2. Harmonization layer view Commodity Position End of Day (HL) (SAP_CMM_HL_PositionEoD) of this model contains a union node based on 2 HL layer views: One for Derivatives End of Day (SAP_CMM_HL_PositionDrvtvEoD) and another for Logistics End of Day (SAP_CMM_HL_PositionLogcEoD).
|
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 *not available in dedicated Logistics AnaModel |
|
UnrlzdGdsRcptContrQty |
Unrealized Goods Receipt Contract Quantity |
UnrlzdGdsRcptContrQty from Logistics *not available in dedicated Logistics AnaModel |
|
UnrlzdGdsIssContrQty |
Unrealized Goods Issue Contract Quantity |
UnrlzdGdsIssContrQty from Logistics *not available in dedicated Logistics AnaModel |
|
MaterialStockContrQty |
Material Stock Contract Quantity |
MaterialStockContrQty from Logistics. *not available in dedicated Logistics AnaModel |
|
MaterialStockMrktQty |
Material Stock 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 Material Stock Contract 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' |