Skip to Content

Unable to return Deep structures from RFC

Hi Experts ,

I have an requirement to return the deep structures in output from RFC .

Req : In output i need multiple tables in Gateway. 

I tried in SEGW for mapping multiple tables , but got error message "Only one Output table can be mapped " . 

Please help me in this , to resolve the issue .  

Thanks in Advance .

Aisurya.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Aug 29, 2013 at 11:29 AM

    HI Aisurya,

    That is right. You cannot have more than one table returning from one gateway request. However you have two options.

    1. Multiple tables which you want to return have parent child relationship? Ex: Sales Order header and Sales order Items? Then you need to use $expand on a query on the parent entity.

    2. You can also use $batch to send multiple requests to the backend, so that you fetch one table for every request. Search in scn for $batch. There are good blogs on it.

    Thanks

    Krishna

    Add comment
    10|10000 characters needed characters exceeded

    • Hi Aisurya,

      But if each custom FM calls the same Standard FM then you do not achieve anything since you will be calling the standard FM returning all four tables every time. Even with the current standard FM you can achieve my approach. While data source mapping for each of the four entity, you just need to map one of the table and leave other three tables without mapping. But the problem is that for each entity FM call is made and you will not be able to utilize three other tables populated.

      My suggestion was, Instead of suppressing three other tables, see if you can just get one table in your custom FM. In that case you save the processing for populating three other tables every time.

      Thanks

      Krishna

  • avatar image
    Former Member
    Oct 09, 2014 at 10:11 AM

    Hi Aisurya,

    Please help me how you resloved this .

    Regards,

    Rahul Pathak

    Add comment
    10|10000 characters needed characters exceeded