Skip to Content

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

Secondary index creation on ztable

Hi,

My requirement is to create secondary index on one custom table.

My custom table has below fields.

matid - primary key

material

material group

chart of account

gl account

creditor

I want to use 4 select statements in the program as below.

1. Get data from ztable on the basis of Material

2. Get data from ztable on the basis of Material Group

3. Get data from ztable on the basis of chart of account and gl account

4.Get data from ztable on the basis of creditor.

So my question is whether is it possible to create 4 indices on my ztable?

Also want to know whether the above selects will give better performance if indices are created?

Please reply ASAP.

Regards,

Shubhada

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