Is it possible to delete the vendor declaration worklist

[Former Member]

Hi Gurus,

Is it possible to delete the vendor declaration worklist (vendor side).

Background the vendor declaration worklist was created by mistake

(SAP Note 1686914 has corrected this issue).

But we have still the worklist, which we need to get rid off.

Is there any possibility? Or in which table is the worklist can we delete it directly in table?

Regards

Dieter

[lakshmikanthc2 · Accepted solution]

Hi Dieter,

Yes, there is a possibility to delete the required entry from vendor delcaration worklist.

How? first go to Assign Vendor report (Assign Vendor /SAPSLL/PARMA_MA_CPS), execute with respective vendor code, then change the vendor relevance for LTVD indicator to BLANK from X and save it.

Then go worklist, select respective entry, click on follow-on functions option to delete the entry.

At lease change the status back to X for respective vendors.

Regards,

Lakshmikanth

[Former Member]

Dieter,

vendor LTVD (after request) are stored in DB tables:

- /SAPSLL/PREVD (header)

- /SAPSLL/PREVDITM (item)

the link between those two is made via GUID_PREVD

You might directly delete respective entries from those tables to delete an existing LTVD

Once deleted you'll be able to recreate an entry in the LTVD request worklist for the same vendor/product/plant

Being said and as you may know, direct DB update/deletion is strongly not recommended

Regards,

Gregory

[Former Member]

Gregory, fully agree, not recommended but effective and sometimes easiest.