Skip to Content

Max no of table joins in AMDP

Hello,

Is there any limitation regarding number of joins in an AMDP? For my requirement, i must join 32 tables. Is it a performance issue to join so many tables? I can create two or three AMDP's as well but i read in one of the post that the transfer of data must be minimal or else it could affect the performance. Can you suggest me an approach?

Thanks,

Prem

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

4 Answers

  • Best Answer
    Posted on Jul 25, 2016 at 10:17 AM

    Generally speaking every additional join will incur additional processing, which means: this likely will take more time.

    The sheer number of tables here is not as relevant as the amount of data processed with every join.

    SAP HANA Live virtual data models, as an example, commonly have tens of stacked views and joins.

    As the SAP HANA query optimiser tries to find the best possible way to execute such joins, trying to implement them manually very likely won't be a good idea.

    So rather create views to logically put joins together that belong together, but don't artificially build multiple ADMPs.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jul 25, 2016 at 06:09 AM

    hi,

    Can't you create CDS for the same and use the result ?

    Regards,

    Naveen Kumar.

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Jul 25, 2016 at 01:36 PM

    Hi Prem,

    Create CDS View either create 2 or 3 graphical views and use it in AMDP.

    If you really worried about performance, persist it in table with delta update later you can use it.

    Have you heard about AMDP inheritance either calling AMDP inside AMDP?

    -Amol S

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Jul 25, 2016 at 03:29 PM

    Thank you all.

    Regards,

    Prem

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.