- SAP Community
- Groups
- Interest Groups
- Application Development
- Discussions
- Client Specific Tables
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
Client Specific Tables
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
2008 Dec 09 11:36 PM
- SAP Managed Tags:
- ABAP Development
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?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
2008 Dec 10 9:55 AM
- SAP Managed Tags:
- ABAP Development
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
2008 Dec 09 11:46 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
2008 Dec 09 11:52 PM
- SAP Managed Tags:
- ABAP Development
We tried, but the system will not allow the removal of a primary key as this is a check table.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
2008 Dec 09 11:55 PM
- SAP Managed Tags:
- ABAP Development
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
2008 Dec 10 9:55 AM
- SAP Managed Tags:
- ABAP Development
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
