Skip to Content
author's profile photo Former Member
0
Former Member

How Extract SAP table without using any RFC/ABAP/BAPI's

Posted on Dec 06, 2004 at 11:56 AM 238 Views

Hello,

I am trying to find a way to extract SAP table information. I have used RFC_GET_TABLE_ENTRIES to get the data from any table. But there are limitations to this approach.

I want to find out if there is any other way to directly access SAP tables through my C# program either using .Net connector or without it.

Thanks in advance.

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

2 Answers

  • author's profile photo Jiri EHRLICH
    Jiri EHRLICH
    Posted on Dec 08, 2004 at 08:12 PM
    0

    Hi Vinay,

    it is a wrong idea! Some of our customers are still thinking in dimension of small database applications!

    SAP WebAS ("SAP basis") has 15-20.000 database tables. There is no public data model. To organize our development we are using business object model with object's methods. You can use BAPIs (or Enterprise Services in future) to call our business objects. Real database table(s) used by method call depends on SAP WebAS release or application release and patch level and customizing but you have still the same method interface.

    Jiri

    Add a comment
    10|10000 characters needed characters exceeded

    • Jiri EHRLICH Former Member
      Dec 09, 2004 at 10:22 AM

      Hi Stefan,

      you are right. We do not offer the same functionality via SAP GUI and via BAPIs in this time (maybe 2006).

      OK, standard way in this case is to create your own function module and declare all your selects inside. The advantage is that you can reduce interface (return selected database fields only). It is a few minutes job, if you know data model.

      Jiri

    Comment on This Answer
  • author's profile photo Former Member
    Former Member
    Posted on Dec 09, 2004 at 12:38 PM
    0

    Hi Jim,

    THe problem with using RFC's or ABAP's is you need upload them to SAP.

    This becomes annoying when especially we want to get data from specific tables.

    Why has SAP provided a RFC_READ_TABLE module which is basically an errorneous program and breaks if something is bigger than 512?

    This means there is need to get the data outside SAP. But it just that this kind of RFC's create confustion among developers like me who would rather stic to C/C++ instead of writing a ABAP and dumping a comma separated data file.

    So i am back to square one. Any one knows how i can extract a particular tables data, selectively by specifying columns and/or where conditions from outside SAP.

    Add a comment
    10|10000 characters needed characters exceeded

    Comment on This Answer

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.