Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

Que About Table And Its Enteries.....

Former Member
0 Kudos

Dear All...

I do have a list of table which are almost 48 which all are 'Y' tables...

Is it possible to program to know that the how many entries each table contains??? And Is it possible to program to know that given table is Transaction table or Master table???

Would be thankful to you if you even show me the right direction...

Warm Regards,

Nirav Parekh

2 REPLIES 2

Former Member
0 Kudos

Hi,

Check the table DD02L to find most of the details.

I don no if it provides the no-of records. i will let u know if i get an option.

    • reward if useful ***

Former Member
0 Kudos

Hi Nirav,

Try the code below to get the entries in a DB table, n reward if found useful


data: len type i.
SELECT COUNT( * ) FROM TVDIR INTO LEN."here i have taken TVDIR as eg.
write : LEN.

This will output the number of entries in any particular table.

Regards,

SJ