info@imigious.com

www.imigious.com

IMIGIOUS TECHNOLOGIES THESAPSOLUTIONS.COM

info@thesapsolutions.com

www.thesapsolutions.com

SAP MM- SPLIT VALUATION• Configuration Steps• Activating a Split Valuation• creating valuation types• Creating Global Categories• Creating a new Valuation Category• Configuration In Material Master DATA• Creating a Material with a Valuation Type• Configuration in PO• Reports of Split-Valuated Materials

MIGIOUS TECHNOLOGIES Road to success

Split Valuation - Split valuation enables you to valuate the substocks (part of the total stock) of a material in different ways. A number of reasons might justify valuating substocks separately, such as:

• The material has different origins (i.e., comes from different countries).• The material is acquired via different types of procurement (i.e., external procurement versus internal procurement).• The material has different categories of quality (i.e., damaged, poor quality, or good quality).• Same material having different batch may have different valuation prices

Split valuation is used only with the moving average price control, and materials subjected to split valuation can be valuated only via the moving average price method.

valuation category : - The valuation category indicates whether a material’s stock should be valuated as one unit or in parts. This category also a key that indicates the criteria for defining partial stock and determines which valuation type is allowed

A valuation type :- A valuation type is a key that identifies split-valuated stocks of a material and indicates the characteristic of a partial stock. The valuation category is assigned in the material master record, and the valuation type is selected during material transactions, such as goods issues and goods receipts. Example 1:

You procure a material both from in-house production and from external vendors. You want to valuate the stocks from each source separately. In this case, you select Procurement type as the valuation category ( B ) and Internal and External as valuation types.

Example 2:

You procure a material from several countries. You want to valuate the stocks from each country separately. In this case, you select Origin as the valuation category ( H ). As valuation types, you define the relevant countries, for example, Italy and France .

Example 3:

You procure a material in different grades. You want to valuate the stocks of each class separately. In this case, you select Quality as the valuation category ( Q ). As valuation types, you could define A , B , C , and D .

Configuration Steps –

Activating a Split Valuation – T-code OMW0

Menu path To activate split valuation, follow the menu path SPRO -Material Management – Valuation and Account Assignment - Split Valuation -Activate Split Valuation.

Allowing split valuation doesn’t mean that you must only valuate the material on a split valuation basis. Split valuation is used only when the valuation category is assigned in a material master record.

Configuring a Split Valuation T –code OMWCMenu Path Material SPRO-Management -Valuation and Account Assignment - Split Valuation - Configure Split Valuation.

Ext. Pos This attribute indicates whether external POs are allowed.

Int. Pos This attribute indicates whether internal POs (i.e., production orders) are allowed.

ARef (account category reference) This attribute is used to group valuation classes. Specify for which account category reference this valuation type is allowed.

The new valuation type Grade A. Repeat the same steps twice for creating two more valuation types, Grade B and Grade C.

click the Account Cat. Ref. button so that the screen On this screen, the account reference (ARef) shows that

Account category 0001 has several associated valuation classes (Val. Class): 0710,0720, 3000, 3001, 3002, and 3003. Place your cursor in the ARef 0001 field and clickChoose, which will assign the newly created valuation type Grade A to account reference0001 (reference for raw materials)

Repeat the same assignment steps for Grade B and for Grade C. Once completed,you’ll see that all three valuation types—Grade A, Grade B, and Grade C—have the account reference (ARef) 0001 and appear on the screen Save your entries and go back.

Creating Global Categories T – code OMWC

You can define the following attributes for a valuation category

Default: val.type ext. procureThe valuation type selected in this field is proposed at the time of PO creation.

Default: val.type ext.proc. mand.If you select this checkbox, the default valuation type is mandatory and can’t bechanged in the PO.

Default: val.type in-house prodThe valuation type selected in this field is proposed at the time of production order creation.

Default: val.type in-house mand.If you select this checkbox, the default valuation type is mandatory and can’t be changed in the production order.

Determine val. type Automat.If this checkbox is selected, the system will automatically determine the valuation type at the time of the goods receipt. This indicator is only useful for materials thatare managed in batches. A valuation record is automatically created for each batch.

Create a new Valuation Category G with a short description Steel Grades.

In the next step, you must activate valuation types for the valuation category byclicking on Types -> Cat.,

Global Valuation Categories

The valuation types GRADE A, GRADE B, and GRADE C are assigned to theValuation Cat. G (Steel Grades) by clicking on Activate button located at the bottom of the screen

Next, click on the Cat. -> OUs button

The option to restrict or limit the valuation category and valuationtypes assignment to specific valuation area(s) or plant(s). Choose Plant 1000 followedby clicking on the Cat. -> OUs button,

Local Definitions: Selecting a Plant

Valuation categories that can be activated or deactivated.For this example, click on the Activate for the Valuation Category G (Steel Grades).

Activating a Valuation Category

Configuration In Material Master DATA

Assigning a Valuation Category

Creating a Material with a Valuation Type

Configuration in POChoose the valuation type on the Delivery tab of the PO. You can change the default value and select the required valuation type.For our example, create two line items in the PO for two grades of steel (Grade A and Grade B) with the purchase price for Grade A being slightly less than Grade B. Save the PO, and the system will create PO number

Purchase Order with Valuation Type

In the next step, post the goods receipt via Transaction MIGO. You can see the valuation type entry on the Material tab

Goods Receipt of Two Materials with Different Valuation Types

Reports of Split-Valuated Materials

You can view the valuation price in the material master Accounting 1 tab via Transaction MM03, which will show you the valuation price at the plant level, as shown in The stock quantity is the sum of all the quantities of various valuation types (steel grades in this case). The moving price denotes the moving average price of material of various valuation types.

If you select a valuation type at the organizational level, the system will display thestock valuation for the selected valuation type.

For example, for material, the value is assigned for split valuation based on steel grades. In the material master record, the stock valuation for a plant will be the total valuation procured, both Grade A and Grade B

The valuation price for each valuation types is also different in these cases. Material Masters of Both Valuation Types

Transaction MMBE and enter the material10000084 and plant 1000. You’ll see the current stock of split-valuated material 10000084 by their respective grades.

THANK YOU!

info@thesapsolutions.com

www.thesapsolutions.com

“Do What You Can With All You Have, Wherever You Are.” –Theodore Roosevelt