Output condition record

[Former Member]

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

[Former Member · Accepted solution]

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

[ralph-michael_rummel · Accepted solution]

Hi Karthik, I spent quite a long time searching for that link ... Thanks a lot for sharing that very useful information!

[Former Member]

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.

[Former Member]

Using Simple mail medium in output condition record we can go in to the communication tab and enter the recipent id which is getting stored in the ADR6 table . Buth linking the condition table or NACH to ADR6 could not be located. Our issue is to fetch the email id from ADR6 table.

[Former Member]

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.

[former_member217082]

Hi Sriram

Apart from NACH table , kindly check in NAST table also

Regards

Srinath