topic Reg:excel sheet data upload with GB01 Application in Application Development and Automation Discussions

Reg:excel sheet data upload with GB01 Application

Former Member — Tue, 02 Dec 2008 15:42:18 GMT

Hi All,

I have to upload GB01 application data through Excel Sheet.

So that Which is Better Method for uploading in GB01 appli?

Plz anybody can suggest me

Advance Thanks

Re: Reg:excel sheet data upload with GB01 Application

Former Member — Tue, 02 Dec 2008 15:52:33 GMT

I think you can perform BDC on this transaction code. Go to SHDB, and do the recording of this transaction code and then Generate a program from the recording. You have an option to do it in the tcode SHDB.

Then in that program, Use ALSM_EXCEL_TO_INTERNAL_TABLE..to upload the excel sheet into internal table.

Then, in the code generated, pass on the internal table values to the sub routines.

For sample code for the above FM, please search in ABAP General or in this forum. Also, you will get sample code for BDC if you do some search.

Regards,

Vishwa.

Re: Reg:excel sheet data upload with GB01 Application

Former Member — Tue, 02 Dec 2008 16:23:22 GMT

use function modules JV_GB01_DIRECT_INPUT and JV_GB01_DOCUMENT_POST

Re: Reg:excel sheet data upload with GB01 Application

Former Member — Wed, 03 Dec 2008 05:24:25 GMT

use LSMW it is very easy to handle

Re: Reg:excel sheet data upload with GB01 Application

abdul_hakim — Wed, 03 Dec 2008 05:46:27 GMT

Check whether any standard transfer program exists for this else check for LSMW else finally go for recording of the transaction and create your own batch input program.

Cheers,

Hakim

Re: Reg:excel sheet data upload with GB01 Application

Former Member — Thu, 04 Dec 2008 04:31:04 GMT

Hi,

Plz give me the Suggestion How we Use those Function Modules.

Thanks