During message monitoring in SAP-PI, I have seen so many error messages which are coming from SAP ECC system (Idocs) in production environment where we have limited access. After the error analysis, I came to know that the error is due to missing of one segment in the Idoc.
Note: The missing segment is not a mandatory segment and all the Idocs are in success status in SAP ECC (But it is a mandatory segment to map with the target message in SAP-PI).
So, now I have to get all those Idoc number details and send to particular team who are responsible for reprocessing. If there are few errors it is easy to gather the Idoc numbers, but if there are 100’s of error messages, then it will be difficult.
Here, my blog is to get the Idoc numbers which are missing one segment for a date range.
After error analysis, error is due to missing of ZE_AFS_DELVRY03/IDOC/E1EDL20/E1TXTH9 segment in the Idoc coming from PE1_100 (ECC system).
Now, go to SAP ECC production system and enter WE02 T-code.
Now, we will get all the Idocs (which include success and error Idocs in PI) and download it into our local file as xls format.
Then, go to SE11 T-code and enter EDID4 table name. Here, provide the segment name and Idoc numbers we got above.
Then download the output into our local file as xls format and remove the duplicates if exists for Idoc numbers.
Now, by comparing the Idoc numbers present in these two documents we can find out the Idoc numbers for which above mentioned segment is missing.
Finally, the missing Idoc numbers in 2nd sheet when compared with the 1st sheet will be the required result.
Thanks to my colleagues Deviprasad Pothireddi and Kiran Gode for providing inputs to post this blog.