topic Re: table contents in Application Development and Automation Discussions

table contents

Former Member — Wed, 19 Dec 2007 12:19:23 GMT

hi mentors

hw one can knw whether table enteries are client-dependent or client-independent?

i repeat, table enteries not table.

thanku in advance

Former Member — Wed, 19 Dec 2007 12:24:03 GMT

if you have a client specific table i.e. if you have a client field in the table...

whenever you enter any record into that table if client not specified system enters the current client number...

so the data becomes client specific-...

client specific table has client specific data

Former Member — Wed, 19 Dec 2007 12:33:26 GMT

In a table if mandt field is there, then table is client dependent,

in a record

mandt is having 800 or 200 or some thing else

then that record belongs to that client.

based on ur login client it will show the table contents based on mandt field

Former Member — Wed, 19 Dec 2007 12:36:43 GMT

Hi,

Most of the tables are client dependent.so the data available in one cleint wont be available in another cleint unless you copy from client.

Mandt field is the cleint field.

if it is client dependent table emans first field should be mandt in that database table.

otherwise you can specify client name in select stmt also.

select * from vbak

into table itab

up to 10 rows

cleint specified

where mandt = '025'.

Regds

Sivaparvathi

Please reward poinjts if helpful...