topic select mandt in Application Development and Automation Discussions

select mandt

Former Member — Mon, 11 Dec 2006 14:09:05 GMT

i am working on client 100 and i am using select query to fetch data from client 200 how can i do it using select statement........

regards

martin

Re: select mandt

Former Member — Mon, 11 Dec 2006 14:12:11 GMT

Try

SELECT * from xxxx CLIENT SPECIFIED 
 where mandt = 200 xxxxx

So long...

Re: select mandt

Former Member — Mon, 11 Dec 2006 14:12:35 GMT

Hello

Try like the below.

SELECT * FROM SCUSTOM CLIENT SPECIFIED INTO WA_SCUSTOM

WHERE MANDT = '003'.

WRITE: / WA_SCUSTOM-ID, WA_SCUSTOM-NAME.

ENDSELECT.

If useful reward.

Vasanth

Re: select mandt

Former Member — Mon, 11 Dec 2006 14:17:03 GMT

By default, only data from the current client is selected (without you having to specify the client field specifically in the WHERE clause). If you want to select data from several clients, you must use the ... CLIENT SPECIFIED addition in the FROM clause.

and u can use the SELECT statement as told by others