topic Re: delete data from mm02 in Application Development and Automation Discussions

delete data from mm02

former_member676451 — Mon, 15 Nov 2010 05:31:13 GMT

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.

Re: delete data from mm02

Former Member — Mon, 15 Nov 2010 06:01:39 GMT

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.

Re: delete data from mm02

Former Member — Mon, 15 Nov 2010 07:03:20 GMT

<<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

Re: delete data from mm02

Former Member — Mon, 15 Nov 2010 07:10:48 GMT

<<dangerous advice deleted by moderator>>

Regards

Munish Garg

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

Re: delete data from mm02

matt — Mon, 15 Nov 2010 08:22:19 GMT

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

Re: delete data from mm02

former_member676451 — Mon, 15 Nov 2010 08:52:36 GMT

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

Re: delete data from mm02

matt — Mon, 15 Nov 2010 08:57:33 GMT

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

Re: delete data from mm02

GauthamV — Mon, 15 Nov 2010 09:09:30 GMT

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

Re: delete data from mm02

former_member676451 — Mon, 15 Nov 2010 09:14:07 GMT

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

Re: delete data from mm02

Former Member — Mon, 15 Nov 2010 09:32:30 GMT

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.

Re: delete data from mm02

Former Member — Mon, 15 Nov 2010 10:01:28 GMT

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

Re: delete data from mm02

Former Member — Mon, 15 Nov 2010 10:15:34 GMT

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

regards,

Amit

Re: delete data from mm02

former_member676451 — Mon, 15 Nov 2010 10:20:57 GMT

in devlopment