number of transactions posted

Hi Friends,

Could you please provide an optimized select for this case.

No. of transactions posted: For each of the Company code & Posting date or fiscal year/ period combination, select all document numbers from BKPF table into an internal table. For each of the company code, GL Account no combination find out no. of distinct records in the BSEG table (or combination of BSIK, BSAK, BSID, BSAD, BSIS & BSAS tables) to get the No. of transactions posted.

If you need any more details for writing an optimized select, Please do let me know.

Thanks,

Prakash.