Issue with Valuation Class and material type assignment

[Former Member]

Hi,

During material creation, when we insert material type, related valuation class should automatically come in Valuation Class field in Accounting View.

In Configuration, we have maintained account category ref. and valuation class according to Material Type. (Through OMSK tcode).

But this will be shown in 1:1:1 case...like Material Type : Account Category Ref. : Valuation Class..

But what can I do in this scenario: -

In our company we have 10 Material Type, so we create 10 Diff. Account Category Ref.. But we have 100 Valuation classes...

How can we do it...because we want valuation class should automatically come in Valuation Class field in Accounting View.

In my case, how it is possible...

Please guide...

[Former Member · Accepted solution]

In std SAP it is not possible to map 100 valuation class for 10 material type with 10 acc cat ref.

Either you should speak with FI consultant to come out with what is possible in SAP

Or you have to develop a z table with some key fields to determine the correct valuation class automatically. In this option also you must assign a the relevant valuation class per material type then only it is possible.

In reality never seen a requirement for 100 Val class I think something to do with convincing the client or find a way to tackle in FI side

[Former Member]

This message was moderated.

[mohsinabbasi007]

This message was moderated.

[Former Member]

If you have 10 material type , material and 10 Account Category Ref. and 100 valuation class,

system could not pick valuation class automatically because same Account Category Refassign to different valuation class .

for automatically pick up valuation class you required to create 100 nos of Account Category Ref

Vipin

[Former Member]

Is it possible after creating 100 account category ref. according to 100 valuation classes???

Then how 100 account category ref. assign to 10 Material Type...

Plz guide..

[Former Member]

Hi

In std sap you can assign 'n' number of valuation class to one account category reference, first of all you dont want to create 10 account category reference, because you can assign all the 10 material type to one account category reference ,so already you have created 10 account categoty reference, so you assign the 100 valuation class to the 10 account category reference to post different g/l account , then assign the 10 material type to either one account category reference or 10 account category differnce that is upto you.

[Former Member]

Hello,

If you have 10 material types and 100 valuation classes, how the system will come to know which valuation class to be picked up.

First of all set up that logic and then only you will be able to solve the issue.

Thanks,

Vinay

[Former Member]

Thanks...

Yea, system will not understand in this case..

If we assign 10 account category ref. to 1 material type, then in Valuation Class, it will show 10 entries for selection.. we have to selection any one of them according to our requirement...

Is there any alternate to solve my issue...

Please guide...

[BijayKumarBarik]

Hi,

Not sure about your actual requirement!

10 Material Type, 10 Diff. Account Category Reference but why 100 Valuation classes?

Account category reference is the link between the valuation classes and the material types. The account category reference is a combination of valuation classes. Precisely one account category reference is assigned to a material type. In the standard SAP , an account category reference is created for each material and account category reference is, in turn, type assigned to precisely one valuation class. This means that each material type has its own valuation class which in turn populates only one valuation class during material creation in MM01 t.code with specific material type.

As you needed

Either you can go for

10 Material Type, 10 Diff. Account Category Reference and 10 Valuation classes & with assigning each material type with one account category reference (OMS2) and ONE account category reference assigned to ONE valuation classes in OMSK t.code ,,,,,,like wise at the end 10 account category reference assigned to 10 valuation classes ,,,,,,

OR

10 Material Type, 10 Diff. Account Category Reference but why 100 Valuation classes

& with assigning each material type with one account category reference (OMS2) and one account category reference assigned to 10 valuation classes in OMSK t.code ,,,,,,like wise at the end 10 account category reference assigned to 100 valuation classes ,,,,,,

Regards,

Biu K

[Former Member]

Thanks dear,

I know that we can assign 10 Material Type, 10 Diff. Account Category Reference and 10 Valuation classes. Here it is 1:1:1...

It's simple to configure and no issue with this...

But we want relation like 1:10:10....Because we cann't create 100 Material Types...

Plz guide..

[BijayKumarBarik]

Hi,

Not read my above reply.

Just tryu2026u2026u2026.

You have 10 material types: M001,M002, M003,M004,M005,M006,M007,M008,M009 & M010.

You can have 10 account category reference: A001,A002,A003,A004,A005,A006,A007,A008,A009 & A010.

You have Valuation classes: V001, V002, V003, V004u2026u2026u2026u2026u2026u2026u2026u2026u2026u2026V100

Now you can assign in OMSK t.code

M001 to A001, M002 to A002u2026u2026u2026u2026u2026u2026u2026.. M010 to A010

& assign

V001-----A001

V002u2026u2026A001

u2026u2026

V011u2026..A002

V012u2026..A002

u2026u2026u2026.

V021u2026..A003

V022u2026..A003

,,,,,,,,u2026

V098---A010

V099----A010

V100----A010

Regards,

Biju K

[raviraj_sharma]

You cannot map your requirement (1 material type -> many acc cat reference ) in standard SAP, you will need to go for a user exit in material master to default valuation class based on a Z table.

The closest option to map your requirement in standard would be to create 10 valuation categories (one for each material type) , and the 10 Valuation types per category , i.e. 100 val types (i.e. Valuation types for each Val class) and 100 account catregory references (1 acc cat ref per val type ) .

and link the Valuation Category->Valuation Type->Acc cat reference . all this can b e done in OMWC. (split valuation)

[Former Member]

Hi,

As you suggest, this is like ...

Material Type.............Account Category Ref.............Valuation Class

M001...............................A001.......................................V001

M001...............................A001.......................................V002

M001...............................A001.......................................V003

From this, we have to select any one of them (3 options) in valuation class field according to material type M001.

I have already tried this way...

[pankaj_singh9]

Hi,

Go to OMSK;

Here First Define the Account Category Reference as A001

Then create Valuation Classes V001, V002, V003 with linkage of Account Category Reference A001 (In 2nd Step)

Now in 3rd step, assign Account Category Reference A001 to Material Type M001

[Former Member]

Dear,

As i told earlier that from doing this, we have to select the Valuation class in accounting view (anyone from V001, V002, V003)..

Main issue is here, we don't want to do it manually because here is the chances of error by user side...

[BijayKumarBarik]

Hi

If you we don't want to do it manually during material creation, then go for 10 Material Type, 10 Account Category Reference and 10 Valuation classes & assign each material type with one account category reference (OMS2) and ONE each account category reference assigned to ONE each valuation classe and One each material type with ONE each account category reference in OMSK t.code. So when you cretae material with MM01 with a material type, you can see default valuation class which is populated from through account catagory refence.

NOTE: If you will go for 10 Material Types, 10 Account Category References and 100 Valuation classes , then you need to follow my 2nd answer where when you wil create materail with materail type M001, then you wil have V001, V002......V010( 10 valuation clasees) which you need to select it manually bcuz all ten valuation calsses assigned to one account category reference A001.

Regards,

Biju K

[pankaj_singh9]

In that case what Bijay is saying is the only option.