PS Report Custom development ALV report

Project Revenue vs Sales Order Billing Reconciliation Report

Short answer: 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.

Estimated effort
M · 4–6 working days
System
ECC and S/4HANA
Tables
10
Scope
Global
Built by
NeKuDos Teknoloji
Last updated

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.

Who uses it? Project control teams, project accounting, sales operations and finance managers.

Closest standard alternatives

  • CJI3 Project Actual Cost Line Items. Shows revenue line items posted to the project; no comparison with order value and invoices.
  • VA03 Display Sales Order. The document flow shows the invoices of one order; no multi-project reconciliation or project revenue.

Tables used

The tables the report reads and their join fields. ECC and S/4HANA differences are marked separately.

TableRoleJoinSystem
PRPSWBS Element Master DataBilling WBS elements (driving table)—ECC + S/4
PROJProject DefinitionProject definitionPROJ-PSPNR = PRPS-PSPHIECC + S/4
VBAPSales Document ItemSales order item assigned to the WBS element and its net valueVBAP-PS_PSP_PNR = PRPS-PSPNRECC + S/4
VBAKSales Document HeaderOrder header: customer and sales organizationVBAK-VBELN = VBAP-VBELNECC + S/4
VBRPBilling Document: Item DataBilling items created for the order itemVBRP-AUBEL = VBAP-VBELN AND VBRP-AUPOS = VBAP-POSNRECC + S/4
VBRKBilling Document HeaderBilling header: cancellation, document category and accounting transfer statusVBRK-VBELN = VBRP-VBELNECC + S/4
COSPCO Object: Cost Totals for External PostingsActual revenue posted to the project (revenue cost elements, WRTTP 04)COSP-OBJNR = PRPS-OBJNRECC + S/4
KNA1Customer Master (General Section)Customer nameKNA1-KUNNR = VBAK-KUNNRECC + S/4
I_SalesOrderItemSales Order ItemCDS view that can replace VBAP in S/4HANASalesOrder = VBAP-VBELN AND SalesOrderItem = VBAP-POSNRS/4HANA only
I_BillingDocumentItemBilling Document ItemCan replace VBRP in S/4HANABillingDocument = VBRP-VBELNS/4HANA only

S/4HANA notes

  • COSP → ACDOCA: In S/4HANA COSP is a view, not a table; actual totals are calculated from ACDOCA.

Selection screen parameters

ParameterDescriptionTypeReference fieldRequiredExample
S_PSPIDProjectRange / multiplePROJ-PSPIDYesP-26015
S_POSIDWBS elementRange / multiplePRPS-POSIDNoP-26015*
S_PBUKRCompany codeRange / multiplePRPS-PBUKRYes1000
S_VKORGSales organizationRange / multipleVBAK-VKORGNo1000
S_KUNNRCustomerRange / multipleVBAK-KUNNRNo200150
S_KSTARRevenue cost elementsRange / multipleCOSP-KSTARYes800000–809999
S_GJAHRFiscal yearRange / multipleCOSP-GJAHRNo2026
P_DIFFDifferences onlyCheckbox—NoX

Output columns

#ColumnSource
1WBS elementPRPS-POSID
2DescriptionPRPS-POST1
3Sales orderVBAP-VBELN
4ItemVBAP-POSNR
5CustomerVBAK-KUNNR
6Customer nameKNA1-NAME1
7Order valueVBAP-NETWR
8BilledCalculated Σ VBRP-NETWR (not cancelled; returns and credit memos negative)
9Project revenueCalculated −Σ COSP actual (WRTTP 04), revenue cost elements
10DifferenceCalculated Billed − project revenue
11Remaining unbilledCalculated VBAP-NETWR − billed
12CurrencyVBAP-WAERK
13Invoices not postedCalculated Number of invoices with VBRK-RFBSK ≠ C
14Check resultCalculated Matched, invoice not posted, billed to another WBS or direct FI revenue

Sample output

WBS elementDescriptionSales orderItemCustomerCustomer nameOrder valueBilledProject revenueDifferenceRemaining unbilledCurrencyInvoices not postedCheck result
P-26015-01Engineering service0000081240000010200150Anadolu Enerji2,400,0001,600,0001,600,0000800,000TRY0Matched
P-26015-04Equipment delivery0000081240000020200150Anadolu Enerji5,100,0003,060,0002,040,0001,020,0002,040,000TRY1Invoice not posted
P-26022-01Site services0000081305000010200218Trakya Altyapı950,000475,000520,000-45,000475,000TRY0Direct FI revenue
P-26031-02Commissioning0000081377000010200301Karadeniz Tesis380,000190,0000190,000190,000EUR0Billed to another WBS
A view built with fictional sample data; not real system data.

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.

Performance notes

Narrow the PRPS selection by project and FAKKZ. If there is no secondary index for reading VBAP via PS_PSP_PNR, read orders with a VBAK/VBAP JOIN and a sales organization filter. Restrict COSP by the revenue cost element range and fiscal year.

Features

  • ALV list (sort, filter, subtotals)
  • User-specific layout variants
  • Double-click drill-down to the document Double-clicking the order opens VA03; double-clicking the project revenue opens CJI3.
  • Export to Excel
  • Runs as a background job
  • Send the result by email Rows with differences can be sent to project accounting before month-end close.

Authorization objects

  • C_PROJ_KOKProject display authorization by controlling area
  • V_VBAK_VKOSales order display authorization by sales organization
  • V_VBRK_VKOBilling 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.

Packages that include this solution

PS Package Custom

Project Closing Control Pack

A five-component pack for closing projects without leaving open items behind: a technical completion readiness check, reconciliation of project …

5 components · v1.0

Related reports

PS Report Custom ALV report

Billing Milestones Reached but Not Invoiced Report

A custom ALV report that lists completed project milestones, those with an actual date, whose billing plan date in the sales order is still not …

MLST · PRPS · FPLT · FPLA

SD Report Custom ALV report

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 …

VBRK · VBRP · BKPF · KNA1

SD Report Custom ALV report

Sales Order Gross Margin Report by Item

A custom ALV report that compares the net value of every sales order item with the cost determined in pricing and shows the gross profit and margin …

VBAK · VBAP · KNA1 · KONV

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.

Related report: Project Revenue vs Sales Order Billing Reconciliation Report