use secondary index

[Former Member]

Hi Experts,

how to use secondary index to below statement:

select mblnr

          mjahr

          bwart

          matnr

          aufnr

          from mseg into table it_mseg

          where bwart = it_out-bwart

           and matnr = it_out-matnr

           and aufnr = '261'.

note:  passing key field to above statement is not possible.

is there any secondary index in mseg if there how to uset it?

please let me know?

[Former Member]

Hi,

Yes there are many Secondary indexes available for MSEG. you can click on indexes and double click on a particular index to see what all fields are there .

To use a particular secondary Index , all you have to do is pass all the fields in where clause.

You can create your own secondary index . Please go through below links.

https://help.sap.com/saphelp_nw70/helpdata/en/cf/21eb2d446011d189700000e8322d00/content.htm

https://help.sap.com/saphelp_nwpi71/helpdata/en/cf/21eb47446011d189700000e8322d00/content.htm

Hope this helps.

[Former Member]

Hi,

You have already asked and had this question rejected - please don't keep posting the same stuff over and over if it is rejected.

You need to search and read SAP Help, as this is pretty basic stuff.

Cheers,

G.