02-27-2008 3:13 PM
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.
02-28-2008 2:58 AM
What are the primary key fields for this table? If it is just FIELD1 (with or without MANDT), then that is your problem.
Rob
02-27-2008 3:22 PM
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
02-27-2008 3:22 PM
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.
02-27-2008 4:23 PM
I have checked it, there are no restrictions.
Please sugggest me what can be done to see all the contents.
02-28-2008 1:46 AM
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
02-28-2008 8:08 AM
Hi,
No code has been written in this 'EVENT'. Do we need to write any code in this?
02-28-2008 2:58 AM
What are the primary key fields for this table? If it is just FIELD1 (with or without MANDT), then that is your problem.
Rob
02-28-2008 8:11 AM
Hi,
I have both the fields as primary keys. Then why is it showing like that?
Please clarify.
02-28-2008 4:51 PM
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