topic Re: ABAP Coding issue in Application Development and Automation Discussions

ABAP Coding issue

Former Member — Tue, 27 Oct 2009 03:15:23 GMT

Hi Abapers,

I am new to ABAP, I am in the process of learning.

I want to do

IF KNVK-PAFKT = Z1

 select single smtp_addr FROM adr6 INTO v_smtp_addr
                          WHERE ADDRNUMBER =   v_adrnr.
Endif.

But i am able to get the EMail without IF condition, waht else I need to do if I want to fulfil the IF condition.

Thanks in Advance,

Rishik.

Re: ABAP Coding issue

SujeetMishra — Tue, 27 Oct 2009 03:19:14 GMT

Hello Rishik,

Please do like below :

IF KNVK-PAFKT = 'Z1'.

select single smtp_addr FROM adr6 INTO v_smtp_addr

WHERE ADDRNUMBER = v_adrnr.

Endif.

Regards,

Sujeet

Re: ABAP Coding issue

I355602 — Tue, 27 Oct 2009 03:25:23 GMT

Hi,

Always check the values using quotes:-


IF KNVK-PAFKT = 'Z1'. "<--refer this
 select single smtp_addr FROM adr6 INTO v_smtp_addr
                          WHERE ADDRNUMBER =   v_adrnr.
Endif.

Hope this helps you.

Regards,

Tarun

Re: ABAP Coding issue

Former Member — Tue, 27 Oct 2009 03:32:16 GMT

I did like that but I forgot put it in the post. I don't have any syntax errors, but these are picking from different tables

i.e KNVK and ADR6

do I need to do the select single for KNVK-PAFKT?

Thanks,

Rishik.

Edited by: Rishik on Oct 27, 2009 4:33 AM

Re: ABAP Coding issue

Former Member — Tue, 27 Oct 2009 03:37:01 GMT

you need to select values from table knvk in a work area based on your requirement

then use wa_knvk-PAFKT in if condition

Re: ABAP Coding issue

Former Member — Tue, 27 Oct 2009 03:40:04 GMT

Hi,

Can you plz eloberate it for me.

Thanks in Advance,

Rishik.

Re: ABAP Coding issue

I355602 — Tue, 27 Oct 2009 03:43:53 GMT

Hi,

Use CLEAR statement before using SELECT


CLEAR v_smtp_addr.

IF KNVK-PAFKT = 'Z1'.
 select single smtp_addr FROM adr6 INTO v_smtp_addr
                          WHERE ADDRNUMBER =   v_adrnr.

  IF sy-subrc NE 0. "<--no record found
    CLEAR v_smtp_addr.
  ENDIF.
ENDIF.

Hope this helps you.

Regards,

Tarun

Re: ABAP Coding issue

Former Member — Tue, 27 Oct 2009 03:56:49 GMT

There would be some condition based on which you would have to fetch from KNVK table.

May be on the basis of partner number PARNR

Select single PAFKT from KNVK into v_pafkt

where PARNR = some value

now check

if v_pafkt = 'K1'.

select query

endif.