Financial Statements F.01 for S/4 HANA

[JAPAN2024]

Dear SAP Experts,

I would like to get the F.01 data by Excel.

My boss told me that need to do copy and paste from the SAP Screen. Is this true?

Is there any other good way to get the excel data by SAP S/4 HANA?

Thank you so much in advance for your help.

Best regards,

[JAPAN2024 · Accepted solution]

Dear All,

I got the way and sharing here for the person who has the same question like me and myself as note.

Step1:

Step2:

Step3:

Open the Excel as new document and open the file which is download at Step2 as below excel menu.

Step4:

Data->Data get from "Text or CSV"

"Open" the text file which you download by Step 2 and "Import" them " Read".

Step5:

You can get the statement as query data, so change the normal data if need it.

Table design -> Change the standard Cell 

I hope this help to someone who wanted to know this way.

Best regards,