topic Re: Regarding update data in database in Application Development and Automation Discussions

Regarding update data in database

Former Member — Sat, 31 Jul 2010 04:26:50 GMT

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

Re: Regarding update data in database

former_member182096 — Sun, 01 Aug 2010 05:22:04 GMT

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

Re: Regarding update data in database

Former Member — Sun, 01 Aug 2010 06:36:02 GMT

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