topic Re: Database table creation in Application Development and Automation Discussions

Database table creation

former_member233090 — Fri, 21 Aug 2009 12:27:11 GMT

Hi,

Iam new to abap programming. i just want to create a table in the database

for suppose

i have taken for employee details with 3 coloumns

EmpNo EmpName DeptNo

with predefined datatype

i have added all the coloumns and when iam trying to create enteries to these coloumns (main menu -> Utilities->Table contents-> create new enteries . it is giving an error

"The system settings (SE06 and SCC4) are such that you cannot make any changes to this table in this client."

so iam unable to understand the problem ,can u pls help me out

Re: Database table creation

Former Member — Fri, 21 Aug 2009 12:29:45 GMT

Hi,

You seem to have created a configuration table when you actually want an application data table.

You need to reseach the meaning of the settings on the 'Delivery and Maintenance' tab and in the table maintenance generator.

Regards,

Nick

Re: Database table creation

former_member233090 — Fri, 21 Aug 2009 12:41:43 GMT

Hey Nick...

thanks for ur reply...but can u be more clear pls

Re: Database table creation

Former Member — Fri, 21 Aug 2009 12:46:31 GMT

Set the Technical Settings(ctrlshftF9), Delivery and Maintenance tab and Table maintenance(Utilities->Table Maintenance Generator).

Re: Database table creation

Former Member — Fri, 21 Aug 2009 12:52:17 GMT

Hi,

When you create a table there are settings you need to make that will dictate whether the table is configuration table (only changed in one client then moved to other systems using transport) or application data (maintained, usually by end users direct in any client in the landscape).

As your table has employee number as the key it seems to be an application data table, but the message you get suggests it is not set as this.

So, in transaction SE11 (where you created the table) look at the settings on the 'Delivery and Maintenance' tab, read the help for these fields and set them to the correct values to maintain the table directly. Also, you are using the option 'Utilities->Table contents-> create new entries' to create entries, where you could use 'Utilities -> Table maintenance generator' to create a maintenance screen. If you choose do this you'll need to check these settings are correct for an application data table.

Regards,

Nick

Re: Database table creation

Former Member — Fri, 21 Aug 2009 16:40:24 GMT

HI,

When ever you want to make the table as cross client and get it transported, first give the mandt field as the key option.

Later select, deliver and maintenance allowed in the attributes section which is important if you want to create new entries.

then later give the enhancement category also in the extras as can be enhanced char or numeric, inorder to avoid the warnings while activating the table.

go to utilities-table maintenance generator, with the help of this maintenance generator ( clients can input the data directly through sm30 tcode ( create new entries, edit,delete ).

steps to create maintenance generator:

give the function group,

select one step

give the screen number

then press create

it will ask for the package, specify the package ,press enter

then it will ask the transport number,specify the same.

now the maintenance generatir is done.

go to sm30 tcode and specify the table name and press maintain.

add your entries by clicking new entries.

upon new entries, save it , inorder to get the entires saved in to the table .

Re: Database table creation

Former Member — Mon, 24 Aug 2009 14:17:24 GMT

Have you import into the table the field MANDT ( Client ) ?

With Regards

George

Edited by: giorgos michaelaris on Aug 24, 2009 5:17 PM

Re: Database table creation

Former Member — Tue, 25 Aug 2009 06:26:51 GMT

Hi,

Please specify the table parameters you have set in Delivery and Maint Tab.

Regards,

Re: Database table creation

digvijay_rai — Tue, 25 Aug 2009 07:08:37 GMT

Dear Bhavana,

I think there is the problem from SCC4 tcode .

go to tcode SCC4 , select your client and double click on that .

in cross client object changes , check option is

changes to Repositry and cross client Customizing allowed or not .

if not then select this option .

your problem will be solved .

Thanks & Regards

Digvijay Rai

Re: Database table creation

Former Member — Wed, 26 Aug 2009 11:24:54 GMT

Hi,

Check out this link. Hope it may help you.

And also maintain the Enhancement category option.

Regards,

Revathi Bhoopal.

Re: Database table creation

Former Member — Wed, 26 Aug 2009 11:25:03 GMT

Hi,

Check out this link. Hope it may help you.

And also maintain the Enhancement category option.

Regards,

Revathi Bhoopal.

Re: Database table creation

Former Member — Wed, 26 Aug 2009 11:26:03 GMT

Hi,

Check out this link. Hope it may help you. Also maintain the enhancement category option.

Regards,

Revathi Bhoopal.

Re: Database table creation

Former Member — Fri, 28 Aug 2009 12:28:14 GMT

Hi Bhavana,

in se11, enter table name & goto 'deliver and maintenenace' tab ,

for 'Data Browser/Table View Maint.' drop down option, select 'Display & maintenace allowed' option .

now save & activate the table.

Now try entering the new values, it will allow to create.

Hope this clue may help you in solving this issue

Rgds

Sripal

Re: Database table creation

former_member233090 — Mon, 31 Aug 2009 03:44:26 GMT

Hey,

The problem has been solved. Thank you all for your responses.

Bhavana