topic Re: Connect two tables in Application Development and Automation Discussions

Connect two tables

Former Member — Wed, 04 Sep 2013 12:30:49 GMT

Hi Experts,

I am new to ABAP. The dump shows that the mistake in the select statement, I checked few codes, I think it is right but still giving dump of dbif_rsql_invalid_rsql. Please guide me where I am lacking.

The requirement is that I need to get tcode field from bkpf table so I have connected it to bsak. Is the connection wrong?

select bukrs

lifnr

budat

wrbtr

belnr

shkzg

zuonr

umskz

sgtxt

gjahr

from bsak

into table it_bsak

where bukrs in s_bukrs and lifnr in s_lifnr and budat in s_date.

if not it_bsak is INITIAL.

select bukrs belnr tcode

from bkpf

INTO table it_bkpf

FOR ALL ENTRIES IN it_bsak

where bukrs = s_bukrs and belnr = it_bsak-belnr.

endif.

Regards

Mani

Re: Connect two tables

FredericGirod — Wed, 04 Sep 2013 13:44:52 GMT

Hi Mani,

in the dump, trans ST22, SAP put an arrow where the program dump. What is this line

maybe your table IT_BSAK didn't have the same number of columns ... try to replace : INTO TABLE IT_BSAK by INTO CORRESPONDING FIELDS OF TABLE IT_BSAK

regards

Fred

Re: Connect two tables

Former Member — Wed, 04 Sep 2013 13:49:42 GMT

Please, post your DUMP report. Probably your query is resulting in too much records.

Dump is occurring at the first or the second select statement?

The WHERE clause of the BKPF selection is wrong on the BUKRS field. Change the '=' to 'IN' and test it again.

Re: Connect two tables

RaymondGiuseppi — Wed, 04 Sep 2013 13:57:16 GMT

You wrote "bukrs = s_bukrs" (so type mismatch btween a field and a table of range) where you should have written "bukrs = it_bsak-bukrs", also you forgot the last key of BKPF : "and gjahr = it_bask-gjahr".

Regards,

Raymond

Re: Connect two tables

Former Member — Wed, 04 Sep 2013 14:27:13 GMT

Hi,

the mismatch is in this code:

if not it_bsak is INITIAL.

select bukrs belnr tcode

from bkpf

INTO table it_bkpf

FOR ALL ENTRIES IN it_bsak

where bukrs = s_bukrs and belnr = it_bsak-belnr.

endif.

You try with this code:

if not it_bsak[] is INITIAL.

select bukrs belnr tcode

from bkpf

INTO table it_bkpf

FOR ALL ENTRIES IN it_bsak

where bukrs IN s_bukrs

and belnr = it_bsak-belnr

and gjahr = it_bsak-gjahr.

endif.

Regards

Ivan

Re: Connect two tables

Former Member — Thu, 05 Sep 2013 03:17:08 GMT

Hi,

I appreciate your replies. Please check the following screenshot:

Please do let me know if any other screenshot is required?

Regards

Mani

Re: Connect two tables

Former Member — Thu, 05 Sep 2013 03:57:57 GMT

Hi Mani,

After corrections as suggested by the experts above, if still it doesn't solve, please check the target locations (it_bsak/it_bkpf). I recently faced this error. If the dump is coming in the first query then check the structure of it_bsak and it the dump is coming in the second query then check structure of it_bkpf.

Please check the order of the fields in the structure with the select query and the data types of fields with the fields in the select query. Can you show us the structures and and the error analysis in the dump?

Regards

Purnand

Re: Connect two tables

former_member209120 — Thu, 05 Sep 2013 04:07:57 GMT

Hi Mani,

Correct like this

select bukrs

lifnr

budat

wrbtr

belnr

shkzg

zuonr

umskz

sgtxt

gjahr

from bsak

into table it_bsak

where bukrs in s_bukrs and lifnr in s_lifnr and budat in s_date.

if not it_bsak is INITIAL.

select bukrs belnr tcode

from bkpf

INTO table it_bkpf

FOR ALL ENTRIES IN it_bsak

where bukrs = s_bukrs

where bukrs in s_bukrs

and belnr = it_bsak-belnr.

endif.

Re: Connect two tables

sivaganesh_krishnan — Thu, 05 Sep 2013 04:11:07 GMT

HI mani,

You have to change the '=' sign with IN in the second select statement. and also you have to add extra where claues in that statement , as the table bkpf also has the primary key gjahr so you have to add it.

SELECT bukrs belnr tcode

FROM bseg
INTO TABLE it_bkpf

FOR ALL ENTRIES IN it_bsak
WHERE bukrs IN s_bukrsAND

belnr EQ it_bkpf-belnr AND

gjahr EQ it_bkpf-gjahr.

Regards,

Sivaganesh

Re: Connect two tables

Former Member — Thu, 05 Sep 2013 06:44:18 GMT

Hi mani,

Replace : INTO TABLE IT_BSAK by INTO CORRESPONDING FIELDS OF TABLE IT_BSAK in the first select query

and sort the table it_bsak

replace in second select query

INTO table it_bkpf by INTO CORRESPONDING FIELDS OF TABLE it_bkpf.

write like below

select bukrs

lifnr

budat

wrbtr

belnr

shkzg

zuonr

umskz

sgtxt

gjahr

from bsak

into corresponing fields of table it_bsak

where bukrs in s_bukrs and lifnr in s_lifnr and budat in s_date.

if not it_bsak is INITIAL.

sort it_bsak by bukrs.

select bukrs belnr tcode

from bkpf

INTO corresponing fields of table it_bkpf

FOR ALL ENTRIES IN it_bsak

where bukrs IN s_bukrs and belnr = it_bsak-belnr and gjahr = it_bsak-gjhar.

endif.

Re: Connect two tables

Former Member — Thu, 05 Sep 2013 07:05:21 GMT

Thank you experts. I had written belnr type belnr instead of belnr type belnr_d. But there were one more mistake that I had written bukrs = s_bukrs instead of bukrs in s_bukrs.

I would like to thank all the experts above for taking time to read, understand and answer my query. I am very happy. This is a great website.

Cheers

Mani

Re: Connect two tables

Former Member — Thu, 05 Sep 2013 07:09:12 GMT

hi,

check the structure of the target field and also check the order of selected fields....

sharmistha

Re: Connect two tables

Former Member — Thu, 05 Sep 2013 07:19:48 GMT

This message was moderated.

Re: Connect two tables

RaymondGiuseppi — Thu, 05 Sep 2013 08:43:29 GMT

Also :

Add gjahr to your type ty_bkpf as well as in the SELECT FROM BKPF statement, and sort criteria (SORT statement or definition TYPE SORTED TABLE) to get the correct document header.
Read BKPF with it_bsak-bukrs and not use the IN s_bukrs. (even if result will be correct if READ TABLE use a correct bukrs, you may read unecessary records in BKPF)

Regards,

Raymond

Re: Connect two tables

Former Member — Thu, 05 Sep 2013 11:18:22 GMT

Hi Raymond,

Added both the points. I am sure the select query is more strong now.

Thanking you

Mani

Re: Connect two tables

Former Member — Thu, 05 Sep 2013 11:38:30 GMT

Hi Mani,

Please check carefully before posting thread in SCN. Since SAP is having 45 years of history almost all the solutions are available for the Queries.

You missed the basic thing that instead of using IN Operator you used = for S_BUKRS. so be cautious.

Welcome to SCN.

Thanks

Pavan.N