Commission to Agent based on sales value

[Former Member]

Dear experts ,

we have a case wherein , a driver / agent is involved with the delivery of a slaes order.

Based on the sales order value , the driver/agent is giver a percentage based commission.

As the driver/agent is a creditor , how can it be mapped in SD Module .

Is there a standard functionality in SAP SD or ant other module ?

Kindly guide as in how to go about it ?

regards

Anis

[former_member383560]

HI

For creating commission agent, you have to follow below steps.

1) Establish Partner Functions for the Commissionee(s)

Menu Path: IMG ->; SALES AND DISTRIBUTION ->; BASIC FUNCTIONS ->; PARTNER DETERMINATION ->; DEFINE PARTNER FUNCTIONS

Transaction Code: VOPA

2) Assign the Partner Functions to Partner Procedures

Menu Path: IMG ->; SALES AND DISTRIBUTION ->; BASIC FUNCTIONS ->; PARTNER DETERMINATION ->; DEFINE PARTNER FUNCTIONS

Transaction Code: VOPA

3) Create a Partner Procedure for the Commissionees

Menu Path: IMG ->; SALES AND DISTRIBUTION ->; BASIC FUNCTIONS ->; PARTNER DETERMINATION ->; DEFINE PARTNER FUNCTIONS

Transaction Code: VOPA

4) Create New Customer Account Group(s) for Commission Agents

Menu Path: IMG ->; LOGISTICS GENERAL ->; LOGISTICS BASIC DATA: BUSINESS PARTNERS ->; CUSTOMERS ->; CONTROL ->; DEFINE ACCOUNT GROUPS AND FIELD SELECTION FOR CUSTOMER

Transaction Code: OVT0

5) Assign the Partner Functions to the Customer Account Group(s)

Menu Path: IMG ->; SALES AND DISTRIBUTION ->; BASIC FUNCTIONS ->; PARTNER DETERMINATION ->; DEFINE PARTNER FUNCTIONS ->; GOTO ->; PARTNER FUNCTIONS ->; ENVIRONMENT ->; ACCOUNT GROUP ASSIGNMENT

Transaction Code: VOPA

6) Assign the Partner Functions to the Partner Procedure for the Sales Document Header

Menu Path:IMG ->; Sales and Distribution ->; Basic Functions ->; Partner Determination ->; Define Partner Functions

Transaction Code: VOPA

7) Assign the Partner Functions to the Partner Procedure for the Sales Document Item (OPTIONAL)

Menu Path: IMG ->; SALES AND DISTRIBUTION ->; BASIC FUNCTIONS ->; PARTNER DETERMINATION ->; DEFINE PARTNER FUNCTIONS

Transaction Code: VOPA

😎 Edit the Pricing Communication Structure (KOMKAZ) to Hold the New Functions (Client Independent)

Menu Path: Menu Path: TOOLS ->; ABAP WORKBENCH ->; DEVELOPMENT ->; DICTIONARY

Transaction Code: SE11

9) Edit MV45AFZZ u2013 userexit_pricing_prepare_tkomk (Client Independent)

Menu Path: TOOLS ->; ABAP WORKBENCH ->; DEVELOPMENT ->; ABAP EDITOR

Transaction Code: SE38

10) Edit RV60AFZZ - userexit_pricing_prepare_tkomk (Client Independent)

Menu Path: TOOLS ->; ABAP WORKBENCH ->; DEVELOPMENT ->; ABAP EDITOR

Transaction Code: SE38

11) Edit MV45AFZB - userexit_new_pricing_vbkd changing new_pricing (Client Independent)

Menu Path: TOOLS ->; ABAP WORKBENCH ->; DEVELOPMENT ->; ABAP EDITOR

Transaction Code: SE38

The following code should be inserted into program MV45AFZZ to allow the system to re-execute pricing if the user makes a change to the relevant partner function (alteration, addition, deletion).

13) Add the KOMKAZ Fields to the Pricing Field Catalog (Client Independent)

Menu Path: IMG ->; SALES AND DISTRIBUTION ->; BASIC FUNCTIONS ->; PRICING ->; PRICING CONTROL ->; DEFINE ACCESS SEQUENCES ->; MAINTAIN ACCESS SEQUENCES

Transaction Code: OV24

14) Create Condition Tables (Client Independent)

Menu Path: IMG ->; SALES AND DISTRIBUTION ->; BASIC FUNCTIONS ->; PRICING ->; PRICING CONTROL ->; DEFINE ACCESS SEQUENCES ->; MAINTAIN ACCESS SEQUENCES

Transaction Code: V/03

15) Create an access sequence containing the new tables (Client Independent)

Menu Path: IMG ->; SALES AND DISTRIBUTION ->; BASIC FUNCTIONS ->; PRICING ->; PRICING CONTROL ->; DEFINE ACCESS SEQUENCES ->; MAINTAIN ACCESS SEQUENCES

Transaction Code: V/07

16) Create a new condition type

Menu Path: IMG ->; SALES AND DISTRIBUTION ->; BASIC FUNCTIONS ->; PRICING ->; PRICING CONTROL ->; DEFINE CONDITION TYPES ->; MAINTAIN CONDITION TYPES

Transaction Code: V/06

17) Add the Condition Type to the Pricing Procedure

Menu Path: IMG ->; SALES AND DISTRIBUTION ->; BASIC FUNCTIONS ->; PRICING ->; PRICING CONTROL ->; DEFINE AND ASSIGN PRICING PROCEDURES ->; MAINTAIN PRICING PROCEDURES

Transaction Code: V/08

11) Create Commsission Report ZZCOMMISSION (Client Independent)

Menu Path: TOOLS ->; ABAP WORKBENCH ->; DEVELOPMENT ->; ABAP EDITOR

Transaction Code: SE38

With Regards

BAALAKRUSHNAN.DA

[Former Member]

Hi

It can be purely be done on SD ............

create the agent as an external cuctomer having a different partner function type........

assign to customers at sales order level maintain condition type either based on % r rate .......

regards,

ram

[Former Member]

Hello Ramaswamy ,

Can u pls elaborate as in how n where can this be mapped in SD ?

thanks in advance

Reagrds

Anis

[Former Member]

Hi

1) Create a new customer account group for the agent having different no.range......

2) Create a new partner type of ur own...and partner determination procedure for the same having SP,PY and the new

Partner function.

3) Now goto customer master data for whom this agent is responsible in that particular CMR in Sales area Data tab in Partners

view enter this partner with the new PF type in it.......

4) Maintain Condition record having some Percentage or Rebate Agreement type.......

5) When you raise for that particular customer check in Header level partner this new partner function comes......

6) then raise an seperate invoice for that Agent..........

Regards,

Ram