topic internal table in Application Development and Automation Discussions

internal table

Former Member — Wed, 23 Apr 2008 07:41:57 GMT

Hello gurus,

I have an internal table with following fields.

matnr werks lgort lvorm

A--

P
M--

A--

Q
M--

A--

Q
N--

A--

Q
O--

B--

P
M--

B--

P
N--

my requirement is if ihave

Material numbers(matnr) with one plant(werks) and one-storage locations(lgort) attached to it ..

EG:A P M X record.....

I have to delete these type of records.

and for these records which have multiple lgorts for same matnr and same plant(werks) i have 2 manipulate like this ...total count for those records which doesnt have X

and deletion count for records which have lvorm = X

A--

Q
M--

A--

Q
N--

A--

Q
O--

in this example ,

total count = 1 A--

Q
N--

deletion count =2 A--

Q
M--

A--

Q
O--

i have 2 find this total count n deletion count for all other matnrs in the internal table.

how can i do manipulations for each individual matnr.....

Re: internal table

Former Member — Wed, 23 Apr 2008 09:06:38 GMT

Hi Madan,

Use the below logic.

data: v_total type i,

v_deleted type i.

data: begin of itab_result occurs 0,

matnr like mara-matnr,

total type i,

deleted type i,

end of itab_result.

sort itab by matnr.

loop at itab.

if itab-lvorm = 'X'.

v_deleted = v_deleted + 1.

else.

v_total = v_total + 1.

endif.

at end of matnr.

itab_result-matnr = itab-matnr.

itab_result-total = v_total.

itab_result-deleted = v_deleted.

append itab_result.

clear itab_result.

clear: v_total, v_deleted.

endat.

endloop.

Edited by: Velangini Showry Maria Kumar Bandanadham on Apr 23, 2008 11:06 AM

Re: internal table

Former Member — Wed, 23 Apr 2008 09:10:54 GMT

ya its ok...

But my first condition shud also satisfy...

delete the records which i have one matnr one plant and one storage location

look at my first point....