Unit of Measures.

[Former Member]

HEllo Experts.

In our R/3 systems we have 3 Ztables. Each tables holds 3 different quantities with different UOMs. We created Generic data source for that tables. In BW we created 3 different ODS for each tables.

At the time of creating the Info objects for the fields in R/3 for Quantity fields, we gave 0UNIT as UOM.

Example in table 1:

1. Field In R/3 is (HCMGRQTY) and UOM is Meins(LACS)

Infoobject in BW (ZHCMGRQT) and UOM is (0unit)

2. Field In R/3 is (AVGWT) and UOM is Meins(KGS)

Infoobject in BW (ZAVGWT) and UOM is (0unit)

When mapping in transfer rule, we can map 0unit to only one field in R/3, for the other fields i am leaving blank as i cannot use the same object twice in same transfer rule.

Q1. Now will i face any problem if i dont assign any object to that particular field?

Q2. we have three different ODS in the same way and this three ODS are used as source to one Main ODS. In update rules of each source 0unit is getting updated. I want to know how will this 0UNIT get updated when it comes from three different ODS. Hope i am clear. Thanks in advace

Regards

Srikanth

[Former Member · Accepted solution]

1 - You are mapping your KFs to corresponding fields, and 0UNIT is automatically mapped to the corresponding unit. If there are 3 datasources (is it so?), I do not see any problem. If it is the same datasource extracting data from the 3 tables (like a inner join or view), you are essentially bringing only one UOM and assigning it to the three KF - a totally incorrect situation.

2 - This is dependent on the above. If you are not bringing the data correctly, you will not be getting the right values in your main ODS.

[Former Member · Accepted solution]

Hi Ajay

Actually the situation is like this

DS1: <b> zabc---> ODS 1:zhcm</b>

DS2: <b>zxyz--->ODS 2:zdtm </b>

DS3: <b>zmno--->ODS 3:zsod </b>

IN ODS1 : i hve 3 qty keyfigures and unit as 0UNIT for all.

IN ODS2 : i hve 3 qty keyfigures and unit as 0UNIT for all.

IN ODS3 : i hve 3 qty keyfigures and unit as 0UNIT for all.

Now this three ODS objects are going into one <b>MAIN ODS</b>. I think i will have a problem in update rules for 0Unit as it is getting updted from 3 different sources.

After the first infopackage 0unit will get updated.

When i run the second infopackage 0unit will get overwrite.

I am not sure just guide me if i am wrong

Regards

Srikanth.

[Former Member · Accepted solution]

Hi Srikanth,

Are the records in the three ODS have common key-fields? If yes, you have a problem.

In this case, you can add ZUNIT1,ZUNIT2 infoobjects (of type unit) to the main ODS, and update these from the 2nd and third ODS.

[Former Member · Accepted solution]

hi ajay

Thanks for your reply ..this is the answer what i was looking for..yes i have common keyfields in my ods

Regards

Srikanth.

[Former Member · Accepted solution]

HI,

Instead of giving 0UNIT as the unit field for different keyfigures, give different unit fields in the info object edit screen. I hope, we can find out lot of unit field which are built on the basis of 0UNIT(as reference).Use them.

With rgds,

Anil Kumar Sharma .P

[Former Member · Accepted solution]

Hi Anil

Thanks for your reply. Actually i created Zunits and assigned to my Zinfoobjects.

Regards

Srikanth