# Cash Flow Planning Entry and Weekly Cash Flow Table Program

> 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.

- Type: Program, Custom development, Mass upload
- Module: FI
- Estimated effort: M (6–9 working days)
- Last updated: 2026-11-17
- URL: https://nekuhub.com/en/programs/cash-flow-planning-entry-and-cash-flow-table/


## 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.

### Closest standard alternatives

- S_ALR_87012078: Gives a due date analysis of vendor open items; no combined table with bank balance and planned items.
- FBL5N: Lists customer open items with due dates; does not produce a cash flow table.

## Tables used

| Table | Role | Access | Join | System |
|---|---|---|---|---|
| FDES | Memo records of planned receipts and payments | Write | - | ECC + S/4 |
| T012K | Bank accounts and their G/L accounts (opening balance) | Read | - | ECC + S/4 |
| FAGLFLEXT | Balance of the bank G/L accounts | Read | FAGLFLEXT-RACCT = T012K-HKONT AND FAGLFLEXT-RBUKRS = T012K-BUKRS | ECC + S/4 |
| BSID | Expected receipts: customer open items and due dates | Read | - | ECC + S/4 |
| BSIK | Expected payments: vendor open items and due dates | Read | - | ECC + S/4 |

## BAPIs and functions used

- CONVERT_TO_LOCAL_CURRENCY: Converts foreign currency items into the table currency

## Selection screen parameters

| Parameter | Description | Type | Reference field | Required |
|---|---|---|---|---|
| S_BUKRS | Company code | Range / multiple | FDES-BUKRS | Yes |
| R_ACTN | Action: upload planned items or cash flow table | Radio button | - | No |
| P_FILE | Plan file (for upload) | Single value | - | No |
| P_START | Table start date | Single value | - | Yes |
| R_BUCKT | Period: week or month | Radio button | - | No |
| P_DELAY | Shift receipts by the customer's average delay | Checkbox | - | No |
| P_TEST | Test mode (without writing memo records) | Checkbox | - | No |

## Input file columns

| Column | Target field | Required |
|---|---|---|
| Company code | FDES-BUKRS | Yes |
| Planning date | FDES-DATUM | Yes |
| Planning level | FDES-EBENE | Yes |
| Bank account / planning group | FDES-BNKKO | No |
| Amount (payments negative) | FDES-WRSHB | Yes |
| Currency | FDES-DISPW | Yes |
| Text | FDES-SGTXT | No |

## Result list columns

| Column | Source |
|---|---|
| Row group | Calculated: Opening balance, customer receipts, vendor payments or planning level |
| Week 47 | Calculated: Total of amounts falling in the week |
| Week 48 | Calculated: Total of amounts falling in the week |
| Week 49 | Calculated: Total of amounts falling in the week |
| Week 50 | Calculated: Total of amounts falling in the week |
| Total | Calculated: Row total over all periods |

## How does the program work?

1. 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.
2. 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.
3. For the cash flow table, the opening balance comes from the G/L balance of the bank accounts (T012K-HKONT with FAGLFLEXT).
4. 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.
5. 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.
6. The table is given in ALV and Excel; periods that fall below zero are highlighted.

## Authorization objects

- F_FDES_BUK: Authorization to create and change memo records in the company code
- F_KNA1_BUK: Authorization to display customer open items
- F_LFA1_BUK: Authorization 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.

---
Let us build this program for your system: https://nekuhub.com/en/request-a-quote/?report=fi-cash-flow-entry
