Change unit of measure

[Former Member]

Hi,

I'm working on a system used as demo system, I want to change a value in a field (unit base of measure), I know that is not possible but I would perform it directly in the related table.

Is there a trx which allows it?

SE16N for example?

[JL23 · Accepted solution]

dont fool around that way. You will create errors that are unusual and can only be solved fooling around in other tables using the same option.

There are so many dependencies that you certainly step into the one or other problem

See this OSS note : especially the last sentence:

From OSS note 138767

Within the material master record maintenance, you want to change the base unit of measure (base unit). During the change, the system performs extensive checks in order to avoid inconsistencies in the applications which use the material master.

In particular, the following checks are performed:

The base unit must not be defined as an alternative unit of measure for the material

No International Article Number must be assigned to the base unit

No proportion/product units must be defined for the material

No configurable material must be assigned

The material must not be used as a configurable material

Stock must neither exist for the previous period nor for the current period

No physical inventory must be active

No reservations or dependent requirements must exist for which the deletion indicator is not set

No planned orders must exist

No purchase requisitions, purchase orders or scheduling agreements must exist for which the deletion indicator is not set

No WM transfer requirements, no WM quants or no WM posting change notices must exist

The material must not be a bill of material

The material must not be contained in a bill of material

The material must not be used as a production resource/tool

The material must not be used in task lists

No standard cost estimate must exist for the current or future period

No production orders must exist

No planned independent requirements must exist

No run schedule headers must exist

If the base unit has dimensions, no serial number profile must be assigned

No sales and distribution documents must exist which have status Not processed or Partially processed.

Solution

If necessary, all reasons mentioned above must be eliminated by archiving the objects listed

[Former Member]

Hi,

look at this link:

http://www.sap-basis-abap.com/mm/changing-base-unit-of-measure.htm

The above link contain the following:

Changing Base Unit Of Measure (Material Master)

How to change the base unit of measure of a material when we already maintained already some stock?

Tips by: Dvj

Before changing the unit of measure is there any stock of that material avaiable?

Base unit of can't be changed once you have created the material and there are stocks.

Any successful changes in material master only took place when there is no open document from SD, PP, MM & FI for that material.

Base unit of measurement cannot be changed. The reason being material movement history is there in table - MSEG mainly which otherwise create inconsistency in reporting.

Instead, create new material and build stock by process in new and old materials.

1) You can only change the base units of measure under the following circumstances:

- No stocks are available for the material.

- There are no existing purchase requisitions, purchase orders, or scheduling agreements for the material.

- At present, no purchase orders or purchase order items are being created or changed. If requests for quotations, purchasing info records, or contracts are available for a material, the system gives a warning while changing base unit of measure. Still if you want to change unit of measure specify in a dialog box the factor for converting the base unit of measure into the new base unit of measure. The purchasing info records are then, if necessary, updated.

2) If there are Open purchase requisitions, purchase orders, or scheduling agreements for the material.

--Run MM02 (Change Material Master immediately.

--Overwrite the old base unit of measure with the new one in basic data screen.

--Save the change.

--System checks

If a change criterion (MM02) is meeting all necessary prerequisites (as mentioned in point 1), system allows changing base unit of measure. Otherwise it displays warning or error. You can display the reason for this, by choosing Display Errors (ctrl+F1)

Points to note:

You can change the base unit of measure if there is no stock of the material during current and previous period. Also, there should not be any open PO's & requistions.

SAP help describes in the following manner about change of unit of measure which is self-explantory:

Diagnosis: You wanted to change the base unit of measure. However, you can do so only under certain circumstances, including the following:

- If there are no stocks of the material in the current period and in the previous period.

- If there are stocks in the previous period, you can clear them as follows:

a) Post the stock in the previous period to the current period (for example, using movement type 561 Posting date 30.06.XX ) so that the stock for the previous period is the same as the stock for the current period.

b) Clear the stock with the posting date in the previous period (for example, using movement type 562 Posting date 30.05.XX).

- If no purchase requisitions, purchase orders, or scheduling agreements exist for the material.

Procedure : Choose Display errors to see why you cannot change the base unit of measure for this material.

The pushbutton Display errors appears only in dialog mode, not in data transfer or in mass maintenance. If this message appears in data transfer or in mass maintenance, and you want to know why the base unit of measure cannot be changed, access the material in dialog mode using the relevant transaction below, try to change the base unit of measure as required, and then choose Display errors:

Lastly, you can considered an Alternate Unit of Measure to do the Conversion from KG to Liter. You then could use your Alternate Unit of Measure as your

Purchased UoM and PLant UoM.

Given the level of activity sometimes required to change the base UOM, it often makes more sense just to add an alternative UOM on the material master.

Maintain the relationship between the Base UOM and the new UOM on the material master and then continue to procure the material in the new UOM rather than the base UOM. If stocks exist I would think it is unlikely that their existing UOM is incorrect as they must have been receipted in that UOM at some point.

In summary:

In the Material master you can maintain the Units of measure IN Material master,

- Base unit of measure in Basic data View,

- Purchase Order Unit in view purchasing (need to activate Variable order unit)

- Sales Order Unit in view sales org 1

- Unit of Issue in view Plant/storage data1

Maintain the conversion factors for all the Unit of measures used.

[Former Member]

???

[kunal_ingale]

hi

i think u havet read the note 138767 and the reply given by Jürgen L.

doing changes in SE16n can lead to inconsistancis

yes u have to archive or delete

regards

KI

[Former Member]

Hi,

Using SE16N,you will be displaying entries at the table level.In any case, deleting entries at table level is not an acceptable practice.

Thanks,

Kaveri

[kunal_ingale]

hi

i is not possible through the table entry

as MARA table cant make direct entries

u have to make stock NIL then delete all the docs related to that material and then try

going through SE16N can create inconsistancy in data

u ccan try it on dev server

regards

KI

[Former Member]

Hi,

with "delete all the docs related to that material" do you mean archiving ?

Regards

[Former Member]

Hi,

Yes, you have to do that Txn in TCODE SE16N.

First go to SE16N and enter the table name and press enter.

then at Command prompt enter &sap_edit then the table goes into change mode activation, this message u can see in the bottom of SAP screen.

now press execute after selection of required fields

then when u enter into the values screen change the required modification value and then press save.

come out of the screen and then again check in se16n or where ever u want to see it.

i hope u got the procedure, let me know if u require any further clarifications.

thanks

[Former Member]

Hi,

I don't see any command prompt in SE16N

[Former Member]

Hi

Changing data directly in the table is not advisable, as this will disturb the data in the other tables as well.. using the debug functionality in SE16N you can chnage the UOM

Thanks & Regards

Kishore