delete data from mm02

[former_member676451]

i want to delete data from mm02 in

mm02 -> basic data ->additional data i want to to delete language and material description exclude language 'EN'.

is it possible to delete direct from the database table?

if yes then how it possible.

[Former Member]

Hi jadav,

As far as my knowledge.We couldnot alter the data present in database table.Because it may change the data globally as many users are using that table.So i suggest u to copy the table to another local table and do modifications as per ur requirement.

[Former Member]

<<dangerous advice deleted by moderator>>

Edited by: Gnana Kumar on Nov 15, 2010 8:07 AM

Edited by: Matt on Nov 15, 2010 9:20 AM

[Former Member]

<<dangerous advice deleted by moderator>>

Regards

Munish Garg

Edited by: kishan P on Nov 15, 2010 12:42 PM

[matt]

If you directly modify a table, and you end up with a database corruption, then you'll have to spend a lot of money getting your system into a consistent state. Changes should generally only be made through transactions.

Sometimes it is necessary or desirable to make direct changes to SAP tables. However, it should only be done by someone who really knows what they are doing, with plenty of experience, after discussing with SAP.

The fact that you are asking the question shows that you do not have sufficient experience, and so should not be attempting this.

matt

[former_member676451]

so its possible to write a code for that and delete the entries?

[matt]

Yes it is. But in my view you will be being incredibly irresponsible unless you.

1. Talk to SAP first

2. Have an experienced programmer do it.

3. Re-consider at least 10 times.

Before you ignore this advice, bear in mind that I'm an ABAP developer of 15 years experience, who has been responsible for mentoring, managing and training many many developers over the years.

matt

[GauthamV]

You can use standard Bapi BAPI_MATERIAL_SAVEDATA to modify any existing data related to the material.

[former_member676451]

if u have another way to do this then pls let me know becus over prob is that we want to delete material description in mm02 excluding language 'EN'.

Moderator message: please do not use SMS speak.

Edited by: Thomas Zloch on Nov 15, 2010 10:23 AM

[Former Member]

Sitting here and reading your crisp question (after I've locked your even more crisper question), it's very difficult to suggest you to do anything.

Firstly, we need to know why you need to delete the Material Description from a standard transaction. If this is a Business requirement, only your Business know why this is needed - Im sure you have no clue about it either.

Secondly, we need to know if this is a requirement that has been handed down to you by your Functional Consultant, or if it's a figment of your own imagination.

Thirdly, we want to know why your Functional Consultant (if any) has not suggested you a suitable suggestion, especially when a "fresher" abap is behind the controls.

Fourthly, please tell us why you are not ready to contact SAP and seek their advice.

pk

[Former Member]

Hello

wa_fieldcat-fieldname = 'AU1'.
wa_fieldcat-ref_table = 'AU2'.
wa_fieldcat-edit = 'X'.
wa_fieldcat-f4availabl = 'X'.
append wa_fieldcat to it_fieldcat.

clear it_f4.
it_f4-fieldname = 'AU2'.
it_f4-register = 'X'.
it_f4-getbefore = 'X'.
it_f4-chngeafter = 'X'.

Use this code I am sure You will get your required results.

thanks,

Amit

Edited by: akg.amit on Nov 15, 2010 11:07 AM

[Former Member]

Do we know that, where are you working , i mean in prodution , quality or the developement?

regards,

Amit

[former_member676451]

in devlopment