Regarding upload program

Former Member — Thu, 23 Oct 2014 14:13:18 GMT

Dear Experts,

I'm new to abap and i'm trying to create an upload program where the data needs to updated in the z table . But while executing , the below error is displayed.

Error :

"GS_ACTUAL" may not be converted into a number"

Coding is as below. Request help on the clearing the below.

REPORT ZPP_UPLOAD_PROGRAM.

TYPE-POOLS TRUXS.
TABLES : ZPP_ACTUAL_PRD.

TYPES : BEGIN OF TY_ACTUAL,
         KDAUF TYPE KDAUF,
         KDPOS TYPE KDPOS,
         WERKS TYPE WERKS_D,
         RFID TYPE ZRFID,
         PROCTYP TYPE ZDE_PP_PROCTYP,
         PROCSEQ TYPE ZDE_PP_PROCSEQ,
         AUFNR TYPE AUFNR,
         VORNR TYPE VORNR,
         WORK_CNTR TYPE ARBPL,
         MATNR TYPE MATNR,
         J_3ASIZE TYPE J_3ASIZE,
         MENGE TYPE MENGE_D,
         MEINS TYPE MEINS,
         STKCATG TYPE J_4KSCAT,
         CHUNM TYPE CHUSER,
         CHDAT TYPE CHDATE,
    MARKER_NAME TYPE ZMARKER_NAME,
    DISP_NAME TYPE ZDISP_NAME,

   END OF TY_ACTUAL.

DATA : GT_ACTUAL TYPE TABLE OF TY_ACTUAL,
        GS_ACTUAL TYPE TY_ACTUAL.

DATA : GT_RAW TYPE TRUXS_T_TEXT_DATA.

PARAMETERS : P_FILE TYPE RLGRAP-FILENAME.

AT SELECTION-SCREEN ON VALUE-REQUEST FOR P_FILE.
   CALL FUNCTION 'F4_FILENAME'
     EXPORTING
*     PROGRAM_NAME = SYST-CPROG
*     DYNPRO_NUMBER = SYST-DYNNR
       FIELD_NAME    = 'P_FILE'
     IMPORTING
       FILE_NAME     = P_FILE.

START-OF-SELECTION.

   CALL FUNCTION 'TEXT_CONVERT_XLS_TO_SAP'
     EXPORTING
*     I_FIELD_SEPERATOR    =
*     I_LINE_HEADER        = 'X'
       I_TAB_RAW_DATA       = GT_RAW
       I_FILENAME           = P_FILE
     TABLES
       I_TAB_CONVERTED_DATA = GT_ACTUAL[]
     EXCEPTIONS
       CONVERSION_FAILED    = 1
       OTHERS               = 2.

   IF SY-SUBRC NE 0.
     MESSAGE ID SY-MSGID
             TYPE SY-MSGTY
             NUMBER SY-MSGNO
             WITH SY-MSGV1 SY-MSGV2 SY-MSGV3 SY-MSGV4.
   ENDIF.

END-OF-SELECTION.

   LOOP AT GT_ACTUAL TO GS_ACTUAL.
     ZPP_ACTUAL_PRD-KDAUF = GS_ACTUAL-KDAUF.
     ZPP_ACTUAL_PRD-KDPOS = GS_ACTUAL-KDPOS.
     ZPP_ACTUAL_PRD-WERKS = GS_ACTUAL-WERKS.
     ZPP_ACTUAL_PRD-RFID = GS_ACTUAL-RFID.
     ZPP_ACTUAL_PRD-PROCTYP = GS_ACTUAL-PROCTYP.
     ZPP_ACTUAL_PRD-PROCSEQ = GS_ACTUAL-PROCSEQ.
     ZPP_ACTUAL_PRD-AUFNR = GS_ACTUAL-AUFNR.

     MODIFY ZPP_ACTUAL_PRD.
   ENDLOOP.

Best rgds/thnks,

Srikanth

Re: Regarding upload program

Former Member — Thu, 23 Oct 2014 14:23:56 GMT

may be your table fields are not matching type fields.

Please check it.

Re: Regarding upload program

Former Member — Thu, 23 Oct 2014 14:24:17 GMT

Hi,

try LOOP AT GT_ACTUAL INTO GS_ACTUAL

instead of LOOP AT GT_ACTUAL TO GS_ACTUAL.

Or can you mark the line, that contains the error?

If you double click on the syntax-check-messagline, the Cursor is set on this line..

Regards

Jan Martin

Re: Regarding upload program

Former Member — Thu, 23 Oct 2014 14:24:39 GMT

On what line do you get the error?

Without knowing that, I'm guessing that your data is not parsing into the correct fields. Typically when I upload, I upload into a long string and then parse the string into the structure.

Neal

Re: Regarding upload program

Former Member — Thu, 23 Oct 2014 14:26:42 GMT

Dear Jan ,

Thanks you very much.

Best rgds/thnks,

Srikanth.

topic Re: Regarding upload program in Application Development and Automation Discussions

Regarding upload program

Re: Regarding upload program

Re: Regarding upload program

Re: Regarding upload program

Re: Regarding upload program