How to calculate stock on hand initial based on VALUATED not Category group

[former_member245036]

Dear Expert,

Now, i want run SNP with initial stock on hand calculated by stock on hand based on VALUATED not category group like CC or CI. Because in ECC we used a lot of valuation types for materials.

please show us.

thanks so much

hungth

[former_member209769]

Hi,

I would think that you want to plan in APO only using this VALUATED stock. For this, most likely you would need to change the CIF of stock so that only the stock that you call VALUATED should come from R/3 to APO.

Please note that with this change, in APO you would have only the stock which would be valuated, and the same would also be used in PPDS, GATP, etc.

PS: Ada already gave another solution to you where you could change the calculation for stock on hand.

Thanks - Pawan

[former_member187488]

Hello,

Not sure what you mean by 'valudated'. But I think you can acheive this by modifying the standard macro.

As you may know, 'stock on hand (initial)' in standard SNP planning book is calculated by macro "stock balance", step "stock on hand (initial)", which uses a macro function INITIAL_STOCK().

If you do not like this, you can change this logic to any other logic you want. If the existed macro function cannot meet your requirement, you can also create a BADI macro.

Best Regards,

Ada

[former_member245036]

Dear Expert,

thanks for your answer. i give you an example:

in ECC for material A224 valuated two valuation types when good receipt at plant 0110 such us: ADTCLT1(100 quantity) and AKDTCLT1(200 quantity) then we cif this stock to APO.

in APO stock on hand = 100 + 200 = 300 but we want use only ADTCLT1 to run snp.

please show us how to customize macro stock balance to calculte stock on hand project ?

thanks so much

[former_member209769]

Hi,

1) You need to answer the question whether you really need this 200 quantity in APO or not? Is your requirement only relevant to SNP? Or that even for GATP, PPDS, etc you don't want to get this 200 stock in APO. If you don't want this 200 quantity in APO at all, then what I said earlier would be applicable. You could try to have enhancement in CIF so that valuation type AKDTCLT1(200 quantity) gets exluded in CIF and doesn't reach APO. I am not really sure how simple or complex this could be, but most likely should be possible.

2) Once the stock is in APO, are you able to distinguish between the 2 stocks in anyway? As far as I know, it won't be possible to distinguish. You could see the version (batch from R/3), and the stock category. I am not sure if valuation type info would be available in any way in APO, but may be I am wrong. Even if you were somehow linking the stock valuation type to the storage location stock, I think only possibility for your would have been to block storage location specific stock to come to APO in CIF (for ALL storage locations), but the stock at Plant level would still come to APO.

If somehow you are able to distinguish the stock based on valuation type, then Ada's solution could be used.

Thanks - Pawan

[former_member245036]

Dear Expert,

in case don't want cif by getting exluded in CIF and doesn't reach APO, please show us what USER_EXIT or BADI to enhance CIF screen.

thanks so much.