We are on EHP8 ECC -Closed customers table

[former_member188080]

We are on EHP8 ECC Oracle version and we wanted to know if there is any table in ECC which can help us in finding out the customers which are already closed? Kindly share your pointers.

[sez41]

Please use the correct SAP terminology, as closed customers really do not ring any bells at all. Is it possible that you are talking about blocked customers, or customers with deletion indicators? You can find relevant information from tables KNA1, KNB1, KNVV, etc.

[former_member188080]

Yes you are right we are trying to find out customers which are discontinued for eg.Some customers are discontinued but still we can find their date in the table as 31.12.9999

Still we will review above tables and see if there is any deletion indicator is included.

Thanks and regards

Kiran

[Jelena]

"Discontinued" is not an SAP term either.

There is deletion indicator, there is "blocked for posting", there could be accounts that simply had no activity for a long time. Define the requirements clearly in the SAP terms and then you'll find an answer.

[Lakshmipathi]

Check OV51 transaction helps you