ECC to EWM mapping of materials per warehouse/st.type/st.bin

[OnnoE]

Hi guys,

For the client i'm trying to gather the mapping from ECC to EWM for a report we want to build for products per warehouse, st.type, st.bin and we want to see the uom for a specific type of hazardhous. Till now I've used this:

from ECC

Product from MARA (field MATNR)

to EWM

table: /scwm/aqua with fields whse nr(LGNUM), st.type(LGTYP), st. bin(LGPLA), product(MATID).

Via the parent & Guid stock ID's I check this in table /scwm/QUAN:

There I can find the uom for all products in st.type/bin per warehouse and the total amount of each uom.

But now I want to add the hazardhous rating, to complete the report. Does anyone have any experience in this?

BR Onno

[PatrickMueller · Accepted solution]

Hello Onno,

are you writing a hazardous substances inventory list?

Have you evaluated the existing EH&S Inventory Report yet before writing one on your own?
The transaction code is /SCWM/ILHS
That report gives you the product quantities per storage type and storage bin as well as hazard rating and additional information from the EH&S substances master.

^^ Even better than writing everything on your own.

Even if your use case cannot be covered via the report, you could copy it and enhance it for your needs instead of writing a report from scratch ...

Best regards,

Patrick

[OnnoE]

Hi Patrick,

I know this transaction, but the problem I have with this report is that I need to change all regular products to hazardous, but I don't want that. I've chosen for another option to show the necessary data with SAP BW.

BR. Onno