‎2007 Jun 22 6:04 AM
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.
‎2007 Jun 22 6:07 AM
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
‎2007 Jun 22 6:23 AM
sORRY Richa, yOUR CODE doesnt WORK.
I appritiate ur reply.
Khan.
‎2007 Jun 22 6:07 AM
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
‎2007 Jun 22 6:09 AM
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.
‎2007 Jun 22 6:09 AM
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
‎2007 Jun 22 6:23 AM
‎2007 Jun 22 6:12 AM
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.
‎2007 Jun 22 6:14 AM
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....
‎2007 Jun 22 6:24 AM