How to use the transaction code SE16h to quickly determine the number of FI Documents for each Company Code in your system.
It is often necessary to figure out the scope of Financial Data in the system for each individual company code. There is a function in transaction code SE16h which does allow you to check the number of entries in the BKPF system for each company code.
This article is intended to help users to quickly find out the number of BKPF entries (representative of each individual Financial Document) in a system for a particular company code. It is of course also possible to use the function described below to find the equivalent number of entries for fiscal year, document type etc.
Often while checking the number of entries in a system, it used to be necessary to check each company code in SE16 manually which was often time consuming. Sometimes you might see that T001 has 200 or more entries for the different company codes, but only 20 of these, for example, are active with real FI documents posted in table BKPF. The function described in this wiki helps to quickly get the scope of active company codes in any system using transaction code SE16h.
Section 1 - Checking Number of Entries in Company Code
To do this, first access transaction code SE16h if available in your system. You will see the following selection screen:
Now enter the table you wish to analyse, which in our case is the Financial Accounting Document Header table BKPF:
Now you need to select the 'Group' checkbox on the Company code row to view the number of entries for each individual Company code entry on the table by pressing F8 (execute):
...the output shows the total number of entries for each Company code in the system:
...as you can see, it is now possible to quickly determine which company codes are the largest, which are the smallest, and which company codes are no longer used actively in FI.
Section 2 - Checking Number of Entries in other fields
This very useful function can also be used for any other field in BKPF or any other table: for example in Fiscal Year:
...the output then gives the breakdown of the number of Financial Documents in each fiscal year for all entries on the BKPF table:
Related SAP Notes/KBAs
SAP KBA 1946896 : How to quickly use the transaction code SE16h to determine the number of entries for each Company Code in your system