To enter commodity market data, Treasury and Risk Management uses logistic structures. The quotation types and quotation sources are mapped to link Treasury and Risk Management to the logistics market data. The functions required to enter commodity prices are available in market data management in the basic functions. We recommend that you use the tables for the Commodity Pricing Engine (CPE). These have been integrated into the functions in Treasury and Risk Management.
Note
If you want to use the old logistics tables rather than the CPE tables, you need to manually integrate them into the functions in Treasury and Risk Management. However, the system helps you map the quotation types and quotation sources.
You create the commodities master data by choosing
See also: Commodity Master Data
You can enter market data either manually or via the Datafeed.
The system accesses the commodity prices and their volatilities to calculate the net present values of commodity futures and options on commodity futures in the Market Risk Analyzer. The net present values are calculated using the function Net Present Value Analysis: Display Single Values (JBRX) or Key Figure Analysis (transaction AISGENKF).
The market data is accessed as follows:
The quotation type is read from the evaluation type.
The quotation name is read from the commodity master data.
The relevant CPE quotation type is determined using the IMG activity Define Quotation Types and Assign Logistic Quotation Types.
The required details, such as the calendar, are read from the IMG activity Define Quotation Names
The default quotation source is read from the commodity master data.
The relevant CPE quotation source is determined using the IMG activity Define Quotation Sources and Assign Logistic Quotation Sources.
The system uses the quotation name, source, type, and date to read the price table under
If a suitable entry is not found, the system looks for an appropriate quotation name, type, and date, regardless of the quotation source. If more than one suitable entry is found, the system uses the most recent price.
The Statistics Calculator in the Market Risk Analyzer calculates the volatilities corresponding to the commodity prices entered.
To enter the market data in the application, you first need to make the following settings in Customizing for Treasury and Risk Management:
To do this, choose
Under Define Quotation Source, you create the various quotation sources that you are using to import the commodity prices and other information
Under Define Quotation Types, you create the quotation types for a commodity. The quotation type is used together with the quotation source and name in the key that the system uses to access the quotations.
Choose Define Quotation Name to enter the quotations whose price trends are registered in the system. For the quotation name, you enter the currency, price unit, and the unit in which the quotation is specified (as opposed to the actual quotation price). Notes:
We recommend that you give the quotation and commodity ID the same name.
In the commodity master data, you assign the quotation name on the Quotation Data tab page.
Choose
Define Quotation Types and Assign Logistic Quotation Types
Define Quotation Sources and Assign Logistic Quotation Sources
Choose
to define your market data provider for commodities.Choose New Entries.
Define a short name and a description of the market data provider.
Save your entries.
Assign a volatility to each commodity ID. The volatility is required when you calculate the net present values of commodity futures and options on commodity futures.
Choose
.You can enter the quotation type and maximum age in days for the evaluation type general details on the Evaluation Control tab page in the Commodities area. The quotation types available are taken from the IMG activity Define Quotation Types and Assign Logistic Quotation Types.
The settings for the old logistics tables for commodities are available under
Under Define Quotation Data Source, you create the various quotation sources that you are using to import the commodity prices and other information
Under Define Quotation Types, you create the quotation types for a commodity. The quotation type is used together with the quotation source and name in the key that the system uses to access the quotations.
Under Define Quotation Data, you create quotation keys for each source and quotation type. Entries are made for the quotation keys including the currency, (sales) quantity, unit of measure, factory calendar, and a description of the key.
The commodity prices/quotations are defined and published by exchanges or agencies, such as Platts or Reuters. To store the prices in the system, proceed as follows:
You can create and change prices or quotations.
You can import price quotations into the ERP system using the external partner program of your data provider. We deliver the Datafeed interface to the ERP system for which different data providers are certified.
You can enter commodity market data in the following tables:
You can use the functions Enter Commodity Prices (CPE), Display Commodity Prices (CPE) and Enter Commodity Prices in the area menu by choosing
.The price quotations are distinguished by origin, type, and name, and entered on a quotation date.
When you create or import the price quotation, the system uses the default values for the currency, price unit, and unit of measure, that you specified in the IMG activity Define Quotation Name.
Example
Price Quotation
Attributes |
Value |
Description |
Source |
PL |
Platts agency |
Quotation type |
H |
Highest price |
Quotation name |
Brent (dated) |
North Sea crude oil |
Price quotation date |
01/05/2005 |
|
Price quotation |
51.03 |
|
Quotation currency |
USD |
US Dollar |
Quotation price unit |
1 |
|
Unit of measure |
BBL |
Barrel |
See also:
You enter the current volatilities for the commodity prices in Customizing by choosing
.To enter the commodity prices in the old logistics tables, in Customizing choose
.