Unit conversion with 0UNIT_MAT
I need sales statistics using a statistic unit of measure (atribute of 0MATERIAL) which is either the base unit of measure or the sales unit, so I need to convert i.e. order qty. in the BW system.
I have 2 doubts I will like to share.
First) What's the best place to do the conversion? Transfer rules or update rules. Initially I'm in favour of the transfer rules because no matter what the user want's to do later with the data, I will have it converted at an early step. i'm not doing at the datasource (in R/3) because the statistical unit is not informed in the R/3 system.
Second) I need to use the conversions available in 0MAT_UNIT to convert to the target unit. Has anyone written any code using it. I'm not a programmer and would appreciate some help here.