Issue in Special Purpose Ledger

[Former Member]

Hi,

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.

Regards,

Dharani.

[former_member581986]

Hi,

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

Csaba

[Former Member]

Dear Csaba,

Thanks for the reply.

Regarding the zero balances, Please let me know where the report options available. Is there any t.code where this option is already set. Pls revert me on this.

And we have check the given report [RFBILA00] and flaged the "Accounts with zero balance". Hence we got the all the accounts with zero balance. Pls let me know how this is linked to FI-SL. Is there any specific settings needs to be done.

Regarding TSL, we had already added TSL column in summary table. Even we are getting foreing currency values in the summary table. And when we execue the query thru SQ01, it is not picking foreign currency balances. Nowhere we had resticted the curreny. Hence pls let us know where it is wrong??

Please reply us at the earliest as we are struggling for quiet long time. Pls do the needful asap.

Thanks,

Dharani.P

[former_member581986]

Hi,

I rally think you mix up things.

FI-SL reporting based on Report Painter / Report Writer is one thing. Here you can set filters when in the list already. Menu path: Edit --> Threshold value (Ctrl-F5) Note this is ECC 6.0 (in earlier releases, it could be slightly different, but basically the same). This menu item may not be available, if you are not using Expert mode (to switch use menu Settings --> Options Ctrl-Shift-F12) from the list. So, once you have the Threshold value option available, put the cursor on the column header and execute the Threshold value function. Use the online help on how to use it, it is quite straightforward anyway.

RFBILA00 is another thing. This is a pure FI-GL report which is not connected to FI-SL at all. If the "Accounts with zero balance" checkbox is set, ALL master data are selected and displayed, regardless if there were any postings / balances on those accounts or not. This option is NOT available with Report Painter/Report Writer based reports that are commonly used in FI-SL. Report Painter/Writer will only rad your summary table and if there is no any database record for a particular account (because it was not posted at all in the given fiscal year), you will NOT be able to display that G/L for the given fiscal year. As an alternative, you could chck out report RFBILA10, which is similar to RFBILA00 (especially, it can offer the option "Accounts with zero balance"), but working on the FI-SL database. If you have only 1 ledger to report on, you can use it. In case of multiple ledgers, RFBILA10 is not a big help, as it can report on a single ldger only.

Finally, SQ01 is a query, which is a third reporting tool. I have no idea how your infoset (SQ02) behind your query is so it is impossible to advise here.

For the further support, it would be very helpful if you would describe where the data are (FI-SL, FI-GL ??) and what tool you want to use for reporting, and what is the exact issue. Otherwise I cannot help, and I am afraid, nobody else can.

Hope that helps, points welcome

Csaba

[Former Member]

Dear Csaba,

Thanks for the detailed explanation.

There is some communication gap. Hence actual need is not satisfied still.

Actually we are generating Region-wise, Functional Area-wise Cost Center Report. All this will be based on the cost center and the cost center is designed like this [SZZ000SL00 means S for South, and SL stands for sales]. Hence we got both Region and Functional area from the cost center.

We had generated Summary table with fields [ GL account number, Fiscal Period, Region & Functional Area]. So with the Report Painter/Writer, we were not able to generate Region-wise, Functional Area-wise Cost Center Report. So we had gone to the other option called Query.

ISSUE: Though the table has the foreign currency values, query report is not picking those balances.

1. Summary table is picking the foreign currency values.

2. But when I execute the query, system is taking only INR figures. It is not considering other currency’s. Please suggest us.

P.S:Unable to send the attachment,can u please give us ur id so that we can directly send our requirement.

[former_member581986]

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

Csaba