Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

Client Specific Tables

Former Member
0 Kudos

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?

1 ACCEPTED SOLUTION

Former Member
0 Kudos

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

4 REPLIES 4

former_member181995
Active Contributor
0 Kudos

Take Out MANDT.

0 Kudos

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

0 Kudos

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.

Former Member
0 Kudos

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