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
Bluesky
