‎2008 Dec 17 4:34 PM
Guys,
This is more of a mixed question between ABAP and BI. I am trying ot create an internal table and then fill it with the incoming load. Can someone tell me how to do that including declarations?
Thanks,
RG
‎2008 Dec 17 4:46 PM
REPORT ZdataFromExcel
data: begin of itable occurs 0,
variable1 type char20,
variable2 type char20,
end of itab.
CALL FUNCTION 'GUI_UPLOAD'
EXPORTING
FILENAME = 'C:/myfile.xls'
FILETYPE = 'ASC'
TABLES
DATA_TAB = itable
IF SY-SUBRC 0.
MESSAGE ID SY-MSGID TYPE SY-MSGTY NUMBER SY-MSGNO
WITH SY-MSGV1 SY-MSGV2 SY-MSGV3 SY-MSGV4.
ENDIF.
loop at itable.
write: /10 itable-var1, 30 itable-var2.
endloop.
‎2008 Dec 17 4:46 PM
REPORT ZdataFromExcel
data: begin of itable occurs 0,
variable1 type char20,
variable2 type char20,
end of itab.
CALL FUNCTION 'GUI_UPLOAD'
EXPORTING
FILENAME = 'C:/myfile.xls'
FILETYPE = 'ASC'
TABLES
DATA_TAB = itable
IF SY-SUBRC 0.
MESSAGE ID SY-MSGID TYPE SY-MSGTY NUMBER SY-MSGNO
WITH SY-MSGV1 SY-MSGV2 SY-MSGV3 SY-MSGV4.
ENDIF.
loop at itable.
write: /10 itable-var1, 30 itable-var2.
endloop.
‎2008 Dec 17 6:18 PM
Thanks but I fail to understand in this code, where you are putting data into internal table from datapack?
Thanks,
RG