topic Re: Insert data into table in Application Development and Automation Discussions

Insert data into table

Former Member — Tue, 10 Apr 2007 03:25:52 GMT

Hi SDN's,

I m new to abap.

could u plz help me.

let us take i m having a table with two fields say eno, ename.

i want to insert da data during runtime,

when i executed, it should display two fields.

i wants to insert data in two fileds, this data sholud save in db table.

how to do that.

plz guide me

thanks in advance

Re: Insert data into table

Former Member — Tue, 10 Apr 2007 03:31:15 GMT

Hi..

data:

begin of itab occurs 0,

eno , " data types of dbtable

ename, " data types of dbtable

end of itab.

2. Fill the itab with some values.

3. INSERT <dbtab> FROM TABLE <itab> [ACCEPTING DUPLICATE KEYS] .

Re: Insert data into table

Former Member — Tue, 10 Apr 2007 03:47:34 GMT

Hi Renu,

You can generate Table Maintenance, and then inster the values into DB as shown

1. Go to SE11 and enter the table for which u want to enter values

2. Go to Utilities from menu bar

3. Clk on Table Maintenance Generator

4. Choose Authorization Group and Function Group

5. Clk on Execute.

once u create Table Maintenance, to enter the values go to

1. SM30

2. Enter the Table Maintence name

then it will take you to a screen where you can enter and save the values into DB.

Re: Insert data into table

Former Member — Tue, 10 Apr 2007 03:48:01 GMT

Hi Renu,

First declare a itab with the fields u want to fill the data base table.

data: begin of itab occurs 0,

eno type string,

ename type tsring,

end of itab.

fill the itab with the data u want to store in database table.

then using insert statement u can insert the data into database table.

insert dbtale from table itab.

u can also insert into database table without using internal table.

tables : databasetable.

databasetable-eno = 'value'.

databasetable-ename = 'value'.

insert databasetable.

here databasetable acts as work area and insert is done into database table from workarea.

Re: Insert data into table

Former Member — Tue, 10 Apr 2007 03:57:50 GMT

hi frinds,

i dont want to insert while writing code.

when i executed my program, i screen should hav to input fields,

in those fileds i hav to write the data. when i press save button, these two input field values should save in data base.

plz tell me

Re: Insert data into table

Former Member — Tue, 10 Apr 2007 04:28:40 GMT

hi renu ,

for that u have to declare it as parameters soething like this

parameters: databasetable-eno ,

databasetable-ename .

case 'button'.

when 'save' .

insert databasetable.

endcase.

ravi

Re: Insert data into table

Former Member — Tue, 10 Apr 2007 05:42:29 GMT

hi ravi,

could u plz provide me sample code.

it wolud be very helpful for me.

thanks in advance

Re: Insert data into table

anversha_s — Tue, 10 Apr 2007 05:45:13 GMT

hi,

chk this.

REPORT ztestreport .
 
DATA : BEGIN OF int OCCURS 0,
       client LIKE ztable-client,
       emp_name LIKE ztable-emp_name,
       emp_id LIKE ztable-emp_id,
       END OF int.
 
 
int-client = '501'.
int-emp_name = 'Test Data'.
int-emp_id = '0001'.
 
APPEND int.
 
INSERT ztable FROM TABLE int.
COMMIT WORK.

Rgds

Anver

Re: Insert data into table

Former Member — Tue, 10 Apr 2007 05:52:26 GMT

hi anversha,

here ur coding for to inseet data like

int-client = '501'.

int-emp_name = 'Test Data'.

int-emp_id = '0001'

but i want to insert this data during runtime when i executed da program.dats wat i m asking

but any ways thanks for ur reply.

do u knw how to do dat method

Re: Insert data into table

anversha_s — Tue, 10 Apr 2007 05:57:16 GMT

hi,

chk this.

REPORT ztestreport .
 
DATA : BEGIN OF int OCCURS 0,
       client LIKE ztable-client,
       emp_name LIKE ztable-emp_name,
       emp_id LIKE ztable-emp_id,
       END OF int.
 
parameters: p_name(35) tyep c ,
                  P_empno(10)n type c.
databasetable-ename .


start-of-selection.

case 'button'.
when 'save' .
int-client = sy-mandt.
int-emp_name = p_name.
int-emp_id = P_empno.
 
APPEND int.
 
INSERT ztable FROM TABLE int.
COMMIT WORK.

endcase.

rgds

Anversha

Re: Insert data into table

Former Member — Tue, 10 Apr 2007 06:00:40 GMT

Hi Renushree,

Is it possible for you to use select options,one for emp no and other for emp name.

So when you execute it wil insert to the database tables.

No need of internal tables in that case or not much code.

Regards,

Ponraj.s.

Re: Insert data into table

Former Member — Tue, 10 Apr 2007 06:06:59 GMT

i hav done same thing what u hav done.

but its throughing sme error like

the work are "int" is not long enough

what does it mean

Re: Insert data into table

anversha_s — Tue, 10 Apr 2007 06:19:08 GMT

hi,

chnage it like this and try.

may be length is an issue.

parameters: p_name like ztable-emp_name,
                  P_empno like ztable-emp_id.

rgds

Anver

Re: Insert data into table

Former Member — Tue, 10 Apr 2007 06:38:43 GMT

hi anversha,

i hav done, and its getting executed also.

but its not saving data in database.

y so.

i m giving the code, hav a look n find out whats wrong in this

plzzzz

DATA : BEGIN OF itab OCCURS 3,

empno LIKE zemp-empno,

empname LIKE zemp-ename,

doj like zemp-doj,

END OF itab.

parameters: p_empno like itab-empno,

P_name like itab-empname,

p_doj like itab-doj.

tables zemp.

start-of-selection.

case 'button'.

when 'save' .

itab-empname = p_name.

itab-empno = P_empno.

itab-doj = p_doj.

APPEND itab.

insert zemp into itab.

COMMIT WORK.

endcase.

Re: Insert data into table

Former Member — Tue, 10 Apr 2007 06:41:46 GMT

hi renu,

i dont have an sys to check my code just use this logic to develop it it will work

ravi

Re: Insert data into table

anversha_s — Tue, 10 Apr 2007 06:45:28 GMT

hi,

error is here

insert zemp into itab.

chnage like this.

INSERT zemp FROM TABLE itab.

Rgds

Anver

Re: Insert data into table

Former Member — Tue, 10 Apr 2007 07:04:18 GMT

its working now

any wayz thanks sdn's.