Dealer Campaign, Promotion and Payment Plan Calculation Enhancement
Short answer: A custom enhancement that automatically applies the discount, free goods and campaign-linked payment terms of dealer-group campaigns to the sales order. Basket conditions (minimum quantity or value, product group mix) and the campaign budget are checked, and a usage report shows how much each dealer has benefited from a campaign.
- Estimated effort
- L · 12–18 working days
- System
- ECC and S/4HANA
- Tables
- 10
- Scope
- Global
- Built by
- NeKuDos Teknoloji
- Last updated
Why is the standard not enough?
In the standard, discounts are kept as condition records (VK11), free goods with VBN1 and sales deals with VB21; each works on its own. Tiered campaigns based on the basket total, campaign-specific payment terms and instalment plans, a campaign budget per dealer and a warning when the budget is exceeded do not exist together in the standard. Order entry therefore applies campaigns manually, and errors are noticed only after invoicing.
Who uses it? Dealer channel sales managers, marketing and campaign teams, order entry teams and finance.
Closest standard alternatives
Tables used
The tables the program reads and updates. ECC and S/4HANA differences are marked separately.
| Table | Role | Access | System |
|---|---|---|---|
| KONHConditions (Header) | Header of campaign condition records and linked sales deal | Read | ECC + S/4 |
| KONPConditions (Item) | Campaign discount rates and amounts | Read | ECC + S/4 |
| KNVVCustomer Master Sales Data | Dealer's customer group and sales area | Read | ECC + S/4 |
| VBAKSales Document Header | Sales order header: dealer, date, order type | Read | ECC + S/4 |
| VBAPSales Document Item | Order items: material, quantity, free-of-charge item | Write | ECC + S/4 |
| VBKDSales Document: Business Data | Campaign payment terms and fixed value date | Write | ECC + S/4 |
| KONVConditions (Transaction Data) | Campaign condition lines added to the order; budget consumption (ECC) | Read / write | ECC only |
| PRCD_ELEMENTSPricing Elements (Document Conditions) | Campaign condition lines added to the order; budget consumption (S/4HANA) | Read / write | S/4HANA only |
| T052Terms of Payment | Campaign payment terms and instalment definition | Read | ECC + S/4 |
| KNA1Customer Master (General Section) | Dealer name | Read | ECC + S/4 |
S/4HANA notes
- KONV → PRCD_ELEMENTS: In S/4HANA document conditions are stored in PRCD_ELEMENTS; custom code reading KONV must be adapted.
BAPIs and functions used
- BAPI_SALESORDER_SIMULATESimulate Sales Order. Calculates the campaign price in the portal and quotation screen without creating an order
- PRICINGPricing. Runs standard pricing after the campaign condition is added
Selection screen parameters
| Parameter | Description | Type | Reference field | Required | Example |
|---|---|---|---|---|---|
| S_KNUMA | Campaign (sales deal) | Range / multiple | KONH-KNUMA_AG | No | 0000004012 |
| S_VKORG | Sales organization | Range / multiple | VBAK-VKORG | Yes | 1000 |
| S_KDGRP | Dealer group (customer group) | Range / multiple | KNVV-KDGRP | No | B1 |
| S_KUNNR | Dealer | Range / multiple | VBAK-KUNNR | No | 200510 |
| S_AUDAT | Order date | Range / multiple | VBAK-AUDAT | Yes | 01.11.2026 – 30.11.2026 |
| P_BLOCK | Save the order with a delivery block when the budget is exceeded | Checkbox | — | No | — |
Result list columns
| # | Column | Source |
|---|---|---|
| 1 | Campaign | KONH-KNUMA_AG |
| 2 | Dealer | VBAK-KUNNR |
| 3 | Dealer name | KNA1-NAME1 |
| 4 | Orders | Calculated Number of orders carrying the campaign condition |
| 5 | Campaign order value | Calculated Σ VBAP-NETWR (campaign items) |
| 6 | Discount granted | Calculated Σ campaign condition line KWERT |
| 7 | Free quantity | Calculated Σ quantity of free-of-charge items |
| 8 | Payment terms | VBKD-ZTERM |
| 9 | Remaining budget | Calculated Campaign budget − Σ discount granted |
| 10 | Currency | VBAK-WAERK |
Sample result list
| Campaign | Dealer | Dealer name | Orders | Campaign order value | Discount granted | Free quantity | Payment terms | Remaining budget | Currency |
|---|---|---|---|---|---|---|---|---|---|
| 0000004012 | 200510 | Örnek Bayi Ltd. Şti. | 7 | 412,800 | 41,280 | 24 | K090 | 158,720 | TRY |
| 0000004012 | 200534 | Marmara Dağıtım A.Ş. | 3 | 186,450 | 18,645 | 12 | K090 | 140,075 | TRY |
| 0000004015 | 200510 | Örnek Bayi Ltd. Şti. | 2 | 96,000 | 4,800 | 0 | K3T | 25,200 | TRY |
| 0000004015 | 200588 | Ege Bayi Ticaret A.Ş. | 5 | 238,900 | 11,945 | 0 | K3T | -1,745 | TRY |
How does the program work?
- The campaign is created as a standard sales deal (VB21); the campaign condition records are linked to the deal (KONH-KNUMA_AG). Extra rules such as dealer group, validity, basket conditions, free goods rule, payment terms and budget are kept per campaign number in a rule table created during installation.
- During order entry (VA01 or the portal) the sales order user exits (MV45AFZZ) and a pricing requirement routine run: valid campaigns are found with the dealer’s customer group (KNVV-KDGRP) and the order date, and if the basket condition is met the campaign condition is applied to the items.
- If the free goods rule is met, a free-of-charge item is added; for tiered campaigns the correct tier is chosen from the basket total.
- The campaign’s payment terms (ZTERM) and fixed value date are written to the order’s business data (VBKD); if instalment payment terms are used, the payment plan is split into instalments on the invoice.
- Budget check: the discount granted by the campaign so far is totalled from the campaign condition lines of open and billed orders (KONV, PRCD_ELEMENTS in S/4HANA). If the budget is exceeded, the rule either issues a warning or saves the order with a delivery block.
- The campaign usage report shows per dealer the campaign order value, the discount granted, the free quantity and the remaining budget. The portal or quotation screen calculates the campaign price before creating an order with BAPI_SALESORDER_SIMULATE.
Performance notes
Buffer the campaign rule table once at the start of order processing; avoid database reads per item. Instead of re-totalling budget consumption on every order, read it from a subtotal kept per campaign and reconcile it with a nightly job.
Features
- ALV list (sort, filter, subtotals)
- Double-click drill-down to the document From a report row the user opens the list of campaign orders and VA03.
- Export to Excel
- Delivered as a transport request User exit and pricing routine changes are moved from test to production with a transport request.
Authorization objects
- V_KONH_VKOCampaign condition maintenance authorization by sales organization
- V_VBAK_AATOrder creation authorization by order type
- V_VBAK_VKOAuthorization to display the usage report by sales organization
Frequently asked questions
How does this differ from the standard sales deal and promotion?
The campaign's discount records still sit in the standard sales deal. The enhancement adds the basket condition, tier selection, free goods, campaign payment terms and budget check on top, so existing pricing and reporting are not disturbed.
How is the campaign budget tracked?
The budget is defined per campaign and compared with the total campaign discount in open and billed orders. Rejected items and returns are deducted from the total; the remaining budget appears in the usage report.
Does it also work for orders coming from the portal?
Yes. Because the rules run while the order is saved, they apply in the same way to orders created in VA01, by mass upload or from the portal through a BAPI.
Related reports
Customer and Material Price Conditions with Validity Dates Report
A custom ALV report that lists customer-specific price conditions in one list with their validity dates, the difference to the list price and the …
Price and Quantity Differences Between Sales Order and Invoice Report
A custom ALV report that compares the invoiced unit price with the net price on the sales order, and the invoiced quantity with the delivered or …
Mass Sales Price Condition Upload from Excel Program
A custom program that creates sales price condition records per customer/material or per material, with validity dates, in bulk from Excel or CSV …
Let us build this program for your system
Briefly describe your system and expectations. We will clarify the scope and come back with an effort and price quote.