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: 

Not able to see all the records in SM30

Former Member
0 Kudos

Hi All,

I have created a Z-table. In that records are stored based on the dates.

Suppose :

The fields and their values in the table are as below,

Field1 Field2 Field3

A 22/02/2008 31/12/9999

A 12/01/2006 21/02/2008

B 10/11/2007 31/12/9999

B 27/05/2006 09/11/2007

But in if we go in SM30 transaction, it is showing only recent records i.e.as below,

Field1 Field2 Field3

A 22/02/2008 31/12/9999

B 10/11/2007 31/12/9999

Please tell me how can I get the full contents of the table in SM30.

1 ACCEPTED SOLUTION

Former Member
0 Kudos

What are the primary key fields for this table? If it is just FIELD1 (with or without MANDT), then that is your problem.

Rob

8 REPLIES 8

Former Member
0 Kudos

Hello Suman,

Can you able to see all the records in SE16.

I think if the records are modified with the date on which the record is created.

Cheers,

Vasanth

Former Member
0 Kudos

Hi,

Looks like there is a date restriction for showing records where the ENDDA date is not less than SY-DATUM.

When entering SM30, select the option (radiobutton) "with restrictions"

There might be some default restriction maintained.. Check that and remove it if present.

Cheers.

0 Kudos

I have checked it, there are no restrictions.

Please sugggest me what can be done to see all the contents.

0 Kudos

Hi,

Did you check if there is any authorization check maintained for the table?

Go to the Table Maintenance Generator. Go to Environment>Modifications>Events.

Check here is there is any code for display authorizations.

Regards,

Sandeep

0 Kudos

Hi,

No code has been written in this 'EVENT'. Do we need to write any code in this?

Former Member
0 Kudos

What are the primary key fields for this table? If it is just FIELD1 (with or without MANDT), then that is your problem.

Rob

0 Kudos

Hi,

I have both the fields as primary keys. Then why is it showing like that?

Please clarify.

0 Kudos

You cannot have duplicate primary keys on the database. If MANDT abd FIELD1 are the primary keys, then you cannot have more than one entry on the database for any combination. MANDT is only used to make the table client dependent, so the only normal key field you have is FIELD1. You can correct this by making FIELD2 (and maybe FIELD3) primary key fields.

Rob