Skip to Content
0
Former Member
Aug 29, 2006 at 01:53 PM

getting duplicate from a select statement.

175 Views

SELECT DISTINCT AFKOAUFNR AFKOPLNBEZ AFKOGAMNG AFKOGLTRP

MARABISMT VBAKAUDAT VBAP~KWMENG

VBEP~MBDAT

INTO CORRESPONDING FIELDS OF ITAB

FROM AFKO

INNER JOIN MARA ON MARAMATNR = AFKOPLNBEZ

INNER JOIN VBAP ON VBAPMATNR = MARAMATNR

INNER JOIN VBAK ON VBAKVBELN = VBAPVBELN

INNER JOIN VBEP ON VBEPVBELN = VBAPVBELN

INNER JOIN VBUK ON VBUKVBELN = VBAPVBELN

  • WHERE AFKOAUFNR IN S_AUFNR and tmp_date = VBAKAUDAT.

WHERE AFKOAUFNR IN S_AUFNR and AFKOGLTRP = VBAK~AUDAT

AND VBAKAUDAT >= AFKOAUFNR

AND VBUK~GBSTK = 'B'.

getting duplicate records how can i distinct it