User`s guide
4.
In the Create New Connection folder, expand SAP Table, Cluster, or Function.
The "SAP System Logon" dialog box appears.
5.
Log on to an SAP system, provide your user logon credentials, and specify extended logon parameters
as prompted. Then, click Finish.
You return to the "Database Expert" dialog box.
6.
Right-click the connection you created and select Options.
The "Options" dialog box appears, with only the Database tab displayed.
7.
In the Data Explorer area, select the check boxes for the types of data that you want to make available
to the report.
8.
Use the Table name LIKE field to select only a subset of the available data types. Use any of the
following techniques when filtering:
• Type full or partial names of tables.
• Add wildcards to select multiple queries or InfoSets: use a percentage sign (%) to denote any
number of characters; use an underscore (_) to denote a single character. (The % and _ wildcards
correspond respectively to the * and ? wildcards that are used within Windows. The % and _
wildcards also correspond respectively to the * and + wildcards that are used within SAP.)
• Clear the field and click OK to proceed without filtering. Note, however, that there is a limit to the
number of objects that can be displayed in the Data Explorer. If the number of queries or InfoSets
in SAP exceeds this limit (which is by default 8000), you may receive an Out of Memory error or
a blank Data Explorer.
9.
In the Tables and Fields area, select Show Description.
10.
Click OK.
The Database Expert displays the selected clusters, tables, or functions, along with the descriptions
that were defined by the SAP administrator. Three branches appear under the data connection that
you created:
• ABAP Function modules
• Data Clusters
• Data Dictionary
11.
In the Available Data Sources area, double-click the tables, clusters, or functions that you want to
add to the report.
Tip:
You can also CTRL-click multiple tables and then click >.
12.
Click OK.
If you selected multiple tables for the report, you must provide table-linking information. For more details,
see Linking tables and views. If you selected a single table, you can now add fields to the report.
2012-03-14598
Integrating Business Applications with Crystal Reports