Reply: 1

Auto translated

Create daily balance sheet in SAP S/4HANA, but how?

Hello,

you no longer need a day ledger in SAP S/4HANA. And it has been since 2018!

A daily ledger would store the data identically to the associated monthly ledger. Reprting has to add up the line items either way. Therefore, a daily ledger no longer makes sense. It is best not to introduce it at all or to deactivate it! It is unnecessary data volume!

FI-SL Ledger would be a very old way of mapping a daily ledger in SAP S/4HANA. See above, not necessary and there will be no Fiori UI's for FI-SL, which is another reason not to do this.

In SAP S/4HANA you should only use the report RFBILA00N. This currently enables balance sheets per key date, but falls back to the respective period. The background to this is that the RFBILAs read the data like the former FAGLFLEXT table.

How can you create a daily balance sheet in SAP S/4HANA?

There are various options depending on the requirements.

  1. Fiori App Trail Balance (Fiori ID W0996), this can output the calendar days (regardless of whether there are documents on the calendar day or not). Periods are of course not possible, as you no longer have this. But calendar days should be easier to use than periods.
  2. Balance sheet / P&L app (Fiori ID F0708 or W0161, W0177 can be tested), here you can enter a key date or even a timestamp and thus create the reporting.
  3. Display of GL line items Fiori App ID F2217 here you can, for example, sort by posting day (only days with posted receipts appear)
  4. ADB Trail Balance (Fiori ID W0166) with average balances based on the monthly ledger.

This will no longer work in the SAP GUI itself and will no longer be possible due to the SAP Fiori strategy.

Regards

Moneyfox

You must be logged in to post a reply.

Login now

1 Answers

  • BETA
    ChatBot
    Automated answer
    This reply was automagically generated by our Espressi A.I. Think of it as a one-off attempt to instantly solve your problem. It will not respond to further replies.

    Hello Moneyfox, thank you for your detailed question and explanations. It is indeed correct that in SAP S/4HANA the use of daily ledgers is largely obsolete and no longer supported. Instead, SAP S/4HANA focuses on monthly ledgers and the use of the RFBILA00N report. However, creating a daily balance sheet in SAP S/4HANA is still possible and is mainly achieved via Fiori Apps. Here are the options you mentioned: - Fiori App Trail Balance (ID W0996) can output the calendar days - The Balance Sheet / P&L App (ID F0708 or W0161, W0177 for review) allows you to enter a specific cut-off date or timestamp for reporting - The Fiori App for displaying GL line items (ID F2217) can be used to post by posting days.

    • ADB Trail Balance (ID W0166) enables average balances based on the monthly ledger. You are absolutely right that these functions in the SAP GUI are obsolete and will no longer be supported as SAP has focused its strategy on Fiori. Yours sincerely, Your AI Assistant

    Need more help from our chatbot? Click here and visit our AI SAP Helper on the SAP learning platform et.training.1

    1. log in with your Espresso Tutorials account. Digital subscription or trial access required.