topic Re: PROBLEM IN LOOP in Application Development and Automation Discussions

PROBLEM IN LOOP

Former Member — Fri, 22 Jun 2007 05:04:39 GMT

i HAVE USED THE BELOW LOOP for displaying the hearder text of Tax coloum based on condition(KSCHL). when ever it fine JVRD or JIPC conditions it shows in right manner but when it doesnt find any row, it wont show any text. I want it to show Sales Tax when JVRD or JIPC are not there.

********************************************************************************

LOOP AT T_KONP WHERE KSCHL = 'JVRD' OR KSCHL = 'JIPC'.

IF SY-SUBRC = 0.

IF T_KONP-KSCHL = 'JVRD'.

TAX = 'Local Tax'.

ELSEIF T_KONP-KSCHL = 'JIPC'.

TAX = 'Central Tax'.

ENDIF.

ELSE.

TAX = 'Sales Tax'.

ENDIF.

*********************************************************************************

Thanks.

Khan.

Re: PROBLEM IN LOOP

Former Member — Fri, 22 Jun 2007 05:07:38 GMT

Hi,

use this code.

LOOP AT T_KONP WHERE KSCHL = 'JVRD' OR KSCHL = 'JIPC'.
  IF T_KONP-KSCHL = 'JVRD'.
     TAX = 'Local Tax'.
  ELSEIF T_KONP-KSCHL = 'JIPC'.
    TAX = 'Central Tax'.
  ENDIF.
ENDLOOP.
IF SY-SUBRC <> 0.
  TAX = 'Sales Tax'.
ENDIF.

Regards,

Richa

Re: PROBLEM IN LOOP

Former Member — Fri, 22 Jun 2007 05:07:41 GMT

Hi ,

LOOP AT T_KONP.

"Remove this.WHERE KSCHL = 'JVRD'OR KSCHL = 'JIPC'.

IF T_KONP-KSCHL = 'JVRD'.

TAX = 'Local Tax'.

ELSEIF T_KONP-KSCHL = 'JIPC'.

TAX = 'Central Tax'.

ELSE.

TAX = 'Sales Tax'.

ENDIF.

ENDLOOP.

Regards,

Suruchi

null

Re: PROBLEM IN LOOP

Former Member — Fri, 22 Jun 2007 05:09:48 GMT

Khan,

You have already filtered out data in loop statement by saying

LOOP AT T_KONP WHERE KSCHL = 'JVRD' OR KSCHL = 'JIPC'.

So, you won't get any record which doesn't have one of these values inside your loop.

As per your requirement you should have used:

LOOP AT T_KONP .

IF T_KONP-KSCHL = 'JVRD'.

TAX = 'Local Tax'.

ELSEIF T_KONP-KSCHL = 'JIPC'.

TAX = 'Central Tax'.

ELSE.

TAX = 'Sales Tax'.

ENDIF.

endloop.

Re: PROBLEM IN LOOP

Former Member — Fri, 22 Jun 2007 05:09:50 GMT

Hi Khan ,

Try this code

LOOP AT T_KONP WHERE KSCHL = 'JVRD' OR KSCHL = 'JIPC'.

IF T_KONP-KSCHL = 'JVRD'.

TAX = 'Local Tax'.

ELSEIF T_KONP-KSCHL = 'JIPC'.

TAX = 'Central Tax'.

ENDIF.

IF SY-SUBRC ne 0.

TAX = 'Sales Tax'.

ENDIF

Regards,

Arun

Re: PROBLEM IN LOOP

Former Member — Fri, 22 Jun 2007 05:12:26 GMT

hi,

LOOP AT T_KONP WHERE KSCHL = 'JVRD' OR KSCHL = 'JIPC'.

IF SY-SUBRC <> 0.

TAX = 'Sales Tax'.

else.

IF T_KONP-KSCHL = 'JVRD'.

TAX = 'Local Tax'.

ELSEIF T_KONP-KSCHL = 'JIPC'.

TAX = 'Central Tax'.

TAX = 'Sales Tax'.

ENDIF.

endif.

Re: PROBLEM IN LOOP

Former Member — Fri, 22 Jun 2007 05:14:41 GMT

khan,

LOOP AT T_KONP.

CASE T_KONP-KSCHL.

WHEN 'JVRD'.

TAX = 'Local Tax'.

WHEN 'JIPC'.

TAX = 'Central Tax'.

WHEN others.

TAX = 'Sales Tax'.

ENDCASE.

ENDLOOP.

Don't forget to reward if useful....

Re: PROBLEM IN LOOP

Former Member — Fri, 22 Jun 2007 05:23:23 GMT

sORRY aRUN , yOUR CODENT WORK.

I appritiate ur reply.

Khan.

Re: PROBLEM IN LOOP

Former Member — Fri, 22 Jun 2007 05:23:59 GMT

sORRY Richa, yOUR CODE doesnt WORK.

I appritiate ur reply.

Khan.

Re: PROBLEM IN LOOP

Former Member — Fri, 22 Jun 2007 05:24:41 GMT

self answered