GL Accounts

[Former Member]

Hi all,

i want to extract all the GL A/C balances to the BW i have found few datasources but i am not able to find which one will give me the accumulated balance like i want the GL account Cash -

---

Balance but not the transactions like debit r credit

i just want at the end of the day balance of that account so that i can do some calculations in the report

thanks and regards

neelu

[Former Member · Accepted solution]

hello neel,

as far as i remember, i have used fi_gl_10 for balance sheet query.

here i there is a virtual cube 0figl_v10 taking data from basic cube 0figl_c10 which in turn is connected to ods 0figl_o10.

sorry as i dont have the system right now, can think of this at the moment.

thanks,

[Former Member · Accepted solution]

Hi

Can somebody kindly give some more info about the datasources available which will give me the balance of each GL account.As i don't want the postings but only the final balance of that GL account.

thanks

neelu

[edwin_harpino · Accepted solution]

hi Neel,

check if helps

http://help.sap.com/saphelp_nw04/helpdata/en/57/dd153c4eb5d82ce10000000a114084/frameset.htm

expand datasources, also check the 'new gl' node

http://help.sap.com/saphelp_nw04/helpdata/en/e2/f16940c3c7bf49e10000000a1550b0/frameset.htm

hope this helps.

[Former Member]

HI Neel

Check the data soure : 0FI_GL_1,it will help you in your requirement...

bye

Shu Moh.

[Former Member]

Hi All,

so if i am using Ecc 5.0 then i need to use 0fi_gl_10 becoz this is used for new general ledger accounting

r else i can use 0fi_gl_6

to get the accumulated balance of Gl accounts

am i right

I HAVE TRIED TO REWARD THE ANSWERS BUT ITS SAYS THREAD IS LOCKED FOR REWARDING.

thanks and regards

neelu

[Former Member]

Hi ,

following link may help u .

http://help.sap.com/saphelp_47x200/helpdata/en/56/df293581dc1f79e10000009b38f889/frameset.htm

Regards,

Aparna