Validation

[Former Member]

Hi guys,

I am new to ABAP.

I need to validate one of my statement, according to it if customer type is 'PY then check Customer id against Knvp-kunn2 where knvp-parvw= AB.

and for this I have written this code:

if it_tab-custty = 'PY'.

it_tabcustid = knvp-kunn2

where knvp-parvw = 'AB'.

endif.

But its giving me some error. Can you help me out.

Thanks

Rajeev Gupta

[uwe_schieferstein]

Hello Rajeev

Based on your description I assume that you have to do a select on table KNVP. Then you could use the following coding:

  IF ( it_tab-custty = 'PY' ).
    SELECT * FROM knvp INTO ls_knvp
      WHERE ( kunn2 = it_tab-custid    AND
              parvw = 'AB' ).
      EXIT.
    ENDSELECT.

    IF ( syst-subrc = 0 ).
"    at least single entry found in DB table that matches condition
"    ...do something

    ELSE.
"    no entry found
    ENDIF.

  ELSE.
...
  ENDIF.

Regards

Uwe

[Former Member]

The Where clause is only used in SQL statements, like a select, update, or delete. You will have to first select the data from KNVP.

IF it_tab-custty = 'PY'.

SELECT * FROM knvp WHERE kunn2 = it_tabcustid AND parvw = 'AB'.

ENDIF.

[Former Member]

Kevin,

Just a correction for freshers in abap.

where clause is not only used in SQL.

you can also use in other places like 'read' , 'loop at itab'... etc.

Thanks,

Pankaj

[Former Member]

Yes, "where" can be used in some other places like a loop statement. However, if you are doing a read statement you have to use "with key..."

[Former Member]

If you already selected from KNVP and those values are available to you.

if it_tab-custty = 'PY' and

it_tabcustid = knvp-kunn2 and

knvp-parvw = 'AB'.

endif.

If don't have KNVP record already then do this

if it_tab-custty = 'PY'.

select * from knvp up to 1 rows where kunn2 = it_tabcustid and knvp-parvw = 'AB'.

endselect.

check sy-subrc = 0.

endif.