Skip to Content
avatar image
Former Member

More than one main table

All -

Is there any pros and cons to have more main table for master data in sigle repository. say 4-5 main table ?

Here most of the look up can be common in many cases.

I am confusing to move ahead.

as in what impact on Database, Roles , users, Load etc ..

Suggesst.

Rgds

Deep

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

2 Answers

  • Best Answer
    avatar image
    Former Member
    Sep 21, 2010 at 10:29 AM

    Hi,

    Please reger to this document.You will get all the pros and cons of moving onto multi main table instead of separate repositories

    http://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/80765a21-78f3-2b10-74a2-dc2ab57a1bd2?quicklink=index&overridelayout=true

    Thanks,

    Sudhanshu

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Sep 21, 2010 at 10:48 AM

    Hi Deepak,

    as in what impact on Database, Roles , users, Load etc ..

    I don't think there should be impact on database, and for Role & user credential you can

    manage as different main table there are some Point need to take care i.e. as follows

    1. Number of Tuple and Qualified table assign to single main Table

    2. Number of records on single main table

    3. Number of User login to repository

    Why you need 4-5 main table ???

    i would suggest consolidate your main table to 2 or build new repository rather to create 4-5 main table in to single repository to avoid complexity and easy to use and maintain

    Note: Above mention point may change upon your business requirement

    Thanks,

    Jignesh Patel

    Add comment
    10|10000 characters needed characters exceeded