SAP Knowledge Base Article - Public

2830429 - Exporting STATUS Field to Excel

Symptom

You are using the Display Line Items in General Ledger app and would like to export the data. Then you note that the STATUS field/column is not exported.

Environment

S/4HANA Cloud.

Cause

The status column is a generated UI icon column –> the icon gets generated, based on the data of the line item of the row.
So this generated icon is nothing which can be exported, because it is not part of the data which gets fetched from the backend.

Resolution

You can export the columns “Open Item Management” and “Item cleared”, because the icons are getting generated based on this information:

OIM equals SPACE -> no OIM -> posted icon
OIM equals X -> OIM -> cleared equals true -> cleared icon
OIM equals X -> OIM -> cleared equals false -> open icon

Keywords

status field,  Item cleared, Open Item Management, Display Line Items in General Ledger, excel, export , KBA , FI-FIO-GL , Fiori UI for General Ledger Accounting , How To

Product

SAP S/4HANA Cloud all versions