on 02-12-2009 4:52 PM
Hi Guys
I am sending RD00 o/p thro concept of simple mail(7). i have created a condtion record where i stored the email id to send the Output. Now for some development i need the link between my condition table ( ex.B950) and the email table. VV31 creates condition record no. in condition table which will be linked to a NACH table for condtion record's detailed information. But the email id is storing in different table which is ADR6 but i am unable to get the link between B950->Nach-> ADR6. Please let me know if u know the link.
Finally i need to fetch the email id which is given in the condtion record.
Thanks
Sriram
Hi,
The link between NACH and ADR6 is as explained below:
NACH-TDNAME is a concatenated string.
Corresponding Recipient information can be found in SOMG table using the NACH-TDNAME broken to fill the following SOMG fields.
Fields - FOLTP, FOLYR, FOLNO, DOCTP, DOCYR, DOCNO
Eg Values - FOL 18 4 SCR 38 0000029
The recipient information is actually stored as the Sender type, year and Number.
If the SOMG-RCP_ID_TP (Sender type) is USR - it refers to an internal SAP user, detail of which can be found from SOUI table
If the SOMG-RCP_ID_TP is not USR, then the recipient can not be found in SOUI. In such case, take the value of SOMG-RCP_ID_NO (sender number) leaving the first 2 characters. Search Table ADCP with this value as SO Key.
The ADCP address number and Person number will be the keys for ADR6 - to get the mail ID.
Thanks
Karthik
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Sriram
As per your requirement:
"Finally i need to fetch the email id which is given in the condtion record."
Firstly no where we are maintianing e-mail id in condition record of output i.e.VV31.
We are only defining the PARTNER for the output type and based on that partner, output is picking up e-mail id of that partner in the Billing document.
For different billing documents there will be different customer, means different e-mail ids.
And for all these documents the "condition record no." will be same. Based on document customer e-mail ids will differ.
Hope you understood what I am trying to explain.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You can modify the driver program of the output to fetch the mail id from ADR6 of the recipient in communication tab. The logic can be developed in ABAP program to get the id from NACH-TDRECEIVER.
If the recipient is a partner function SP, SH, etc. then put that customer number in KNA1 and take the address number (KNA1-ADRNR) and that address number can be used in ADR6 (ADR6-ADDRNUMBER) to get the mail id.
Hi Sriram
Apart from NACH table , kindly check in NAST table also
Regards
Srinath
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
109 | |
15 | |
10 | |
5 | |
4 | |
3 | |
3 | |
3 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.