Jul 29, 2006 at 01:34 PM
Internal tables.
Hi All,
matnr idocty date status idocnum
75008845 matmas 22/7/06 53 13432
75008845 cremas 23/7/06 51 12341
75008845 bommat 21/7/06 64 15432
75008840 matmas 22/7/06 51 12432
75008840 cremas 22/7/06 51 12351
75008840 bommat 23/7/06 53 15438
75008825 matmas 21/7/06 64 19876
75008825 cremas 23/7/06 53 12543
75008825 bommat 22/7/06 51 15439.
My int.table looks like above For every there can be some three or four idoctypes with various status.I want to take only the least status for every material irrespective of message type. For eg I need only cremas record for material 75008845 since idoc status is least(51) out of three idoc types for mtrl 75008845.
How it would be possible.
Thanks,
Ponraj.s.