topic Re: FUNCTION MODULE in Application Development and Automation Discussions

FUNCTION MODULE

Former Member — Mon, 03 Dec 2007 18:58:51 GMT



Tables:
itab1 like itab.

Import Parameters:
p_erdat like vbak-erdat.
p_vkorg like vbak-vkorg.
p_vtweg like vbak-vtweg.
p_spart like vbak-spart.

Source Code:
DATA:BEGIN OF ITAB OCCURS 0,
       vbeln LIKE vbak-vbeln,
       bsark LIKE vbak-bsark,
       vtweg LIKE vbak-vtweg,
       spart LIKE vbak-spart,
       vdatu LIKE vbak-vdatu,
       END OF ITAB.

  SELECT vbeln bsark vtweg spart vdatu
  FROM vbak
  INTO CORRESPONDING FIELDS OF TABLE ITAB1
  WHERE
  erdat = p_erdat AND
  vkorg = p_vkorg AND
  vtweg = p_vtweg AND
  spart = p_spart.

I have created a Function Module in which I have given the above entries,but I am not getting any data in internal table itab1.Can anyone please suggest.points will be no doubt rewarded.

Re: FUNCTION MODULE

naimesh_patel — Mon, 03 Dec 2007 19:04:45 GMT

In order to get the values from this select query you must pass all 4 fields with values. If you don't put value to any field you will not get any data in the itab.

Make your fields as mandatory parameters.

Regards,

Naimesh Patel

Re: FUNCTION MODULE

former_member194669 — Mon, 03 Dec 2007 19:06:42 GMT

Hi,

1. change itab1 to itab


SELECT vbeln bsark vtweg spart vdatu
  FROM vbak
  INTO CORRESPONDING FIELDS OF TABLE ITAB "<<<<
  WHERE
  erdat = p_erdat AND
  vkorg = p_vkorg AND
  vtweg = p_vtweg AND
  spart = p_spart.

2. If you are not getting value then first go to se16 --> enter table name VBAK and give all input values for erdat, vkorg, vtweg, spart and check whether you are getting entries?

a®

Re: FUNCTION MODULE

Former Member — Mon, 03 Dec 2007 19:17:05 GMT

I am passing all 4 fields and it is also showing 2 entries but when i am entering inside it,it shows no entries,only 2 columns that is keypart and funcpart is coming.

Plz suggest.

Re: FUNCTION MODULE

former_member156446 — Mon, 03 Dec 2007 19:45:56 GMT

make sure the alpha exit ( Padding zeros) are fine...

Re: FUNCTION MODULE

former_member195698 — Mon, 03 Dec 2007 19:49:27 GMT

Hi,

Your table Parameter is WRONG. YOu have declared it with type ITAB ( Which is a structure with two fields KEYPART

FUNCPART )

You should declare your own structure with required fields and then use that structure for declaring the parameter ITAB1 in your TABLES parameter for the Function Module

Declare a new structure with fields vbeln bsark vtweg spart vdatu.

Declare your Tables Parameter ITAB1 with type VBAK

Message was edited by:

Abhishek Jolly

Re: FUNCTION MODULE

Former Member — Mon, 03 Dec 2007 19:51:50 GMT

Check the date format which you are passing

Thanks,

Srinivas

Re: FUNCTION MODULE

Former Member — Mon, 03 Dec 2007 20:22:50 GMT

> I am passing all 4 fields <-- assuming that these are 4 import parameters
> and it is also showing 2 entries <-- what is 'it'? 2 entries means you see 2 records in itab1?
> but when i am entering inside it,it shows no entries, <-- What do you mean by "inside it"?
> only 2 columns that is keypart and funcpart is coming. <-- What do you mean by funcpart and keypart?

Re: FUNCTION MODULE

Former Member — Mon, 03 Dec 2007 21:24:11 GMT

I mean when I loook into itab1 in output, not a single field that are present in itab is present in itab1.

Is there any error in declaring internal table?

Re: FUNCTION MODULE

former_member195698 — Mon, 03 Dec 2007 21:40:34 GMT

Hi,

Your TABLES Parameter is WRONG. YOu have declared it with type ITAB ( Which is a structure with two fields KEYPART

FUNCPART )

You should declare your own structure with required fields and then use that structure for declaring the parameter ITAB1 in your TABLES parameter for the Function Module

Create a new structure with fields vbeln bsark vtweg spart vdatu and use it in the tables parameter for ITAB1

Declare your Tables Parameter ITAB1 LIKE VBAK

The TABLES Parameter ITAB1 is not using the Local Internal table structure declared in the Source code. Its using the Data dictinoary structure ITAB

Re: FUNCTION MODULE

Former Member — Mon, 03 Dec 2007 21:41:47 GMT

Try:

  SELECT vbeln bsark vtweg spart vdatu
  FROM vbak
  APPENDING CORRESPONDING FIELDS OF TABLE ITAB1    "<===
  WHERE ...

Rob