Skip to Content
0

Validation for Material master

Jul 26, 2017 at 09:07 AM

232

avatar image
Former Member

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

10 |10000 characters needed characters left characters exceeded

Materials Management tag removed as it is purely about sales order

0

What does the "Other" mean now - why did you close the question - not satisfied by the answers as they did not say what you wanted to hear?

0
* Please Login or Register to Answer, Follow or Comment.

6 Answers

Jürgen L
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

Share
10 |10000 characters needed characters left characters exceeded
G Lakshmipathi
Jul 26, 2017 at 09:16 AM
0

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

Share
10 |10000 characters needed characters left characters exceeded
avatar image
Former Member Jul 26, 2017 at 09:29 AM
0

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

Show 2 Share
10 |10000 characters needed characters left characters exceeded

Check whether "Cross Division" can help you.

Thanks, JP

1
Former Member
Jyoti Prakash

Dear Sir,

Thanks for your reply. May I know the steps to handle cross division?

Brgds.

Ripon

0
G Lakshmipathi
Jul 26, 2017 at 11:33 AM
0
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.

Show 1 Share
10 |10000 characters needed characters left 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

0
Phanikumar Valiveti Jul 27, 2017 at 04:27 AM
0

*****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

Share
10 |10000 characters needed characters left characters exceeded
Siva Prasad Vasireddy Jul 27, 2017 at 05:58 AM
0

Hi,

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

Share
10 |10000 characters needed characters left characters exceeded