Need idea if i write This code

Former Member — Thu, 08 May 2008 09:36:29 GMT

Hi,

i Do This Code and i Wont To have idea How to do it Better.

i have to do the select for every month for 13 month before today.

Regards

&----

*& Form ap

&----

----

----

FORM ap TABLES p_cats_tab USING p_l_begda13

p_l_begda12.

SELECT *

FROM catsdb

APPENDING CORRESPONDING FIELDS OF TABLE p_c_tab

WHERE workdate BETWEEN p_l_begda1 AND p_l_begda2.

ENDFORM. " ap

PERFORM: ap TABLES cats_tab1 USING l_begda13 l_begda12 ,

ap TABLES cats_tab2 USING l_begda12 l_begda11 ,

ap TABLES cats_tab3 USING l_begda11 l_begda10 ,

ap TABLES cats_tab4 USING l_begda10 l_begda9 ,

ap TABLES cats_tab5 USING l_begda9 l_begda8 ,

ap TABLES cats_tab6 USING l_begda8 l_begda7 ,

ap TABLES cats_tab7 USING l_begda7 l_begda6 ,

ap TABLES cats_tab8 USING l_begda6 l_begda5 ,

ap TABLES cats_tab9 USING l_begda5 l_begda4 ,

ap TABLES cats_tab10 USING l_begda4 l_begda3 ,

ap TABLES cats_tab11 USING l_begda3 l_begda2 ,

ap TABLES cats_tab12 USING l_begda2 l_begda1 ,

ap TABLES cats_tab13 USING l_begda1 sy-datum .

Re: Need idea if i write This code

andreas_mann3 — Thu, 08 May 2008 13:53:17 GMT

select all of catsdb

and move data to an itab with period as key-field

hope that helps

Andreas