Production Report for Quantity produced.

[Former Member]

Hi PP Gurus,

We want to capture a report wherein we need to capture quantity produced against work center/production order. Finished product got base unit of measure and alternate unit of measure like Base UoM= EA

Alternate UoM= Case and Bottles

Now the requirement is report should comprise of Actual unit produced in Base UoM and all alternate UoM.

What can be done to resolve this issue.

Thanks & Regards,

Abu Arbab

[Former Member · Accepted solution]

Hi,

You can create a Z development using the Order tables : AFKO /AFPO/AFUM/AFRU.

You can provide the Order type in the table and fetch the order number and qty in BUOM. You can insert a new column for Alt UOM and calculate the production qty interms of Bottles and Cases.

Hope this will help you.

regards

radhak mk

[Former Member · Accepted solution]

Hi Radha MK,

Thankd for input.

This report we're going to build in BI. See in MMBE transaction code whatever Base UoM or Alternate UoM we can see what's the function module or logic behind that, that we can't bring and develop report?

Please cpme back with suggestions.

Thanks & Regards,m

Abu Arbab

[Former Member · Accepted solution]

Hi Radha MK,

Thanks for input.

We got a table MARM which will store all UoM and their conversions for a material and plant combination and moreover FM is also available for the same.

Best Regards,

Abu Arbab