about Join

Former Member — Tue, 19 Aug 2008 09:30:22 GMT

hi all ,I have this code:

SELECT afko_{aufnr afko}gltrp afko_{gstrp aufk}objnr afpo_{amein afpo}dauat afpo_{dwerk afpo}matnr afpo~psmng

afpo_{wemng resb}bdmng resb_{meins mara}prdha makt_{maktx marc}zzprtnd

INTO TABLE int_tab

FROM ( afko

INNER JOIN aufk

ON aufk_{aufnr = afko}aufnr

INNER JOIN afpo

ON afpo_{aufnr = afko}aufnr

INNER JOIN resb

ON resb_{aufnr = afpo}aufnr

INNER JOIN mara

ON mara_{matnr = afpo}matnr

INNER JOIN makt

ON makt_{matnr = afpo}matnr

INNER JOIN marc

ON marc_{matnr = afpo}matnr )

WHERE afko~gstrp = '20080801'

AND afpo~dauat = 'ZP01'

AND afpo~dwerk = '4801'.

why there are same records for the same afko~aufnr ?

for example, the afko~aufnr = 1000301

there is only 1 record in afpo when aufnr 1000301

and only 1 record in resb when 1000301.

this is the code from the query, so I can't modify the code to delete the duplicate record. maybe I should modify the table join, but how should I do?

Re: about Join

ThomasZloch — Tue, 19 Aug 2008 13:21:09 GMT

You should add MAKT_{SPRAS = SY-LANGU and MARC}WERKS = AFPO~DWERK to the ON-conditions.

Even after that, the join on RESB is problematic, since no index is used and any number of RESB entries with a matching AUFNR could be returned.

Thomas

topic about Join in Application Development and Automation Discussions

about Join

Re: about Join