topic ALV list & select option in Application Development and Automation Discussions

ALV list & select option

Former Member — Wed, 04 Mar 2009 14:47:11 GMT

Hi experts,

i have two problems. If someone could help me...

1) I have a select option for mara-mfrpn and a select. If in this select option i have select more than 5000 entries SAP gives me an ABAP short dump.

Error in the module RSQL accessing the database interface.

What should i do? I want to run this program using more than 60.000 entries in select option.

SELECT-OPTIONS: mfrpn FOR mara-mfrpn OBLIGATORY
.
.
.
SELECT mara~matnr mara~mfrpn mara~mfrnr makt~maktx
  FROM mara INNER JOIN makt ON mara~matnr = makt~matnr
  INTO CORRESPONDING FIELDS OF it_npfmfrnr
  WHERE mara~mfrnr = mfrnr AND mara~mfrpn IN mfrpn AND makt~spras =
spras.

2)In same program i have a ALV list. I want to color some lines according to some conditions.

How can i do that? I mention that i have used two function:

REUSE_ALV_FIELDCATALOG_MERGE

REUSE_ALV_LIST_DISPLAY

Thank you.

Re: ALV list & select option

Former Member — Wed, 04 Mar 2009 14:53:58 GMT

Hi Dan,

!) for avoiding the shot dump in the select query you can set the Packet Size in that qurey.

for how to set the packet size you can get the from the F1 help on select query.

2) For setting the color refer to this

hope it helps you.

Regards!

Re: ALV list & select option

Former Member — Wed, 04 Mar 2009 14:57:08 GMT

HI,

For the point.

1. Remove the inner join between the MARA & MAKT get the data in two different table t_MARA & t_MAKT..

Loop through the t_mara reak the t_MAKT for the coreespondng material and update the final table whcih is used to output the data.

or you can use thw Packet Size

2. Refer to this link..

Re: ALV list & select option

Former Member — Wed, 04 Mar 2009 14:58:54 GMT

You can convert the IN mfrpn to a FOR ALL ENTRIES.

I don't see how using PACKAGE SIZE or splitting the SELECT would help.

Rob

Edited by: Rob Burbank on Mar 4, 2009 10:00 AM

Re: ALV list & select option

Former Member — Thu, 05 Mar 2009 08:31:28 GMT

It works with FOR ALL ENTRIES. I didn't try with PACKET SIZE.

Thak you.

Re: ALV list & select option

uwe_schieferstein — Thu, 05 Mar 2009 09:01:18 GMT

Hello Dan

Regarding colouring in ALV you may have a look at thread

The same solution should be applicable for old-fashioned fm-based ALV lists.

Regards

Uwe