Skip to Content

Below User Define Functions (UDF) logic can be used to group, sort and handle duplicate XML records.

Note: –

  1. Number of queue entries in each input field, to UDF should be equal (except key fields). Use ‘mapWithDefault’ for all optional input fields.
  2. Input fields context should be removed. Use ‘removeContexts’ OR right click on field and then change ‘Context’.
  3. Create UDF with Execution Type as ‘All Values of Queue’. Input all related fields to one ‘multiple input and multiple output UDF’. When match is found, write all related fields to output.
  4. Please tryout below examples in sandbox. And then solve your actual requirement.

Grouping XML records

Here is input XML and expected output XML: –


Mapping: –


UDF: –

UDF will search ‘Name_People’ in ‘Name_Record’, if it finds a match, corresponding ‘Where’ and ‘Phone’ will be written to target fields with Context Change. Context Change will be added to output ‘Record_out’ for each ‘Name_People’.


Sorting XML records

Here is input XML and expected output XML: –


Mapping: –

Mapping is same as above, add standard function ‘sort’ to key field. UDF logic is same as above. Output XML will be sorted with Name_People.


Handling Duplicate XML records

Here is input XML and expected output XML: – Duplicate records are ignored.


Mapping: –


UDF: –

HashSet will return true, if unique value is added. It will return false, if duplicate is added.


UDF code for reference

// Grouping XML records.
public void udf_getCorrespondingRecord(String[] Name_People, String[] Name_Record, String[] Where, String[] Phone, ResultList Record_out, ResultList Where_out, ResultList Phone_out, Container container) throws StreamTransformationException{
for(int i = 0; i < Name_People.length; i ++) {
     for(int j = 0; j < Name_Record.length; j ++) {
         if(Name_People[ i ].equals(Name_Record[ j ])) {
             Record_out.addValue(" ");
             Where_out.addValue(Where[ j ]);             Phone_out.addValue(Phone[ j ]);
             Where_out.addValue(ResultList.CC);    Phone_out.addValue(ResultList.CC);
//If match has to be found using a combination of two fields. Please use logic something like this in above UDF:
//if((Name_People[ i ] + Where[ i ]).equals(Name_People[ j ] + Where[ j ]))
// Handle duplicate XML records.
public void udf_getUnique(String[] Id, String[] Name, String[] field1, ResultList Record_out, ResultList Id_out, ResultList Name_out, ResultList field1_out, Container container) throws StreamTransformationException{
Set<String> unique = new HashSet<String>();
for(int i = 0; i < Id.length; i ++) {
    if(unique.add( Id[ i ] )) { // True if unique.
      Record_out.addValue(" ");
      Id_out.addValue(Id[ i ]);                    Name_out.addValue(Name[ i ]);             field1_out.addValue(field1[ i ]);
      Id_out.addValue(ResultList.CC);   Name_out.addValue(ResultList.CC);   field1_out.addValue(ResultList.CC);

To report this post you need to login first.


You must be Logged on to comment or reply to a post.

  1. Former Member

    Good one Raghu Vamseedhar Reddy KadipiReddy

    Well, you don’t believe the same concept was in my mind from last few weeks for one of complex interface requirement which was recently go-live but at the moment with a java mapping and I am planning to replace it with a Graphical mapping for a better visibility in general and for enhancements by support team later

    May be you can consider adding below points,

    1. Returning multiple ResultLists using an UDF” is not explicitly documented (at least I haven’t seen) in SAP help/Forum blogs etc..except we see this feature in standard SAP RFC lookup
    2. And using “Returning Multiple ResultLists” concept, we can replace some complex java mappings with a simple, effortless and efficient graphical mapping’s

    Thanks for sharing a nice pattern. And keep blogging your ideas ….

    Best Regards,

    Praveen Gujjeti

    1. Former Member Post author

      Thank you Praveen, for feedback.

      I myself written Java mapping for grouping XML records, previously. I agree with you, now we can implement more transformations using graphical mapping.

  2. Former Member

    Hi Raghu ,Thanks for sharing this it’s really helped me a lot.

    can you please tell this, for duplicate XML UDF. If I want add or concatenate the Field one . this is the requirement I got .

    Please share your thoughts




Leave a Reply