Standard Queries for the Transaction Manager

SAP Query supports a wide range of options for defining reports (queries) and creating different report types, such as basic lists, statistics and ranked lists. Reports (queries) are simple to create. By selecting an InfoSet, you can specify which fields in the query you require for evaluations.

Several sample standard queries have been defined based on the InfoSets for the Transaction Manager . You can use these standard queries:

For immediate execution as they are
As templates for your own queries
- You can use the queries delivered with the system for creating your own queries, or add further characteristics and key figures to reflect your own requirements.
- However, you can only copy queries if you have change authorization.
- You can copy all queries within a user group. Queries from other user groups can only be copied if the InfoSet used to define the query is assigned to both user groups.

The standard queries are located in the report structure of the Transaction Manager Information System as well as in transaction SAP Query: Start Queries [SQ00] under the user group /SAPQUERY/T1 = Queries for the TRM area.

Evaluation of positions for a given key date

Query	Technical Name	Assigned InfoSet	Logical Database
Position Overview	CFM_POS_1	/SAPQUERY/CFM_POSITIONS	FTI_TR_POSITIONS
IAS Classification	CFM_POS_2	/SAPQUERY/CFM_POSITIONS	FTI_TR_POSITIONS
Rating Analysis Securities	CFM_POS_4	/SAPQUERY/CFM_POSITIONS	FTI_TR_POSITIONS
Total Commitment	CFM_POS_12	/SAPQUERY/CFM_POSITIONS	FTI_TR_POSITIONS
Country Analysis	CFM_POS_5	/SAPQUERY/CFM_POSITIONS	FTI_TR_POSITIONS
Accounting Overview	CFM_POS_08	/SAPQUERY/CFM_POSITIONS	FTI_TR_POSITIONS
Simulated Valuation	CFM_POS_11	/SAPQUERY/CFM_POSITIONS	FTI_TR_POSITIONS
Remaining Term Statistics	CFM_POS_06	/SAPQUERY/CFM_POSITIONS	FTI_TR_POSITIONS
Share of Position	CFM_POS_07	/SAPQUERY/CFM_POSITIONS	FTI_TR_POSITIONS
TOP 5 -Security Items (market value view)	CFM_POS_09	/SAPQUERY/CFM_POSITIONS	FTI_TR_POSITIONS
Currency Analysis	CFM_POS_10	/SAPQUERY/CFM_POSITIONS	FTI_TR_POSITIONS
Issue Position	CFM_POS_13	/SAPQUERY/ CFM_ISSUE_POS	FTI_TR_POSITIONS
ABS MBS Positions	CFM_POS_14	/SAPQUERY/CFM_ABSMBS_POS	FTI_TR_POSITIONS

Evaluation of flows/position trend (within a period)

Query	Technical Name	Assigned InfoSet	Logical Database
Book Value / OCI Trend	CFM_PER_03	/SAPQUERY/CFM_PERIODS	FTI_TR_PERIODS
Position Trend	CFM_PER_02	/SAPQUERY/CFM_PERIODS	FTI_TR_PERIODS
Due Date Grid	CFM_MAT_01	/SAPQUERY/CFM_MATUR_CF	FTI_TR_CASH_FLOWS

Evaluation of revenues/turnovers/flows due (within a period)

Query	Technical Name	Assigned InfoSet	Logical Database
Revenues	CFM_REV_01	/SAPQUERY/CFM_REVENUE	FTI_TR_PL_CF
Sales Proceeds	CFM_REV_02	/SAPQUERY/CFM_REVENUE	FTI_TR_PL_CF
Revenue Forecast	CFM_FOR_01	/SAPQUERY/CFM_REV_FCAST	FTI_TR_PL_CF

Issue Evaluations (for a defined key date)

Query	Technical Name	Assigned InfoSet	Logical Database
Issue Position	CFM_POS_13	/SAPQUERY/CFM_ISSUE_POS	FTI_TR_POSITIONS
Issue Volumes	CFM_DEAL_02	/SAPQUERY/CFM_ISSUE	FTI_TR_DEALS
Issue Charges	CFM_DEAL_01	/SAPQUERY/CFM_ISSUE	FTI_TR_DEALS
Issue Hedge	CFM_DEAL_03	/SAPQUERY/CFM_ISSUE	FTI_TR_DEALS

Proceed as follows if you would first like to see an overview of how a certain query is structured :

Use transaction SAP Query: Start Queries [SQ00].
Select one user group and one query.
Choose Description.
This gives you an overview of general information and options for the selected query:
1. The query title
2. Author and user to last make changes
3. Comments regarding the query
4. InfoSet used to define the query
5. The origin of the selected data
6. Generated lists (sublists)
7. Additional selections