Download IDoc data from SAP Table
By Imran, Mohammad March 02, 2022 under SAP ECC/S4HANA
We oftenly need to check the an IDoc that what data we passed in it but we are not sure which IDoc it was. So checking one by one in WE02 will be a very difficult task if you have a lot IDocs posted on the day. You can do it by browsing some of IDoc related tables.
Run the table called EDIDC from se16n and enter the details in the fields below to fetch certain IDocs.
- STATUS - Status 51 or any other which you want to fecth IDocs for need to entered.
- CREDAT - It is important to enter from date and to date so that you have only those IDoc which falls between that time period.
- Message Type - It is important to note that you are entering Message Type otherwise you will end up having a lot of IDocs listed, other objects too.
Now, in the next screen you will have the list of the IDocs. Export it as excel and copy the IDoc numbers.
Now, run anothe table call EDID4. This table holds the IDoc data.
- Copy all your IDocs and paste them in the field DOCNUM
- Check which segment has the data you are looking for then put that segment number in the field SEGNUM.
- SDATA is the field which has the IDoc data. You will need excel Text to Column feature to take fields data in different different columns.
If you have very large volume of IDocs then I will recommend to use BODS, you can import these two tables. Extract data from EDIDC by putting certain filter. Then put a joining with EDID4 to fetch SDATA. Now, you waill have all your IDocs with SDATA in a table or in fileformat(.txt). You can even apply substr funtion on SDATA to truncate additional data.