cancel
Showing results for 
Search instead for 
Did you mean: 

DB02 detailed analysis column rows

Former Member
0 Kudos

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

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

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

Former Member
0 Kudos

Not possible to get the row count from DB02.

You would have to create your own report.

Is there a reason you would need to keep track of row counts ??

Pravin

Former Member
0 Kudos

We want to execute archiving of the archive object FI_DOCUMNT.

So we would like to have a situation before the archiving and after the archiving

Some suggestions?

Thanks

Mario

Former Member
0 Kudos

Easier way to get that information is

Goto

SARA

Fillin

FI_DOCUMNT

Click on

Database Tables Tab

Click on Space Statistics

Second column is Number of records

Pravin

Former Member
0 Kudos

Thanks Pravin.

If I click there, I only obtain info on 2 tabls (AGKO and BSIS).

I obtain info only for the table that have the statistics updated?

Or is this the real number of rows?

Furthermore, have I to update all the statistics for all tables to have a good date rows?

thanks.

Mario

Former Member
0 Kudos

Just two tables ??

You should see lot more tables there.

Analysis date will be the date when the Oracle Statistics analysis ran.

If you selct one table and click on space anlysis it will say it was computed using anysis method EI or CI or so on.

Should be pretty close

Pravin

Former Member
0 Kudos

Yes Pravin,

I see only two tables.

So why this?

Thanks.

Mario

Answers (1)

Answers (1)

Former Member
0 Kudos

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

Former Member
0 Kudos

Excellent suggestion from Naveen.

That would definetely give the data you are looking for.

Pravin

Former Member
0 Kudos

Excuse me but in transaction TAANA I see only ACCTITT data.

If I go on "Environment"->"Analysis Variant" I see the list with BKPF but I don't understand what I have to do to see BKPF data.

thanks.

Mario

Former Member
0 Kudos

go to TAANA and press F8 (or select Table Analysis -> Execute / perform) give the table name as BKPF and drill down and choose the analysis variant ARCHIVE and then run the job in the background.