Showing posts with label ABAP Programming. Show all posts
Showing posts with label ABAP Programming. Show all posts

Friday, August 28, 2009

Code snippet for ALSM_EXCEL_TO_SAP

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.

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 ....


tptco---> job scheduling

tbtcp --> Table that contains information about scheduled job.