Knowledge Management

Question:
Hi SAPers,
I have stumbled into a problem which maybe some of you have encountered before. I need to update the valuation category in the material master record, but it is not possible due to existing batches, purchase orders and sales documents. What is the procedure on how to be get to the situation where I can change the valuation category?
Hope to hear from you gurus soon!
Thanksalot!
Best regards,
zhivago
Answer:
From OSS note 155874
want to change the valuation category in the material master (Accounting screen). A number of checks are executed in this case before the system allows this change:
1. If you change from joint valuation to split valuation or vice versa, no stock must exist (neither for the current nor for the previous period) and no physical inventory must be active.
2. If you change from split to joint valuation, no valuation data must exist for a valuation type.
3. If you change form joint to split valuation, no batches must exist.
4. If you change the category of the split valuation, the existing valuation types must fit the new valuation category.
5. If the valuation category provides valuation for a single batch, the batch management requirement indicator must be set.
In addition, the following is always checked:
6. no purchase orders or no delivery schedules exist
7. no production orders exist
8. no sales orders or no deliveries exist
9. no WM stocks (quants) and no transfer requirements are available
The reason for these restrictions is that above objects refer to the original valuation category or to valuation data that is dependent on the valuation category and inconsistencies can occur if the valuation category is changed.
For example, stocks referring to the original valuation category or to the valuation types dependent on it might occur and you would no longer be able to clear these stocks, or an incorrect G/L account might get updated in Financial Accounting if goods receipt or an invoice receipt were posted to the above objects, for example.
Solution
You must eliminate the described causes, for example, by archiving the affected objects.
Answer:
Thanks Svetja,
Puuhhh, it is good to know you are around! The reason why I am struggling with this is that someone by "accident" has started to use a material which has not been updated with the correct valuation category. Purch. orders, GRs, GIs and Deliveries have been posted and now I must clear (read: archive and delete) all these documents to be able to enter the valuation category of the material. (Entry H instead of blank.) So it is not a conventional archiving I am doing....
Anyways, I have tried to list the archiving objects to be done below:
Purchase Docs - MM_EKKO
GRs and GIs - MM_MATBEL
Deliveries - RV_LIKP
Sales docs - SD_VBAK
Batches - MM_SPSTOCK
Am I correct about the above? Do you have any tips and hints on which order I should do the archiving??
Thanks for all your help!
Best regards,
hc
Answer:
I would start with MM_MATBEL, then RV_LIKP, MM_EKKO, SD_VBRK and SD_VBAK and finally MM_SPSTOCK.
Do you think its worth to do all this for a (one?) material. It is much easier to create a new material master.
Answer:
It is really 3 materials, but I catch your drift.... The thing is that it is wanted to keep the exact same materialnumber as before, and it does not seem possible to extend the material for just valuation category. Do you have any smart ideas on how to handle this?
If it is possible to re-create the materials for the correct valuation category. I would guess the next step would be to remove stock, close the open documents and flag the incorrect materials for deletion....
Best regards,
zhivago
Answer:
No smart ideas, and with the next steps you are right.
Answer:
I am now testing how archiving of MM_MATBEL works and nothing happens!! I would expect the material doc to be deleted, but oh no! Could something be wrong with my settings?
I specify mat. doc number, mat.doc.year and plant and I have `Create archive files`, `Delete only in test mode` and `Log flow` all ticked.
Are there other checks I should do before running MM_MATBEL?
Thanks for your advice!
Best regards,
zhivago
Answer:
Have you set the document life? Click button Customizing in SARA and then Change document lives.
Because you are trying to archive very young and just used materials the material documents you enter in the selection might not be old enough to be archived. Hence you need to change the residence time (document live) temporarily to 1 day
Answer:
Thanks for the good input so far!
I have a couple of questions regarding archiving of POs. I need to archive one of two items in a PO. How do I do this? Do I just delete the item in ME22N and then run the MM_EKKO?
Also, must the IR be posted to have a complete document flow before I start the archiving?
Thanks again!
Best regards,
zhivago
Answer:
Archiving object is named MM_EKKO. EKKO is the table for purchase order HEADER.
I think it is not possible to just archive 1 of 2 items in one PO.
If you do Goods Receipt based invoice verification, then it does not make sense to archive already a PO before the invoice is posted. How should invoice verfication then be able to check if the price is okay?
Archiving transfers data from many related tables into object oriented data. object oriented means more or less one large record per business case.
SAP archiving programms always check if business case is completed. If not, they do not allow to archive.
Answer:
Thanks for your quick reply!!
I will archive the complete PO with both items.
You see, the reason why I ask these somewhat strange questions is that this is not "normal" archiving. It is a clean up of existing documents, so I can be allowed to change the valuation category of a material. (Unfortunately this is the only way SAP allows me to do it!) Therefore what I really want is to delete the existing Purchasing docs, so I can run MM_SPSTOCK to delete the batch....
I take it from you that it is possible to archive the GR/GI (MM_MATBEL) first then the Delivery (RV_LIKP) and then the PO (MM_EKKO). In this specific scenario I do not have to create the IR to complete the flow.
Best regards,
zhivago