SAP Pricing - Custom Table referenced via user exit for Price Procedure determination at sales order

[Former Member]

Hello SD Gurus ,

My client has a requirement wherein a custom table needs to be setup with the following fields : Order type , Customer no , Pricing Procedure basically only for export orders and two different price procedures might be called based on the unique entry in the custom table.Can anyone throw light on the best way to go about this? Can we use the pricing user exit for this? Any inputs would be greatly appreciated.

Thanks and Regards

Hari

[oiver_beie · Accepted solution]

Hi Hari,

You can use user exit  USEREXIT_MOVE_FIELD_TO_VBAK to change the pricing procedure (VBAK-KALSM) according to your logic before pricing is called.

Best regards,

Oliver

[neeraj_lal]

Former Member

Are you sure that u need zdevelopment to get this requirement? As per my understanding:

Order Type (Export or Domestic): Doc Pricing procedure wil take care of this.

Customer no : Customer Pricing procedure will take care of this.

2 Unique entries in price table: ? check if you can get it without using z development.....

Use Zdevelopment for pricing procedure determination after checking all pro and cons.. I have seen customer facing many issue after using development in such sensitive area.

If you are using Z pricing procedure determination in sales document than what will happen in Invoice? You should analysis this also...

If you calculate freight in delivery document than check this also and do analysis.....

If you finalise that only z development can suffice your requirement, then do testing carefully.

Regards

[Former Member]

Hello

Unfortunately it cannot be catered to via standard SAP Config.

The requirement has now been extended to all possible order types and all customers.

ie. order type1  + customer A  - Price Procedure A

      order type 2 + customer A  - Price Procedure B

      order type1 + customer B - Price Procedure B

      order type2 + customer B - Price Procedure A

also based on exigencies the price procedure can also be switched ie. order type1 + Customer A - Price Procedure B

I guess above should explain why the standard SAP config for price procedure determination will not work in this case.Also Business does not like the idea of having duplicate order types and want a custom table which can be easily maintained as master data to amend the entries in that custom table.

The fields of the custom table will be as below :

1. Order Type   2. Customer No.  3. Price Procedure.

I like Oliver's idea of using the

Program : MV45AFZZ

User exit :  USEREXIT_MOVE_FIELD_TO_VBAK to change

the pricing procedure (VBAK-KALSM) to pick the price procedure for the relevant combination from this custom table.

I hope i have thought of everything.Oliver and others please guide me if i am wrong in any way.

Kindest Regards

Hari

[moazzam_ali]

Hi

MV45AFZZ is the program and user exit has already been shared by Oliver but I am wondering don't you have separate sale area for export? You can control this through sale area or document pricing procedure (create a copy of your export order type). ABAP modification should be there when you can't control anything through standards but dont know in your case what is your limitations but I have just shared my opinion.

[jpfriends079]

custom table needs to be setup with the following fields : Order type , Customer no , Pricing Procedure

Frankly very surprising thought/suggestion to differential your pricing procedure based on fields mention above in a custom condition table.

I don't think you should do that.

Why?

Order type = you have doc pricing procedure

Customer no. = you have customer pricing procedure

If you or client know a bit of pricing procedure determination in SAP, then you might be aware that

Pricing procedure in sales document get determines based on Sales Area(SOrg + DistriChannel + Division) from your sales doc + doc pricing procedure from sales doc/order type(VOV8) + customer pricing procedure from customer master (XD02/VD02).

There are lot of information floating on web for pricing procedure determination in SD. Please read them and clarify your doubt through search/trail. And then understand client requirement and suggest them accordingly.

Cheers, JP