topic Re: Client Specific Tables in Application Development and Automation Discussions

Client Specific Tables

Former Member — Tue, 09 Dec 2008 23:36:11 GMT

Is there any way to change a table so that it is no longer client specific without deleting the entire table and starting over scratch?

Re: Client Specific Tables

Former Member — Tue, 09 Dec 2008 23:46:05 GMT

Take Out MANDT.

Re: Client Specific Tables

Former Member — Tue, 09 Dec 2008 23:52:06 GMT

We tried, but the system will not allow the removal of a primary key as this is a check table.

Re: Client Specific Tables

Former Member — Tue, 09 Dec 2008 23:55:48 GMT

As long as Foreign key relation/Check table you defined you can't delete MANDT.

One option just copy(Ctrl+F5 from SE11) the existing table to other one unmark the check/Foreign and take out the MANDT and work with this table.

Re: Client Specific Tables

Former Member — Wed, 10 Dec 2008 09:55:17 GMT

Hi Lamont,

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,

Nitesh Jain