Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

How an INDEX of a Table got selected when a SELECT query hits the Database

Hi All,

How an Index got selected when a SELECT query hits the Database Table.

My SELECT query is as ahown below.

SELECT ebeln ebelp matnr FROM ekpo

APPENDING TABLE i_ebeln

FOR ALL ENTRIES IN i_mara_01

WHERE werks = p_werks AND

matnr = i_mara_01-matnr AND

bstyp EQ 'F' AND

loekz IN (' ' , 'S') AND

elikz = ' ' AND

ebeln IN s_ebeln AND

pstyp IN ('0' , '3') AND

knttp = ' ' AND

ko_prctr IN r_prctr AND

retpo = ''.

The fields in the INDEX of the Table EKPO should be in the same sequence as in the WHERE clasuse?

Regards,

Viji

Tags:
Not what you were looking for? View more on this topic or Ask a question