ALV list & select option

[Former Member]

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.

[Former Member]

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.

[Former Member]

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!

[Former Member]

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..

[Former Member]

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

[Former Member]

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

Thak you.

[uwe_schieferstein]

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