topic Re: Left outer join in Application Development and Automation Discussions

Left outer join

Former Member — Tue, 04 Dec 2007 16:03:36 GMT

When i make a left outer join into an internal table in a select, the field of the condition doesn´t get into my table, what´s my problem please, or if it is normal, how can i resolve it please?

Thanks in advance

regards

Re: Left outer join

JozsefSzikszai — Tue, 04 Dec 2007 16:09:26 GMT

hi Carlos,

can you copy your code here?

thanks

Re: Left outer join

Former Member — Tue, 04 Dec 2007 16:11:54 GMT

SELECT * INTO CORRESPONDING FIELDS OF TABLE it_mara

FROM mara as a left outer join marc as b on a_{matnr = b}matnr

WHERE matkl IN s_matkl.

And matnr is not filled in my table.

Thanks in advance.

regards

Re: Left outer join

Former Member — Tue, 04 Dec 2007 16:17:14 GMT

I think that the problem is taht there are many materials without center, is this the problem?

Thanks in advance

Regards

Re: Left outer join

JozsefSzikszai — Tue, 04 Dec 2007 16:25:03 GMT

first I would check the value of s_matkl during runtime.

Re: Left outer join

Former Member — Tue, 04 Dec 2007 16:25:56 GMT

Hi Carlos,

Make sure that the internal table field name and the database field name are same ,because INTO CORRESPONDING FIELDS will be success only both the fields are same name

Message Edited

shibu