Commodity Position End of Day for Logistics (RL)
The Analytical Model "Commodity Position End of Day for Logistics (RL) (SAP_CMM_RL_PositionLogcEoD) provides the position of physical contracts 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 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 for Logistics (HL) (SAP_CMM_HL_PositionLogcEoD) of this model contains the Unit Conversion logic that converts the measures that are coming from ACRA in Mass and Volume units to the user-selected mass and volume units from the prompt screen.
Following are the metrics that are available through this model:
|
Metric Technical Name |
Metric Description |
Calculation |
|---|---|---|
|
CommodityQuantity |
Commodity Quantity |
Straight Mapping from ACRA |
|
UnrlzdContrQty |
Unrealized Contract Quantity |
Straight Mapping from ACRA |
|
UnrlzdUnprcContrQty |
Unrealized Unpriced Contract Quantity |
Straight Mapping from ACRA |
|
UnrlzdPricedContrQty |
Unrealized Priced Contract Quantity |
Straight Mapping from ACRA |
|
TodayUnrlzdUnprcContrQty |
Today Unrealized Unpriced Contract Quantity |
Straight Mapping from ACRA |
|
TodayUnrlzdPricedContrQty |
Today Unrealized Priced Contract Quantity |
Straight Mapping from ACRA |
|
UnrlzdGdsRcptContrQty |
Unrealized Goods Receipt Contract Quantity |
Straight Mapping from ACRA |
|
UnrlzdGdsIssContrQty |
Unrealized Goods Issue Contract Quantity |
Straight Mapping from ACRA |
|
MaterialStockContrQty |
Stock on Hand Quantity |
Straight Mapping from ACRA |
|
MaterialStockMrktQty |
Stock on Hand Market Quantity |
Straight Mapping from ACRA |
|
UnrlzdMrktQty |
Unrealized Market Quantity |
Straight Mapping from ACRA |
|
UnrlzdGdsRcptMrktQty |
Unrealized Goods Receipt Market Quantity |
Straight Mapping from ACRA |
|
UnrlzdGdsIssMrktQty |
Unrealized Goods Issue Market Quantity |
Straight Mapping from ACRA |
|
OutrightExposureQty |
Outright Exposure Quantity |
UnrlzdUnprcContrQty + UnrlzdMrktQty + MaterialStockMrktQty + UnrlzdGdsRcptMrktQty + UnrlzdGdsIssMrktQty |
|
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. |