query templates

the most common procurement report. shows all purchase orders with their goods receipt and invoice receipt history. essential for tracking po fulfillment, identifying gr/ir mismatches, and reconciling open commitments.

audit staple: traces every purchase order through to its invoice verification documents. shows po line items alongside their matched invoices from logistics invoice verification (miro). essential for three-way match audits, duplicate invoice detection, and ap reconciliation.

core order-to-cash (otc) reporting. traces every sales order item through delivery and billing, showing the complete fulfillment lifecycle. essential for revenue recognition, delivery performance analysis, and order backlog reporting.

pipeline visibility: shows all sales order items with their downstream document flow status. identifies items not yet delivered, not yet billed, or partially fulfilled. essential for order backlog analysis, revenue pipeline tracking, and delivery planning.

complete inventory picture: combines material master data with current stock quantities and valuation prices across plant and storage location levels. the go-to query for inventory analysis, stock valuation audits, and slow-moving inventory identification.

ap essentials: shows all open (unpaid) vendor invoices with aging analysis. combines vendor master data with open line items from the secondary index. the foundation for cash flow planning, payment prioritization, and vendor relationship management.

ar essentials: shows all open (unpaid) customer invoices with aging analysis. combines customer master data with open receivables. the foundation for collections management, bad debt provisioning, and dso (days sales outstanding) calculation.

general ledger analysis: shows accounting document headers with their line items and g/l account details. the fundamental fi query for journal entry analysis, account reconciliation, and audit trail reporting.

warehouse and logistics analysis: shows all inventory movements (goods receipts, goods issues, transfers, scrapping) with material details. essential for inventory transaction auditing, movement type analysis, and supply chain traceability.

manufacturing reporting: shows production orders with their header data, produced items, and bom components. essential for production planning analysis, component availability checks, and manufacturing cost tracking.

complete fi document journal listing all accounting documents with header and line item details. joins bkpf (document headers) to bseg (line items) with full filtering by company code, fiscal year, document type, posting date range, and account type. essential for auditors, accountants, and anyone needing a full ledger extract.

extracts tax-relevant data from fi documents by joining bkpf (document headers), bseg (line items), and bset (tax data line items). provides tax base amounts, tax amounts by tax code, and jurisdiction details needed for vat/gst reporting and tax reconciliation.

traces automatic payment program (f110) results by joining reguh (payment headers per vendor), regup (individual items settled in each payment), and payr (issued payment media/checks). provides a complete view of what was paid, when, by which payment method, and check/transfer details.

shows the status of purchase requisitions (prs) and their conversion to purchase orders. joins eban (pr line items) to ekpo (po line items) via the pr-to-po assignment fields. useful for procurement monitoring: which prs are still open, which converted to pos, and at what price variance.

extracts material movement history by joining mkpf (material document headers) with mseg (material document items). filterable by movement type (bwart) to isolate goods receipts (101), goods issues (261), transfer postings (301), returns, scrapping, etc. core report for inventory analysis, consumption tracking, and logistics auditing.

reports on open (unfulfilled) sales orders by joining vbak (sales order headers), vbap (sales order items), and vbup (item-level status). filters for items not yet fully delivered or billed, giving a clear picture of outstanding customer commitments, backlog value, and aging.

measures delivery performance by comparing scheduled delivery dates from vbep (sales order schedule lines) against actual goods issue dates from likp (delivery headers). joins through lips (delivery items) back to the sales order for traceability. calculates on-time vs. late metrics per customer, material, and plant.

extracts billing document revenue data by joining vbrk (billing headers), vbrp (billing items), kna1 (customer master), and mara (material master). provides revenue amounts with customer name and material details for revenue analysis, commission calculations, and financial reporting.

summarizes actual costs posted to internal orders by joining aufk (order master data) with coep (co line items — actual postings). shows total actual costs per order, cost element, and period. useful for project cost tracking, marketing spend analysis, and investment monitoring against budgets.

end-to-end p2p trace for a single purchase order: from purchase requisition (eban) through po header/items (ekko/ekpo), goods receipt/history (ekbe), invoice receipt (rseg/rbkp), to the final fi accounting document (bkpf/bseg). traces the complete lifecycle of a procurement transaction for audit, reconciliation, and dispute resolution.