Solved: DG Profile indicator - Mass update/export

Former Member · ‎2012 Aug 13

Hi,

We have more than 100 materials in the Material Assignment tab in a REAL_SUB, is there a way to set the DG indicator Profile for all the materials in the REAL_SUB without going through MM02 one at a time?

Also is there a way to copy or export the materials from Material Assignment tab into a Excel spreadsheet without using ESTMJ table?

Thanks,

David

Former Member · ‎2012 Aug 15

Hi David,

Here is the procedure to change a DG Indicator field for 100 or more materials.

As correctly mentioned by Christoph, this is MM part and not a EHS part.

In MM Domain, this is called as "Mass Change"

here is the procedure to do mass change for DG Indicator profile.

1) Go to Transcation MASS and select object type "BUS1001" and execute

2) select MARA-PROFL in tab "Fileds" as shown below & Execute

3) Select / copy the Material or Materials and execute

4) Enter the DG Profile "GPP" at uppper section, and then click "Carry Out Mass Change Button" (6th button from left) so that value GPP will come in front of material/materials as shown below and finally SAVE.

5) After saving, the Green message will come as below shows that, DG indicator successfully updated in materials

6) Bingo.... now our value is updated in Material as shown below

In this way we have updated the DG Indicator profile fields simultenuously in all the materials.

I hope this will help you.

Do let me know, if you are facing any issue / problem in mass change.. happy to help you..

Regards

Amol

christoph_bergemann · ‎2012 Aug 14

Dear David

the DG indicator profile is linked to MM only and not part of EH&S. To my knowledge no suitable process exists to perform a "mass update" using MM transactions.

The whole topic mainly depends on your business process and how you reflect that in SAP.

Option 1: per material type you can prepare (to my knowledge) by using customizing a set up in such a way that any new material does have the "GPP" profile immediately.

The "problem" is that may be you need not this indicator but a different one; the same is true regarding the "relevance indicator" (EH&S relevant) on material type level. Here you can prepare "default" values by using customizing; but the user must change that if necessary

Option 2: you could prepare a customer transaction which "simulates" MM02 and use a list of materials which you than "classify" by mass to GPP or to a different profile; same process could be use to handel the EH&S relevance indicator

Regarding second topic: in most cases tu use an output variant is the best option. Here you use a hitlist and the perfoprm a mass download (e.g. by using the ALV technique etc.). Furtheron there is an existing ouput variant: in SAP standard. This output variant is explained/mentioned here:

http://help.sap.com/erp2005_ehp_06/helpdata/en/a7/2871910a6c11d28a220000e829fbbd/content.htm

SUB_OUTPUT

Selected header data and properties are output in the SAP system, with Microsoft Excel, or in a browser in HTML format.

Only "con" is: it is not EXCEL oriented but HTML oriented.

Hope this helps.

C.B.

PS: a number of subprocesses related to EH&S area are not part of EH&S; one further example is the material class which you can use to indicate e.g. REACh relevance

DG Profile indicator - Mass update/export

Know the answer?

Need more details?

Accepted Solutions (1)

Accepted Solutions (1)

Answers (1)

Answers (1)