topic Re: database table in Application Development and Automation Discussions

database table

Former Member — Wed, 13 Dec 2006 19:09:08 GMT

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.

Re: database table

Former Member — Wed, 13 Dec 2006 19:12:14 GMT

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

Re: database table

Former Member — Wed, 13 Dec 2006 19:13:29 GMT

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

Re: database table

RichHeilman — Wed, 13 Dec 2006 19:13:36 GMT

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

Re: database table

Former Member — Wed, 13 Dec 2006 19:18:04 GMT

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.

Re: database table

Former Member — Wed, 13 Dec 2006 19:20:24 GMT

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

Re: database table

ferry_lianto — Wed, 13 Dec 2006 19:24:08 GMT

Hi Madhu,

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

Regards,

Ferry Lianto