Graphical Mapping Issue

[Former Member]

Hi All,

I have a mapping issue. Source target is idoc WBBDLD.WBBDLD05 for which I have simplified below:

WBBDLD05

....IDOC (0..n)

........E1WBB01 (0..10000)

................UMREZ (0..1)

................UMREN (0..1)

................E1WBB07 (0..1000)

....................KSCHL (0..1)

....................DATAB (0..1)

....................E1WBB08 (0..100)

........................KWERT (0..1)

Target structure is simplified as below:

Request (1..1)

....Recordset (1..unbounded)

........BuyingCost (1..1)

Into target field RecordSet, I have mapped E1WBB01 (context: WBBDLD05). For target field BuyingCost, I need to map KWERT when UMREZ and UMREN = '1' and KSCHL = 'ZSPB' and the first record with the smallest DATAB (a date field). Is there a way of achieving this in the graphical mapping tool ?

Please help. Hopefully I have simplified my scenario enough.

I can email a sample test file if required.

Kind Regards,

JM

Edited by: Joy Massimino on Oct 20, 2009 9:40 PM

[Former Member]

Hi Everyone,

I have managed to solve my problem by fiddling with the contexts of the various fields and creating a UDF to handle the final sort and map of the most recent DATAB field.

Kind Regards,

JM

[Former Member]

Hi JM,

Would you please eloborate this

 first record with the smallest DATAB