Regarding update data in database

[Former Member]

Hi Abap Gurus,

i have selection screen such that one list box in that 7 tables are there.

one field for upload the excel file from desktop. my requirement is that when the user click on the field and after upload a Excel file then user select that particular table from list box and after executing the upload data has to be updated in database through posting in transaction VA41. since i am working with Open Contracts.

i found a Bapi Function Module in SDN that is BAPI_CONTRACT_CREATEFROMDATA.

how to approach this issue. simply i cannot use GUI_UPLOAD function module. and BAPI_CONTRACT_CREATEFROMDATA.

<< Do not offer points >>

Edited by: Rob Burbank on Jul 31, 2010 8:53 PM

[former_member182096]

Hi There,

Can you elaborate on your requirement - it just seems like you have all the data required to create the contract in an excel file . So why can you not use the excel file and the BAPI or an LSMW or even a BDC?

Thanks,

Srini

[Former Member]

Hi srinu_varahalu ,

To select and fill the values in the listbox for the table names you can use

TYPE-POOLS : VRM

using this VRM and function module 'VRM_SET_VALUES' you can fill the values in the listbox.

Now using the report events select the particular table, then you can go for uploading the data by using BDC, LSMW or any function module.

Thanks,

Thanesh