External Commission Settlement of Invoices created directly from sales orders prior to delivery

[AnustupSAP]

Hello SAP Community,

        We want to use condition contracts for payment of external commissions using condition contract technique to dealers. Business requirement mandates that no settlement should be done (accrual or actual payment) unless a delivery has been created. For sales from stock products we do not have an issue as billing always takes place post delivery. But for custom make to orders, we have order related billing and billing document is created much ahead of the delivery. However, since condition contract settlement gets triggered by billing, system doesnt check if the delivery for the custom order has been made or not. Is there any way to achieve this technically? I have looked for a BADI under Settlement process which allows us to cancel the settlement run for an entire contract if one of the invoices in the business volume is found to be without any delivery. But customer doesnt want this to happen- we need to skip only that particular invoice and settle the commissions for the remaining invoices where delivery has been made for the custom orders.

Please share your opinion on how we can achieve this - specifically, if there is any BADI which allows us the scope to remove the invoices (without delivery) from the business volume for calculating the settlement amount.

Thanks

Anustup Chakrabarti

[gvictor]

Hi @AnustupSAP,

One the easiest option would be to use SAP HANA Studio to create a custom CDS view selecting from VWB2_VBRKVBRP_7. You will need to list all relevant fields for the new CDS view. Add as well the logic to capture only the relevant billing document with a delivery - you may want to exclude billing types for direct billing such as G2 and L2. 
The last step would be to assign the CDS view newly created to the relevant profile of business volume you're using.

The system will only create settlement with the relevant business volume based on your requirement. 

Regards, 
Gauthier VICTOR

[AnustupSAP]

Thanks @gvictor, would try this out. I am still trying to convince the customer to pay the commission as soon as the billing is done because the dealer has done his job of making the sale happen. But your solution looks promising.