topic Re: Function Module for GL account Open Balance on Posing/Document Date in Application Development and Automation Discussions

Function Module for GL account Open Balance on Posing/Document Date

Former Member — Sat, 03 Oct 2009 07:08:24 GMT

Hi,

Can any one tell me the function Module for GL account Open Balance on Posing/Document Date.

Thanks,

Ravi.

Re: Function Module for GL account Open Balance on Posing/Document Date

Former Member — Sat, 03 Oct 2009 07:33:18 GMT

Check " BAPI_GL_ACC_GET* " Function Modules.

Re: Function Module for GL account Open Balance on Posing/Document Date

Former Member — Sat, 03 Oct 2009 07:36:43 GMT

ravi,

you can use FMs or directly fetch from tables.

http://www.sdn.sap.com/irj/scn/advancedsearch;jsessionid=%28J2EE3414800%29ID0782851750DB00329402770374214840End?query=GLaccountOpen+Balance

Re: Function Module for GL account Open Balance on Posing/Document Date

Former Member — Sat, 03 Oct 2009 07:41:13 GMT

Hi Amith,

Thanks for your reply, i searched these function modules, these are giving the details based on the period but they are not giving on date wise. Can you give me the solution.

Thanks,

Ravi.

Re: Function Module for GL account Open Balance on Posing/Document Date

Former Member — Sat, 03 Oct 2009 07:46:42 GMT

Yes You are correct.I doubt if any FM are really exist which fetch data on date wise.You might have to compromise with Periodic values.Also,If you are ABAPer then you might copy this FM and create your own Z FM which fetch data w.r.t to date from relevant tables(not an easy but possible).

p.s. This is Amit

Re: Function Module for GL account Open Balance on Posing/Document Date

GauthamV — Sat, 03 Oct 2009 10:51:42 GMT

You can write a custom program using BSIS and BSAS tables to get

those details..

Re: Function Module for GL account Open Balance on Posing/Document Date

Former Member — Sat, 03 Oct 2009 10:58:22 GMT

search for bapi .

u will get bapi for open or clearing accnts

Re: Function Module for GL account Open Balance on Posing/Document Date

Former Member — Sat, 03 Oct 2009 11:16:53 GMT

Hello

U need to create u own Z function module using BSIS and BSAS I think there in no other way to get data date-wise .

Regards

Nilesh.

Re: Function Module for GL account Open Balance on Posing/Document Date

Clemenss — Sat, 03 Oct 2009 16:25:52 GMT

Hi Ravi,

chose from those function modules


1028                           Business Object General Ledger
BAPI_GL_GETGLACCBALANCE        Closing balance of G/L account for chosen year
BAPI_GL_GETGLACCCURRENTBALANCE Closing balance of G/L account for current year
BAPI_GL_GETGLACCPERIODBALANCES Posting period balances for each G/L account

3006                           Business Objekt General Ledger Account
BAPI_GL_ACC_EXISTENCECHECK     Check existence of G/L account
BAPI_GL_ACC_GETBALANCE         Closing balance of G/L account for chosen year
BAPI_GL_ACC_GETCURRENTBALANCE  Closing balance of G/L account for current year
BAPI_GL_ACC_GETLIST            List of G/L accounts for each company code
BAPI_GL_ACC_GETPERIODBALANCES  Posting period balances for each G/L account

3006_HRO                       Business object G/L account
BAPI_GL_ACC_GETDETAIL          G/L account details

If you want to select directly from database tables, you may have to regard if New Generla Ledger (FAGLFLEX) is active.

Regards,

Clemens