Skip to Content
avatar image
Former Member

Validation for Material master

Dear Experts:

We are using same material codes for two different companies with their different sales area. That's we can't maintain Division in material master. In our system we've maintained divisions as brand name wise. Now problem is when we are selecting Division A and selecting Materials which suppose to be material of division B then system is not restricting them to select in sales order. If we maintain divisions in material then we can't select them in other company code because divisions are different company code wise.

Now can you please suggest me how can I restrict them.

Thanks in advance and your suggestions will be highly appreciated.

Best Regards.

Ripon

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

6 Answers

  • Jul 27, 2017 at 04:41 AM
    -1

    How can you say the material is common if you want to restrict it to from being used in 1 division (without maintaining a division)?

    If you do not maintain a division, how can anybody know that this material must not be used in a certain division.

    You can't control anything without maintaining data.

    I have minimum 3 ideas.

    You could use classification with a characteristic allowing for multiple values and could maintain your possible allowed divisions there and can then check in a user exit of the sales order whether the division that is used in the sales order is among the divisions of the classification.

    You could also maintain a 00 division as neutral in your main material master and create for each real division that is allowed another material master with a real division and use material determination

    You can also use listing/exclusion to restrict the sale of this material to customer xy

    Add comment
    10|10000 characters needed characters exceeded

  • Jul 26, 2017 at 09:16 AM

    Your post is not clear enough to understand. You need to explain with an example how currently the material master is set up and how you want the system to behave. Hope, you are aware Division can be controlled whether to allow or not in sale order

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jul 26, 2017 at 09:29 AM

    Dear Sir:

    Sorry for the confusion.

    1) Company Code : AE01, Sales Org: IWH1, Dist. Ch. : BR and Division: IK, ID and IP

    2) Company Code : AEV1, Sales Org: GNS1, Dist. Ch. : RT and Division: BK, BD and BP

    3) Matreial : CF0001 (Created without division for both companies) for use of BK and IK sales orders

    4) Matreial : SF0001 (Created without division for both companies) for use of BD and ID sales orders

    Now when I'm selecting CF001 in sales order with sales area GNS1, RT and division BD system is allowing me to select that material but we want to restrict it for only BK and IK division.

    Hope the matter is clear now. If you still have confusion then please let me know.

    Best Regards.

    Ripon

    Add comment
    10|10000 characters needed characters exceeded

  • Jul 26, 2017 at 11:33 AM
    we want to restrict it for only BK and IK division

    Still not clear whether the same material is extended to different Division !!!

    we want to restrict it

    In sales document type, you have this control. Search before posting such basic query.

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Dear Sir,

      As we are using common material in both companies so we didn't maintain division in material master. So, when we are creating sales order for division BK with material of BP system allowing us to create that Sales order. We cannot maintain division in material master cause materials are same for BP and IP. If we maintain BP in material master then we cannot create sales order with same material with division IP.

      Still I'm not clear what need to do? Please help.

      Best Regards.

      Ripon

  • Jul 27, 2017 at 04:27 AM

    *****we can't maintain Division in material master**** &

    again...

    *****system is allowing me to select that material but we want to restrict it for only BK and IK division****

    Please let us understand-how system can differentiate sales area if Blank is at master...

    How you were getting prices for this material(Any sales area combinations?)

    Division means Range of the product-same material can be used in n-number of company codes-irrespective of division with sales area differentiation...

    I think maintaining the material without division-some design issues are there...

    Still need to restrict-we need to control with sales order exits..(But we can't recommend this)

    Phanikumar

    Add comment
    10|10000 characters needed characters exceeded

  • Jul 27, 2017 at 05:58 AM

    Hi,

    There comes the common Division concept,you need to decide how you can apply to the scenario.

    Add comment
    10|10000 characters needed characters exceeded