topic Re: Can access subsystem table from a server ? in Application Development and Automation Discussions

Can access subsystem table from a server ?

Former Member — Thu, 17 Dec 2009 11:05:49 GMT

Hi Everyone,

My Thread subject may not be clear sorry about that, actually my requirement is there is a server say DEV, this DEV system has

two SubSystems DSM and DCO. Here i am executing a program in DEV System and want to know if there is any way to access

a table entry from DSM System.I want to know whether this requirement can be done using ABAP or not . Kindly advice on

this..Waiting for your suggestions..

Thanks,

subash

Re: Can access subsystem table from a server ?

Former Member — Thu, 17 Dec 2009 11:22:43 GMT

Hi,

If there are two clients in a server, you can get acess the other clients data by specifying CLIENT SPECIFIED addition in your select statement.

SELECT * FROM table CLIENT SPECIFIED INTO wa WHERE MANDT = MANDT . " mandt is other client number

Regards,

Ravi

Re: Can access subsystem table from a server ?

christine_evans — Thu, 17 Dec 2009 11:49:02 GMT

I don't think he means clients. I think he means system names. In Oracle for example you can have several systems sitting in the same database and you can access one from the other if the username you are using has connect to that system and you specifiy the system name before the table name eg SELECT * FROM DSM.TABNAME;. I think it is unlikely that you can do something like this in Open SQL or from within the SAP system though I guess it might be possible using real SQL. In any case, it would all depend on the database accesses and you'd need to check with BASIS about that.