Alternate UoM

[Former Member]

Hello,

Is there anyway by which we can find out that a particular UoM has not maintained.

We are maintaining Alt UoM in 'Basic date-- Additional data --Unit of Measure'

These are Cartons, Pallets, Each,Thousand, Ream, PCS, Rolls etc... Whereas important one is CAR.

So to find out by entering the Material number etc, I did try with MARA,MARM etc. in form of query.

But that way it is listing up and it is pain to find out particular with CAR.

Regards,

JPS

[Former Member]

Hi,

Try this query.

SELECT MARA_{MATNR MARA}MEINS MARM_{MEINH MARM}UMREZ MARM~UMREN

INTO TABLE X_UOM

FROM MARA

JOIN MARM

ON MARA_{MATNR EQ MARM}MATNR

WHERE MARA_{MEINS NE MARM}MEINH

AND MARM~MEINH EQ 'CAR'.

Hope, It will help you.

Regards,

Poonam.

[JL23]

you have to use an outer join when you choin MARA and MARM.

Then you can search for material that do not have a MARM record with CAR.

[Former Member]

Hello Juergen,

As mentioned, I have already tried with the same (with MARA/ MARM) but that way It would list down multiple entries of each materials and to find out which one CAR is there or not it a pain.

Regards,

JPS

[JL23]

I think you did it with an inner join instead of outer join.

But you can compare as well in Excel,

download your material number from MARA, and all CAR records with material number from MARM.

Then do a VLOOKUP in Excel to see which MARA entry does not have a corresponding MARM entry.