Copy Data from Excel 2003 and paste into SAP

See if this is of any help.

http://www.excelforum.com/excel-programming/646670-connection-with-sap.html

Thanks guys, for the response!

@Daniel - Yes, the solution need not be VBA based. I just said VBA coz i know little bit of VBA, so i can tweak if any similar solution already exists. I will try the utilities you have mentioned above tomorrow at my office (im not very familiar with SAP, so i'll ask someone else to help me out on that).


@ssaqibh - I had already seen that link (from google), but couldn't understand the code given at the bottom of that page. Could you explain? And can it be modified to paste the data and save in SAP?


Regards,
Vikrant.

I dont have SAP. If you have SAP then see if it has an option to record a macro. If yes then maybe I can guide you there.

Saqib

Saqib, SAP has something similar to Macro (i dont know what it is called) but the end user (here, me) doesn't have the authorization to create one. And, it is a long process to ask the IT people to create a similar thing in SAP and requires lot of approvals from the top management.
That is why i was thinking for any possibility of controlling few SAP commands from VBA.

I think your best of using some of the import tools rather than a script. Check them out first, if they're useless to you we can see if we can script our way out of it.

If you don't have authorization to create scripts in SAP itself you should step carefully if you want to use VBA.

They might not like that too much, it might even breach security.

If you can use VBA then you might want to check if you can automate SAP from it in someway.

I don't know if you can with SAP but you can with plenty of other applications.

From the link I provided above it is evident that VBA can access SAP. So now we somehow have to find the command which would either post a value or paste a value in SAP for which I was hoping a macro recorder could do the trick.

Hello all,

<<They might not like that too much, it might even breach security.>>
That's what i was told by few of my colleagues here, followed by the suggestion of dropping the plan!


<<If you can use VBA then you might want to check if you can automate SAP from it in someway.>>
Automate SAP.... This is the precise thing that i want to do but couldn't find good literature of examples on the net.


And Saqib, in the link you have provided, (i'm just guessing) the code at the bottom checks if SAPLogon is installed or not and may be opens the SAP GUI if its installed. I couldn't find any more such examples on google where SAP is involved with VBA.

One more thing i found in VB Editor is, when we go to Tools >> References, there are lots of SAP related references available which hints me that there should be an option to control SAP from VBA. But the question is HOW?



Tils.

What transaction code are you using? May be you can consider using simple ABAP program to upload to SAP.

Hello all.

Sorry for leaving the question idle, had a long 3-day weekend :)


@ssaqibh: The link that you gave me, contains some SAP Script. I could understand only few lines! I'm a novice in SAP and don't have a programming background, so have no clue on how to use it :(


@chwong67: I'm using VK11.



Tils.

If you have ABAP programmer, it is easier to upload data from excel in prn format.
Please refer to the link below for more information:
https://forums.sme.sap.com/message.jspa?messageID=3031758

Hi,

are you sure that the file contains the data you need?

There is a report (Transaktion SA38 -> Report RV14BTCI) for mass input ...

Please check the [i] (Info Button for this report ...

Best regards
gnurl

Hi all,

@Chowng67: I dont have ABAP Programmer in my office :(

@gnurl: I'm on a Business Trip now, so won't have access to SAP. I'll get back to you on that, this coming monday.


Thanks,
Tils.

Hi,
I think that the following link will help you solve your problem:

http://help.sap.com/saphelp_46c/helpdata/en/70/93a417ecf411d296400000e82debf7/content.htm

Hello all,

@gnurl: I just checked, I'm not authorized to use the Transaction SA38. Any other option possible?

@Murhaf Khaled: I'm not sure if that helps! Could you explain further?


Thanks,
Tils.

Hi Tils,

could you explain the problem to your permissons guy (enter 20000 lines of data to sap is worth to change the permission even if temporarely)? Maybe you could get the permission ... an other way would be transaction SE38 but this permission should have been used more restrictively than SA38!

Good luck
gnurl

Hi gnurl,

I was just tryin to play with the Recorder option of SAP and it again said im not authorised to do so.... :(
As of now, since i had no other option, i had to appoint a group of people to upload the data, which took them around 4.5 hours. But after a few days, we might have to do a similar exercise. So, we are going to go for either having enough authorisations or something called as "BDC" which allows mass data entry.

Could you please show me your input screen dump?
May be I can help you with simple ABAP Batch upload program...

@chwong67: This explains my current procedure.
Excel-to-SAP.xls

I need the following informations from input screen:
1. System->Status: write down 'Transaction' information.
2. Place the cursor on respective field, Press F1, click 'Technical Info'  and write down 'screen field' information.

Here is the "system status" screen.
Tell me for which all fields do you need the "technical info"?


Thanks
Tils.

Forgot to attach the file.
Here it is!
System-Status.xls

Transaction ZJOB is customized Transaction Code.
The steps to follow to get the field information:
1. Place the cursor on respective field, i.e. Group Code,
2. Press F1, and then click 'Technical Info'
3.Write down 'screen field' information or Print Screen.
4. Repeat Step 1-3 for Job Code, Description, ManPower.
I believe this table is customized table...

Yes, ZJOB is a customized T-code and the table is also a customized one.

Below are the screen field details for Group Code, Job Code, Material Description, Man hours (in the same order):
ZSD_JOBCODE_MAST-GROUP_CODE
ZSD_JOBCODE_MAST-JOB_CODE
ZSD_JOBCODE_MAST-JOB_DESC
ZSD_JOBCODE_MAST-MAN_HOURS



Tils.

Since the table is customized table, you can write directly to the table ZSD_JOBCODE_MAST...
Before that, the program need to check valid Group Code, Job Code?
Please provide also table structure:
SE11->Database name: ZSD_JOBCODE_MAST->Click Display->print screen

Hi gnurl & Chwong67,

Thanks a lot for that code Chwong67. BUT, I do not have all required authorizations!! :(
whenever I try doing something in SAP, it stops me from doing so.

On further discussion with my colleagues, I found out that in my organization, they have very strict policies about SAP accounts/authorizations. Each account to be created requires lot of permissions and for the existing accounts, adding more transactions require further approvals.


Tils.

Hi Chowng67,


Changing the screen resolution, this seems to be the only way out for now. It will reduce my data entry time by more than 20%!


Thanks,
Tils.

It's my pleasure to help you... If you do not have any other issue, please close this message. Thanks...

will do it soon!

Thank you all for your efforts and solutions.
Really appreciate.


Regards,
Tils.