sales order status

[Former Member]

Hello,

There is requirement from my client. client wants to shot mail to ship to party after 60 days from the date when sales order status gets completed.

Example: If on 02/27/2009 sales order status gets completed then mail should trigger after 60 days from this date (02/27/2009)

Now problem is I am not getting the Table which shows me that sales order status gets completed on particular date.

anybody has clue about this.

thanks in advance,

Naveed Ansari.

[Former Member · Accepted solution]

Hi Naveed,

You can fetch the sales order status data from DOCUMENT_FLOW_ALV_STRUC table,

Program Name - SAPMV75F and Field name - STATUS.

Thanks,

Swamy H P

[Former Member]

thanks

[former_member184555]

Hi

You have to generate a report everyday for the list of order items whose status has been changed to Completed on a specific date (60 days back to the current date. This date can be autopopulated in the selection screen. Then the mail should be sent to those in that list automatically. Please take the opinion of your Abaper on this development.

Thanks,

Ravi