Skip to Content
0
Former Member
Nov 30, 2011 at 03:49 PM

Query of GL line items along with "the other side of the JEs"

433 Views

Hello All,

I am trying to create an ABAP program or SAP query that would allow me to create an output of all line items posted to a general ledger account for a particular fiscal year(s) along with the other side the journal entry.

Said another way, I want all documents posted to a general ledger account along with the rest of the line items included with those journal entry.

For example, if I wanted to do this for Bad Debt Expense (P&L acct), I would like to see all those bad debt write off postings that were (credit Trade AR and Debit Bad debt Expense) vs. adjusting the bad debt reserve or any other posting in there.

Rather than looking at each transaction individually, I think this query would allow me to see the big picture of all posting to a particular account.

Any help is appreciated.