Counting Posted docuemnt in FI based on Document Type

[Former Member]

Hello Team,

As a part of audit trail...I need to count all the posted FI documents based on document type and Company code. Table BKPF does not meet my requirement as it takes lot of time to count the documents and even not possible to get the break-up. is there any report / T.Code with with i can achieve my purpose.

Please reply.

[Former Member · Accepted solution]

I was looking for the report where i can get the result like below:-

Company code Document type   Year       No of posted document

xxx1                    sa                    2013     2000

xxx1                    kr                     2013     1900

XXX2                    sa                    2013     1500  

Do we have any standard report to get above result??

[former_member221213 · Accepted solution]

Hi,

1. Go to T-code TAANA and click on Start table analysis (F8).

2. Enter BKFP as table name and click the push button "Analysis variant". In the next popup,  click     on "Ad Hoc Variant" button.

3. Select the fields Company code, Fiscal year, Doc type and continue.

4. Select the new variant and continue.

5. Select the run in background option and proceed.

6. Click on Immediate and the save the job

7. Click on Job (F9) to see the job status

    Once job finish click on back

8. Double click on AD-HOC to see the results.

Regards

Rohidas Shinde

[Former Member · Accepted solution]

Thanks a lot Mr Shinde.

[former_member221213]

Hi,

Use transaction code FB03, Then click on document list (Shift + F8) as shown in below screen shot.

Then find the document as per your requirement.

Regards,

Rohidas Shinde

[Former Member]

Hi,

Please check if S_ALR_87012287 or S_ALR_87012289 reports fulfills your requirement.

Hope it helps,

Jay