help me plz

38 Views

hi all

My requirement is

if more than one kondm 'material pricing group' has been found then select the kondm which is appearing

the most for this material in this table

example

matnr mat pricing grp

101 c7

102 c7

103 c1

104 c2

105 c7

then the value for 101,102,105 shud be displayed this is an just an rough example i don know the records

and the code wich i wrote is

SELECT matnr

kondm

into table it_mvke

from mvke

where matnr in p_matnr

loop at it_mvke

WRITE: / it_mvke-matnr UNDER 'material no',it_mvke-kondm UNDER 'material gp'.

endloop.

top-OF-PAGE.

WRITE: /'material no','material gp'.

this code is displaying all the records but my requirement is

if more than one kondm 'material pricing group' has been found then select the kondm which is appearing

the most for this material in this table