query error

[Former Member]

Hi Abapers

When i compile this query, am getting the following error,

For pooled tables, cluster tables, and projection views, JOIN is not allowd "BSEG"

but i want form the query like this condition, what can i do.

SELECT A~BELNR

A~VALUT

A~EBELN

A~EBELP

A~LIFNR

A~MATNR

A~WERKS

A~MENGE

A~MEINS

A~GJAHR

A~DMBTR

B~BLART

INTO CORRESPONDING FIELDS OF TABLE IT_BSEG1

FROM BSEG AS A

INNER JOIN BSIK AS B ON A_{BELNR = B}BELNR

for all entries in it_bseg2

WHERE A~EBELN = IT_BSEG2-EBELN and

A~GJAHR = IT_BSEG2-GJAHR and

B~BLART = 'RE'.

thanks in advance..

Regards

Rajaram

[Former Member]

Hi Raja,

You can not perform JOIN on Cluster tables as BSEG is a Cluster table.

Use FOR ALL ENTRIES instead of JOINs.

<b>Friendly Note:</b> You have many open threads and Plz close the threads if they are answered/solved and reward points to the people who are helping you by taking their valuable time apart from their regular activities.

Thanks,

Vinay

[Former Member]

I have closed all threads and given points also.

Thanks and regards

Rajaram

[Former Member]

Hi,

Rightly said you can not use joins in cluster tables such as BSEG and KONV in joins instead you will have to use your own query using either for all entries or first moving all values from bseg into an internal table and all values from the other table into another table and then using the read with key statement to update the values in one IT

Regards,

Himanshu