topic Re: Getting Dump while using inner join in Application Development and Automation Discussions

Getting Dump while using inner join

Former Member — Mon, 01 Dec 2008 09:03:21 GMT

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.

Re: Getting Dump while using inner join

Former Member — Mon, 01 Dec 2008 09:05:07 GMT

It will be helpful if you can post your code.

Regards,

Mohaiyuddin

Re: Getting Dump while using inner join

Sm1tje — Mon, 01 Dec 2008 09:06:33 GMT

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.

Re: Getting Dump while using inner join

Former Member — Mon, 01 Dec 2008 09:07:09 GMT

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

Re: Getting Dump while using inner join

Former Member — Mon, 01 Dec 2008 09:08:54 GMT

Post ur innerhjoin query

Re: Getting Dump while using inner join

Former Member — Mon, 01 Dec 2008 09:09:12 GMT

Hi,

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

Regards,

Suresh.

Re: Getting Dump while using inner join

Former Member — Mon, 01 Dec 2008 09:09:34 GMT

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

Re: Getting Dump while using inner join

Former Member — Mon, 01 Dec 2008 09:10:11 GMT

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

Re: Getting Dump while using inner join

Former Member — Mon, 01 Dec 2008 09:13:20 GMT

Hello Poonam,

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

regards,

Advait