10-01-2007 9:29 AM
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.
10-01-2007 9:49 AM
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
10-01-2007 9:51 AM
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>