topic Re: loops problem in Application Development and Automation Discussions

loops problem

Former Member — Wed, 15 Nov 2006 16:32:02 GMT

Hellow I wont in field wa_itab_final-status_resom = text-004. to be a defrent text from the text in 003 but it not working all the text in the field is text-003 and in the second select I bring difrent value so the text have to to change accordingly thankes

LOOP AT itab_final INTO wa_itab_final.

MOVE wa_c_itab-begda TO wa_itab_final-begda.

MOVE wa_c_itab-endda TO wa_itab_final-endda.

MOVE wa_c_itab-priox TO wa_itab_final-priox.

MOVE wa_c_itab-istat TO wa_itab_final-istat.

SELECT SINGLE stext

FROM hrp1000

INTO wa_itab_final-stext

WHERE objid = wa_c_itab-objid.

wa_itab_final-status_resom = text-003.

MODIFY itab_final FROM wa_itab_final.

ENDLOOP.

*--

employye that register to the course-----

LOOP AT itab INTO wa_itab.

READ TABLE d_itab INTO wa_d_itab WITH KEY employee_num_reg = wa_itab-objid.

IF sy-subrc = 0.

wa_itab_final-objid = wa_itab-objid.

wa_itab_final-firstname = wa_itab-firstname.

wa_itab_final-lastname = wa_itab-lastname.

wa_itab_final-status_resom = text-004.

APPEND wa_itab_final TO itab_final.

ENDIF.

ENDLOOP.

Re: loops problem

Former Member — Wed, 15 Nov 2006 16:39:06 GMT

Introduce a CLEAR WA_ITAB_FINAL staement between the two LOOP statements and try.

Regards,

Ravi

Note : Please mark all the helpful answers

Re: loops problem

Former Member — Wed, 15 Nov 2006 16:42:02 GMT

Hello,

After APPEND Statement Clear wa_itab_final in both the loops.

If useful reward.

Vasanth

Re: loops problem

Former Member — Wed, 15 Nov 2006 16:52:09 GMT

hellow vasanth its not working

Re: loops problem

Former Member — Wed, 15 Nov 2006 16:53:16 GMT

helloe ravi its not working i thihnk becouse of append and modify

Re: loops problem

Former Member — Wed, 15 Nov 2006 17:03:46 GMT

Hello,

If the WA_FINAL-SATUS_RESOM should always TEXT-004, then make the change in the first loop also..

Vasanth

Re: loops problem

Former Member — Wed, 15 Nov 2006 17:07:38 GMT

It is not recommended to use TEXT SYMBOLS in WHERE CLAUSES instead use variables. This may give dumps.

Re: loops problem

Former Member — Wed, 15 Nov 2006 17:11:34 GMT

hi vasanthits not i just wont that when the first loop is happens in wa_itab_final-status_resom = text-003.

and when the second loop happen wa_itab_final-status = text-004

Re: loops problem

Former Member — Wed, 15 Nov 2006 17:19:14 GMT

I did not get your exact requirement but if below is what you want..then check the given solution.

U wish to update the itab_final-status_resom field to be text-003 or text-004 depending on the loop. In the first loop you would set it to 003 and if the employee has registered for the course it should be 004.

If that is the case change the below loop -->

LOOP AT itab INTO wa_itab.

READ TABLE d_itab INTO wa_d_itab WITH KEY employee_num_reg = wa_itab-objid.

IF sy-subrc = 0.

read table itab_final into wa_itab_final with key objid = wa_d_itab-objid.

*wa_itab_final-objid = wa_itab-objid.

wa_itab_final-firstname = wa_itab-firstname.

wa_itab_final-lastname = wa_itab-lastname.

wa_itab_final-status_resom = text-004.

*APPEND wa_itab_final TO itab_final.

MODIFY itab_final from wa_itab_final index sy-tabix.

ENDIF.

ENDLOOP.

Re: loops problem

Former Member — Wed, 15 Nov 2006 17:22:39 GMT

Hi Antonio,

As u r appending second time u r getting new record into table itab_final.

Please check it by changing Append with Modify.

Regards,

Sanjeev