topic Re: table fields in Application Development and Automation Discussions

table fields

Former Member — Tue, 22 Apr 2008 22:09:43 GMT

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.

Re: table fields

amit_khare — Wed, 23 Apr 2008 00:12:59 GMT

use SORT itab BY <field1> <field2>

Re: table fields

venkat_o — Wed, 23 Apr 2008 02:34:01 GMT

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

Re: table fields

Former Member — Wed, 23 Apr 2008 03:34:14 GMT

Hi,

Use sort.


SORT itab BY matnr mbrsh brgew.

Regards

Sandipan