/SCWM/GM 33 You can only post WM stocks using WM functions

[former_member738707]

Good day.

I'm trying to reduce data in table sap ewm /SCWM/HU_IW01. 1) I've set spro setting - SCM Basis\LIME\Basic settings\Index table and hierarchy\determine index tables - Hangling Unit W01-set check box Yes for AutoDelete. 2) Then i go to program /LIME/BACKGROUND_DELETE_EXEC and choose option Step 2 Hangling unit Index - set check box Yes and put selection criteria W01. Then start program in background. Program worked 230 000 sec. and gave me no result (no any entry has been deleted in /SCWM/HU_IW01) in log system gave me fault -

/SCWM/GM 33 You can only post WM stocks using WM functions

Tell me please how can i reduce table /SCWM/HU_IW01 via /LIME/BACKGROUND_DELETE_EXEC and what this error means and how can i work around this issue?

Thanks in advance!

[Daniil]

Hi Dmitriy, just wandering, how big is this table? How old / fresh is you system? And are you sure that you have something to delete? Maybe it is a wrong record planned for deletion, therefore you get this error message since stock belongs to WM, and during deletion some goods movement is triggered.

I would recommend to set all known OSS notes to the report, there are some correction, like locking fixes and so on.

https://launchpad.support.sap.com/#/notes/2816857

https://launchpad.support.sap.com/#/notes/1982070

https://launchpad.support.sap.com/#/notes/2582237

https://launchpad.support.sap.com/#/notes/2875719

BR,

Daniil

[former_member738707]

Hello Daniil, you right, we have very old sap version, i ll ask our basis to install note 2191829 but, it seems for 702 vetsion it can't be done.

Thanks for your advance!!!!!!!!!!!!!!

[former_member738707]

Daniil, i see no variant for job creating, or may be i'm doing something wrong, explain, please:

[Daniil]

Hi Dmitriy, maybe you have an old (9.0 or older) System, here it is https://launchpad.support.sap.com/#/notes/2191829

Not sure if it can be Authorization check for the context menu items. Menu is the right one, so it should be some more items there.

BR,

Daniil

[former_member738707]

Hello, this is standart view:

st12 trace:

The time spent leader of this report are table lime/ntree and /SCWM/HU_IW01. User don't want to create new report with new selection logic.

[Daniil]

Hi Dmitriy,

for sure if you have a lot of stocks it takes time. If you need to check only stock on resources, it is Resource node Under the Stock and bin. If you need complete stock in the warehouse, you can plan this report in background to have it ready for example every day at 17:30, it can be done with a right mouse click on monitor node.

BR,

Daniil

[former_member738707]

Daniil, you right i needn't to reduce table /SCWM/HU_IW01, because /SCWM/HU_IW01 = /SCWM/HUHDR.

Thanks a lot for yours answer!!!!!!!!!

[Daniil]

Hi Dmitriy,

since you said that you have Performance issues with these tables, it could be as well for example because of a lot of stocks in a same bin and so on. Are these reports standard reports or something developed? Maybe there are other ways to reduce a work time. If you share more details we can take a look deeper.

BR,

Daniil

[former_member738707]

Hello Daniil.

I've already install notes:

2870529 /LIME/NTREE inconsistencies (LFT-RGT range) produced during repacking 2912961 /LIME/BACKGROUND_DELETE - delete gaps from /LIME/NTREE (new functionality) 2857030 Removal of the zero quantity stocks 1933603 Performance correction of post_quan_modify 2000264 Functional correction of post_quan_modify 2001605 Inconsistent stocks lead to dumps 2048875 Handling Units can not be deleted 2242375 LIME Unit test corrections 2375174 /LIME/NTREE insert failure while unload 2572891 Lock errors when running LIME background delete report 2582237 Possible deadlock during /LIME/NQUAN update 2703976 Long Running PGI: Expensive SORT LT_NQUAN in Program /LIME/LCOREDGI 2816857 Update failures due to parameter ‘/LIME/E_RESERVE’ 2819407 Receipts from POS DM to FnR errors III 2879121 Reversal of note 2816857 2875719 Deleting zero quantity entries from /LIME/NQUAN 3027072 /LIME/NQUAN records with zero quantities are not available 3031785 /LIME/NQUAN zero entries are being created unnecessarily 2887931 Update error /LIME/CORE 012 during Wave 2920563 /LIME/CORE 003 Update Error 3042220 /LIME/BACKGROUND_DELETE_EXEC no longer deleting 0 entries

Now i'm just in test system, table /SCWM/HU_IW01 has only 674159 entries ( in prod about 2100000) probably system resources to small in test system to rework all table quickly.

In few reports users waits to long and they asked me to help them, i've made trace and tables /SCWM/HU_IW01 and lime/ntree takes many time to complete report (how to reduce entries in lime/ntree i already found). And now just needs to reduce entries in /SCWM/HU_IW01.

[Daniil]

Hi Dmitriy, since it is a message, if it happens in update task it has to be as well a short dump (or a lot of dumps)

If it is one or if it is broken update process in SM13 you can check what EWM tried to do.

You can debug it with BREAK-POINT ID /lime/core.

Are you sure that you have some HU records there which are deleted in EWM and could be deleted from index table? I just tested, as soon as I deleted HU it was as well deleted from /SCWM/HU_IW01, I am not sure which records should be deleted with report, I never used it.

It is written there in the comments

* 2b) Delete HU (index + tree) with object_delete=X with no children.
* Step 2b is iterative. Number of runs determined by HU hierarchy
* depth from /LIME/NTREE. 

* How to avoid deleting HUs that have just been created (they also have
* no children):
* - Plan the delete job during the night when no HU is created by users
* - Create the HU and post stock quantities to the HU's in the same
*   document (via function module /LIME/DOCUMENT_POST).

from description it sounds like empty HUs. And for me amount of HUs in IW01 same as in /SCWM/HUHDR. Maybe it is just nothing to delete in your case?

BR,

Daniil

[former_member738707]

Also i've done this:

"Activate BAdI implementation /SCWM/EI_BKG_DELETE_EWM (implemented by this note) via the following Customizing: Tx SPRO SCM Extended Warehouse Management->SCM Basis->Logistics Inventory Management Engine (LIME)->Basic Settings->Business Add-Ins (BAdIs)->BAdI: Filter Data of Background Delete Report"