← Report Library

SAP FI Document Journal / Audit 360

FICO-21FI / CORuns on the  Live Query Engine

Compact FI journal with entry-vs-posting date, reversal chain and partner/account enrichment.

28 columns 5 SAP tables 4 joins prebuilt ECC & S/4HANA
FI Document Journal / Audit 360Excel Add-in · FICO-21SAMPLE PREVIEW
FILTERS COMPANY CODE1000 DATE RANGE2026-01-01 → 2026-07-26 MAX ROWS500
Company CodeDocument NumberFiscal YearDocument TypeDocument DatePosting DateEntry DateEntered By
100019000023002026NORM2026-01-122026-02-052026-01-2601
200019000025112026SA2026-06-162026-06-262026-01-0903
100019000027222026KR2026-03-172026-04-032026-01-1802
100019000029332026ZOR2026-01-132026-01-092026-04-2801
200019000031442026NB2026-04-102026-06-122026-01-0810
100019000033552026KR2026-01-012026-05-192026-01-2802
200019000035662026SA2026-06-192026-02-102026-02-27Z1
+20 more columns in the full report
$7.1M
Total value in scope
9,210
Rows fetched
214
Distinct entities

Top 5 by value

Brightway Components$2.51M
Atlas Supplies Ltd$1.94M
Meridian Parts Co$1.5M
Northgate Industrial$1.04M
Vector Freight GmbH$0.66M

Split by company code

$7.1MTOTAL
CoCd 10002.8M
CoCd 20002.0M
CoCd 11001.4M
CoCd 21000.9M
Illustrative sample data — fictional values, not connected to any SAP system. Run it in PostNow to see your own data.
Read-only Live & refreshable AI-customizable Row-limit guarded Excel-native ECC + S/4HANA
PostNow Live Query Engine

What happens on every run.

Session attach

Connects read-only inside your own SAP session — your business data is never changed.

Selection push-down

Your filters run inside SAP, so only matching rows ever travel the wire.

Join resolution

The engine links every source table on the correct key fields, automatically.

Text enrichment

Raw SAP codes are resolved into readable names and descriptions on the way out.

Excel delivery

Formatted rows land in your sheet, guarded by a max-row limit for fast first runs.

Refresh on demand

The report keeps its selection — one click pulls the latest data, any time.

SAP tables joined

BKPFBSEGT003TSKATT001

Columns delivered

28

Pre-selected key fields with text lookups resolved — customize freely.

Live Query Engine

Key relationships resolved automatically. Joins, text lookups and filter push-down are engineered by SAP solution architects — zero ABAP on your side.

Run FI Document Journal / Audit 360 on your own SAP system.

Excel add-in, read-only in your own SAP session, live data in minutes. ECC & S/4HANA.

Start free trial Book a live demo
About this report

The SAP FI Document Journal / Audit 360 report, explained.

What this report answers

The FI Document Journal / Audit 360 report gives finance and controlling teams one readable answer to a question that normally takes several screens: compact FI journal with entry-vs-posting date, reversal chain and partner/account enrichment. Rather than working through transactions one object at a time, you get 28 pre-selected columns side by side — keys, descriptions and organizational context in one place, ready to filter, pivot and share.

How teams pull this data today

The usual route to this data is FBL3N or FAGLL03 for the on-screen view, followed by SE16 downloads of BKPF, BSEG, T003T stitched together in Excel. Each export is a snapshot: text fields arrive as codes, the joins are rebuilt by hand, and by the time the workbook reconciles, the numbers are already a day old. Multiply that by every month-end or every expediting run, and the report becomes a job of its own.

What PostNow changes

In PostNow the report ships ready to run. The 5 underlying tables (BKPF, BSEG, T003T, SKAT, T001) are already joined on the correct key fields, code values are resolved into plain-language texts, and results land directly in Excel. Every run is read-only inside your own SAP session — the engine reads data, it never changes it. Refresh whenever you need a current version, tighten the filters, or use the report as a starting point and adjust columns in the visual builder. It behaves identically on SAP ECC and S/4HANA.

Frequently asked questions

Which SAP tables does the FI Document Journal / Audit 360 report read?

It joins 5 tables — BKPF, BSEG, T003T, SKAT, T001 — on their standard key fields. Text and check tables are resolved automatically, so the output shows readable names and descriptions instead of raw codes, and the 28 delivered columns can be extended in the visual builder if you need more.

How do I get fi document journal / audit 360 data from SAP into Excel without ABAP?

Transactions like FBL3N and FAGLL03 show the data on screen, but a clean Excel extract from them means manual exports and re-formatting every time. PostNow reads the same tables through standard interfaces — no ABAP, no transports. You pick the report in the Excel add-in, set filters such as company code and date range, and the joined result is written straight into your sheet. Every run is read-only and happens inside your own SAP session — nothing is ever written back.

Can I filter the report by company code, date range or other criteria?

Yes. Every report has selection filters with SAP value help, so you can narrow by company code, posting or document dates, plants, accounts and more before anything is fetched. A max-rows guard keeps first runs fast, and once the selection looks right you can widen it and refresh — the report remembers your filters.