I’ll try to explain this as simply as possible…
We deployed SAP RM 4.0 Inventory Analysis in test environment. In testing we discovered bugs with special stock balances - it does not affect regular stock types, only special stock (Vendor, Sales Order, Consignment). A few items of background/explanation, then my question below:
Problem: stock balances by stock field type (for Special Stocks only)remains constant at the balance as of the intial load.
Observations:
-Inventory Balances on the Initial Load assign stock balances to the related stock field type (Restricted, Unrestricted(LABST), Blocked, …). See first page of attached .pdf.
-Material Movement Fact assigns special stock movements to ‘OTHER’ (see second page of attached .pdf) rather than the same stock field as the inventory balances.
-See third page of attached .pdf for the effect on the SAPIA 15 report (note: the plant queried went live AFTER 10/1/2012).
-Attempted Fix #1: I attempted to correct the issue by assigning the special stock material movements to the related stock field type (see fourth page of attached .pdf and the text at the bottom of this post). The changes were successful in assigning the material documents appropriately. However, this change had no effect on special stock balances.
-Attempted Fix #2 (pending): I am planning to assign all of the stock balance fields of the special stock tables (MSKA, MSKU, MSLB, etc) to ‘OTHER’. While this isnt ideal (it restricts a level of detail that my users desire), it is more important to have correct data at a less granular level.
I would prefer to follow Fix #1 and correct the stock balance calculation, but I am having difficulty understanding what else is used to determine stock balances for special stocks?
Mapping of MATERIAL_MVMT_FACT
[i]Original:
#decode( # only first 12 have values in Inventory
XEINME <> ’ ’ , ‘EINME’,
XINSME <> ’ ’ , ‘INSME’,
XKEINM <> ’ ’ , ‘KEINM’,
XKINSM <> ’ ’ , ‘KINSM’,
XKLABS <> ’ ’ , ‘KLABS’,
XKSPEM <> ’ ’ , ‘KSPEM’,
XLABST <> ’ ’ , ‘LABST’,
XRETME <> ’ ’ , ‘RETME’,
XSPEME <> ’ ’ , ‘SPEME’,
XTRAME <> ’ ’ , ‘TRAME’,
XUMLMC <> ’ ’ , ‘UMLMC’,
XUMLME <> ’ ’ , ‘UMLME’,
# Remainder are assigned "OTHER"
XBWESB <> ’ ’ , ‘OTHER’,
XGLGMG <> ’ ’ , ‘OTHER’,
# XMEIKE <> ’ ’ , ‘OTHER’,******
# XMEIKL <> ’ ’ , ‘OTHER’,******
XMEIKQ <> ’ ’ , ‘OTHER’,
XMEIKS <> ’ ’ , ‘OTHER’,
XMKEKK <> ’ ’ , ‘OTHER’,
XMKEKL <> ’ ’ , ‘OTHER’,
XMKLKK <> ’ ’ , ‘OTHER’,
XMKLKL <> ’ ’ , ‘OTHER’,
XMKQKK <> ’ ’ , ‘OTHER’,
XMKQKL <> ’ ’ , ‘OTHER’,
XMKUBL <> ’ ’ , ‘OTHER’,
XMSEBO <> ’ ’ , ‘OTHER’,
XMSLBO <> ’ ’ , ‘OTHER’,
XMSPRE <> ’ ’ , ‘OTHER’,
XMSPRL <> ’ ’ , ‘OTHER’,
XMSPRQ <> ’ ’ , ‘OTHER’,
XMSPRS <> ’ ’ , ‘OTHER’,
XMSQBO <> ’ ’ , ‘OTHER’,
XMTVEI <> ’ ’ , ‘OTHER’,
XMTVLA <> ’ ’ , ‘OTHER’,
XMTVQU <> ’ ’ , ‘OTHER’,
XMTVSP <> ’ ’ , ‘OTHER’,
XSATRA <> ’ ’ , ‘OTHER’,
XSQTRA <> ’ ’ , ‘OTHER’,
# If you get here all are blank and are assigned "UNKNOWN"
‘UNKNOWN’)
My Changes:
decode( # only first 12 have values in Inventory
XLABST <> ’ ’ , ‘LABST’,
XINSME <> ’ ’ , ‘INSME’,
XSPEME <> ’ ’ , ‘SPEME’,
XEINME <> ’ ’ , ‘EINME’,
XTRAME <> ’ ’ , ‘TRAME’,
XRETME <> ’ ’ , ‘RETME’,
XUMLMC <> ’ ’ , ‘UMLMC’,
XUMLME <> ’ ’ , ‘UMLME’,
Special Stocks Customer Consignment by abooth 5.2.2013
XMKLKK <> ’ ’ , ‘LABST’,
XMKQKK <> ’ ’ , ‘INSME’,
XMKEKK <> ’ ’ , ‘EINME’,
Special Stocks Sales Order by abooth 5.2.2013
XMEIKL <> ’ ’ , ‘LABST’, ******
XMEIKE <> ’ ’ , ‘EINME’,******
XMEIKQ <> ’ ’ , ‘INSME’,
XMEIKS <> ’ ’ , ‘SPEME’,
Special Stocks Vendor by abooth 5.2.2013
XMSLBO <> ’ ’ , ‘LABST’,
XMSEBO <> ’ ’ , ‘EINME’,
XMSQBO <> ’ ’ , ‘INSME’,
Consignment - not used
XKEINM <> ’ ’ , ‘KEINM’,
XKINSM <> ’ ’ , ‘KINSM’,
XKLABS <> ’ ’ , ‘KLABS’,
XKSPEM <> ’ ’ , ‘KSPEM’,
Remainder are assigned “OTHER”
XBWESB <> ’ ’ , ‘OTHER’,
XGLGMG <> ’ ’ , ‘OTHER’,
XMKEKL <> ’ ’ , ‘OTHER’,
XMKLKL <> ’ ’ , ‘OTHER’,
XMKQKL <> ’ ’ , ‘OTHER’,
XMKUBL <> ’ ’ , ‘OTHER’,
XMSPRE <> ’ ’ , ‘OTHER’,
XMSPRL <> ’ ’ , ‘OTHER’,
XMSPRQ <> ’ ’ , ‘OTHER’,
XMSPRS <> ’ ’ , ‘OTHER’,
XMTVEI <> ’ ’ , ‘OTHER’,
XMTVLA <> ’ ’ , ‘OTHER’,
XMTVQU <> ’ ’ , ‘OTHER’,
XMTVSP <> ’ ’ , ‘OTHER’,
XSATRA <> ’ ’ , ‘OTHER’,
XSQTRA <> ’ ’ , ‘OTHER’,
If you get here all are blank and are assigned “UNKNOWN”
‘UNKNOWN’)[/i]
SAPIA - Stock Balance Bug.pdf (481.0 KB)
abooth (BOB member since 2011-07-08)