Clear entries from /SAPLL/OBJIDX

[Former Member]

Hi ,

We have a bunch of entries that landed up in the table /SAPSLL/OBJIDX with the processed flag not set.

The cause behind being some Sales Order types ,not configured to be pushed from ECC to GTS ,were manually attempted to be pushed with the program "/SAPSLL/SD0A_DISTRIBUTE_R3"

Is there a standard mechanism wherein these entries can be removed from the table without the involvement of a custom program development or a backend update.

These entries are currently marked as "UNPROCESSED" in the table

Thanks

Jasmit Kohli

[Former Member]

Hi,,

Try program /SAPSLL/OBJIDX_REORG_R3

[Former Member]

Thanks Sudheer.. the program to Reorganize index just helps to remove processed entries..

I am looking out to clear the unprocessed ones which landed up incorrectly ( config in R/3 is not switched on to transfer this document type )

Thanks

Jasmit Kohli

[former_member58030]

Hi Jasmit,

You need to write a Z program or ABAP line command

It is pretty simple if you just want to create your own local ABAP program to delete an entry.

e.g:

delete from /sapsll/lc_cusb1 where GUID_LC_CUSB1 = '0002D75687063045B5D86B33ED83F2DD'.

Syntax check...run it in test mode, and it will delete the entries out of the tables BUT TREAD VERY CAREFULLY!

Regards,

Prarit