Accounting Entries

[Former Member]

Can someone tell me in which table can i find the accounting entries file? i have to give a report of ALL accounting entries which have been passed during a period?

Is there any standard SAP report which displays the same?

Thanks in advance

[Former Member]

Hi,

I guess the document journal report (RFBELJ10) from the SAP standard can help you on this.

This report contain any document/ journal and you can also restrict the selection by posting date.

regards,

Halim

[Former Member]

BSEG is the Account Segment Table. This will have all the account entries resulted from all SAP modules. It's header table is BKPF.

BSEG holds very large amount of data. So SAP has created some views for this table to retrive the data based on Vendor, customer, G/L. Also check whether you need Open or closed account entries.

[RichHeilman]

The major accounting document tables are ....

BSAD	Accounting: Secondary Index for Customers (Cleared Items)
BSAK	Accounting: Secondary Index for Vendors (Cleared Items)
BSAS	Accounting: Secondary Index for G/L Accounts (Cleared Items)
BSBM	Document Valuation Fields
BSBW	Document Valuation Fields
BSEC	One-Time Account Data Document Segment
BSED	Bill of Exchange Fields Document Segment
BSEG	Accounting Document Segment
BSES	Document Control Data
BSET	Tax Data Document Segment
BSID	Accounting: Secondary Index for Customers
BSIK	Accounting: Secondary Index for Vendors
BSIM	Secondary Index, Documents for Material
BSIP	Index for Vendor Validation of Double Documents
BSIS	Accounting: Secondary Index for G/L Accounts

Regards,

Rich Heilman