Reg:excel sheet data upload with GB01 Application

[Former Member]

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

[Former Member]

Hi

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.

[Former Member]

use function modules JV_GB01_DIRECT_INPUT and JV_GB01_DOCUMENT_POST

[Former Member]

Hi,

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

Thanks

[Former Member]

hi

use LSMW it is very easy to handle

[abdul_hakim]

Hi

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