Skip to Content
avatar image
Former Member

Regarding Validations

hi

I have little bit doubt about validations.how to validate selection-screen variables .

means shall we prefer select up to 1 row statement or any other method

thanks & Regrds

sandhya

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

6 Answers

  • Best Answer
    avatar image
    Former Member
    May 09, 2006 at 12:12 PM

    Hi,

    If you look at any SAP transaction having select-options, it will further proceed with execution even if one value within the range of select option is valid. So the error message not being thrown is right way to go.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    May 09, 2006 at 11:22 AM

    select single is preferred over select upto 1 rows due to performance improvement of former over the latter.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    May 09, 2006 at 11:22 AM

    hi

    u can also use

    select single matnr from mara into v_matnr

    where matnr in s_matnr.

    s_matnr: select options for matnr.

    thanks,

    priya.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    May 09, 2006 at 11:22 AM

    u can validate them on check tables

    for that u can use select single or select up to 1 rows

    Add comment
    10|10000 characters needed characters exceeded

  • May 09, 2006 at 11:40 AM

    hi

    it all depends on your requirement.say if you need more than one record then you can use SELECT field1 fiel2 INTO TABLE itab WHERE field3 = p_field3.

    if you need single record then you can use either SELECT UP TO 1 ROWS etc..

    Cheers,

    Abdul

    Close the thread if ur question has been answered...

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    May 09, 2006 at 11:49 AM

    Hai Sandhya

    Check the following Document

    use instead of select up to 1 row Select Single Statement

    That will increase your Performence also

    Thanks & regards

    Sreenivasulu P

    Add comment
    10|10000 characters needed characters exceeded