Left outer join

[Former Member]

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

[JozsefSzikszai]

hi Carlos,

can you copy your code here?

thanks

ec

[Former Member]

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

[Former Member]

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

Thanks in advance

Regards

[JozsefSzikszai]

first I would check the value of s_matkl during runtime.

[Former Member]

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