table contents

[Former Member]

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]

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]

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]

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]

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...