How to delete Application Specific Data from SM13?

[#1]

Hi All,

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

Regards,

Kiran

[Former Member · Accepted solution]

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

[Former Member · Accepted solution]

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

[Former Member · Accepted solution]

Hi

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!

[Former Member · Accepted solution]

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

[Former Member]

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

[Former Member]

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

[Former Member]

Hi ,

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

Hope it helps,

Supriya

[Former Member]

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

[Former Member]

Hi

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

[Former Member]

Hi Kiran,

See this link,

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

Hope it helps,

Supriya

[Former Member]

Hi,

Apllication specific Setuptable deletion is done thru LBWG.

Application specific Extraction queue deletion thru LBWQ.