Problems acceding table EDID4

[Former Member]

Hi, i'm newbie in idocs and i have a problem.. There is a report Z which access table EDID4 with the following fields: SEGNUM, SEGNAM, HLEVEL and SDATA. The access with SDATA is "STADA like <value>&"

The problem is that table EDID4 has too many records and when the report arrives to that select, it fails because of timeout exception..

I tried to create an index to that table but adviced that it is not possible... Is there any solution ??? thanks in advance !!!

Maria

[Former Member]

Hi,

You can restrict the records using the idoc number which is passed to the docnum field of the table EDID4.

Hope it works,

Thanks,

Sandeep.

[Former Member]

Hi,

Select Values from SAP Table EDID4, passing the valid(filtered IDOC No.) from EDIDC in a loop.

Timeout will occur, since there will be more records in EDID4, based on Message Type for a Particular IDoc No.

Its the standard Practice for Retrieving IDocs though it hits the Database for every IDoc to overcome the TimeOut Issue.

Hope it helps to solve your Issue.

Regards,

Anbalagan

[Former Member]

no, i think at this point in the program the idoc number is unknown..

[Former Member]

as i have already told.. i don't have the idoc number....

[rainer_hbenthal]

try to run the report in background.

[Former Member]

i'll try it but it's an exit which is run whenever a purchase order is modified.... so i think it won't be possible to run it background...

[Former Member]

I've read in internet that when acceding clusters, it's better to only make the select with the key fileds and for the other fields use "check", i mean, i have the following select:

SELECT SINGLE * FROM edid4 INTO wa_edid4

WHERE segnum = '000001'

AND segnam = 'E1BPRKPFC'

AND hlevel = '01'

AND sdata LIKE gl_rsnum.

maybe it's better to do this??

SELECT * FROM edid4 INTO wa_edid4 WHERE segnum = '000001'.

CHECK wa_edid4-segnam = 'E1BPRKPFC'.

CHECK wa_edid4-hlevel = '01'.

CHECK wa_edid4-sdata CP gl_rsnum.

ENDSELECT.

[Former Member]

Hi,

You can also use the FM 'IDOC_READ_COMPLETELY' to read the idoc data.

Hope it is useful.

Thanks,

Sandeep.

[former_member581561]

if u get dump error when you pass to interal table use "package size"