Skip to Content
0
Former Member
Jan 11, 2008 at 07:20 AM

I want to retrive data from KNVP table but it shows records in miss order.

269 Views

Hello all,

I have written following query.

SELECT KPKUNNR KPKUNN2

INTO corresponding fields of table I_KUNZJ

FROM KNVP AS KP

WHERE KP~PARVW = 'ZJ'

AND KP~KUNN2 = 'C0100' .

KNVP table having following customers for my condition:-

Kunnr

100510

1150010

1166835

But it shows records in following order:-

Kunnr

1150010

100510

1166835

So it shows 1st record = 1150010 instead of 100510. I want to show 1st record as 100510. Can any one please tell me why it shows such miss order.