table fields

[Former Member]

Hi,

can any body tell me how to distribute respective data from data base table fields? eg MARA contains field MATNR,MBRSH(indus sector), BRGEW (gross wt).

suppose in mara- 1 to 100.

MBRSH - 10 indust sectors for 100 material no.

BRGEW - 25 differnt gross wt for 100 material no.

now i want to classify material no -

---

1] having same MBRSH

2] having same BRGEW.

Thanks.

[amit_khare]

use SORT itab BY <field1> <field2>

[venkat_o]

Hi Rani, Just sort the table by the 3 fields. and see the table in debug.

DATA: BEGIN OF i_mara OCCURS 0,
        matnr TYPE mara-matnr,
        mbrsh TYPE mara-mbrsh,
        brgew TYPE mara-brgew,
      END OF i_mara.

  SORT i_mara BY matnr mbrsh brgew.

Regards, Venkat.O

[Former Member]

Hi,

Use sort.

SORT itab BY matnr mbrsh brgew.

Regards

Sandipan