1a) Master Data: Compound Characteristic - crxmatKl
#C2PLANT |
#C2COUNTRY |
#Crxmatkl |
0base_uom Base Unit of Measure |
0apo_storgu Stock Level |
---|---|---|---|---|
P001 |
DE |
4711 |
UNIT |
PAL |
P001 |
DE |
4712 |
ROL |
PAL |
P002 |
G.B. |
4712 |
KG |
PAL |
P025 |
SE |
4713 |
UNIT |
PAL |
The unit 0base_uom is entered as the base unit of measure in the master data on the Business Explorer tab page.
The DataStore Object uomcrxkl is also created and activated from the master data (
).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 - not listed in following table>
#Crxmatkl |
#C2PLANT |
#C2COUNTRY |
#0UNIT |
0base_uom |
0uomz1d |
0uomn1d |
---|---|---|---|---|---|---|
4711 |
P001 |
DE |
G |
UNIT |
1 |
25 |
4711 |
P001 |
DE |
CAR |
UNIT |
240 |
1 |
4711 |
P001 |
DE |
BX |
UNIT |
24 |
1 |
4711 |
P001 |
DE |
PAL |
UNIT |
9600 |
1 |
4712 |
P002 |
G.B. |
G |
KG |
1 |
1000 |
4712 |
P002 |
G.B. |
UNIT |
KG |
1 |
5 |
4712 |
P001 |
DE |
TO |
ROL |
2 |
1 |
4712 |
P001 |
DE |
UNIT |
ROL |
1 |
450 |
4713 |
P025 |
SE |
CAR |
UNIT |
1 |
0 |
4713 |
P025 |
SE |
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
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.
Material 4712: Plant P002: InfoObject-specific conversions are possible between:
G, UNIT, KG
Material 4712: Plant P001: InfoObject-specific conversions are possible between:
TO, ROL, UNIT
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: uomcrxkl
#Crxmatkl |
#C2PLANT |
#C2COUNTRY |
#0UNIT |
0base_uom |
0uomz1d |
0uomn1d |
---|---|---|---|---|---|---|
4711 |
P001 |
DE |
G |
UNIT |
1 |
25 |
4711 |
P001 |
DE |
CAR |
UNIT |
240 |
1 |
4711 |
P001 |
DE |
BX |
UNIT |
24 |
1 |
4711 |
P001 |
DE |
PAL |
UNIT |
9600 |
1 |
4711 |
P001 |
DE |
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 0base_uom does not contain the base unit of measure from the master data (UNIT).
2) Master Data cruom1 (can be used to calculate the unit of measure from the unit of measure attribute)
#CrUOM1 |
#CRF1 |
0SALES_UNIT |
0UNIT |
---|---|---|---|
M1 |
C1 |
KG |
G |
M2 |
C2 |
CAR |
BX |
M3 |
C3 |
PAL |
UNIT |
3) Master data cruom1kl (can be used to calculate the unit of measure from the measure attribute)
#CrUOM1 |
#0bp_contper |
#CRF1 |
0SALES_UNIT |
0UNIT |
---|---|---|---|---|
M1 |
Akino |
C1 |
KG |
G |
M2 |
Bertolini |
C2 |
CAR |
BX |
M3 |
Smith |
C3 |
PAL |
UNIT |
Examples
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