Cost Center Line Items with Vendor, Purchase Order and Employee Report
Short answer: A custom ALV report that shows cost center actual line items on one row with the purchase order, vendor name, employee name and source document. The cost center owner answers "who incurred this cost, with which vendor and which order" in one list.
- Estimated effort
- M · 3–5 working days
- System
- ECC and S/4HANA
- Tables
- 9
- Scope
- Global
- Built by
- NeKuDos Teknoloji
- Last updated
Why is the standard not enough?
KSB1 shows the CO document, cost element and offsetting account; vendor name and employee name are not on the row, and the PO number is only present on some items. To see the vendor, each row is followed to the FI document and the order separately. Spend analysis and budget meetings need this information in one list.
Who uses it? Cost center owners, controllers and budget teams analysing spend.
Closest standard alternatives
Tables used
The tables the report reads and their join fields. ECC and S/4HANA differences are marked separately.
| Table | Role | Join | System |
|---|---|---|---|
| COEPCO Object: Line Items (by Period) | CO actual line items: object, cost element, amount, PO, employee (driving table) | — | ECC + S/4 |
| COBKCO Object: Document Header | CO document header: posting date, user, reference document | COBK-KOKRS = COEP-KOKRS AND COBK-BELNR = COEP-BELNR | ECC + S/4 |
| CSKSCost Center Master Record | Cost center object number and owner | CSKS-OBJNR = COEP-OBJNR AND CSKS-KOKRS = COEP-KOKRS | ECC + S/4 |
| CSKTCost Center Texts | Cost center text | CSKT-KOKRS = CSKS-KOKRS AND CSKT-KOSTL = CSKS-KOSTL AND CSKT-DATBI = CSKS-DATBI AND CSKT-SPRAS = SY-LANGU | ECC + S/4 |
| EKKOPurchasing Document Header | Vendor on the purchase order | EKKO-EBELN = COEP-EBELN | ECC + S/4 |
| BSEGAccounting Document Segment | Vendor line for FI invoices without a PO | BSEG-BELNR = COBK-REFBN AND BSEG-GJAHR = COBK-REFGJ AND BSEG-KOART = 'K' | ECC + S/4 |
| LFA1Vendor Master (General Section) | Vendor name | LFA1-LIFNR = EKKO-LIFNR veya BSEG-LIFNR | ECC + S/4 |
| PA0001HR Master Record: Infotype 0001 (Organizational Assignment) | Employee name (organizational assignment) | PA0001-PERNR = COEP-PERNR AND PA0001-ENDDA >= COBK-BUDAT | ECC + S/4 |
| ACDOCAUniversal Journal Entry Line Items | Actual items with vendor and PO on S/4HANA | KOKRS = COEP-KOKRS AND RCNTR = CSKS-KOSTL | S/4HANA only |
S/4HANA notes
- COEP → ACDOCA: In S/4HANA actual CO line items are stored in ACDOCA; reads on COEP go through the compatibility view V_COEP.
Selection screen parameters
| Parameter | Description | Type | Reference field | Required | Example |
|---|---|---|---|---|---|
| P_KOKRS | Controlling area | Single value | COEP-KOKRS | Yes | 1000 |
| S_KOSTL | Cost center | Range / multiple | CSKS-KOSTL | Yes | 4110 |
| S_KSTAR | Cost element | Range / multiple | COEP-KSTAR | No | 7700000000 |
| P_GJAHR | Fiscal year | Single value | COEP-GJAHR | Yes | 2026 |
| S_PERIO | Period | Range / multiple | COEP-PERIO | No | 001 – 010 |
| S_LIFNR | Vendor | Range / multiple | EKKO-LIFNR | No | 100245 |
| S_EBELN | Purchase order | Range / multiple | COEP-EBELN | No | 4500012345 |
Output columns
| # | Column | Source |
|---|---|---|
| 1 | Cost center | CSKS-KOSTL |
| 2 | Cost center text | CSKT-KTEXT |
| 3 | Cost element | COEP-KSTAR |
| 4 | Period | COEP-PERIO |
| 5 | Posting date | COBK-BUDAT |
| 6 | CO document | COEP-BELNR |
| 7 | Reference document | COBK-REFBN |
| 8 | Text | COEP-SGTXT |
| 9 | Amount | COEP-WKGBTR |
| 10 | Purchase order | COEP-EBELN |
| 11 | PO item | COEP-EBELP |
| 12 | Vendor | Calculated EKKO-LIFNR; BSEG-LIFNR from the reference FI document when there is no PO |
| 13 | Vendor name | LFA1-NAME1 |
| 14 | Personnel number | COEP-PERNR |
| 15 | Employee name | PA0001-ENAME |
| 16 | Entered by | COBK-USNAM |
Sample output
| Cost center | Cost center text | Cost element | Period | Posting date | CO document | Reference document | Text | Amount | Purchase order | PO item | Vendor | Vendor name | Personnel number | Employee name | Entered by |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4110 | Production maintenance | 7700100000 | 010 | 10/06/2026 | 200014521 | 5105602211 | Hydraulic oil purchase | 18,400 | 4500012345 | 10 | 100387 | Delta Metal | AP_USER1 | ||
| 4110 | Production maintenance | 7700200000 | 010 | 10/12/2026 | 200014633 | 1900004410 | External repair service | 32,500 | 100951 | Teknik Servis Atölyesi | AP_USER2 | ||||
| 9100 | General administration | 7700300000 | 010 | 10/20/2026 | 200014702 | 0000315520 | Travel expenses October | 6,850 | 00001042 | Ayşe Demir | HR_BATCH | ||||
| 9100 | General administration | 7700400000 | 010 | 10/28/2026 | 200014790 | 5105602388 | Office stationery | 4,210 | 4500012411 | 20 | 100245 | Atlas Ambalaj | AP_USER1 |
How does the report work?
- Object numbers (OBJNR) are taken from CSKS by controlling area and cost center selection; the text is added from CSKT.
- Actual line items for those objects are read from COEP: WRTTP = 04, VERSN = 000, fiscal year and period range, cost element selection.
- The document header is added from COBK: posting date, entered by, reference document (REFBN) and reference type (AWTYP).
- Vendor: when the item has a PO (COEP-EBELN), from EKKO-LIFNR; otherwise, when the reference is an FI document, from the vendor line of the same document (BSEG, KOART = K). The name is added from LFA1.
- When the personnel number (COEP-PERNR) is filled, the employee name is added from PA0001-ENAME with the record valid on the posting date; the amount is shown in controlling area currency.
Performance notes
Read COEP by OBJNR, fiscal year and period; buffer COBK, EKKO and LFA1 in bulk. Go to BSEG with the full key only for FI-originated items without a PO. On S/4HANA ACDOCA holds the vendor (LIFNR) and the PO on the same row.
Features
- ALV list (sort, filter, subtotals)
- User-specific layout variants
- Double-click drill-down to the document Double-clicking the CO document opens KSB5; double-clicking the PO opens ME23N.
- Export to Excel
- Send the result by email Each cost center owner can receive their own list at month end.
Authorization objects
- K_CSKSAuthorization for cost center master data and line items
- K_CCACost center accounting transaction authorization
Frequently asked questions
Does seeing the employee name need extra authorization?
Yes. The employee name is HR data; reading PA0001 requires personnel administration display authorization. Without it the column stays empty and only the personnel number is visible.
Are items from assessments and distributions listed too?
Yes, secondary cost items are in COEP as well, so they are listed; for those items the sending cost center is shown instead of a vendor.
Can commitments be seen as well?
This report covers actual items. For open PO commitments, use the plan/actual/commitment report, or add them as an extra view.
Related reports
Cost Center Plan vs Actual with Commitments Report
A custom ALV report that shows plan, actual and open purchasing commitments per cost center and cost element on one row, and calculates the remaining …
Profit Center Plan vs Actual Revenue and Cost Report
A custom ALV report that compares plan and actual amounts by profit center and account for the period and year to date, and gives the variance as …
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.