Function Module to delete records from standard table.

[Former Member]

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.

[Former Member]

hi shiv,

this link will help you:

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

[ThomasZloch]

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

[Former Member]

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

[christine_evans]

>

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

[Former Member]

Christine...

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

pk

[christine_evans]

>

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

????????

[Former Member]

>

 ????????

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

[christine_evans]

>

> >

 ????????

>

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

[Former Member]

>

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

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

Cheers,

Amit.

[Former Member]

>

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

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

Rob

[Former Member]

>

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

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

[Former Member]

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

[Former Member]

>

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

Is there any history behind PK--

---

>>KP--

---

>>OMG now A.K.A?

Can i expect now XXX?

[Former Member]

>

> 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

[Former Member]

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.

[Former Member]

Answered