How to get the mail statuses when an issue output of invoice is done.

[Former Member]

Hi,

1. I want to get the mail statuses of the invoice mail sent to a customer.

2. In which table the log will be stored ?

3. How to get the link for the billing document for which the mail was sent to the customer ?

[Former Member]

Hi

1. I want to get the mail statuses of the invoice mail sent to a customer.
2. In which table the log will be stored ?
3. How to get the link for the billing document for which the mail was sent to the customer ?

What do you mean?

How do you manage the mail?

I suppose you manage it by a messages, if it's so you can have 2 different status:

- One for the message: check table NAST

- One for mail: see transaction SOST

The link is in NAST table

Max

[Former Member]

1. The Email option is set ticked in NAST, and in VF03 if you go to header HEDAER details, in Header partners tab,

you get the list of partners, and when you docuble click the partner you see a mail ID maintained for that.

--> so basically , when in VF03 initial screnn from menu when i give issue output to using an output type, and email as the print option, then as per the configuration , the mail goes to the partners email id maintained, so i want to create a report, of the statuses of all those mails. ( i know SOST, but the requiremetn is to create a report for only the billing documents numbers

and emails id of tha petners and their statuses.

[Former Member]

basically in one line i want to know:

in which table i can get the link between the billing document number, the partner and the email s

statuses of the mail sent..

as i want to create a report with the follwoing fields:

- Billing doc number | Customer Number | Customer Mail id | Status |

[madhu_vadlamani]

Hi,

Go to the table Nast and see.

Regards,

Madhu.

[Former Member]

i don't see any key field joining these two tables.

can you please tell me how to get the appropriate SOST record for the NAST racord.

[madhu_vadlamani]

Hi Srinivas,

Check like this

SOST ENTRY_DATE + ENTRY_TIME = NAST-ERDAT + NAST-ERUHR.Check the table once SOOD.If you have any issue in this tell me i will keep the code.

Regards,

Madhu.

[Former Member]

Thanks a lot for the above informaiton it is very usefull, but I have one doubt with this, wont there be any delay in the time stamp between NAST ans SOST becasue, during updation there can be delay and the because of that the key changes .

[Former Member]

Hi

If you have created the message see the NAST:

NAST-KAPPL = 'V3'.

NAST-OBJKY = VBRK-VBELN.

NAST-KSCHL = <message code>.

NAST-PARNR = <customer code for the mail>

NAST-VSTAT = <status code>.

If the message is elaborated, you should see a record in SOOS table

Max

[Former Member]

Can you please expand that..what is this SOOS?