KF Unit Conversion based at : RSUOM + 0MATERIAL + UOM0MATE

[#1]

Hello, guys.

I have query, with various materials, having various units.

Task:

Aside with original field (green) I want to add a conversion unit field (purple):

And for this taks it is not possible to use simple formulas, or fixed rsuom-conversions, because, as you can see, this query contains a lot of different units of measure.

Also, even for conversion from KG to T there can be different coeffitient for each material!

I focus attention at material 1002005, as it is in kilogramms, and must be in tonns.

OK, so based at manual: Quantity Conversion Guide for SAP BI.pdf

I am trying to solve this taks, using combo:

0MAT_UNIT_ATTR + 0MATERIAL (DSO:UOM0MATE ) + RSUOM (not fixed).

So, here are the steps I have made:

1. Implemented 0MATERIAL with DSO UOM0MATE:

2. Replicated 0MAT_UNIT_ATTR from BC, provided it with data.

Build dataflow from it to DSO, reading MD for 0BASE_UOM:

3. PSA of 0MAT_UNIT_ATTR is loaded as follows.

As you can see for the material 1002005 there are 2 records:

4. Checked table MARM at source ERP, and the values for this material are the same.

5. DSO UOM0MATE is loaded with data:

6. Meanwhile, I can see only one record in 0MATERIAL, and it is KG.

7. In RSUOM I created this conversion type:

8. In transformation for InfoCube I created such Rule for my new KF:

9. Ok, now infocube is loaded, and I created such KF in query using these settings:

And now, when I run query, I expect to see Tonns for material:

But, as you can see - NO EFFECT - it is still kologramms.

So, the main question is - what am I doing wrong?

Here are some guesses and suspicions:

1. I still dont really understand the whole logic of this mechanism, and miss something...

2. Why 0UNIT in InfoCube is Empty? Maybe this is a key for something...?

3. What if my new KF must be based at its own unit, not 0BASE_UOM ?

[anshu_lilhori]

Hi,

I am not sure if you have already gone through this document.

In this different ways of reporting in alternate unit of measurement has been described in detail.

Please check if this helps or not.

https://archive.sap.com/documents/docs/DOC-11542

Regards,

AL

[former_member595258]

Hi Anshu! Thansk for your answer.

Well, I based my efforts exactly at this very document.

I used Unit-3 and pages 15-18 from it.

But! in that case author uses 0volumeunit, which is more narrow example.

And I tried to create some wide and universal mod of that example, based only at 0base_uom.