topic Re: function module in Application Development and Automation Discussions

function module

Former Member — Fri, 23 May 2008 15:02:00 GMT

i hv got the output ............but i want that only 3 fields will be display which i needed.................i.e.

SELECT MATNR

VMSTA

VMSTD

FROM mvke

INTO corresponding fields of TABLE i_mvke

WHERE MATNR = MATNO.

but when i m executing .........all the fields of table mvke are displayed.........i know that the remaining fields will contain zero/blank value........but i dont want to display all that fields.....

Re: function module

Former Member — Fri, 23 May 2008 15:04:59 GMT

Hi,

Check how you have declared the internal table i_mvke.Decalre it as follows:

types:begin of str,

MATNR type mvke-matnr,

VMSTA type mvke-vmsta,

VMSTD type mvke-VMSTD,

end of str.

Data:i_mvke type standard table of str.

Re: function module

Former Member — Fri, 23 May 2008 15:05:19 GMT

If u only need 3 fields declare the internal table only with this fields

data: begin of i_mvke occurs 0,

matnr like mvke-matnr,

vmsta like mvke-vmsta,

vmstd like mvke-vmstd,

end of i_mvke.

SELECT MATNR

VMSTA

VMSTD

FROM mvke

INTO TABLE i_mvke

WHERE MATNR = MATNO.

Re: function module

Former Member — Fri, 23 May 2008 15:06:48 GMT

How did you declare your I_MVKE?

declare with only those fields that you want.

data: begin of i_mvke occurs 0,

MATNR type mvke-matnr,

VMSTA type mvke-vmsta,

VMSTD type mvke-vmstd,

end of i_mvke.

Regards,

Ravi

Re: function module

Former Member — Fri, 23 May 2008 15:07:52 GMT

hi,

give ur code for WRITE statement where you are displaying Report.

so, that I wil go thur once and tel u.

regards

Sandeep reddy

Re: function module

Former Member — Fri, 23 May 2008 21:31:54 GMT

Decalre your internal table i_mvke like this

DATA: BEGIN OF i_mvke OCCURS 0,

MATNR TYPE mvke-MATNR ,

VMSTA TYPE mvke-VMSTA,

VMSTD type mvke-VMSTD,

END OF i_mvke.

SELECT MATNR

VMSTA

VMSTD

FROM mvke

INTO corresponding fields of TABLE i_mvke

WHERE MATNR = MATNO.

Reward me if it helps. let me know if you have any question.

Regards,

Kinjal