database table

[Former Member]

hello friends,

I want to find out the number of unique customers in KNVV table. Is there a way in SE11 to do this.

Madhu.

[Former Member]

Hi,

I believe this cannot be done in SE11.

Instead you can write a small program to get the unique customers in KNVV.

Thanks,

Naren

[Former Member]

Hi,

There is no such provision in SE11. YOu can probably write a code to read the unique Customers or else download the data into an excel and sort excel sheet by customer. This will give you the number of unique customers.

Regards,

Vara

[RichHeilman]

Well, if these customers exist in KNVV, then they must exists also in KNA1, which in this table is the key, so you will have unique customers for every row in KNA1.

Regards,

Rich Heilman

[Former Member]

No, I am actually doing it on a custom table. Have uploaded it through excel sheet. Am doing some validations on a field, comparing with excel. Hence want to find the unique data in that field.

Thanks for the answers.

Madhu.

[Former Member]

Hi ,

Try this SE16 >KNVV>Display all records of the table . now goto settings>listformat>choose fields , deselct all fields other than KUNNR , so now u have only Customer being displayed. Now goto SETTINGS->USERPARAMETERS and select the ALV Grid display radio button . so now ur display is in LAV , now sort the data on KUNNR.

Hope this helps.

Regards

Arun

[ferry_lianto]

Hi Madhu,

Perhaps you may want to use SE16N to browse table KNVV.

Regards,

Ferry Lianto