How to see Active customers that are having atleast one Sales Order?

[Former Member]

Dear Friends,

How can we see all active customers in the system, means customers those are having atleast one sales order.

How to see

[Former Member · Accepted solution]

Go to Tcode MCTE (standard analysis for sales organization), specify the sales organization and analysis period, Execute.

Highlight incoming orders and press pushbutton "switch drilldown", from the popup window select sold to party.

[Former Member]

Hi Raghu,

As per your requirement you also can check the table VBAK.

In that table you can see the sales document number alongwith sold-to-party number.

In this table you can also see the document date on which that has been created.You can also check in last one year or six months how many order has been placed by a customer

Regards

San

[Lakshmipathi]

Dear Raghu Ram

There are many ways to see all active customers.

- run T.Code VA05 or VA05N

- run T.Code MCTE

- run T.Code MC+E

- run T.code MC(A

- run T.Code MCTA

- run T.Code MC(I

- run T.Code MC+2

thanks

G. Lakshmipathi

[Jelena]

It depends on which role this customer might have on the sales order. If it's a Sold-to, then you can run a query by VBAK-KUNNR, otherwise VBPA table will have all other partner types (use POSNR = 000000 to see only the header-level partners). Most likely there will be a lot of records. You might want to run the query in batches or limit the selection. Then download the results to Excel and there you can delete the duplicates and get a list of the unique customer numbers.

MCTE will help only if the corresponding info structure (S003) is being updated correctly. Also it has only sold-to customers.