‎2008 Mar 03 10:30 AM
hi gurus,
i need following on my screen using module pool.
username from______ to_______(f4 help)
radiobutton1 today " only for today
radiobutton2 all "all the date
radiobutton3 period " between given date.
thanks
anuj
point wil be surely awarded
‎2008 Mar 03 10:44 AM
Hi,
To create screen, Right click on program name -> Select Create -> Screen -> Opens Screen Description page -> Enter short description for screen -> Select screen type as NORMAL -> Click on LAYOUT pushbutton from application toolbar -> Opens Screen Painter -> In the menu bar click the icon dictionary/program fields, the give the database name and select the field(here) username (then u can give search help for the created this username in the attributes screen)or else u can drag and drop two input fields for the username.
Then drag and drop the three radio buttons and name them.
click 'flow logic' to write the code.
hope this helps u,
Arunsri
‎2008 Mar 03 10:39 AM
Oh I am so sorry,I forgot to read the module pool part.You will ahve to design a screen for the same,with the given requirement.
Its a simple case of using SELECT OPTION & Parameter.Even while you type your code for the same,you can always use F1 help for documentation.
SELECTION-SCREEN BEGIN OF BLOCK t1 WITH FRAME TITLE text-001.
SELECT-OPTION USERNAME TYPE SY-UNAME.
SELECTION-SCREEN END OF BLOCK t1.
SELECTION-SCREEN BEGIN OF BLOCK t2 WITH FRAME TITLE text-002.
PARAMETERS p_date TYPE sy-datum DEFAULT sy-datum OBLIGATORY.
PARAMETERS p_ALL TYPE sy-datum .
PARAMETERS P_PERIOD TYPE sy-datum .
SELECTION-SCREEN END OF BLOCK t2.
Edited by: p317980 on Mar 3, 2008 11:40 AM
‎2008 Mar 03 10:44 AM
Hi,
To create screen, Right click on program name -> Select Create -> Screen -> Opens Screen Description page -> Enter short description for screen -> Select screen type as NORMAL -> Click on LAYOUT pushbutton from application toolbar -> Opens Screen Painter -> In the menu bar click the icon dictionary/program fields, the give the database name and select the field(here) username (then u can give search help for the created this username in the attributes screen)or else u can drag and drop two input fields for the username.
Then drag and drop the three radio buttons and name them.
click 'flow logic' to write the code.
hope this helps u,
Arunsri
‎2008 Mar 03 1:49 PM
hello there
thanks for the reply
but my problem is that i have to select all the output between the input
here uname.
if i use select-potions s_ame for tablename-uname.
then in the select query i can use
select * .....
where uname IN s_uname.
please help me of to proceed .
thanks
anuj
‎2008 Mar 03 2:18 PM
Your problem is not understandable.
you defined
SELECT-OPTIONS: s_ame for tablename-uname.
whatever the data you enter in the selection screen for that s_ame field (range) you have to write the querry as following to pick up those detaild data from the respective tables.
select field1 field2....fieldn
from table_n
into table itab
where uname = same.
please update your problem with understandable.
sekhar
‎2008 Mar 04 5:22 AM
hi thnks for ur reply,
may be this ll clear my problem
i have a this
uname ______________ " no from .... to.....
i need
uname from________ to ________
in module pool.
so what would be thw select query for this
please help me with this
anuj.
Edited by: anuj anuj on Mar 4, 2008 6:37 AM
‎2008 Mar 04 5:54 AM
Hi anuj,
Think u need a select-options in ur module pool..is that right,
if it is so,
chk this out...
You can define your own selection screen using statements 'SELECTION-SCREEN BEGIN OF SCREEN...' and 'SELECTION-SCREEN END OF SCREEN...' like this:
Code:
TABLES: sflight.
SELECTION-SCREEN BEGIN OF SCREEN 200 TITLE title.
PARAMETERS p_carrid TYPE sflight-carrid.
SELECT-OPTIONS: s_connid FOR sflight-connid.
SELECTION-SCREEN END OF SCREEN 200.
Call your screen with statement 'CALL SELECTION-SCREEN [number]'
Code:
title = 'My selection-screen'.
call selection-screen '200'.
The system-returncode (sy-subrc) is set on value '4' if user cancelled.
In other way: you can define your selection screen as subscreen and integrate the subsreen in your module-pool
Code:
SELECTION-SCREEN BEGIN OF SCREEN 200 AS SUBSCREEN.
PARAMETERS p_carrid TYPE sflight-carrid.
SELECT-OPTIONS: s_connid FOR sflight-connid.
SELECTION-SCREEN END OF SCREEN 200.
u can use the select query which u use for select-options in reports..
like,
selection-screen begin of block b1 with frame title text001.
select-options: begda for zemptab3-zedoj.
selection-screen end of block b1.
select * from zemptab3 into table wi_emp2 where zedoj in begda.
Hope this helps u,
Arunsri
Edited by: Arunsri on Mar 4, 2008 6:55 AM
‎2008 Mar 04 6:14 AM
hi
yes i need select-option.
but.
as mention above i need to change
uname ________
to
uname from______ to _____
so i have to change the
where condition also in the select query also
as i can not put same dataelement.
plz help me with the same
anuj
‎2008 Mar 04 6:24 AM
Hi,
create two I/O fields in screen painter like sel-options....
let first field be UNAME_LOW and second be UNAME_HIGH.....
now define a range...
RANGES uname for usr01-bname.
uname-sign = 'I'.
uname-option = 'BT'.
uname-low = UNAME_LOW.
uname-high = UNAME_HIGH.
append uname.and in ur query use it like sel-options
select............where name IN UNAME......
Cheers,
jose.
Edited by: Jose on Mar 4, 2008 7:25 AM
‎2008 Mar 05 5:23 AM
probelm is answers by others
but thanks all for all your help
anuj
Edited by: anuj anuj on Mar 5, 2008 6:35 AM