topic Re: Regarding error in inner join, in Application Development and Automation Discussions

Regarding error in inner join,

former_member242166 — Thu, 28 Jun 2012 06:50:00 GMT

Hi experts when i use the following code error occurs, Please help me for my error

The error is: For pooled tables, cluster tables, and projection views, JOIN is not allowed : BSEG

My code is:

SELECT zfi_rtgs~voucherno

zfi_rtgs~rtgsdate

zfi_rtgs~outwardno

zfi_rtgs~tbankcode

zfi_bankdetails~acntno

zfi_bankdetails~acnttyp

zfi_bankdetails~bankname

zfi_bankdetails~compname

bseg~dmbtr

INTO CORRESPONDING FIELDS OF TABLE t_data

FROM zfi_rtgs as zfi_rtgs

inner join zfi_bankdetails as zfi_bankdetails on zfi_rtgs~tbankcode = zfi_bankdetails~bankcode

inner join bseg as bseg on zfi-rtgs~voucherno = bseg~belnr

WHERE zfi_rtgs~voucherno in s_vouc01

AND zfi_rtgs~rtgsdate in s_rtgs02

AND zfi_rtgs~tbankcode in s_tban03

AND bseg~gjahr in s_gjahr.

Regards,

Linganathan.K

Moderator Message: The solution to your problem is easily searchable. Thread locked.

Message was edited by: Suhas Saha

Re: Regarding error in inner join,

Former Member — Thu, 28 Jun 2012 06:53:47 GMT

Thats right. The error is what it says. You can't put up join on BSEG table as it is a cluster table.

Re: Regarding error in inner join,

former_member242166 — Thu, 28 Jun 2012 06:55:51 GMT

Then how can i get the dmbtr field for my alv report?

Regards,

Linganathan.K

Re: Regarding error in inner join,

Former Member — Thu, 28 Jun 2012 06:56:33 GMT

Hi,

Because the bseg table is a pooled table. For pooled tables, cluster tables, and projection views, JOIN is not allowed.

Regards,

Ramya R

Re: Regarding error in inner join,

Former Member — Thu, 28 Jun 2012 06:58:23 GMT

You can fetch data, you just cant apply join.

So, create an intermediate table it_bseg.

fetch all the data in it_bseg as per your where clause.

Use For all entries clause to fetch data from your custom table.

or vice-verse, as per your requirement.

Re: Regarding error in inner join,

former_member242166 — Thu, 28 Jun 2012 06:59:24 GMT

Hi ramya,

Then , i want dmbtr field from bseg table for my ALV Report, How can i do this.

Thanks,

Linganathan.K