Example: Easy Query API
The following graphic shows a simple query with two characteristics ('Calendar Year' and 'Customer' rows). The 'Customer' characteristic contains a hierarchy and the 'Net Sales' key figure is listed under columns.
This type of query can be displayed as follows in query monitor (transaction RSRT):
The result of the easy query for this query looks different. This is because the easy query formats the data so that it can be displayed by various different tools for specific applications. The result consists of the following tables:
|
0D_FC_CUST |
0CALYEAR |
0D_FC_NETSA |
0D_FC_NETSA_F |
|---|---|---|---|
|
Group 2 |
2004 |
3.00 |
3,00 EUR |
|
Group 2 |
2005 |
2.00 |
2.00 EUR |
|
Group 2 |
2006 |
2.00 |
2.00 EUR |
|
Group 2 |
2007 |
5.00 |
5.00 EUR |
|
Group 2 |
2008 |
0 |
0.00 EUR |
|
Group 2 |
TOTAL |
12.00 |
12.00 EUR |
|
Anchor Inn |
2005 |
2.00 |
2.00 EUR |
|
Anchor Inn |
2006 |
2.00 |
2.00 EUR |
|
Anchor Inn |
TOTAL |
4.00 |
4.00 EUR |
|
Banquetes Bennati Ltd |
2004 |
3.00 |
3,00 EUR |
|
Banquetes Bennati Ltd |
2008 |
0 |
0.00 EUR |
|
Banquetes Bennati Ltd |
TOTAL |
3.00 |
3,00 EUR |
|
Capri Creations Ltd |
2004 |
0 |
0.00 EUR |
|
Capri Creations Ltd |
2007 |
5 |
5.00 EUR |
|
Capri Creations Ltd |
2008 |
0 |
0.00 EUR |
|
Capri Creations Ltd |
TOTAL |
5 |
5.00 EUR |
Every key figure (in this case 0D_FC_NETSA) appears twice in the table: Once in column 0D_FC_NETSA unformatted for graphical display by corresponding applications and once in column 0D_FC_NETSA_F formatted according to the local user settings.
|
COLUMN_NAME |
COLUMN_TYPE |
COLUMN_DESCRIPTION |
|---|---|---|
|
0D_FC_CUST |
C |
Customer |
|
0CALYEAR |
C |
Calendar Year |
|
0D_FC_NETSA |
K |
Net sales |
|
0D_FC_NETSA_F |
K |
Net sales (formatted) |
Table E_T_COLUMN_DESCRIPTION contains the metadata for the column description: technical name of column, column type, description.
|
COLUMN_NAME |
COLUMN_TYPE |
COLUMN_DESCRIPTION |
|
0D_FC_CUST |
C |
Customer |
|
0CALYEAR |
C |
Calendar Year |
|
0D_FC_NETSA |
K |
Net sales |
|
0D_FC_NETSA_F |
K |
Net sales (formatted) |
Table E_T_COLUMN_DESCRIPTION contains the metadata for the column description: technical name of column, column type, description.
|
ROW_ID |
COLUMN_ID |
VALUE_TYPE |
PARENT_ROW_ID |
HIER_LEVEL |
|
1 |
1 |
E |
0 |
0 |
|
2 |
1 |
E |
0 |
0 |
|
3 |
1 |
E |
0 |
0 |
|
4 |
1 |
E |
0 |
0 |
|
5 |
1 |
E |
0 |
0 |
|
6 |
1 |
E |
0 |
0 |
|
6 |
2 |
T |
0 |
0 |
|
7 |
1 |
L |
6 |
2 |
|
8 |
1 |
L |
6 |
2 |
|
9 |
1 |
L |
6 |
2 |
|
9 |
2 |
T |
0 |
0 |
|
10 |
1 |
L |
6 |
2 |
|
11 |
1 |
L |
6 |
2 |
|
12 |
1 |
L |
6 |
2 |
|
12 |
2 |
T |
0 |
0 |
|
13 |
1 |
L |
6 |
2 |
|
14 |
1 |
L |
6 |
2 |
|
15 |
1 |
L |
6 |
2 |
|
16 |
1 |
L |
6 |
2 |
|
16 |
2 |
T |
0 |
0 |
Table E_T_ROW_DESCRIPTION contains the metadata required to interpret the value table: Row number, column number, value type; for hierarchies: row number of parent, hierarchy level.
Our example contains four totals (rows 6, 9, 12, 16) for the second characteristic (calendar year). An application program can use type T to highlight total rows or subtotal rows in a specific color. The fields PARENT_ROW_ID (row number of parent) and HIER_LEVEL (hierarchy level) are empty in total and subtotal rows.
The values can be nodes or leaves if a characteristic is displayed as a hierarchy. Nodes can be expanded or collapsed. Every row indicates the node type (E, C, L), the parent and the hierarchy level. Using the parent and hierarchy level, you can assign a node to its predecessor and indent the node to suit the hierarchy structure.