Accounting for code based consumable material in SAP
Just a scenario I want to discuss with You all:
Earlier were using non-stock items (no material code,only text to procure materials) and projects were consuming it. Now, we are going to use material codes to procure non-stock items which now have master code for it now the requirement for this process is as below.
- At the time of GRN system pick project G/L(Profit and loss account G/L ) with account assignment S (or Q ) and respective WBS
- While transferring the left over project qty to another project ,accounting document is to be created .
- Warehouse want to track to moved quantity as well from project to project and to own stock .
considering these requirement i m working on two logic.
Logic 1 .
I configured the material as value based material so that while doing GRN project WBS is debiting
and after consumption of partial material quantity, I am transferring the remaining cost of project to another project by t-code KB61N or KB11N where cost is moving from project to project .
now to show quantity movement i am developing one report which can show the quantity based on moved Price lets say if unit prince is 10 and 200 cost is transferring from project to project means 20 qty is moving in customized report .
With the help of BADI or some development a virtual storage location will be created on MIGO screen
and material will be fetched in this virtual storage location while doing GRN as a referance purpose
and the same location to be used during transferring material from project to project
let me know how far this logic and requirement is correct to code the consumable material and it is going to be codified for reporting purpose .
your earliest response will be appreciable .
Thanks in advance .