# Billing Item Detail Report with Pricing Conditions and Quantities

> 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.

- Type: Report, Custom development, ALV report
- Module: SD
- Estimated effort: M (5–8 working days)
- Last updated: 2026-11-18
- URL: https://nekuhub.com/en/reports/billing-item-detail-report-pricing-conditions-quantities/


## 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.

### Closest standard alternatives

- VF05N: Lists billing documents; does not show condition values or the quantity in an alternative unit.
- KE24: Shows profitability line items with value fields; columns depend on the CO-PA setup and no unit conversion is done.
- VF03: Shows the conditions of a single invoice item by item; gives no list.

## Tables used

| Table | Role | Access | Join | System |
|---|---|---|---|---|
| VBRK | Billing header: billing type, date, payer, document currency, condition number (driving table) | Read | - | ECC + S/4 |
| VBRP | Billing items: material, quantity, unit, weight, net value, order and delivery reference | Read | VBRP-VBELN = VBRK-VBELN | ECC + S/4 |
| PRCD_ELEMENTS | Pricing conditions per item (S/4HANA) | Read | PRCD_ELEMENTS-KNUMV = VBRK-KNUMV AND KPOSN = VBRP-POSNR | S/4HANA only |
| KONV | Pricing conditions per item (ECC) | Read | KONV-KNUMV = VBRK-KNUMV AND KPOSN = VBRP-POSNR | ECC only |
| MARM | Alternative unit of measure conversion factors | Read | MARM-MATNR = VBRP-MATNR | ECC + S/4 |
| BKPF | Accounting document created from the invoice | Read | BKPF-AWTYP = 'VBRK' AND BKPF-AWKEY = VBRK-VBELN | ECC + S/4 |
| ACDOCA | Accounting amount and profit center (S/4HANA, optional) | Read | ACDOCA-RBUKRS = BKPF-BUKRS AND BELNR = BKPF-BELNR AND GJAHR = BKPF-GJAHR | S/4HANA only |
| VBAK | Order type and order date | Read | VBAK-VBELN = VBRP-AUBEL | ECC + S/4 |
| VBKD | Payment terms and incoterms | Read | VBKD-VBELN = VBRP-AUBEL | ECC + S/4 |
| KNA1 | Customer name | Read | KNA1-KUNNR = VBRK-KUNAG | ECC + S/4 |

## BAPIs and functions used

- UNIT_CONVERSION_SIMPLE: Converts between weight and volume units

## Selection screen parameters

| Parameter | Description | Type | Reference field | Required |
|---|---|---|---|---|
| S_VKORG | Sales organization | Range / multiple | VBRK-VKORG | Yes |
| S_FKDAT | Billing date | Range / multiple | VBRK-FKDAT | Yes |
| S_FKART | Billing type | Range / multiple | VBRK-FKART | No |
| S_KUNAG | Sold-to party | Range / multiple | VBRK-KUNAG | No |
| S_MATNR | Material | Range / multiple | VBRP-MATNR | No |
| P_ALTME | Alternative unit of measure | Single value | MARM-MEINH | No |
| P_NOCAN | Exclude cancelled and cancellation documents | Checkbox | - | No |

## Output columns

| Column | Source |
|---|---|
| Billing document | VBRK-VBELN |
| Item | VBRP-POSNR |
| Billing date | VBRK-FKDAT |
| Customer name | KNA1-NAME1 |
| Material | VBRP-MATNR |
| Billed quantity | VBRP-FKIMG |
| Sales unit | VBRP-VRKME |
| Quantity in alternative unit | Calculated: FKLMG × MARM-UMREN / MARM-UMREZ (for the selected unit) |
| List price value | Calculated: Sum of KWERT for the conditions mapped to the 'list price' column during setup |
| Discounts | Calculated: Sum of KWERT for the conditions mapped to the discount column |
| Freight | Calculated: Sum of KWERT for the conditions mapped to the freight column |
| Bonus accrual | Calculated: Sum of KWERT for the conditions mapped to the bonus column |
| Net value | VBRP-NETWR |
| Currency | VBRK-WAERK |
| Accounting document | BKPF-BELNR |
| Sales order | VBRP-AUBEL |

## How does the report work?

1. 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.
2. 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).
3. 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.
4. 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.
5. 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.
6. 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.

## Authorization objects

- V_VBRK_VKO: Billing document display by sales organization
- V_VBRK_FKA: Billing document display by billing type
- F_BKPF_BUK: Company 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.

---
Let us build this report for your system: https://nekuhub.com/en/request-a-quote/?report=sd-billing-item-condition-quantity-detail
