SAP Query Creation

237 Views

Hi All,

I am creating a SAP query in the system using the tables KONP,MBEW & A018 i could join tables KONP & MBEW but i am not able to add the table A018 and a error message is displayed

Error Message:

Table A018 cannot be used in a join

Message no. AQ501

Diagnosis

1. You cannot read the selected table with SELECT statements (because, for example, it is a structure without a database table). Therefore, this table cannot be read within a table join either.

2. The chosen table is a pool or cluster table. These tables may not be used in a table join.

Can anyone tell me a alternative to join this table to MBEW & KONP.

I want this Join Conditions:

MBEW-MATNR = A018-MATNR

A018-KAPPL = KONP-KAPPL

A018-KSCHL = KONP-KSCHL

A018-KNUMH = KONP-KNUMH

Thanks & Regards

Andrew

Edited by: Andrew J on Dec 18, 2008 2:49 PM