product sales license-Legal control

[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 to 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 liense 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 out in this I will really appreciate your help. Full points guaranteed.

Thank you in advance.

SAPContributor

[gomatheeswaran_palaniappa · Accepted solution]

Hi,

The following information source might help you, if you haven't gone through it before.

[Legal Control in SD Documents|http://help.sap.com/saphelp_45b/helpdata/en/8d/774a2e9be011d1b4e50000e82d81b0/frameset.htm]

Regards,

P Gomatheeswaran

[Former Member · Accepted solution]

Thanks for your reply.

But yeah I had already gone through this but all this does not specificly talk about the above two issues. Thats the reason I want to seek help of someone who might have done similar thing or know about it.

Thanks,

SAPContributor

Edited by: SAPcontributor on Aug 1, 2011 4:55 PM

[Former Member]

Hi,

Iam not very sure if standard SAP has a provision to include a new field in the license master, if it does then the solution you are thinking off will hold good. Else you can have a Z table with three columns License, State and Maximum Qty so that both your requirements are met, i.e. the system will check this table and do as per your requirement.

[Former Member]

This requirement seems very common and also legal requirement - does SAP not handle this in standard?

[Former Member]

Hi,

The first requirement can be best handled through an Sales Order Exit, you can your technical consultant to tell the system to check first for the Ship to party STATE and allow sales order creation if the ship to party state is CALIFORNIA or else give an error message.

And for the second requirement you can create a Quantity Contract with 1000 qty and create sales orders referencing the contract. The system will stop you once the quantity is fully referenced.

[Former Member]

Hi PJ,

Thanks for the input.

But the solution which you have suggested are directly related with transactions and not with license or license master(VX01n) and we use sales orders with license validationin legal control so cant use Contracts. All this thing need to be controlled at license level.

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.