topic Re: Getting run time error when accessing the file from frontend server using F4.....? in Application Development and Automation Discussions

Getting run time error when accessing the file from frontend server using F4.....?

Former Member — Mon, 26 May 2014 09:00:09 GMT

Category ABAP Programming Error

Runtime Errors CONVT_NO_NUMBER

Except. CX_SY_CONVERSION_NO_NUMBER

ABAP Program ZMM_MIGO_GOODS_ISSUE

Application Component Not assigned

Date and Time 26.05.2014 14:28:30

Short Text

"C:\Users\SAP\Desktop\MIGO\MIGO.xlsx" cannot be interpreted as a number

What happened?

Error in the ABAP Application Program

The current ABAP program "ZMM_MIGO_GOODS_ISSUE" had to be terminated because

it has

come across a statement that unfortunately cannot be executed.

Error analysis

An exception has occurred which is explained in more detail below. The

exception is assigned to class 'CX_SY_CONVERSION_NO_NUMBER' and was not caught

in procedure

"%_SEL_SCREEN_P_FNAME_V" "(FORM)", nor was it propagated by a RAISING clause.

Since the caller of the procedure could not have anticipated this

Re: Getting run time error when accessing the file from frontend server using F4.....?

anubhab — Mon, 26 May 2014 09:03:49 GMT

Hi Suresh,

It seems to be a problem with the variable that you used to capture the path for the file. Did you declared as numeric field? Are you using OOPS methods or normal ABAP? Can you please provide the code snippet where the error occurred.

Regards,

Anubhab

Re: Getting run time error when accessing the file from frontend server using F4.....?

nabheetscn — Mon, 26 May 2014 09:06:32 GMT

Suresh

Your dump in itself explains data mismatch issue. Please check your variable type declaration where udmp comes

Nabheet

Re: Getting run time error when accessing the file from frontend server using F4.....?

Former Member — Mon, 26 May 2014 09:11:06 GMT

Thanks for the reply Chirui,

Please find the code snippet:

REPORT ZMM_MIGO_GOODS_ISSUE NO STANDARD PAGE HEADING.

DATA : BEGIN OF IT_DATA OCCURS 0,

ID(10),

BLDAT(10), " Document Date

BUDAT(10), " Posting Date

REF_DOC_NO(16), " Material Slip No

DEL_NOTE(16), " delivery note

MATNR TYPE MSEG-MATNR, " Material Number

ERFMG(13) TYPE C, " Quantity

BWART TYPE RM07M-BWARTWA, " Movement Type

SOBKZ(1), " Special Stock

WERKS TYPE RM07M-WERKS, " Plant

LGORT TYPE RM07M-LGORT, " Storage Location

PS_POSID TYPE PS_POSID, " WBS Element

COST_CENTER TYPE KOSTL, " cost center

ORDER TYPE AUFNR, " order number

SERNR TYPE RIPW0-SERNR, " Serial Number

END OF IT_DATA,

BEGIN OF IT_HEAD OCCURS 0,

ID(10),

BLDAT(10), " Document Date

BUDAT(10), " Posting Date

REF_DOC_NO(16), " Reference document number

"HEADER_TXT(25), " Header Text

BWART TYPE RM07M-BWARTWA, " Movement Type

END OF IT_HEAD,

BEGIN OF IT_ITEM OCCURS 0,

ID(10),

"ID1(10),

WERKS TYPE RM07M-WERKS, " Plant

LGORT TYPE RM07M-LGORT, " Storage Location

VAL_TYPE TYPE BWTAR_D,

MATNR TYPE MSEG-MATNR, " Material Number

ERFMG(13) TYPE C, " Quantity

CHARG TYPE MSEG-CHARG, " Batch

BWTAR TYPE BWTAR_D,

PS_POSID TYPE PS_POSID, " WBS Element

ERFME TYPE MSEG-ERFME, " Unit

COST_CENTER TYPE KOSTL, " cost center

ORDER TYPE AUFNR, " order number

CUSTOMER TYPE EKUNN, " Account Number of Customer

SERNR TYPE RIPW0-SERNR, " Serial Number

AMOUNT_LC TYPE BAPI_EXBWR,

SOBKZ(1),

END OF IT_ITEM,

HEADER LIKE BAPI2017_GM_HEAD_01,

CODE LIKE BAPI2017_GM_CODE,

ITEMS LIKE BAPI2017_GM_ITEM_CREATE OCCURS 0 WITH HEADER LINE,

SERIAL LIKE BAPI2017_GM_SERIALNUMBER OCCURS 0 WITH HEADER LINE,

RETURN LIKE BAPI2017_GM_HEAD_RET,

RET LIKE BAPIRET2 OCCURS 0 WITH HEADER LINE,

TESTRUN LIKE BAPI2017_GM_GEN-TESTRUN,

IT_TAB TYPE FILETABLE,

GD_SUBRC TYPE I,

L_FILE TYPE RLGRAP-FILENAME,

IT_RAW TYPE TRUXS_T_TEXT_DATA,

COUNT(2) TYPE N,

TEXT_C(30).

DATA: V_BEGCOL TYPE I VALUE 1, "Begin Col

V_BEGROW TYPE I VALUE 1, "Begin Row

V_ENDCOL TYPE I VALUE 16, "End Col

V_ENDROW TYPE I VALUE 99999,

V_FNAME TYPE I ,

L_FILENAME TYPE I,

L_FNAME TYPE I.

DATA: DATA LIKE TABLE OF IT_ITEM WITH HEADER LINE.

DATA: IT_TEMP LIKE TABLE OF IT_ITEM WITH HEADER LINE.

DATA: IT_TEMP1 LIKE TABLE OF IT_ITEM WITH HEADER LINE.

DATA: IT_ITEM1 LIKE TABLE OF IT_ITEM WITH HEADER LINE.

SELECTION-SCREEN: BEGIN OF BLOCK B1 WITH FRAME TITLE TEXT-001.

PARAMETERS : P_FNAME TYPE RLGRAP-FILENAME.

* p_test AS CHECKBOX.

SELECTION-SCREEN: END OF BLOCK B1.

AT SELECTION-SCREEN ON VALUE-REQUEST FOR P_FNAME.

CALL FUNCTION 'F4_FILENAME'

EXPORTING

FIELD_NAME = 'FILENAME'

IMPORTING

FILE_NAME = P_FNAME.

*AT SELECTION-SCREEN ON VALUE-REQUEST FOR P_FILE.

* CALL METHOD CL_GUI_FRONTEND_SERVICES=>FILE_OPEN_DIALOG

* EXPORTING

* WINDOW_TITLE = 'SELECT FILE'

* CHANGING

* FILE_TABLE = IT_TAB

* RC = GD_SUBRC.

* READ TABLE IT_TAB INTO P_FILE INDEX 1.

START-OF-SELECTION.

PERFORM GET_EXCEL_DATA.

PERFORM GET_HEADER_ITEM.

PERFORM UPDATE_DATA.

*&---------------------------------------------------------------------*

*& Form GET_EXCEL_DATA

*&---------------------------------------------------------------------*

* text

*----------------------------------------------------------------------*

* --> p1 text

* <-- p2 text

*----------------------------------------------------------------------*

FORM GET_EXCEL_DATA .

* CALL FUNCTION 'CONVERSION_EXIT_ALPHA_INPUT'

* EXPORTING

* INPUT = P_FNAME

* IMPORTING

* OUTPUT = L_FNAME.

CALL FUNCTION 'ALSM_EXCEL_TO_INTERNAL_TABLE'

EXPORTING

FILENAME = L_FILENAME

I_BEGIN_COL = V_BEGCOL

I_BEGIN_ROW = V_BEGROW

I_END_COL = V_ENDCOL

I_END_ROW = V_ENDROW

TABLES

INTERN = IT_DATA

EXCEPTIONS

INCONSISTENT_PARAMETERS = 1

UPLOAD_OLE = 2

OTHERS = 3.

CLEAR:V_FNAME.

MOVE P_FNAME TO V_FNAME.

L_FILENAME = P_FNAME.

IF SY-SUBRC <> 0.

MESSAGE ID SY-MSGID TYPE SY-MSGTY NUMBER SY-MSGNO

WITH SY-MSGV1 SY-MSGV2 SY-MSGV3 SY-MSGV4.

ENDIF.

ENDFORM. " GET_EXCEL_DATA

Regards,

Suresh Bheema.

Re: Getting run time error when accessing the file from frontend server using F4.....?

anubhab — Mon, 26 May 2014 09:18:13 GMT

Hi Suresh,

Please change V_FNAME TYPE I ( also L_FILENAME TYPE I, make both of them of type RLGRAP-FILENAME). Because when you try to do this operation: MOVE P_FNAME TO V_FNAME. there will be a type conflict, which is causing you the dump.

Regards,

Anubhab

Re: Getting run time error when accessing the file from frontend server using F4.....?

pavanm592 — Mon, 26 May 2014 09:24:46 GMT

Hi Suresh,

Change your IT_DATA field types to charecter type and check and also L_FILENAME to char,

When your uploading data from flat files this is the most common mistake,try change all the field types to char type and revert the status.

Regards,

Pavan

Re: Getting run time error when accessing the file from frontend server using F4.....?

RaymondGiuseppi — Mon, 26 May 2014 09:29:33 GMT

Define your fields respecting the FM signature.

You can use menu "Program", "check", "code inspector" to find such errors.

Regards,

Raymond

Re: Getting run time error when accessing the file from frontend server using F4.....?

Mohamed_Mukhtar — Mon, 26 May 2014 09:31:02 GMT

Hello Suresh,

Please change data declaration of L_filename.


Data : L_FILENAME type RLGRAP-FILENAME.

AT SELECTION-SCREEN ON VALUE-REQUEST FOR P_FNAME.
 
   CALL FUNCTION 'F4_FILENAME'
     EXPORTING
       FIELD_NAME = 'FILENAME'
     IMPORTING
       FILE_NAME  = P_FNAME.
 
   L_FILENAME =  P_FNAME. ----> add this line

Re: Getting run time error when accessing the file from frontend server using F4.....?

Former Member — Mon, 26 May 2014 09:40:11 GMT

HI CHIRUI,

I have changed and tried but still i a getting the same thing..

otherwise please check this i am using some class method i am not getting short dump,but excel file is not getting uploaded.

REPORT ZMM_MIGO_GOODS_ISSUE NO STANDARD PAGE HEADING.

DATA : BEGIN OF IT_DATA OCCURS 0,

ID(10),

BLDAT(10), " Document Date

BUDAT(10), " Posting Date

REF_DOC_NO(16), " Material Slip No

DEL_NOTE(16), " delivery note

MATNR TYPE MSEG-MATNR, " Material Number

ERFMG(13) TYPE C, " Quantity

BWART TYPE RM07M-BWARTWA, " Movement Type

SOBKZ(1), " Special Stock

WERKS TYPE RM07M-WERKS, " Plant

LGORT TYPE RM07M-LGORT, " Storage Location

PS_POSID TYPE PS_POSID, " WBS Element

COST_CENTER TYPE KOSTL, " cost center

ORDER TYPE AUFNR, " order number

SERNR TYPE RIPW0-SERNR, " Serial Number

END OF IT_DATA,

BEGIN OF IT_HEAD OCCURS 0,

ID(10),

BLDAT(10), " Document Date

BUDAT(10), " Posting Date

REF_DOC_NO(16), " Reference document number

"HEADER_TXT(25), " Header Text

BWART TYPE RM07M-BWARTWA, " Movement Type

END OF IT_HEAD,

BEGIN OF IT_ITEM OCCURS 0,

ID(10),

"ID1(10),

WERKS TYPE RM07M-WERKS, " Plant

LGORT TYPE RM07M-LGORT, " Storage Location

VAL_TYPE TYPE BWTAR_D,

MATNR TYPE MSEG-MATNR, " Material Number

ERFMG(13) TYPE C, " Quantity

CHARG TYPE MSEG-CHARG, " Batch

BWTAR TYPE BWTAR_D,

PS_POSID TYPE PS_POSID, " WBS Element

ERFME TYPE MSEG-ERFME, " Unit

COST_CENTER TYPE KOSTL, " cost center

ORDER TYPE AUFNR, " order number

CUSTOMER TYPE EKUNN, " Account Number of Customer

SERNR TYPE RIPW0-SERNR, " Serial Number

AMOUNT_LC TYPE BAPI_EXBWR,

SOBKZ(1),

END OF IT_ITEM,

HEADER LIKE BAPI2017_GM_HEAD_01,

CODE LIKE BAPI2017_GM_CODE,

ITEMS LIKE BAPI2017_GM_ITEM_CREATE OCCURS 0 WITH HEADER LINE,

SERIAL LIKE BAPI2017_GM_SERIALNUMBER OCCURS 0 WITH HEADER LINE,

RETURN LIKE BAPI2017_GM_HEAD_RET,

RET LIKE BAPIRET2 OCCURS 0 WITH HEADER LINE,

TESTRUN LIKE BAPI2017_GM_GEN-TESTRUN,

IT_TAB TYPE FILETABLE,

GD_SUBRC TYPE I,

L_FILE TYPE RLGRAP-FILENAME,

IT_RAW TYPE TRUXS_T_TEXT_DATA,

COUNT(2) TYPE N,

TEXT_C(30).

DATA: DATA LIKE TABLE OF IT_ITEM WITH HEADER LINE.

DATA: IT_TEMP LIKE TABLE OF IT_ITEM WITH HEADER LINE.

DATA: IT_TEMP1 LIKE TABLE OF IT_ITEM WITH HEADER LINE.

DATA: IT_ITEM1 LIKE TABLE OF IT_ITEM WITH HEADER LINE.

SELECTION-SCREEN: BEGIN OF BLOCK B1 WITH FRAME TITLE TEXT-001.

PARAMETERS : P_FILE TYPE RLGRAP-FILENAME.

* p_test AS CHECKBOX.

SELECTION-SCREEN: END OF BLOCK B1.

AT SELECTION-SCREEN ON VALUE-REQUEST FOR P_FILE.

CALL METHOD CL_GUI_FRONTEND_SERVICES=>FILE_OPEN_DIALOG

EXPORTING

WINDOW_TITLE = 'SELECT FILE'

CHANGING

FILE_TABLE = IT_TAB

RC = GD_SUBRC.

READ TABLE IT_TAB INTO P_FILE INDEX 1.

START-OF-SELECTION.

PERFORM GET_EXCEL_DATA.

PERFORM GET_HEADER_ITEM.

PERFORM UPDATE_DATA.

*&---------------------------------------------------------------------*

*& Form GET_EXCEL_DATA

*&---------------------------------------------------------------------*

* text

*----------------------------------------------------------------------*

* --> p1 text

* <-- p2 text

*----------------------------------------------------------------------*

FORM GET_EXCEL_DATA .

CALL FUNCTION 'CONVERSION_EXIT_ALPHA_INPUT'

EXPORTING

INPUT = P_FILE

IMPORTING

OUTPUT = L_FILE.

CALL FUNCTION 'TEXT_CONVERT_XLS_TO_SAP'

EXPORTING

I_LINE_HEADER = 'X'

I_TAB_RAW_DATA = IT_RAW

I_FILENAME = L_FILE

TABLES

I_TAB_CONVERTED_DATA = IT_DATA

EXCEPTIONS

CONVERSION_FAILED = 1

OTHERS = 2.

IF SY-SUBRC <> 0.

MESSAGE ID SY-MSGID TYPE SY-MSGTY NUMBER SY-MSGNO

WITH SY-MSGV1 SY-MSGV2 SY-MSGV3 SY-MSGV4.

ENDIF.

ENDFORM. " GET_EXCEL_DATA

*&---------------------------------------------------------------------*

*& Form GET_HEADER_ITEM

*&---------------------------------------------------------------------*

* text

*----------------------------------------------------------------------*

* --> p1 text

* <-- p2 text

*----------------------------------------------------------------------*

FORM GET_HEADER_ITEM .

DATA : FLAG(1).

LOOP AT IT_DATA.

CLEAR FLAG.

IF IT_DATA-ID IS NOT INITIAL.

AT NEW ID.

FLAG = 'X'.

ENDAT.

ENDIF.

IF FLAG = 'X'.

MOVE-CORRESPONDING IT_DATA TO IT_HEAD.

APPEND IT_HEAD.

ENDIF.

MOVE-CORRESPONDING IT_DATA TO IT_ITEM.

APPEND IT_ITEM.

ENDLOOP.

DATA[] = IT_ITEM[].

IT_TEMP[] = IT_ITEM[].

IT_TEMP1[] = IT_ITEM[].

ENDFORM. " GET_HEADER_ITEM

*&---------------------------------------------------------------------*

*& Form UPDATE_DATA

*&---------------------------------------------------------------------*

* text

*----------------------------------------------------------------------*

* --> p1 text

* <-- p2 text

*----------------------------------------------------------------------*

FORM UPDATE_DATA .

DATA : COUNT1(10),

L_QTY TYPE I,

DAT(10).

CONCATENATE SY-DATUM+6(2) '.' SY-DATUM+4(2) '.' SY-DATUM(4) INTO DAT.

LOOP AT IT_HEAD.

ON CHANGE OF IT_HEAD-ID.

CALL FUNCTION 'CONVERT_DATE_TO_INTERNAL'

EXPORTING

DATE_EXTERNAL = IT_HEAD-BUDAT

ACCEPT_INITIAL_DATE = 'X'

IMPORTING

DATE_INTERNAL = HEADER-PSTNG_DATE.

IF SY-SUBRC <> 0.

MESSAGE ID SY-MSGID TYPE SY-MSGTY NUMBER SY-MSGNO

WITH SY-MSGV1 SY-MSGV2 SY-MSGV3 SY-MSGV4.

ENDIF.

CALL FUNCTION 'CONVERT_DATE_TO_INTERNAL'

EXPORTING

DATE_EXTERNAL = IT_HEAD-BLDAT

ACCEPT_INITIAL_DATE = 'X'

IMPORTING

DATE_INTERNAL = HEADER-DOC_DATE.

IF SY-SUBRC <> 0.

MESSAGE ID SY-MSGID TYPE SY-MSGTY NUMBER SY-MSGNO

WITH SY-MSGV1 SY-MSGV2 SY-MSGV3 SY-MSGV4.

ENDIF.

MOVE : '2' TO HEADER-VER_GR_GI_SLIP,

'X' TO HEADER-VER_GR_GI_SLIPX.

* IF r1 EQ 'X'.

MOVE '05' TO CODE-GM_CODE.

HEADER-REF_DOC_NO = IT_HEAD-REF_DOC_NO.

"HEADER-HEADER_TXT = IT_HEAD-HEADER_TXT.

* ELSEIF r2 EQ 'X'.

* MOVE '04' TO code-gm_code.

* ELSEIF r3 EQ 'X'.

* MOVE '04' TO code-gm_code.

* ENDIF.

* IF p_test = 'X'.

* MOVE 'X' TO testrun.

* ENDIF.

ENDON.

IT_ITEM1[] = IT_ITEM[].

*delete it_item[] where werks = '' and id = it_head-id.

DELETE ADJACENT DUPLICATES FROM IT_ITEM COMPARING ID MATNR.

LOOP AT IT_ITEM WHERE ID = IT_HEAD-ID.

* ON CHANGE OF it_item-id1.

COUNT1 = COUNT1 + 1.

CALL FUNCTION 'CONVERSION_EXIT_ALPHA_INPUT'

EXPORTING

INPUT = IT_ITEM-MATNR

IMPORTING

OUTPUT = ITEMS-MATERIAL.

MOVE : IT_ITEM-WERKS TO ITEMS-PLANT,

IT_ITEM-LGORT TO ITEMS-STGE_LOC,

* it_item-lgort1 TO items-move_stloc,

IT_ITEM-CHARG TO ITEMS-BATCH,

* IT_ITEM-VAL_TYPE TO ITEMS-VAL_TYPE,

'FRESH' TO ITEMS-VAL_TYPE,

IT_HEAD-BWART TO ITEMS-MOVE_TYPE,

IT_ITEM-SOBKZ TO ITEMS-SPEC_STOCK,

IT_ITEM-ERFMG TO ITEMS-ENTRY_QNT,

* it_item-erfme TO items-entry_uom,

* it_item-sgtxt TO items-item_text,

* it_item-exbwr TO items-amount_lc,

IT_ITEM-PS_POSID TO ITEMS-WBS_ELEM,

IT_ITEM-PS_POSID TO ITEMS-VAL_WBS_ELEM,

"IT_ITEM-CUSTOMER TO ITEMS-CUSTOMER,

IT_ITEM-ERFMG TO L_QTY,

IT_ITEM-AMOUNT_LC TO ITEMS-AMOUNT_LC,

IT_ITEM-COST_CENTER TO ITEMS-COSTCENTER,

IT_ITEM-ORDER TO ITEMS-ORDERID.

* items-SPEC_MVMT = 'R'.

CALL FUNCTION 'CONVERSION_EXIT_ABPSN_INPUT'

EXPORTING

INPUT = ITEMS-WBS_ELEM

IMPORTING

OUTPUT = ITEMS-WBS_ELEM.

CALL FUNCTION 'CONVERSION_EXIT_ABPSN_INPUT'

EXPORTING

INPUT = ITEMS-VAL_WBS_ELEM

IMPORTING

OUTPUT = ITEMS-VAL_WBS_ELEM.

* CALL FUNCTION 'CONVERSION_EXIT_ALPHA_INPUT'

* EXPORTING

* input = it_item-lifnr

* IMPORTING

* output = items-vendor.

APPEND ITEMS.

* ENDON.

ENDLOOP.

DELETE ADJACENT DUPLICATES FROM IT_TEMP COMPARING ID MATNR.

DELETE IT_TEMP1 WHERE ID <> IT_HEAD-ID.

DELETE IT_TEMP WHERE ID <> IT_HEAD-ID.

DATA: MAT_ITM TYPE MBLPO,

SERNP TYPE SERAIL.

MAT_ITM = '0001'.

LOOP AT IT_TEMP.

SELECT SINGLE SERNP FROM MARC INTO SERNP WHERE MATNR = IT_TEMP-MATNR.

IF SERNP IS NOT INITIAL.

LOOP AT IT_TEMP1 WHERE ID = IT_TEMP-ID AND MATNR = IT_TEMP-MATNR.

* MOVE : it_item1-id TO serial-matdoc_itm,

* MOVE : mat_itm TO serial-matdoc_itm,

SERIAL-MATDOC_ITM = MAT_ITM .

SERIAL-SERIALNO = IT_TEMP1-SERNR.

APPEND SERIAL.

CLEAR IT_ITEM1.

ENDLOOP.

MAT_ITM = MAT_ITM + 1.

ENDIF.

CLEAR IT_TEMP.

ENDLOOP.

CALL FUNCTION 'BAPI_GOODSMVT_CREATE'

EXPORTING

GOODSMVT_HEADER = HEADER

GOODSMVT_CODE = CODE

TESTRUN = TESTRUN

* GOODSMVT_REF_EWM =

IMPORTING

GOODSMVT_HEADRET = RETURN

* MATERIALDOCUMENT =

* MATDOCUMENTYEAR =

TABLES

GOODSMVT_ITEM = ITEMS

GOODSMVT_SERIALNUMBER = SERIAL

RETURN = RET

* GOODSMVT_SERV_PART_DATA =

* EXTENSIONIN =

CALL FUNCTION 'BAPI_TRANSACTION_COMMIT'

EXPORTING

WAIT = 'X'

* IMPORTING

* RETURN =

IF NOT RETURN IS INITIAL.

WRITE :/ 'Material Document Number Generated: ' ,RETURN-MAT_DOC,RETURN-DOC_YEAR.

ELSE.

LOOP AT RET.

WRITE : RET-TYPE, RET-MESSAGE.

* log-index = sy-index.

* log-matnr = header-material.

* log-message = ret1-message.

* APPEND log.

ENDLOOP.

ENDIF.

REFRESH : ITEMS,RET.

CLEAR : HEADER,RETURN.

CLEAR: TESTRUN ,

RETURN,

ITEMS[],

SERIAL[],

RET[],

HEADER,

IT_TEMP[] ,

IT_TEMP1[].

IT_TEMP[] = DATA[].

IT_TEMP1[] = DATA[].

ENDLOOP.

ENDFORM. " UPDATE_DATA

Regards,

Suresh bheema

Re: Getting run time error when accessing the file from frontend server using F4.....?

anubhab — Mon, 26 May 2014 09:47:41 GMT

Hi Suresh,

Please check if your internal table and excel file are in sync and having same type.

Regards,

Anubhab

Re: Getting run time error when accessing the file from frontend server using F4.....?

Former Member — Mon, 26 May 2014 09:50:33 GMT

Please find the error screen shot......

Re: Getting run time error when accessing the file from frontend server using F4.....?

Former Member — Mon, 26 May 2014 09:53:48 GMT

Yeah, internal table is in same type.please check in the code also there is no mistake ,when i am debugging at CALL FUNCTION 'TEXT_CONVERT_XLS_TO_SAP' ...........i am getting the mentioned screen .so there might be the problem with the FM. i tried a lot but i didnt get it .Please help me out....!

Regards,

Suresh Bheema

Re: Getting run time error when accessing the file from frontend server using F4.....?

anubhab — Mon, 26 May 2014 09:56:48 GMT

Hi Suresh,

Why don't you just check Remember My Decision box and click on Allow. See what happens. And please make sure, you haven't kept the file open. If so, please sloce it and try.

Regards,

Anubhab

Re: Getting run time error when accessing the file from frontend server using F4.....?

Former Member — Mon, 26 May 2014 10:05:32 GMT

Dear Chirui,

i tried that already making the check Remember My Decision box and click on Allow . but once i came out of that and again press F8 it is asking the same thing.....!

I think it may be the problem with that class method or 'TEXT_CONVERT_XLS_TO_SAP' .

Regadrs,

Suresh

Re: Getting run time error when accessing the file from frontend server using F4.....?

pavanm592 — Mon, 26 May 2014 10:15:50 GMT

Hi Suresh,

To avoid the pop up Simply click (in the SAP GUI) "Option" -> "Security" -> "Security Settings". Here you can set the "Default Action" to whatever you want.

Regards,

Pavan

Re: Getting run time error when accessing the file from frontend server using F4.....?

anubhab — Mon, 26 May 2014 10:21:28 GMT

Hi Suresh,

It might be some problem with GUI security setting not with the FM. Please try as suggested. Or else contact your Basis person.

Regards,

Anubhab

Re: Getting run time error when accessing the file from frontend server using F4.....?

Former Member — Mon, 26 May 2014 10:26:29 GMT

Now that GUI allow and deny is not coming .But the screen is coming like this .

Re: Getting run time error when accessing the file from frontend server using F4.....?

anubhab — Mon, 26 May 2014 10:31:10 GMT

Hi Suresh,

This is simply file type mismatch dialogue. Please check the file extension. Is it in '.XLS' format or something else.

Regards,

Anubhab

Re: Getting run time error when accessing the file from frontend server using F4.....?

pavanm592 — Mon, 26 May 2014 10:37:15 GMT

Hi Suresh,

Please Check the below link, Error opening file: "The file format differs from the format that the file name extension specifies"

are you using Excel 2007 it seems like problem with excel

Regards,

Pavan

Re: Getting run time error when accessing the file from frontend server using F4.....?

Former Member — Mon, 26 May 2014 10:41:26 GMT

Hi Friends,

Thanks for your interest to resolve my issue........... I am using Microsoft excel 2010 .still i am getting the same issue

Regards,

Suresh