Billing Item Detail Report with Pricing Conditions and Quantities
Short answer: An ALV report that lists billing documents item by item, with pricing conditions such as discounts, freight and bonus in separate columns, the quantity in both the sales unit and an alternative unit, and the accounting document and sales order on the same row. Sales and accounting teams no longer merge invoice lists, condition dumps and accounting entries in Excel every month.
- Estimated effort
- M · 5–8 working days
- System
- ECC and S/4HANA
- Tables
- 10
- Scope
- Global
- Built by
- NeKuDos Teknoloji
- Last updated
Why is the standard not enough?
VF05N lists billing documents but does not show condition values; conditions can only be seen document by document or by reading tables. KE24 shows profitability line items, but its value fields depend on the CO-PA setup and it does not carry an alternative unit of measure. The custom report takes the mapping of condition types to columns from a setup table, converts the quantity into the requested unit with the material's unit conversion and links the accounting document to the billing item.
Who uses it? Sales operations and billing teams, sales accounting, controllers and sales managers.
Closest standard alternatives
- VF05N List of Billing Documents. Lists billing documents; does not show condition values or the quantity in an alternative unit.
- KE24 Line Item Display – Actual Data (CO-PA). Shows profitability line items with value fields; columns depend on the CO-PA setup and no unit conversion is done.
- VF03 Display Billing Document. Shows the conditions of a single invoice item by item; gives no list.
Tables used
The tables the report reads and their join fields. ECC and S/4HANA differences are marked separately.
| Table | Role | Join | System |
|---|---|---|---|
| VBRKBilling Document Header | Billing header: billing type, date, payer, document currency, condition number (driving table) | — | ECC + S/4 |
| VBRPBilling Document: Item Data | Billing items: material, quantity, unit, weight, net value, order and delivery reference | VBRP-VBELN = VBRK-VBELN | ECC + S/4 |
| PRCD_ELEMENTSPricing Elements (Document Conditions) | Pricing conditions per item (S/4HANA) | PRCD_ELEMENTS-KNUMV = VBRK-KNUMV AND KPOSN = VBRP-POSNR | S/4HANA only |
| KONVConditions (Transaction Data) | Pricing conditions per item (ECC) | KONV-KNUMV = VBRK-KNUMV AND KPOSN = VBRP-POSNR | ECC only |
| MARMUnits of Measure for Material | Alternative unit of measure conversion factors | MARM-MATNR = VBRP-MATNR | ECC + S/4 |
| BKPFAccounting Document Header | Accounting document created from the invoice | BKPF-AWTYP = 'VBRK' AND BKPF-AWKEY = VBRK-VBELN | ECC + S/4 |
| ACDOCAUniversal Journal Entry Line Items | Accounting amount and profit center (S/4HANA, optional) | ACDOCA-RBUKRS = BKPF-BUKRS AND BELNR = BKPF-BELNR AND GJAHR = BKPF-GJAHR | S/4HANA only |
| VBAKSales Document Header | Order type and order date | VBAK-VBELN = VBRP-AUBEL | ECC + S/4 |
| VBKDSales Document: Business Data | Payment terms and incoterms | VBKD-VBELN = VBRP-AUBEL | ECC + S/4 |
| KNA1Customer Master (General Section) | Customer name | KNA1-KUNNR = VBRK-KUNAG | 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
- UNIT_CONVERSION_SIMPLEConvert Unit of Measure (T006). Converts between weight and volume units
Selection screen parameters
| Parameter | Description | Type | Reference field | Required | Example |
|---|---|---|---|---|---|
| S_VKORG | Sales organization | Range / multiple | VBRK-VKORG | Yes | 1000 |
| S_FKDAT | Billing date | Range / multiple | VBRK-FKDAT | Yes | 01.10.2026 – 31.10.2026 |
| S_FKART | Billing type | Range / multiple | VBRK-FKART | No | F2 |
| S_KUNAG | Sold-to party | Range / multiple | VBRK-KUNAG | No | 200145 |
| S_MATNR | Material | Range / multiple | VBRP-MATNR | No | FG-10020 |
| P_ALTME | Alternative unit of measure | Single value | MARM-MEINH | No | KG |
| P_NOCAN | Exclude cancelled and cancellation documents | Checkbox | — | No | X |
Output columns
| # | Column | Source |
|---|---|---|
| 1 | Billing document | VBRK-VBELN |
| 2 | Item | VBRP-POSNR |
| 3 | Billing date | VBRK-FKDAT |
| 4 | Customer name | KNA1-NAME1 |
| 5 | Material | VBRP-MATNR |
| 6 | Billed quantity | VBRP-FKIMG |
| 7 | Sales unit | VBRP-VRKME |
| 8 | Quantity in alternative unit | Calculated FKLMG × MARM-UMREN / MARM-UMREZ (for the selected unit) |
| 9 | List price value | Calculated Sum of KWERT for the conditions mapped to the 'list price' column during setup |
| 10 | Discounts | Calculated Sum of KWERT for the conditions mapped to the discount column |
| 11 | Freight | Calculated Sum of KWERT for the conditions mapped to the freight column |
| 12 | Bonus accrual | Calculated Sum of KWERT for the conditions mapped to the bonus column |
| 13 | Net value | VBRP-NETWR |
| 14 | Currency | VBRK-WAERK |
| 15 | Accounting document | BKPF-BELNR |
| 16 | Sales order | VBRP-AUBEL |
Sample output
| Billing document | Item | Billing date | Customer name | Material | Billed quantity | Sales unit | Quantity in alternative unit | List price value | Discounts | Freight | Bonus accrual | Net value | Currency | Accounting document | Sales order |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 90051231 | 10 | 10/06/2026 | Örnek Ambalaj A.Ş. | FG-10020 | 1,200 | KAR | 9,600 | 54,000 | -4,320 | 1,250 | -1,080 | 49,930 | TRY | 1800023411 | 10004512 |
| 90051231 | 20 | 10/06/2026 | Örnek Ambalaj A.Ş. | FG-10035 | 800 | KAR | 5,120 | 31,200 | -2,496 | 830 | -624 | 28,910 | TRY | 1800023411 | 10004512 |
| 90051244 | 10 | 10/07/2026 | Demo Gıda Ltd. | FG-20110 | 450 | KOL | 6,750 | 40,500 | 0 | 1,900 | -810 | 41,590 | TRY | 1800023460 | 10004530 |
| 90051302 | 10 | 10/09/2026 | Deneme Kimya San. A.Ş. | FG-30008 | 20 | TO | 20,000 | 18,400 | -920 | 600 | 0 | 18,080 | EUR | 1800023517 | 10004588 |
How does the report work?
- VBRK is read by the sales organization, billing date and billing type entered on the selection screen; cancelled documents (FKSTO) and cancellation invoices can be excluded.
- Items come from VBRP: material, billed quantity (FKIMG, VRKME), quantity in base unit (FKLMG), net/gross weight, net value, sales order reference (AUBEL/AUPOS) and delivery reference (VGBEL).
- Pricing conditions are read in one pass from PRCD_ELEMENTS in S/4HANA (KONV in ECC) using VBRK-KNUMV and the item number. A setup table maps each condition type to a report column (for example list price, customer discount, campaign discount, freight, bonus accrual); unmapped conditions are summed in an “other” column. Inactive conditions (KINAK) are left out.
- For the alternative unit, the conversion factors in MARM (UMREZ/UMREN) are used; conversions between weight units are done with UNIT_CONVERSION_SIMPLE. If the material has no conversion, the cell stays empty and the row is flagged.
- The accounting document is found in BKPF with AWTYP = ‘VBRK’ and AWKEY = billing document number; in S/4HANA the amount and profit center can be read from ACDOCA.
- Order type, customer order date and payment terms are added from VBAK/VBKD. The ALV shows the condition columns with totals; clicking the billing or order number opens the document.
Performance notes
Read conditions in one pass with FOR ALL ENTRIES or a JOIN on the KNUMV list of the selected invoices instead of one SELECT per invoice. One month is typically hundreds of thousands of condition rows; for month-end, run the report in the background and save the ALV layout. In S/4HANA, aggregating PRCD_ELEMENTS and ACDOCA in the database through CDS or AMDP can be considered.
Features
- ALV list (sort, filter, subtotals)
- User-specific layout variants Condition columns and totals can be saved as a user layout.
- Double-click drill-down to the document Click through to the billing document, sales order and accounting document.
- Export to Excel
- Runs as a background job The month-end extract can be produced in the background and kept with its ALV layout.
Authorization objects
- V_VBRK_VKOBilling document display by sales organization
- V_VBRK_FKABilling document display by billing type
- F_BKPF_BUKCompany code authorization for the accounting document column
Frequently asked questions
Does the report need to change when a new condition type is added?
No. The mapping of condition types to report columns is kept in a setup table; mapping the new condition type to a column is enough. Unmapped conditions appear in the 'other' column, so no amount is lost.
Where does the alternative unit of measure come from?
From the unit conversions in the material master (MARM). If the selected unit is not defined for the material and both units are weight units, the standard unit conversion is used; otherwise the cell stays empty and the row is flagged.
What is read instead of KONV in S/4HANA?
In S/4HANA pricing conditions are stored in PRCD_ELEMENTS; the report reads the right table for the release. On the accounting side the BKPF link stays the same, and ACDOCA can be used for the amount and profit center.
Related reports
Billing Documents Not Posted to Accounting Report
A custom ALV report that lists billing documents which exist in SD but have no accounting document yet, with the reason code, age and amount. At …
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 …
Let us build this report for your system
Briefly describe your system and expectations. We will clarify the scope and come back with an effort and price quote.