How to split Header Detail sets in Sender File Adapter?

[jegathees_waran]

Hello Friends,

My input fixed length text file contains n number of Header, Detail,Trailer records with identifier.

Header - 1

Detail   - 2

Trailer  - 9

Assume that the input file like below.

--------------------------------------------------------------------------------

18001023122013

20010Screw12

20011Nails  15

20013Polish12

9 3

18001124122013

20021Rod   12

20022VBelt13

9 2

--------------------------------------------------------------------------------

It has two purchase order details: 1) 80010 dt 23/12/2013, contails 3 line items : itemcode, description, qty. 2) 80011 dt 24122013 contains 2 items.

Like this, the input file contains n number of purchase orders.

As per our requirement, this single file needs to be split up for each purchase order (H, D) or each file. And those files to be processed.

My doubt is how to split the files based on Header detail and trailer set?

Or any other way to process each purchase order separately.

Friends, Could you please clarify?

Kind regards,

Jegathees P.

[nabendu_sen · Accepted solution]

Hi Jegathess,

Have you tried Recordsets per Message = 1 with Header,1,Item,*,Trailer,1.

http://www.riyaz.net/sap/xipi-file-content-conversion-for-complex-structures/79/

[gagandeep_batra]

Hi Jegathee,

First you need to do FCC for converting text file to XML file  then go for multi mapping logic to genrate the each file based on PO

For FCC check below link:

http://help.sap.com/saphelp_nw04/helpdata/en/2c/181077dd7d6b4ea6a8029b20bf7e55/content.htm

Regards

Gagan