How to count SAP EWM delivery items in an existing system?
In the new version of SAP EWM the main metric to understand hosting (for cloud system) and license usage is average number of delivery items per day.
Within implementation project of SAP S/4HANA EWM PCE we had to understand how to calculate the metric as a lot of things depend on it: the size of the system, how much customer should pay for hosting and licenses, how many production instances we can have.
According to RISE with SAP S/4HANA, private cloud edition Service Description Guide the main metric for SAP S/4HANA for extended warehouse management, extra stack, private cloud edition is number of items:
Items represent the average number of Items (as defined below) per day based on the number of active days, managed in the Cloud Service during a contract year. A contract year is a 12- month period beginning on the first day of the Subscription Term or its annual anniversary. For shipper scenario, Items are delivery line items. A delivery is the documentation for a shipment sent to/from a warehouse location to/from a destination (customer, vendor or other plant/location). The items of the delivery are the unique material codes irrespective of quantity shipped under that delivery.
For the transit warehousing scenario, Items are the packaging items (handling units) moved through the system from origin to destination. The packaging items are counted only once in this process
However it is not clear how exactly these items are calculated. If we already have a system (the old decentral EWM or S/4HANA is already used), how to calculate this metric? Should we count only main items, should we count text or zero items, should we count PMR/EGR items, --- it is not clear from SAP documentation.
Another complication we had is a number of warehouses, --- we have a lot of them. How to understand the metric per warehouse number?
The solution to these problems is the table /SCWM/DLVCNTRAW
, --- the one that
is intended to be used by SAP when they perform audits. The table contains
counters for delivery items per warehouse per day, so it is useful for
performing all kinds of reports.
If you want to count a number of delivery items on average per year, you select
all records for a year, sum up the column COUNTER
and divide it by 365 (days
in a year), --- voila! You have an average number of items per day for a whole
year.
However, if your business has seasonality, you might want to consider calculating the metric monthly and then use a number from the biggest month. Or you might want to do it per warehouse: you can use the same table.
Another benefit is that the table includes already archived data. However, there seems to be its own archiving: the table holds only 24 months of data.
Note: Use the metric at your own risk. I wasn't able to receive 100% confirmation from SAP on how to actually calculate the metric. Moreover, I received some contradicting messages. I suggest you to look for all existing options before coming to the same conclusion: this is the best way to do it.
Provide feedback
If you have comments or suggestions, please feel free to:
- Reply on X/Twitter.
- Leave a comment on our Telegram Channel.