Skip to Content
author's profile photo Former Member
Former Member

Issue in Special Purpose Ledger


Im working on a Regionwise cost center report(already done by someone else) using Special purpose Ledger.

Though the system is capturing foreign currecy amounts in summary tables, the report is not picking the foreign currency documents.Tried adding trasaction currency [TSL] and local currency [HSL] fields to the summary table. But still the report is not showing the foreign currency amounts.

Also the report is not showing the A/Cs with zero balances.

Thanx in advance.



Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

1 Answer

  • Posted on Aug 24, 2007 at 12:16 PM


    A/Cs with zero balances are not shown - that could have 2 reasons. Either ths is suppressed in report options, which you can change easily (remove filter). Or there is no any database record selected, in this case, you cannot do anything. (Unlike in RFBILA00, there is no "Accounts with zero balance" flag in FI-SL reports. This is because RFBILA00 is reading the master data, regardless if there was any movement on that account or not. But the FI-SL database is just a bag of transactional data. If a particular account was not posted at all, no 0 value row will be displayed, never.

    Why TSL column is empty (I assume you have added new columns to the report and not new fields to the summary table as you have mentioned). This can be tricky. It could be that the total value in TSL is zero? What you can do: pick a particular cost center / company code / period where you are sure that there must be a TSL value. Then go to SE16 and display the corresponding database records from your summary table ZZ*T. Check the TSL field for the chosen period. Do you have an amount there? If you do, the report definition may have a problem.

    Hope that helps, points welcome 😊


    Add a comment
    10|10000 characters needed characters exceeded

    • Hi,

      if you have special ledger in use, why you do not include the field cost center? Then it would be a snap to get your report. You can even add this new field now, unless you have not archived your documents yet, you can add the new field and rebuild the database. This seems like a big deal, but on mid term, this is how it will work.

      But I understand you have forgotten to include the CC field in your FI-SL table group, so you do not have the cost centre information available. OK.

      So you try another reporting tool, SAP query. How the infoset behind the query is defined? It is a table join? What tables? Is it a logical database? The fields (including the amount fields) shown by the query are determined by the Infoset. So until you do not provide information about the data source (table names), no one will be able to help you.

      I do not want tto give out my email, I am sure you would not do so neither.

      Hope that helps, points welcome 😊


Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.