Skip to Content
avatar image
Former Member

changing division in material master

Dear Gurus,

My requirement is changing material division in material master.

If i change division in material master, where it is effect in sd module.

What are the prerequisites to change division in material master.

Please suggest.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

11 Answers

  • Best Answer
    avatar image
    Former Member
    Aug 28, 2013 at 11:17 AM

    Hi Krishna,

    Simple suggestion is to create a new Material Code with new division and transfer existing Stock of Material Code in New Material Code.

    Effect if Division changed in Material Master

    1) Reports will have effect as your old same Material code will be showing Division based report for previous transactions differently and new differently

    2) Pricing Procedure Determination will be wrong as Division is the part of it's determination.

    3) Free Goods Determination can have effect. Any other Determination Process which has Division in part will have effect.

    4) Any of the Condition Records which has Division as part of Condition Table will not be determined correctly. (Ex. Pricing / Accounts or any other Functionality)

    Also in addition to Division you will have to check other Fields which will also have to be changed. For example dependent Material Group, Tax Classification, Material Account assignment Group or any other.

    Regards,

    MJ.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Aug 28, 2013 at 08:00 AM

    Dear Kmkrishna,

    Division can be changed in MMR for a particular Material however to ensure the correct Reporting Analysis you can create new Material with the same description and desired Division by putting Deletion Flag on the previous one. If the break up of Sale is based on the division and you don't want any compromise on it then i think you should go for new material creation because in case of Division change everything will be updated at newly created Sale Documents. By the way can you please share the business requirement of doing the same. Thanks.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Aug 27, 2013 at 12:50 PM

    Hi,

    Yes  K MKrishna  if you change the division this will effect in the doc of the  line item, can you specify what is your requirement of changing the division in the master. Thanks Sukant Chakraborthy

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Aug 27, 2013 at 06:23 PM

    Dear Kmkrishna,

    Material is always specific to a division. if u want to change its MM02 the change will get reflected in the other document which you will create from now.

    Coming to prerequisites to change division in material master depend on scenario to scenario, so if you can give a brief, then its will be good for us to reply.

    Thanks,

    Sumeet Sah

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Aug 28, 2013 at 04:46 AM

    Dear KMKRISHNA,

    If you Change the division in Material Master, it will effect your All Sale Flow & Sale Documents i.e Contract, Sale Order, Delivery Order and then invoice. As Contract & Sale Order has been created on the combination of Sale Organization, Distribution Channel and Division which is called Sale Area and moreover other sale documents has been created with reference to previous documents so it will copy over from copy Control settings in Sale Documents. So firstly you have to give your proposed division to the initial screen while creating Sale Order with T-Code VA01 Sale order Creation i.e:


    As Contract and sale order has been made on specific Sale Area. so we have to give correct division which has been maintained in Material master Data. and further you also look upon other material master settings i.e Material Groups etc.

    If you feel Any ambiguity,, Feel free to ask. Hope it will help you. =)

    Regards,

    SUHAIB BIN AZIZ

    Add comment
    10|10000 characters needed characters exceeded

  • Aug 28, 2013 at 08:21 AM

    If any transactions happens, I dont think, system will allow to change the Division since it is client specific and not SD or MM specific.

    G. Lakshmipathi

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Aug 28, 2013 at 09:36 AM

    Hi,

    If the system allows you to change the division in master even after having transactions for that division ,then you may need to check the accounting entries. Take one accounting document before changing the division and after changing the division and you an understand the division. Mainly you need to check on business area combination because mostly business area mapped to division only.

    Raneesh C N

    Add comment
    10|10000 characters needed characters exceeded

  • Sep 05, 2013 at 03:38 PM

    Hello Krishna,

    As mentiond by Mahendra, the impact of changinh the Material division is very high, hence it must not be done.

    Re-Create the Material with new divisoin and post a Material to Material transfer Material.

    Regards,

    Onkar

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Sep 06, 2013 at 11:29 AM

    Hello

    From My Side following points ..

    1> It  causes at pricing procedure determination if the sales doc type is with item division.

    2> It also effect the business area determination at PGI level.

    3> It also effect the EXICE Invoice ( if it is present )

    4> Also effect the existing Z Report 

    Regards

    Sohan

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Sep 07, 2013 at 01:33 PM

    My dear KMKRISHNA,

    First of All you please explain your scenario that what sort of effect you are talking about? if you have completed the sale flow document processing from Sale Order till Invoice, after then u change the division in MM? and want to see the effect? or before. kindly explain it first because there are so many scenarios if we talk about sd module as its very vast field. please explain?

    Thanks!

    Suhaib Bin Aziz

    Add comment
    10|10000 characters needed characters exceeded