on 05-21-2010 10:47 AM
Hello,
In Tcode ST02 --> Detailed Analysis, there is an option to check Table Call Statistics.
In that statistics page there is a column Buffer State
For table A807 the Buffer state is Error.
I tried searching but couldn't find anything on the Buffer State in Error.
COuld you help me with the reason and solution for this error?
Thanks.
Its very obvious that when a table is in error state that means the table cannot be load into the buffer.
Either the table table is big enough or your buffer is small.
This is what i see from the help page.
Error: The table content could not be placed in the buffer, because insufficient space was available in the buffer or the table line is larger than a data frame (currently 4K).
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Have you tried option analyze table? You need to click on analyze table and give table name. It will execute one report in background and give you details about that table. Try that option and see what it says. You can paste the log below.
Thanks and Regards,
Kedar
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Analysis log
Date/time of analysis: 21.05.2010 11:34:42
Analyzed table: A807
Total number of rows: 4.234.059 rows
Requested bytes per row: 81 bytes per row
Requested bytes to be buffered 100%: 342.958.779 bytes
Current buffering mode: 100% buffering
Rows per Distinct 1 11 101 1.001 10.001 100.001 more than
neric key values - 10 - 100 - 1.000 - 10.000 - 100.000 -1.000.000 1.000.000
Key fields Number of areas that are specified by the generic key and contain the given number of rows
MANDT 1 0 0 0 0 0 0 1
KAPPL 1 0 0 0 0 0 0 1
KSCHL 6 0 0 2 0 1 2 1
PLTYP 41 7 8 4 1 12 9
MATNR 416.822 256.631 159.975 216
VARCOND 903.442 903.442
DATBI 4.234.059 4.234.059
User | Count |
---|---|
83 | |
23 | |
11 | |
9 | |
8 | |
5 | |
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.