Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

Wrong e-mail address shown on ZCGC

Former Member
0 Kudos

Hi ABAP GURUS

Wrong e-mail address shown on ZCGC.

This is the query

SELECT SINGLE smtp_addr FROM adr6 INTO adr6-smtp_addr

WHERE addrnumber EQ vbpa-adrnr

AND persnumber EQ vbpa-adrnp.

SELECT SINGLE smtp_addr FROM adr6 INTO adr6-smtp_addr

WHERE addrnumber EQ vbpa-adrnr.

First select with vbpa-adrnr + vbpa-adrnp not successful because data doesn’t exist in ADR6.

Data only exist WITH vbap-adrnp (persnumber). this field dosn't exist

Second SELECT with only vbpa-adrnr gives multiple records (see above) and because of

SELECT SINGLE the first record is being read.

from this they are printing an email-id Smtp_addr which is wrong.

The e-mail address has nothing to do with the partner in the order.

Let me know the posible way to get these details please. I hope u got understood the requirment.

1 REPLY 1

Former Member
0 Kudos

Hi,

Can you be specific what needs to be done ,like what user id needs to be selected & from where.etc.

Then it will be better to answer your question.

Thanks.