Crystal Reports Based on SAP Function Module and Transperant Tables

[Former Member]

Hi,

I need to develop reports based on SAP trasperant tables and to filter the records I require to use one of the function module in SAP.

I have created parameters in Crystal reports that are required for the function to execute and are included in the where clause of the query. This helped the fuction to get those parameters and execute it.

The thing is that the fuction works fine with one set of parameters and gives accurate results both in SAP and Crystal Reports.

But fails for other set of parameters.

It works fine when we directly execute function in SAP produces a record set. But, when we pass those parameters from Crystal Reports it fetches no data.

Can anybody tell me the exact procedure to use function module and transperent tables together in Crystal Reports ?

Thanks in Advance.

Niwas Joshi

[Former Member · Accepted solution]

Hi,

This is going to be hard to explain, however you need to recognize that the function has input and possibly output (export) parameters. Crystal Reports is able to work with these parameters. However it is up to you to figure out how these parameters are used effectively to give you the correct results when joining the function with other data sources such as transparent tables.

If you're using transparent tables and functions in a Crystal Report, then you need to link these objects in such a way so that a left outer join for example is using the function's output parameters to join to the transparent table equivalent fields. However if the table is the starting point then the joins from the table should join the Input parameters of your function.

you can set these joins in the Database menu | Database Expert | Links of Crystal Reports.

[Former Member · Accepted solution]

Hi Mike,

The problem is resolved, as you pointed out correctly need to analyse the database and use of function. Establishing appropriate joins between table and function in Crystal Reports, made it possible.

Thanks for your reply.

Thanks and Regards,

Niwas