topic Function Module query in Application Development and Automation Discussions

Function Module query

Former Member — Tue, 22 Jan 2008 08:16:33 GMT

hi all ,

In my FM , i have a importing parameter kna1-kunnr

i want to select a field from table knvp

based on my importing parameter

how do i use it??

select field from knvp where ""

can anybody help me with this

thnkx

bhanu

Re: Function Module query

former_member182190 — Tue, 22 Jan 2008 08:20:45 GMT

Hi,

If the name of ur Importing parameter is kna1-kunnr then

select fields

from knvp

where kunnr = kna1-kunnr.

if the name of ur importing parameter is i_kna1-kunnr then

select fields

from knvp

where kunnr = i_kna1-kunnr.

Hope this helps.

Regards,

Ismail.

Re: Function Module query

Former Member — Tue, 22 Jan 2008 08:28:36 GMT

ITS GIVING ME ERROR MESSAGE

"KUNNR" IS UNKNOWN

Re: Function Module query

Former Member — Tue, 22 Jan 2008 08:28:55 GMT

hi,

select field from knvp where kunnr = kna1-kunnr.

try this

tables:kna1,knvp.

data itab like knvp occurs 0 with header line.

select kunnr from knvp into itab where kunnr = kna1-kunnr.

endselect.

reward if its helpful

Edited by: Rajasekhar Reddy on Jan 22, 2008 2:02 PM

Edited by: Rajasekhar Reddy on Jan 22, 2008 2:07 PM

Re: Function Module query

Former Member — Tue, 22 Jan 2008 08:33:58 GMT

Hello Bhanu,

Just create a data object like kna1-kunnr.

ex: kunnr1 like kna1-kunnr.

assign the value from importing parameter of function module to kunnr1.

then write query like:

select <field> from knvp where kunnr eq kunnr1.

hope it works.

Reward If Helpful.

Regards

Sasidhar Reddy Matli.

Re: Function Module query

Former Member — Tue, 22 Jan 2008 08:35:35 GMT

Bhanu,

Decalre the internal table with fields which you require from KNVP table.

FOR ex: In FM if you gave v_kunnr

select required fields into table

i_knvp from knvp

where kunnr EQ v_kunnr.

Don't forget to reward if useful...

Re: Function Module query

Former Member — Tue, 22 Jan 2008 08:36:35 GMT

import parameter name may be gv_kunnr.

then ur select statment should be

select kunnr from knvp into table itab where kunnr = gv_kunnr.

Madhavi

Re: Function Module query

Former Member — Tue, 22 Jan 2008 09:23:59 GMT

Hi Dear,

You have 2 use the inner join Bcaz ur using

two tables.

1.First u create the structure for the fields which

u r gng to select from the KNVP table.

In this structure mention u r import parameter

field also.

Eg: Begin of x_KNVP,

Kunnr type Kunnr,

field2 type dataelement,

field3.....

End of x_KNVP.

2.Now write the select query like this

Select Field1

Field2

Fieldn

into corresponding fields of table it_KNVP

from KNVP as C

inner join KNA1 as D

on C_{KUNNR = D}KUNNR.

I hope it will help you.If it helps reward me points.

Regards

AshokChowdhary.M

Re: Function Module query

Former Member — Tue, 22 Jan 2008 09:32:07 GMT

thnkx

now i got it

thkx