topic Re: Table creation in Application Development and Automation Discussions

Table creation

Former Member — Tue, 02 Jun 2009 05:04:32 GMT

Hi,

I have to create a z table. Should the table be client dependent or client independent. I mean when do we create the client dependent table and when independent. Please suggest.

Re: Table creation

Sm1tje — Tue, 02 Jun 2009 05:09:38 GMT

That depends on your requirement: Do you have (in production) now or in future more than one Client or not?

Is it data that you would want to maintain per client, so does this data depend on the client it self, or will this data ever be the same regardless of the client you (or the end users) are working in.

Normally, you would want to create a table with client field, but again, this depends on your specific configuration / settings.

Re: Table creation

Former Member — Tue, 02 Jun 2009 05:09:49 GMT

Hi Sashi,

Creating a client dependent table should not be a problem. If your customer has more than one client and any point of time you would like to access data for that particular client then client dependent table would be a good option.

George

Re: Table creation

Former Member — Tue, 02 Jun 2009 05:09:59 GMT

Dear Shashi,

if u need the table entries in any client then u need to create client independent.

If table entries are different from one client to other client, then u will go for client dependent.

Rgds,

Kiran

Re: Table creation

Former Member — Tue, 02 Jun 2009 05:12:16 GMT

We basically create Client Dependent tables when the data they are supposed to hols is for a specific client only and that are not for all. Moreover we go for them when we are not expecting SAP to provide them in future and the existing tables don't have the data we want.

Client Indipendent tables on other hand are created in situation where they can be use for other clients also and are not specific for one client and requirment.

Hope it make the concept bit clearer.

Regards

Gaurav.

Re: Table creation

Former Member — Tue, 02 Jun 2009 05:13:05 GMT

hi,

search on sdn ,there will be lot of material present. it depends upon you requierment that you want to make table clint dependent or independent. IF yu want some tutorial then tell me about it.

revert back if you need help.

Re: Table creation

Former Member — Tue, 02 Jun 2009 05:13:37 GMT

When we are creating any Table we are taking first field as MANDT and it should be mandatory...it means that created table was client dependent,if you are not consider MANDT field in creation of table it one is client independent.

just observe some standard tables,you can observe that first field is MANDT means that one is client dependent.

we have dev,quality,production servers.

In development server some sysytem has 2 clients one is for development another one is for testing.

but both don't have same data,why because our tables are client dependent..

Hope some what help ful...

Re: Table creation

Former Member — Tue, 02 Jun 2009 05:14:41 GMT

Hi,

The table in which the first field is not mandt is the client independent tables

Mandt is the field with mandt as the data element

Automatically client which we login is populated to mandt

Re: Table creation

Former Member — Tue, 02 Jun 2009 05:28:52 GMT

Dear shashi,

Its all depends on your requirement: whether the table be client dependent or client independent

when we add a field MANDT of type MANDT then our table is client dependent and is visible to only that specific client. But if this Field is not added to the table then we can access the table using any client number.

Cheers

fareed