How to make multiple files with same vendors from a input file

[Former Member]

Dear All,

I am getting below data in a file need to split the file depends upon PO number

PO Number	Part Number	Part Name	PO Item	Supplier Code	PO Date
R1601-1006	0080508250	BOLT;HEX-HD,FLAN	260	M001	03-02-2016
R1601-1005	280508250	BOLT;HEX-HD,FLAN	260	M002	02-02-2016
R1601-1007	280508600	BOLT;HEX-HD,FLAN	270	M002	02-02-2016
R1601-1005	280610250	BOLT;HEX-HD,FLAN	280	M002	02-02-2016
R1602-1008	280610800	BOLT;HEX-HD,FLAN	290	M003	02-02-2016
R1605-1001	286508250	BOLT;HEX-HD,FLAN	300	M002	02-02-2016
S1601-1009	811230250	PIN;SPLIT	310	M002	02-02-2016

Here for each similar PO numbers i need to create one file. In one file it may be more than 5k lines of data

Ho can i achieve this in SAP PO?

[former_member186851]

Try with multimapping,Sort and collect all PO in one message.

http://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/90dcc6f4-0829-2d10-b0b2-c892473f1...

[Former Member]

Dear Raghuraman,

     Thank you for your response.

I cant predict the PO number, it will change depends upon third party system, i.e every time i will receive new PO numbers so by using multi mapping how can we achieve this. it may be 5 or 10 or 2 different types of PO numbers with multiple records in one file.

Note: PO number is Alphanumaric with special character "-" 

[former_member186851]

Hello Shaik,

once you sort it you can split the target based on change in value of PO Number.

For sorting refer Srinivas Ideas.

[former_member191435]

Hi,

Do one file to file interface.

In this interface read the whole file and sort with PONumber and create file based on PONumber change.

let me know if you need more clarifications.

Thanks,

Sreenivasa

[Former Member]

Dear Sreenivas,

Thank you for your response,

   Here PONumber is Alphanumeric, how can i sort this.

   How to create multiple files if PONumber changes, same POnumber may repeat number of times.

Example: Po number with 1,1,1,1,1,- all records in one file

                   PO number with 2,2,2,2,2,2,2,2, all records in one file

                         .

                         ........................................................etc

Could you please explain it clearly

[former_member191435]

Please check ....

Thanks,

Sreenivasa Veldanda.

[Former Member]

Dear Sreenivas,

Thank you very Much for your response,

After sorting how can I generate multiple files for each PONumber

[former_member191435]

Map that to root node and create files as a root .