Delete lock entry for an IDOC locked since 5 days ago.

[former_member641522]

Hello,

I received some Delivery and an IDOC numbers, I was asked to release the delivery with the VKM5 T-code, and the IDOC with the BD87, However one of them was locked by user TIDAL_SCHED.

Here's the Delivery Number:

86622718

The IDOC number:

0000001073053855

Here's the message I receive when I try to release the delivery:

86622718   CSL: VPRCLNT810:SALES_DOCUMENT:0150000010 is locked by TIDAL_SCHED (VPRCLNT810-01) (lock time: 20150430141129 , reference counter: 1 )

How can I locate this exact lock entry? Is there an specific table I should look for besides the user name? So far I have obtained the following information:

Sales Order: 3000011472

Return: 0150000010

Delivery: 0086622718

As you can see the look time is April 30th 2015; whenever I look into everything TIDAL_SCHED I don't get anything referencing the Delivery and/or Sales doc or april 30th:

810	TIDAL_SCHED	18:05:07	S	ZVSPGMUSG	810ZTIAP_TWS_PAYMENT_UPDATES               TIDAL_SCHED	0	1
810	TIDAL_SCHED	18:14:40	E	CSL_MTLK	VPRCLNT81001VPRCLNT810:SALES_DOCUMENT:7677216031	0	1
810	TIDAL_SCHED	18:14:40	E	EDIDC	8100000001073152622	1	1
810	TIDAL_SCHED	18:14:40	S	EM07M	810XSAMN910TBLK      DC150001MARDDC15                           L01 H            1.000              0.00	0	1
810	TIDAL_SCHED	18:14:40	E	EM07W	810XSAMN910TBLK      DC15                                          0.000              0.00              0.00              0.00	0	1
810	TIDAL_SCHED	18:14:40	E	LIKP	8108676864448	0	1
810	TIDAL_SCHED	18:14:40	S	MARC	810XSAMN910TBLK      DC15	0	2
810	TIDAL_SCHED	18:14:40	S	MBEW	810XSAMN910TBLK      DC15##########	0	3
810	TIDAL_SCHED	18:14:40	E	VBAK	8107677216031	0	1
810	TIDAL_SCHED	18:14:40	S	ATPENQ	810810000000610214635259DC30          DC30            20150504                                              2           1.000	0	1
810	TIDAL_SCHED	18:14:40	E	EDIDC	8100000001073169350	0	2
810	TIDAL_SCHED	18:14:40	S	EM07M	810000000610214635259DC300001MARDDC30                           L01 H            1.000              0.00	0	1
810	TIDAL_SCHED	18:14:40	S	EM07W	810000000610214635259DC30                           10             1.000-           130.23-           130.00-             0.00	0	1
810	TIDAL_SCHED	18:14:40	S	MARC	810000000610214635259DC30	0	2
810	TIDAL_SCHED	18:14:40	S	MBEW	810000000610214635259DC30##########	0	3
810	TIDAL_SCHED	18:14:41	E	CSL_MTLK	VPRCLNT81001VPRCLNT810:SALES_DOCUMENT:7677211659	0	1
810	TIDAL_SCHED	18:14:41	E	EDIDC	8100000001073147516	1	1
810	TIDAL_SCHED	18:14:41	E	LIKP	8108676859884	0	1
810	TIDAL_SCHED	18:14:41	E	VBAK	8107677211659	0	1
810	TIDAL_SCHED	18:14:41	E	EDIDC	8100000001073169349	1	1
810	TIDAL_SCHED	18:14:41	E	EM07W	810000000610214694102DC30                                          0.000              0.00              0.00              0.00	0	1
810	TIDAL_SCHED	18:14:41	S	MARC	810000000610214694102DC30	0	1
810	TIDAL_SCHED	18:14:41	S	MBEW	810000000610214694102DC30##########	0	2

[mtarundeep]

Hi Eric,

CSL_MTLK	CSL: Assignment Token Manager to Token
EDIDC	Control record (IDoc)
LIKP	SD Document: Delivery Header Data
VBAK	Sales Document: Header Data
EDIDC	Control record (IDoc)
EM07W	N/A
MARC	Plant Data for Material
MBEW	Material Valuation
ATPENQ	Enqueue Structure ATP Server: Lock

as per the above tables in the log we understand that there is a Material Movement transaction trying to be executed by the IDOC or delivery document ,

Hence I believe that there is a lock for a particular material ( from one of the document)  at the plant level and hence during the IDOC release or the Delivery document change there is a problem

Please check the below materials

610214635259 in Plant DC30
610214694102 in Plant DC30

In your post you've only mentioned the IDOC , Sales Order & delivery but there is no return delivery number mentioned.( please also look into the return delivery)

You can also check with the lock entries for 30th April on the time mentioned in the error message you received.

Please also check the documents ( as per the above provided logs)

Delivery Doc	8676859884
Sales Order	7677211659

All the above mentioned details are just ways to pinpoint the problem,hopefully this approach helps.

Thanks,

Tarun

[Lakshmipathi]

Did you check in SM12 from where, you can delete the unwanted entries ?

G. Lakshmipathi

[former_member641522]

Actually that's what I try to find out, I see several locks but none of them seem to refer to the sales doc, I don't know if there's a table that could help me find that specific lock entry.