topic Re: Check Inner join in Application Development and Automation Discussions

Check Inner join

Former Member — Thu, 17 Jul 2008 13:57:07 GMT

Can you please check below select statement because there are double records reasoning somethings . Shall I need to change order of joins ?

SELECT mara_{matnr mara}prdha marc_{maabc mara}meins

makt_{maktx marc}trame mard~labst

mbew_{stprs mbew}peinh

INTO CORRESPONDING FIELDS OF gt_mara_itab

FROM mara

INNER JOIN makt

ON makt_{matnr = mara}matnr

AND makt~spras = sy-langu

INNER JOIN marc

ON marc_{matnr = mara}matnr

INNER JOIN mard

ON mard_{matnr = mara}matnr

AND mard_{werks = marc}werks

LEFT OUTER JOIN mbew

ON mbew_{matnr = marc}matnr

AND mbew_{bwkey = marc}werks.

WHERE mara~matnr IN smal_tab

AND mara~mtart IN s_mtart

AND mara~matkl IN s_matkl

AND marc~werks IN s_pplant

AND mard~lgort NOT IN gr_lgort

AND mara~lvorm = space

AND marc~lvorm = space

AND mard~lvorm = space.

Re: Check Inner join

Former Member — Thu, 17 Jul 2008 14:13:27 GMT

It's pretty hard to say where the problem lies. As a start, try splitting up the SELECT. I'd see what happens without the JOIN on MBEW first.

Rob

Re: Check Inner join

Former Member — Thu, 17 Jul 2008 14:14:11 GMT

hi,

you'll have duplicates of material, its desceiption, but if u notice the quantity fields may not. thats because of data selection from marc and mard. jus delete the duplicates based on ur requirement. if u want unique entries at the time of selection itself, then use left outer join as u have used in the program for marc and mard. theres nothing wrong in your select.

regards,

madhu

Re: Check Inner join

Former Member — Thu, 17 Jul 2008 14:42:47 GMT

This message was moderated.