Regarding error in inner join,

[former_member242166]

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

[former_member242166]

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

[Former Member]

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

[former_member242166]

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

Regards,

Linganathan.K

[Former Member]

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.

[Former Member]

Hi,

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

Regards,

Ramya R

[former_member242166]

Hi ramya,

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

Thanks,

Linganathan.K