What is the quantity of fixed assets, normal documents, customers, vendors, GL accounts that there are in the client?
Hi Colleagues,
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.
JPA
Hi João,
These are all standard programs and standard transactions, can they be found in the standard SAP menu also? Can I find same information in SAP help or any OSS note?
What can be instead something of the added value is for example to give real business cases about when using these reports is beneficial for the client. Is it for system auditing or for calculation of any KPI values? And what can be those useful KPIs based on this information?
Thank you,
Paulo
Hi Paulo,
Firstly, thank you for you answer and your question. I'll explain my point of view:
1. No. These transaction can't be found it in the menu transactions. And in the menu transaction, you can't find programs. I don't know, but maybe for the transaction group FAIS, you can't find transactions codes in the standard menu;
2. And I did not found any related information in the OSS Notes;
3. I thinj the client has benefits using these tcodes, i.e to control what is the quantity of documents used in the company or document type in the period. Imagine that you create a special type of document to post in the special scenarios. You expect that have 5 documents per month. And some date when you run the report, you found 15 document with this document type. The triple that you expected. Of course that the audit area can or should use, but you can too.
4. When you run these reports, is diplayed some data that you or audit can control. I.e, GL accounts limit to create or to not exceed. This can be a KPI like anyone else. Will depends in how to use this information.
JPA
I agree with Paulo - without any "story" and business background it's just the documentation. One can easily go to SE93 (for transaction codes) or SE38/SE80 (for reports) and run a search by description.
Blogs are supposed to be about the experiences, not just the transaction lists. While I understand that someone might feel an urge to share information upon finding a useful transaction, but when there is more of a story to tell (e.g. what prompted you to search for these?), it's always more valuable to the community. I hope that you would consider this when working on the next blog.
Thank you.