-
Products and Technology
By Category
-
Groups
Activity Groups
Industry Groups
Influence and Feedback Groups
Interest Groups
Location Groups
Customer Only Groups
- Developers
- Partners
- Events
- Help Center
- Topic Pages
-
Explore SAP
Products
- Autonomous Enterprise
- Artificial intelligence
- Data and analytics
- Autonomous Suite
- Technology platform
- Transformation management
- Midsize business solutions
- Financial management
- Spend management
- Supply chain management
- Human capital management
- Customer experience
- Enterprise resource planning
- Business network
- Sustainability management
- SAP Store
- Try SAP
- View all industries
- Partners
- Services
Learning and Support
-
- Products and Technology
- Groups
- Developers
- Partners
- Events
- Help Center
- Topic Pages
-
Explore SAP
- Explore SAP
-
Products
- Products
- Autonomous Enterprise
- Artificial intelligence
- Data and analytics
- Autonomous Suite
- Technology platform
- Transformation management
- Midsize business solutions
- Financial management
- Spend management
- Supply chain management
- Human capital management
- Customer experience
- Enterprise resource planning
- Business network
- Sustainability management
- SAP Store
- Try SAP
- View all industries
- Partners
- Services
- Learning and Support
- About
- SAP Community
- Groups
- Interest Groups
- Application Development and Automation
- Discussions
- Re: 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
Bluesky