# Cost Center Line Items with Vendor, Purchase Order and Employee Report

> 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.

- Type: Report, Custom development, ALV report
- Module: CO
- Estimated effort: M (3–5 working days)
- Last updated: 2026-11-17
- URL: https://nekuhub.com/en/reports/cost-center-line-items-vendor-po-employee-report/


## 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.

### Closest standard alternatives

- KSB1: Lists cost center actual line items; vendor and employee names are not on the row.
- KSB5: Displays individual CO documents; gives no list by cost center.

## Tables used

| Table | Role | Access | Join | System |
|---|---|---|---|---|
| COEP | CO actual line items: object, cost element, amount, PO, employee (driving table) | Read | - | ECC + S/4 |
| COBK | CO document header: posting date, user, reference document | Read | COBK-KOKRS = COEP-KOKRS AND COBK-BELNR = COEP-BELNR | ECC + S/4 |
| CSKS | Cost center object number and owner | Read | CSKS-OBJNR = COEP-OBJNR AND CSKS-KOKRS = COEP-KOKRS | ECC + S/4 |
| CSKT | Cost center text | Read | CSKT-KOKRS = CSKS-KOKRS AND CSKT-KOSTL = CSKS-KOSTL AND CSKT-DATBI = CSKS-DATBI AND CSKT-SPRAS = SY-LANGU | ECC + S/4 |
| EKKO | Vendor on the purchase order | Read | EKKO-EBELN = COEP-EBELN | ECC + S/4 |
| BSEG | Vendor line for FI invoices without a PO | Read | BSEG-BELNR = COBK-REFBN AND BSEG-GJAHR = COBK-REFGJ AND BSEG-KOART = 'K' | ECC + S/4 |
| LFA1 | Vendor name | Read | LFA1-LIFNR = EKKO-LIFNR veya BSEG-LIFNR | ECC + S/4 |
| PA0001 | Employee name (organizational assignment) | Read | PA0001-PERNR = COEP-PERNR AND PA0001-ENDDA >= COBK-BUDAT | ECC + S/4 |
| ACDOCA | Actual items with vendor and PO on S/4HANA | Read | KOKRS = COEP-KOKRS AND RCNTR = CSKS-KOSTL | S/4HANA only |

## Selection screen parameters

| Parameter | Description | Type | Reference field | Required |
|---|---|---|---|---|
| P_KOKRS | Controlling area | Single value | COEP-KOKRS | Yes |
| S_KOSTL | Cost center | Range / multiple | CSKS-KOSTL | Yes |
| S_KSTAR | Cost element | Range / multiple | COEP-KSTAR | No |
| P_GJAHR | Fiscal year | Single value | COEP-GJAHR | Yes |
| S_PERIO | Period | Range / multiple | COEP-PERIO | No |
| S_LIFNR | Vendor | Range / multiple | EKKO-LIFNR | No |
| S_EBELN | Purchase order | Range / multiple | COEP-EBELN | No |

## Output columns

| Column | Source |
|---|---|
| Cost center | CSKS-KOSTL |
| Cost center text | CSKT-KTEXT |
| Cost element | COEP-KSTAR |
| Period | COEP-PERIO |
| Posting date | COBK-BUDAT |
| CO document | COEP-BELNR |
| Reference document | COBK-REFBN |
| Text | COEP-SGTXT |
| Amount | COEP-WKGBTR |
| Purchase order | COEP-EBELN |
| PO item | COEP-EBELP |
| Vendor | Calculated: EKKO-LIFNR; BSEG-LIFNR from the reference FI document when there is no PO |
| Vendor name | LFA1-NAME1 |
| Personnel number | COEP-PERNR |
| Employee name | PA0001-ENAME |
| Entered by | COBK-USNAM |

## How does the report work?

1. Object numbers (OBJNR) are taken from CSKS by controlling area and cost center selection; the text is added from CSKT.
2. Actual line items for those objects are read from COEP: WRTTP = 04, VERSN = 000, fiscal year and period range, cost element selection.
3. The document header is added from COBK: posting date, entered by, reference document (REFBN) and reference type (AWTYP).
4. 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.
5. 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.

## Authorization objects

- K_CSKS: Authorization for cost center master data and line items
- K_CCA: Cost 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.

---
Let us build this report for your system: https://nekuhub.com/en/request-a-quote/?report=co-cost-center-line-items-vendor-po
