Skip to Content

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

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Aug 03, 2017 at 04:21 PM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • Aug 08, 2017 at 06:40 AM

    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

    Add comment
    10|10000 characters needed characters exceeded