Can access subsystem table from a server ?

[Former Member]

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

[Former Member]

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

[christine_evans]

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.