topic Re: about inserting new rows in database table in Application Development and Automation Discussions

about inserting new rows in database table

Former Member — Thu, 02 Nov 2006 16:46:48 GMT

Hi to all,

I recently installed SAP 4.7 on my system.Everything is going on smoothly .

But, I created a table "zemp" and created columns for it .And i tried to enter data into the table by

se16(data browser) ---> create entries (F5)

But system is displaying error message

"The System settings do not allow any changes "

and its not accepting any data .What i have to do .

Please help me in this regard .

thanks in advance.

Re: about inserting new rows in database table

Former Member — Thu, 02 Nov 2006 16:47:45 GMT

You need to create the table maintenance generator for the table

Please check the following links

https://www.sdn.sap.com/irj/servlet/prt/portal/prtroot/com.sap.km.cm.docs/library/abap/how%20to%20implement%20events%20in%20table%20maintenance.doc

For further help look into these links

http://help.sap.com/saphelp_46c/helpdata/EN/cf/21eb6e446011d189700000e8322d00/frameset.htm

http://help.sap.com/saphelp_bw30b/helpdata/en/69/c2516e4ba111d189750000e8322d00/content.htm

Message was edited by: Dominic Pappaly

Re: about inserting new rows in database table

Former Member — Thu, 02 Nov 2006 16:50:09 GMT

Hi,

Welcome to SDN.

Did you set to display/maintenance allowed (under Delivery and Mainatenance) for data browser/table view maint. in SE11?

If you did then you should be able to insert from SE16.

Regards,

Ferry Lianto

Re: about inserting new rows in database table

sridhar_k1 — Thu, 02 Nov 2006 16:50:39 GMT

check 'Data Browser/Table View M' in SE11 delivery and maintenance tab, may be it's set to maintenance not allowed.

Regards

Sridhar

Re: about inserting new rows in database table

Former Member — Thu, 02 Nov 2006 16:51:47 GMT

Hi Sagar,

1) You can write a small program to insert data

2) maintain a Table mantenance and insert data using SM30.

3) Double click the recod in Se16 -> enter /h and enter twice.-> this will lead you to debug mode -> change <b>Code</b> value to 'INSR'-> enter value you want to -> Save ->F8.

Reward points if it helps.

Manish

Message was edited by: Manish Kumar

Re: about inserting new rows in database table

Former Member — Thu, 02 Nov 2006 17:23:25 GMT

Hi ,

I have given this correctly "display/maintenance allowed " ,still the problem is there.

Re: about inserting new rows in database table

sridhar_k1 — Thu, 02 Nov 2006 17:51:03 GMT

May be you don't have authorization to create entries like that, execute transaction SU53 after you get the message.

Regards

Sridhar