SAP Knowledge Base Article - Public

2830429 - Exporting STATUS Field to Excel

Symptom

The Status field is not exported when exporting to Excel from the Display Line Items in General Ledger app (ID F2217).

Environment

SAP S/4HANA Cloud

Cause

The status field is a generated UI icon column; the icon is generated based on the line item data in each row.
Hence this icon can't be exported.

Resolution

It's possible to export the columns “Open Item Management” and “Item cleared” because the icons are 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 , FI-FIO-GL-2CL , Fiori UI for General Ledger Accounting (Public Cloud) , How To

Product

SAP S/4HANA Cloud all versions