topic ZTABLE in Application Development and Automation Discussions

ZTABLE

Former Member — Sun, 25 Nov 2007 15:26:14 GMT

1) while creating ztable in the last step ie: for creating table entries

utilities->table controls->create entries

its showing a pop window saying that "the table is cross client."

what does it actually mean an when i click on the tick mark its showing an error mesage " create data processing functional maodule" what does it mean. can any one help me plz.

Re: ZTABLE

former_member195698 — Sun, 25 Nov 2007 15:43:50 GMT

In the table Doesn't have the field MANDT its a cross client table.. It means all the clients within a system will have the same entries.

Suppose your development system has 2 clients 100, 110

And if the table is cross client, if you insert entry in the table in Client 100, the same will appear in client 110 also.

If the table is not cross client ( Client dependent table ) then if you insert entry in client 100, it will not appear in client 110.

Tables with field MANDT are Client dependent tables

and tables without MANDT field are called Client Independent or Cross Client tables

Regards,

Abhishek

Re: ZTABLE

Former Member — Mon, 26 Nov 2007 04:00:30 GMT

Create a field in your table...with following details...

Name: MANDT

Type: MANDT

Assign it as a key field....

This field will tell the corresponding Client, where the data belongs to.

As you know a SAP system may have many clients....

There are two types of data available....

1. Client - Dependent

2. Client - Independent (The data which are not having this MANDT field)

Cross Client data means that Client Independent data...

For Example...

The Country table, Currency Table, Language Table are all Cross-Client tables...

Re: ZTABLE

Former Member — Mon, 26 Nov 2007 05:04:34 GMT

<b>The table is cross-client</b>

Diagnosis

You are in the process of maintaining a cross-client table. You are using the standard table maintenance screen here, which is frequently used to maintain client-specific Customizing entries. This message serves to warn you that each change you make will have an effect on all other clients in the system.

System response

You have the authorization required for cross-client maintenance.

Procedure

Think carefully about the effect of your changes. Due to logical dependencies between client-specific Customizing and applications data on the one hand and cross-client Customizing data on the other hand, changing or deleting cross-client data could result in inconsistencies.

Therefore such changes should be carefully planned and coordinated, taking all the clients in the system into consideration.

<b>Reward if usefull</b>

Re: ZTABLE

Former Member — Mon, 26 Nov 2007 08:51:01 GMT

Hi Satish,

My in short advice is to create Table Maintainance to create/maintain entries in the table( T-code SM30). Before this just insert one field at first row Mandt with type Mandt check as key field. You wont get that Pop window for cross client.

After creating this table field just go for table maintainance.....

steps are....

Go for Menu

Utilities -> Table Maintenace Generator

Then enter Authorisation group as "&NC&".

Just see any authorisation object....

Create one new function group....

then check for ONE step.

then maintain screen number ...overview screen ( enter one number eg. 100)

then create

it will ask for Package/development class....

save and come out

Then activate Ztable....

Then go to transaction SM30 and enter Ztable name....

and click on Maintain.

Then click on new entries and start entering the values/entries in the table....

This is the way in which you are going to maintain entries in the table...

Reward points....

Cheers,

Enjoy,,

Sagun Desai....

Re: ZTABLE

Former Member — Mon, 26 Nov 2007 10:44:32 GMT

Hi Satish,

There are 2 types of data available -

i. Client Dependent

ii. Client Independent(For which there is no Mandt field)

Cross Client data means that Client Independent data...

Regards

Anushree