Reply from LCC352 on Apr 7 at 7:33 PM You can also build a simple ABAP query based on the logical database BRM (document database). Query automatically creates the ALV grid for you which would be easily downloaded.
Just make sure that a month of data isn't going to be more than Excel can handle. The last company I worked for had over a million rows a month.
Lou
| | | ---------------Original Message---------------
From: clangkamp
Sent: Tuesday, March 24, 2015 2:41 AM
Subject: Journal Line Item Extract (S_ALR_87012347) Just Excel Lines, No Formatting
Part of the accounting process is to look at the Trial Balance (generated by F.01), perform adjustments and then upload the result into the company consolidation tool.
In order to check items one always needs to go back to SAP into the accounts.
Theoretically, for a medium sized company, it should be possible just to download all the journals posted in a period and then do a sumifs() total to get from a list of all journals to the actual trial balance. (i.e. year end trial balance + Sumifs on a large excel spreadsheet).
The Journal Line items kind of has the data, but not quite, no Line texts, and the formatting is horrendous. Is it possible to download a list of all journal lines posted in a period (i.e. [17,7,40,50,], [Cur], [Date Posted], [Amt Loc Cur], [Amt transaction cur], [Text], ...
Simple Excel dump?
Any suggestions? |
| Reply to this email to post your response. __.____._ | In the Spotlight Become a blogger at Toolbox.com and share your expertise with the community. Start today.   _.____.__ |
