Hello experts!
I've received a requirement to read a txt file and created a Sales Order via Idoc (Orders) and I'd like your opinion about the best way to execute that.
The requirement:
Read the file (txt) with the structure below where the yellow lines are the Header of sales orders, therefore, I need read once the lines "EDI_DC40" and "LINHA1" and the the others lines from "LINHA2" till "LINHA9" are the items of the sales order.
I thought as a solution create the FCC function to read this file and transform it into an XML structure and mapping it with the IDOC, however, I've never created the FCC function with this kind of the file. I don't know how to ignore the others lines with head information.
My main doubt is: what is the best solution for reading this file and transform it into XML structure? (FCC or java mapping)? Is it possíble to create a java mapping to transform the file into the communication channel?
I appreciate any input.
Thank you.
César Sevilha,