Icon

SAP General Ledger - GL Account Line Item Display T-code FBL3N

<p><strong>SAP General Ledger - GL Account Line Item Display (T-code FBL3N)</strong></p><p>SAP T-code FBL3N (Display General Ledger Line Items) returns a list of accounting document items based on the selection criteria you enter. This workflow from DVW Analytics extracts FBL3N data into KNIME, converts the SAP amounts to true numbers, and explores the result with an interactive bar chart and a filterable line-item 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/watch?v=5vTA_wBEugk
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 General Ledger

GL Account Line Item Display (T-code FBL3N)

This workflow from DVW Analytics extracts FBL3N line items from SAP into KNIME, converts the SAP amounts to true numbers, then totals them by GL account 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 FBL3N (report RFITEMGL) and pulls the GL 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
Excel Writer
SAP Report
String Manipulation
String to Number

Nodes

Extensions

Links