Advertisement
Guest User

Untitled

a guest
Mar 26th, 2018
560
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.60 KB | None | 0 0
  1. TYPES tt_materials TYPE STANDARD TABLE OF marc WITH DEFAULT KEY.
  2.  
  3. SELECT * UP TO 20 ROWS
  4. INTO TABLE @DATA(materials)
  5. FROM marc
  6. ORDER BY matnr, pstat.
  7.  
  8. DATA duplicates TYPE tt_materials.
  9. LOOP AT materials INTO DATA(material)
  10. GROUP BY ( id = material-matnr
  11. status = material-pstat
  12. size = GROUP SIZE )
  13. ASCENDING REFERENCE INTO DATA(group_ref).
  14.  
  15. CHECK group_ref->*-size > 1.
  16. DATA(members) = VALUE tt_materials( FOR <status> IN GROUP group_ref ( <status> ) ).
  17. duplicates = VALUE tt_materials( BASE duplicates FOR member IN members ( member ) ).
  18.  
  19. ENDLOOP.
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement