Solved: Getting run time error when accessing the file fro...

Former Member · ‎2014 May 26

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

Former Member · ‎2015 Apr 03

Hello Suresh,

This is because of the excel sheet number format. Just go to excel sheet and chech whether numeric fields are coming with ','(comma) sign for number greater than 999. If it does right click on the column and change the format to Numeric.

Regards,

Sana Khan

anubhab · ‎2014 May 26

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

Former Member · ‎2014 May 26

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.

anubhab · ‎2014 May 26

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

pavanm592 · ‎2014 May 26

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

RaymondGiuseppi · ‎2014 May 26

Define your fields respecting the FM signature.

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

Regards,

Raymond

Mohamed_Mukhtar · ‎2014 May 26

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

Former Member · ‎2014 May 26

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

anubhab · ‎2014 May 26

Hi Suresh,

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

Regards,

Anubhab

Former Member · ‎2014 May 26

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

Former Member · ‎2014 May 26

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

anubhab · ‎2014 May 26

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

Former Member · ‎2014 May 26

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

pavanm592 · ‎2014 May 26

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

anubhab · ‎2014 May 26

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

Former Member · ‎2014 May 26

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

anubhab · ‎2014 May 26

Hi Suresh,

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

Regards,

Anubhab

pavanm592 · ‎2014 May 26

Hi Suresh,

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

are you using Excel 2007 it seems like problem with excel

Regards,

Pavan

Former Member · ‎2014 May 26

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

Former Member · ‎2014 May 26

It Is in .XLS format only Chirui.

Regards,

Suresh

pavanm592 · ‎2014 May 26

Hi,

After you click on YES is the data is read from the excel or what is happening after that?

Try this one too..

Click Start, click Run, type regedit.exe and press ENTER. This will open
your Registry.
Navigate to -
HKEY_CURRENT_USER\SOFTWARE\MICROSOFT\OFFICE\12.0\EXCEL\SECURITY
Right click in the right window and choose New -> DWORD
In the Name field, type - ExtensionHardening
Verify that the data has the value 0

Regards,

Pavan

anubhab · ‎2014 May 26

Hi Suresh,

Can you please check the file name parameter in the FM, what value you are getting there.

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.

Check in debugger once if it's taking proper file name with extension. Likely it should hold the value: "C:\User\SAP\Desktop\MIGO\Data template for Goods Movement_TRC_v1.xls". Try changing file format to .XLS, rather than .XLSX. I can see in one of your previous screen shot that the file extension is .XLSX.

Regards,

Anubhab

Former Member · ‎2014 May 26

I changed it to .xls and tried still same result.

let me check with the basis and IT guys whether they can do fix something for this.

I wil get back with the result.

Regards,

Suresh

RaymondGiuseppi · ‎2014 May 26

Is the file a true XLS/XLSX file or actually a flat ascii format (e.g. csv) in disguise ?

(Reference : Error opening file: "The file format differs from the format that the file name extension specifies")

Regards,

Raymond

nabheetscn · ‎2014 May 26

Suresh

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

Nabheet

Former Member · ‎2014 May 26

Hi Suresh,

You need to declare all your local structure components of CHAR type of respective lengths!

I see from your local structure declaration that you have declared WBS element with type being PS_POSID, this a numeric value! Wherever you have used DDIC data element just check as to whether they are CHAR type or not.

For use of function module 'TEXT_CONVERT_XLS_TO_SAP' you need to have all your internal table components of CHAR type.

Cheers,

Varun

Former Member · ‎2015 Apr 03

Hello Suresh,

This is because of the excel sheet number format. Just go to excel sheet and chech whether numeric fields are coming with ','(comma) sign for number greater than 999. If it does right click on the column and change the format to Numeric.

Regards,

Sana Khan

former_member658440 · ‎2019 Nov 20

Hi,

using FM F4_FILENAME- leads to short dump. this FM I have used to open the file path using help f4 option. could anyone please help me out to solve the issue!

By Category

Related Content

Activity Groups

Industry Groups

Influence and Feedback Groups

Interest Groups

Location Groups

Customer Only Groups

Forums

Related Resources

Products

Learning and Support

About

My SAP Profile

My SAP Profile

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