Skip to Content
author's profile photo Former Member
Former Member

How to Delete Request Ids of Infoobjects

Hi BW Experts,

We are using the SAP standared Infoobject 0EMPLOYEE for the last 5 years. Since we have daily updates, we have large Request IDs built ver the years.

How do I delete these requests IDs. is there a table or a function module. Doing manually is very cumbersom.

kindly suggest.

Thanks,

Sai

Add a comment
10|10000 characters needed characters exceeded

Related questions

7 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Dec 14, 2011 at 06:04 AM

    Hi Sai,

    Instead of deleting each & evry request. f you looking to delete the data in 0EMPLOYEE, then goto SE14 tran --> Give the Master data table name i.e /BI0/PEMPLOYEE & select table radio button & click on Edit. Then Select Delete data in the next screen & then click on "Activate & Adjust database". So that data should be deleted.

    But you have to be very careful in SE14 trans & also make sure you donot want any history data stored in this MD. This might have been used in many places.

    Hope it helps!

    Regards,

    Pavan

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Dec 14, 2011 at 04:02 AM

    But why you want to delete those request? Don't delete without any reason.

    Regards,

    Sushant

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Dec 14, 2011 at 06:24 AM

    Hi,

    use this table table:RSBKREQUEST.field-REQUID gives the numeric value and field DTP gives the Data Transfer Process ID.

    Hope this help you,

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Dec 14, 2011 at 06:33 AM

    HI

    Try this Fm:RSDMD_DEL_Master_DATA.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Dec 14, 2011 at 06:54 AM

    Hi sainath,

    when we will load the masterdata sid 's will be generated by the system.They are unique .

    SO " no duplicate sid " ARE possible

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Dec 14, 2011 at 03:47 PM

    Hello Sai,

    The report RSSM_AUTODEL_REQU_MASTER_TEXT can be used to delete the request information from master data infoproviders. All the relevant info is in SAP note 1143710.

    Best Regards,

    Vincent

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Dec 14, 2011 at 04:34 PM

    Thanks All,

    Per Sushant's suggestion, it is not required to delet the 1000s of Request IDs in a an Infoobject (Not DSO or cube) ?

    I thought the loading perfornce will be affected if there are too may Request IDs.

    That is what is happening in my case, where the load time has increased over the past 4 yeras.

    Kndly suggest.

    Thanks,

    Sai

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.