Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

Warning message

former_member189354
Contributor
0 Kudos

Hi,

Iam executing one of the userdefined report it many selection fields defined with select-options statments.

When Iam executing using F8 key it gives warnig message saying that selection was not restricted. Can any body help in this regard. Thanks in advance.

bye,

MSN.

5 REPLIES 5

Former Member
0 Kudos

May be you have too many fields for selection and you are not entering KEY values, which means you are tryign to acess lot of data.

Rgds,

Manohar

0 Kudos

I guess it is just to warn you that the report can take a long time to run, because you do not restrict in the selection screen.

Former Member
0 Kudos

Hi MSN,

This warning is to inform you that, as you have not restricted the selection of the data, the following consequences may apply:

1. The report will contain a large amount of data (potentially too much to be useful)

2. The report will be very slow to run (as it will most likely have to do table scans to access data rather than selecting using primary key indexes)

3. As a consequence of 2, it may timeout due to running too long and short dump giving you no result

4. Due to the large number of data to be selected, the execution of the report may affect the overall system performance as CPU time is dedicted to the database to perform the selection.

Thus, it is recommending that you fill in some of the selection criteria in order to minimise the risk of encountering problems 1 through 4.

Cheers,

Brad

0 Kudos

Hi,

This warning message comes after upgrading to the serice patch to server.

bye,

MSN.

0 Kudos

Thanks MSN,

So, with the latest service pack, SAP has introduced the warning message into the report code as this report must have been causing problems in some environments.

That makes sense.

If you are happy then please close the thread.

Cheers,

Brad