Icon

SAP Controlling - Cost Centers Actual Line Items (T-code KSB1)

<p><strong>SAP Controlling - Cost Centers: Actual Line Items (T-code KSB1)</strong></p><p>SAP T-code KSB1 (Cost Centers: Actual Line Items, report RKAEP000) returns the actual cost line items posted to cost centers based on the selection criteria you enter. This workflow from DVW Analytics extracts the KSB1 line items into KNIME, cleans the SAP amounts into real numbers, and explores them with an interactive bar chart and a filterable table.</p><p>Prerequisites: the DVW KNIME Connector for SAP.</p><p>To see this workflow in action, click the Workflow Demonstration link under External Resources.</p><p>This workflow requires the DVW KNIME Connector for SAP. For more details and to request a trial, visit us at www.dvwanalytics.com</p>

URL: Workflow Demonstration https://www.youtube.com/@dvwanalytics
URL: DVW KNIME Connector for SAP https://www.dvwanalytics.com/knime-connector-for-sap.html?utm_source=knime-gallery&utm_medium=partner&utm_campaign=knime-connector&utm_content=connector-page
URL: Start a free trial https://www.dvwanalytics.com/knime-connector-for-sap.html?utm_source=knime-gallery&utm_medium=partner&utm_campaign=knime-connector&utm_content=trial-signup#dvw-trial-signup

SAP Controlling

Cost Centers: Actual Line Items (T-code KSB1)

This workflow from DVW Analytics extracts cost center actual line items from SAP (T-code KSB1) into KNIME, cleans the SAP amounts into real numbers, and shows an interactive bar chart and a filterable table. Excel output is included as a take-away.

Prerequisites: the DVW KNIME Connector for SAP. To watch it in action, use the Workflow Demonstration link under External Resources.

Request a free trial at www.dvwanalytics.com

1 Extract from SAP

The SAP Report node runs T-code KSB1 (report RKAEP000) and pulls the cost center actual line items into KNIME.

2 Convert SAP amounts to true numbers

SAP returns amounts as text with a trailing minus, e.g. 11,350.94-. String Manipulation removes the thousands separator and moves the minus to the front; String to Number then casts it to a real number.

3 Explore in KNIME

The component shows an interactive bar chart and a filterable line-item table. Right-click it and choose Open view.

4 Export to Excel

The same cleaned data is also written to an .xlsx file as a take-away.

Component
SAP Report
String Manipulation
String to Number
Excel Writer

Nodes

Extensions

Links

Download

To use this workflow in KNIME, download it from the below URL and open it in KNIME:

Download Workflow
Created by: TusharKale
Created at: 2022-02-17
On NodePit since: 2026-07-02
Last update: 2026-07-02
Created with KNIME version: v5.11.1
Tags: SAPDVW AnalyticsControllingCost Center AccountingKSB1

Deploy, schedule, execute, and monitor your KNIME workflows locally, in the cloud or on-premises – with our brand new NodePit Runner.

Try NodePit Runner!