DATA : l_file TYPE rlgrap-filename,
row TYPE i VALUE 1,
p_ifile type rlgrap-filename value 'c://documents and setting/input.xls',
t_tab type standard table of alsmex_tabline
col TYPE i VALUE 1,
rowsize TYPE i VALUE 4000,
columno TYPE i VALUE 40.
CALL FUNCTION 'ALSM_EXCEL_TO_INTERNAL_TABLE'
EXPORTING
filename = p_ifile
i_begin_col = col
i_begin_row = row
i_end_col = columno
i_end_row = rowsize
TABLES
intern = t_tab
EXCEPTIONS
inconsistent_parameters = 1
upload_ole = 2
OTHERS = 3.
IF sy-subrc <> 0.
Write : / ,'Load failed'.
ENDIF.
Showing posts with label ABAP Programming. Show all posts
Showing posts with label ABAP Programming. Show all posts
Friday, August 28, 2009
Thursday, August 27, 2009
The Transactions and tables I have used
AL11--> It shows the directories in SAP system.
SM35------> To check the session overview. You can check the status of your request here.
SM36-----> Create a schedule for a program.
SM37-----> Check the scheduling of various jobs and edit it.
File-----> Here you can check the logical file path of any file. Or you can create one.
SHDB----> This is a transaction by which you can record the other transactions. I am still in the process of learning it. will post more shortly ....
SM35------> To check the session overview. You can check the status of your request here.
SM36-----> Create a schedule for a program.
SM37-----> Check the scheduling of various jobs and edit it.
File-----> Here you can check the logical file path of any file. Or you can create one.
SHDB----> This is a transaction by which you can record the other transactions. I am still in the process of learning it. will post more shortly ....
tptco---> job scheduling
tbtcp --> Table that contains information about scheduled job.
Labels:
ABAP Programming,
ABAP Tables,
SAP ABAP,
Transactions-ABAP
Subscribe to:
Posts (Atom)