Access SAP data from xMII 12.1 without RFC or JCO

[Former Member]

Hi All,

Is it possible to access/get data from SAP in xMII without RFC/ JCO call?

Let me know if there is other option available..

Regards,

Sachin

[jcgood25 · Accepted solution]

Out of curiosity, why would you not choose the traditional methods?

[Former Member · Accepted solution]

Hi All,

Thanks for providing options.

Hi Christian,

can you please explain the way to access SAP database directly with example?

It will be very helpfull for me.

Hi Jeremy,

As i want to remove dependency of SAP development team i am looking for other options.

As per my understanding for RFC/JCO call some function has to be created in SAP which we call from transaction.

i want to access SAP database directly.

Please provide some info on same.

Thanks & Regards,

Sachin

[agentry_src · Accepted solution]

I think you misunderstand how the JCO/JRA interface is used.

Most functions that you need already exist in the BAPI/RFC library of standard function modules. Look under SAP T-code SE37 or BAPI (for just the bapis). If a standard RFC or BAPI does not exist for your purposes, you could then look at making your own. But before you go to custom development take a look at using RFC_READ_TABLE to do your direct table reads through a JCO/JRA connector.

Good luck,

Mike

[sidnooradarsh · Accepted solution]

Sachin,

As far my knowledge goes the primarily used forms of achieving MII to ERP connectivity,

1) MII -- ERP (via RFC, IDOC's, BAPI's)

2) MII -- PI(XI) -- ERP

3) MII -- ESR -- ERP (Web-services)

But, I completely concur with Mike on this, you do not need to create any function modules unless you have no other choice.

Check this link for List of Bapi's available and their description

[BAPI List|http://www.sapbapi.com/bapi-list/]

If none of the BAPI's really meets your requirement then you can go for "RFC_READ_TABLE" this RFC accepts the SAP table name and desired column names. (in a way you will be accessing the SAP DB you are looking for...)

Yet, if none of the above options suffices your requirement only then you go for writing a custom Function module.

[Writing Function Module|http://abaplovers.blogspot.com/2008/02/creating-function-module-in-sap-abap.html]

Good Luck!!

Regards,

Adarsh

[agentry_src · Accepted solution]

Hi Sachin,

If you do decide to use RFC_READ_TABLE, there are a lot of good postings in this forum, but many of them will be more than 3 months old, so change your search date range to include all dates. Some of the best are from over a year ago.

Regards,

Mike

[Former Member]

Sachin,

I guess you know the [JRA call|http://help.sap.com/saphelp_mii122/helpdata/en/44/c5e701054c388ce10000000a11466f/frameset.html]?

You may also customize a web service in SAP: [SOAP Runtime for the SAP Web AS|http://help.sap.com/saphelp_srm40/helpdata/en/94/f8c8c0e68811d6b2dc00508b5d5211/frameset.htm] which can be called from MII using the webservice action,

Michael

[Former Member]

You may also be able to access the SAP database directly. I have never seen this done with MII however, and I think it requires a special driver.

[Former Member]

IDoc, Webservice call?