# Project Revenue vs Sales Order Billing Reconciliation Report

> A custom ALV report that shows, on one row per billing WBS element, the differences between the sales order value, the amount invoiced and the revenue posted to the project. Project control and accounting teams catch billing documents not passed to accounting, revenue that went to another WBS element and the remaining unbilled amount before month end.

- Type: Report, Custom development, ALV report
- Module: PS
- Estimated effort: M (4–6 working days)
- Last updated: 2026-11-17
- URL: https://nekuhub.com/en/reports/project-revenue-sales-order-billing-reconciliation-report/


## Why is the standard not enough?

CJI3 shows the revenue line items posted to the project but does not compare them with the sales order item value and the billing documents. The VA03 document flow shows the invoices of a single order. The reason for a difference between billed amount and project revenue (billing not passed to accounting, posting to another WBS, direct FI revenue) does not appear together in any standard list. The custom report reconciles the three sources per WBS element.

### Closest standard alternatives

- CJI3: Shows revenue line items posted to the project; no comparison with order value and invoices.
- VA03: The document flow shows the invoices of one order; no multi-project reconciliation or project revenue.

## Tables used

| Table | Role | Access | Join | System |
|---|---|---|---|---|
| PRPS | Billing WBS elements (driving table) | Read | - | ECC + S/4 |
| PROJ | Project definition | Read | PROJ-PSPNR = PRPS-PSPHI | ECC + S/4 |
| VBAP | Sales order item assigned to the WBS element and its net value | Read | VBAP-PS_PSP_PNR = PRPS-PSPNR | ECC + S/4 |
| VBAK | Order header: customer and sales organization | Read | VBAK-VBELN = VBAP-VBELN | ECC + S/4 |
| VBRP | Billing items created for the order item | Read | VBRP-AUBEL = VBAP-VBELN AND VBRP-AUPOS = VBAP-POSNR | ECC + S/4 |
| VBRK | Billing header: cancellation, document category and accounting transfer status | Read | VBRK-VBELN = VBRP-VBELN | ECC + S/4 |
| COSP | Actual revenue posted to the project (revenue cost elements, WRTTP 04) | Read | COSP-OBJNR = PRPS-OBJNR | ECC + S/4 |
| KNA1 | Customer name | Read | KNA1-KUNNR = VBAK-KUNNR | ECC + S/4 |
| I_SalesOrderItem | CDS view that can replace VBAP in S/4HANA | Read | SalesOrder = VBAP-VBELN AND SalesOrderItem = VBAP-POSNR | S/4HANA only |
| I_BillingDocumentItem | Can replace VBRP in S/4HANA | Read | BillingDocument = VBRP-VBELN | S/4HANA only |

## Selection screen parameters

| Parameter | Description | Type | Reference field | Required |
|---|---|---|---|---|
| S_PSPID | Project | Range / multiple | PROJ-PSPID | Yes |
| S_POSID | WBS element | Range / multiple | PRPS-POSID | No |
| S_PBUKR | Company code | Range / multiple | PRPS-PBUKR | Yes |
| S_VKORG | Sales organization | Range / multiple | VBAK-VKORG | No |
| S_KUNNR | Customer | Range / multiple | VBAK-KUNNR | No |
| S_KSTAR | Revenue cost elements | Range / multiple | COSP-KSTAR | Yes |
| S_GJAHR | Fiscal year | Range / multiple | COSP-GJAHR | No |
| P_DIFF | Differences only | Checkbox | - | No |

## Output columns

| Column | Source |
|---|---|
| WBS element | PRPS-POSID |
| Description | PRPS-POST1 |
| Sales order | VBAP-VBELN |
| Item | VBAP-POSNR |
| Customer | VBAK-KUNNR |
| Customer name | KNA1-NAME1 |
| Order value | VBAP-NETWR |
| Billed | Calculated: Σ VBRP-NETWR (not cancelled; returns and credit memos negative) |
| Project revenue | Calculated: −Σ COSP actual (WRTTP 04), revenue cost elements |
| Difference | Calculated: Billed − project revenue |
| Remaining unbilled | Calculated: VBAP-NETWR − billed |
| Currency | VBAP-WAERK |
| Invoices not posted | Calculated: Number of invoices with VBRK-RFBSK ≠ C |
| Check result | Calculated: Matched, invoice not posted, billed to another WBS or direct FI revenue |

## How does the report work?

1. PROJ and PRPS are read by project, WBS element and company code; only billing elements (PRPS-FAKKZ = X) are taken.
2. Sales order items assigned to the WBS element are found via VBAP-PS_PSP_PNR; rejected items (ABGRU filled) are skipped. The customer comes from VBAK and KNA1.
3. Billing documents are read via VBRP-AUBEL/AUPOS; cancelled documents (VBRK-FKSTO) are skipped and returns and credit memos (VBRK-VBTYP) are totalled with a negative sign. Documents not passed to accounting (VBRK-RFBSK ≠ C) are counted separately.
4. Project revenue comes from the COSP actuals (WRTTP 04) of the selected revenue cost elements; the sign is reversed because revenue is a credit posting.
5. Difference = billed − project revenue; remaining = order value − billed. If the billing WBS (VBRP-PS_PSP_PNR) differs from the order WBS, a "billed to another WBS" flag is set. The check result column states the likely reason for the difference.

## Authorization objects

- C_PROJ_KOK: Project display authorization by controlling area
- V_VBAK_VKO: Sales order display authorization by sales organization
- V_VBRK_VKO: Billing document display authorization by sales organization

## Frequently asked questions

### Why are revenue cost elements asked on the selection screen?

Both costs and revenues are posted to the project, and revenue is separated by revenue-type cost elements. Because the range depends on the chart of accounts, these elements are given on the selection screen or in a variant; the report totals only those as revenue.

### What about projects with results analysis (revenue accrual)?

With results analysis, the project may carry a revenue value different from billing. In that case the report is extended to show billing revenue and the results analysis value in separate columns, so the reason for the difference stays clear.

### How is this reconciliation done on S/4HANA?

In S/4HANA revenue is written to ACDOCA; COSP can be read as a compatibility view or ACDOCA can be totalled directly by WBS element and account. For orders and billing, the CDS views I_SalesOrderItem and I_BillingDocumentItem can be used.

---
Let us build this report for your system: https://nekuhub.com/en/request-a-quote/?report=ps-project-revenue-vs-sales-order-billing
