‎2008 Apr 18 1:09 PM
Hi,
In selection screen - Parameter P_vkorg default value 'A'.
.Here the sales organization 'A' is always default.
Now the user wants to add sales organization 'B'.
In that condition :-
if user belongs to 'A' then - Default will be 'A' and A related data will be display.
if user belongs to 'B'. then default will be 'B' and B related data will display...
Hints :
select PARVA from USR05 table
with condition PARID = 'A'.
we have to to populate it before execute . in case of parameter how we populate..
Bye..
‎2008 Apr 18 1:16 PM
Hi,
You can do this in INITIALIZATION event of the report. It is like START-OF-SELECTION. Triggered before the selection is displayed. Here you can write your select query and populate the parameter.
Example:
INITIALIZATION.
Select single * from XXXX into P_value where .........
This will be called before displaying the selection screen. When the selection screen is displayed the parameter will be filled by the value in the table.
Reward points if helpful.
Thanks and Regards,
Lakshmi.
‎2008 Apr 18 1:18 PM
Hi,
Code it in Initialization or At selection-screen output event.
p_vkorg = <value selected by select query>.
Regards,
Mohaiyuddin
‎2008 Apr 18 1:18 PM
Hi,
select PARVA
from USR05
into i_parva
where parid = p_vkorg.
ples reward points if helpful.
‎2008 Apr 18 1:18 PM
Hi,
select PARVA
from USR05
into i_parva
where parid = p_vkorg.
please reward points if helpful.
‎2008 Apr 18 1:20 PM
Hi,
try this
SELECT-OPTIONS P_VKORG FOR VBRK-VKORG DEFAULT 'A' TO 'B'.
‎2011 Mar 01 1:59 PM