custom table with only one entry and without any primary keys
I have a requirement where I need to create a custom table without any primary keys and it can have only one entry in database at max.
It mean the user should not be able to insert new row but can modify only the existing row. The fields should be character type with a size of 1000 characters.
I created table with 4-5 fields of char predefined type with length 1000 characters but when I try to maintain in SM30 I do not get any fields for input.
Even I do not see the table fields in the table maintainence generator (modification screen).
Could you please help.. Is this requirement not possible? I also need help in creating event for table to have only one entry.
Thanks in advance.
Ramakrishnappa Gangappa replied
Its possible to have non-key fields with mandt as key.
delete and re-generate the table maintenance view again with maintenance type = Two step.
Also make sure that, in the Delivery and Maintenance " Display/Maintenance allowed" is chosen.