PS Report Custom development ALV report

Billing Milestones Reached but Not Invoiced Report

Short answer: 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 invoiced, with customer, amount, billing block and days since completion. It shows project and sales teams together where delayed collections come from.

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

Why is the standard not enough?

The VF04 billing due list shows SD billing plan dates, but it does not show items whose milestone is completed while the billing block is still set or the billing date is still in the future, together with the WBS element and project responsible. CN53N lists milestones without billing status or amount. As a result, completed work can stay uninvoiced for weeks.

Who uses it? Project managers, sales operations and billing teams, finance teams that monitor cash flow.

Closest standard alternatives

  • VF04 Maintain Billing Due List. Processes the billing due list; does not show items whose milestone is completed but blocked or dated in the future, with the WBS element.
  • CN53N Overview: Milestones. Lists milestones; no billing plan value or status.

Tables used

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

TableRoleJoinSystem
MLSTMilestoneMilestone: number, WBS element and actual date (driving table)—ECC + S/4
PRPSWBS Element Master DataWBS element and responsible personPRPS-PSPNR = MLST-PSPNRECC + S/4
FPLTBilling Plan DatesBilling plan date: value, percentage, billing date, status and blockFPLT-MLSTN = MLST-MLSTNECC + S/4
FPLABilling PlanBilling plan header and sales documentFPLA-FPLNR = FPLT-FPLNRECC + S/4
VBAKSales Document HeaderSales order: customer and sales organizationVBAK-VBELN = FPLA-VBELNECC + S/4
KNA1Customer Master (General Section)Customer nameKNA1-KUNNR = VBAK-KUNNRECC + S/4

Selection screen parameters

ParameterDescriptionTypeReference fieldRequiredExample
S_VKORGSales organizationRange / multipleVBAK-VKORGNo1000
S_KUNNRCustomerRange / multipleVBAK-KUNNRNo200310
S_VBELNSales documentRange / multipleVBAK-VBELNNo0000012045
S_POSIDWBS elementRange / multiplePRPS-POSIDNoP-26-0012-*
S_ACTDTMilestone actual dateRange / multipleMLST-LST_ACTDTNo01.01.2026 – 17.11.2026
P_BLOCKBilling block onlyCheckbox—No—
P_KEYDTKey dateSingle valueSY-DATUMYes17.11.2026

Output columns

#ColumnSource
1WBS elementPRPS-POSID
2MilestoneMLST-MLSTN
3Actual dateMLST-LST_ACTDT
4Sales documentVBAK-VBELN
5CustomerVBAK-KUNNR
6Customer nameKNA1-NAME1
7Billing plan itemFPLT-FPLTR
8Billing dateFPLT-AFDAT
9PercentageFPLT-FPROZ
10Value to billFPLT-FAKWR
11CurrencyFPLT-WAERS
12Billing blockFPLT-FAKSP
13Billing statusFPLT-FKSAF
14Days since completionCalculated Key date − MLST-LST_ACTDT
15StatusCalculated Block set / billing date not reached / due, not invoiced

Sample output

WBS elementMilestoneActual dateSales documentCustomerCustomer nameBilling plan itemBilling datePercentageValue to billCurrencyBilling blockBilling statusDays since completionStatus
P-26-0012-010000041206/20/20260000012045200310Kartal Enerji00000206/20/2026202,400,000TRYZ1A150Block set
P-26-0012-020000041510/28/20260000012045200310Kartal Enerji00000310/31/2026404,800,000TRYA20Due, not invoiced
P-26-0015-010000043109/26/20260000012190200455Boğaziçi Altyapı00000412/01/2026301,950,000TRYA52Billing date not reached
A view built with fictional sample data; not real system data.

How does the report work?

  1. Milestones with an actual date (LST_ACTDT) in the selected range and before the key date, not deleted (LOEKZ), are read from MLST; the WBS element is added from PRPS.
  2. Billing plan dates are found in FPLT by milestone number (FPLT-MLSTN = MLST-MLSTN); dates whose billing status (FKSAF) is fully processed are skipped.
  3. The sales document comes from FPLA, the customer and sales organization from VBAK and the customer name from KNA1.
  4. The billing value FPLT-FAKWR, percentage FPLT-FPROZ, billing date FPLT-AFDAT and block FPLT-FAKSP are shown. Days since = key date − LST_ACTDT.
  5. Status: “block set” (FAKSP filled), “billing date not reached” (AFDAT > key date) or “due, not invoiced”.

Performance notes

MLST and FPLT are small tables, so the report runs fast online. The selection order is set to read VBAK/FPLA first when a sales organization is given, and MLST first otherwise. A background job with email is recommended for the weekly collections meeting.

Features

  • ALV list (sort, filter, subtotals)
  • User-specific layout variants
  • Double-click drill-down to the document The sales document opens VA03 (billing plan), the WBS element opens CJ20N.
  • Export to Excel
  • Runs as a background job
  • Send the result by email Can be sent to project and sales owners for the weekly collections meeting.

Authorization objects

  • V_VBAK_VKOSales document display authorization by sales organization
  • V_VBAK_AATDisplay authorization by sales document type
  • C_PRPS_VNRWBS element authorization by responsible person

Frequently asked questions

Does the report create the invoice or remove the block?

No, it only reads. Billing is done with VF04 or VF01. If automatic block removal is wanted, it is assessed as a separate program.

Is resource-related billing covered as well?

No. The report covers billing plan dates linked to milestones. Resource-related billing with DP91 is tracked with a different logic.

Does this report work on S/4HANA?

Yes. MLST, FPLA and FPLT are used in S/4HANA as well; VBAK and KNA1 are read with the same fields.

Packages that include this solution

PS Package Custom

Project Budget and Schedule Controlling Pack

A pack that combines five reports for the project review meeting with one project definition and WBS selection: budget vs actual vs commitment, …

5 components · v1.0

Related reports

SD Report Custom ALV report

Sales Order – Delivery – Invoice Status Report

A custom ALV report that shows every sales order item on the same line as its delivery and invoice documents. You see in one list which orders have …

VBAK · VBAP · VBFA · LIKP

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: Billing Milestones Reached but Not Invoiced Report