Profit Center wise Balance sheet by SQVI ,GRR1

[former_member229445]

Hi Knowledge ,

We have used the select query and generated the report for profit center balance sheet !

the performance is too low ,

is their any possibility from the SQVI and GRR1 tool to get the desire Results .

Requirements:

GL account Long Text Location 1 Location 2 Location 3 Total .

we were very by using SQVI ----But we need the report from report painter .

How to go with the GRR1 -- to achieve the desirable results .

Thanks

[iklovski]

Hi,

If you are working with NewGL, then you have standard report by profit centre. Even if you work with some other NewGL totals table, you can build your own report via FGI0. If you work with classical G/L, then you balance sheet by profit centre could be extracted only from EC-PCA module and there also you have standard reports. So, you question is not quite clear... What is sure, though, that you shouldn't make such a report simply by SQVI; this transaction is not suitable for this.

Regards,

Eli

[former_member229445]

Hi All,

Logic for the /output

First we are passing Sys Date for valid from/To field in CEPC --

Passing the above out put to FAGLFLEXT/FAGLFLEXA == With account number , Year , HSL,HSLVT Fields .

How to join the tables in report painter for the above requirement .

We have copied the standard library 8A0

Thanks

Murali.V