Skip to Content
0
Mar 04, 2009 at 11:21 AM

Displaying red color in SQL trace select on EKKO & EKPO using inner join

67 Views

Hi All,

Can any one tell me why SQL trace is showing red against table EKPO for below statement and please suggest how best I can write this.

SELECT a~ebeln "Purchasing document

b~ebelp "PO item

a~lifnr "Vendor

a~ekgrp "Purchasing group

a~bedat "Document date

b~txz01 "Short text

b~matnr "Material

b~matkl "Material

b~menge "Quantity

b~meins "UOM

b~netpr "Net price

b~netwr "Net value

INTO TABLE t_poitems

FROM ekko AS a INNER JOIN ekpo AS b

ON aebeln EQ bebeln

WHERE a~ebeln IN s_ebeln

And a~bstyp eq u2018Fu2019

AND a~lifnr IN s_lifnr

AND a~ekgrp IN s_ekgrp

AND a~bedat IN s_bedat

AND a~loekz EQ space

AND b~matnr IN s_matnr

AND b~bstyp EQ 'F'

AND b~matkl IN s_matkl

AND b~loekz EQ space.

Thanks,

Jwala