Skip to Content

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

Secondary Indexes

I want to extract the data from EKKO and EKPO using join statement. So I wrote the select query. But in where condition I have to use different combinations as in the selection screen user may enter and may not enter few fields. I have the below combinations.

CASE A

matnr

ekgrp

ekorg

knttp

pstyp

loekz

CASE B

ekgrp

ekorg

knttp

pstyp

loekz

CASE C

infnr

matnr

ekgrp

ekorg

knttp

pstyp

loekz

CASE D

infnr

ekgrp

ekorg

knttp

pstyp

loekz

Out of which Case B and D is taking long time to execute, so I want to create secondary index for cases B and D. So can you please suggest me some way to improve the speed the select like how to create the secondary index in this scenario??

Thnks,

Raghu Posani.

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