topic Re: Create a custom table in Application Development and Automation Discussions

Create a custom table

Former Member — Fri, 08 Dec 2006 11:40:24 GMT

Hi,

Can anyone let me know how to create a custom table. There is some difference between customizing table and custom table creation. I want that end user should be able to create the entries in the table.

Thanks

Re: Create a custom table

Sandeep_Panghal — Fri, 08 Dec 2006 11:47:36 GMT

Hi,

Goto SE11 and create a table with customer namesapce .

If u want to allow that entries shouldd be maintained by the customer., Cehck the Maintenance allowed check box in the attributes tab of the table.

Also Customizing table is delivery class maintained for allowing customer maintenance.

Re: Create a custom table

Former Member — Fri, 08 Dec 2006 15:18:53 GMT

Hi ,

Go to se11 transaction ,

give ' C ' in the delivery class .This allows you to enter records even from se11 ,transsaction , abap program .

Select the delivery maintanance allowed .

Now enter the mandt field in the next tab and all the requiered fields along with the data element .

goto to utilities -> table maintenance generator .

Give the function group .

Select the number of steps .

Then press the number of screens .

Then save .

The press create .

Come back to the initial screen .

To enter the data

goto Utilities -> table contents -> entries .

add record .

Re: Create a custom table

Former Member — Mon, 11 Dec 2006 05:40:28 GMT

hi dwibedi,

Inorder to create a custom table in se11.. u have to select table type as 'C' customizing table and select delivery with maintenance allowed u can do wat u like..

regards ,

Rajkumar.G

Re: Create a custom table

Former Member — Mon, 11 Dec 2006 05:50:23 GMT

hi,

Thanks for your replies. But my actual problem is that i am creating entries in development system, and when i need those entries in testing system, i need to transport it to test or may be production system. But requirement is that, user should be able to create entries in the production itself and he should not transport it all the time from dev or test systems. My table has 'C' as the delivery class and i have also created the table maintenance generator. But still something is missing i guess.

Please let me know what shouldd be done in this case.

Re: Create a custom table

Former Member — Mon, 11 Dec 2006 06:12:03 GMT

Hi,

Take out the mandt in se11 .If mandt is present it is not cross client .

Hope this helps you .

Re: Create a custom table

Former Member — Mon, 11 Dec 2006 06:47:30 GMT

Hi,

The table will be transported to production system and from there user will be creating entries through table maintenance generator(as its been already generated) . Removing MANDT wont solve the problem.

Re: Create a custom table

Former Member — Mon, 11 Dec 2006 07:33:36 GMT

Hi,

1. Create a custom table using SE11 Trasaction.

2. Create a table maintenence screen for table using SE11 itself.

3. Using SM30 / SM31, you can request your user to maintain the table directly in production. If its a critical table, restrict with Authorization.

Regards,

Ramki.