topic Re: Insert Query in Application Development and Automation Discussions

Insert Query

Former Member — Thu, 18 Sep 2008 09:27:06 GMT

hi,

am creating a Function Module,

i just want to insert a record into my ZTABLE through SE37.

No Internal table or work area is used.

I couldn't frame out the inert query properly..

Can any one please help me by providing possible insert query.

Thanks.

Re: Insert Query

JozsefSzikszai — Thu, 18 Sep 2008 09:29:45 GMT

i just want to insert a record into my ZTABLE through SE37.
> No Internal table or work area is used..

it won't be easy then... (the versions of INSERT without internal table / work area are obsolate)

Re: Insert Query

Former Member — Thu, 18 Sep 2008 09:33:57 GMT

You create a FM

TABLES

TableName =

Internaltable =

use

insert TableName from table Internaltable.

Re: Insert Query

Former Member — Thu, 18 Sep 2008 09:34:21 GMT

Hi,

You must have declared table under TABLES section in Function module.

FUNCTION ZTEST1.

*"----

""Local Interface:

*" TABLES

*" TAB STRUCTURE ZTEST

*"----

INSERT ZTEST FROM TAB.

ENDFUNCTION.

Re: Insert Query

naveen_inuganti2 — Thu, 18 Sep 2008 09:36:15 GMT

Hi..,

You have to use work area in your source code of your function module, If you dont want declare it in parameters..

data: wa type ztable.
wa-f1 = 'a'.
wa-f2 = 'b'.
wa-f3 = 'c'.
\\\\\\\
insert into ztable values wa.

here a, b, c are either importing parameters or entries which you fetched from other table with where condition of ur import parameter.

Thanks,

Naveen.I

Re: Insert Query

Former Member — Thu, 18 Sep 2008 09:44:55 GMT

Hi,

it is possible with out work area or internal table.

--Naresh.

Re: Insert Query

Former Member — Thu, 18 Sep 2008 10:02:10 GMT

thanks a lot for all ur suggestions..

Am getting the following error message while declaring the internal table in tables tab:

Tables parameters are obsolete!

How to declare the Internal table?

Thanks.

Edited by: RPN on Sep 18, 2008 12:02 PM

Re: Insert Query

Former Member — Thu, 18 Sep 2008 10:08:29 GMT

you have to declare the table in changing option of the FM with reference to a table type that you have to create in SE11, using this table type declare your internal table in CHANGING,

as tables options have became obsolete.

With luck,

Pritam.

Re: Insert Query

Former Member — Thu, 18 Sep 2008 10:10:10 GMT

internal that you pass in Fm,

its type must be defined in abap dictionary.

Re: Insert Query

Former Member — Thu, 18 Sep 2008 10:54:30 GMT

THANKS A LOT:)

RPN