MM Report Custom development ALV report

Purchase Requisition to Payment End-to-End Document Flow and Cycle Time Report

Short answer: A custom ALV report that follows each purchase requisition item through the purchase order, goods receipt, invoice and payment on a single row and calculates the days between the steps. Purchasing and accounting teams see where the process gets stuck and how long requisition-to-payment takes on average.

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

Why is the standard not enough?

ME5A shows the requisition and the linked order number, and ME80FN shows the goods receipts and invoices in the order history; but no standard list puts requisition, order, goods receipt, invoice and payment dates on the same row and calculates the time between the steps. Payment information requires a separate trip to FBL1N. The custom report builds the chain in one run and flags the step that is still open.

Who uses it? Purchasing managers, accounts payable, process owners and internal audit.

Closest standard alternatives

  • ME5A Purchase Requisitions: List Display. Lists requisitions with the linked order number; no goods receipt, invoice or payment dates.
  • ME80FN General Analyses of Purchasing Documents. Shows the order history but does not start from the requisition and gives no payment data or step durations.

Tables used

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

TableRoleJoinSystem
EBANPurchase RequisitionPurchase requisition item: requisition and release date (driving table)—ECC + S/4
EKPOPurchasing Document ItemOrder item created from the requisitionEKPO-BANFN = EBAN-BANFN AND EKPO-BNFPO = EBAN-BNFPOECC + S/4
EKKOPurchasing Document HeaderOrder date, vendor and company codeEKKO-EBELN = EKPO-EBELNECC + S/4
EKBEPurchasing Document HistoryOrder history: goods receipt and invoice datesEKBE-EBELN = EKPO-EBELN AND EKBE-EBELP = EKPO-EBELPECC + S/4
RBKPDocument Header: Incoming InvoiceLogistics invoice header: posting date and payment blockRBKP-BELNR = EKBE-BELNR AND RBKP-GJAHR = EKBE-GJAHRECC + S/4
BKPFAccounting Document HeaderFI document of the invoiceBKPF-AWKEY = RBKP-BELNR + RBKP-GJAHRECC + S/4
BSAKVendor Cleared ItemsCleared vendor item: payment date and payment documentBSAK-BUKRS = BKPF-BUKRS AND BSAK-BELNR = BKPF-BELNR AND BSAK-GJAHR = BKPF-GJAHRECC + S/4
LFA1Vendor Master (General Section)Vendor nameLFA1-LIFNR = EKKO-LIFNRECC + S/4
I_PurchaseRequisitionItemAPI01Purchase Requisition Item (API)Released CDS view that can replace EBAN in S/4HANAPurchaseRequisition = EBAN-BANFNS/4HANA only
I_SupplierInvoiceAPI01Supplier Invoice (API)Can replace RBKP in S/4HANASupplierInvoice = RBKP-BELNRS/4HANA only

S/4HANA notes

  • BSAK → I_OperationalAcctgDocItem: In S/4HANA BSAK is not filled as a separate table; it is read through a compatibility view of the same name. For new developments the I_OperationalAcctgDocItem CDS view is recommended.

Selection screen parameters

ParameterDescriptionTypeReference fieldRequiredExample
S_WERKSPlantRange / multipleEBAN-WERKSYes1000
S_EKGRPPurchasing groupRange / multipleEBAN-EKGRPNo001
S_BSARTRequisition typeRange / multipleEBAN-BSARTNoNB
S_BADATRequisition date rangeRange / multipleEBAN-BADATYes01.07.2026 – 31.10.2026
S_AFNAMRequisitionerRange / multipleEBAN-AFNAMNoBAKIM
S_LIFNRVendorRange / multipleEKKO-LIFNRNo100245
P_OPENOnly chains not yet paidCheckbox—NoX

Output columns

#ColumnSource
1RequisitionEBAN-BANFN
2Req. itemEBAN-BNFPO
3Release dateEBAN-FRGDT
4Purchase orderEKPO-EBELN
5Order dateEKKO-BEDAT
6Vendor nameLFA1-NAME1
7First goods receiptCalculated Earliest EKBE-BUDAT (VGABE = 1)
8Invoice documentRBKP-BELNR
9Invoice posting dateRBKP-BUDAT
10Payment dateBSAK-AUGDT
11Req. → order (days)Calculated EKKO-BEDAT − EBAN-FRGDT
12Order → GR (days)Calculated First goods receipt − EKKO-BEDAT
13GR → invoice (days)Calculated RBKP-BUDAT − first goods receipt
14Invoice → payment (days)Calculated BSAK-AUGDT − RBKP-BUDAT
15Total cycle (days)Calculated Date of the last step reached − EBAN-FRGDT
16Open stepCalculated First step not yet reached: order, goods receipt, invoice, payment or completed

Sample output

RequisitionReq. itemRelease datePurchase orderOrder dateVendor nameFirst goods receiptInvoice documentInvoice posting datePayment dateReq. → order (days)Order → GR (days)GR → invoice (days)Invoice → payment (days)Total cycle (days)Open step
00100045210001009/02/2026450001289009/05/2026Atlas Ambalaj09/19/2026510560011209/22/202610/22/202631433050Completed
00100045870002009/15/2026450001301509/24/2026Delta Metal10/14/2026510560039810/30/20269201645Payment
00100046330001010/01/2026450001310210/03/2026Ege Kimya10/27/202622447Invoice
00100047020001010/20/202628Order
A view built with fictional sample data; not real system data.

How does the report work?

  1. EBAN is read by plant, purchasing group, document type and requisition date; deleted items (LOEKZ) are skipped.
  2. Order items linked to the requisition are found via EKPO-BANFN/BNFPO; the order date and vendor come from EKKO. If a requisition is split over several orders, each order item becomes its own row.
  3. The first goods receipt (VGABE = 1) and first invoice (VGABE = 2) dates are taken from EKBE; reversals (SHKZG) are taken into account.
  4. The invoice document is read from RBKP; the FI document is found via BKPF-AWKEY = RBKP-BELNR + RBKP-GJAHR. The clearing date and document of the vendor line come from BSAK (payment date).
  5. Durations: requisition release → order, order → goods receipt, goods receipt → invoice, invoice → payment and total. The first step not yet reached is shown as the “open step”.

Performance notes

Always restrict the EBAN selection by requisition date and plant. Read EKBE in one pass for the selected order items. For BKPF access via AWKEY, supply AWTYP = RMRP together with AWKEY; on large systems a nightly background job is recommended.

Features

  • ALV list (sort, filter, subtotals)
  • User-specific layout variants
  • Double-click drill-down to the document The requisition opens ME53N, the order ME23N, the invoice MIR4 and the payment document FB03.
  • Export to Excel
  • Runs as a background job
  • Send the result by email A monthly cycle time summary can be sent to purchasing and accounting managers.

Authorization objects

  • M_BANF_WRKRequisition display authorization by plant
  • M_BEST_WRKOrder display authorization by plant
  • F_BKPF_BUKAccounting document display authorization by company code

Frequently asked questions

Which date is used when an order is invoiced several times?

By default the first invoice and its payment are shown. The last invoice date can be chosen on the selection screen; for partly invoiced orders both dates can be added to the ALV as extra columns.

Do orders created without a requisition appear?

No, the report starts from requisition items. If the share of orders without a requisition matters for process compliance, an extra option can show orders with an empty EKPO-BANFN in a separate list.

Where is payment data read from in S/4HANA?

In S/4HANA, BSAK is a compatibility view and keeps working; for a clean core approach the clearing can be taken from ACDOCA or released CDS views. I_PurchaseRequisitionItemAPI01 and I_SupplierInvoiceAPI01 can be used for requisitions and invoices.

Packages that include this solution

MM Package Custom

Purchasing Approval and Cycle Time Pack

A four-component pack that shows where purchasing waits between requisition and payment: released requisitions not yet ordered, purchase orders …

4 components · v1.0

Related reports

FI Report Custom ALV report

Vendor Open Items Aging Report

A custom ALV report that ages vendor open items by net due date and spreads the amounts into not-due, 0–30, 31–60, 61–90 and 90+ day buckets. The …

BSIK · LFA1 · LFB1 · T001

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: Purchase Requisition to Payment End-to-End Document Flow and Cycle Time Report