SAP Library - Find your answers

Hi Rohan,
You need to call two function modules, first is (KD_GET_FILENAME_ON_F4). In this, u have to pass excel file name with extention(abc.xls)and the second one is (ALSM_EXCEL_TO_INTERNAL_TABLE).
In this, u need to pass the row and column address of the .xls file.
like: first one:-
CALL FUNCTION 'KD_GET_FILENAME_ON_F4'
EXPORTING
mask = '*.xls'
static = 'X'
CHANGING
file_name = filename.
second one:-
CALL FUNCTION 'ALSM_EXCEL_TO_INTERNAL_TABLE'
EXPORTING
filename = filename
i_begin_col = begcol
i_begin_row = begrow
i_end_col = endcol
i_end_row = endrow
TABLES
intern = intern
EXCEPTIONS
inconsistent_parameters = 1
upload_ole = 2
OTHERS = 3.


On Fri, 26 Jun 2009 19:52:00 +0530 wrote
>
>
>Hi,
>I have to make a BDC to create purchase order.I have already done the BDC recording for that.When i run the BDC for P.O Creation,if there are more than one item in a P.O,BDC is creating P.O for every material.Kindly help me on this,how can i upload the excel in one go for one P.O? and please tell me if i can do this with BAPI and the method too? __.____._