Enterprise Resource Planning Blogs by Members
Gain new perspectives and knowledge about enterprise resource planning in blog posts from community members. Share your own comments and ERP insights today!
cancel
Showing results for 
Search instead for 
Did you mean: 
João_FI_FIN-CS
Active Contributor

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

3 Comments
Labels in this area