New Customers

[Former Member]

Hi

Is it possible to generate a report based on the new business procured and new customers month wise?

Please elaborate as how to achieve this in sap?

Is there any standard process

regards

Edited by: rithvika on Dec 17, 2008 11:01 AM

Edited by: rithvika on Dec 17, 2008 12:42 PM

[Former Member]

Hi,

In KNVV you can find KNVV-ERDAT which shows when the customer is created.

In VBRP-ERDAT you can find the sales transaction date or if you want the posting date VBRK-FKDAT

Selection screen will have customer created date range and sales transaction happened date range.

Once you execute the report based on customer created date, customers will be selected. For those customers from VBRK & VBRP sales transaction is selected with considering the sales transaction date which is given in selection screen.

Now the report will show new business happened for the new customer of our company.

Regards

Mani

[Lakshmipathi]

Dear Rithvika

On your first question, yes it is quite possible to capture the new business procured (both in terms of customer and material) through a query.

To answer your second question as how to achieve this, consider Tables KNA1 and VBRP in a query with "From-To" date range. The logic should be the report should generate sales details only if the sales happened during the period specified.

That is if you are giving one year period in the query and once you execute the report, system should generate sales report only for that period and if any sales has happened in the previous year, then it should not consider that customer or material.

thanks

G. Lakshmipathi

[Former Member]

Hi,

Use this report S_ALR_87012186.

Click on dynamic selections(Shift+F4). Expand the customer master tree.

double click on created on field. click on multiple section. enter date range 11/17/2008 to 12/17/2008 ( customers created) in select ranges field.execute.

Execute the report.

System will show sales, customers who are created during above range.

Regards,

Chandra

[Former Member]

Hi Rithvika,

You can try VC/1 Transaction code or use table KNA1 and create query with help of ABAP er.

Another option would be go to T code MCTA and give only period i.e the month you want to get the new customers and execue.

Thanks!

Preethi

Edited by: preethi R on Dec 17, 2008 10:16 AM

[Former Member]

Hi

Is it possible to create a report on the basis of new customers created month wise

regards

[Former Member]

You can query that directly from table KNA1 by customer creation date in SE16 or create a query in SQ01, for example.