Uploading data to SAP R/3 without enabling SAP Scripting

Uploading data to SAP R/3 without enabling SAP Scripting

I am trying to upload data into an SAP R/3 system. However, SAP Scripting is not enabled. Still, I want to upload the data. How can I do this without using any software other than Excel and VBA?

    Requires Free Membership to View

    When you register, you will start receiving targeted emails from my award-winning team of editorial writers. Our goal is to keep you informed on the hottest topics and biggest challenges faced by SAP professionals today.

    Hannah Smalltree, Editorial Director

    By submitting your registration information to SearchSAP.com you agree to receive email communications from TechTarget and TechTarget partners. We encourage you to read our Privacy Policy which contains important disclosures about how we collect and use your registration and other information. If you reside outside of the United States, by submitting this registration information you consent to having your personal data transferred to and processed in the United States. Your use of SearchSAP.com is governed by our Terms of Use. You may contact us at webmaster@TechTarget.com.

Data connectivity with SAP is done usually via RFC directly from the machine you are working on. You can write simple VBA scripts that connect to R/3 via RFC. There is a set of DLL on your Windows machine that is installed along with SAPGUI; this is the proxy bridge to SAP.

To upload data, you only need an RFC enabled function in SAP that receives the data for you.

Alternatively, you can write a small BSP page in SAP and send data via HTTP; that way, you will not need anything installed on the client.

Click here for a very old document of mine that describes in detail how it works.

This was first published in June 2010

Join the conversationComment

Share
Comments

    Results

    Contribute to the conversation

    All fields are required. Comments will appear at the bottom of the article.