Application Development and Automation Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 
Read only

Upload multiple journals via Excel

Former Member
0 Likes
488

Dear All,

I want to Upload multiple journals via Excel file into SAP.

Will you please let me know how to do this, it would be greatfull if you can send some code.

Thanks in Advacne,

Ramana

1 ACCEPTED SOLUTION
Read only

Former Member
0 Likes
459

Hi,

use your "normal" upload and after OPEN set this:

  • Set First Workdsheeet

CALL METHOD OF H_EXCEL 'Worksheets' = H_WORK EXPORTING #1 = 1.

PERFORM ERR_HDL.

CALL METHOD OF H_WORK 'Activate'.

PERFORM ERR_HDL.

Hope it helps.

Regards, Dieter

Dear All,

I want to Upload multiple journals via Excel file into SAP.

Will you please let me know how to do this, it would be greatfull if you can send some code.

Thanks in Advacne,

Ramana

2 REPLIES 2
Read only

Former Member
0 Likes
460

Hi,

use your "normal" upload and after OPEN set this:

  • Set First Workdsheeet

CALL METHOD OF H_EXCEL 'Worksheets' = H_WORK EXPORTING #1 = 1.

PERFORM ERR_HDL.

CALL METHOD OF H_WORK 'Activate'.

PERFORM ERR_HDL.

Hope it helps.

Regards, Dieter

Read only

Former Member
0 Likes
459

Hi,

Check the following link it may help you:

Regards,

Bhaskar