SAP MM material scenario

[Former Member]

Dear all Gurus,

This is a typical situation which is related to Material Data.

Company is an Engineering Industry & they have some materials that are alternatives to other materials. These materials are perfect substitutes of each other & are known as alternatives.(the user can consume either of the materials or both).

How to maintain the relation between the alternatives in SAP?

How the MRP considers the quantity of each alternative for the MRP calculation?

Plz. explain in detail with example.

Thanx in advnce to all.

Regards,

Rajesh

[Former Member]

thnx to all.

[Former Member]

Hi,

For alternate material it is difficult to run MRP .

Instead if you are using for some product better put the alternate material in the BOM then only MRP will plan.

Say there are 5 products are manufactured and in two product you can give the Alternate material in BOM

(or)

In Engg Industry it is common ,better to change the partno for the Alternate material in the Material Master you can track the no.

SPLIT VALUATION IS DIFFERENT CONCEPT

G.Ganesh Kumar

[Former Member]

Dear Ganeshji

can u plz. explain with one example, how to configure and wt are the steps to be taken care for running the functions correctly.

Regards,

Rajesh

[Former Member]

Dear,

The SAP R/3 System allows you to valuate stocks of a material either together or separately, that is, according to different valuation criteria.

Split valuation is necessary if, for example:

1. Stock from in-house production has a different valuation price than externally procured stock.

2. Stock obtained from one manufacturer is valuated at a different price than stock obtained from another manufacturer.

3. Different batch stocks of a material have different valuation prices.

4. Value damaged and repair part differently from a new part.

To used split valuation, you have to activate it using 'OMW0'.

To change split material valuation once it has been set, you must

1. first post out all stocks (for example, to a cost center or with movement type 562)

2. then change the control parameters

3. if necessary, change the automatic account determination

4. finally post the stocks back in again

In split valuation, you can distinguish between partial stocks of a material according to certain criteria and valuate them separately.

The material stock is divided according to valuation category and valuation type.

The valuation category determines how the partial stocks are divided, that is, according to which criteria.

The valuation type describes the characteristics of the individual stocks.

With the function "Setting" you can determine:

which valuation categories exist in your company (global categories)

which valuation types exist in your company (global types)

which valuation types belong to which valuation category

which valuation categories exist in a valuation area (local categories)

Your entries are only relevant if you set split valuation as active in the function "Global settings".

In the standard SAP R/3 System, the following valuation categories are default settings :

B procurement type

with the valuation types:

"EIGEN" for in-house production

"FREMD" for external procurement

H Origin

X automatic valuation (only for batch)

To select split valuation ('OMWC'), proceed as follows:

1. Determine the valuation categories and valuation types that are allowed for all valuation areas:

global valuation categories via menu "Goto --> Global Categories"

global valuation types via menu "Goto --> Global Types"

2. Allocate the valuation types to the valuation categories.

a) Select "Goto --> Global Categories".

b) Position the cursor on a valuation category and select

"Goto --> Global Categories --> Assignments --> 'Types->Category'".

c) Activate the valuation types you want.

3. Determine the local valuation categories for each valuation area.

a) Select "Goto --> Local definitions".

b) Position the cursor on a valuation area and select

"Goto --> Local Definitions --> Allocate Categoires->Org.units (button Cats->(OU)".

You obtain a list of the global valuation categories.

c) Activate the categories to be used in this valuation area.

The system creates the local valuation types based on the allocations under point 2.

Only now can you create a master record with split valuation.

Specifying Split Valuation by creating Material Subject to Split Valuation

1. Create a material master record, selecting the Accounting View 1.

2. Enter your data as required on the Accounting data screen, specifying a valuation category.

(If you can't find the valuation category field, it might be hidden, use OMSR to define the Field Groups.

Look for the field MBEW-BWTTY for Valuation category).

3. Be sure that the price control indicator is V for moving average price and enter a moving average price.

4. In the case of split valuation, you can create only one valuation header record with price control V because the

individual stock values are cumulated, and this total value is written to the valuation header record. This is where the

individual stocks of a material are managed cumulatively. To do this, fill in the Valuation category field on the accounting

screen when you create the material master record and leave the Valuation type field blank.

5. Save your data and the system creates the valuation header record.

6. The initial screen appears.

7. Extend the material by creating new material master records from the Accounting view 1. For the first material, specify a

valuation type in the Organizational Levels dialog box and enter the respective accounting data on the data screen.

Proceed likewise for the other materials, distinguishing between them by valuation type. To do this, call up the material in

creation mode again. Due to the fact that a valuation header record exists, the system requires you to enter a valuation

type for the valuation category.

8. Repeat step seven for every valuation type planned.

You want to valuate the stock of material XYZ that you obtain from manufacturer A in Los Angeles at a different price than the stock you obtain from manufacturer B in Detroit. In this case, the valuation category is H for origin. Your valuation types can be LOS ANGELES and DETROIT.

If a material is subject to split valuation, every quantity (sub-stock) of this material must be assigned to a valuation type (for example, country of origin).

For every valuation type, there are two types of data in the system, as follows:

Valuation data (for example, valuation price, total stock quantity, total stock value), which is defined for every valuation type at valuation-area level and applies to all dependent storage locations.

Stock data, which, like batch data, is managed separately for each storage location. If a material that is subject to split valuation is also subject to management in batches, its stock data is not managed by valuation type, but rather by batch. Every batch is assigned to a valuation type.

The stock quantity, stock value, and valuation price for all valuation types are managed cumulatively at valuation-area level.

Must the Valuation Type Exist Before the First Goods Receipt?

You can post the goods receipt of material of a certain valuation type only if the valuation data for this valuation type already exists, because the system valuates the goods receipt at the price defined in the valuation data. On the other hand, the stock data for the valuation type is created automatically during the first goods receipt into the storage location, if this is defined in Customizing for Inventory Management.

Goods Movements with Materials Subject to Split Valuation

If you want to enter goods movements for materials subject to split valuation, you must enter the valuation type in addition to the material number.

Enter the valuation type in the Batch field for MB01.

In MIGO, there is a valuation type field in Detail data -> Material.

Also check SPLIT VALUATION configuration with screenshots at:

http://www.sap123.com/showthread.php?t=29

Regards,

Syed Hussain.

Edited by: Syed Hussain on Oct 13, 2008 12:15 PM

[Former Member]

Hi Rajesh,

Be clear do you want to know about SPLIT valuation then please see the post by one friend.

See you cannot able to run MRP for Alternate Material

Say Suppose you are buying Starter motor for a CAR

Source will be LUCAS TVS ,MICO both the starter will be having the same partno then only MRP will plan. But for your records you can track both the make in the production system .

Similarlly you have to do for engg products also

hope you understood.

G.Ganesh Kumar

[Former Member]

My suggestion is to use Material Clasification instead of Split Valuation.

Hope this helps

[Former Member]

Hi

go for split valuation.

regards

ram