Skip to Content
avatar image
Former Member

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

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

4 Answers

  • Best Answer
    avatar image
    Former Member
    Sep 02, 2013 at 09:05 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • Sep 02, 2013 at 09:09 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • Sep 02, 2013 at 09:15 AM

    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.

    Add comment
    10|10000 characters needed characters exceeded

  • Sep 02, 2013 at 09:19 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

    • 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