XI--->R/3 scenario: directly access and query a Y-table in R/3

[Former Member]

Hi forum,

I need to make a XI--->R/3 scenario, i want to access and query a table in R/3 (a Y transparent table),

i have been suggested to use a Sysnchronous call to BAPI/Function module, but i want to know whether there's a way i can access/query a Y-Table in the R/3 directly without using a function module in it,

[Former Member]

hi sudeep,

to access a table in r/3 u can either go for an rfc or a server proxy.

>>whether there's a way i can access/query a Y-Table in the R/3 directly without using a function module in it,

do u mean querying the database directly? u "can" ofcourse do it but <b>shud never</b> access r/3 database directly.

[reward if helpful]

regards,

latika.

[Former Member]

thanks latika,

<<do u mean querying the database directly? u "can" ofcourse do it but shud never access r/3 database directly.>>

how can i use the option from my XI

[Former Member]

hey u can access r/3 database like u access other database... u need proper authorizations for it...

but y do u want to access the databse from xi? as its not the best practice. r/3 database shud be accessed by the r/3 application layer which is meant for it.

[Former Member]

Latika,

I just want to know how its possible...pls help

[Former Member]

>>> just want to know how its possible...

using JDBC adapters. Buat as pointed out never even try this in a PROD environment.

Regards,

Jai Shankar

[Former Member]

by using jdbc adapter. u need authorization for the same and know the schema where r/3 tables are created.

regards,

latika.