Optimize query - EBAN

[Former Member]

Hi friends,

I want to optimize one selection in a table EBAN.

The index z02 support my QUERY.

Fields of the INDEX:

FLIEF Fixed vendor

LFDAT Item delivery date

WERKS Plant

BERID MRP area

LOEKZ Deletion indicator in purchasing document

STATU Processing status of purchase requisition

Today my selection is:

SELECT preis peinh waers menge meins

banfn bnfpo knttp loekz ebeln

ebelp INTO TABLE t_eban

FROM eban

WHERE loekz EQ ' '

AND frgkz >= space

AND werks EQ p_werks

AND statu NE 'B'

AND ( knttp EQ 'F' OR

knttp EQ 'K' )

AND lfdat LE v_high.

I need get the field FLIEF to complete that index and consequently improve my selection. How can I get the field FLIEL using WERKS to search?

• I tried to use the table LFA1 but the field WERKS is not obligatory.

Please suggestions.

Best regards,

William Rodrigues

[Former Member]

Moderator message - Welcome to SCN. Please see before posting Also, Please read and and [Asking Good Questions in the Forums to get Good Answers|/people/rob.burbank/blog/2010/05/12/asking-good-questions-in-the-forums-to-get-good-answers] before posting again. Rob