topic Function Module to delete records from standard table. in Application Development and Automation Discussions

Function Module to delete records from standard table.

Former Member — Thu, 27 Nov 2008 13:18:58 GMT

Hi Experts,

I need to delete entries from standard table HRUS_D2 using where condition. Is there any function module for this purpose. If anybody worked on this please help me.

Thanks and regards,

Shivanand Kalagi.

Re: Function Module to delete records from standard table.

Former Member — Thu, 27 Nov 2008 13:28:58 GMT

hi shiv,

this link will help you:

http://abap4.tripod.com/SAP_Functions.html

Re: Function Module to delete records from standard table.

ThomasZloch — Thu, 27 Nov 2008 13:34:08 GMT

How would a list of hundreds of functions modules (some obsolete) help in this case?

Re: Function Module to delete records from standard table.

Former Member — Thu, 27 Nov 2008 13:52:48 GMT

Hi Shivanand,

You may not get any FM for this , just write down a report of FM for this as per your requirement,

no other way for this........

Re: Function Module to delete records from standard table.

christine_evans — Thu, 27 Nov 2008 13:59:26 GMT


> Hi Experts,
> I need to delete entries from standard table HRUS_D2 using where condition. Is there any function module for this purpose. If anybody worked on this please help me.
> 
> Thanks and regards,
> Shivanand Kalagi.

Updating SAP standard tables directly is not usually a recommended option. However, on HRUS_D2 apparently it can be an option. In our 'Practical Workflow for SAP' manual, published by SAP Press, in the Agents section on page 130 it says, referring to this table:

However, if you want to maintain this table centrally, this is one of the few cases where the table is sufficiently straightforward and independent of other tables that creating your own maintenance view of the table is a reasonably safe option.

So, supported by this opinion and having been assured by everyone else that for this table this was an ok thing to do, I built a BSP that maintains user substitutes by doing direct updates on HRUS_D2. And I've not had any problems so far.

Re: Function Module to delete records from standard table.

Former Member — Thu, 27 Nov 2008 14:02:38 GMT

Christine...

I was watching my favourite show in SDN and You are spoiling the show....

Re: Function Module to delete records from standard table.

christine_evans — Thu, 27 Nov 2008 14:25:20 GMT


> Christine...
> 
> I was watching my favourite show in SDN and You are spoiling the show.... 
> 
> 
> pk

????????

Re: Function Module to delete records from standard table.

Former Member — Thu, 27 Nov 2008 15:15:05 GMT

 ????????

I believe that PK was saying that the thread was quickly de-generating into something more interesting, but not very useful. Your straightrforward answer appears to solve the problem, but the tangent it was headed for is likely no more.

Rob

Re: Function Module to delete records from standard table.

christine_evans — Thu, 27 Nov 2008 16:25:07 GMT

> >

 ????????

> I believe that PK was saying that the thread was quickly de-generating into something more interesting, but not very useful. Your straightrforward answer appears to solve the problem, but the tangent it was headed for is likely no more.

> Rob

Thank you for the explanation. I apologise for spoiling the fun.....

Re: Function Module to delete records from standard table.

Former Member — Thu, 27 Nov 2008 20:28:42 GMT


> I believe that PK was saying......

..But i believe that KP was saying.....;-)

Cheers,

Amit.

Re: Function Module to delete records from standard table.

Former Member — Thu, 27 Nov 2008 20:38:19 GMT


> ..But i believe that KP was saying.....;-)

I apoligize to PK if I stole his voice;-)

Rob

Re: Function Module to delete records from standard table.

Former Member — Thu, 27 Nov 2008 20:42:55 GMT

 
> I apoligize to PK if I stole his voice;-)

..And I apologize to KP if I addressed him wrongly;-)

Re: Function Module to delete records from standard table.

Former Member — Fri, 28 Nov 2008 03:25:26 GMT

Christine,

Rob's dissection of my statement is spot-on....as always

Lost the count of the number of occasions where people ask "How to delete data directly from Standard table" or in some cases "how to delete standard table", etc etc...

A lot of people dont seem to understand the implications of deleting data directly from SAP tables. the worst part is the number of replies encouraging the OP for a direct deletion.

Its commendable of you to create an awareness about the implications. So you dont have to be sorry

Kishan.P (a.k.a) pk

Re: Function Module to delete records from standard table.

Former Member — Fri, 28 Nov 2008 03:32:25 GMT

 
> Kishan.P (a.k.a) pk

Is there any history behind PK--

>>KP--

>>OMG now A.K.A?

Can i expect now XXX?

Re: Function Module to delete records from standard table.

Former Member — Fri, 28 Nov 2008 03:57:34 GMT


> Is there any history behind PK--
>>KP--
>>OMG now A.K.A?

[a.k.a|http://en.wikipedia.org/wiki/A.k.a] => also known as

kishan.P

Re: Function Module to delete records from standard table.

Former Member — Fri, 28 Nov 2008 04:06:14 GMT

Thank you for clarify my doubt.

Before I was bit hesitated ,as thought ["Awesomely Kick Ass".|http://www.acronymattic.com/AKA.html]

PS:So i would suggest you to not use Internet slang words for avoiding confusion

Cheers,

Amit.

Re: Function Module to delete records from standard table.

Former Member — Tue, 23 Dec 2008 05:39:44 GMT

Answered