on 09-11-2009 10:02 AM
Hello experts.
I would like to have the "rows" column on the "Detailed Analysis" of DB02 transaction.
How could I do?
Or where could I find a report to do this?
Thanks.
Mario
I assume you want to know how many rows a table has.
You can look at the table stats to get an estimate of the number of rows. You can use transaction ST05 -> button 'enter sql statement':
select * from <table> -> Explain
Now click on the table an you see the number of rows. There is no real select executed, only the table stats are read.
Regards, Michael
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Mario,
The best option as I see is to use table analysis.
Use transaction TAANA on table BKPF with variant ARCHIVE. Not only can you get the number of rows, but also the distribution pertaining to various fiscal years, company codes etc.
Hope this solves your problem,
Naveen
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
24 | |
11 | |
9 | |
7 | |
6 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.