‎2008 Jun 12 1:37 PM
Is there any website link where I can get information about all the functions used in ABAP...
EX: I want to know the export,import,...parametes of the function "ALSM_EXCEL_TO_INTERNAL_TABLE"....?
‎2008 Jun 12 6:58 PM
Hi SRK,
Please check this link
SAP Function Module Documentation Repository
(WWW.SE37.COM)
Here u need to give the Function module name then u get description of the function module
and the paremeters of the function module.
For some function modules u get the description in german language.
For ALSM_EXCEL_TO_INTERNAL_TABLE u can see
Description Language
Datenübernahme aus Excel mit OLE - Konvertierung ins interne Format German Now click on German. Now u get the Description and parameters in German language.
But for Some function modules u get in English itself.
Ex:
REUSE_ALV_GRID_DISPLAY
REUSE_ALV_LIST_DISPLAY
HR_READ_INFOTYPE
BAPI_GOODSMVT_CREATE
BAPI_PRODCAT_GETPRICES
Best regards,
raam
‎2008 Jun 12 1:40 PM
hi,
u can check the import and export parameters of ALSM_EXCEL_TO_INTERNAL_TABLE in se37.
all function modules r stored in TFDIR table.
<REMOVED BY MODERATOR>
Edited by: Alvaro Tejada Galindo on Jun 12, 2008 1:42 PM
‎2008 Jun 12 1:42 PM
Hi,
Go to se37 (function Builder), there give Function Module name and click on display. u can find all the import , export parameters. some FM have documentation as well to the right hand side top corner. check it out. i think this will help u.
Rgds.,
subash.
‎2008 Jun 12 1:43 PM
hi
link for list of FMs
its very helpful check this out
http://www.sapbrainsonline.com/REFERENCES/FunctionModules/SAP_function_modules_list.html
check this prog donot forget to prepare a flat file
TYPES: BEGIN OF ty_mara,
matnr LIKE mara-matnr,
mbrsh LIKE mara-mbrsh,
mtart LIKE mara-mtart,
maktx LIKE makt-maktx,
meins LIKE mara-meins,
END OF ty_mara.
DATA: it_mara TYPE table of ty_mara WITH HEADER LINE.
parameters : p_file like RLGRAP-FILENAME.
data : itab type table of ALSMEX_TABLINE WITH HEADER LINE.
start-of-selection.
CALL FUNCTION 'ALSM_EXCEL_TO_INTERNAL_TABLE'
EXPORTING
filename = p_file
i_begin_col = 1
i_begin_row = 1
i_end_col = 5
i_end_row = 4
tables
intern = itab.
loop at itab.
CASE ITAB-COL.
WHEN '1'.
it_mara-matnr = ITAB-VALUE.
WHEN '2'.
it_mara-mbrsh = ITAB-VALUE.
WHEN '3'.
it_mara-mbrsh = ITAB-VALUE.
WHEN '4'.
it_mara-maktx = ITAB-VALUE.
WHEN '5'.
it_mara-meins = ITAB-VALUE.
ENDCASE.
AT END OF ROW.
APPEND it_mara.
CLEAR it_mara.
ENDAT.
endloop.
Edited by: prasanth kasturi on Jun 12, 2008 3:01 PM
‎2008 Jun 12 1:44 PM
tfdir, "Function Module
enlfdir, "Additional Attributes for Function Modules
‎2008 Jun 12 1:46 PM
it wud b okay if i have the SAP installed in the system...
im asking for any other alternative apart from this?
‎2008 Jun 12 1:47 PM
CALL FUNCTION 'KCD_EXCEL_OLE_TO_INT_CONVERT'
EXPORTING
filename = <filename>
i_begin_col = 1
i_begin_row = 1
i_end_col = 10
i_end_row = 65536
TABLES
intern = <internal table>
This depends on the excel as well.
65536 is the max number of rows in the sheet.
<REMOVED BY MODERATOR>
Thanks,
Kartavya
Edited by: Alvaro Tejada Galindo on Jun 12, 2008 1:42 PM
‎2008 Jun 12 1:47 PM
hii
pass following data
ls_excel TYPE alsmex_tabline,
" Work Area to hold Rows for Table
" with Excel Data
CALL FUNCTION 'ALSM_EXCEL_TO_INTERNAL_TABLE'
EXPORTING
filename = p_pfile
i_begin_col = 1
i_begin_row = 2
i_end_col = 45
i_end_row = 8
TABLES
intern = it_excel
EXCEPTIONS
inconsistent_parameters = 1
upload_ole = 2
OTHERS = 3.
IF sy-subrc <> 0.<REMOVED BY MODERATOR>
thx
twinkal
Edited by: Alvaro Tejada Galindo on Jun 12, 2008 1:42 PM
‎2008 Jun 12 6:58 PM
Hi SRK,
Please check this link
SAP Function Module Documentation Repository
(WWW.SE37.COM)
Here u need to give the Function module name then u get description of the function module
and the paremeters of the function module.
For some function modules u get the description in german language.
For ALSM_EXCEL_TO_INTERNAL_TABLE u can see
Description Language
Datenübernahme aus Excel mit OLE - Konvertierung ins interne Format German Now click on German. Now u get the Description and parameters in German language.
But for Some function modules u get in English itself.
Ex:
REUSE_ALV_GRID_DISPLAY
REUSE_ALV_LIST_DISPLAY
HR_READ_INFOTYPE
BAPI_GOODSMVT_CREATE
BAPI_PRODCAT_GETPRICES
Best regards,
raam
‎2008 Jun 12 7:40 PM
here is the description for the function modules with their name