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

[Former Member]

Hi,

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

Thanks,

Ravi.

[Former Member]

Check " BAPI_GL_ACC_GET* " Function Modules.

[Former Member]

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.

[Former Member]

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

[Former Member]

ravi,

you can use FMs or directly fetch from tables.

http://www.sdn.sap.com/irj/scn/advancedsearch;jsessionid=%28J2EE3414800%29ID0782851750DB003294027703...accountOpen+Balance

[GauthamV]

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

those details..

[Former Member]

search for bapi .

u will get bapi for open or clearing accnts

[Former Member]

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.

[Clemenss]

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