Skip to Content
avatar image
Former Member

Total no. of tables in sap...

Hi All,

Can you plz let me know how many tables sap has...

Regards,

yunus

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

4 Answers

  • avatar image
    Former Member
    Feb 23, 2007 at 11:24 AM

    lots of table

    can i know y u want to know this .can u just specify ur problem..:-)

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Abdul Hakim Sulaiman Batcha

      hi,

      Yes..the table DD02L contains all the standard tables which may be of types such transparent, pooled and clustered tables but this completely depends on your sap system configuration. That is the size of tablespaces, initial extent, next extent configured by the BASIS people. you can not exactly say that my sap system has this n number of tables becoz this only tells u the no of tables accoding the size of tablespace configured by your administrator or basis people. Even though, this DD02L exludes all your Z* or Y* programs. Also, DD02L only gives the skeleton definitions of data..i mean to say it does not contain the actual data. the actual data is stored on the database level..DD02L has only the definitions of the data stored on the database level and which is maintained at the time of system configuration. so this proves that no of exact tables maintained at the database server is of no use to us..we're only here(as an abaper) to use the raw data, amke it meaningful...display them using reporting techniques etc. and store them at the database level.

      plz correct me if i'm not correct.

      thanks,

      shamim.

  • avatar image
    Former Member
    Feb 23, 2007 at 11:26 AM

    Total number of entries in DD02L table equals to the total number of tables exists in your system 😊

    Cheers

    Manohar

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Feb 23, 2007 at 12:22 PM

    Hi,

    DD02L-it is table which contains list of SAP tables.

    Check the number of entries for the table DD02L

    The count is equal to the total no of sap tables.

    Regards,

    Sruthi

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Feb 24, 2007 at 09:28 PM

    Hi Yunus,

    The total number of SAP tables varies from release to release. In your current release, you can find this by checking the total number of table in DD02L <b>MINUS</b> Number of tables in customer name space.

    Thanks and regards 😊,

    Ravi 😊.

    Add comment
    10|10000 characters needed characters exceeded