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