cancel
Showing results for 
Search instead for 
Did you mean: 

access sap tables directly

Former Member
0 Kudos

hi guys,

i am retrieving data using RFM via jco ,ok fine

but i want to acess the sap tables directly without using functionalmodule's

i know this is bad approach...it is possible means plz send me details....how?

thanks,

tony

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos

Hi Tony,

I dont think so there any other way other than accesing SAP tables directly.

You have to Use either BAPI or Function Modules to get the data from R/3.

regards

Anil Dichpally

Former Member
0 Kudos

The only way to directly access a DB table in SAP is to use a JDBC connection. This bypasses the entire R/3 layer and goes directly to the DB - whatever DB that is - using a java sql driver specific to the DB you're running. I would NOT recommend this for standard tables, but a for a Z-table it might be an option.

This will of course only work if your admins allow you direct access to the DB layer and if you don't breach any security policies...

Below is a link to a jdbc tutorial. Should be quite straighftorward to an experienced java developer.

http://java.sun.com/docs/books/tutorial/jdbc/

regards,

Dion

Former Member
0 Kudos

hi Dion,

plz send me sample code.. to acess sap db directly using jdbc......

thanks,.

Former Member
0 Kudos

hi

i am trying like this using jdbc.... to sap connection

conn = DriverManager.getConnection(

"jdbc:oracle:thin:@10.10.88.111:50000","username","password");

but it is throwing ioException: get minus one from a read call

pls help me....

thanks

Former Member
0 Kudos

it is always possible that you could connect to and modify business data for an application DIRECTLY from backend. if you end up doing that, it defeats the sole purpose of the business application that is built on top of that business data...

Former Member
0 Kudos

hi Joshi,

u given valuable information, so,plz send me one simple sample example

using jdbc driver i have written that one line....is it correct ?

but throwing IOException ....

thanks