topic Re: Extracting IDOC data from DB in Application Development and Automation Discussions

Extracting IDOC data from DB

Former Member — Wed, 01 Aug 2007 08:41:29 GMT

I've got a requirement to list the material numbers of some failed IDOCs, but am struggling to get to the data.

I've tried doing a SQL trace, but this only gets me as far as being able to identify the IDOC numbers through EDIDC, and I need to be able to retrieve the segment data as well.

Does anyone know of a FM that would do the job?

Re: Extracting IDOC data from DB

Former Member — Wed, 01 Aug 2007 08:43:15 GMT

Hi Chris,

Also check table EDIDD.

All table starting with EDI are useful to you.

Regards,

Atish

Re: Extracting IDOC data from DB

Former Member — Wed, 01 Aug 2007 09:04:22 GMT

Hi Chris,

After getting the IDOC numbers from EDIDC then you can use FM : IDOC_READ_COMPLETELY to read the IDOC segment.

[pls see in table parameter : INT_EDIDD-SDATA]

Regards,

Hendy

Re: Extracting IDOC data from DB

Former Member — Wed, 01 Aug 2007 09:16:58 GMT

Thanks Hendy, that's exactly what I was looking for.