Question:
Hello,
We have an issue where we want to delete entries from SAP table MVER.
Is theer a standar utility that can be used to delete entries based on some key feilds.
Its a production issue, i know we can write a program and get the job done, but is there some utility that can help ?
Regards,
guest
Answer:
See here. Substitute Delete for Insert.
_________________
Regards
R
Abap KC
SFMDR
Answer:
Not sure how the link you attached is helpful here.
Answer:
you are missing R's point - we should not delete / insert /update standard SAP tables directly due to the implications of linked tables and data.
Not sure why you would want to delete entries from this table without looking at other Material tables also.
Dave
Answer:
The link is intended to point out that you are not supposed to do direct updates on SAP standard tables. Ever. But having said that I must admit (again) that I have done this once. Under duress and having been assured (in writing) by our external consultant that he had consulted with SAP and it was ok in this 'changing from classic to flexible RE' situation.
Answer:
The link is intended to point out that you are not supposed to do direct updates on SAP standard tables. Ever. But having said that I must admit (again) that I have done this once. Under duress and having been assured (in writing) by our external consultant that he had consulted with SAP and it was ok in this 'changing from classic to flexible RE' situation.
Directly updating SAP tables under SAP Instruction is a totally different matter.
_________________
Regards
R
Abap KC
SFMDR
Answer:
problem is, wrong fiscal year entries for 37 plants were loaded on to this table via a load program.
We need to delete these entries.
Answer:
do it manually, or if they are a bunch, create a program like your inserting one for delete them.
I just wish your insertions were made through standard transacions using BI or through BAPIs... use the same method to drop them, then
_________________
Brief History of the Tuly Idiots
Bad advices, wrong answers, bigotism
sapfans GD
Ad by Viiiiiic
Answer:
Directly updating SAP tables under SAP Instruction is a totally different matter.
Well, our consultant had a chat with a SAP consultant over the phone and they came to the conclusion that the table update was a viable option and a note to this effect was added to a customer message by our consultant. I'm not sure that this process is formal enough to qualify as being 'under SAP Instruction'. Still, no problems so far....