topic Re: Hi problems in function module in Application Development and Automation Discussions

Hi problems in function module

Former Member — Mon, 21 Jan 2008 07:52:28 GMT

Hi friends I have the following problems.........

When I am using this following code in a function module

its not giving me output until i comment those two fields kwmeng and netwr..i have use VRKME and WAERS for those two..........which are the components of a structure i have created....unless i comment them its giving dump

but when i am using the same thing in report...i am getting

values..off course there is no use of structures......i am creating internal tables and using them ...

i need to use this functio module...how can i get the data from those two fields..tell me the

SELECT vbak~vbeln

vbak~erdat

vbak~vkorg

vbak~ABRVW

vbak~augru

vbak~kunnr

vbap~posnr

vbap~matnr

vbap~vkaus

vbap~spart

vbap~netwr

vbap~waerk

vbap~kwmeng

vbap~kondm

vbap~mvgr1

vbap~mvgr2

vbap~mvgr3

vbap~mvgr4

vbap~mvgr5

FROM vbak AS vbak INNER JOIN vbap AS vbap

ON vbak_{vbeln EQ vbap}vbeln

INTO corresponding fields of TABLE tvbak

WHERE vbak~vbeln = vbeln1.

Re: Hi problems in function module

Former Member — Mon, 21 Jan 2008 07:59:18 GMT

Can you provide details of dump and declaration of tvbak.

Regards

Eswar

Re: Hi problems in function module

Former Member — Mon, 21 Jan 2008 08:00:43 GMT

Hi jyotirmoy,

Check if tvbak has fieldnames same as field you are selecting. As you are using INTO CORRESPONDING FIELDS OF TABLE select query will assign values with same name in your internal table.

Regards,

Mohaiyuddin

Re: Hi problems in function module

Former Member — Mon, 21 Jan 2008 08:00:46 GMT

may i know what is the structure that u created. and is the table referiing that structure

Re: Hi problems in function module

Former Member — Mon, 21 Jan 2008 08:08:42 GMT

there is aproblem witht he last line of your code:

WHERE vbak~vbeln = vbeln1.

it should be

WHERE vbak_{vbeln = vbap}vbeln.

There is no problem with selection of netwr or Kwmeng .

Edited by: Rachana Singh on Jan 21, 2008 9:09 AM

Re: Hi problems in function module

Former Member — Mon, 21 Jan 2008 10:47:42 GMT

while creatin structure for them u need to to specify refeence fields for them

Reward point if helpful

egards

Shashi