topic Re: query error in Application Development and Automation Discussions

query error

Former Member — Sat, 04 Aug 2007 04:12:25 GMT

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

Re: query error

Former Member — Sat, 04 Aug 2007 04:24:09 GMT

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

Re: query error

Former Member — Sat, 04 Aug 2007 05:03:30 GMT

I have closed all threads and given points also.

Thanks and regards

Rajaram

Re: query error

Former Member — Sat, 04 Aug 2007 05:13:26 GMT

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