topic Re: alv reports in Application Development and Automation Discussions

alv reports

Former Member — Tue, 25 Mar 2008 18:05:56 GMT

hi friends ,

i have an issue

i have the select options matnr,werks,vtweg(dist.channel),dispo(mrp cntller) etc.

when the user enters these fields for a mrp cntrler say002 it has to give the data of the shortage deficit

in "percentages" for different dist.channels

and when u click on the mrp cntrller it has to navigate to the other screen

wich must show the shortage deficit of the individual raw materials in "percentages"

itz very urgent plz help me

any clue ...

Thanks

Re: alv reports

Former Member — Tue, 25 Mar 2008 18:10:29 GMT

hi check this and let me knows if there is any questions...

&----

*& Report ZVENKATTEST0

&----

REPORT ZVENKATTEST0.

TABLES:MARA.

SELECT-OPTIONS:S_TEST1 FOR MARA-MATNR MODIF ID M1 ,

S_TEST2 FOR MARA-MEINS MODIF ID M2 .

PARAMETERS:P_RAD1 RADIOBUTTON GROUP G1 USER-COMMAND UC1 DEFAULT 'X',

P_RAD2 RADIOBUTTON GROUP G1 ,

P_RAD3 RADIOBUTTON GROUP G1 .

AT SELECTION-SCREEN OUTPUT .

LOOP AT SCREEN.

IF P_RAD1 = 'X'.

IF SCREEN-NAME = 'S_TEST1-LOW' .

SCREEN-INPUT = '0'.

MODIFY SCREEN.

ENDIF.

IF SCREEN-NAME = 'S_TEST1-HIGH' .

SCREEN-INPUT = '0'.

MODIFY SCREEN.

ENDIF.

IF SCREEN-NAME = 'S_TEST2-LOW' .

SCREEN-INPUT = '0'.

MODIFY SCREEN.

ENDIF.

IF SCREEN-NAME = 'S_TEST2-HIGH' .

SCREEN-INPUT = '0'.

MODIFY SCREEN.

ENDIF.

IF P_RAD2 = 'X'.

IF SCREEN-NAME = 'S_TEST1-LOW' .

SCREEN-INPUT = '0'.

MODIFY SCREEN.

ENDIF.

IF SCREEN-NAME = 'S_TEST1-HIGH' .

SCREEN-INPUT = '0'.

MODIFY SCREEN.

ENDIF.

IF P_RAD3 = 'X'.

IF SCREEN-NAME = 'S_TEST2-LOW' .

SCREEN-INPUT = '0'.

MODIFY SCREEN.

ENDIF.

IF SCREEN-NAME = 'S_TEST2-HIGH' .

SCREEN-INPUT = '0'.

MODIFY SCREEN.

ENDIF.

ENDLOOP.

regrards,

venkat.

Re: alv reports

Former Member — Tue, 25 Mar 2008 18:21:27 GMT

hi venkat ,

thanks for the reply ,

i m fine wih creating the screens

but my main issue is that it has to calcullte the shortage deficit for given MRP CONTRLER and DIST.CHANNEL

in PERCENTAGES ...

and when the user clicks on a particular mrp controller it has to navigate to the other screen and show the shortage deficit for individual

raw materials in percentages .

hope i m clear ......

Re: alv reports

Former Member — Tue, 25 Mar 2008 18:41:35 GMT

hi you can do it like this... if u write the coding for getting data in the selection screen output condition it is possible..

this is an example....

at selection-screen output.

select matnr

meins

mtart

pstat

ernam

from mara

into table it_mara

where matnr in s_matnr.

regards,

venkat.