topic Re: how do i acess client dependent data in Application Development and Automation Discussions

how do i acess client dependent data

Former Member — Thu, 17 May 2007 07:53:21 GMT

how do i acess client dependent data

Re: how do i acess client dependent data

Former Member — Thu, 17 May 2007 07:56:34 GMT

Hi,

You need to use MANDT in the select statment ......

Regards

Sudheer

Re: how do i acess client dependent data

Former Member — Thu, 17 May 2007 08:02:48 GMT


SELECT  *
  INTO  table itab
  FROM  (name) CLIENT SPECIFIED
  WHERE mandt = '000'.

Thx

pavan

Re: how do i acess client dependent data

former_member196299 — Thu, 17 May 2007 08:02:49 GMT

hi ,

You need to write select statement using MANDT in where condition ..

ex: select * from < Table > client specified

into itab

where ........... ( condition 1 )

mandt = 100.

this will definately work ...

Reward if helpful !

Regards,

Ranjita

Re: how do i acess client dependent data

dustyplanet — Thu, 17 May 2007 08:02:51 GMT

Correction...

Use MANDT in select statement, but this is possible only if you also use CLIENT SPECIFIED in the select statement, without which MANDT cannot be used...

One more thing, MANDT may not necessarily be the name of the client field, find out from the table definition before using it... It's the first field in the table, with type CLNT...

Hope this helps

Regards,

Dushyant Shetty

Re: how do i acess client dependent data

Former Member — Thu, 17 May 2007 08:37:53 GMT

thanku for ur answer