Skip to Content
avatar image
Former Member

use secondary index

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?

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • avatar image
    Former Member
    May 22, 2015 at 08:58 AM

    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.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    May 22, 2015 at 08:57 AM

    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.

    Add comment
    10|10000 characters needed characters exceeded