User`s guide

In order to overcome these issues, the individual components of data clusters must be mapped as
tables. You can do this by creating a dictionary of the clusters on a particular SAP system.
Mapping ABAP data clusters
The Cluster Definition tool (transaction ZCDD) enables you to create a dictionary of the data clusters
on your SAP system. Once you have added a data cluster to the dictionary, you can select the cluster
in Crystal Reports and report off its data with the Open SQL driver. You will usually require prior
experience with ABAP programming because you need to find the cluster definitions within R/3 before
you enter them with the Cluster Definition tool.
The following procedures show how to map the SALDO table (Time balances per period) to your
dictionary of data clusters with the Cluster Definition tool. The SALDO table is located in the B2 (PDC
Data (Month)) cluster area of the ABAP data cluster that is stored in the PCL2 (HR cluster 2) transparent
table. In this case, PCL2 is the cluster database, B2 is the cluster area or type, and SALDO is the table.
The procedures listed below correspond to SAP R/3 4.6b:
Creating a new cluster entry in the dictionary
This section guides you through the process of defining a new cluster entry in the dictionary.
To create a new cluster entry in the dictionary
1.
From the SAPGUI, execute transaction ZCDD.
The Cluster Definition tool displays its "View Cluster Id Table" screen.
2.
Click Add to create a new entry.
The "Edit Cluster ID Record" screen appears.
3.
In the Cluster Database field, type the name of the table in which the ABAP data cluster is stored.
For this example, type PCL2.
Note:
To find out which transparent table contains a required ABAP data cluster, ask a subject matter
expert about the module on which you are working. Or, if you are trying to locate the data from a
particular program (such as an SAP report like RPC11XE0), look for the table in the ABAP code.
When you find the table, look at the data in the RELID field for a list of cluster areas.
4.
In the Cluster Area field, type the name of the cluster area or RELID.
For this example, type B2.
5.
Click Save and exit the Cluster Definition tool.
You now need to find the key to the cluster area. Specifically, you need the name of the dictionary
structure or table in which the key fields are stored, and you need the names of those key fields. To
locate the cluster area's key fields, go to the next section, Locating the cluster area's key fields.
2012-03-14605
Integrating Business Applications with Crystal Reports