on 04-18-2015 2:24 PM
Dear all,
I need to design the standard R3 report T code: S_ALR_87012284 financial statements in SAP BW in a bit customized way.
I am bit confused about which base tables are being used in the report . Would any body suggest on this ?
Also this standard report, isnt it a cumulative one? that is it always shows total of all reporting fiscals?
Are the reporting fiscals = 16 in this report.
Requirement is to design the report for each fiscal period.
I have used 0fi_gl_1 extractor but I am not able to get the desired result. i thought base table should be GLT0.
Please suggest.
Thanks !
Hi,
Your report is balance sheet P/L report.
Go to your Tx -S_ALR_87012284 At ecc side, menu system-->status-->program. Double click on it or copy program name and open thru SE38. in program code you may see the base tables.
Coming to bw side, Data source 0FI_GL_6.
to know the more information about financial statements please check wtih FI team or FI forum here.
Thanks
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Above two data sources pulls data from same table(GLT0). You already checked data thru 0fi_gl_1 which is not fulfilled your needs. so check 0fi_gl_6 and check the data extraction at RSA3.
that may give some idea about required fields/data.
Even there is a best pdf with explanation about balance sheet p& l report.
find it from Google and explore it.
use Google search key as "Handling Balance Sheets and P&L Statements in SAP BW".
Hello,
Thanks Raman.
Please check whether you are going to use the base table as GLT0 or FAGLFLEXA. If you are using the new GL in your ECC you should be using FAGLFLEXA should be base table. In that case 0FI_GL_10 will give you the desired result.
Now if your base table is GLT0 the 0FI_GL_1 should give you the correct value. Please check GL wise where the inconsistency is. you may also check 0FI_GL_4 which will give you document wise data which will be easy for reconciliation
Regards
Gajesh
Thanks Raman.
The appropriate DataSource depends on whether you are using Classic G/L or New G/L.
Classic G/L:
I suggest to use DataSource 0FI_GL_6 (which replaces 0FI_GL_1 and is delta-enabled). The base table is GLT0.
New G/L:
I suggest to use DataSource 0FI_GL_10. The base table is FAGLFLEXT.
Best regards,
Sander
Hi,
SAP R/3 report for Financial Profitability Statements can be Prepared on Virtual Info cube inside BW system.this report is giving you information about total income ,total expenditure, total profit/loss,investment,sales incomes etc...
BW Objects:
The cube name -
0FIGL_V10 : Virtual info cube- G/L (New): Balance Sheet and Profit and Loss
To get the data in virtual info cube you have to activate and load another
info cube :
0FIGL_C10 - General Ledger (New): Transaction Figures
Data source Name: 0FI_GL_10- General Ledger: Leading Ledger Balances.
ECC:
you can use the T-Code as you mentioned or Also you can use - F.01 to see the finance statements./Also OB58.
Reporting periods - you can select from 1 to 12 or 1 to 16. Because 4 special periods are there in one assessment Year. Also you have to fill financial statement version compulsorily.
Go through this link: you can get information about base tables:
https://scn.sap.com/thread/1430818
any queries ,please share.
Thanks
Ashish
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
Reports of that kind (financial statement) should be created on 0figl_v10 (or sth like this).
Be aware that time restricting is abit different than in standard infocubes. You should rather point at one fiscal period than restrict to range of values.
Regards,
Leszek
0FIGL_V10 works in connection with 0figl_c10(0FI_GL_10) <== mentioned about this data source.
Message was edited by: Lesław Piwowarski
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Any suggestions please Experts ?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
101 | |
13 | |
13 | |
11 | |
11 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.