Show TOC

 Lookup for BW Variant Names

When requesting transaction data from SAP BW, SAP CRM looks for BW variants in the order described below. As soon as a BW variant has been found, the subsequent steps for the lookup are no longer executed.

  1. The system first checks whether any generic variant definitions exist (variants that have the prefix BWA_).

  2. The variant name entered directly in the detail settings of a query request is applied. You can therefore enter a variant for all users. Since this only makes sense in relatively few cases, a name rarely appears at this point.

  3. The variants that you can enter via the Users pushbutton in the Query Request screen are applied in queries for all users.

  4. If no variants are entered there either, the system then looks for variants with names matching those of the users concerned. This is probably the most common scenario, whereby variants for all queries should be created with the name MILLER for user MILLER. In this way, no other entries need to be made on the SAP CRM Server for BW requests.

  5. Finally, if no such variants are found either, a variant with a name matching the corresponding role is taken. Note that, since role names can be longer than variant names, this method cannot always be applied.

  6. If the system has been unable to find a variant by this step, an error message appears, and the query cannot be executed. This means that no entries are generated for the tables SMOREPMA and SMOREPMAL.