Skip to Content
author's profile photo Former Member
Former Member

Client dependent Tables entries

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

Rehan

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

2 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Dec 22, 2008 at 07:00 AM

    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

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Dec 22, 2008 at 07:08 AM

    Hi

    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

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.