Conversion Options
Simple conversions can be performed between units of measure that belong to the same dimension (such as meters to kilometers, kilograms to grams).
You can also perform InfoObject-specific conversions, such as an example where two palettes (PAL) of material 4711 were ordered and this order quantity must be converted to the stock quantity carton (CAR).
The way that you want conversion factors to be determined, is the decisive element in defining a conversion type.
Transfer all the tables relevant for unit conversion from other SAP systems connected to the SAP BW/4HANA system. Specifically, this includes the tables T006, T006A, T006B, T006C, T006D, T006I, T006J, and T006T.
Note
In the Data Warehousing Workbench, under Modeling, choose the source system tree. In the context menu of your SAP Source System, choose Transfer Global Settings. The Transfer Global Settings: Selection screen appears. Under Transfer Global Table Contents, select the Units of Measure field.
The specific options for dynamic determination of conversion factors are as follows:
Use reference InfoObject.
Use central units of measure (T006).
Use the reference InfoObject if available. Otherwise, use central units of measure (T006).
Use central units of measure (T006) if available. Otherwise, use reference InfoObject.
Dynamic determination of conversion factors allows for the determination to come from either a reference InfoObject (and the linked quantity DataStore Object (advanced)), from table T006, or both. If both, the order of operations is set and if the system fails to find it in the initial source, it searches the alternate source for final determination.
The following options are available for conversion factors:
Using a reference InfoObject
The system tries to determine the conversion factors from the reference InfoObject that you chose or from the associated quantity DataStore Object (advanced). Consider this scenario: you want to convert 1000 grams to kilograms but the conversion factors aren't defined in the quantity DataStore Object (advanced). In this case, the system can't perform the conversion (even though it's a simple conversion).
Using central units of measure
Conversion can only take place if the source unit of measure and target unit of measure belong to the same dimension. For example, meters to kilometers or kilograms to grams.
Using reference InfoObject if available, central units of measure if not
The system tries to determine the conversion factors using the quantity DataStore Object (advanced) you have defined. If the system finds conversion factors, it uses these to perform the calculation. If the system cannot determine conversion factors from the quantity DataStore Object (advanced), it tries again, using the central units of measure.
Using central units of measure if available, reference InfoObject if not
The system tries to find the conversion factors in the central units of the measure table. If the system finds conversion factors, it uses these conversion factors to perform the conversion. The system may not be able to determine conversion factors from the central units of measure. If so, the system tries to find conversion factors that match the attributes of the data record by looking at the quantity DataStore Object (advanced).
The settings that you can make in the system affect performance and the decision must be strictly based on the data set. Consider the following points:
If you are performing conversions only within the same dimension, the second option is most suitable.
If you are performing InfoObject-specific conversions (for example, material-specific conversions) between units that do not belong to the same dimension, the first option is most suitable.
NoteIn both cases above, the system accesses only one database table. That table contains the conversion factors.
With the third and fourth options, the system tries to determine conversion factors at each stage. If conversion factors are not found in the basic table (T006), the system searches again in the quantity DataStore Object (advanced), or in reverse.
The option you choose depends on how you want to spread the conversion. For example, the source unit of measure and target unit of measure may belong to the same dimension for 80% of the data records that you want to convert. If so, try to determine factors by using the central units of measure (the fourth option). Accept that the system must also search for the remaining 20%in the second table.
Conversion Factor from (Key Figure) InfoObject
The Conversion Factor from (Key Figure) InfoObject option (as with Exchange Rate from InfoObject in currency translation types) is only available when you load data. The key figure that you enter here must exist in the InfoProvider and the value this key figure has in the data record is taken as the conversion factor.
Source Unit of Measure
The source unit of measure is the unit of measure that you want to convert. During the data load process, the source unit of measure is determined dynamically from the data record or from a unit (quantity) attribute of an InfoObject (characteristic).
You can also specify a fixed source unit of measure or determine the source unit of measure using a variable.
When converting quantities in a Query, the data record determines the source unit of measure.
Target Unit of Measure
You have the following options for determining the target unit of measure:
You can enter a fixed target unit of measure in the unit conversion type (for example, kg).
You can specify an InfoObject in the unit conversion type that is used to determine the target unit of measure during the conversion. All InfoObjects that have at least one unit attribute type are listed under InfoObject for Determining Unit of Measure. Select one of these attributes as the corresponding quantity attribute.
Alternatively, you can specify that the target unit of measure is determined from a variable during the conversion.
