Client dependent Tables entries

[Former Member]

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

Rehan

[Former Member]

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

[abdul_hakim]

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