Archived discussions are read-only. Learn more about SAP Q&A

Duplicate records

Hi

I have written one query like follow, but some records are duplicating please let me know what is problem

SELECT catsdb~pernr

pa0001~ename

t001p~btext

t528t~plstx

  • t542t~atx

catsdb~raufnr

aufk~kdauf

afih~qmnum

vbak~vkbur

t003p~txt

aufk~ernam

aufk~auart

catsdb~catshours

t554t~atext

catsdb~workdate

catsdb~status

catsdb~lstar

  • catsdb~lstnr

catsdb~raufnr

catsdb~werks

catsdb~autyp

catsdb~awart

catsdb~lgart

t503t~ptext

catsdb~skostl

catsdb~rkostl

aufk~objnr

catsdb~laeda

catsdb~laetm

catsdb~aenam

catsdb~apdat

catsdb~apnam

crtx~ktext_up

t528t~plans

t503t~persk

INTO CORRESPONDING FIELDS OF TABLE i_output

FROM catsdb

INNER JOIN pa0001 ON catsdbpernr EQ pa0001pernr AND

pa0001~endda GT sy-datum

INNER JOIN aufk ON catsdbraufnr EQ aufkaufnr

INNER JOIN afih ON afihaufnr EQ aufkaufnr

LEFT JOIN crtx ON crtxobjid EQ afihgewrk AND

crtxobjty EQ afihpm_objty AND

crtx~spras EQ sy-langu

LEFT JOIN vbak ON vbakvbeln EQ aufkkdauf

LEFT JOIN t001p ON t001pwerks EQ pa0001werks AND

t001pbtrtl EQ pa0001btrtl

LEFT JOIN t528t ON t528tplans EQ pa0001plans AND

t528t~sprsl EQ sy-langu AND

t528t~otype EQ 'S'

LEFT JOIN t554t ON t554tawart EQ catsdblgart AND

t554t~sprsl EQ sy-langu

  • LEFT JOIN t542t ON t542tansvh EQ pa0001ansvh AND

  • t542t~spras EQ 'EN'

LEFT JOIN t003p ON t003pauart EQ aufkauart AND

t003p~spras EQ sy-langu

LEFT JOIN t503t ON t503tpersk EQ pa0001persk AND

t503t~sprsl EQ sy-langu

WHERE catsdb~workdate IN s_workdt AND

pa0001~werks EQ p_werks

ORDER BY catsdbpernr catsdbraufnr.

Regards

Sebastian John

Not what you were looking for? View more on this topic or Ask a question