topic Re: inserting data in ztable in Application Development and Automation Discussions

inserting data in ztable

Former Member — Thu, 24 Apr 2008 09:29:04 GMT

Hi Frd

I wants to insert data in ztable.can anyone tell me how to do that .

thanks

Pari

Re: inserting data in ztable

Former Member — Thu, 24 Apr 2008 09:31:12 GMT

Using Table Maintenance Generator

Go to SE11, give the table name and click on change. Then Go to utilities--> Table

maintenance generator.

In the table maintenance generator screen, we should give Authorization Group,

Function Group name (Function Group name can be same as table name),

Maintenance type can be one step or two step, usually we will create with one

step. we should give maintenance screen number. After clicking on create button,

a table maintenance generator will be created.

To check it go to SM30 . In SM30, we find display, Maintain options.

We can view the table contents by choosing Display and we can create table

entries by choosing Maintain.

Have a look at below link for more details:

[Table Maintenance|http://help.sap.com/saphelp_nw04/helpdata/en/67/86b0f5415811d1893d0000e8323c4f/frameset.htm]

I hope it helps.

Thanks,

Vibha

Please mark all the useful answers

Re: inserting data in ztable

Former Member — Thu, 24 Apr 2008 09:32:04 GMT

Hi,

Goto SE11

Provide the Ztable Name and Display.

Utilities->Tablecontents->create entries

If you want to insert multiple data then you can create

a maintenace view from sm30 or from SE11 utilities->generate table maintenace.

Check the link on step by step table maintenace creation

/people/sudheer.cheedella/blog/2006/02/20/extracting-data-in-table-maintenance

Regards,

Raj.

Re: inserting data in ztable

Former Member — Thu, 24 Apr 2008 09:33:10 GMT

Hi,Pari

You can use se16 to insert data directly,

or generate maintenance view in Se11,than input data in SM30.

Regars

Pole

Re: inserting data in ztable

asik_shameem — Thu, 24 Apr 2008 09:33:26 GMT

Do in this way.

wa-name = 'DIAZ'.
wa-deptkey = 'HNR'.
wa-salary = 1250.

***************** INSERT*********************
insert into zemp_sal values wa.

if sy-subrc eq 0.
    write / 'record inserted successfully'.
else.
    write / 'record already exists'.
endif.

Re: inserting data in ztable

Former Member — Thu, 24 Apr 2008 09:33:36 GMT

Hi,

Go to SE16 tcode and give the ztable name and then click on create entries.pass the values in to the fileds and then click on save.

Regards,

Koti.

Re: inserting data in ztable

Former Member — Thu, 24 Apr 2008 09:52:27 GMT

Hi,

Just Check this:

Goto SE16N and give the table name for which you like to insert values.

After giving the table name goto Transaction &SAP_EDIT and press enter you will get a message like editing function is activated.

Now press execute and you can insert new values into your ZTABLE.

Think this is helpful.

Rwd if helpful.

Thanks.

Re: inserting data in ztable

Former Member — Thu, 24 Apr 2008 10:23:18 GMT

create table maintenance generator and do it from sm30...

regds