Skip to Content
Former Member
Aug 30, 2006 at 04:50 PM

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.