topic Re: table in Application Development and Automation Discussions

table

Former Member — Fri, 12 Oct 2007 08:19:05 GMT

TABLE IS CLIENT SPECIFIC? WHAT IS MEAN THAT?

Re: table

Former Member — Fri, 12 Oct 2007 08:22:13 GMT

Hi Srinath,

Client-specific means :

Incase if you have created the program/ table in the development server, it is specific to that particular server.

So if you want to use the same in the production server , then you have to transport the same with the transport request that is created ( specific ) for the development.

Reward if useful.

Regards,

Chitra

Re: table

Former Member — Fri, 12 Oct 2007 08:25:37 GMT

Hi,

There are different clients on your system eg : client 100, client 200 like this.

When you log on to some client and do some transaction, then data for that transaction is stored in respective tables for the respective client.

check the MANDT field of table , it will give you the client no.

client dependent means data of client 100 will not be visible in client 200.

Regards,

Bharat.

Reward if helpful...

Re: table

Former Member — Fri, 12 Oct 2007 08:25:41 GMT

HI,

tables which can be access by all user are client independent (no mandt field in table)

tables which can be access by some specific user are client dependent (use mandt field in table)

rgds,

bharat.

Re: table

sivanantham_rajendran — Fri, 12 Oct 2007 08:26:01 GMT

Table is client specific means if you maintain a table entries in one client, you can access the maintainned entries only in that client only.

if you want to copy the maintained entries to other client, Go to SCC1 Tcode and give the transport request which created for maintaining table.

Please reward if this is useful.

regards,

Siva

Re: table

Former Member — Fri, 12 Oct 2007 08:27:32 GMT

Tables r client independent whereas the data in them are client dependant.

To know if the table is Client-dependent or Client-Independent, check for the field "MANDT" in the table fields.

If "MANDT" is present then table is Client-Dependent and If not exists table is Client-Independent.

the structure of the table is not client-dependent - only the content of the table

records at the table whose first field is MANDT with type MANDT, are client depemdents.

THESE ARE SOME CHARACTERISTICS OF CLIENT DEPENDENT AND CROSS CLIENT TABLES.

Client-Dependent Tables

Class A and C: Data is only imported into client 000. Existing data records are overwritten.

Class E, S and W: Data is imported into all clients. Existing data records are overwritten.

Class G: Existing data records are overwritten in client 000. In all other clients, new data records are inserted, but existing data records are not overwritten.

Class L: No data is imported.

Cross-Client Tables

Classes A, L and C: No data is imported.

Classes E, S, and W: Data is imported. Existing data records with the same key are overwritten.

Class G: Non-existent data records are inserted, but no existing data records are overwritten.

A table can be either client-specific (applying only to a single client) or client-independent (applying to all clients in the SAP system).

· Client-independent tables

Client-independent tables contain data of general relevance, for example, SAP system control data, language indicators, and transaction codes.

· Client-specific tables

Data which only applies to one client is stored in client-specific tables. Examples of client-specific tables are tables containing application data, tables containing information about the structure of a company, and, with a limited number of exceptions (for example, language indicators), tables containing basic commercial data.

A table attribute in the Data Dictionary indicates whether a table is client-specific or client-independent (see also "Creating a Table Structure" in the ABAP/4 Dictionary guide). In client-specific tables, the client is always entered in the first key position.

Re: table

Former Member — Fri, 12 Oct 2007 08:28:16 GMT

Hi Srinath,

There are different servers like developement server, production server.

If you are creating a table and that table contains field MANDT, it means that table is client specific.

Whatever data you will enter in the table will be specific to that server only.

The same table may be in other server also but its not necessary that the tables on both the servers have same data.

If you want to transport table from one server to another that also you can do.

Reward points if helpful.

Thanks.

Re: table

Former Member — Fri, 12 Oct 2007 08:33:45 GMT

CLIENT SPECIFIC :

two types in SAP

CLIENT DEPENDANT

CLIENT INDEPENDANT.

SUPPOSE 3 SERVERS YOU HAVE

DEV : CLIENT 400, CLIENT 410, CLIENT 520.

QAS : CLIENT 400, CLIENT 410

PRO : CLIENT 400

HERE CLIENT DEPENDENT MEANS : ONLY ON THAT CLIENT.

IF YOU DEVELOP A SAPSCRIPT(SE71) ON SAY DEV 400 CHANGES ARE NOT AVAILABLE EVEN IN DEV 410 AND DEV 520.

for this you have to copy the object within the same server my mean DEV using SCC1 client copy.

CLIENT INDEPENDANT ARE :

IF YOU DEVELOP A REPORT 9se38)ON SAY DEV 400 CHANGES ARE AVAILABLE EVEN IN DEV 410 AND DEV 520.

no need to copy here, changes in 400 reflect to 410 1nd 520 automatically.

you have to transport the request from DEV to QAS or PRO.

same things happens here as well.

reward if useful.

Amit Singla