topic Re: client dependent table in Application Development and Automation Discussions

client dependent table

Former Member — Sun, 30 Dec 2007 09:29:19 GMT

incase if u r table is client dependent how the end user will access the data?

Former Member — Mon, 31 Dec 2007 05:20:12 GMT

hI,

USE CLIENT SPECIFIC STATEMENT ADDITIONALLY IN SELECT STATEMENT .

it shows all clients data to end user.

Former Member — Mon, 31 Dec 2007 05:27:05 GMT

make the select statements client specific by specifying the client number..

with regards,

Hema Sundara.

Former Member — Mon, 31 Dec 2007 10:58:49 GMT

Hi,

use this statement to select data form client specific table:-

select * from <DBtable> into table <internal table> CLIENT SPECIFIED where MANDT = '0100' and field1 = .....

Here it select the data belongs to 0100 clients.