topic Re: Urgent:Validation in Application Development and Automation Discussions

Urgent:Validation

Former Member — Fri, 04 Apr 2008 10:05:04 GMT

Hi am entering a range of vendor while checking, it must display the particular vendor alone is invalid not the whole set of vendors which is entered .How should i declare?

Re: Urgent:Validation

Former Member — Fri, 04 Apr 2008 10:10:16 GMT

show your codings....

Re: Urgent:Validation

Former Member — Fri, 04 Apr 2008 10:10:42 GMT

SELECT single lifnr INTO wa_liifnr FROM LFA1

WHERE lifnr IN s_lifnr.

endselect.

IF SY-SUBRC <> 0.

MESSAGE TYPE 'I' WITH WA_LIFNR 'NOT FOUND.'

ENDIF.

plz reward if useful

vivek

Edited by: Vivek Gaur on Apr 4, 2008 12:11 PM

Re: Urgent:Validation

Former Member — Fri, 04 Apr 2008 10:23:12 GMT

This is my coding.

CLEAR lfb1-lifnr.

IF NOT s_lifnr[] IS INITIAL.

SELECT SINGLE lifnr INTO gw_lfb1 FROM lfb1 WHERE lifnr IN s_lifnr.

IF sy-subrc <> 0.

MESSAGE e000 WITH 'Invalid vendor'.

ENDIF.

This is applicable when i enter only one vendor how if i enter a range of vendors

Re: Urgent:Validation

Former Member — Fri, 04 Apr 2008 10:26:48 GMT

plz give ur complete codings... then only i can tell you which statement you need to change

Re: Urgent:Validation

Former Member — Fri, 04 Apr 2008 10:36:10 GMT

Hi,

if you use select single, why don't you use parameters.

Another problem is, if you use lfb1 what abaut bukrs?

Regards, Dieter

Re: Urgent:Validation

Former Member — Fri, 04 Apr 2008 10:43:05 GMT

I am a little confused. In your code, don't you want to check if sy-subrc is NOT zero, and issue an error? Maybe I just missed something. Please clarify.

CLEAR lfb1-lifnr.

IF NOT s_lifnr[] IS INITIAL.
  SELECT SINGLE lifnr INTO gw_lfb1 FROM lfb1 WHERE lifnr IN s_lifnr.
  IF sy-subrc NE 0.             " NE?
    MESSAGE e000 WITH 'Invalid vendor'.
  ENDIF.
ENDIF.

Re: Urgent:Validation

Former Member — Fri, 04 Apr 2008 10:46:02 GMT

The above is the coding for validation part.Now my requirement has changed that i have to use range of entering the vendor so if i use the above syntax if i enter the range of values if one vendor is invalid it ll show everything as invalid.This is my problem .Can u get me?

Re: Urgent:Validation

Former Member — Fri, 04 Apr 2008 10:49:38 GMT

No need of burks.Anything select-option or parameter is ok but i have used select-option

Re: Urgent:Validation

Former Member — Fri, 04 Apr 2008 10:51:25 GMT

No i didnt check that codn.Do u have any idea?

Re: Urgent:Validation

Former Member — Fri, 04 Apr 2008 10:55:51 GMT

i have got some questions

1) tell me on what basis you are considering avendor is valid or invalid

2) if you are going to give a range of vendors you should use select * and not select single.

3) if you are passing the selected records to a workarea it is ok if you select a single record, but for range of vendors make sure you passs it to an internal table

first clarify my above questions.

Re: Urgent:Validation

Former Member — Fri, 04 Apr 2008 11:23:09 GMT

Do u want this?

TABLES: lfa1.

SELECT-OPTIONS: s_lifnr FOR lfa1-lifnr.

DATA: gt_lfa1 TYPE STANDARD TABLE OF lfa1 WITH HEADER LINE,

v_lifnr TYPE lifnr.

SELECT lifnr

FROM lfa1

INTO CORRESPONDING FIELDS OF TABLE gt_lfa1

WHERE lifnr IN s_lifnr.

v_lifnr = s_lifnr-low .

if s_lifnr-high is initial.

s_lifnr-high = s_lifnr-low.

endif.

DO.

IF v_lifnr <= s_lifnr-high.

READ TABLE gt_lfa1 WITH KEY lifnr = v_lifnr.

IF sy-subrc NE 0.

WRITE: / 'Vendor', v_lifnr, 'is invalid.'.

ENDIF.

v_lifnr = v_lifnr + 1.

UNPACK v_lifnr TO v_lifnr.

ELSE.

EXIT.

ENDIF.

ENDDO.

Re: Urgent:Validation

Former Member — Fri, 04 Apr 2008 11:27:35 GMT

Instead of select-options i have to make use of ranges.How should i do it?

Re: Urgent:Validation

Former Member — Fri, 04 Apr 2008 14:23:14 GMT

Your code is helpful but when i enter a range of vendors it is not correctly pointing out the invalid vendor.Its processing the other vendors and displaying it.In my case i also need the invalid vendor number.

Re: Urgent:Validation

Former Member — Fri, 04 Apr 2008 15:22:18 GMT

Do you want all invalid vendors in a internal table ?

Re: Urgent:Validation

Former Member — Sat, 05 Apr 2008 03:46:02 GMT

ya have to validate all the vendors but still i didnt enter in internal table.How should i do?