Skip to Content
author's profile photo Former Member
Former Member

Is there a way to report on Prospects being changed to a Sold-to

I need a way to report on when a Prospect is changed to a Sold-to . . . is there something available on SAP?

Our Finance group uses transaction OV50 to see when our Sales Group has created a Sold-to, so they can create the Finance views. They check by Account Group and Date. The problem is when a Prospect is changed it retains it's original date, so it's created on date is say 01/01/2000, and the change to a Sold-to is 9/9/09 . . . The report would have to be run wide open to see this is new. They seem to have alot of customer masters they do not maintain. So, is there a table where the changed date is stored, that I can report on. I tried using OV51 the run time is very long. Any ideas?

Thanks,

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

3 Answers

  • Posted on Sep 14, 2009 at 10:52 AM

    Hi

    What do you mean by " A prospect is changed to Sold To.."

    If you are talking about maintaining the Customer Sales View data on a later date, when you actually created the Customer by using the transaction FD01, then you can check the table KNVV, there it will show you when you have created the data for Sales Area or Sales Data.

    And if your querry is something else, then pl. explain it in detail.

    Thanks and regards

    Amitesh Anand

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Sep 15, 2009 at 12:08 PM

    We create Sales Prospects, Acct Group 0005. They are created with minimal data. When the Prospects becomes a customer, we will convert to a Sold-to, Acct Group 001, by using transaction XD07. Sales will do this so there is only the Sales "owned" views . . . like if they were to create thru VD01. This means there are no Company Code views, XD01. So I am looking for a report that will let Finance know when this conversion takes place so they can maintain their views, as well as the Credit Managment Master. Today when Acct Group 0001 is created they run transaction OV50 to see what was recently created . . . daily or weekly they may run the report. The problem with the Sales Prospect conversation, the created on date is in the past, so since they are either putting in a day or weekly date range, they never know when it was converted. OV50 does have a changed on. OV51 does, but has a significant run time, just for a day. Any ideas? Or any ideas where this data is stored, so a possible query could be done?

    Add a comment
    10|10000 characters needed characters exceeded

    • Hi

      You can track the change of Account Group with date and time in table CDHDR.

      Check this table in transaction SE16. Enter your Cutomer Code in OBJECT VALUE (exactly of 10 digit, if require add 0 as prefix) and XD07 in transaction --> Execute. It will show you the details.

      Hope this will help you.

      Regards

      Amitesh Anand

  • author's profile photo Former Member
    Former Member
    Posted on Sep 16, 2009 at 03:24 PM

    Yes this helps. This table as well as OV51 have such a long run time.

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.