topic Re: smtp_addr in Application Development and Automation Discussions

smtp_addr

SHYEIKH — Wed, 07 Oct 2015 04:55:06 GMT

Hi All,

I'm a novice on ABAP programming.Is there anybody to help me to fix my issue?

The following is the my code. I just want to get the email address from xk03. But didn't get SMTP_ADDR(email) though I got the NAME1(vendor name) by the following inner join. But why I couldn't get the email/SMTP_ADDR. If anybody know the solution then please help me.

Thanks

SELECT smtp_addr smtp_srch name1 adrc~addrnumber INTO TABLE t_adrc FROM adrc
INNER JOIN adr6 ON adrc~addrnumber = adr6~addrnumber
WHERE adrc~name1 IN s_name1 AND
adrc~addrnumber IN s_adrnr.

Re: smtp_addr

Former Member — Wed, 07 Oct 2015 05:42:53 GMT

Hi,

Check at the table level if there is any value in SMTP_ADDR in ADR6.

Write the query as below.

SELECT adr6~smtp_addr adr6~smtp_srch adrc~addrnumber adrc~name1 INTO TABLE t_adrc FROM

adrc INNER JOIN adr6 ON adrc~addrnumber = adr6~addrnumber

WHERE adrc~name1 IN s_name1 AND

adrc~addrnumber IN s_adrnr.

Hope this helps.

Re: smtp_addr

RaymondGiuseppi — Wed, 07 Oct 2015 05:45:13 GMT

Did you try to replace NAME1 with MC_NAME1 (uppercase)

Regards,

Raymond

Re: smtp_addr

JL23 — Wed, 07 Oct 2015 06:06:27 GMT

I wonder about the 2 fields in the where part of the selection.

The name is very unspecific, you could even have duplicates, the address number is unique in your SAP, but from where could you even know this number.

If you know this number already then specifying the name is not needed and even can lead to the fact that you don't find a record because of a mismatch in the entered name.

If you are working with international addresses then better use the address version (field NATION) to get a single hit.

Re: smtp_addr

SHYEIKH — Wed, 07 Oct 2015 10:56:28 GMT

@Gaurav Dubey, @Raymond Giuseppi, @Jürgen L, thanks a lot to you all. In fact it was my fault, I made some errors in variable declaration. Now it fixed and working properly. Thanks again for your response.