topic Client dependent Tables entries in Application Development and Automation Discussions

Client dependent Tables entries

Former Member — Mon, 22 Dec 2008 06:58:56 GMT

Is any way to change a table client specific without deleting the entries. Because the exiting table no longer client specific .

Rehan

Re: Client dependent Tables entries

Former Member — Mon, 22 Dec 2008 07:00:22 GMT

Hi rehan,

For already existing table SAP will not allow the deletion of MANDT field as it is a promary key for the table. The best option in your case will be copy the existing table to another table & before saving the table remove the MANDT field from the table's field.

Moreover you can also create a VIEW on your table containing all the fields except MANDT to make it client independent & use that view in your query.

Thanks & Regards

Md.MahaboobKhan

Re: Client dependent Tables entries

abdul_hakim — Mon, 22 Dec 2008 07:08:01 GMT

Proceed as follows,

Insert the following field as first field of your table.

Field Name: MANDT

Data Element: MANDT

Save and activate it.

Then Proceed as follows

Go to transaction SE14

Give your table name and select edit button

Keep the processing type as Direct(default)

select "Adjust and Activate database" Keep "Save Data" as Marked.

In the next dialog box accept "Yes"

Come back to SE11 and activate your table.

You are done!!

Cheers,

Hakim