on 06-22-2016 8:07 AM
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?
Try with multimapping,Sort and collect all PO in one message.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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 "-"
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
User | Count |
---|---|
91 | |
10 | |
10 | |
9 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.