Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Mapping Problem SAP PI 7.1

Hello!

I am struggling with a sales order mapping:

My source and target structure:

My source data (just the content of fields KdNr, Auftrag, Posnr, Artnr, Liefermenge as an example):

01,1000,1,100,A,10

02,1001,1,100,A,10     -> KdNr "02" and Auftrag "1001"

02,1001,2,200,B,10     -> also KdNr "02" and Auftrag "1001" but pos. 2 of the order

03,1002,1,100,A,10

04,1003,1,100,A,10

05,1004,1,100,A,10

My goal:

a) 1 Recordset per KdNr (customer number) and

b) if a source Recordset has 2 or more positions (like 02,1001,1,100,A,10 and 02,1001,2,200,B,10) these positions should be mapped together in one Recordset in the target message.

So the output should be:

Recordset 1 with 1 position

Recordset 2 with 2 positions

Recordset 3 with 1 position

Recordset 4 with 1 position

Recordset 5 with 1 position

Does anyone know how to solve this problem?

Thanks in advance and all the best for 2015!

Regards

Christian

Not what you were looking for? View more on this topic or Ask a question