Skip to Content
0
Nov 19, 2018 at 02:18 PM

Mapping with compare result from independent nodes

60 Views

Hello,

We have an interface from SAP ERP providing two table structures.

So this is

Table1:

Line 1 fields: VBELN / KUNNR => 1001 / 3579

Line 2 fields: VBELN / KUNNR = 1002 / 4680

etc...

Table 2:

Line 1 fields: VBELN / POSNR / etc... => 1001 / 010

Line 2 fields: VEBLN / POSNR / etc... => 1002 / 010

Line 3 fields: / VBELN / POSNR / ... => 1002 / 020

Line 4 fields: / VBELN / POSNR / .... => 1003 / 010

etc...

For each VBELN in table 1 we can habe n lines in Table 2 with same VBELN.

The target structure is based on Table 2 and we need to add the correct KUNNR to each target line.

Seems this is not possible with graphical mapping. Any idea how to solve this ? E.g. with a small UDF? But how?

Best regards

Dirk