03-04-2009 2:47 PM
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.
03-04-2009 2:53 PM
03-04-2009 2:57 PM
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..
03-04-2009 2:58 PM
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
03-05-2009 8:31 AM
It works with FOR ALL ENTRIES. I didn't try with PACKET SIZE.
Thak you.
03-05-2009 9:01 AM
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