Skip to Content

CKMDUVMAT: how is "withdrawn quantity" calculated?

When you create a distribution and look at the details, the line for each order contains the field "withdrawn quantity". We assume this to be the quantity of the distributed material that was consumed by each selected order during the specified period. In a normal situation, this would be the 261/262 movements, and the movement quantities in MB51 should equal the withdrawn quantities in CKMDUVMAT.

I have a situation where a raw material was consumed by 39 production orders. For 32 of those orders, MB51 qty = Withdrawn qty. However, for 7 of the orders, the 261/262 goods movements do not match the withdrawn quantities. In one case, the difference is significant -- consumption was 2.1 million kg, but the withdrawn quantity was only 1.5 million kg.

All 261/262 movements were generated either by backflush from confirmation, or a subsequent COGI. There were some 309s (material to material transfers) for the raw material, but none of these movements were for orders.

I have checked everything I can think of -- posting dates, selection periods, whether the finished goods were recosted, whether TECO was flipped -- and I'm coming up blank.

The only other factor I can offer is that these are extended-time production orders for make-to-stock. We produce against them for several months (settling monthly), so there have already been DUVs in prior periods. Looking back, I have found the same situation in the past, though so far, I haven't found such a huge discrepancy.

Can anyone explain how "withdrawn quantity" is determined, since it obviously is not the simple calculation that I thought?

Thanks in advance.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Sep 25, 2017 at 05:03 AM


    One more parameter needs to be checked is storage location. DUV is activated at plant and storage location level. So if material is issued from storage location which is not part of activation then issued quantity from such storage location will not be considered


    Add comment
    10|10000 characters needed characters exceeded