Exporting data from IDOC to excel sheet

[Former Member]

Dear All,

I wanted to export IDOC information into excel sheet how can I do that?

I have suggested the client to go to WE02 select the IDOC in question and then select PRINT IDOC and then select list and select export and then excel sheet and location of the file and save. But in the client screen the movement he selects Print IDOC he is getting an option to select printer.

Can anyone guide me as to how we can export the IDOC data into excel sheet.

Thanks

vinila

[Former Member]

Dear All,

I wanted to export IDOC information into excel sheet how can I do that?

I have suggested the client to go to WE02 select the IDOC in question and then select PRINT IDOC and then select list and select export and then excel sheet and location of the file and save. But in the client screen the movement he selects Print IDOC he is getting an option to select printer.

Can anyone guide me as to how we can export the IDOC data into excel sheet.

Thanks

vinila

[Former Member]

Go to transaction We19 and you can download the idoc into excel from there

System -->list -->Save as local file,

Regards,

Vimal

[Former Member]

Dear Vimal / Shreemohan,

thanks for the reply.

i have tried htat but it gives me just the details which are on the screen but I wanted the information which is there in each node.

i wanted the data indepth from each node for our PI/XI server to accept for further processing

i hope i have explained you properly...

vinila

[Former Member]

Hi

Go to T-code IDOC -

---

> Enter IDOC Number -

---

> Select Analysis IDOC Field -

---

> Execute F8 -

---

> If you want even Empty Field Then Click on Check Box.

Execute F8.

To Down Load go to List at menu Bar and select Save/send.

If any issue plz let me know

Thanks & regards,

ShreeMohan

Edited by: ShreeMohan Pugalia on Jul 21, 2009 12:44 PM

[Former Member]

Hi Shree mohan

I have tired the method which you have given me but will it give me the same data as i get from WE02? as i can see i get ony 119 fields in this way (IDOC method) whereas WE02 is giving me 241 feilds a difference of 122 feilds

vinila

[Former Member]

WE19 ---> Enter IdocNumber -

---

> Select System in Menu Bar -

---

> List -

---

>Save ---> Local file