topic Re: selection screen fields in Application Development and Automation Discussions

selection screen fields

Former Member — Tue, 04 Sep 2007 09:18:10 GMT

hi gurus,

i created selection screen afpo-aufnr, afko-rsnum, resb-matnr fields with select options apart from that if i select either afpo-aufnr or afko-resnum for this i have to validate that selection fields plz sen the logic how to validate that

Re: selection screen fields

Former Member — Tue, 04 Sep 2007 09:21:04 GMT

hi,

if afpo-aufnr is not initial

then validate afpo-aufnr

endif.

if afko-resnum is not initial

validate afko-resnum

endif.

Thanks,

Praveena

Re: selection screen fields

Former Member — Tue, 04 Sep 2007 09:23:16 GMT

HI,

at selection screen.

select aufnr from AUFK into table itab where aufnr in s_aufnr.

if sy-subrc ne 0.

message no data found for AUFNR.

endif.

select RSNUM from AFKO into table itab1 where RSNUM in s_rsnum.

if sy-subrc ne 0.

message no data found for RSNUM .

endif.

you can also use

at selection screnn on s_aufnr-low.

at selection screnn on s_aufnr-high.

at selection screnn on s_rsnum-low.

at selection screnn on s_rsnum-high.

thanks & regards,

Venkatesh

Re: selection screen fields

Former Member — Tue, 04 Sep 2007 09:25:08 GMT

Hi,

Suppose you want to validate afpo-aufnr field then write as follows

supose you have a selct options SO_AUFNR for afpo-aufnr . then

data v_aufnr type afpo-aufnr.

SELECT SINGLE aufnr

FROM afpo

where aufnr IN so_aufnr.

IF SY-SUBRC NE 0.

Message E()....Raise error message whch u r using in Program.

ENDIF.

In the same way you can validate other fields

Kindly Reward Points for Helpfill Answers

Regards

Tanweer

Re: selection screen fields

Former Member — Tue, 04 Sep 2007 09:26:16 GMT

Hi,

let say you have

select-options: s_aufnr for afpo-aufnr,

s_rsnum for afko-rsnum.

you can write:

at selection-screen on s_aufnr.

If s-aufnr[] is not initial.

data : lv_aufnr type aufnr.

here we are using select single because AUFNR is the only primary key in its **value table AUFK

select single sufnr from aufk into lv_aufnr where aufnr in s_aufnr.

If sy-subrc <> 0.

**Message " Error message here " please enter valid order number

endif.

at selection-screen on s_rsnum.

If s_rsnum[] is not initial.

data : lv_rsnum type rsnum.

here we are using select upto 1 rows because rsnum is a part of primary key in **its value table RESB.

select rsnum into lv_rsnum

from resb

up to 1 rows where rsnum in s_rsnum.

endselect.

if sy-subrc <> 0.

error message..

endif.

rewards if useful,

regards,

nazeer

Re: selection screen fields

Former Member — Tue, 04 Sep 2007 09:27:17 GMT

AT SELECTION SCREEN ON s_aufnr

if s_aufnr[] IS NOT INOTIAL. " Select option for afpo-aufnr

VALIDATE AUFNR

SElect single aufnr from AUFK into v_aufnr where

aufnr in s_aufnr.

if sy-subrc ne 0.

Display error message

endif.

Similary validate others

Regards,

Taranam

Re: selection screen fields

Former Member — Tue, 04 Sep 2007 09:27:38 GMT

Hi babu,

Find the code below it will help you out.. even if your problem not solved .. feel free to contact me.

Reward points if it useful. Which boost us help others.

*&---------------------------------------------------------------------*
*& Report  YPRG33
*&
*&---------------------------------------------------------------------*
*&
*&
*&---------------------------------------------------------------------*

REPORT  YPRG33.

tables : afpo, afko, resb.

select-options : so_aufnr for afpo-aufnr,
                 so_rsnum for afko-rsnum,
                 so_matnr for resb-matnr .
                 
at selection-screen on so_aufnr.
*................
*.. statements over here
*...............

at selection-screen on so_rsnum.
*................
*..statements over here
*...............

Re: selection screen fields

Former Member — Tue, 04 Sep 2007 09:29:03 GMT

Hi babu,

Find the code below it will help you out.. even if your problem not solved .. feel free to contact me.

Reward points if it useful. Which boost us help others.

*&---------------------------------------------------------------------*
*& Report  YPRG33
*&
*&---------------------------------------------------------------------*
*&
*&
*&---------------------------------------------------------------------*

REPORT  YPRG33.

tables : afpo, afko, resb.

select-options : so_aufnr for afpo-aufnr,
                 so_rsnum for afko-rsnum,
                 so_matnr for resb-matnr .
                 
at selection-screen on so_aufnr.
*................
*.. statements over here
*...............

at selection-screen on so_rsnum.
*................
*..statements over here
*...............

regards

sharma

Re: selection screen fields

Former Member — Tue, 04 Sep 2007 09:31:00 GMT

You can do this under "AT selection screen" event.

Logic goes here.

At selection -screen on afpo-aufnr-LOW.

Seelct single * from AUFK where AUFNR = afpo-aufnr-LOW.

If sy-subrc NE 0.

Raise PRoper message.

At selection -screen on afpo-aufnr-HIGH.

Seelct single * from AUFK where AUFNR = afpo-aufnr-HIGH.

If sy-subrc NE 0.

Raise PRoper message.

Same way Validate AFKO-Resnum againest table RESB table and raise proper messages.

HOpe this is helpful..

Cheers,

Jaleel

Re: selection screen fields

Former Member — Tue, 04 Sep 2007 09:59:43 GMT

HI GURUS THANX'S FOR REPLY