function module

[Former Member]

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.....

[Former Member]

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.

[Former Member]

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.

[Former Member]

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

[Former Member]

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

[Former Member]

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