#CMAT07 |
0base_uom Base Unit of Measure |
0apo_storgu Stock Level |
4711 |
UNIT |
PAL |
4712 |
KG |
PAL |
4713 |
UNIT |
PAL |
The unit 0base_uom is entered as the base unit of measure in master data maintenance on the Business Explorer tab page.
The DataStore Object UOM07 is also created and activated in master data maintenance (tab page: Business Explorer → Units of Measure for Char.).
The structure of a DataStore Object always complies with the following rule:
<characteristic> <compounding for characteristic, where applicable>
<target unit of measure> <base unit of measure> <conversion factor: counter>
<conversion factor: denominator> <SID columns for all characteristics>
#Cmat07 |
#0unit |
0base_uom |
0uomz1d |
0uomn1d |
4711 |
G |
UNIT |
1 |
25 |
4711 |
CAR |
UNIT |
240 |
1 |
4711 |
BX |
UNIT |
24 |
1 |
4711 |
PAL |
UNIT |
9600 |
1 |
4712 |
G |
KG |
1 |
1000 |
4712 |
UNIT |
KG |
1 |
5 |
4713 |
CAR |
UNIT |
1 |
0 |
4713 |
BX |
UNIT |
0 |
2 |
The table is read as follows:
1 UNIT @ 25 G
240 UNIT @ 1 CAR
24 UNIT @ 1 BX
9600 UNIT @ 1 PAL
For material 4711: InfoObject-specific conversions are possible between:
UNIT, G, CAR, BX, PAL
The conversion is always performed using the base unit of measure and therefore is performed in a maximum of two steps. If, for example, you convert from PAL to BX, the system first converts from PAL to UNIT and thereupon from UNIT to BX.
For material 4712: InfoObject-specific conversions are possible between:
G, UNIT, KG
For material 4713: InfoObject-specific conversions are possible between:
CAR, UNIT, BX
Theoretically you could try to load the quantity DataStore object as follows (aim: convert CAR directly to BX and BX to CAR):
Quantity DataStore object: UOM07
#Crxmatkl |
#0unit |
0base_uom |
0uomz1d |
0uomn1d |
4711 |
G |
UNIT |
1 |
25 |
4711 |
CAR |
UNIT |
240 |
1 |
4711 |
BX |
UNIT |
24 |
1 |
4711 |
PAL |
UNIT |
9600 |
1 |
4711 |
CAR |
BX |
10 |
1 |
The direct reference between CAR and BX is specified in the last row. This entry is incorrect on one hand because the primary key is violated if data record 2 already exists in the object. If record 2 does not already exist, the entry is still incorrect because the column 0base_uom does not contain the base unit of measure from the master data (UNIT).
#cruom1 |
Crf1 |
0sales_unit |
0unit |
M1 |
C1 |
KG |
G |
M2 |
C2 |
CAR |
BX |
M3 |
C3 |
PAL |
UNIT |
#cruom1 |
#0bp_contper |
Crf1 |
0sales_unit |
0unit |
M1 |
Akino |
C1 |
KG |
G |
M2 |
Bertolini |
C2 |
CAR |
BX |
M3 |
Smith |
C3 |
PAL |
UNIT |
The examples listed below are based on the example data given above. These examples illustrate the results produced by the different options available with unit conversion:
Examples of Conversion with Fixed Target Unit of Measure
Examples of Conversion Using Factor from InfoObject
Examples of Conversion with Target Unit of Measure Using Attribute in InfoObject
Examples of Conversion with Fixed Target Unit of Measure and Dynamic Determination Without Options