Queries of Commodity Price Exposures
The Commodity Position Overview uses table TBAT_CTY_EXPOS
as a data basis.
You can use the Query Monitor (transaction RSRT
) to create BEx queries for different user interfaces (such as BEx UI) and make the settings for their properties (such as filters).
If you use the SAP Web Dynpro ABAP
user interface, you select a query by entering the technical name in the format COEX_RISK_QUERY_COMPCONF_Q*
.
Risk Profile 100
The following BEx queries are available:
Commodity Position Overview (
0CFM_CFTY_EXP_Q0001
)Commodity Position Fixing Overview (
0CFM_CTY_EXP_Q0002
)Historic Commodity Position Overview (
0CFM_CTY_EXP_Q0006
)
Risk Profile 200
The following BEx queries are available:
Commodity Position Overview (
0CFM_CTY_EXP_Q2001
)Commodity Position Overview (hierarchical)
0CFM_CTY_EXP_Q2003
Historic Commodity Position Overview (
0CFM_CTY_EXP_Q2002
)Historic Commodity Position Overview (hierarchical) (
0CFM_CTY_EXP_Q2004
)
Risk Profile 300
The following BEx queries are available:
Commodity Position Overview (
0CFM_CFTY_EXP_Q3003
)Commodity Position Overview (hierarchical) (
0CFM_CTY_EXP_Q3001
)Historic Commodity Position Overview (
0CFM_CTY_EXP_Q3004
)Historic Commodity Position Overview (hierarchical) (
0CFM_CTY_EXP_Q3002
)
Activities
To execute queries, proceed as follows:
Call transaction
Query Monitor
(RSRT
).Choose a BEx query and the value
BEx Analyzer
. Then chooseExecute
.Specify a date in the
Valid From
andExposure Due Date
fields.Choose
Execute
.
You can select additional data using the selection lists Rows
, Columns
, and Free Characteristics
. Alternatively, you can use the context menu.