topic Re: Material Report in Application Development and Automation Discussions

Material Report

Former Member — Thu, 28 Dec 2006 17:14:28 GMT

I practicing a report where I prompt user to enter for MATNR range and display output for that range...

TABLES: MARA

DATA : BEGIN OF ITAB OCCURS 0

MATNR LIKE MARA-MATNR,

ERSDA LIKE MARA-ERSDA,

ERNAM LIKE MARA-ERNAM,

MTART LIKE MARA-MTART,

ENDOF ITAB.

*SELECT OPTION FOR USER TO ENTER MATERIAL RANGE

LOOP AT ITAB

WRITE 😕 ITAB-MATNR, ITAB-ERSDA,ITAB-ERNAM,ITAB-MTART

ENDLOOP.

Could someone help me how to proceed after select-options...

Re: Material Report

Former Member — Thu, 28 Dec 2006 17:20:08 GMT

Hi,

Check this..

TABLES: MARA

DATA : BEGIN OF ITAB OCCURS 0

MATNR LIKE MARA-MATNR,

ERSDA LIKE MARA-ERSDA,

ERNAM LIKE MARA-ERNAM,

MTART LIKE MARA-MTART,

ENDOF ITAB.

SELECT-OPTIONS: SO_MATNR FOR MARA-MATNR.

GET THE VALUES

SELECT MATNR ERSDA ERNAM MTART

FROM MARA

INTO TABLE ITAB

WHERE MATNR IN SO_MATNR.

LOOP AT ITAB

WRITE 😕 ITAB-MATNR, ITAB-ERSDA,ITAB-ERNAM,ITAB-MTART

ENDLOOP.

Thanks,

Naren

Re: Material Report

Former Member — Thu, 28 Dec 2006 17:21:48 GMT

Hi Alexander,

Write a SELECT in START-OF-SELECTION event to get the data into internal table and display the contents in END-OF-SELECTION event.

Try with this code.

SELECT-OPTIONS: R_MATNR FOR MARA-MATNR.

START-OF-SELECTION.

SELECT MATNR ERSDA ERNAM MTART

FROM MARA

INTO TABLE ITAB

WHERE MATNR IN R_MATNR.

END-OF-SELECTION.

IF ITAB[] IS NOT INITIAL.

LOOP AT ITAB.

WRITE 😕 ITAB-MATNR, ITAB-ERSDA, ITAB-ERNAM, ITAB-MTART.

ENDLOOP.

ENDIF.

Thanks,

Vinay

Re: Material Report

Former Member — Thu, 28 Dec 2006 17:22:41 GMT

SELECT-OPTIONS: SO_MATNR FOR MARA-MATNR.

GET THE VALUES

SELECT MATNR ERSDA ERNAM MTART

FROM MARA

INTO TABLE ITAB

WHERE MATNR IN SO_MATNR.

Can you explain what this part does

Re: Material Report

Former Member — Thu, 28 Dec 2006 17:25:30 GMT

Hi Alxendar,

It will fetch the data from the database table MARA(Material master) into internal table ITAB where MATNR(Material number) is specified under SO_MATNR(what you input at your selection-screen).

Thanks,

Vinay

Re: Material Report

Former Member — Thu, 28 Dec 2006 17:26:50 GMT

Hi,

SELECT-OPTIONS: SO_MATNR FOR MARA-MATNR.

Defines a range in the selection screen for the material..Where the user can enter range or multiple material.

GET THE VALUES

SELECT MATNR ERSDA ERNAM MTART

FROM MARA

INTO TABLE ITAB

WHERE MATNR IN SO_MATNR.

For the input material entered in the selection-screen...Getting the material master details from the table MARA...IN is used for select-options in the WHERE clause of the select statement to filter the data based on the input..

Thanks,

Naren

Re: Material Report

Former Member — Fri, 29 Dec 2006 12:22:40 GMT

hi,

DATA : BEGIN OF ITAB OCCURS 0

MATNR LIKE MARA-MATNR,

ERSDA LIKE MARA-ERSDA,

ERNAM LIKE MARA-ERNAM,

MTART LIKE MARA-MTART,

ENDOF ITAB.

*********************

select-options : s_matnr for itab-matnr.

***********************

start-of-selection.

select matnr ersda ernam mtart from mara into table

itab where matnr in s_matnr.

end-of-selection.

loop at itab.

write : / itab-matnr, itab-ersda, itab-ernam.

endloop.

if helpful get some points.

regards.

Praveen