Journal Entry Document List (Including Total Dr and Cr)

[Former Member]

Hi,

Is there are report that I can run to give me all journal entries for a specified period, including the following information: User, Company Code, Document No., Doc type, Reference, Document Header, doc date, posting date and dr. and cr. values? When I run TCode FB02 I get all the info except for the dr. and cr. values.

Regards,

Tracy

[Former Member]

Hi,

Try this report and see if it suits your requirement.

S_ALR_87012291 - Line Item Journal

Regards,

Mike

[Former Member]

It's an old post, yet very useful! thanks for sharing

[sanju_ms]

Hi,

try in FB03 T.code

And in change layout you can include above mentioned fields on it

But you cannot bring the debit & credit amount fields

regards,

Sanju M S

[former_member219217]

Hi,

Pls check Tcode S_ALR_87012296 if it fulfills your requirement.

Regards

[Former Member]

Hi Tracy,

The below report can get your requirement:

S_ALR_87012347 - Line Items Extract

Julie

[former_member1272049]

Great Answer, Thanks fr your help

[sridevi_p]

Hi,

Try to build your own query with BRF logical database/

Regards,

sridevi

[Former Member]

Dear,

Please use the table BSEG, where you give document type and period. Remember it is a primary table if your time period is vast then i dont suggest you to use this. You can make a query with table BKPF and BSIS to get the required details.

Transaction code : SE16 or SE16N and give the above tables and check the data, before you make a query.