select mandt

[Former Member]

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

[Former Member]

Try

SELECT * from xxxx CLIENT SPECIFIED 
 where mandt = 200 xxxxx

So long...

[Former Member]

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

[Former Member]

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