topic Re: Fetching the IDOC Status in Application Development and Automation Discussions

Fetching the IDOC Status

Former Member — Mon, 01 Oct 2007 08:29:21 GMT

Hi,

For each idoc number in the table edids four records exist but I want to capture the status in my program I want to display the message like if it is error message then error message. How to write a query as it contains four records with same idoc number let us say in my idoc contains four records with 50 64 62 51

But I want to pick the error one. Some times 50 64 62 53 that time I want to pick 53. Please help me how to write the query for this.

Thanks a lot.

Re: Fetching the IDOC Status

former_member404244 — Mon, 01 Oct 2007 08:49:08 GMT

Hi,

u can do like this

select docnum status from edids into it_edids where docunum = <idoc number>

and status = '51'.

Now u will get the idoc with status 51...

similarly if u want for status 53 u can do like this..

select docnum status from edids into it_edids where docunum = <idoc number>

and status = '53'.

Reward points if u find useful..

Regards,

nagaraj

Re: Fetching the IDOC Status

varma_narayana — Mon, 01 Oct 2007 08:51:40 GMT

hI Babji..

For this purpose dont read the table EDIDS Directly. instead Select STATUS from the EDIDC table . It will only store the Current status of IDOC.

select STATUS FROM EDIDC WHERE DOCNUM = <IDOCno>.

<b>REWARD IF HELPFUL.</b>