12-11-2006 2:09 PM
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
12-11-2006 2:12 PM
Try
SELECT * from xxxx CLIENT SPECIFIED
where mandt = 200 xxxxx
So long...
12-11-2006 2:12 PM
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
12-11-2006 2:17 PM
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