Licence Master- Legal Control for product sales

[Former Member]

Hello Gurus,

I need your help for following two issues. I tried researching the issues which gives me very little clue on the approach. If you guys can help me out I will be very grateful.

My client is a pharmaceutical company which requires license to sell particular drugs to particular customers. This is legal requirement. Following are the issues where I am stuck.

1. How can we control particular license for particular state alone.

E.g. If there are 10 customers in the particular state then we should be able to control the sale of particular product to that state only. I know we can control it by company code or country in the license master but not sure how to do it by State.

So for product ABC if we have license for say California, then we should be able to sell it to all the customers in California. System should validate the ship to party state and allow the sale for California alone and should not allow to process the order if the state is other than California.

2. How to control the total quantity of specific product to be sold by particular license to specific customer.

In license master I know we have field for value and quantity. With value field system validates the value but not the quantity. And also we need have traceability of how much quantity is consumed from that license.

E.g. If we have legal license to sell product ABC to customer XYZ for say 1000 units for license validity period of say one year. And if we create 10 orders for first 8 months which completes the quota of 1000 units and ten we try to create order with more quantity which surpasses the 1000 unit quota under this license for this customer then system should not allow processing the order.

Also the quantity for each license is limited and there needs to be a full audit trail from the sales order back to the license.

Gurus please help me pout in this I will really appreciate your help. Full points guaranteed.

Thank you in advance.

SAPContributor

[Former Member]

Hi Friends,

Any clue on the above will be helpful. Please have a look.

thank you.

[Former Member]

I was thinking something on following lines. Gurus please chip in your recommendations:

1. I was thinking of adding new field in license master for state an dthen have system validate it when that particular license is called in sales order through a userexit.

2. I was thinking to use standard field "Quantity" in license master (VX01N) to maintain maximum quantity that license can sell. And the during sales order creation have user exit to validate this maximum quantity with all the sales order quantities created with reference to this license. If the sum of all quantities associated with this license is more than or equal to maximum quantity maintianed in license master then stop the order. If not then allow the order to be created for the quantity available.

Gurus. please let me know your comments on above solutions.

Thank you.

SAPcontributor.