Skip to Content
0
Dec 08, 2007 at 05:28 AM

Regardaing secondary index

26 Views

hi all,

i want to create the secondary index on mseg table.

here i am having select stament like this...

which fields can i select in the secondary index.

give me a brief explain.

SELECT MSEG~MBLNR

MSEG~BWART

MSEG~WERKS

MSEG~SHKZG

MSEG~MATNR

MSEG~ERFMG

MSEG~UMWRK

MKPF~MBLNR

MKPF~BUDAT

MSEG~XAUTO

MSEG~EBELN

INTO TABLE I_3MSEG

FROM MSEG

INNER JOIN MKPF

ON MSEGMBLNR = MKPFMBLNR

WHERE MSEG~BWART IN ('301')

AND MSEG~MATNR IN S_MATNR

AND MSEG~WERKS IN S_SPLANT

AND MSEG~UMWRK IN S_RPLANT

AND MKPF~BUDAT IN S_AEDAT

AND MSEG~XAUTO <> 'X'

AND MSEG~EBELN IN S_EBELN.

Regards..

Anand.N