Getting Dump while using inner join

[Former Member]

Hi All,

I am selecting 20 fields from 2 different database table using inner join. While executing the report getting dump.

The purpose of using inner join is that in selection screen I have few fields from two different database table.

Any suggestion how I can go ahead for the same.

[Former Member]

It will be helpful if you can post your code.

Regards,

Mohaiyuddin

[Sm1tje]

this is normally caused by the fact that your internal table does not match the selected fields from the tables from the joins.

But better post the code first.

[Former Member]

Hi Poonan

You can use select for all entries .

Select <Fields> from <dbtab1>

into table itab

Where condition.

If sy-subrc eq 0.

Select <Fields> from <dbtab2>

into table itab2

for all entries in itab

where A = itab-A

and so on.

endif.

Regards

Neha

[Former Member]

Post ur innerhjoin query

[Former Member]

Hi,

I think you are joining cluster (or) pooled tables. you can post your code.

Regards,

Suresh.

[Former Member]

Hi Poonam

This happens either the fields of itab and the order or fields in the select query doen't match or

the data types you mentioned in the declaration of itab doesn't accomodate the values fetched from the select query.

if possible please let us know what is the dump you are getting

Regards

Ramchander Rao.K

[Former Member]

this is the way of writing innerjoin

SELECT a_{vbeln a}auart a_{ernam a}erdat a_{vkorg a}vtweg a_{spart a}kunnr a_{lifsk a}netwr

INTO CORRESPONDING FIELDS OF TABLE it_vbak

FROM vbak AS a

INNER JOIN vbuk AS b ON a_{vbeln EQ b}vbeln

WHERE a~vbeln IN s_vbeln

AND a~erdat IN s_erdat

AND a~kunnr IN s_kunnr

AND a~vkorg IN s_vkorg

AND a~ernam IN s_nam_so

AND a~auart IN s_auart

AND a~vtweg IN s_vtweg

AND a~spart IN s_spart

AND b~cmgst EQ c_credit_stat.

Regards,

Ajay

[Former Member]

Hello Poonam,

Kindly post your code, until then, I'm afraid, no one will be able to help you.

regards,

Advait