topic Re: SQL Problem in Application Development and Automation Discussions

SQL Problem

Former Member — Fri, 31 Aug 2007 02:31:05 GMT

Dear all,

I'm new in ABAP development. I got the runtime error for the following Open SQL statement:

SELECT a1_{preis a1}bedat b1_{matnr INTO TABLE it_price FROM eipa AS a1 JOIN eina AS b1 ON a1}infnr = b1~infnr

WHERE b1_{matnr IN ( SELECT mvke}matnr FROM mvke WHERE mvke_{provg = c_provg AND mvke}mvgr1 = c_mvgr1 ) AND b1~lifnr = '0000001000'.

Any comment??

Regards,

Kit

Message was edited by:

Chun Kit Chan

Former Member — Fri, 31 Aug 2007 02:48:25 GMT

Hi Chun,

dont use joins.. they are bad in performance.. use for all entries..

Structure of itab_mvke : Only one field matnr

itab_eina: matnr, infnr, preis, bedat

SELECT matnr

FROM mvke

INTO TABLE itab_mvke

WHERE provg EQ c_provg

AND mvgr1 EQ c_mvgr1.

IF sy-subrc EQ 0

AND NOT itab_mvke[] IS INITIAL.

SELECT matnr

infnr

FROM eina

INTO TABLE itab_eina

FOR ALL ENTRIES IN itab_mvke

WHERE matnr EQ itab-mvke

AND lifnr EQ '0000001000'.

IF sy-subrc EQ 0

AND NOT itab_eina[] IS INITIAL.

SELECT preis

bedat

FROM eipa

INTO CORRESPONDING FIELDS OF itab_eina

FOR ALL ENTRIES IN itab_eina

WHERE infnr EQ itab_eina-infnr.

ENDIF.

Thanks and Best Regards,

Vikas Bittera.

**Reward if useful**

Former Member — Fri, 31 Aug 2007 02:49:22 GMT

What is the error message?