Skip to Content
0
Former Member
May 08, 2013 at 11:09 PM

Select Distinct not work.

636 Views

hi Friends i go to se16n and see my Ztable ZGT_MICROPTO definition (and data):

CODIGO

VERSION

COMPONENTE

DESCRIPCION

ALTA

BAJA

BORRADO

P001 1 FI002 PRUEBA 1 08.05.2013

P002 1 FI017 PRUEBA 2 08.05.2013

P003 1 FI002 PRUEBA 3 08.05.2013

P004 1 FI001 PRUEBA 4 08.05.2013

P005 1 FI001 PRUEBA 5 08.05.2013

P005 1 FI002 PRUEBA 5 08.05.2013

P006 1 FI001 PRUEBA 6 08.05.2013

P007 1 FI004 PRUEBA 7 08.05.2013

P007 1 FI015 PRUEBA 7 08.05.2013

P007 1 FI016 PRUEBA 7 08.05.2013

P008 1 FI001 PRUEBA 8 08.05.2013

P009 1 FI001 PRUEBA 9 08.05.2013

i am interested in get only the Distinct values of the table.

i try:

SELECT DISTINCT CODIGO VERSION COMPONENTE DESCRIPCION ALTA BAJA BORRADO INTO CORRESPONDING FIELDS OF TABLE GT_MICROPTO FROM ZGT_MICROPTO.

but continue getting all the records(sames as the table).

Exist a way for get ONLY the distinct values of a Ztable?

Thanks

Chihuahua, Mexico.

Moderator Message - Read the ABAP online documentation or the F1 help before posting your query.

Message was edited by: Suhas Saha