Cash Flow Planning Entry and Weekly Cash Flow Table Program
Short answer: A custom program that enters expected receipts and payments with no accounting document yet (taxes, salaries, loan installments, capital expenditure, a large customer collection) from Excel or on screen as Cash Management memo records, and combines them with bank balances and customer and vendor open items into a weekly or monthly cash flow table.
- Estimated effort
- M · 6–9 working days
- System
- ECC and S/4HANA
- Tables
- 5
- Scope
- Global
- Built by
- NeKuDos Teknoloji
- Last updated
Why is the standard not enough?
In the standard, memo records are entered one by one with FF63 and the cash position is displayed with FF7A/FF7B; both need Cash Management settings (planning levels, groups, account assignments) to be set up and maintained. There is no bulk memo record entry from Excel, and the S_ALR_87012078 and FBL5N due date analyses only show open items, without a combined weekly table of bank balances and planned items. So cash flow is mostly put together in a spreadsheet.
Who uses it? Treasury and finance teams, finance managers who plan cash flow and teams preparing CFO reporting.
Closest standard alternatives
- S_ALR_87012078 Due Date Analysis for Open Items (Vendors). Gives a due date analysis of vendor open items; no combined table with bank balance and planned items.
- FBL5N Customer Line Items. Lists customer open items with due dates; does not produce a cash flow table.
Tables used
The tables the program reads and updates. ECC and S/4HANA differences are marked separately.
| Table | Role | Access | System |
|---|---|---|---|
| FDESCash Management and Forecast: Memo Records | Memo records of planned receipts and payments | Write | ECC + S/4 |
| T012KHouse Bank Accounts | Bank accounts and their G/L accounts (opening balance) | Read | ECC + S/4 |
| FAGLFLEXTNew General Ledger: Totals | Balance of the bank G/L accounts | Read | ECC + S/4 |
| BSIDCustomer Open Items | Expected receipts: customer open items and due dates | Read | ECC + S/4 |
| BSIKVendor Open Items | Expected payments: vendor open items and due dates | Read | ECC + S/4 |
S/4HANA notes
- T012K: In S/4HANA reads of T012K go through the compatibility view V_T012K_BAM; bank accounts are maintained in Bank Account Management (BAM).
- FAGLFLEXT → ACDOCA: In S/4HANA totals tables are no longer updated separately; FAGLFLEXT is read as a compatibility view that aggregates ACDOCA line items.
- BSID → I_OperationalAcctgDocItem: In S/4HANA BSID is no longer filled as a separate index table; reads work through a compatibility view of the same name. For new developments the I_OperationalAcctgDocItem CDS view is recommended.
- BSIK: In S/4HANA BSIK is no longer filled as a separate index table; reads work through a compatibility view. For new developments the I_OperationalAcctgDocItem CDS view is recommended.
BAPIs and functions used
- CONVERT_TO_LOCAL_CURRENCYTranslate Foreign Currency Amount to Local Currency. Converts foreign currency items into the table currency
Selection screen parameters
| Parameter | Description | Type | Reference field | Required | Example |
|---|---|---|---|---|---|
| S_BUKRS | Company code | Range / multiple | FDES-BUKRS | Yes | 1000 |
| R_ACTN | Action: upload planned items or cash flow table | Radio button | — | No | Nakit akış tablosu |
| P_FILE | Plan file (for upload) | Single value | — | No | C:\temp\nakit_plani.xlsx |
| P_START | Table start date | Single value | — | Yes | 17.11.2026 |
| R_BUCKT | Period: week or month | Radio button | — | No | Hafta |
| P_DELAY | Shift receipts by the customer's average delay | Checkbox | — | No | X |
| P_TEST | Test mode (without writing memo records) | Checkbox | — | No | X |
Input file columns
The columns of the upload template and the SAP fields they are written to. Columns with an asterisk are mandatory.
| # | Column | Target field | Required |
|---|---|---|---|
| 1 | Company code | FDES-BUKRS | Yes |
| 2 | Planning date | FDES-DATUM | Yes |
| 3 | Planning level | FDES-EBENE | Yes |
| 4 | Bank account / planning group | FDES-BNKKO | No |
| 5 | Amount (payments negative) | FDES-WRSHB | Yes |
| 6 | Currency | FDES-DISPW | Yes |
| 7 | Text | FDES-SGTXT | No |
Sample upload file
| 1 | Company code * | Planning date * | Planning level * | Bank account / planning group | Amount (payments negative) * | Currency * | Text |
|---|---|---|---|---|---|---|---|
| 2 | 1000 | 11/26/2026 | VG | 1020000 | -1,450,000 | TRY | October VAT payment |
| 3 | 1000 | 11/30/2026 | MA | 1020000 | -2,860,000 | TRY | November salaries |
| 4 | 1000 | 12/05/2026 | YT | 1020100 | -85,000 | EUR | Machine down payment |
| 5 | 1000 | 12/10/2026 | TH | 1020000 | 3,200,000 | TRY | Expected project collection |
Result list columns
| # | Column | Source |
|---|---|---|
| 1 | Row group | Calculated Opening balance, customer receipts, vendor payments or planning level |
| 2 | Week 47 | Calculated Total of amounts falling in the week |
| 3 | Week 48 | Calculated Total of amounts falling in the week |
| 4 | Week 49 | Calculated Total of amounts falling in the week |
| 5 | Week 50 | Calculated Total of amounts falling in the week |
| 6 | Total | Calculated Row total over all periods |
Sample result list
| Row group | Week 47 | Week 48 | Week 49 | Week 50 | Total |
|---|---|---|---|---|---|
| Opening bank balance | 4,292,200 | 0 | 0 | 0 | 4,292,200 |
| Customer receipts | 1,860,000 | 2,410,000 | 1,975,000 | 2,240,000 | 8,485,000 |
| Vendor payments | -1,520,000 | -2,105,000 | -1,690,000 | -1,880,000 | -7,195,000 |
| Taxes and salaries (plan) | 0 | -4,310,000 | 0 | 0 | -4,310,000 |
| Expected project collection (plan) | 0 | 0 | 0 | 3,200,000 | 3,200,000 |
| Cumulative cash | 4,632,200 | 627,200 | 912,200 | 4,472,200 | 4,472,200 |
How does the program work?
- Planned items are uploaded from an Excel template or entered on screen: company code, planning date, planning level (taxes, salaries, loans, capital expenditure and so on), amount, currency and text. Rows are checked and listed in test mode.
- Approved rows are written to FDES as memo records with an expiration date (AVDAT), so planned items in the past drop out of the table automatically.
- For the cash flow table, the opening balance comes from the G/L balance of the bank accounts (T012K-HKONT with FAGLFLEXT).
- Expected receipts are read from BSID and expected payments from BSIK by net due date; if the customer’s average delay is selected, the collection date is shifted by it.
- Memo records, open items and bank balance are distributed to week or month columns; rows are grouped by planning level and a cumulative cash balance is calculated for each period.
- The table is given in ALV and Excel; periods that fall below zero are highlighted.
Performance notes
Open items are read by company code and due date range; the table usually covers 13 weeks or 12 months. On large systems open item totals are grouped by due date bucket in the database.
Features
- Export to Excel Planned items are uploaded in bulk from an Excel template; the table is exported to Excel.
- Test mode (check without posting)
- Download failed lines as a separate file Rows with errors are written to a separate file with their message.
- ALV list (sort, filter, subtotals)
- Double-click drill-down to the document A cell drills down to the items falling in that week.
Authorization objects
- F_FDES_BUKAuthorization to create and change memo records in the company code
- F_KNA1_BUKAuthorization to display customer open items
- F_LFA1_BUKAuthorization to display vendor open items
Frequently asked questions
Does it work if Cash Management is not set up?
The cash flow table reads open items and bank balances directly, so it works even if Cash Management is not active. Only a few planning levels are defined once so that planned items can be stored as memo records.
How does an actual item replace the planned one?
The planned record can be deleted by hand when the actual document is created, or it drops out of the table once its expiration date has passed. For regular items such as loan installments that come from a source program, the planned record is closed together with the payment posting.
Can it be used on S/4HANA?
Yes. Memo records are also used in S/4HANA Cash Management and appear in the cash position apps; the program writes planned items the same way.
Related reports
Unmatched Bank Statement Items on Clearing Accounts Report
A custom ALV report that lists electronic or manual bank statement items that were never posted, or were posted to a bank clearing account and are …
Customer Receivables Aging Report
A custom ALV report that ages customer open items by net due date and shows down payments received and other special G/L items in the same list. …
Vendor Open Items Aging Report
A custom ALV report that ages vendor open items by net due date and spreads the amounts into not-due, 0–30, 31–60, 61–90 and 90+ day buckets. The …
Let us build this program for your system
Briefly describe your system and expectations. We will clarify the scope and come back with an effort and price quote.