Skip to Content
avatar image
-1
Former Member

Unique feild for delivey number in LIPS

i want to develop a report in smart form.

display verticaly

Dio1 Dio2 Dio3

delivery No: I 0080000566 I 0080000592 I 0080000620.................... so on

but in LIPS table

delivery no are showing item wise.

select matnr from lips into CORRESPONDING FIELDS OF TABLE it_do_detail where lips~vgbel = s_vbeln-low.

delete adjacent duplicates from it_do_detail comparing matnr.

loop at it_do_detail.

select single lips~vbeln from lips into it_do_detail-dio1 where lips~vgbel = s_vbeln-low.

* and lips~vgpos = '10'.

 select single lips~vbeln from lips into it_do_detail-dio2 where lips~vgbel = s_vbeln-low.

* and lips~vgpos = '20'.

 select single lips~vbeln from lips into it_do_detail-dio3 where lips~vgbel = s_vbeln-low.

* and lips~vgpos = '30'.

modify it_do_detail.
ENDLOOP.

delete adjacent duplicates from it_do_detail comparing dio1.

result in debugger:

any one can help

xc.jpg (56.5 kB)
lips.jpg (90.0 kB)
dio.jpg (75.7 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

0 Answers