cancel
Showing results for 
Search instead for 
Did you mean: 

Problem on archieving Material Master (con)

former_member287204
Participant
0 Kudos

Dear Experts,

Further to the following Forum –

http://scn.sap.com/thread/3505830

I recently tested to archieve a Finished Good Material and found the following errors -

Error 1 –

MARC: 8200 planned order exists

Message no. W4008

Diagnosis

A planned order exists for the material. Procedure Delete the planned order. You can then archive the material.

Error 2 –

MARC: 8200 assignments (product group/planning) exist

Message no. W4024

Procedure

Delete the assignment of the material to the product group. You can then archive the material.

Error 3 –

MBEW: 8200 plant is assigned to the valuation area

Message no. W4031

Diagnosis

The material cannot be archived for this valuation area since the material is still used in dependent tables.

Procedure

Delete these dependencies. You can then archive the material for the valuation area.

Error 4 –

MARC: 8200 internal use of the material

Message no. W4107

Diagnosis

The material is still being used internally by another material.

Possible ways in which the material is being used:

As a pricing reference material

As a configurable material

As a follow-up material

As a manufacturer part number

The material may be in use both at material level and at plant level.

Error 5 –

MARA:  Dependent material master data still exists

Message no. W4134

For the Error 1, the above Forum had advised to check table PLAF and then found some Planned Orders for the Material in there. Would like to ask –

Q1) Why the Planned Orders could not be found in some transactions such as MD04 / MD16 (collective display planned orders) but could only be found in the table PLAF ?

For your ref., the following error was found when inputting those Planned Orders in MD14 (convert planned order to PR) –

Simulation planned orders cannot be converted

Message no. MD132

Diagnosis

The planned order selected is a simulative planned order from long-term planning. In long-term planning, the system only creates planned orders. These planned orders are not converted into either production orders or purchase requisitions. System Response Planned orders that are created in long-term planning cannot be converted. They are used to check the effects of the simulative demand program on production and procurement. Thus, a preview is availble of the planned demand program. The planned orders are changed or replanned in the operative planning run.

Q2) After deleting the Planned Orders found in the table PLAF using MD12 and then tested to archieve again, the above Error 1 was not found, but the rest of 4 Errors were still found. According to the above Forum (msg on 2014-2-27 7:52), the Error 5 (Message no. W4134) is a warning and will be fixed AFTER the other Errors have been fixed. Is it correct ?

Q3) Anyway, could you advise how to solve the above Errors 2-5 ?

Ref. SAP Note 900537 –

For Error 3 (W4031) - Plant is assigned to the valuation area:

The material cannot be archived for this valuation area since the material is still used in dependent tables. Delete these dependencies. You can then archive the material for the valuation area. This message is created when the MARC entry for valuation area has a check error, but there is no check error for the assigned MBEW entry.

Actually no exact solution on the above info. ?

For Error 4 (W4107) - Internal use of the material:

First, error message W4107 indicates that the material is used as an internal material for another material. Go to table MARA for this material and check fields BMATN and MFRPN.

Please call the function 'MG_BEZUG_MARA_CHECK' with the material and it should give you back a flag, if article is used or not

Also it can be possible that the material is used in table fields

MARA-PMATA

MARA-PMATN

MARC-NFMAT

MARC-STDPD

MARA-BMATN

MVKE-PMATN

Does it mean that we have to write program to call function 'MG_BEZUG_MARA_CHECK' to fix this error ?

For Error 5 (W4134) - Dependent material master data still exists:

Please refer note 561972. Also delete the routings / BOMs / PO for these Materials.

For the note 561972, does it mean that we have to apply Correction “SAP_APPL” ? If so, which Correction no. is suitable for ERP 2005 ? If the above Q2 is correct, is it still required to apply this Correction ?

Looking forward to hearing from your reply.

Many Thanks,

KH Fong

Accepted Solutions (1)

Accepted Solutions (1)

JL23
Active Contributor
0 Kudos

1) MD04/MD16 is for operative planning, but your planned orders are from a simulation, hence they will not be shown to not confuse the people. Talk to your planners to know about the best transaction to show such planned orders (just in case SE16 at table PLAF is not enough for you)

2) All messages are warning messages, however, they prevent you from archiving. Yes this message can go away automatically if other issues are solved. But this is not always the case and cannot be said in general. If it is the last and only error message you have then you may need to debug to know what is causing it.

3) Usually the plant is itself the valuation area. The only other option is if your valuation area is at company code level. Do you really have this error?

4) Of course you can create such program. I would just do SE16 to check if those fields are used in our process at all. If that is the case in general then it might be a good option to have such check report before you start with archiving.

5) if you see this error message then this note is already applied, it is also already in your system if your release is above the mentioned releases.

former_member287204
Participant
0 Kudos

Dear Jurgen,

Thanks for your reply. Regarding your reply -

Q1) -

1) Does it mean that both the normal planned orders (can be shown in MD04 / MD16) and the simulation planned orders are saved in the table PLAF ? and Does it mean that there is no standard transaction code to show the simulation planned orders, but have to customise report to show these orders ?

Q2) -

2) As I found these messages were in red light (as below), why you said "All messages are warning messages" ?

Q3) -

3) Our valuation area is at plant level. Then, how to fix this Error 3 (W4031) ? The above SAP Note 900537 didn't advise how to delete the dependencies.

4) Except the table field - "MARA-PMATN" which could not be found, I had searched the above tables' fields but nothing was found for the Material. Then, how to fix this Error 4 (W4107) ? Still customise program to call the above mentioned function or else ?

5) Our release is ERP 2005. Is this Error 5 (W4134) a warning or an error actually ? If error as well, how to fix it ?

6) Also, how to fix the Error 2 ?

MARC: 8200 assignments (product group/planning) exist

Message no. W4024

Procedure

Delete the assignment of the material to the product group. You can then archive the material.

Many Thanks,

KH Fong

JL23
Active Contributor
0 Kudos

Sorry I was confused tonight about the W in front of the message

Usually the W stands for warning, but here it is just part of the message class.

So all messages are errors and prevent archiving of a material

Please, if you try to archive materials, then get all people together who use material in their processes.  This is the normal way an archiving project is setup. 

As said yesterday, the PP experts (consultants or even key users) usually know the transactions for this simulation planned orders, and yes they are stored in the same table and have probably an indicator in one of the fields to enable MD04 not to display them. You may even find the user who created those records from field PUSER in table PLAF and talk to him directly to get a transaction for the display. 

You may have to debug the archiving program to know when this message W4031 is issued, as you have material with this message it should be possible for you or an ABAPer, I browsed a few check programs but could not locate the program with this message. Eventually you have to write to SAP to elaborate on this error message, convince them that the note is to vague.


You can call the function module directly from SE37 to investigate a single case.


Product group assignment is probably maintained via MC86, but this is also a topic of your PP consultant.



former_member287204
Participant
0 Kudos

Dear Jurgen,

Thanks for your advice again.

For the Error 5 (W4134), if it is an error as well, how to fix it ?

For the Error 2 (W4024), there is no value in MC86 and we are not used to using the Product Group, could you also advise how to solve this problem ?

Tks,

KH Fong

JL23
Active Contributor
0 Kudos

Regarding W4024 Check again using SE16 at table PGMI

the check is made in MMREO012 and this is calling FUNCTION 'MC_PG_MITGLIEDER_GET'

and this FM is checking at table PGMI

there is more coding for PRGRP checks in this MMREO12, if has to do with sales plan then the product group is check against an entry in table  P445V



former_member287204
Participant
0 Kudos

Dear Jurgen,

Found related data in table PGMI but without data in table P445V. Does it mean that the Error 3 (W4024 - MARC: 8200 assignments (product group/planning) exist) can be solved AFTER clearing the data in the table PGMI ? If so, how to clear these data ?

For the Error 5 (W4134 - Dependent material master data still exists:), if it is an error as well, how to fix it ?

Many Thanks,

KH Fong

JL23
Active Contributor
0 Kudos

Ask your PP guys to know what they are doing. I gave you the transaction MC86 which is used in our company to maintain entries in PGMI. There might be other transactions that I am not aware of, I am not working in PP module. 

There are many tables in SAP which are used from different transaction, like EKKO, can be maintained with ME21N and with ME31K and ME31L. You cannot open a contract with ME22N and not a purchase order with ME32L, even there data is in the same table.

That is why you need to have module expert in a project. SAP is not a one-man show. I have about 20 years experience with different SAP modules, mainly MM, SD and LE and work  in MDM department doing data loads and archiving and some ABAP and still cannot give you a 100% answer on this question. I need my experts too, especially because I would not want to take the full responsibility alone, it is always better to have this put on many shoulders, especially as archiving is a kind of working on the heart of SAP. If you do something wrong you may not be able to bring the data back to the database.

former_member287204
Participant
0 Kudos

Dear Jurgen,

Then, which module is related to the Error 5 (W4134 - Dependent material master data still exists:) ?

Tks,

KH Fong

JL23
Active Contributor
0 Kudos

Can be any. I once had it with EH&S data.

Care about the other messages first and see if this one will finally stay alone or vanish together with the last other message

Former Member
0 Kudos

KH,

Another way data can be created in table PGMI is by entering a Planning Material in the Material Master (MRP3 view of material master).  Remove these entries/save, and it automagically removes the PGMI entries.

Best Regards,

DB49

former_member287204
Participant
0 Kudos

Dear DB49,

Thanks for your advice. Found that the problem was due to three fields - "Planning material", "Planning plant" & "Plng conv. factor" under the "MRP 3" view of the Material who assigned the main Material (to be archieved) as the "Planning material", i.e.

In table PGMI, the highlighted Material is to assign the main Material (to be archieved)

After removing the three fields for the Material who assigned the main Material (to be archieved),

The relevant record in table PGMI could then be removed.

Could you advise what is the usage for these three fields under the "MRP 3" tab of the Material Master ?

For your ref., AFTER clearing data in the above table PGMI and trying to archieve the Material again, not only this Error 2 (W4024) could be solved, but also the rest of above Errors 3-5 could also be solved. Refer the following messages which are all green lights -

Many Thanks,

KH Fong

Former Member
0 Kudos

Kwok,

Could you advise what is the usage for these three fields under the "MRP 3" tab of the Material Master ?

I hope you have not failed to heed expert Jürgen's advice about convening a team of people to manage the archive process. 

I am going to assume that you have done so, but the users on the team were unable to answer the question you just asked. My advice is that archiving must never be done by IT in isolation.  I promise you that you will regret this if you try.

Planning Material and the related fields are used in two Planning strategies.  The field in the Material Master is used to establish the linkage between a Finished Goods material and a Planning Material.  For more info about Planning materials, read SAP help about Planning Strategies 60 and 63 for a start.

Planning with a Planning Material (60) - Demand Management (PP-MP-DEM) - SAP Library

Planning w/ a Planning Material and w/o MTO (63) - Demand Management (PP-MP-DEM) - SAP Library

Best Regards,

DB49

former_member287204
Participant
0 Kudos

Dear DB49 & Jurgen,

I just tested to archieve such kind of Material nos. in QA system. The final list(s) of Materials with related docs. should be confirmed by users. Actually, the final execution of archieving should be handled by IT and users do never know those archieving functions, tables and objects etc. technically. That's why I have to test to prepare it technically so as to be able to co-operate with end users.

Just would like to clarify some more -

According to the flow of archieving Material Master (MM_MATNR.pdf) downloaded from SAP, Material documents (Object: MM_MATBEL) and Billing documents (Object: VBRK) are also required to archieve BEFORE archieving the Material nos.(Object: MM_MATNR). However, for my above testing, it is NOT required to archieve these two kinds of docs., only required to archieve Delivery notes (Object: RV_LIKP), Sales docs. (Object: SD_VBAK) and Production orders (Object: PP_ORDER). Therefore, will there by any impact if I archieved the Material nos. (Object: MM_MATNR) w/o archieving the Material documents (Object: MM_MATBEL) and Billing documents (Object: VBRK) ?

Tks,

KH Fong

JL23
Active Contributor
0 Kudos

Read the technical reason why material documents are not checked in OSS note 547867 - FAQ: MM_MATNR Archiving of materials


Nevertheless there is certainly an impact if you remove materials from the data base but still have material documents.

First of all they are a kind of orphaned after the archiving of the materials. They are in the MKPF/MSEG table and maybe included in some reports but you wont see a material description which makes the information useless and disturbing.


While I can understand the technical reason which is given in the OSS note (one material document can have several lines for different materials) I still the opinion it is a kind of theoretical. The material master is from my point of view one of the last archiving objects that can be executed because of it long chain of dependencies. And the material documents are the most easy straight forward archiving object that exists in SAP. No dependencies at all.

Anything is accessible in the archive, so the usual way of archiving is to archive those object that are easy to archive and are very large objects which bring a benefit immediately are the first who are executed. So you rarely find a case in reality where you have movements when you archive materials.


you should search and read all archiving object related OSS notes  before you archive, it is really giving knowledge and safety.



Even you want prepare yourself before you include keyusers you should not hesitate to contact them already occasionally to speed up your process. A telephone call to colleague is much quicker than a discussion in SCN which spreads over more than a week

former_member287204
Participant
0 Kudos

Dear Jurgen,

Thanks for your advice and info. for the Material docs. (Object: MM_MATBEL). How about the Billing docs. (Object: SD_VBRK) ? Will there be any impact if skipping to archieve this object when archieving the Material Master (Object: MM_MATNR) ?

Tks,

KH Fong

former_member287204
Participant
0 Kudos

This message was moderated.

Answers (1)

Answers (1)

former_member594003
Discoverer
0 Kudos

same issues i am facing