topic tables in Application Development and Automation Discussions

tables

Former Member — Tue, 21 Nov 2006 07:28:24 GMT

hi,

what are the client dependent and independent tables.how u explaine it clealy.

thanks in advance.

Re: tables

michael-john_turner — Tue, 21 Nov 2006 07:31:14 GMT

Hi,

Client dependent tables contain data visible only in the current client. Technically, their first key field is the client number (normally named MANDT).

Client independent tables contain data visible in all clients, typically system-wide customisations or data, for example. They do not contain the client number as the first key field.

Re: tables

Former Member — Tue, 21 Nov 2006 07:31:41 GMT

Client Dependent tables contain a field MANDT while client independent tables dont have this field.

Depending upon this field different data related to different clients can be saved in those tables.

Best Regards,

Vibha

*Please mark all the helpful answers

Re: tables

Former Member — Tue, 21 Nov 2006 07:32:17 GMT

Hi Surendra,

If the table contain the field MANDT and it is a key field then it is client dependent otherwise it is client independent.

Regards,

Kali Pramod

Re: tables

Former Member — Tue, 21 Nov 2006 07:33:47 GMT

Hi surendra,

Tables which contain mandt field are client dependent tables

Tables which does not contain mandt field are client independent tables

Suppose u have two clients say ,

client 1 - 600

client 2 - 800

Client independent means not dependent upon client. For example a report is client independent.ie, a report (zex1) which is created in client 600 can be accessed in both clients 600 and 800 and viceversa.

Client dependent means dependent upon client. For example script is client dependent ie, If u create a script (zscript1) in client 600 then, that script is accessible in client 600 only, we cannot access it in client 800 and viceversa.

If u want to access it in client 800 we have to transport it

Similarly , tables which are having mandt field is client dependent and which does not have mandt field are client independent.

Re: tables

Former Member — Tue, 21 Nov 2006 12:18:59 GMT

client independent tables will hold the same data across all the clients.

where as data is not same in the client dependent tables in each client.

client dependent table must contain MANDT as the first field in the table.