topic Re: Function Modules. in Application Development and Automation Discussions

Function Modules.

Former Member — Thu, 22 Nov 2007 01:23:11 GMT

I am creating a Function Module and in Export parameter I am giving:

S_vbak like vbak-vbeln.

In tables I am giving:

ITAB like vbak

In source code I am giving :

TABLES:vbak.

SELECT vtweg FROM vbak INTO TABLE itab WHERE vbeln EQ s_vbeln.

LOOP AT itab.

WRITE:itab-vtweg.

endloop.

ENDFUNCTION.

But I am getting Zero entries,can u plz tell the error.

Re: Function Modules.

Former Member — Thu, 22 Nov 2007 03:10:55 GMT

chk vbeln "used this converstion_inpu alphaexit.

S_vbak like vbak-vbeln.

In tables I am giving:

ITAB like vbak

In source code I am giving :

TABLES:vbak.

*chk p_vbeln run time length both are same or not.

SELECT vtweg FROM vbak INTO TABLE itab WHERE vbeln EQ s_vbeln.

if sy-subrc =0. record found else where condition error

LOOP AT itab.

WRITE:itab-vtweg.

endloop.

endif.

ENDFUNCTION.

Re: Function Modules.

Former Member — Thu, 22 Nov 2007 03:23:32 GMT


S_vbeln like vbak-vbeln. " S_VBAK is changed to S_VBELN

" In tables I am giving:
data : ITAB type standard table of  vbak.

" In source code I am giving :
TABLES:vbak.

SELECT * FROM vbak INTO TABLE itab WHERE vbeln IN s_vbeln. " EQ changed to IN
LOOP AT itab.
WRITE:itab-vtweg.
endloop.

Re: Function Modules.

Former Member — Thu, 22 Nov 2007 03:26:25 GMT

Hi,

If u r using select-options, U should not use EQ u can use IN.

SELECT vtweg FROM vbak INTO TABLE itab WHERE vbeln IN s_vbeln.

Like this.

Re: Function Modules.

Former Member — Thu, 22 Nov 2007 03:26:29 GMT

Hello Ajaya,

As per my understanding, in the below select statement, s_vbeln is not assigned with any value. Are you looking for values in vbak with no entry in vblen ? if not may be you need to assign a value to it and then this staement will return you the required output.

SELECT vtweg FROM vbak INTO TABLE itab WHERE vbeln EQ s_vbeln.

Best regards,

Kulwant Singh

Re: Function Modules.

Former Member — Thu, 22 Nov 2007 03:50:20 GMT

Hi,ajaya.

I think you can try call this function in a program.

Regards,

feng.

Re: Function Modules.

Former Member — Thu, 22 Nov 2007 04:20:48 GMT

Hi,

If u want to get the entries from VBAk based on S_VBAK,

then give S_VBAK in IMPORT parameters.

U need not write any Loop statement, because u r directly retrieving the values in to ur export table.

Ex:

Import: S_VBELN like VBAK-VBELN.

Tables: ITAB like VBAK.

Source code: Select * from VBAK into table ITAB where VBELN = S_VBELN.

Note: If u want only particular fields to be displayed, then u need to create a structure with these fields and give in Tables parameters.

Re: Function Modules.

Former Member — Thu, 22 Nov 2007 04:35:33 GMT

read the itab into a structure which has the same type as the table itab.

data: wa type vbak.

loop at itab into wa

write : wa-vtweg.

endloop.

Re: Function Modules.

Former Member — Thu, 22 Nov 2007 05:17:39 GMT

we will be calling this function module in some program.

right?

so just change the select statement i.e. remove the loop from there.

and try calling the FM in some prg and then you will come to know where exactly you are going wrong.

Message was edited by:

prachi s

Re: Function Modules.

Former Member — Thu, 24 Jan 2008 12:31:51 GMT

try it with this coding. that one is properly written.

S_vbak like vbak-vbeln.

In tables I am giving:

ITAB like vbak

In source code I am giving :

TABLES:vbak.

SELECT vbeln vtweg FROM vbak INTO corresponding fields of TABLE itab WHERE vbeln EQ s_vbak.

LOOP AT itab.

WRITE:itab-vtweg.

endloop.

ENDFUNCTION.

now it will work.