07-31-2008 3:58 PM
Hi Friends:
Please help me in coding the following scenario:
I've the following checkboxes on selection screen:
1. inventory quantity current period-unrestricted (mard-labst)
2. inventory quantity current period-restricted use stock (mard-einme)
3. inventory quantity current period-in quality inspection(mard-insme)
4. inventory quantity current period - blocked (mard-speme)
5. inventory quantity current period - returns (mard-retme)
6. inventory quantity current period- stock in transfer (mard-umlme)
now the scenario is like this. The user may check 1/2/3/4/5/6 checkboxes while executing this program. Now what all checkboxes are checked, only those values to be fetched from MARD. E.g. 1 & 2 are checked. Then I'll fetch labst & einme from MARD. Then I'll add it up. Please help me in coidng this. How to decide it at runtime.
Thanks:
07-31-2008 4:03 PM
Gaurav
you can write 6 different select like this
if checkbox1 = 'X'.
select mard-labst .
endif.
if checkbox2 = 'X'.
select mard-einme.
endif....and so on...
Amit.
07-31-2008 4:03 PM
Gaurav
you can write 6 different select like this
if checkbox1 = 'X'.
select mard-labst .
endif.
if checkbox2 = 'X'.
select mard-einme.
endif....and so on...
Amit.
07-31-2008 4:03 PM
hi check this..
do like this..write the condition in the where condition..
if p_c1 = 'X.
select * from mard into table it_mard where ...
endif.
if p_c2 = 'X.
select * from mard into table it_mard where..
endif.
if p_c3 = 'X.
select * from mard into table it_mard where..
endif.
if p_c4 = 'X.
select * from mard into table it_mard where..
endif.
if p_c5 = 'X.
select * from mard into table it_mard where..
endif.
if p_c6 = 'X.
select * from mard into table it_mard where..
endif.
07-31-2008 4:04 PM
Hi use this logic.
if c1 = 'X.
select single labst from mard into corrseponding table it_mard where..
endif
if c2 = 'X.
select single einme from mard into corrseponding table it_mard where..
endif.
if c3 = 'X.
select single insmefrom mard into corrseponding table it_mard where..
endif.
if c4 = 'X.
select single spemefrom mard into corrseponding table it_mard where..endif.
endif
if c5 = 'X.
select single retme from mard into corrseponding table it_mard where..
endif.
if c6 = 'X.
select single umlme from mard into corrseponding table it_mard where..endif.
endif
Regards,
Prasad.