Delete CM & MM from database

[Former Member]

We can set deletion flag for Customer master & Material master.. but if we want to delete this permenantly from database..how can we do this?

Thanks,

Venkat

[Former Member]

Hi Venkat,

Delete materials permanently?

Use transaction MM70 - Material Master->Other->Reorganization->Material->Choose.

Build variant with selection range of material master records to be selected for deletion and maintain run parameters. Execute.

Use transaction MM71 - Material Master-> other-> Reorganization->Material->Reorganization

Build a second variant

Maintain run parameters and execute.

It is also important to remove the records manually from info record, POs, PRs, reservation etc for successful deletion of the material.

Reward points pls.

Regards,

Govind.

[Former Member]

Hi

If you want to delete record from Database table however directly it is not possible.

FIrst you set up a delation flag for that master data

than you maintain procedure to handle delation flag.

that is of two type 1st Archive it 2nd delete that.

If setting is made to delete it.

at the time of client refresh system will delete this data

Best ragards

Bhavesh

[Former Member]

Hi Venkat,

U can set the CMR & MMR as flag for deletion, but U cannot delete the records from the data base with the std. transactions.

Regards,

Praveen.

[bcrao]

not possible