What is the quantity of fixed assets, normal documents, customers, vendors, GL accounts that there are in the client?
Through the transaction or program, you can discover the number of customers, vendors, GL accounts, assets or normal FI documents in a client, company, by period, chart of accounts, etc. Basically the program research the data master tables with company codes, chart of accounts and so on.
RFAUDI01 – Number of Customer Master Records – S_ALR_87101051
The screenshot above indicates the number of customers according the KNA1 table and KNB1 table per company code.
RFAUDI02 – Number of Vendor Master Records – S_ALR_87101052
The program above check all the vendos by LFA1 and/or can separate by company code.
RFAUDI03 – Number of G/L Master Records – S_ALR_87101049
The screenshot above indicates how many items there are in SKA1 table per chart of accounts. And below, indicates how many items there are in the SKB1 table per company in each chart of accounts. This is very useful when the client has many company codes assigned to a chart of accounts. There aren’t a option to select parameters.
RFAUDI04 – Number of Asset Master Records – S_ALR_87101050
Technically, the program check ANLH table. You do not have access to selection parameters like a research by company code.
RFAUDI07 – Number of Standard FI Documents – S_ALR_87101054 is shown below:
In this case, the program will check the BKPF table by company, ledger, type of document, period and year, but you can insert posting date to research in a specific period. Remeber that normal documents are all documents that aren’t special GL items, parked items or noted items.
Also, you can run these transactions in backgorund mode and get the list in the SM37.