Question Re: How to delete Application Specific Data from SM13? in Technology Q&A

How to delete Application Specific Data from SM13?

Former Member — Fri, 02 Jan 2009 11:48:27 GMT

Hi All,

Please can anybody tell me How to delete Application Specific Data from SM13?

Regards,

Kiran

Re: How to delete Application Specific Data from SM13?

Former Member — Fri, 02 Jan 2009 12:09:49 GMT

Hi ,

you can delete set up table data related to an application component using LBWG transaction.

Hope it helps,

Supriya

Re: How to delete Application Specific Data from SM13?

Former Member — Fri, 02 Jan 2009 12:13:21 GMT

Hi Supriya,

Thanks for the reply.

I am looking to Delete Transactions in SM13 with respect to Application Specific, like 02 (ME21N, ME23, etc).

Please let me know in that way.

Regards,

Kiran

Re: How to delete Application Specific Data from SM13?

Former Member — Fri, 02 Jan 2009 12:17:16 GMT

SE13 can be used for Technical Settings for Tables/Views as far I know and by using this we can only display and change the Technical settings of Particular Table/Views.

Use LBWG for this because the Application component is in Logistics Cockpit and I dont think it is possible to delete the Application Components in other way around.

Hope it helps

Re: How to delete Application Specific Data from SM13?

Former Member — Fri, 02 Jan 2009 12:18:54 GMT

Hi Kiran,

See this link,

http://sapbwneelam.blogspot.com/2007/09/note-396647-faq-v3-update-questions-and.html

Hope it helps,

Supriya

Re: How to delete Application Specific Data from SM13?

Former Member — Sat, 03 Jan 2009 05:08:56 GMT

Hi Kiran,

Try if you have authorization for the T-code SMQ1.

Here you will find all the the data for each extraction queue.Ex:-For 11:-MCEX11 12:-MCEX12 03:-MCEX03.

If you want delete the application specific data selection respective queue and click on delete button this will delete the data.

Next time when the users posts the data these queues are created.

Hope this information may help you.

Regards

Ramesh

Re: How to delete Application Specific Data from SM13?

Former Member — Sat, 03 Jan 2009 05:22:51 GMT

HI Kiran,

To delete the Application specific data like 11:-MCEX11 12:-MCEX12 03:MCEX03

Try if you have authorization for T-Code SMQ1.

SMQ1

Re: How to delete Application Specific Data from SM13?

Former Member — Sun, 04 Jan 2009 04:36:27 GMT

Hi,

Apllication specific Setuptable deletion is done thru LBWG.

Application specific Extraction queue deletion thru LBWQ.

Re: How to delete Application Specific Data from SM13?

Former Member — Sun, 04 Jan 2009 05:22:53 GMT

Hi,

You can also try the below but with caution:

Start the report RSM13005 for the respective module (z.B. MCEX_UPDATE_03).

Status COL_RUN INIT: without Delete_Flag but with VB_Flag (records are updated).

Status COL_RUN OK: with Delete_Flag (the records are deleted for all modules with COL_RUN -- OK)

With the IN_VB flag, data are only deleted, if there is no delta initialization. Otherwise, the records are updated.

MAXFBS : The number of processed records without Commit.

ATTENTION: The delta records are deleted irrevocably after executing report RSM13005 (without flag IN_VB). You can reload the data into BW only with a new delta-initialization!.

For more info on SM13 see the link:

http://sapbwneelam.blogspot.com/2007/09/note-396647-faq-v3-update-questions-and.html

Re: How to delete Application Specific Data from SM13?

Former Member — Sun, 04 Jan 2009 11:04:38 GMT

Hi Ramesh,

Thanks for the reply.

In my SMQ1, i am not able to see the entries with respect to application specific datasources, because entries are strucked in SM13, only 02 application related data is not coming to SMQ1 or RSA7, i want to delete entries from SM13, Please let me know any inputs.

Regards,

Kiran

Re: How to delete Application Specific Data from SM13?

Former Member — Tue, 06 Jan 2009 10:19:56 GMT

Start the report RSM13005 for the respective module (z.B. MCEX_UPDATE_03).

Status COL_RUN INIT: without Delete_Flag but with VB_Flag (records are updated).

Status COL_RUN OK: with Delete_Flag (the records are deleted for all modules with COL_RUN -- OK)

With the IN_VB flag, data are only deleted, if there is no delta initialization. Otherwise, the records are updated.

MAXFBS : The number of processed records without Commit.

ATTENTION: The delta records are deleted irrevocably after executing report RSM13005 (without flag IN_VB). You can reload the data into BW only with a new delta-initialization!

Re: How to delete Application Specific Data from SM13?

Former Member — Wed, 07 Jan 2009 12:04:29 GMT

Hi Aduri,

I tried with RSM13005 program, i have specified MCEX_UPDATE_02 and selected Delete Radio Button and executed. Everytime it is giving 0 Number of deleted records. Please explain me what are the radio buttons i have to select.

Even i followed note Note 520845 - Number of deleted records in RSM13005 is always 0.

we have correct patch level. Please let me know what to do?

Regards,

Kiran