{"id":11238,"date":"2018-02-22T15:00:00","date_gmt":"2018-02-22T15:00:00","guid":{"rendered":"https:\/\/zapliance.com\/?p=11238"},"modified":"2022-08-26T13:51:18","modified_gmt":"2022-08-26T13:51:18","slug":"2-steps-to-analyze-inventory-differences-in-theft-sensitive-goods-2","status":"publish","type":"post","link":"https:\/\/zapliance.com\/en\/blog\/2-steps-to-analyze-inventory-differences-in-theft-sensitive-goods-2\/","title":{"rendered":"2 steps to analyze inventory differences in theft-sensitive goods"},"content":{"rendered":"\n

Inventory differences are troublesome in many ways. After determining differences, it is often necessary to do a recount just to find out that there are some goods in the corner of a warehouse corner somewhere that nobody had thought of. At least any direct impact on profit and loss will have been avoided however. Still, it is not always possible to be so lucky. Things can get particularly unpleasant when it comes to valuable or theft-sensitive goods. You can find out exactly what valuable or theft-sensitive goods are, how they are labeled in SAP and what an analysis relating to inventory differences may look like in this blog post.<\/p>\n\n\n\n

How are valuable or theft-sensitive goods defined?<\/h2>\n\n\n\n

The search for a meaningful definition of valuable or theft-sensitive goods does not seem to be that much of a simple matter at first. Among other things, I found a definition in the \u201cGerman Freight Forwarders\u2019 Standard Terms and Conditions\u201d (Allgemeine Deutsche Spediteurbedingungen<\/em>) of 2016, according to which valuable goods are defined as follows:<\/p>\n\n\n\n

\u201cValuable goods are classified as those that, at the time and place of taking over, have an actual value of at least 50 Euro\/kg or 10,000 Euro\/per packed item.\u201d<\/p>\n\n\n\n

This threshold can be reached very quickly for some goods. So far so good then. Now let\u2019s take a look at the definition of theft-sensitive goods:<\/p>\n\n\n\n

\u201cTheft-sensitive goods are those exposed to an increased risk of robbery and theft, such as money, precious metals, jewellery, watches, precious minerals, art, antiques, check books, credit cards and\/or other payment means, stocks and security papers, documents, spirits, tobacco, entertainment electronic goods, telecommunications goods, IT equipment and accessories.\u201d<\/p>\n\n\n\n

The possibility of certain combinations of these definitions cannot be ruled out in my view. For instance, I can easily imagine jewellery that might have a value of more than \u20ac 10,000 per package. Once again, so far so good: we have now clarified what valuable or theft-sensitive goods are. Regardless of the definition though, every company is of course still free to come up with its own idea and definition of what it considers valuable goods to be.<\/p>\n\n\n\n

Where is the indicator for theft-sensitive goods located in SAP?<\/h2>\n\n\n\n

As usual, SAP has provided a special field for theft-sensitive goods in the general material data \u2013 master data (SAP table \u201cMARA\u201d). At first glance, there is no field in \u201cMARA\u201d for valuable goods. However, due to the close connection between goods which are \u201cvaluable\u201d and \u201ctheft-sensitive\u201d, it is possible to consider handling them as one and the same. The corresponding field has the technical name \u201cPILFERABLE\u201d, or in other words \u201ctheft-sensitive\u201d, and has a length of one character. This makes it clear that it is only a \u201cflag\u201d and that an item of goods is either theft-sensitive or not (\u201cX\u201d or null). If you weren\u2019t already, by now you will probably be asking yourself whether this field is even used in your company or not? I don\u2019t want to prolong your agony any longer. As always, there is more than one road that leads to Rome and so I can tell you that you have the option of using the transaction \u201cSE16\u201d or \u201cSE16n\u201d to first filter by the information entered in the aforementioned field with \u201cNot equal to: empty\u201d, or to choose our favorite procedure of using the SQL editor (transaction \u201cDBACOCKPIT\u201d \u2013 Diagnosis \u2013 SQL Editor). The query you need is then as follows:<\/p>\n\n\n\n

SELECT * FROM MARA WHERE PILFERABLE NOT LIKE ''<\/code><\/p>\n\n\n\n

This is exactly the same query as described for SE16.<\/p>\n\n\n\n

The basics of inventory in brief<\/h2>\n\n\n\n

Probably every one of you knows what an inventory is and could easily give a definition of it in your own words. Therefore, we will restrict ourselves to the technical terms to refresh the basics.<\/p>\n\n\n\n

An inventory is basically an inventory of assets and liabilities on a certain key date. Among other things, it is a prerequisite for proper accounting and reporting, whereby the following principles apply:<\/p>\n\n\n\n