topic Re: Table Control Change / Delete in Application Development and Automation Discussions

Table Control Change / Delete

Former Member — Fri, 19 Oct 2007 14:56:12 GMT

I need to Delete or Change database table using screens. I want to view the selected records together and change or delete. Kindly provide me sample table control program or any other method to achieve this.

Thanks

Re: Table Control Change / Delete

Former Member — Fri, 19 Oct 2007 14:59:31 GMT

Changing or modifying Standard table records is not a good practice.

If it is a custom table, please go ahead and create Table maintenance for the same using transaction sE11. This will help you to maintain data for a custom table.

ashish

Re: Table Control Change / Delete

Former Member — Fri, 19 Oct 2007 15:02:39 GMT

Ashish

Users are not authorized for se11.

Thanks

Re: Table Control Change / Delete

Former Member — Fri, 19 Oct 2007 15:03:58 GMT

Check the below links :

http://help.sap.com/saphelp_nw04/helpdata/en/9f/dbac5e35c111d1829f0000e829fbfe/frameset.htm

http://help.sap.com/saphelp_nw04s/helpdata/en/9f/dbac5e35c111d1829f0000e829fbfe/frameset.htm

http://help.sap.com/saphelp_nw04/helpdata/en/9f/dbac4435c111d1829f0000e829fbfe/frameset.htm

http://help.sap.com/saphelp_nw04s/helpdata/en/9f/dbac4435c111d1829f0000e829fbfe/frameset.htm

Thanks

Seshu

Re: Table Control Change / Delete

Former Member — Fri, 19 Oct 2007 15:12:30 GMT

Senthil,

That is not required. Developer needs to have access to SE11 to create a table maintenance.

Users will maintain table using transaction SM30. If users don't have access to SM30 (which at most client places they don't), create a custom transaction code for SM30 for maintaining that specific table and give access of that transaction to users.

Are you clear with the concept?

ashish

Re: Table Control Change / Delete

Former Member — Fri, 19 Oct 2007 15:16:05 GMT

I did the custom transaction for SM30 to modify ztable but it is asking workbench request for every new entries to the ztable.

Thanks

Re: Table Control Change / Delete

Former Member — Fri, 19 Oct 2007 15:21:01 GMT

Check your table attributes - If it is 'C' for customizing, it will ask for the request, every time you make a change.

Also check Data Browser / Table maintenance property in "Delivery & Maint" tab. It should not be "Display Main allowed with restric".

ashish

Re: Table Control Change / Delete

Former Member — Fri, 19 Oct 2007 15:23:21 GMT

Then issue would be at table maintaince or delivery classs ( if you use C)

Just goto SE11 -> enter table name -> display

Utilities -> table maintaince -> here check the radio buttons

Recording routine -> select no or user recording routine

delete old table maintaince,recreate it again

Thanks

Seshu

Re: Table Control Change / Delete

Former Member — Fri, 19 Oct 2007 15:26:30 GMT

My settings are the following

Data Browser/Table View Maint: Display/Maintenance allowed

Delivery class is : Customizing table, maintenance only by cust., not SAP import

But it should not ask request every time when user changes. How to achieve this ?

Thanks

Re: Table Control Change / Delete

Former Member — Fri, 19 Oct 2007 15:29:21 GMT

For Customizing table, it will always ask for a transport.

Which table do you want to maintain? Is it a Z table?

ashish

Re: Table Control Change / Delete

Former Member — Fri, 19 Oct 2007 15:32:42 GMT

Yes. It is ZTABLE Create by me.

what should i give for Delivery Class and Data Browser/Table View Maint.

Thanks

Re: Table Control Change / Delete

Former Member — Fri, 19 Oct 2007 15:35:21 GMT

Give delivery class is A

and use table maintaince allowed

Thanks

Seshu

Re: Table Control Change / Delete

Former Member — Fri, 19 Oct 2007 15:35:22 GMT

Ok, Delivery class should be "A" if this contains Master / Transaction data. (Not customizing data).

Data Browser / Table View Maint = Display / Maintenance allowed.

Change this, activate table, recreate Table maintenance and check again. It should work.

ashish

Re: Table Control Change / Delete

Former Member — Fri, 19 Oct 2007 15:38:53 GMT

Even i tried 'A - Application table (master and transaction data)' it is asking request.

Thanks

Re: Table Control Change / Delete

Former Member — Fri, 19 Oct 2007 15:41:06 GMT

Did you change this property?

Data Browser / Table View Maint = Display / Maintenance allowed.

Delete table maintenance , check above property and create again.

ashish

Re: Table Control Change / Delete

Former Member — Fri, 19 Oct 2007 15:47:05 GMT

I tried it is not working for 'A' and works when i changed to

'Table for storing temporary data, delivered Empty'

Kindly help me what should i give while creating the custom transaction for sm30 for default values (Name of the screen field and value).

Thanks

Re: Table Control Change / Delete

Former Member — Fri, 19 Oct 2007 15:50:11 GMT

You can click on find screen numbers, it will generate screen numbers automatically. Make sure radio button for "Standard Recording routine" is set.

You should be able to change table attributes to "A". Please make sure that the attributes are changed before going for table maintenance.

ashish

Re: Table Control Change / Delete

Former Member — Fri, 19 Oct 2007 15:54:13 GMT

When i try to delete table maintenance it is showing the following error

Function group Y_TABMAINT cannot be processed

Re: Table Control Change / Delete

Former Member — Fri, 19 Oct 2007 15:56:34 GMT

Check if this function group exists. Also exit from transaction se11 and reenter and try again. It will work.

ashish

Re: Table Control Change / Delete

Former Member — Fri, 19 Oct 2007 16:03:51 GMT

Asish

it working on following condition

Delivery Class for ztable: Table for storing temporary data, delivered empty

I have also created custom transaction for SM30.

But i don't know when i transport to Production the user should have authorization for SM30 because the custom transaction again calls SM30 right?

Thanks