topic question about validation in Application Development and Automation Discussions

question about validation

Former Member — Thu, 29 May 2008 16:45:24 GMT

Hi People

Sorry for posting this in general but didnt know wat category this would go in.

The question is suppose i have a select options for materila say s_matnr on the selection scree. I wanna validate it so i put a piece of validation at-sel-screen saying

SELECT SINGLE * FROM mara WHERE
  matnr IN s_matnr.
  IF sy-subrc <> 0.
   MESSAGE e000 WITH text-t06 s_matnr-low text-e01.
  ENDIF.

But wat if some one enters a multiple selection on the sel screen where the 3rd and the 4th material nos are incorrect. In that case the system is not returning any error message.

Can some one suggest me a better way??

is looping on s_matnr a good option?

Re: question about validation

Former Member — Thu, 29 May 2008 16:48:07 GMT

You are doing SELECT SINGLE *........ remove single and just say

SELECT * FROM MARA INTO TABLE LT_MATA WHERE MATNR IN S_MATNR.

IF SY-SUBRC <> 0.
  error message
ENDIF.

Re: question about validation

Former Member — Thu, 29 May 2008 16:49:17 GMT

s_matnr is a range, which in essence is a table.


check NOT s_matnr is INITIAL.
LOOP AT s_matnr.
  SELECT SINGLE * FROM mara WHERE
    matnr IN s_matnr-LOW.  " <== note change here
    IF sy-subrc  0.
     MESSAGE e000 WITH text-t06 s_matnr-low text-e01.
    ENDIF.
ENDLOOP.

Re: question about validation

Former Member — Thu, 29 May 2008 16:50:38 GMT

and just select matnr, no reason to select the whole table if there are going to be multiple materials, might take too much time

Re: question about validation

Former Member — Thu, 29 May 2008 17:21:19 GMT

Hi,

do like this.

TYPES : BEGIN OF st_ebeln,

matnr TYPE mara-matnr,

END OF st_ebeln.

data : it_matnr TYPE STANDARD TABLE OF st_ebeln.

AT SELECTION-SCREEN ON so_matnr.

PERFORM validate_matnr.

&----

*& Form validate_ebeln

&----

FORM validate_ebeln.

SELECT matnr

FROM mara

INTO TABLE it_matnr

WHERE matnr IN so_matnr.

IF sy-subrc NE 0.

MESSAGE e020(z50871msg) WITH text-014.

ENDIF.

ENDFORM.

Regards

Sandeep Reddy

Re: question about validation

Former Member — Thu, 29 May 2008 17:48:11 GMT

thanx guys