Skip to Content
0

Excel to Idoc to Flat file in ific format...Is it possible in SAP PO7.5?

Aug 03, 2017 at 03:23 PM

66

avatar image

Hello Experts,

I have a very strange requirement like this

User will give the excel/tab delimited file and it needs to be converted to IDoc in SAP PO and then IDoc needs to be converted to a flat file in a row ific format.

Is if feasible in SAP PO7.5?

Thanks in advance,

Vikas

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

2 Answers

Manoj K Aug 03, 2017 at 04:21 PM
0

Vikas,

For converting the excel file into XML you need to use java mapping or custom module as explained here.

Once you have the XML do the required transformation in mapping then in receiver channel use module IDOCXmlToFlatConvertor to convert XML to IDOC flat file structure as explained here

br,

Manoj

Share
10 |10000 characters needed characters left characters exceeded
Rudra Singh Aug 08, 2017 at 06:40 AM
0

Hi Vikas,

You can use custom module given in Eng Swee's blog.

https://blogs.sap.com/2014/10/21/exceltransformbean-part-1-convert-various-excel-formats-to-simple-xml-easily/

Warm Regards,

Rudra

Share
10 |10000 characters needed characters left characters exceeded