CO Report Custom development ALV report

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

  • KSB1 Cost Centers: Actual Line Items. Lists cost center actual line items; vendor and employee names are not on the row.
  • KSB5 Controlling Documents: Actual. Displays individual CO documents; gives no list by cost center.

Tables used

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

TableRoleJoinSystem
COEPCO Object: Line Items (by Period)CO actual line items: object, cost element, amount, PO, employee (driving table)—ECC + S/4
COBKCO Object: Document HeaderCO document header: posting date, user, reference documentCOBK-KOKRS = COEP-KOKRS AND COBK-BELNR = COEP-BELNRECC + S/4
CSKSCost Center Master RecordCost center object number and ownerCSKS-OBJNR = COEP-OBJNR AND CSKS-KOKRS = COEP-KOKRSECC + S/4
CSKTCost Center TextsCost center textCSKT-KOKRS = CSKS-KOKRS AND CSKT-KOSTL = CSKS-KOSTL AND CSKT-DATBI = CSKS-DATBI AND CSKT-SPRAS = SY-LANGUECC + S/4
EKKOPurchasing Document HeaderVendor on the purchase orderEKKO-EBELN = COEP-EBELNECC + S/4
BSEGAccounting Document SegmentVendor line for FI invoices without a POBSEG-BELNR = COBK-REFBN AND BSEG-GJAHR = COBK-REFGJ AND BSEG-KOART = 'K'ECC + S/4
LFA1Vendor Master (General Section)Vendor nameLFA1-LIFNR = EKKO-LIFNR veya BSEG-LIFNRECC + S/4
PA0001HR Master Record: Infotype 0001 (Organizational Assignment)Employee name (organizational assignment)PA0001-PERNR = COEP-PERNR AND PA0001-ENDDA >= COBK-BUDATECC + S/4
ACDOCAUniversal Journal Entry Line ItemsActual items with vendor and PO on S/4HANAKOKRS = COEP-KOKRS AND RCNTR = CSKS-KOSTLS/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

ParameterDescriptionTypeReference fieldRequiredExample
P_KOKRSControlling areaSingle valueCOEP-KOKRSYes1000
S_KOSTLCost centerRange / multipleCSKS-KOSTLYes4110
S_KSTARCost elementRange / multipleCOEP-KSTARNo7700000000
P_GJAHRFiscal yearSingle valueCOEP-GJAHRYes2026
S_PERIOPeriodRange / multipleCOEP-PERIONo001 – 010
S_LIFNRVendorRange / multipleEKKO-LIFNRNo100245
S_EBELNPurchase orderRange / multipleCOEP-EBELNNo4500012345

Output columns

#ColumnSource
1Cost centerCSKS-KOSTL
2Cost center textCSKT-KTEXT
3Cost elementCOEP-KSTAR
4PeriodCOEP-PERIO
5Posting dateCOBK-BUDAT
6CO documentCOEP-BELNR
7Reference documentCOBK-REFBN
8TextCOEP-SGTXT
9AmountCOEP-WKGBTR
10Purchase orderCOEP-EBELN
11PO itemCOEP-EBELP
12VendorCalculated EKKO-LIFNR; BSEG-LIFNR from the reference FI document when there is no PO
13Vendor nameLFA1-NAME1
14Personnel numberCOEP-PERNR
15Employee namePA0001-ENAME
16Entered byCOBK-USNAM

Sample output

Cost centerCost center textCost elementPeriodPosting dateCO documentReference documentTextAmountPurchase orderPO itemVendorVendor namePersonnel numberEmployee nameEntered by
4110Production maintenance770010000001010/06/20262000145215105602211Hydraulic oil purchase18,400450001234510100387Delta MetalAP_USER1
4110Production maintenance770020000001010/12/20262000146331900004410External repair service32,500100951Teknik Servis AtölyesiAP_USER2
9100General administration770030000001010/20/20262000147020000315520Travel expenses October6,85000001042Ayşe DemirHR_BATCH
9100General administration770040000001010/28/20262000147905105602388Office stationery4,210450001241120100245Atlas AmbalajAP_USER1
A view built with fictional sample data; not real system data.

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.

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

CO Report Custom ALV report

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 …

COSP · COSS · CSKS · CSKT

CO Report Custom ALV report

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 …

FAGLFLEXT · CEPC · CEPCT · SKAT

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: Cost Center Line Items with Vendor, Purchase Order and Employee Report