topic Re: Problems acceding table EDID4 in Application Development and Automation Discussions

Problems acceding table EDID4

Former Member — Tue, 30 Oct 2007 10:34:23 GMT

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

Re: Problems acceding table EDID4

Former Member — Tue, 30 Oct 2007 10:37:16 GMT

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.

Re: Problems acceding table EDID4

Former Member — Tue, 30 Oct 2007 10:38:45 GMT

Hi,

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

Hope it is useful.

Thanks,

Sandeep.

Re: Problems acceding table EDID4

Former Member — Tue, 30 Oct 2007 10:43:39 GMT

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

Re: Problems acceding table EDID4

former_member581561 — Tue, 30 Oct 2007 10:45:15 GMT

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

Re: Problems acceding table EDID4

Former Member — Tue, 30 Oct 2007 11:17:29 GMT

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

Re: Problems acceding table EDID4

Former Member — Tue, 30 Oct 2007 11:23:01 GMT

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

Re: Problems acceding table EDID4

rainer_hbenthal — Tue, 30 Oct 2007 11:31:48 GMT

try to run the report in background.

Re: Problems acceding table EDID4

Former Member — Tue, 30 Oct 2007 11:45:26 GMT

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

Re: Problems acceding table EDID4

Former Member — Wed, 31 Oct 2007 08:41:05 GMT

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.