TO solve c_quote_sap with c_quote_PC

25 Views

hi all,

it is little bit tricky....I am using a program which sends an Excel file as mail attachment. I have a field say TRIP No which is a character field. For some reason, I am hard coding inside my program the TRIP NO to be as " ="TRIP NO" ". Then I am calling a customised Z_CONVERT_ALV which converts lt_output to Excel file .

Inside this customised Z_CONVERT_ALV , they are using a condition like

IF ga_layout-displ_type EQ 'C' "Character

AND <f> CS c_quote_sap.

REPLACE ALL OCCURRENCES OF c_quote_sap

IN <f>

WITH c_quote_pc.

ENDIF.

Hence my lt_ouput-TRIP NO contains c_quote_sap , hence satisfies this conditon, replaces all " with " (c_quote_pc), causing error in the Excel file

My question is : is there any way this IF condition can be made false and my ouput has ="TRIP NO" . even when I tried to change my TRIP NO to c_quote_pc and make this IF as false, but my output comes as "error in the Excel file".

THANKS

Edited by: Rob Burbank on Mar 28, 2010 9:42 PM