Skip to Content
avatar image
Former Member

Updating and Deleting Rows in the SAP database table using ASP.NET

Hello,

I am kalyan. I am a .net developer. And I know nothing about SAP. I request you to please help me in this regard.

I want to create a webform ( using asp.net, c#.net and visual studio 2008).where it takes the input from the user and compares it with the data in the tables in SAP R/3 ( Version: 4.7).

I want to access the tables in SAP R/3 and retrieve the rows onto the webform and I want to update / delete the rows in the table in SAP R/3 4.7.

My question is

1) Can I access the SAP R/3 tables using Visual Studio 2008?

2) And Can I update and Delete the rows in the Table of SAP?

3) Are there any Third party tools to connect to SAP database tables and edit the rows of the tables?

4) And I heard that If there is a web service in SAP .. I can call that web service from asp.net and retrieve the data.

But, my question is can I update the data on the Table?

5) I read some article. And according to it SAP connector is only compatible with .NET framework 1.1 and visual studio 2003. So, what is the best and reliable way to connect to SAP database?

All the above questions are kind of weird. But, I am trying to find a solution from the past 10days and I can't find any solution. Please help in this regard.

Thank you.

Regards,

Kalyan

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

3 Answers

  • Best Answer
    avatar image
    Former Member
    Mar 26, 2009 at 04:43 AM

    1) Yes

    2) you can but not directly on table ,you have to use RFC..

    3) No need of third party tool

    4) yes , you can do this by consuming enterprise services.

    5) use the wrapper class on the .Net connector.

    give your exact requirement,what is your business process ,e.g. which transaction or table you want to access from SAP,

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Oct 21, 2011 at 09:23 AM

    Hello,

    Can someone post an example on how to use transactions to update, delete or insert a new row in SAP tables using SAP.NET connector 3.0?

    Thanks

    Edited by: unosinu on Oct 21, 2011 11:24 AM

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    May 24, 2013 at 09:10 AM

    Hi kalz rnv,

    Even i have same scenario as yours, where in i have to create website on which there is 1 inquiry form where user will fill form and submit it, then all the details should be updated to SAP database.

    As your scenario is same as ours, can u please provide all the information from the initial step if u have done with your scenario.

    Thanks & regards,

    Anil Anchan

    Add comment
    10|10000 characters needed characters exceeded